Abstract
Data warehouses usually store large amounts of information, representing an integration of base data from different data sources over a long time period. Aggregate views can be stored as a set of its horizontal fragments for the purposes of reducing warehouse query response time and maintenance cost.
This paper proposes a scheme that efficiently maintains horizontally partitioned data warehouse views. Using the proposed scheme, only one view fragment holding the relevant subset of tuples of the view is accessed for each update. The scheme also includes an approach to reduce the refresh time for maintaining views that compute aggregate functions MIN and MAX.
This research was supported by the Natural Science and Engineering Research Council (NSERC) of Canada under an operating grant (OGP-0194134) and a University of Windsor grant.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Colby, L.S., Griffin, T., Libkin, L.: Algorithms for Deferred View Maintenance. Proceedings of the ACM SIGMOD International Conference, Montreal, Canada,(1996) 469–480
Ezeife, C.I.: Selecting and Materializing Horizontally Partitioned Warehouse Views. to appear in Elsevier journal of Data and Knowledge Engineering, (2000).
Harinarayan, Venky and Rajaraman, Anand, Ullman, Jeffret,: Implementing Data Cubes Efficiently. ACM SIGMOD International Conference on Management of Data, (1996), 205–216.
Mumick, I.S., Quass, D., Mumick, B.S.: Maintenance of Data Cubes and Summary Tables in a Warehouse. Proceedings of the ACM SIGMOD International Conference, (1997) 100–111.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2000 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Xu, M., Ezeife, C.I. (2000). Maintaining Horizontally Partitioned Warehouse Views. In: Kambayashi, Y., Mohania, M., Tjoa, A.M. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2000. Lecture Notes in Computer Science, vol 1874. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-44466-1_13
Download citation
DOI: https://doi.org/10.1007/3-540-44466-1_13
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-67980-6
Online ISBN: 978-3-540-44466-4
eBook Packages: Springer Book Archive