article

Free access

Monotonic complements for independent data warehouses

Authors:

J. Lechtenbörger,

G. VossenAuthors Info & Claims

The VLDB Journal — The International Journal on Very Large Data Bases, Volume 10, Issue 4

Pages 295 - 315

https://doi.org/10.1007/s007780100055

Published: 01 December 2001 Publication History

Abstract

Views over databases have regained attention in the context of data warehouses, which are seen as materialized views. In this setting, efficient view maintenance is an important issue, for which the notion of self-maintainability has been identified as desirable. In this paper, we extend the concept of self-maintainability to (query and update) independence within a formal framework, where independence with respect to arbitrary given sets of queries and updates over the sources can be guaranteed. To this end we establish an intuitively appealing connection between warehouse independence and view complements. Moreover, we study special kinds of complements, namely monotonic complements, and show how to compute minimal ones in the presence of keys and foreign keys in the underlying databases. Taking advantage of these complements, an algorithmic approach is proposed for the specification of independent warehouses with respect to given sets of queries and updates.

References

[1]

1. Abiteboul S., Hull R., Vianu V. Foundations of databases. Addison-Wesley, Reading, Mass., USA, 1995.

[2]

2. Akinde M.O., Jensen O.G., Böhlen M.H. Minimizing detail data in data warehouses. Proc. 6th EDBT 1998, pp 293-307.

[3]

3. de Amo S., Halfeld Ferrari Alves M. Efficient maintenance of temporal data warehouses. Proc. IDEAS 2000, pp 188-196.

[4]

4. Bancilhon F., Spyratos N. Update semantics of relational views. ACM TODS 6:557-575, 1981.

[5]

5. Blakeley J.A., Coburn N., Larson P. Updating derived relations: detecting irrelevant and autonomously computable updates. ACM TODS 14:369-400, 1989.

[6]

6. Blakeley J.A., Larson P., Tompa F.W. Efficiently updating materialized views. Proc. ACM SIGMOD 1986, pp 61-71.

[7]

7. Chaudhuri S., Dayal U. An overview of data warehousing and OLAP technologies. Proc. ACM SIGMOD 1997, pp 65-74.

[8]

8. Chaudhuri S., Krishnamurthy R., Potamianos S., Shim K. Optimizing queries with materialized views. Proc. 11th ICDE 1995, pp 190-200.

[9]

9. Cosmadakis S.S., Papadimitriou C.H. Updates of relational views. JACM 31:742-760, 1984.

[10]

10. Griffin T., Libkin L. Incremental maintenance of views with duplicates. Proc. ACM SIGMOD 1995, pp 328-339.

[11]

11. Griffin T., Libkin L., Trickey H. An improved algorithm for the incremental recomputation of active relational expressions. IEEE TKDE 9:508-511, 1997.

[12]

12. Gupta A., Jagadish H.V., Mumick I.S. Data integration using self-maintainable views. Technical Memorandum, AT&T Bell Laboratories, November 1994.

[13]

13. Gupta A., Mumick I.S. Maintenance of materialized views: problems, techniques, and applications. IEEE Data Eng Bull 18(2):3-18, 1995.

[14]

14. Gupta A., Mumick I.S. (eds) Materialized views: techniques, implementations, and applications. The MIT Press, Cambridge, Mass., USA, 1999.

[15]

15. Gupta A., Mumick I.S., Subrahmanian V.S. Maintaining views incrementally. Proc. ACM SIGMOD 1993, pp 157-167.

[16]

16. Honeyman P. Extension joins. Proc. 6th VLDB 1980, pp 239- 244.

[17]

17. Huyn N. Multiple-view self-maintenance in data warehousing environments. Proc. 23rd VLDB 1997, pp 26-35.

[18]

18. Karp R.M. Reducibility among combinatorial problems. In: Complexity of computer computations. Plenum, New York, 1972, pp 85-103.

[19]

19. Laurent D., Lechtenbörger J., Spyratos N., Vossen G. Complements for data warehouses. Proc. 15th ICDE 1999, pp 490-499.

[20]

20. Levy A.Y., Mendelzon A., Sagiv Y., Srivastava D. Answering queries using views. Proc. 14th ACM PODS 1995, pp 95-104.

