article

Aggregate Queries Over Conditional Tables

Authors:

Jens Lechtenbörger,

Hua Shu,

Gottfried VossenAuthors Info & Claims

Journal of Intelligent Information Systems, Volume 19, Issue 3

Pages 343 - 362

https://doi.org/10.1023/A:1020197923385

Published: 01 November 2002 Publication History

Publisher Site

Abstract

Conditional tables have been identified long ago as a way to capture unknown or incomplete information. However, queries over conditional tables have never been allowed to involve column functions such as aggregates. In this paper, the theory of conditional tables is extended in this direction, and it is shown that a strong representation system exists which has the closure property that the result of an aggregate query over a conditional table can be again represented by a conditional table. It turns out, however, that the number of tuples in a conditional table representing the result of an aggregate query may grow exponentially in the number of variables in the table. This phenomenon is analyzed in detail, and tight upper and lower bounds concerning the number of tuples contained in the result of an aggregate query are given. Finally, representation techniques are sketched that approximate aggregation results in tables of reasonable size.

References

[1]

Abiteboul, S. (1999). On views and XML. In Proc. 18th ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems, Philadelphia, Pensylvania, USA (pp. 1-9).

Digital Library

Google Scholar

[2]

Abiteboul, S., Hull, R., and Vianu, V. (1995). Foundations of Databases. Reading, MA: Addison-Wesley.

Digital Library

Google Scholar

[3]

Chamberlin, D. (1998). A Complete Guide to DB2 Universal Database. San Mateo, CA: Morgan Kaufmann.

Digital Library

Google Scholar

[4]

Grahne, G. (1991). The Problem of Incomplete Information in Relational Databases. Vol. 554 in Lecture Notes in Computer Science. Berlin: Springer-Verlag.

Digital Library

Google Scholar

[5]

Gray, J., Bosworth, A., Layman, A., and Pirahesh, H. (1996). Data Cube: A Relational Aggregation Operator Generalizing Group-by, Cross-Tab, and Sub-Total. In Proc. 12th International Conference on Data Engineering, New Orleans, Louisiana (pp. 152-159).

Digital Library

Google Scholar

[6]

Gupta, A., Harinarayan, V., and Quass, D. (1995). Aggregate-Query Processing in Data Warehousing Environments. In Proc. 21st International Conference on Very Large Data Bases, Zurich, Switzerland (pp. 358-369).

Digital Library

Google Scholar

[7]

Gupta, A. and Mumick, I.S. (1995). Maintenance of Materialized Views: Problems, Techniques, and Applications. Data Engineering Bulletin, 18(2), 3-18.

Google Scholar

[8]

Gupta, A., Mumick, I.S., and Subrahmanian, V.S. (1993). Maintaining Views Incrementally. In P. Buneman and S. Jajodia (Eds.), Proc. ACM SIGMOD International Conference on Management of Data, New York (pp. 157- 166). ACM Press.

Digital Library

Google Scholar

[9]

Imielinski, T. and Lipski, W.J. (1984). Incomplete Information in Relational Databases. Journal of the ACM, 31(4), 761-791.

Digital Library

Google Scholar

[10]

Laurent, D., Lechtenbörger, J., Spyratos, N., and Vossen, G. (1999). Complements for Data Warehouses. In Proc. 15th IEEE International Conference on Data Engineering, Sydney, Australia (pp. 490-499).

Digital Library

Google Scholar

[11]

Quass, D., Gupta, A., Mumick, I.S., and Widom, J. (1996). Making Views Self-Maintainable for Data Warehousing. In Proc. 4th International Conference on Parallel and Distributed Information Systems, Brüssel (pp. 158-169). IEEE Computer Society Press.

Digital Library

Google Scholar

[12]

Shu, H. (1997). View Maintenance Using Conditional Tables. In Proc. 5th International Conference on Deductive and Object-Oriented Databases, Montreux, Switzerland (pp. 67-84).

Digital Library

Google Scholar

Cited By

View all

Feng SGlavic BKennedy O(2023)Efficient Approximation of Certain and Possible Answers for Ranking and Window Queries over Uncertain DataProceedings of the VLDB Endowment10.14778/3583140.358315116:6(1346-1358)Online publication date: 20-Apr-2023
https://dl.acm.org/doi/10.14778/3583140.3583151
Feng SGlavic BHuber AKennedy OLi GLi ZIdreos SSrivastava D(2021)Efficient Uncertainty Tracking for Complex Queries with Attribute-level BoundsProceedings of the 2021 International Conference on Management of Data10.1145/3448016.3452791(528-540)Online publication date: 9-Jun-2021
https://dl.acm.org/doi/10.1145/3448016.3452791
Fink RHan LOlteanu D(2012)Aggregation in probabilistic databases via knowledge compilationProceedings of the VLDB Endowment10.14778/2140436.21404455:5(490-501)Online publication date: 1-Jan-2012
https://dl.acm.org/doi/10.14778/2140436.2140445
Show More Cited By

