Reengineering relational databases to object-oriented: constructing the class hierarchy and migrating the data

Alhajj, Reda; Polat, Faruk

doi:10.1109/wcre.2001.957840

Cited by 11 publications

(8 citation statements)

References 17 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Alhajj and Polat re-engineered an RDB into an OODB using an expert user and the data dictionary as primary sources of information [3]. Since an RDB does not enable a natural way of representing inheritances, several heuristic and algorithmic methods have been proposed to elicit inheritance relationships hidden in RDBs [20,4].…”

Section: Database Reverse Engineering (Dbre)mentioning

confidence: 99%

“…To enrich a source RDB structurally and semantically, graphs and models are proposed as an intermediate stage [1,13,14,2,23]. A graph called an RID, developed by Alhajj [2], has been used to translate an RDB into an OODB [3] or into an XML [46]. This graph, similar to an ER diagram is used for identifying relationships and cardinalities.…”

Section: Conceptual Models Usedmentioning

confidence: 99%

“…Some proposals for migrating RDBs into XML use data dictionaries and assume well-designed RDB [14,3,18] whereas others consider legacy RDB for migration into XML documents [46]. Besides, the resulting XML schemas might be a DTD [18], XML Schema [46] or independent XML language [13].…”

Section: Migrating Rdb Into Xmlmentioning

confidence: 99%

See 2 more Smart Citations

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

Section: Database Reverse Engineering (Dbre)mentioning

confidence: 99%

Section: Conceptual Models Usedmentioning

confidence: 99%

See 1 more Smart Citation

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

show abstract

“…By the use of this approach a large database can be easily distributed on the different machines. Alhajj et al [9] have described the objectoriented data model from the relational database model which converts the structured database into the object-oriented database. Fraser [10] has presented a approach for finding the length of the test cases generated from the software code.…”

Section: Introductionmentioning

confidence: 99%

A Validation Technique for UML Activity Model

Singh¹,

Zaidi²,

Saxena³

2015

IJCA

View full text Add to dashboard Cite

In the current scenario of modeling, object-oriented modeling has completely replaced the structured modeling approach. Software industries are slowly-slowly shifting their old structured based softwares into the object-oriented based softwares, for e.g. Foxpro has been changed into the Visual Foxpro. From the literature, it is observed that various researchers are proposing the software models based on the object-oriented technology. It is a big challenge whether the proposed design is correct or reliable for a long time. For solution of this problem, the present work deals with a proposal of Unified Modeling Language (UML) model for a real case study of Mobile Bill Deposit System (MBDS) By the use of UML, class and activity models are designed for static and dynamic representation of the problem. For validation purpose the activity model is validated by the use of Finite State Machine (FSM) technique and results are presented in the form of test cases. When the size of the model becomes complex then presented technique shall help for validation of the complex model.

show abstract

“…The dominance of traditional RDB and its limitation to support the benefits provided by these new technologies motivate its migration into Object-Oriented DataBase (OODB), Object-Relational DataBase (ORDB) and XML [1,2,11,12]. This paper aims to provide an investigation into the problem of DataBase Migration (DBM), to review various techniques and proposals, to identify their differences, and to assess the impact of existing literature and how it shapes current and future research in this area.…”

Section: Introductionmentioning

confidence: 99%

Relational Database Migration: A Perspective

Maatuk

Ali

Rossiter

Lecture Notes in Computer Science

View full text Add to dashboard Cite

Abstract. This paper presents an investigation into approaches and techniques used for database conversion. Constructing object views on top of a Relational DataBase (RDB), simple database integration and database migration are among these approaches. We present a categorisation of selected works proposed in the literature and translation techniques used for the problem of database conversion, concentrating on migrating an RDB as source into object-based and XML databases as targets. Database migration from the source into each of the targets is discussed in detail including semantic enrichment, schema translation and data conversion. Based on a detailed analysis of the existing literature, we conclude that an existing RDB can be migrated into object-based/XML databases according to available database standards. We propose an integrated method for migrating an RDB into object-based/XML databases using an intermediate Canonical Data Model (CDM), which enriches the source database's semantics and captures characteristics of the target databases. A prototype has been implemented, which successfully translates CDM into object-oriented (ODMG 3.0 ODL), object-relational (Oracle 10g) and XML schemas.

show abstract

Reengineering relational databases to object-oriented: constructing the class hierarchy and migrating the data

Cited by 11 publications

References 17 publications

Re-engineering relational databases

Re-engineering relational databases

A Validation Technique for UML Activity Model

Relational Database Migration: A Perspective

Contact Info

Product

Resources

About