Relative information capacity of simple relational database schemata
SIAM Journal on Computing
Semantic database modeling: survey, applications, and research issues
ACM Computing Surveys (CSUR)
Persistence software: bridging object-oriented programming and relational databases
SIGMOD '93 Proceedings of the 1993 ACM SIGMOD international conference on Management of data
Tools and transformations—rigorous and otherwise—for practical database design
ACM Transactions on Database Systems (TODS)
Specification preservation in schema transformations—application to semantics and statistics
Data & Knowledge Engineering
A general formal framework for schema transformation
Data & Knowledge Engineering - Special issue on ER '97
EXPRESS: a data EXtraction, Processing, and Restructuring System
ACM Transactions on Database Systems (TODS)
Multivalued dependencies and a new normal form for relational databases
ACM Transactions on Database Systems (TODS)
Management of Multiple Models in an Extensible Database Design Tool
EDBT '96 Proceedings of the 5th International Conference on Extending Database Technology: Advances in Database Technology
Understanding Implementations of IS-A Relations
ER '96 Proceedings of the 15th International Conference on Conceptual Modeling
M(DM): An Open Framework for Interoperation of Multimodel Multidatabase Systems
Proceedings of the Eighth International Conference on Data Engineering
Gangam: A Transformation Modeling Framework
DASFAA '03 Proceedings of the Eighth International Conference on Database Systems for Advanced Applications
Interactive schema translation with instance-level mappings
VLDB '05 Proceedings of the 31st international conference on Very large data bases
Composing schema mappings: Second-order dependencies to the rescue
ACM Transactions on Database Systems (TODS) - Special Issue: SIGMOD/PODS 2004
Heterogeneous data translation through XML conversion
Journal of Web Engineering
Model-Independent schema and data translation
EDBT'06 Proceedings of the 10th international conference on Advances in Database Technology
Comparing and transforming between data models via an intermediate hypergraph data model
Journal on Data Semantics IV
GeRoMe: a generic role based metamodel for model management
OTM'05 Proceedings of the 2005 OTM Confederated international conference on On the Move to Meaningful Internet Systems: CoopIS, COA, and ODBASE - Volume Part II
The transformational approach to database engineering
GTTSE'05 Proceedings of the 2005 international conference on Generative and Transformational Techniques in Software Engineering
The ADO.NET entity framework: making the conceptual level real
ER'06 Proceedings of the 25th international conference on Conceptual Modeling
A Generic Data Level Implementation of ModelGen
BNCOD '08 Proceedings of the 25th British national conference on Databases: Sharing Data, Information and Knowledge
Model---Driven, View---Based Evolution of Relational Databases
DEXA '08 Proceedings of the 19th international conference on Database and Expert Systems Applications
Model-independent schema translation
The VLDB Journal — The International Journal on Very Large Data Bases
A runtime approach to model-independent schema and data translation
Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology
Schema exchange: Generic mappings for transforming data and metadata
Data & Knowledge Engineering
A runtime approach to model-generic translation of schema and data
Information Systems
Polymorphism in datalog and inheritance in a metamodel
FoIKS'10 Proceedings of the 6th international conference on Foundations of Information and Knowledge Systems
Representing uniqueness constraints in object-relational mapping
TOOLS'12 Proceedings of the 50th international conference on Objects, Models, Components, Patterns
| Hi-index | 0.00 |
This paper describes a rule-based algorithm to derive a relational schema from an extended entity-relationship model. Our work is based on an approach by Atzeni and Torlone in which the source EER model is imported into a universal metamodel, a series of transformations are performed to eliminate constructs not appearing in the relational metamodel, and the result is exported. Our algorithm includes novel features that are needed for practical object to relational mapping systems: First, it generates forward-and reverse-views that transform instances of the source model into instances of the target and back again. These views automate the object-to-relational (O/R) mapping. Second, it supports a flexible mapping of inheritance hierarchies to flat relations that subsumes and extends prior approaches. Third, it propagates incremental updates of the source model into incremental updates of the target. We prove the algorithm's correctness and demonstrate its practicality in an implementation.