A comparative analysis of methodologies for database schema integration
ACM Computing Surveys (CSUR)
Federated database systems for managing distributed, heterogeneous, and autonomous databases
ACM Computing Surveys (CSUR) - Special issue on heterogeneous databases
A nested-graph model for the representation and manipulation of complex objects
ACM Transactions on Information Systems (TOIS)
Schema equivalence in heterogeneous systems: bridging theory and practice
Information Systems - Special issue on extending database technology
A formalisation of semantic schema integration
Information Systems
A survey of structured and object-oriented software specification methods and techniques
ACM Computing Surveys (CSUR)
A general formal framework for schema transformation
Data & Knowledge Engineering - Special issue on ER '97
A formal approach to the definition and the design of conceptual schemata for databased systems
ACM Transactions on Database Systems (TODS)
Applying graph transformations to database re-engineering
Handbook of graph grammars and computing by graph transformation
Information modeling and relational databases: from conceptual analysis to logical design
Information modeling and relational databases: from conceptual analysis to logical design
Data-driven understanding and refinement of schema mappings
SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
Data integration: a theoretical perspective
Proceedings of the twenty-first ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Design theory for advanced datamodels
ADC '01 Proceedings of the 12th Australasian database conference
Relational Database Writings 1994-1997
Relational Database Writings 1994-1997
Entity-Relationship Modeling: Foundations of Database Technology
Entity-Relationship Modeling: Foundations of Database Technology
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
WOL: A Language for Database Transformations and Constraints
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Towards the Reverse Engineering of Denormalized Relational Databases
ICDE '96 Proceedings of the Twelfth International Conference on Data Engineering
Integrity Constraints in the Multi-paradigm Language PROGRES
TAGT'98 Selected papers from the 6th International Workshop on Theory and Application of Graph Transformations
A Uniform Approach to Inter-model Transformations
CAiSE '99 Proceedings of the 11th International Conference on Advanced Information Systems Engineering
Schema Evolution in Heterogeneous Database Architectures, A Schema Transformation Approach
CAiSE '02 Proceedings of the 14th International Conference on Advanced Information Systems Engineering
PROgrammed Graph REwriting System PROGRES
AGTIVE '99 Proceedings of the International Workshop on Applications of Graph Transformations with Industrial Relevance
Semantics of Database Transformations
Selected Papers from a Workshop on Semantics in Databases
Extracting an Entity Relationship Schema from a Relational Database through Reverse Engineering
ER '94 Proceedings of the13th International Conference on the Entity-Relationship Approach
Tutorial Introduction to Graph Transformation: A Software Engineering Perspective
ICGT '02 Proceedings of the First International Conference on Graph Transformation
Database Evolution: the DB-Main Approach
ER '94 Proceedings of the13th International Conference on the Entity-Relationship Approach
Reasoning about participation constraints and Chen's constraints
ADC '03 Proceedings of the 14th Australasian database conference - Volume 17
An Introduction to Database Systems
An Introduction to Database Systems
Temporal Data and the Relational Model
Temporal Data and the Relational Model
Mapping XML and Relational Schemas with Clio
ICDE '02 Proceedings of the 18th International Conference on Data Engineering
Model Management Through Graph Transformation
VLHCC '04 Proceedings of the 2004 IEEE Symposium on Visual Languages - Human Centric Computing
Transformation of Knowledge, Information and Data: Theory and Applications
Transformation of Knowledge, Information and Data: Theory and Applications
Database schema transformation optimisation techniques for the automed system
BNCOD'03 Proceedings of the 20th British national conference on Databases
A general approach to the generation of conceptual model transformations
CAiSE'05 Proceedings of the 17th international conference on Advanced Information Systems Engineering
A Generic Data Level Implementation of ModelGen
BNCOD '08 Proceedings of the 25th British national conference on Databases: Sharing Data, Information and Knowledge
Model-independent schema translation
The VLDB Journal — The International Journal on Very Large Data Bases
An object-oriented operation-based approach to translation between MOF metaschemas
Data & Knowledge Engineering
Temporal Constraints in Non-temporal Data Modelling Languages
ER '08 Proceedings of the 27th International Conference on Conceptual Modeling
Schema Merging Based on Semantic Mappings
BNCOD 26 Proceedings of the 26th British National Conference on Databases: Dataspace: The Final Frontier
Teaching a schema translator to produce O/R views
ER'07 Proceedings of the 26th international conference on Conceptual modeling
Hypergraph-based multidimensional data modeling towards on-demand business analysis
Proceedings of the 13th International Conference on Information Integration and Web-based Applications and Services
ICMT'12 Proceedings of the 5th international conference on Theory and Practice of Model Transformations
International Journal of Advanced Pervasive and Ubiquitous Computing
Hi-index | 0.00 |
Data integration is frequently performed between heterogeneous data sources, requiring that not only a schema, but also the data modelling language in which that schema is represented must be transformed between one data source and another. This paper describes an extension to the hypergraph data model (HDM), used in the AutoMed data integration approach, that allows constraint constructs found in static data modelling languages to be represented by a small set of primitive constraint operators in the HDM. In addition, a set of five equivalence preserving transformation rules are defined that operate over this extended HDM. These transformation rules are shown to allow a bidirectional mapping to be defined between equivalent relational, ER, UML and ORM schemas. The approach we propose provides a precise framework in which to compare data modelling languages, and precisely identifies what semantics of a particular domain one data model may express that another data model may not express. The approach also forms the platform for further work in automating the process of transforming between different data modelling languages. The use of the both-as-view approach to data integration means that a bidirectional association is produced between schemas in the data modelling language. Hence a further advantage of the approach is that composition of data mappings may be performed such that mapping two schemas to one common schema will produce a bidirectional mapping between the original two data sources.