Solving ORM by MAGIC: MApping GeneratIon and Composition

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.

[1]  José A. Blakeley,et al.  Anatomy of the ADO.NET entity framework , 2007, SIGMOD '07.

[2]  Satoshi Matsuoka,et al.  ECOOP'97 — Object-Oriented Programming , 1997, Lecture Notes in Computer Science.

[3]  Ronald Fagin,et al.  Composing schema mappings: second-order dependencies to the rescue , 2004, PODS '04.

[4]  Alon Y. Halevy,et al.  MiniCon: A scalable algorithm for answering queries using views , 2000, The VLDB Journal.

[5]  Craig Russell.  Bridging the Object-Relational Divide , 2008, ACM Queue.

[6]  Matthias Jarke,et al.  Generic schema mappings for composition and query answering , 2009, Data Knowl. Eng..

[7]  Kevin Waugh,et al.  A Classification of Object-Relational Impedance Mismatch , 2009, 2009 First International Confernce on Advances in Databases, Knowledge, and Data Applications.

[8]  Brian Beckman,et al.  LINQ: reconciling object, relations and XML in the .NET framework , 2006, SIGMOD Conference.

[9]  Pablo Castro,et al.  ADO.NET entity framework: raising the level of abstraction in data programming , 2007, SIGMOD '07.

[10]  Matthias Jarke,et al.  GeRoMe: A Generic Role Based Metamodel for Model Management , 2005, OTM Conferences.

[11]  Philip A. Bernstein,et al.  Compiling mappings to bridge applications and databases , 2007, SIGMOD '07.

[12]  Philip A. Bernstein,et al.  A vision for management of complex models , 2000, SGMD.

[13]  Philip A. Bernstein,et al.  Full-Fidelity Flexible Object-Oriented XML Access , 2009, Proc. VLDB Endow..

[14]  Cristina V. Lopes,et al.  Aspect-oriented programming , 1999, ECOOP Workshops.

[15]  Cristina V. Lopes,et al.  Aspect-oriented programming , 1999, ECOOP Workshops.

[16]  Ronald Fagin.  Inverting schema mappings , 2007 .

[17]  Yong Li,et al.  GeRoMeSuite: A System for Holistic Generic Model Management , 2007, VLDB.