Long Beach, CA, USA
Mar. 1, 2010 to Mar. 6, 2010
Ankit Malpani , Indian Institute of Technology Madras, India
Philip A. Bernstein , Microsoft Research, USA
Sergey Melnik , Google Inc., USA
James F. Terwilliger , Microsoft Research, USA
Object-relational mapping systems have become often-used tools to provide application access to relational databases. In a database-first development scenario, the onus is on the developer to construct a meaningful object layer for the application because shipping tools, as ORM tools only ship database reverse-engineering tools that generate objects with a trivial one-to-one mapping. We built a tool, EdmGen++, that combines pattern-finding rules from conceptual modelling literature with configurable conditions that increase the likelihood that found patterns are semantically relevant. EdmGen++ produces a conceptual model with inheritance in Microsoft's Entity Data Model, which Microsoft's Entity Framework uses to support an executable object-to-relational mapping. The execution time of EdmGen++ on customer databases is reasonable for design-time.
Ankit Malpani, Philip A. Bernstein, Sergey Melnik, James F. Terwilliger, "Reverse engineering models from databases to bootstrap application development", ICDE, 2010, 2013 IEEE 29th International Conference on Data Engineering (ICDE), 2013 IEEE 29th International Conference on Data Engineering (ICDE) 2010, pp. 1177-1180, doi:10.1109/ICDE.2010.5447776