[21]

21. Levy A.Y., Sagiv Y. Queries independent of updates. Proc. 19th VLDB 1993, pp 171-181.

[22]

22. Liang W., Li H., Wang H., Orlowska M.E. Making multiple views self-maintainable in a data warehouse. DKE 30:121-134, 1999.

[23]

23. Mohania M.K., Kambayashi Y. Making aggregate views self-maintainable. DKE 32:87-109, 2000.

[24]

24. Mumick I.S., Quass D., Mumick B.S. Maintenance of data cubes and summary tables in a warehouse. Proc. ACM SIGMOD 1997, pp 100-111.

[25]

25. Quass D., Gupta A., Mumick I.S., Widom J. Making views self-maintainable for data warehousing. Proc. PDIS 1996.

[26]

26. Rajaraman A., Sagiv Y., Ullman J.D. Answering queries using templates with binding patterns. Proc. 14th ACM PODS 1995, pp 95-104.

[27]

27. Sagiv Y., Yannakakis M. Equivalences among relational expressions with the union and difference operators. JACM 27:633- 655, 1980.

[28]

28. Sen A., Jacob V.S. (eds) Industrial-strength data warehousing. CACM 41(9):28-69 1998.

[29]

29. Shu H. View maintenance using conditional tables. Proc. 5th DOOD 1997, Lecture Notes in Computer Sciance, vol. 1341. Springer, Berlin Heidelberg New York, 1997, pp. 67-84.

[30]

30. Transaction Processing Council. TPC Benchmark(tm) H (Decision Support), Standard Specification, Revision 1.2.1. San Jose, 1999. Available on the web under URL http://www.tpc.org/tpch

[31]

31. Ullman J.D. Principles of database and knowledge-base systems, vol I. Computer Science, New York, 1988.

[32]

32. Vossen G. Data models, database languages, and database management systems. Addison-Wesley, Reading, Mass., USA, 1991.

[33]

33. Widom J. (ed) Special issue on materialized views and data warehousing. IEEE Data Eng Bull 18(2), 1995.

[34]

34. Widom J. Research problems in data warehousing. Proc. 4th CIKM 1995.

[35]

35. Zhuge Y., Garcia-Molina H., Hammer J., Widom J. View maintenance in a warehousing environment. Proc. ACM SIGMOD 1995, pp 316-327.

[36]

36. Zhuge Y., Garcia-Molina H., Wiener J.L. Multiple view consistency for data warehousing. Proc. 13th ICDE 1997, pp 289-300.

Cited By

Sebaa A(2022)Parallel Maintenance of Materialized Views in Large-Scale Analytic PlatformsInternational Journal of Organizational and Collective Intelligence10.4018/IJOCI.30520912:1(1-19)Online publication date: 21-Jul-2022
https://dl.acm.org/doi/10.4018/IJOCI.305209
Tzitzikas Y(2018)Evolution of faceted taxonomies and CTCA expressionsKnowledge and Information Systems10.5555/3227215.322736113:3(337-365)Online publication date: 29-Dec-2018
https://dl.acm.org/doi/10.5555/3227215.3227361
Huang YDuy DFang C(2018)Efficient maintenance of basic statistical functions in data warehousesDecision Support Systems10.1016/j.dss.2013.08.00357(94-104)Online publication date: 31-Dec-2018
https://dl.acm.org/doi/10.1016/j.dss.2013.08.003
Show More Cited By

Index Terms

Monotonic complements for independent data warehouses
1. Information systems
2. Theory of computation
  1. Theory and algorithms for application domains
    1. Database theory
      1. Database query languages (principles)
      2. Database query processing and optimization (theory)

Recommendations

Finding an efficient rewriting of OLAP queries using materialized views in data warehouses

OLAP queries involve a lot of aggregations on a large amount of data in data warehouses. To process expensive OLAP queries efficiently, we propose a new method to rewrite a given OLAP query using various kinds of materialized views which already exist ...
Efficient maintenance of basic statistical functions in data warehouses

In general, some simple but very meaningful statistical functions are often used to retrieve valuable summary information in corporate databases. However, it is not uncommon that such information is obtained from computerized information systems which ...
Complements for Data Warehouses
ICDE '99: Proceedings of the 15th International Conference on Data Engineering

