Abstract
Object-relational mapping (ORM) technologies have been proposed as a solution for the impedance mismatch problem between object-oriented applications and relational databases. Existing approaches use special-purpose mapping languages or are tightly integrated with the programming language. In this paper, we present MAGIC, an approach using bidirectional query and update views, based on a generic metamodel and a generic mapping language. The mapping language is based on second-order tuple-generating dependencies and allows arbitrary restructuring between the application model and the database schema. Due to the genericity of our approach, the core part including mapping generation and mapping composition is independent of the modeling languages being employed. We show the formal basis of MAGIC and how queries including aggregation can be defined using an easy to use query API. The scalability of our approach is shown in the evaluation using the TPC benchmark.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Adya, A., Blakeley, J.A., Melnik, S., Muralidhar, S.: Anatomy of the ado.net entity framework. In: Proc. SIGMOD Beijing, China, pp. 877–888 (2007)
Bernstein, P.A., Halevy, A.Y., Pottinger, R.: A vision for management of complex models. SIGMOD Record 29(4), 55–63 (2000)
Castro, P., Melnik, S., Adya, A.: Ado.net entity framework: raising the level of abstraction in dataprogramming. In: Proc. SIGMOD, pp. 1070–1072 (2007)
Fagin, R.: Inverting schema mappings. ACM Transactions on Database Systems 32(4) (2007)
Fagin, R., Kolaitis, P.G., Popa, L., Tan, W.C.: Composing schema mappings: Second-order dependencies to the rescue. ACM Trans. Database Syst. 30(4), 994–1055 (2005)
Ireland, C., Bowers, D., Newton, M., Waugh, K.: A classification of object-relational impedance mismatch. In: Proc. DBKDA, pp. 36–43. IEEE, Los Alamitos (2009)
Keene, C.: Data services for next-generation soas. Web Services Journal 4(12) (2004)
Kensche, D., Quix, C., Chatti, M.A., Jarke, M.: GeRoMe: A generic role based metamodel for model management. Journal on Data Semantics VIII, 82–117 (2007)
Kensche, D., Quix, C., Li, X., Li, Y.: GeRoMeSuite: A system for holistic generic model management. In: Proc. VLDB, pp. 1322–1325 (2007)
Kensche, D., Quix, C., Li, X., Li, Y., Jarke, M.: Generic schema mappings for composition and query answering. Data Knowl. Eng. 68(7), 599–621 (2009)
Kiczales, G., Lamping, J., Mendhekar, A., Maeda, C., Lopes, C.V., Loingtier, J.-M., Irwin, J.: Aspect-oriented programming. In: Aksit, M., Matsuoka, S. (eds.) ECOOP 1997. LNCS, vol. 1241, pp. 220–242. Springer, Heidelberg (1997)
Meijer, E., Beckman, B., Bierman, G.: LINQ: Reconciling object, relations and XML in the .NET framework. In: Proc. SIGMOD, pp. 706–706 (2006)
Melnik, S., Adya, A., Bernstein, P.A.: Compiling mappings to bridge applications and databases. In: Proc. SIGMOD, Beijing, China, pp. 461–472 (2007)
Pottinger, R., Halevy, A.Y.: Minicon: A scalable algorithm for answering queries using views. VLDB Journal 10(2-3), 182–198 (2001)
Russell, C.: Bridging the object-relational divide. ACM Queue 6(3), 18–28 (2008)
Terwilliger, J.F., Bernstein, P.A., Melnik, S.: Full-fidelity flexible object-oriented xml access. Proc. VLDB Endow. 2(1), 1030–1041 (2009)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2010 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Kensche, D., Quix, C., Li, X., Geisler, S. (2010). Solving ORM by MAGIC:MApping GeneratIon and Composition. In: Dearle, A., Zicari, R.V. (eds) Objects and Databases. ICOODB 2010. Lecture Notes in Computer Science, vol 6348. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-16092-9_12
Download citation
DOI: https://doi.org/10.1007/978-3-642-16092-9_12
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-16091-2
Online ISBN: 978-3-642-16092-9
eBook Packages: Computer ScienceComputer Science (R0)