A new system architecture for flexible database conversion

  • Authors:
  • Siti Z. Z. Abidin;Suzana Ahmad;Wael M. S. Yafooz

  • Affiliations:
  • Faculty of Computer and Mathematical Sciences, University Technology MARA, Shah Alam, Selangor, Malaysia;Faculty of Computer and Mathematical Sciences, University Technology MARA, Shah Alam, Selangor, Malaysia;Faculty of Computer and Mathematical Sciences, University Technology MARA, Shah Alam, Selangor, Malaysia

  • Venue:
  • WSEAS Transactions on Computers
  • Year:
  • 2010

Quantified Score

Hi-index 0.00

Visualization

Abstract

Much research has been undertaken to work on database sharing, integration, conversion, merging and migration. In particular, database conversion has attracted researchers' attention due to the rapid change in the computer technology. There are also several tools available on the Web for free usage on handling database conversion. All of these works are focusing on the relational database which consists of an integrated collection of logically related records. Database plays an important role in an area of computing when there is a lot of data and information need to be stored and retrieved. Today, databases are used in many disciplines such as business, education, general administration, medicine and many more. Research in database works have been advanced from file management system to data warehousing with the discussion of how a database can be significantly sustainable and have the potential to be added and modified to suit the current situation and technology. In this paper, we propose a new method on doing database conversion by providing a single master database that can accept multiple databases of any type through the use of Java Database Connectivity (JDBC) and application program interface (API). The key contribution of this method is the ability to accept a single record, multiple records or the whole records of a database to be converted into any other database type. Thus, any existing form of database can be integrated and updated without the need to design new database system for coping with the new technology. In this way, the old or existing databases can be used for an unlimited lifetime and a broader scope of application domains.