Identifying Extended Entity-Relationship Object Structures in Relational Schemas
IEEE Transactions on Software Engineering
Conceptual database design: an Entity-relationship approach
Conceptual database design: an Entity-relationship approach
Reverse engineering of relational databases: extraction of an EER model from a relational database
Data & Knowledge Engineering
The logic of knowledge bases
Foundations of Databases: The Logical Level
Foundations of Databases: The Logical Level
Fundamentals of Database Systems
Fundamentals of Database Systems
A Method for Transforming Relational Schemas Into Conceptual Schemas
Proceedings of the Tenth International Conference on Data Engineering
Schema Mapping as Query Discovery
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
The Use of Information Capacity in Schema Integration and Translation
VLDB '93 Proceedings of the 19th International Conference on Very Large Data Bases
Extracting an Entity Relationship Schema from a Relational Database through Reverse Engineering
ER '94 Proceedings of the13th International Conference on the Entity-Relationship Approach
A survey of approaches to automatic schema matching
The VLDB Journal — The International Journal on Very Large Data Bases
The description logic handbook
HePToX: marrying XML and heterogeneity in your P2P databases
VLDB '05 Proceedings of the 31st international conference on Very large data bases
Bringing Relational Data into the SemanticWeb using SPARQL and Relational.OWL
ICDEW '06 Proceedings of the 22nd International Conference on Data Engineering Workshops
Reasoning on UML class diagrams
Artificial Intelligence
Discovering and using semantics for database schemas
Discovering and using semantics for database schemas
DL-Lite: tractable description logics for ontologies
AAAI'05 Proceedings of the 20th national conference on Artificial intelligence - Volume 2
Identification constraints and functional dependencies in description logics
IJCAI'01 Proceedings of the 17th international joint conference on Artificial intelligence - Volume 1
A survey of schema-based matching approaches
Journal on Data Semantics IV
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
Translating relational & object-relational database models into OWL models
IRI'09 Proceedings of the 10th IEEE international conference on Information Reuse & Integration
Hi-index | 0.00 |
The rapid growth of available data arises the need for more sophisticated techniques for semantic access to information. It has been proved that using conceptual model or ontology over relational data sources is necessary to overcome many problems related with accessing the structured data. However, the task of wrapping the data residing in a database by means of an ontology is mainly done manually. The research we are carrying out studies the reuse of relational sources in the context of semantics-based access to information. This problem is tackled in two phases: (i) extracting semantics hidden in the relational sources by wrapping them by means of an ontology, (ii) understanding the methodology for semantic extension of such ontologies. In this paper we focus on the first sub-problem and present an automatic procedure for extracting from a relational database schema its conceptual view. The semantic mapping between the database and its conceptualization is captured by associating views over the data source to elements of the extracted ontology. To represent the extracted conceptual model we use an ontology language, rather that a graphical notation, in order to provide precise formal semantics. Our approach uses heuristics based on ideas of standard relational schema design and normalization. Under this we formally prove that our technique preserves the semantics of constraints in the database. Therefore, there is no data loss, and the extracted model constitutes a faithful wrapper of the relational database.