International Journal of Computational Engineering Research||Vol, 03||Issue, 6|| www.ijceronline.com ||June ||2013|| Page 101 A Novel Approach for Converting Relational Database to an Object Oriented Database: Data Migration and Performanace Analysis Mr.R.S.Mawale 1 , Prof.A.V.Deorankar 2 , Prof. V. A. Kakde 3 1 M.Tech. Scholor, (CSE), Govt. College Of Engineering, Amravati, Maharashtra, India 2 Associate Professor, Dept. Of CSE, Govt. College Of Engineering, Amravati, Maharashtra, India 3 Assistant Professor, Dept. Of Information Technology, G.H Raisoni College Of Engg, Amravati, Maharashtra, India I. INTRODUCTION During the last two decades, Relational Database Management System (RDBM) has been established as the technology, handling databases up to terabytes. Relational DBMSs have been extremely successful in the market; however RDBMS lack the mechanisms to deal with complex structured data. Their tabular approach does not allow a suitable modeling of complex hierarchical objects. Most of the applications such as Geographical Information System, CAD, Multimedia, and Engineering etc. are characterized by having to manage complex, highly interrelated information, which was difficult to manage in RDBMS. To combat the limitations of RDBMS and meet the challenge of the increasing rise of the internet and the Web, programmers developed object-oriented databases in 1980 [7]. In recent years, database research has concentrated on object-oriented data models, which allow to store highly structured data. With regard to the data structuring concepts offered, an object-oriented data model can be looked upon as an extension of the nested relational model, [5] which allows to store relations as attribute values. However, the relational model only permits the alphanumeric data management. II. OVERVIEW OF OODBMS An OODBMS is the result of combining object oriented programming principles with database management principles. Object oriented programming concepts such as encapsulation, polymorphism and inheritance are enforced along with regular database management concepts such as the Atomicity, Consistency, Isolation and Durability (ACID properties) which lead to system integrity, support for an ad hoc query language and secondary storage management systems which allow for managing very large amounts of data.. OODB [6] is a system while supporting all the functionality of a relational database system (including queries, transactions, backup and recovery mechanisms), also offers an Object oriented programming language interface, user defined data types, object identifiers and the ability to manage objects persistently. Features that are common in the RDBMS world such as transactions, the ability to handle large amounts of data, indexes, deadlock detection, backup and restoration features and data recovery mechanisms also exist in the OODBMS world. ABSTRACT The object-oriented data model is predicted to be the heart of the next generation of database systems. Users want to move from old legacy databases into applying this new technology that provides extensibility and exibility in maintenance. However, a major limitation on the wide acceptance of object-oriented databases is the amount of time and money invested on existing database applications, which are based on conventional legacy systems. Users do not want to lose the huge amounts of data present in conventional databases. This paper presents a novel approach to transform a given conventional database into an object-oriented database. It is assumed that the necessary characteristics of the conventional database to be re-engineered are known and available. The source of these characteristics might be the data dictionary and/or an expert in the given conventional database. We implemented a system that builds an understanding of a given conventional database by taking these characteristics as input and produces the corresponding object-oriented database as output. Finally, we handle the migration of data from the conventional database to the constructed object-oriented database. KEYWORDS: algorithms, data migration, forward engineering, object-oriented databases, reengineering of legacy databases, relational databases.