Skip to main content
SpringerLink
Log in
Book cover

Evolution in Computational Intelligence pp 1–9Cite as

Faster Result Retrieval from Health Care Product Sales Data Warehouse Using Materialized Queries

  • Conference paper
  • First Online:

  • 800 Accesses

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 1176))

Abstract

Existing approaches for result retrieval from a Data Warehouse, i.e., Data Cubes and Materialized Views, incur more processing, maintenance and storage cost. For faster retrieval of query results from Data Warehouse, authors suggest storing executed OLAP queries and their results along with metadata in a relational database referred here as Materialized Query Database (MQDB). For stored queries, processing incremental results using Data Marts is faster as compared to using Data Warehouse. Therefore, a significant reduction in query processing time is achieved using MQDB. Authors depict the working of proposed MQDB approach on the sales data of a health care product manufacturing organization by placing Data Warehouse on Centralized and on Cloud Server.

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

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   169.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   219.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

References

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

    Google Scholar 

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

    Google Scholar 

  3. 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 

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

    Google Scholar 

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

    Google Scholar 

  6. 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, San Deigo, pp. 223–232 (1999)

    Google Scholar 

  7. 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 

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

    Google Scholar 

  9. Quass, D.: Maintenance Expressions for Views with Aggregation. Views (1996)

    Google Scholar 

  10. 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, San Jose, pp. 316–327 (1995)

    Google Scholar 

  11. Gupta, A., Jagadish H., Mumick, I.: Data integration using self-maintainable views. In: Advances in Database Technology—EDBT ’96, LNCENS, vol. 1057, pp. 140–144 (1996)

    Google Scholar 

  12. 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, Tuscon, pp. 100–111 (1997)

    Google Scholar 

  13. Chakraborty, S., Doshi, J.: Performance evaluation of materialized query. Int. J. Emerg. Technol. Adv. Eng. 8(1), 243–249 (2018)

    Google Scholar 

  14. Chakraborty, S., Doshi, J.: Incremental updates using data warehouse versus data marts. In: 4th International Conference for Convergence in Technology (I2CT), IEEE Xplore® Digital Library (2018). (In Press)

    Google Scholar 

  15. Chakraborty, S., Doshi, J.: Deriving aggregate results with incremental data using materialized queries. Int. J. Comput. Sci. Eng. 5(8), 835–839 (2018)

    Google Scholar 

  16. Chakraborty, S., Doshi, J.: Reducing query processing time for non-synonymous materialized queries with differed criteria. Int. J. Nat. Comput. Res. 8(2), 75–93 (2019). (IGI Global Publishers)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. GLS University, Ahmedabad, Gujarat, India

    Sonali Chakraborty & Jyotika Doshi

Authors
  1. Sonali Chakraborty
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Jyotika Doshi
    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 Electronics and Communication Engineering, Shri Ramswaroop Memorial Group of Professional Colleges (SRMGPC), Lucknow, Uttar Pradesh, India

    Vikrant Bhateja

  2. Department of Computer Science and Information Engineering, National Dong Hwa University, Hualien, Taiwan

    Sheng-Lung Peng

  3. School of Computer Engineering, Kalinga Institute of Industrial Technology (KIIT), Bhubaneswar, Odisha, India

    Suresh Chandra Satapathy

  4. Department of Informatics, University of Leicester, Leicester, UK

    Yu-Dong Zhang

Rights and permissions

Reprints and permissions

Copyright information

© 2021 The Editor(s) (if applicable) and The Author(s), under exclusive license to Springer Nature Singapore Pte Ltd.

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Chakraborty, S., Doshi, J. (2021). Faster Result Retrieval from Health Care Product Sales Data Warehouse Using Materialized Queries. In: Bhateja, V., Peng, SL., Satapathy, S.C., Zhang, YD. (eds) Evolution in Computational Intelligence. Advances in Intelligent Systems and Computing, vol 1176. Springer, Singapore. https://doi.org/10.1007/978-981-15-5788-0_1

Download citation

Publish with us

Policies and ethics

Search

Navigation