Skip to main navigation Skip to search Skip to main content

Migration of Relational Database to Document-Oriented Database: Structure Denormalization and Data Transformation

Research output: Chapter in Book/Report/Conference proceeding › Conference paper › Research › peer-review

58 Citations (Scopus)

Abstract

Relational databases remain the leading data storage technology. Nevertheless, many companies want to reduce operating expenses, to make scalable applications that use cloud computing technologies. Use of NoSQL database is one of the possible solutions, and it is forecasted that the NoSQL market will be growing at a CAGR of approximately 50 percent over the next five years. The paper offers a solution for quick data migration from a relational database into a document-oriented database. We have created semi-automatically two logical levels over physical data. Users can refine generated logical data model and configure data migration template for each needed document. Data migration features are implemented into relational database browser Dig Browser. Real patients' database was migrated to Clasterpoint database. The offered approach provides means to obtain at least proof-of-concept for new document-oriented database solution in a couple of days.

Original languageEnglish
Title of host publicationProceedings - 7th International Conference on Computational Intelligence, Communication Systems and Networks, CICSyN 2015
EditorsAndrejs Romanovs, Galina Merkuryeva, Yuri Merkuryev, David Al-Dabass
PublisherInstitute of Electrical and Electronics Engineers Inc.
Pages113-118
Number of pages6
ISBN (Electronic)9781467370165
DOIs
Publication statusPublished - 28 Oct 2015
Event7th International Conference on Computational Intelligence, Communication Systems and Networks, CICSyN 2015 - Riga, Latvia
Duration: 3 Jun 2015 → 5 Jun 2015

Publication series

NameProceedings - 7th International Conference on Computational Intelligence, Communication Systems and Networks, CICSyN 2015

Conference

Conference7th International Conference on Computational Intelligence, Communication Systems and Networks, CICSyN 2015
Country/TerritoryLatvia
CityRiga
Period3/06/15 → 5/06/15

Keywords

  • database migration
  • document-oriented database
  • logical data representation
  • meta model
  • NoSQL
  • relational database

Fingerprint

Dive into the research topics of 'Migration of Relational Database to Document-Oriented Database: Structure Denormalization and Data Transformation'. Together they form a unique fingerprint.

Cite this