Self-maintainable data warehouse views using differential files

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

Volumn 2453, Issue , 2002, Pages 216-225

  Wookey, Lee ^a   Hwang, Yonghun ^b   Kang, Suk Ho ^b   Kim, Sanggeun ^a   Kim, Changmin ^a   Lee, Yunsun ^a  

^a Sungkyul University   (South Korea)

^b Seoul National University   (South Korea)

Author keywords

Data warehouse; Differential file; Materialized view; Selfmaintenance

Indexed keywords

CONCURRENCY CONTROL; EXPERT SYSTEMS;

ALGEBRAIC APPROACHES; DIFFERENTIAL FILE; DIFFERENTIAL METHODS; INCREMENTAL UPDATES; MATERIALIZED VIEW; SELF-MAINTENANCE; SUPPLEMENTARY DATA; VIEW MAINTENANCE;

DATA WAREHOUSES;

EID: 84949803773     PISSN: 03029743     EISSN: 16113349     Source Type: Book Series    
DOI: 10.1007/3-540-46146-9_22     Document Type: Conference Paper

References (35)

1. Agrawal, D., Abbadi, A.E., Singh, A.K. and Yurek, T.: Efficient View Maintenance in Data Warehouses, ACM SIGMOD, (1997) 417-427
2. Blakeley, J., Larson, P. and Tompa, F.: Efficiently Updating Materialized Views, ACM SIGMOD, Washington D.C., (1986) 61-71
3. Ceri, S., Cochrane, R.J. and Widom, J.: Practical Application of Triggers and Constraints: Successes and Lingering Issues, Proc. of the 26th VLDB conference, Egypt, (2000) 254-262
4. Chen, J and Rundensteiner, E.A.: TxnWrap: A Transactional Approach to Data Warehouse Maintenance, CS Technical Report WPI-CS-TR-00-26 (2000)
5. Ceri, S. and Widom, J.: Deriving production rules for incremental view maintenance, In Proc. the 7th Int’l Conf. on VLDB, Spain, September (1991) 577-589
6. Gupta, A. and Blakeley, J.: Using partial information to update a materialized view, Information Systems, Vol. 20, No. 8 (1995) 641-662
7. Gray, J., Chaudhuri, S., Bosworth, A., Layman, A., Reichart, D., Venkatrao, M., Pellow, R. and Pirahesh, H.: Data Cube: A Relational Aggregation Operator Generalizing Group-by, Cross-Tab, and Sub-Totals, Data Mining and Knowledge Discovery, Vol. 1 (1997) 29-53
8. Griffin, T., Libkin, L. and Trickey, H.: An Improved Algorithm for the Incremental Recomputation of Active Relational Expressions, IEEE TKDE, Vol. 9, No. 3 May-June (1997) 508-511
9. Gupta, A. and Mumick I. S.: Maintenance of Materialized Views: Problems, Techniques, and Applications. IEEE Data Engineering Bulletin, 18(2), June (1995)
10. Gupta, H. and Mumick, I.S.: Incremental Maintenance of Aggregate and Outer-join Expressions, Technical report, Stanford University (1999)
11. Harinarayan, V., Rajaraman, A. and Ullman, J.: Implementing data cubes efficiently, In SIGMOD, Montreal, Canada, June (1996) 205-216
12. Huyn, N.: Maintaining Data Warehouse Under Limited Source Access, Ph.D. thesis, Stanford University, August (1997)
13. Kim, Y., Wookey, L., Kim, J. and Kim, S.: Efficient View Maintenance with Consistency at Data Warehouse Environment, Proc. INFORMS, Seoul, Korea (2000) 1935-1941
14. Kotidis, Y. and Roussopoulos, N.: A Case for Dynamic View Management, ACM TODS, Vol. 26, No. 4 (2001) 388-423
15. Laurent, D., Lechtenborger, J., Spyratos, N. and Vossen, G.: Complements for Data Warehouses, Proc. the 15th ICDE (1999)
16. Mohania, M. and Kambayashi, Y.: Making Aggregate Views Self-Maintainable, Data and Knowledge Engineering, Vol. 32, No. 1 (2000) 7-109
17. Mumick, I., Quass, D. and Mumick, B.: Maintenance of Data Cubes and Summary Tables in a Warehouse, ACM SIGMOD, Tuscon, Arizona, May (1997)
18. O'Gorman, K., Agrawal, D. and Abbadi, A.E.: Posse: A Framework for Optimizing Incremental View Maintenance at Data Warehouses, In DaWaK 99 (1999) 106-115
19. Quass, D., Gupta, A., Mumick, I. and Widom, J.: Making Views Self-Maintainable for Data Warehousing, Proc. Parallel and Distributed Information Systems, Miami, FL (1996)
20. Quass, D.: Materialized Views in Data Warehouses, Ph.D. thesis, Stanford Univ., Department of Computer Science (1997)
21. Quian, X. and Wiederhold, G.: Incremental Recomputation of Active Relational Expressions,” IEEE TKDE, Vol. 3, No. 3 (1991) 337-341
22. Segev, A. and Park, J.: Updating Distributed Materialized Views, IEEE TKDE, Vol. 1, No. 2, June (1989) 173-184
23. Theodoratos, D. and Bouzeghoub, M.: A General Framework for the View Selection Problem for Data Warehouse Design and Evolution, Proc. the ACM workshop on Data Warehousing and OLAP (2000) 1-8
24. Tompa, F. W. and Blakeley, J. A.: Maintaining Materialized Views Without Accessing Base Data, Information Systems, Vol. 13, No. 4 (1988) 393-406
25. http://www.tpc.org/
26. Vincent, M., Mohania, M. and Kambayashi, Y.: A Self Maintainable View Maintenance Technique for Data Warehouses, ACM SIGMOD (1997) 7-22
27. Widom, J.: Research Problems in Data Warehousing," Fourth Intl. Conf. on Information and Knowledge Management (1995) 25-30
28. Wookey, L.: On the Independence of Data Warehouse from Databases in Maintaining Join Views, In DaWak99, LNCS, Springer Verlag Vol. 1676 (1999)
29. Wookey, L., Park, J. and Kang, S.: Replication Server Scheme in Distributed Database Systems, Proc. of `96APDSI conference, Vol. 3 (1996) 1275-1282
30. Wookey, L., Park, J. and Kang, S.: A Distributed Join Data Replicator, Journal of Computer Information Systems, Vol. 38, No. 4 (1998) 108-116
31. Wookey, L., Park, J. and Kang, S.: An Asynchronous Differential Join in Distributed Data Replications, Journal of Database Management, Vol. 10, No. 3 Idea-Group Pub. (1999) 3- 12
32. Yang, J. and Widom, J.: Temporal View Self-Maintenance in a Warehousing Environment, Proc. 8th Int. Conf. EDBT2000, LNCS 1777, (2000) 395-412
33. Zhuge, Y., Garcia-Molina, H., Hammer, J. and Widom, J.: View Maintenance in a Warehousing Environment, ACM SIGMOD, (1995) 316-327
34. Zhuge, Y., Garcia-Molina, H. and Wiener, J.L.: The Strobe Algorithms for Multi-Source Warehouse Consistency, Conf. on Parallel and Distributed Information Systems (1996) 146-157
35. Zhang, x. and Rundensteiner, E.A.: Psweep: Parallel view maintenance under concurrent data updates of distributed sources," Technical Report WPI-CS-TR-99-14, Worcester Polytechnic Institute, Computer Science Department, Worcester, MA (1999)