Data Migration between Document-Oriented and Relational Databases

Authors: Bogdan Walek, Cyril Klimes

Abstract:

Current tools for data migration between documentoriented and relational databases have several disadvantages. We propose a new approach for data migration between documentoriented and relational databases. During data migration the relational schema of the target (relational database) is automatically created from collection of XML documents. Proposed approach is verified on data migration between document-oriented database IBM Lotus/ Notes Domino and relational database implemented in relational database management system (RDBMS) MySQL.

Keywords: data migration, database, document-oriented database, XML, relational schema

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1059451

References:

[1] P. Atzeni, V. De Antonellis, Relational Database Theory. The Benjamin/ Cummings Publishing Company, Inc., Redwood City, 1993, ch. 1.
[2] L. Jan Harrington, Relational database design and implementation. Elsevier Inc., Burlington, 2009, ch. 4,5.
[3] IBM Lotus Notes. IBM, 2011. http://www- 01.ibm.com/software/lotus/products/notes/.
[4] IBM - Software to synchonize across multiple repositiories - Tivoli Directory Integrator. IBM, 2011. http://www- 01.ibm.com/software/tivoli/products/directory-integrator/.
[5] Notes2DB: Migrate Data from IBM Lotus Notes Domino to a RDBMS. 2011. http://my.advisor.com/doc/12332.
[6] DetachIt Attachment Extraction and field Export Tool for Lotus Notes. Kim Beros Consulting, 2011. http://www.lotus-notesexport. com/DetachIt.asp?MoreInfo=1.
[7] Lotus Notes to SQL. Convert Lotus Notes to SQL. Lotus Notes Export to SQL. Kim Beros Consulting 2011. http://www.lotus-notesexport. com/Lotus-Notes-To-SQL.asp.
[8] J. Morris, Practical data migration. The British Computer Society, Chippenham, 2009, ch.1.