The goal of model management is to develop a generic infrastructure that offers an order-of-magnitude productivity improvement to builders of model-driven applications, such as database tools, application design tools, message translators, and customizable commercial applications.
We have worked on both abstract operators that manipulate models and mappings and on practical applications of this technology. Abstract operators include the following:·
- Match – returns correspondences between elements of two given schemas
- Merge – returns an integration of two models based on a mapping
- Compose - returns the composition of two mappings
- ModelGen – translates a schema from one metamodel to another
Practical problems that we have worked on include the following
- Schema matcher – we developed the automated schema-matching algorithm in Microsoft’s BizTalk Mapper
- Object-to-relational mapping – we helped develop the mapping compiler for Microsoft’s ADO.NET Entity Framework
- Relational to object-oriented reverse engineering - we developed a tool that produces an Entity Data Model schema (with inheritance) from a SQL schema
We recently extended the Entity Framework schema-mapping compiler to perform incremental compilation, which will appear at SIGMOD 2013.
- Philip A. Bernstein, Jayant Madhavan, and Erhard Rahm, Generic Schema Matching, Ten Years Later, in PVLDB, vol. 4, no. 11, pp. 695-701, 2011
- Ankit Malpani, Philip A. Bernstein, Sergey Melnik, and James F. Terwilliger, Reverse Engineering Models from Databases to Bootstrap Application Development, International Conference on Data Engineering, 2010
- James F. Terwilliger, Philip A. Bernstein, and Adi Unnithan, Worry-Free Database Upgrades: Automated Model-Driven Evolution of Schemas and Complex Mappings, ACM SIGMOD, 2010
- James F. Terwilliger, Philip A. Bernstein, and Adi Unnithan, Automated Co-evoluation of Conceptual Models, Physical Databases, and Mapings, in Conceptual Modeling -- ER 2010, Springer, 2010
- Arnab Nandi and Philip A. Bernstein, HAMSTER: Using Search Clicklogs for Schema and Taxonomy Matching, in Proceedings of VLDB 2009, Very Large Data Bases Endowment Inc., August 2009
- Sergey Melnik, Atul Adya, and Philip A. Bernstein, Compiling mappings to bridge applications and databases, in ACM Trans. Database Syst., vol. 33, no. 4, 2008
- James F. Terwilliger, Sergey Melnik, and Philip A. Bernstein, Language-integrated querying of XML data in SQL server, in PVLDB, vol. 1, no. 2, pp. 1396-1399, 2008
- Paolo Atzeni, Paolo Cappellari, Riccardo Torlone, Philip A. Bernstein, and Giorgio Gianforme, Model-independent schema translation, in VLDB J., vol. 17, no. 6, pp. 1347-1370, 2008
- Rachel Pottinger and Philip A. Bernstein, Merging Models Based on Given Correspondences, in VLDB, 2003
- Philip A. Bernstein, Applying Model Management to Classical Meta Data Problems, in CIDR, 2003
- Erhard Rahm and Philip A. Bernstein, A survey of approaches to automatic schema matching, in VLDB J., vol. 10, no. 4, pp. 334-350, 2001
Past Contributors: Sergey Melnik, Suad Alagic, Paolo Atzeni, Alon Halevy, Renee Miller, Christine Parent, Christoph Quix, Lemonia Ragia, Erhard Rahm, Guillem Rull, Vadim Savenkov, Stefano Spaccapietra, Adi Unnithan.
Past Interns: Paolo Cappellari, Ivo Garcia dos Santos, Todd J. Green, Marie Jacob, Yannis Katsis, Jayant Madhavan, Ankit Malpani, Peter Mork, Arnab Nandi, Alan Nash, Nicola Onose, Jorge Perez, Michalis Petropoulos, Rachel Pottinger, and Soujanya Vadapalli.