Towards flexible database conversion with automatic restructuring
Pages 314 - 319
Abstract
A database is an integrated collection of logically related records. It 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 on several issues such as database sharing, integration, conversion, access and integrity. 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.
References
[1]
Fred R. McFadden, Jeffrey A. Hoffer, Modern database management, Oracle Edition, Prentice Hall, 1999.
[2]
Maydene Fisher, Jon Ellis and Jonathan Bruce, JDBC API tutorial and reference, Sun Microsystems, 2003.
[3]
Richard D. Hackathorn, Enterprise Database Connectivity, Wiley professional computing, 1993.
[4]
JDBC Architecture, developersbook, http:// www.developersbook.com/jdbc/interviewquestions/jdbc-interview-questionsfaqs.php, 2007
[5]
Full Convert Enterprise, spectralcore, http://www.spectralcore.com/fullconver/, 2010.
[6]
Data Sync, spectralcore, http://www.spectral core. com/datasync, 2010.
[7]
swissql-data migration tool 5.7, SwisSQL, http://www.swissql.com/products/datamigratio n/data-migration.html, 2010.
[8]
Database converter, Sanmaxi, http:// www.database-converter.com, 2009.
[9]
Database Conversion Tool, Pro Data Doctor, http://www.prodata doctor.com, 2009.
[10]
Fred R. Mcafadden, Jeffrey A. Hoffer, Database Management, Benjamin/Cumming Publish Company, 1985.
[11]
S. Sumathi. S. Esakkirajan, Fundamental of Relational Database Management System, Springer, 2007.
[12]
RL Worrender, Database, crucial, 2003.
[13]
Dbmaker, http://www.dbmaker.com.tw/referenc e/manuals/tutorial/tutorial_03.html, 2002.
[14]
Rao, B.R. Object-Oriented Databases: Technology, Applications, and Products, McGraw-Hill. New York, 1994.
[15]
Suzanne W. Dietrich, Susan D. Urban and Ion Kyriakides, JDBC Demonstration CoursewareUsing Servlets and Java Server Pages, ACM New York, NY, USA, 2002.
[16]
Paul W.P.J. Grefen and Peter M.G. Apers, Integrity control in relational database system, Elsevier Science Publishers B. V. Amsterdam, the Netherlands, the Netherlands, 1993.
[17]
Can Turker, Michael Gertz, Semantic Integrity Support in SQL-99 and Commercial (Object-) Relational Database Management Systems, Springer-Verlag New York, Inc. Secaucus, NJ, USA, 2001.
[18]
Michael Blaha, Referential Integrity Is Important For Databases, Modelsoft Consulting Corp, 2005.
[19]
Yusuke Yoshida, Masayoshi Aritsugi and Yoshinari Kanamori, Performance Evaluation of Combining Data Migration and Method Migration in Object Database Environments, Australian Computer Society, Inc, Darlinghurst, Australia, 2002.
[20]
Andreas Meier, Providing Database Migration Tools, Morgan Kaufmann Publishers Inc. San Francisco, CA, USA, 1995.
[21]
Chang-Yang Lin, Migrating to Relational Systems: Problems, Methods, and Strategies, Contemporary Management Research, 2008.
[22]
Joseph Fong, Converting Relational to Object-Oriented Databases, ACM New York, NY, USA, 1997.
[23]
Christine Parent and Stefano Spaccapietra, Issues and Approaches of Database Integration, ACM New York, NY, USA, 1998.
[24]
Kei-Hoi Cheung, Andrew K. Smith, Kevin Y.L. Yip, Christopher J.O. Baker and Mark B. Gerstein, Semantic Web Approach To Database Integration In The Life Sciences, Elsevier Science Publishers B. V. Amsterdam, the Netherlands, 2006.
[25]
Anne Le Calvé and Jacques Savoy, Database Merging Strategy Based On Logistic Regression, Pergamon Press, Inc. Tarrytown, NY, USA, 2000.
[26]
H. Daniel Wagner, Tombstone Identification through Database Merging, Avotaynu, vol. XXIV, Spring 2008.
[27]
DatabasSpy, Altova, http://www.altova.com /databasespy.html, 2010.
[28]
Database Merge, Donald Fish Data Management, http://www.donaldfish.com/ database-merge.html, 2010.
[29]
DBConvert Product Line, DMSoft Technologies, http://dbconvert.com, 2009.
[30]
M. Kazemian, B. Moshiri, H. Nikhbakh and C. Lucas, Architecture for Biological Database Integration, Artificial Intelligence and Machine Learning 2005 Conference (AIML 05), 2005.
- Towards flexible database conversion with automatic restructuring
Recommendations
A new system architecture for flexible database conversion
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 ...
Database Migration from ORACLE to PostgreSQL
AbstractMethods of data transfer from the Oracle environment to the PostgreSQL environment with stage-by-stage organization of actions and determination of the sequence of migration are considered. The main directions for the transformation of the ...
Schema analysis for database restructuring
The problem of generalized restructuring of databases has been addressed with two limitations: first, it is assumed that the restructuring user is able to describe the source and target databases in terms of the implicit data model of a particular ...
Comments
Information & Contributors
Information
Published In
Publisher
World Scientific and Engineering Academy and Society (WSEAS)
Stevens Point, Wisconsin, United States
Publication History
Published: 23 July 2010
Author Tags
Qualifiers
- Article
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- 0Total Citations
- 0Total Downloads
- Downloads (Last 12 months)0
- Downloads (Last 6 weeks)0
Reflects downloads up to 20 Jan 2025