Data currency quality satisfaction in the design of a data warehouse

International Journal of Cooperative Information Systems

Volumn 10, Issue 3, 2001, Pages 299-326

  Theodoratos, Dimitri ^a   Bouzeghoub, Mokrane ^a  

^a NONE

Author keywords

Currency constraints; Data warehouse design; Data warehousing; Materialized views; Quality goals

Indexed keywords

EID: 0035644582     PISSN: 02188430     EISSN: None     Source Type: Journal    
DOI: 10.1142/S0218843001000369     Document Type: Article

References (53)

1. S. Chaudhuri and U. Dayal, An overview of data warehousing and OLAP technology, SIGMOD Record 26 (1997) 65-74.
2. J. Widom, Research problems in data warehousing, Proc. 4th Int. Conf. Inf. Knowledge Management, (November 1995) 25-30.
3. N. Roussopoulos, View indexing in relational databases, ACM Trans. Database Syst. 7, 2 (1982) 258-290.
4. V. Harinarayan, A. Rajaraman and J. D. Ullman, Implementing data cubes efficiently, Proc. ACM SIGMOD Int. Conf. Management Data, 1996.
5. D. Theodoratos and T. Sellis, Data warehouse configuration, Proc. 23rd Int. Conf. Very Large Data Bases (1997) 126-135.
6. H. Gupta and I. S. Mumick, Selection of views to materialize under a maintenance cost constraint, Proc. 7th Int. Conf. Database Theory (1999) 453-470.
7. M. Jarke, M. Jeusfeld, C. Quix and P. Vassiliades, Architecture and quality in data warehouses, Proc. 10th Int. Conf. Adv. Inf. Syst. Eng. (1997) 93-113.
8. M. Jeusfeld, C. Quix, and M. Jarke. Design and analysis of quality information for data warehouses, Proc. 17th Int. Conf. Conceptual Modeling, Springer Lecture Notes in Computer Science 1507 (Springer, 1998) 349-362.
9. M. Jarke and Y. Vassiliou, Data warehouse quality: A review of the DWQ project, Proc. 2nd Int. Conf. Inf. Quality (Cambridge, MA, 1997) 98-112.
10. J. Yang, K. Karlapalem and Q. Li, Algorithms for materialized view design in data warehousing environment, Proc. 23rd Int. Conf. Very Large Data Bases (1997) 136-145.
11. A. Segev and W. Fang, Currency-based updates to distributed materialized views, Proc. 6th Int. Conf. Data Eng. (1990) 512-520.
12. R. Hull and G. Zhou, A framework for supporting data integration using the materialized and virtual approaches, Proc. ACM SIGMOD Int. Conf. Management Data, (1996) 481-492.
13. A. Levy, A. O. Mendelson, Y. Sagiv and D. Srivastava, Answering queries using views, Proc. ACM Symp. Principles Database Syst. (1995) 95-104.
14. D. Theodoratos, S. Ligoudistianos and T. Sellis, Designing the global data warehouse with SPJ views, Proc. 11th Int. Conf. Adv. Inf. Syst. Eng., Lecture Notes in Computer Science 1626 (Spring-Verlag, 1999) 180-194.
15. A. Gupta and I. S. Mumick, Maintenance of materialized views: Problems, techniques and applications, Data Eng. 18, 2 (1995) 3-18.
16. G. Zhou, R. Hull, R. King and J.-C. Franchitti, Supporting data integration and warehousing using H20, Data Eng., 18, 2 (1995) 29-40.
17. J. A. Blakeley, P. Larson and F. W. Tompa, Efficiently updating materialized views, Proc. ACM SIGMOD Int. Conf. Management Data (1986) 61-71.
18. X. Qian and Gio Wiederhold, Incremental recomputation of active relational expressions, IEEE Trans. Knowledge Data Eng. 3, 3 (1991) 439-450.
19. A. Gupta, I. S. Mumick and V. S. Subrahmanian, Maintaining views incrementally, Proc. ACM SIGMOD Int. Conf. Management Data (1993) 157-166.
20. T. Griffin and L. Libkin, Incremental maintenance of views with duplicates, Proc. ACM SIGMOD Int. Conf. Management Data (1995) 328-339.
21. D. Quass, Maintenance expressions for views with aggregation, Workshop on Materialized Views: Techniques and Applications (1996) 110-118.
22. M. Staudt and M. Jarke, Incremental maintenance of externally materialized views, Proc. 22nd Int. Conf. Very Large Data Bases (1996) 75-86.
23. L. Colby, A. Kawagushi, D. Lieuwen, I. S. Mumick and K. Ross, Supporting multiple view maintenance policies, Proc. ACM SIGMOD Int. Conf. Management Data, 1997.
24. Y. Zhuge, H. Garcia-Molina, J. Hammer and J. Widom, View maintenance in a warehousing environment, Proc. ACM SIGMOD Int. Conf. Management Data (1995) 316-327.
25. S. Ceri and J. Widom, Deriving production rules for incremental view maintenance, Proc. Int. Conf. Very Large Data Bases (1991) 577-589.
26. L. Colby, T. Griffin, L. Libkin, I. S. Mumick and H. Trickey, Algorithms for deferred view maintenance, Proc. ACM SIGMOD Int. Conf. Management Data (1996) 469-480.
27. A. Segev and J. Park, Updating distributed materialized views, IEEE Trans. Knowledge Data Eng. 1, 2 (1989) 173-184.
28. E. Hanson, A performance analysis of view materialization strategy, Proc. ACM SIGMOD Int. Conf. Management Data (1987) 440-453.
29. Y. Zhuge, H. Garcia-Molina and J. Wiener, The strobe algorithms for multi-source warehouse consistency, Proc. 4th Int. Conf. Parallel Distributed Inf. Syst. 1996.
30. Y. Zhuge, J. Wiener and H. Garcia-Molina, Multiple view consistency for data warehousing, Proc. 13th Int. Conf. Data Eng. (1997) 289-300.
31. F. Llirbat, E. Simon and D. Tombroff, Using versions in update transactions, Proc. 23rd Int. Conf. Very Large Data Bases (1997) 96-105.
32. W. J. Labio and H. Garcia-Molina, Efficient snapshot differential algorithms for data warehousing, Proc. 22nd Int. Conf. Very Large Data Bases (1996) 63-74.
33. J. Wiener, H. Gupta, W. Labio, Y. Zhuge, H. Garcia-Mollina and J. Widom, A system prototype for warehouse view maintenance, Workshop on Materialized Views: Techniques and Applications, 1996.
34. M. Jarke, Common subexpression isolation in multiple query optimization, eds. W. Kim, D. S. Reiner and D. S Batory, Query Processing in DB System (Springer 1985) 191-205.
35. T. K. Sellis, Multiple query optimization, ACM Trans. Database Syst. 13, 1 (1988) 23-52.
36. K. Shim, Timos K. Sellis and D. Nau, Improvements on a heuristic algorithm for multiple-query optimization, Data Knowledge Eng. 12, (1994) 197-222.
37. K. A. Ross, D. Srivastava and S. Sudarshan, Materialized view maintenance and integrity constraint checking: Trading space for time, Proc. ACM SIGMOD Int. Conf. Management Data (1996) 447-458.
38. D. Theodoratos and T. Sellis, Designing data warehouses, Data Knowledge Eng. 31, 3 (October 1999) 279-301.
39. A. Gupta, H.V. Jagadish and I. S. Mumick, Data integration using self-maintainable views, Proc. 5th Int. Conf. Extending Database Tech. (1996) 140-144.
40. D. Quass, A. Gupta, I. S. Mumick and J. Widom, Making views self maintainable for data warehousing, Proc. 4th Int. Conf. Parallel Distributed Inf. Syst. (1996) 158-169.
41. J. A. Blakeley, N. Coburn and P. A. Larson, Updating derived relations: Detecting irrelevant and autonomously computable updates, ACM Trans. Database Syst. 14, 3 (1989) 369-400.
42. A. Y. Levy and Y. Sagiv, Queries independent of updates, Proc. 19th Int. Conf. Very Large Data Bases (1993) 171-181.
43. H. Gupta, Selection of views to materialize in a data warehouse, Proc. 6th Int. Conf. Database Theory (1997) 98-112.
44. G. Graefe and W. J. McKenna. The volcano optimizer generator: Extensibility and efficient search, Proc. 9th Int. Conf. Data Eng. (1993) 209-217.
45. D. Theodoratos and T. Sellis, Incremental design of a data warehouse, J. Intell. Inf. Syst. 15, 1 (Kluwer Academic Publishers, 2000) 7-27.
46. W. Yan and P.-Å. Larson, Performing group-by before join, Proc. 10th Int. Conf. Data Eng. (1994) 89-100.
47. N. Roussopoulos, The logical access path schema of a database, IEEE Trans. Software Eng. 8, 2 (1982) 563-573.
48. W. J. Labio, R. Yerneni and H. Garcia-Molina, Shrinking the warehouse update window, Proc. 25nd Int. Conf. Very Large Data Bases (1999) 383-394.
49. D. Theodoratos, Detecting redundancy in data warehouse evolution, Proc. 18th Int. Conf. Conceptual Modeling, Lecture Notes in Computer Science 1728, (Springer, 1999) 340-353.
50. A. Gupta, V. harinarayan and D. Quass, Aggregate-query processing in data warehousing environments, Proc. 21st Int. Conf. Very Large Data Bases (1995) 358-369.
51. S. Dar, H. V. Jagadish, A. Y. Levy and D. Srivastava, Answering SQL queries with aggregation using views, Proc. 22nd Int. Conf. Very Large Data Bases (1996) 318-329.
52. D. Calvanese, G. DeGiacomo, M. Lenzerini, D. Nardi and R. Rosati, A principled approach to data integration and reconciliation, Proc. Int. Workshop Design Management Data Warehouses, Germany, 1999.
53. J. Srivastava and D. Rotem, Analytical modeling of materialized view maintenance, Proc. 5th ACM Symp. Principles Database Systems (1988) 126-134.