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.
[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.
[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.
@article{"International Journal of Information, Control and Computer Sciences:53684", author = "Bogdan Walek and Cyril Klimes", title = "Data Migration between Document-Oriented and Relational Databases", 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", volume = "6", number = "9", pages = "1115-5", }