An Approach for Creating and Maintaining Dependent Data Marts using Materialized Queries Information

Authors

  • Sonali Chakraborty  K. S School Of Business Management, Gujarat University, Ahmedabad, Gujarat, India
  • Jyotika Doshi   GLS Institute of Computer Technology (MCA), GLS University, Ahmedabad, Gujarat, India

Keywords:

Data Mart, Data Warehouse, Materialized Queries

Abstract

Result generation of enterprise OLAP queries is done using warehouse data. Traversing through records in a warehouse is quite time consuming due to enormous amount of historical and current data. Data warehouse undergoes periodic refreshing to keep the information updated. OLAP queries along with their results and other parameters are stored in Materialized Query Database (MQDB) for faster result retrieval. If same OLAP query is fired again, and it requires incremental updates, complete analysis of warehouse data is done again. This results into higher query execution time. Performing incremental updates using predefined data marts will give faster query results as compared to generating results using warehouse data. This paper discusses an approach to determine and create dependent data marts and maintaining them periodically.

References

  1. Manuel Serranoa, Juan Trujillo, Coral Calero, Mario Piattini, "Metrics for data warehouse conceptual models understandability," Information and Software Technology, Volume 49, Issue 8, August 2007, Pages 851–870.
  2. Lou Agosta, "Data Warehousing Refresh Rates," Information Management, 2003. Online] Available: http://search.proquest.com/openview/d27cfb901e3832ced0e374680b990baa/1?pq-origsite=gscholar&cbl=51938 Accessed February 19, 2017].
  3. Thomas Jorg and Stefan Dessloch, "Formalizing ETL Jobs for Incremental Loading of Data Warehouses," Proceedings der GI-Fachtagung fur Datenbanksysteme in Business, Technologie und Web, Lecture Notes in Informatics, Volume P-144, 2. bis 6. M¨ arz 2009, M ¨ unster, Germany, pp. 327–346. ISBN 978-3-88579-238-3.
  4. M. Bouzeghoub, F. Fabret, M. Matulovic-Broqué, "Modeling Data Warehouse Refreshment Process as a Workflow Application," Proceedings of the International Workshop on Design and Management of Data Warehouses (DMDW'99) Heidelberg, Germany, 14. - 15. 6. 1999 (S. Gatziu, M. Jeusfeld, M. Staudt, Y. Vassiliou, eds.).
  5. Jiawei Han, Micheline Kamber, and Jian Pei. Data Mining-Concepts and Techniques, Third Edition, Morgan Kaufman Publishers.
  6. Angela Bonifati, Fabiano Cattaneo, Stefano Ceri, Alfonso Fuggetta, Stefano Paraboschi, "Designing Data Marts for Data Warehouses," ACM Transactions on Software Engineering and Methodology (TOSEM), Volume 10 Issue 4, Oct. 2001, Pages 452-483.
  7. Ahlem Nabli, AhlemS oussi, Jamel Feki, Hanêne Ben Abdallah, Faiez Gargouri, "Towards An Automatic Data Mart Design," ICEIS 2005 - Databases And Information Systems Integration.
  8. Fatma Abdelhédi, Geneviève Pujolle, Olivier Teste, Gilles Zurfluh, "Computer-Aided Data-Mart Design," ICEIS (1), 2011.
  9. Anmar Aljanabi, Alaa Alhamami, Basim Alhadidi, "Query Dispatching Tool Supporting Fast Access to Data Warehouse," The International Arab Journal of Information Technology, Vol. 10, No. 3, May 2013.
  10. Reema Thareja. Data Warehousing, Oxford University Press.
  11. Sonali Chakraborty, Jyotika Doshi, "Performance Evaluation of Materialized Query," International Journal of Emerging Technology and Advanced Engineering, Volume 8, Issue 1, January 2018, pages 243-249.

International Journal of Scientific Research in Science, Engineering and Technology

Downloads

Published

2018-02-28

Issue

Volume 4, Issue 1, January-February-2018

Section

Research Articles

License

Copyright (c) IJSRSET

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

How to Cite

[1]
Sonali Chakraborty, Jyotika Doshi , " An Approach for Creating and Maintaining Dependent Data Marts using Materialized Queries Information, International Journal of Scientific Research in Science, Engineering and Technology(IJSRSET), Print ISSN : 2395-1990, Online ISSN : 2394-4099, Volume 4, Issue 1, pp.1527-1533, January-February-2018.