Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Skip to main content
Springer Nature Link
Log in

A Novel Approach of Using Materialized Queries for Retrieving Results from Data Warehouse

  • Conference paper
  • First Online:
Proceedings of the International Conference on Intelligent Vision and Computing (ICIVC 2021) (ICIVC 2021)

Part of the book series: Proceedings in Adaptation, Learning and Optimization ((PALO,volume 15))

Included in the following conference series:

  • 767 Accesses

Abstract

The organization data warehouse stores historical records collected from various operational sources for management strategy making. In case of frequent management queries, generation of same results by repeated invocation to the data warehouse is relatively time consuming. In order to extract results from data warehouse, data-cubes and materialized-views are used. They acquire more processing, storage area and maintenance cost. The present study enhances result fetching of the queries which are frequent from a data warehouse by loading queries, results and some meta-data in a database stated as Materialized-Query-Database denoted as MQDB. When a query is given by the user, the MQDB is checked for determining any already existing query in the database. In case the query exists in MQDB and the stored results do not require any result updation then the results are simply fetched from the database. The approach of storing the results of the input query and thereafter simply fetching them when the same query is executed again reduces the query processing time substantially. The evaluation of the novel approach done by using the data warehouse on the central as well as on a remote cloud-server shows a noteworthy reduction in the time taken to retrieve results of the queries as compared to using the prevailing approaches. The approach is suitable to make use of past records in the data warehouse for management decision making.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution

Institutional subscriptions

We’re sorry, something doesn't seem to be working properly.

Please try refreshing the page. If that doesn't work, please contact support so we can address the problem.

References

  1. Agrawal, R., Gupta, A., Sarawagi, S.: Modeling multidimensional databases. In: Proceedings of the 13th International Conference on Data Engineering, pp. 232–243 (1997)

    Google Scholar 

  2. Bara, A., Lungu, I., Velicanu, M., Diaconita, V., Botha, I.: Improving query performance in virtual data warehouses. WSEAS Trans. Inf. Sci. Appl. 5(5), 632–641 (2008)

    Google Scholar 

  3. Chakraborty, S., Doshi, J.: Materialized queries with incremental updates. Springer Smart Innov. Syst. Technol. 1, 31–40 (2018)

    Google Scholar 

  4. Chakraborty, S., Doshi, J.: Faster result retrieval from health care product sales data warehouse using materialized queries. Evol. Computational Intell. Adv. Intell. Syst. Computing 1176, 1–9 (2020)

    Google Scholar 

  5. Chaudhuri, S., Dayal, U.: An overview of data warehousing and OLAP technology. ACM SIGMOD Rec. 26(1), 65–74 (1997)

    Article  Google Scholar 

  6. Chun, S., Chung, C., Lee, J., Lee, S.: Dynamic update cube for range-sum queries. In: Proceedings of the 27th VLDB Conference, pp 521–530 (2001)

    Google Scholar 

  7. Datta, A., Thomas, H.: The cube data model: a conceptual model and algebra for on-line analytical processing in data warehouses. Decis. Support Syst. 27(3), 289–301 (1999)

    Article  Google Scholar 

  8. Deshpande, P., Agarwal, S., Naughton, J., Ramakrishnan, R.: Computation of multidimensional aggregates. In: Proceedings of the 22nd VLDB Conference, pp. 506–521 (1996)

    Google Scholar 

  9. Gupta, A., Mumick, I., Subrahmanian, V.: Maintaining views incrementally. In: Proceedings of the 1993 ACM SIGMOD International Conference on Management of Data, Washington, pp. 157–166 (1993)

    Google Scholar 

  10. Gupta, A., Mumick, I.: Maintenance of materialized-views: problems, techniques and applications. Bull. Tech. Commit. Data Eng., IEEE Comput. Soc. 18(2),  3–18 (1995)

    Google Scholar 

  11. Gupta, A., Jagadish, H.V., Singh Mumick, I.: Data integration using self-maintainable views. In: Apers, P., Bouzeghoub, M., Gardarin, G. (eds.) EDBT 1996. LNCS, vol. 1057, pp. 140–144. Springer, Heidelberg (1996). https://doi.org/10.1007/BFb0014149

    Chapter  Google Scholar 

  12. Gupta, G.: Introduction to data mining with case studies. PHI Learning Private Limited (2014)

    Google Scholar 

  13. Han, J., Kamber, M., Pei, J.: Data Mining-Concepts and Techniques, Third edn. Morgan Kaufman Publishers (2011)

    Google Scholar 

  14. Harinarayan, V., Rajaraman, A., Ullman, J.: Implementing data-cubes efficiently. In: Proceedings of the 1996 ACM SIGMOD International Conference on Management of Data, pp. 205–216 (1996)

    Google Scholar 

  15. Laudon, K., Laudon, J., Dass, R.: Management Information Systems, Eleventh edn., pp. 45–49. Pearson Education (2010)

    Google Scholar 

  16. Mumick, I., Quass, D., Mumick, B.: Maintenance of data-cubes and summary tables in a warehouse. In: Proceedings of the 1997 ACM SIGMOD International Conference on Management of Data, pp. 100–111 (1997)

    Google Scholar 

  17. Neil, P., Quass, D.: Improved query performance with variant indexes. In: Proceedings of the 1997 ACM SIGMOD International Conference on Management of Data, Tucson, pp. 38–49 (1997)

    Google Scholar 

  18. Quass, D.: Maintenance Expressions for Views with Aggregation. Views’96. http://ilpubs.stanford.edu:8090/183/1/1996-54.pdf (1996)

  19. Serranoa, M., Trujillo, J., Calero, C., Piattini, M.: Metrics for data warehouse conceptual model’s understandability. Inf. Softw. Technol. 49(8), 851–870 (2007)

    Article  Google Scholar 

  20. Shanmugasundaram, J., Fayyad, U., Bradley, P.: Compressed data-cubes for OLAP aggregate query approximation on continuous dimensions. In: Proceedings of the 5th ACM SIGKDD International Conference on Knowledge Discovery and Data Mining, pp. 223–232 (1999)

    Google Scholar 

  21. Thareja, R.: Data Warehousing. Oxford University Press (2009)

    Google Scholar 

  22. The Office of the Registrar General and Census Commissioner, Ministry of Home Affairs. http://censusindia.gov.in (2020)

  23. Vanichayobon, S.: Indexing Techniques for Data Warehouses’ Queries. http://www.cs.ou.edu/~database/documents/vg99.pdf (1999)

  24. Zhou, J., Larson, P., Elmongui, H.: Lazy maintenance of materialized-views. In: Proceedings of the 33rd International Conference on Very large Databases, pp. 231–242 (2007)

    Google Scholar 

  25. Zhuge, Y., Molina, H., Hammer, J., Widom, J.: View maintenance in a warehousing environment. In: Proceedings of the 1995 ACM SIGMOD International Conference on Management of Data, pp. 316–327 (1995)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Mathematical and Computational Sciences, National Institute of Technology, Mangalore, Karnataka, 575025, India

    Sonali Chakraborty

Authors
  1. Sonali Chakraborty
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Sonali Chakraborty .

Editor information

Editors and Affiliations

  1. Department of Computer Science and Engineering, Rajasthan Technical University, Kota, India

    Harish Sharma

  2. Sur University College, Sur, Oman

    Vijay Kumar Vyas

  3. Department of Mathematical Sciences, Indian Institute of Technology (BHU) Varanasi, Varanasi, Uttar Pradesh, India

    Rajesh Kumar Pandey

  4. School of Computer Science, University of Technology Sydney, Sydney, NSW, Australia

    Mukesh Prasad

Rights and permissions

Reprints and permissions

Copyright information

© 2022 The Author(s), under exclusive license to Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Chakraborty, S. (2022). A Novel Approach of Using Materialized Queries for Retrieving Results from Data Warehouse. In: Sharma, H., Vyas, V.K., Pandey, R.K., Prasad, M. (eds) Proceedings of the International Conference on Intelligent Vision and Computing (ICIVC 2021). ICIVC 2021. Proceedings in Adaptation, Learning and Optimization, vol 15. Springer, Cham. https://doi.org/10.1007/978-3-030-97196-0_3

Download citation

Publish with us

Policies and ethics

Search

Navigation