Skip to main content
SpringerLink
Log in

Query-Driven Method for Improvement of Data Warehouse Conceptual Model

  • Conference paper
  • First Online:
Building Sustainable Information Systems

Abstract

We propose a query-driven method that elicits the information requirements from existing queries on data sources and their usage statistics. Our method presumes that the queries against the source database reflect the analysis needs of users. We use this method to recommend changes to the existing data warehouse schemata. In our method, we take advantage of the schema versioning approach to reflect all changes that occur in the analysed process, and we analyse the activity of users in the source system, rather than changes in physical data structure, to infer the necessary improvements to the data warehouse schema.

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

Access this chapter

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
Hardcover Book
USD 219.99
Price excludes VAT (USA)
  • Durable hardcover 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

Institutional subscriptions

References

  1. Westerman P (2001) Data warehousing using the Wal-Mart model. Morgan Kaufmann, San Francisco

    Google Scholar 

  2. Kaldeich C, Oliveira J (2004) Data warehouse methodology: a process driven approach, vol 3084, LNCS. Springer, Berlin, pp 536–549

    Google Scholar 

  3. Giorgini P, Rizzi S, Garzetti M (2005) Goal-oriented requirement analysis for data warehouse design. In: 8th ACM international workshop DOLAP, pp 47–56

    Google Scholar 

  4. Golfarelli M, Maio D, Rizzi S (1998) The dimensional fact model: a conceptual model for data warehouses. Int J Coop Inf Syst 7(2&3):215–247

    Article  Google Scholar 

  5. Jones ME, Song I (2005) Dimensional modeling: identifying, classifying and applying patterns. In: Proceedings of DOLAP '05. ACM, New York, pp 29–38

    Google Scholar 

  6. Golfarelli M, Lechtenbörger J, Rizzi S, Vossen G (2006) Schema versioning in data ware-houses: enabling cross-version querying via schema augmentation. Data Knowl Eng 59(2):435–459

    Article  Google Scholar 

  7. Kuechler B, Vaishnavi VK (2008) On theory development in design science research: anatomy of a research project. Eur J Inf Syst 17(5):489–504

    Article  Google Scholar 

  8. Niemi T, Nummenmaa J, Thanisch P (2001) Constructing OLAP cubes based on queries. In: Proceedings of the 4th ACM international workshop on data warehousing and OLAP. ACM Press, pp 9–15

    Google Scholar 

  9. Pang C, Taylor K, Zhang X, Cameron M (2004) Generating multidimensional schemata from relational aggregation queries. In: Zhou X et al (eds) WISE’2004, vol 3306, LNCS. Springer, Berlin, pp 584–589

    Google Scholar 

  10. Nair R, Wilson C, Srinivasan B (2007) A conceptual query-driven design framework for data warehouse, vol 19, Transactions on engineering, computing and technology., pp 141–146

    Google Scholar 

  11. Zhang J, Wang W, Liu H, Zhang S (2005) X-warehouse: building query pattern-driven data warehouse for XML data. In: Proceedings of the international world wide web conference, pp 896–897

    Google Scholar 

  12. Body M, Miquel M, Bedard Y, Tchounikine A (2002) A multidimensional and multiversion structure for OLAP applications. In: ACM 5th international workshop on data warehousing and OLAP. ACM, McLean, VA, pp 1–6

    Google Scholar 

  13. Wrembel R, Bębel B (2005) Metadata management in a multiversion data warehouse. In: On the Move to Meaningful Internet Systems 2005: CoopIS, DOA, and ODBASE (pp. 1347–1364). Springer Berlin Heidelberg

    Google Scholar 

  14. Velegrakis Y, Miller RJ, Popa L (2003) Mapping adaptation under evolving schemas. In: 29th international conference on VLDB. Morgan Kaufmann, Berlin, Germany, pp 584–595

    Google Scholar 

  15. Solodovnikova D (2007) Data warehouse evolution framework. In: Proceedings of the Spring Young Researcher’s Colloquium on Database and Information Systems (SYRCoDIS'07), Moscow, Russia. http://ceur-ws.org/Vol-256/submission_4.pdf

  16. Solodovnikova D (2010) Metadata to Support Data Warehouse Evolution. In Information Systems Development (pp. 627–635). Springer US

    Google Scholar 

  17. Solodovnikova D, Niedrite L (2006) Data warehouse adaptation after the changes in source schemata. In: 7th international Baltic conference on databases and information systems, pp 52–63

    Google Scholar 

Download references

Acknowledgments

This work has been supported by ESF project No. 2009/0216/1DP/1.1.1.2.0/09/APIA/VIAA/044.

Author information

Authors and Affiliations

  1. Faculty of Computing, University of Latvia, Raina boulv.19, Riga, Latvia

    Darja Solodovnikova, Laila Niedrite & Aivars Niedritis

Authors
  1. Darja Solodovnikova
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Laila Niedrite
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Aivars Niedritis
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Darja Solodovnikova .

Editor information

Editors and Affiliations

  1. Monash University, Caaulfield East, Victoria, Australia

    Henry Linger

  2. Monash University, Caulfield East, Victoria, Australia

    Julie Fisher

  3. Box Hill Institute, Box Hill, Victoria, Australia

    Andrew Barnden

  4. National University of Ireland, Galway, Ireland

    Chris Barry

  5. National University of Ireland, Galway, Ireland

    Michael Lang

  6. City University of Hong Kong, Kowloon, Hong Kong SAR

    Christoph Schneider

Rights and permissions

Reprints and permissions

Copyright information

© 2013 Springer Science+Business Media, LLC

About this paper

Cite this paper

Solodovnikova, D., Niedrite, L., Niedritis, A. (2013). Query-Driven Method for Improvement of Data Warehouse Conceptual Model. In: Linger, H., Fisher, J., Barnden, A., Barry, C., Lang, M., Schneider, C. (eds) Building Sustainable Information Systems. Springer, Boston, MA. https://doi.org/10.1007/978-1-4614-7540-8_41

Download citation

  • DOI: https://doi.org/10.1007/978-1-4614-7540-8_41

  • Published:

  • Publisher Name: Springer, Boston, MA

  • Print ISBN: 978-1-4614-7539-2

  • Online ISBN: 978-1-4614-7540-8

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation