Published September 22, 2012 | Version 4574

Data Migration between Document-Oriented and Relational Databases

Authors/Creators

Description

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.

Files

4574.pdf

Files (315.2 kB)

Name Size Download all
md5:36c64c195b68f6a181c07d900aff36fc
315.2 kB Preview Download

Additional details

References

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