GPIVOT: Efficient incremental maintenance of complex ROLAP views

Proceedings - International Conference on Data Engineering

Volumn , Issue , 2005, Pages 552-563

  Chen, Songting ^a   Rundensteiner, Elke A ^a  

^a WORCESTER POLYTECHNIC INSTITUTE   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

DATA VOLUMES; ON-LINE ANALYTICAL PROCESSING;

MATHEMATICAL OPERATORS; MATHEMATICAL TRANSFORMATIONS; OPTIMIZATION; QUERY LANGUAGES;

DATA PROCESSING;

EID: 28444447954     PISSN: 10844627     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/ICDE.2005.71     Document Type: Conference Paper

References (18)

1. R. Agrawal, A. Somani, and Y. Xu. Storage and Querying of E-Commerce Data. In Proceedings of VLDB, pages 149-158, 2001.
2. R. G. Bello, K. Dias, A. Downing, J. J. F. Jr., J. L. Finnerty, W. D. Norcott, H. Sun, A. Witkowski, and M. Ziauddin. Materialized Views in Oracle. In Proceedings of VLDB, pages 659-664, 1998.
3. S. Chaudhuri and U. Dayal. An Overview of Data Warehousing and OLAP Technology. SIGMOD Record, 26(1):65-74, 1997.
4. S. Chen and E. A. Rundensteiner. GPIVOT: Efficient Incremental Maintenance of Complex ROLAP Views. Technical Report, 2004. http://davis.wpi. edu/dsrg/dsrg-all-pubs.html.
5. L. S. Colby, T. Griffin, L. Libkin, I. S. Mumick, and H. Trickey. Algorithms for Deferred View Maintenance. In Proceedings of SIGMOD, pages 469-480, 1996.
6. N. Colossi, W. Malloy, and B. Reinwald. Relational Extensions for OLAP. IBM System Journal, Vol 41, No 4, 2002.
7. C. Cunningham, G. Graefe, and C. A. Galindo-legaria. PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS. In Proceedings of VLDB, pages 998-1009, 2004.
8. R. Elmasri and S. B. Navathe. Fundamental of Database Systems. Benjamin/Cummings, 1989.
9. J. Gray, A. Bosworth, A. Layman, and H. Pirahesh. Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Total. In Proceedings of ICDE, pages 152-159, 1996.
10. T. Griffin and L. Libkin. Incremental Maintenance of Views with Duplicates. In Proceedings of SIGMOD, pages 328-339, 1995.
11. A. Gupta, I. S. Mumick, and V. S. Subrahmanian. Maintaining Views Incrementally. In Proceedings of SIGMOD, pages 157-166, 1993.
12. A. Koeller and E. A. Rundensteiner. Incremental Maintenance of Schema-Restructuring Views. In Proceedings of EDBT, pages 354-371, 2002.
13. L. V. S. Lakshmanan, F. Sadri, and S. N. Subramanian. On Efficiently Implementing SchemaSQL on an SQL Database System. In Proceedings of VLDB, pages 471-482, 1999.
14. W. Lehner, R. Sidle, H. Pirahesh, and R. Cochrane. Maintenance of Automatic Summary Tables. In Proceedings of SIGMOD, pages 512-513, 2000.
15. Microsoft SQL Server (Yukon). http://www.microsoft.com/sql/yukon.
16. I. Mumick, D. Quass, and B. Mumick. Maintenance of Data Cubes and Summary Tables in a Warehouse. In Proceedings of SIGMOD, pages 100-111, May 1997.
17. D. Quass. Maintenance Expressions for Views with Aggregation. In Proceedings of the Workshop on Materialized Views: Techniques and Applications, pages 110-118, 1996.
18. K. Salem, K. S. Beyer, R. Cochrane, and B. G. Lindsay. How To Roll a Join: Asynchronous Incremental View Maintenance. In Proceedings of SIGMOD, pages 129-140, 2000.