A Study on Comparison and Transformation of OLTP into OLAP
Main Article Content
Abstract
OLAP is an important feature of Business Intelligence. It is a process of converting new data into business information through multidimensional
analysis. Database design for OLTP is in normalized form. OLTP databases provide real time accesses to its data which is being
updated by other transactions. OLTP is abbreviation of On-Line Transaction Processing. This paper illustrating a theoretical procedure to
convert OLTP data into OLAP data and also comparison of OLTP and OLAP. For this transformation Merge Data, Scrub Data (Cleansing data),
Aggregate Data, Organize Data in Cubes is used. ER modeling is used for normalizing the OLTP database design. Dimensional modeling is
used for de-normalizing the ROLAP/MOLAP design. The concept of ETL : extract, transform, and load is used for transformation of data.
Â
Keywords: OLAP, OLTP, ETL and Data warehouse.
Downloads
Article Details
COPYRIGHT
Submission of a manuscript implies: that the work described has not been published before, that it is not under consideration for publication elsewhere; that if and when the manuscript is accepted for publication, the authors agree to automatic transfer of the copyright to the publisher.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work
- The journal allows the author(s) to retain publishing rights without restrictions.
- The journal allows the author(s) to hold the copyright without restrictions.