Design and Development of OLAP Tool for Data warehousing

Authors

  • R. P. Alamelu Research Scholar, Department of Computer Science, AVS College of Arts & Science, Ramalingapuram, Tamil Nadu, India
  • R. Parimala Assistant Professor, Department of Computer Science, AVS College of Arts & Science, Ramalingapuram, Tamil Nadu, India

DOI:

https://doi.org/10.37591/joadms.v5i3.1924

Abstract

The complex information requirements and the ever-growing demand for increasingly sophisticated data analysis sparked the creation of a new type of data repository.  This repository contains data in formats that facilitate data extraction, data analysis, and decision making.  This data repository is known as decision support systems.  The need for more intensive decision support On Line Analytical Processing (OLAP), create an advanced data analysis environment that supports decision making, business modelling, and operations research activities. The main aim of this research work is to design and develop a user-friendly Hybrid on Line Analytical Processing (HOLAP) tool for Data Warehouse environment.  This tool contains two modules ROLAP and MOLAP.  In ROLAP module different data sources are integrated in different ways to from data warehouse.  In MOLAP module, the data cube is constructed and represented in star schema.  The OLAP operations like slicing, dicing, drilling and pivoting are all performed.  Information is also retrieved using natural language query as well as SQL. The introduction chapter contains the basic concepts of data warehousing, overview of OLAP.  The second chapter contains the details about star schema, types of OLAP and multidimensional model.  The analysis of related works is also discussed.  Goals and overview of the system are discussed in the third chapter.  Methodology, system structure and implementation are discussed in the fourth chapter.

Downloads

Published

2019-01-30

Issue

Vol. 5 No. 3 (2018)

Section

Research Articles

License

Declaration and Copyright Transfer Form

(to be completed by authors)

I/ We, the undersigned author(s) of the submitted manuscript, hereby declare, that the above manuscript which is submitted for publication in the STM Journals(s), is not published already in part or whole (except in the form of abstract) in any journal or magazine for private or public circulation, and, is not under consideration of publication elsewhere.

  • I/We will not withdraw the manuscript after 1 week of submission as I have read the Author Guidelines and will adhere to the guidelines.
  • I/We Author(s ) have niether given nor will give this manuscript elsewhere for publishing after submitting in STM Journal(s).
  • I/ We have read the original version of the manuscript and am/ are responsible for the thought contents embodied in it. The work dealt in the manuscript is my/ our own, and my/ our individual contribution to this work is significant enough to qualify for authorship.
  •  I/We also agree to the authorship of the article in the following order:

Author’s name                                    

 

1. ________________

2. ________________

3. ________________

4. ________________

 

We  Author(s) tick this box and would request you to consider it as our signature as we agree to the terms of this Copyright Notice, which will apply to this submission if and when it is published by this journal.