Views over databases have recently regained attention in the context of data warehouses, which are seen as materialized views. In this setting, efficient view maintenance is an important issue, for which the notion of self-maintainability has been ...

Comments

Information & Contributors

Information

Published In

cover image The VLDB Journal — The International Journal on Very Large Data Bases

The VLDB Journal — The International Journal on Very Large Data Bases Volume 10, Issue 4

December 2001

110 pages

ISSN:1066-8888

Issue’s Table of Contents

Publisher

Springer-Verlag

Berlin, Heidelberg

Publication History

Published: 01 December 2001

Author Tags

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

14
Total Citations
View Citations
654
Total Downloads

Downloads (Last 12 months)17
Downloads (Last 6 weeks)5

Reflects downloads up to 13 Jan 2025

Other Metrics

View Author Metrics

Citations

Cited By

Sebaa A(2022)Parallel Maintenance of Materialized Views in Large-Scale Analytic PlatformsInternational Journal of Organizational and Collective Intelligence10.4018/IJOCI.30520912:1(1-19)Online publication date: 21-Jul-2022
https://dl.acm.org/doi/10.4018/IJOCI.305209
Tzitzikas Y(2018)Evolution of faceted taxonomies and CTCA expressionsKnowledge and Information Systems10.5555/3227215.322736113:3(337-365)Online publication date: 29-Dec-2018
https://dl.acm.org/doi/10.5555/3227215.3227361
Huang YDuy DFang C(2018)Efficient maintenance of basic statistical functions in data warehousesDecision Support Systems10.1016/j.dss.2013.08.00357(94-104)Online publication date: 31-Dec-2018
https://dl.acm.org/doi/10.1016/j.dss.2013.08.003
Stanger N(2017)Characterising relational view updates using relative information capacityProceedings of the Australasian Computer Science Week Multiconference10.1145/3014812.3014847(1-10)Online publication date: 30-Jan-2017
https://dl.acm.org/doi/10.1145/3014812.3014847
Foster NMatsuda KVoigtländer J(2010)Three complementary approaches to bidirectional programmingProceedings of the 2010 international spring school conference on Generic and Indexed Programming10.1007/978-3-642-32202-0_1(1-46)Online publication date: 22-Mar-2010
https://dl.acm.org/doi/10.1007/978-3-642-32202-0_1
Gire FIdabal HDesai B(2008)Updates and views dependencies in semi-structured databasesProceedings of the 2008 international symposium on Database engineering & applications10.1145/1451940.1451963(159-168)Online publication date: 10-Sep-2008
https://dl.acm.org/doi/10.1145/1451940.1451963
Matsuda KHu ZNakano KHamana MTakeichi M(2007)Bidirectionalization transformation based on automatic derivation of view complement functionsACM SIGPLAN Notices10.1145/1291220.129116242:9(47-58)Online publication date: 1-Oct-2007
https://dl.acm.org/doi/10.1145/1291220.1291162
Matsuda KHu ZNakano KHamana MTakeichi MHinze RRamsey N(2007)Bidirectionalization transformation based on automatic derivation of view complement functionsProceedings of the 12th ACM SIGPLAN international conference on Functional programming10.1145/1291151.1291162(47-58)Online publication date: 3-Oct-2007
https://dl.acm.org/doi/10.1145/1291151.1291162
Rizzi SAbelló ALechtenbörger JTrujillo JSong IVassiliadis P(2006)Research in data warehouse modeling and designProceedings of the 9th ACM international workshop on Data warehousing and OLAP10.1145/1183512.1183515(3-10)Online publication date: 10-Nov-2006
https://dl.acm.org/doi/10.1145/1183512.1183515
Leung CLee W(2006)Efficient update of data warehouse views with generalised referential integrity differential filesProceedings of the 23rd British National Conference on Databases, conference on Flexible and Efficient Information Handling10.1007/11788911_17(199-211)Online publication date: 18-Jul-2006
https://dl.acm.org/doi/10.1007/11788911_17
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Article

Media

Figures

Other

Tables

View Issue’s Table of Contents