Index Terms

Aggregate Queries Over Conditional Tables

Recommendations

Extended conditions for answering an aggregate query using materialized views
Processing Aggregate Queries with Materialized Views in Data Warehouse Environment

Materialized views, which are derived from base relations and stored in the database, offer opportunities for significant performance gain in query evaluation by providing quick access to the pre-computed data. A materialized view can be utilized in ...
Answering ad hoc aggregate queries from data streams using prefix aggregate trees

In some business applications such as trading management in financial institutions, it is required to accurately answer ad hoc aggregate queries over data streams. Materializing and incrementally maintaining a full data cube or even its compression or ...

Comments

Information & Contributors

Information

Published In

Journal of Intelligent Information Systems Volume 19, Issue 3

November 2002

94 pages

ISSN:0925-9902

Issue’s Table of Contents

Publisher

Kluwer Academic Publishers

United States

Publication History

Published: 01 November 2002

Author Tags

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

12
Total Citations
View Citations
0
Total Downloads

Downloads (Last 12 months)0
Downloads (Last 6 weeks)0

Reflects downloads up to 09 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Feng SGlavic BKennedy O(2023)Efficient Approximation of Certain and Possible Answers for Ranking and Window Queries over Uncertain DataProceedings of the VLDB Endowment10.14778/3583140.358315116:6(1346-1358)Online publication date: 20-Apr-2023
https://dl.acm.org/doi/10.14778/3583140.3583151
Feng SGlavic BHuber AKennedy OLi GLi ZIdreos SSrivastava D(2021)Efficient Uncertainty Tracking for Complex Queries with Attribute-level BoundsProceedings of the 2021 International Conference on Management of Data10.1145/3448016.3452791(528-540)Online publication date: 9-Jun-2021
https://dl.acm.org/doi/10.1145/3448016.3452791
Fink RHan LOlteanu D(2012)Aggregation in probabilistic databases via knowledge compilationProceedings of the VLDB Endowment10.14778/2140436.21404455:5(490-501)Online publication date: 1-Jan-2012
https://dl.acm.org/doi/10.14778/2140436.2140445
Abiteboul SChan TKharlamov ENutt WSenellart P(2011)Capturing continuous data and answering aggregate queries in probabilistic XMLACM Transactions on Database Systems10.1145/2043652.204365836:4(1-45)Online publication date: 19-Dec-2011
https://dl.acm.org/doi/10.1145/2043652.2043658
Amsterdamer YDeutch DTannen VLenzerini MSchwentick T(2011)Provenance for aggregate queriesProceedings of the thirtieth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems10.1145/1989284.1989302(153-164)Online publication date: 13-Jun-2011
https://dl.acm.org/doi/10.1145/1989284.1989302
Herschel MHernández M(2010)Explaining missing answers to SPJUA queriesProceedings of the VLDB Endowment10.14778/1920841.19208693:1-2(185-196)Online publication date: 1-Sep-2010
https://dl.acm.org/doi/10.14778/1920841.1920869
Abiteboul SChan TKharlamov ENutt WSenellart P(2010)Aggregate queries for discrete and continuous probabilistic XMLProceedings of the 13th International Conference on Database Theory10.1145/1804669.1804679(50-61)Online publication date: 23-Mar-2010
https://dl.acm.org/doi/10.1145/1804669.1804679
Herschel MHernández MTan W(2009)ArtemisProceedings of the VLDB Endowment10.14778/1687553.16875882:2(1550-1553)Online publication date: 1-Aug-2009
https://dl.acm.org/doi/10.14778/1687553.1687588
Calvanese DKharlamov ENutt WThorne CElmasri RDoerr MBrochhausen MHan H(2008)Aggregate queries over ontologiesProceedings of the 2nd international workshop on Ontologies and information systems for the semantic web10.1145/1458484.1458500(97-104)Online publication date: 30-Oct-2008
https://dl.acm.org/doi/10.1145/1458484.1458500
Yamaguchi AShimizu SIshihara YFujiwara T(2008)Bag-based data models for incomplete information and their closure propertiesJournal of Intelligent Information Systems10.1007/s10844-006-0020-130:2(115-135)Online publication date: 1-Apr-2008
https://dl.acm.org/doi/10.1007/s10844-006-0020-1
Show More Cited By

Abstract

References

Cited By

Index Terms

Recommendations

Extended conditions for answering an aggregate query using materialized views

Processing Aggregate Queries with Materialized Views in Data Warehouse Environment

Answering ad hoc aggregate queries from data streams using prefix aggregate trees

Comments

Information

Published In

Publisher

Publication History

Author Tags

Qualifiers

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

View options

Figures

Other

Share

Share this Publication link

Share on social media

Affiliations