Abstract
To achieve vital advantages of simulating business scenarios, extensions are made to versioning concept by dividing alternative versions into two types, Materialized Alternative Versions and Virtual Alternative Versions. This paper presents querying method from multi-version data warehouse in the presence of real versions, materialized and virtual alternative versions. This is done by making extensions to our Synthetic Warehouse Builder with new component called Version Manager.Version manger with its confinement process divide query into smaller parts called mono-version queries; execute it on relevant and heterogeneous version/s and merging the result to present it for analysis. It is expected that, Version Manager is very useful for short term data requirements as well as rapidly changing requirements of simulating business alternatives.
Keywords
- Data Warehouse
- evolution
- versioning
- querying DW
- architecture
- data retrieval.
This is a preview of subscription content, access via your institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Bebel, B. Eder, J. Koncilia, C. Morzy, T. Wrembel, R. Creation and Management of Versions in Multiversion Data Warehouse, Proceedings of 2004 ACM Symposium on Applied Computing, 2004.
Soberg, D. Quantifying Schema, Evolution Information Software Technology 35, 1, 35-54, 1993.
Blaschka, M. Sapia, C. Hofling, G. On Schema Evolution in Multidimensional Databases. Proceedings of DaWak99 Conference, Italy, 1999.
Hurtado, C.A. Mendelzon, A.O. Vaisman, A.A. Maintaining Data Cubes under Dimension Updates. Proceedings of ICDE Conference, Australia, 1999.
Pasha, M.A. Nasir, J.A. Shahzad, M.K Semi-star schema for managing data warehouse consistency, In Proceedings of National Conference on Emerging Technologies, IEEE-ACM, NCET’04, Karachi, Pakistan, 2004.
Wrembel R., Morzy T. Multiversion Data Warehouses: Challenges and Solutions. Proc. of the 3rd IEEE Conference on Computational Cybernetics (ICCC 2005), Mauritius, April 2005.
Morzy T., Wrembel R.: On Querying Versions of Multi-version Data Warehouse. In Proceedings of 7th ACM DOLAP’04, Washington, USA, 2004.
Nasir, J.A. Shahzad, M.K. Pasha, M.A. Transparent querying multi-version data warehouse, Information Technology Journal 5 (2): 250-259, 2006.
Shahzad,M.K. Recent issues identified and conceptualized for achieving vital advantages in multi-version data warehouse. International Journal of Soft Computing1(2): 97-102, 2006.
Eder, J. Koncilia, C. Changes of Dimension Data in Temporal Data Warehouses. Proceedings of DaWak, 2001.
Eder, J. Koncilia, C. Morzy, T. The COMET Metamodel for temporal Data Warehouses, Proceedings of CAiSE’02, Canada, 2002.
Chamoni, P. Stock, S. Temporal structures in Data Warehousing. Proceedings of the DaWaK, Italy, 1999.
Mendelzon, A.O. Viasman, A.A. Temporal Queries in OLAP, Proceedings of VLDB Conference, Egypt, 2000.
Bernadrino, J. Madera, H. Data Warehousing and OLAP: Improving Query Performance Using Distributed Computing, Proceedings of CAiSE’00, Sweden, 2000.
Pedersen, D. Riis, K. Pedersen, T.B. Query optimization for OLAP XML federation, In Proceedings of 5th ACM Workshop on DOLAP, USA, 2002.
Pedersen, D. Pedersen, J. Pedersen, T.B. Integrating XML Data in Target OLAP system, In Proceedings of 9th ICDE, 2004.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2007 Springer
About this paper
Cite this paper
Shahzad, M.K. (2007). Version Manager: A step towards Synthetic-Warehouse-Builder extension. 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_52
Download citation
DOI: https://doi.org/10.1007/978-1-4020-6268-1_52
Publisher Name: Springer, Dordrecht
Print ISBN: 978-1-4020-6267-4
Online ISBN: 978-1-4020-6268-1
eBook Packages: EngineeringEngineering (R0)
