Skip to main content

Architecture for Virtualization in Data Warehouse

  • Conference paper

Abstract

Conventional data warehouse (DW) due to structure of its schema and contents is unable to: a) support any dynamics in its source structure and contents b) unable to support hidden-subjects c) unable to provide data on-the-fly i.e. real-time data and populate hidden-subjects on their evolution. To handle these problems the concept of virtualization in DW is floated here. In this study we have proposed architecture of virtualization approach. According to this approach, conventional DW is replaced by: i) a storage component called data-store ii) a Synthetic warehouse (SWH). Data-store is a non-subjective, content consistent, time-variant and integrated storage. On the other hand, SWH is only a structure, with no instances attached. It acts as a schema source for analytical processing and is mapped to its data-store. Subjective conversion is expected to be done on-the-fly. We are hopeful that this architecture will qualify all the evaluation parameters of: i) scalability ii) hidden-subjective support iii) source dynamics.

Keywords

  • Data Warehouse
  • virtualization
  • on-the-fly integration
  • architecture
  • synthetic warehouse.

This is a preview of subscription content, access via your institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (Canada)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   129.00
Price excludes VAT (Canada)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   169.99
Price excludes VAT (Canada)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD   169.99
Price excludes VAT (Canada)
  • 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

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Paulraj Ponniah.Data Warehousing Fundamentals, A Comprehensive Guide for IT Professional. Wiley Publishers, 1998. ISBN: 0471412546

    Google Scholar 

  2. Jarke, M. Lenzerini, M. Vallilious, Y. Vassiliadis. Fundamentals of Data Warehouses.Springer-Verlag,, 2000.

    Google Scholar 

  3. Bebel, B. Eder, J. Koncilia, C. Morzy, T. Wrembel, R. Creation and Management of Versions in Multiversion Data Warehouse. Proceeding of , 2004.

    Google Scholar 

  4. Sjoberg, D. Quantifying Schema Evolution.Software Technology 35, 1, Page 35-54, 1993.

    Google Scholar 

  5. Blaschaka, M.Sapia, C.Hofling, G.: On Schema Evolution in Multidimensional Databases.Proceedings of DaWak99, Italy, 1999.

    Google Scholar 

  6. Golfarelli, M. Rizzi, S. Cella, I. Beyond Data Warehousing: What’s Next in Business Intelligence?Proceedings of 7th International Workshop on Data Warehousing & OLAP, 2004

    Google Scholar 

  7. Rundensteiner, E. Koeller, A. Zhang, X. Maintaining Data Warehouses over Changing Information Sources. Communication of the ACM, Vol. 3, No 6, 2000.

    Google Scholar 

  8. Pasha,M.A. Nasir,J.A, Shahzad,M.K Semi-Star Modeling Schema for managing Data Warehouse Consistency. Proceedings of IEEE-ACM-NCET, Pakistan, 2004.

    Google Scholar 

  9. Eder, J. Koncilia, C. Changes of Dimension Data in Temporal Data Warehouses. Proceedings of DaWak, 2001.

    Google Scholar 

  10. Chamoni, P. Stock, S. Temporal Structures in Data Warehousing. Proceedings of the Data Warehousing and Knowledge Discovery DaWak99.

    Google Scholar 

  11. Morzy T., Wrembel R.:On Querying Versions of Multi-version Data Warehouse. In Proceedings of 7th ACM DOLAP’04, Washington, USA, 2004

    Google Scholar 

  12. Bernadrino, J. Madera, H. Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing, Proceedings of CAiSE’00, Sweden, 2000.

    Google Scholar 

  13. Raymond,D. Partial Order Databases,PhD Thesis, submitted to Department of Computer Science, University of Waterloo.

    Google Scholar 

  14. Genesereth,R.M. Keller,A.M. Duschka,O.M. Infomaster: An Information IntegrationSystem. Proceedings of ACM-SIGMOD’97, AZ, USA

    Google Scholar 

  15. Han,J. Kamber,M. Data mining: concepts and techniques,Morgan Kaufmann publishers, 2000.

    Google Scholar 

  16. Inmon, B. The Operational Data Store.InfoDB, February, 1995.

    Google Scholar 

  17. Baina, K. Tata, S. Bema;o, K. A Model for Process Service Inteaction. Proceedings of 1st Conference on Business Process management. Netherlands, 2003

    Google Scholar 

  18. Monge, A. Elkan, C. The field matching Problem: Algorithms and Applications.Proceedings of KDD-96.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and Permissions

Copyright information

© 2007 Springer

About this paper

Cite this paper

Nasir, J., Khurram Shahzad, M. (2007). Architecture for Virtualization in Data Warehouse. In: Sobh, T. (eds) Innovations and Advanced Techniques in Computer and Information Sciences and Engineering. Springer, Dordrecht. https://doi.org/10.1007/978-1-4020-6268-1_44

Download citation

  • DOI: https://doi.org/10.1007/978-1-4020-6268-1_44

  • Publisher Name: Springer, Dordrecht

  • Print ISBN: 978-1-4020-6267-4

  • Online ISBN: 978-1-4020-6268-1

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics