Data Migration between Document-Oriented and Relational Databases

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.

Authors:

• Bogdan Walek
• Cyril Klimes

Keywords:

• data migration
• database
• document-oriented database
• XML
• relational schema

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.