Converting relational to object-oriented databases

Fong, Joseph

doi:10.1145/248603.248614

Cited by 31 publications

(20 citation statements)

References 8 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Because of its mathematical basic, Relational database systems refer to the relationships between the tables (Fong, 1997). Jones and Monk (1997) state that Relational databases include various instructions which express the database components.…”

Section: B Rational Approachmentioning

confidence: 99%

“…Therefore, the user gets the opportunity to create a built-in data type, dynamic data type, from the existing data types inside any database. Because of its properties, Fong (1997) stat that in cases of saving data and assessing the pre-implemented database, Object Oriented approach is more suitable than other approaches. In addition, applications designed by this approach has a high level of security due to its hidden properties and methods which are built to be unseen by the user (Fong, 1997).…”

Section: A Logical Design Of Databasesmentioning

confidence: 99%

See 1 more Smart Citation

Object-oriented and relational approaches in database management systems (dbmss): design, implementation and industrial markets

2017

IJLTET

View full text Add to dashboard Cite

Section: B Rational Approachmentioning

confidence: 99%

Section: A Logical Design Of Databasesmentioning

confidence: 99%

Object-oriented and relational approaches in database management systems (dbmss): design, implementation and industrial markets

2017

IJLTET

View full text Add to dashboard Cite

“…However this approach can be used just to convert relational to object oriented. This prototype is compared with other translation schemes [21], [23], [24].…”

Section: Literature Surveymentioning

confidence: 99%

Automatic Translation of Heterogeneous Data Models

Naz¹,

Majeed²,

Qayyum³

2012

IJCCE

View full text Add to dashboard Cite

Abstract-Schema translation is the process of transforming schemas in heterogeneous data models into a single target data model. Today there exist various data models to save useful data. The need of schema translation rises due to the existence of wide range of prominent, heterogeneous database applications. Due to the increasing requirement of interoperability of autonomous databases, multi database system which consists of homogenous or heterogeneous databases are required to work in a cooperative environment. In heterogeneous multi database system, the translation of one data model to another data model is critical. In this paper, we present a data model translation between heterogeneous models. Our approach translates the schema and data of one model to the target schema and data. We use the concept of metadictionary to achieve translation. We use XML as the standard to perform core translation. Our approach can adopt new upcoming models and can change them to old models easily.Index Terms-Data models, data translation, meta model, heterogeneous model.

show abstract

“…Data stored as tuples in an RDB are converted into complex objects/literals in object-based databases or elements in XML documents. This involves extracting and restructuring RDB data, and then reloading the converted data into a target database in order to populate the schema generated earlier during the schema translation process [22].…”

Section: Database Re-engineeringmentioning

confidence: 99%

“…Flat technique: This technique converts each relation into an object class/XML element in the target database [39,22,46]. Foreign keys are mapped into references to connect objects.…”

Section: Source-to-target (S2t) Techniquementioning

confidence: 99%

Re-engineering relational databases

Maatuk

Ali

Rossiter

2011

Proceedings of the 2011 International Conference on Intelligent Semantic Web-Services and Applications

View full text Add to dashboard Cite

This paper surveys the recent literature about various research trends relevant to Relational DataBase (RDB) reengineering. The paper presents an analysis of approaches and techniques used in this context, including construction of object views on top of RDBs, database integration and database migration. A categorisation is presented of the selected work, concentrating on migrating an RDB as a source into object-based and XML databases as targets. Database migration from the source into each of the targets is discussed and critically evaluated, including the semantic enrichment, schema translation and data conversion. Based on a detailed analysis of the existing literature, it seems that the existing work does not provide a complete solution for more than one target database for either schema or data conversion. Besides, none of the existing proposals can be considered as a method for migrating an RDB into an objectrelational database. We propose such a method based on an intermediate canonical data model, which enriches the semantics of the source RDB and captures characteristics of the target databases.

show abstract

Converting relational to object-oriented databases

Cited by 31 publications

References 8 publications

Object-oriented and relational approaches in database management systems (dbmss): design, implementation and industrial markets

Object-oriented and relational approaches in database management systems (dbmss): design, implementation and industrial markets

Automatic Translation of Heterogeneous Data Models

Re-engineering relational databases

Contact Info

Product

Resources

About