A survey on temporal data warehousing

International Journal of Data Warehousing and Mining

Volumn 5, Issue 1, 2009, Pages 1-17

  Golfarelli, Matteo ^a   Rizzi, Stefano ^a  

^a UNIVERSITY OF BOLOGNA   (Italy)

Author keywords

Business intelligence; Data mart; Data warehouse; Multidimensional database design; Spatiotemporal database

Indexed keywords

COMPETITIVE INTELLIGENCE; DATA WAREHOUSES; DECISION MAKING; QUERY PROCESSING; SURVEYS;

COMMERCIAL TOOLS; DATA MART; DATA WAREHOUSING SYSTEMS; HISTORICAL TRENDS; INFORMATION REPOSITORIES; MULTIDIMENSIONAL DATABASE; SPATIO-TEMPORAL DATABASE; TEMPORAL DATABASE;

DATA HANDLING;

EID: 70249117074     PISSN: 15483924     EISSN: 15483932     Source Type: Journal    
DOI: 10.4018/jdwm.2009010101     Document Type: Review

References (57)

1. Abelló, A., & Martín, C. (2003). A Bi-temporal Storage Structure for a Corporate Data Warehouse. Proceedings International Conference on Enterprise Information Systems, Angers, France, 177-183.
2. Bellahsene, Z. (1998). View Adaptation in Data Warehousing Systems. Proceedings International Conference on Database and Expert Systems Applications, Vienna, Austria, 300-309.
3. Bellahsene, Z. (2002). Schema Evolution in Data Warehouses. Knowledge and Information Systems, 4(3), 283-304.
4. Blaschka, M. (2000). FIESTA - A Framework for Schema Evolution in Multidimensional Databases. PhD Thesis, Technische Universitat Munchen, Germany.
5. Blaschka, M., Sapia, C., & Höfling, G. (1999). On Schema Evolution in Multidimensional Databases. Proceedings International Conference on Data Warehousing and Knowledge Discovery, Florence, Italy, 153-164.
6. Bliujute, R., Saltenis, S., Slivinskas, G., & Jensen, C. S. (1998). Systematic Change Management in Dimensional Data Warehousing. Proceedings International Baltic Workshop on Databases and Information Systems, Riga, Latvia, 27-41.
7. Body, M., Miquel, M., Bédard, Y., & Tchounikine, A. (2003). Handling Evolutions in Multidimensional Structures. Proceedings International Conference on Data Engineering, Bangalore, India, 581-591.
8. Bruckner, R., & Tjoa, A. (2002). Capturing Delays and Valid Times in Data Warehouses - Towards Timely Consistent Analyses. Journal of Intelligent Information Systems, 19(2), 169-190.
9. Chamoni, P. & Stock, S. (1999). Temporal Structures in Data Warehousing. Proceedings International Conference on Data Warehousing and Knowledge Discovery, Florence, Italy, 353-358.
10. Chen, S., Zhang, X., & Rundensteiner, E. (2006). A Compensation-Based Approach for View Maintenance in Distributed Environments. IEEE Transactions of Knowledge and Data Engineering, 18(8), 1068-1081. (Pubitemid 44109536)
11. Combi, C. & Oliboni, B. (2007). Temporal semistructured data models and data warehouses. In Data Warehouses and OLAP: Concepts, Architectures and Solutions, Wrembel & Koncilia (Eds.), IRM Press, 277-297.
12. De Amo, S., & Halfeld Ferrari Alves, M. (2000). Efficient Maintenance of Temporal Data Warehouses. Proceedings International Database Engineering and Applications Symposium, Yokohoma, Japan 188-196.
13. Devlin, B. (1997). Managing Time In The Data Warehouse. InfoDB, 11(1), 7-12.
14. Eder, J., & Koncilia C. (2001). Changes of Dimension Data in Temporal Data Warehouses. Proceedings International Conference on Data Warehousing and Knowledge Discovery, Munich, Germany, 284-293.
15. Eder, J., Koncilia, C., & Morzy, T. (2002). The COMET Metamodel For Temporal Data Warehouses. Proceedings International Conference on Advanced Information Systems Engineering, Toronto, Canada, 83-99.
16. Fan, H., & Poulovassilis, A. (2004). Schema Evolution in Data Warehousing Environments - A Schema Transformation-Based Approach. Proceedings International Conference on Conceptual Modeling, Shanghai, China, 639-653.
17. Feng, Y., Li, H.-G., Agrawal, D., & El Abbadi, A. (2005). Exploiting Temporal Correlation in Temporal Data Warehouses. Proceedings International Conference on Database Systems for Advanced Applications, Beijing, China, 662-674.
18. Golfarelli, M. & Rizzi, S. (1999). Designing the data warehouse: key steps and crucial issues. Journal of Computer Science and Information Management, 2(1), 1-14.
19. Golfarelli, M., Lechtenbörger, J. Rizzi, S., & Vossen, G. (2006). Schema Versioning in Data Warehouses: Enabling Cross-Version Querying via Schema Augmentation. Data and Knowledge Engineering, 59(2), 435-459.
20. Golfarelli, M. & Rizzi, S. (2007a). X-Time: Schema Versioning and Cross-Version Querying in Data Warehouses. Proceedings International Conference on Data Engineering, Istanbul, Turkey, 1471-147.
21. Golfarelli, M. & Rizzi, S. (2007b). Managing late measurements in data warehouses. International Journal of Data Warehousing and Mining, 3(4), 51-67.
22. Grandi, F. (2002). A Relational Multi-Schema Data Model and Query Language for full Support of Schema Versioning. Proceedings SEBD, Portoferraio, Italy, 323-336.
23. Gupta, A., & Mumick, I. S. (1995). Maintenance of materialized views: problems, techniques, and applications. Data Engineering Bulletin, 18(2), 3-18.
24. Hurtado, C., Mendelzon, A., & Vaisman, A. (1999a). Maintaining Data Cubes under Dimension Updates. Proceedings International Conference on Data Engineering, Sydney, Austrialia, 346-355.
25. Hurtado, C., Mendelzon A., & Vaisman A. (1999b). Updating OLAP Dimensions. Proceedings International Workshop on Data Warehousing and OLAP, Kansas City, USA, 60-66.
26. Inmon, W. (1996). Building the data warehouse. John Wiley & Sons.
27. Jarke, M., Jeusfeld, M., Quix, C., & Vassiliadis, P. (1999). Architecture and Quality in Data Warehouses: An Extended Repository Approach. Information Systems, 24(3), 229-253.
28. Jensen, C., Clifford, J., Elmasri, R., Gadia, S. K., Hayes, P. J., & Jajodia, S. (1994). A Consensus Glossary of Temporal Database Concepts. ACM SIGMOD Record, 23(1), 52-64.
29. Kaas, C., Pedersen, T. B., & Rasmussen, B. (2004). Schema Evolution for Stars and Snowflakes. Proceedings International Conference on Enterprise Information Systems, Porto, Portugal, 425-433.
30. Kimball, R. (1996). The Data Warehouse Toolkit. Wiley Computer Publishing.
31. Kimball, R. (2000). Backward in Time. Intelligent Enterprise Magazine, 3(15).
32. Koncilia, C. (2003). Bi-Temporal Data Warehouse Model. Short Paper Proceedings Conference on Advanced Information Systems Engineering, Klagenfurt/ Velden, Austria.
33. Lee, A., Nica, A., & Rundensteiner, E. (2002). The EVE Approach: View Synchronization in Dynamic Distributed Environments. IEEE Transactions on Knowledge and Data Engineering, 14(5), 931- 954.
34. Lenz, H. J. & Shoshani, A. (1997). Summarizability in OLAP and Statistical Databases. Proceedings Statistical and Scientific Database Management Conference, Olympia, US, 132-143.
35. Letz, C., Henn, E., & Vossen, G. (2002). Consistency in Data Warehouse Dimensions. Proceedings International Database Engineering and Application Symposium, Edmonton, Canada, 224-232.
36. Malinowski, E. & Zimányi, E. (2008). A conceptual model for temporal data warehouses and its transformation to the ER and the object-relational models. Data & Knowledge Engineering, 64, 101-133.
37. McKenzie, E., & Snodgrass, R. (1990). Schema Evolution and the Relational Algebra. Information Systems, 15(2), 207-232.
38. Mendelzon, A., & Vaisman, A. (2000). Temporal queries in OLAP. Proceedings Conference on Very Large Data Bases, Cairo, Egypt, 242-253.
39. Morzy, T. & Wrembel, R. (2004). On querying versions of multiversion data warehouse. Proceedings International Workshop on Data Warehousing and OLAP, Washington, DC, 92-101.
40. Pedersen, T. B., & Jensen, C. (1998). Research Issues in Clinical Data Warehousing. Proceedings Statistical and Scientific Database Management Conference, Capri, Italy, 43-52.
41. Pedersen, T. B. & Jensen, C. (1999). Multidimensional Data Modeling for Complex Data. Proceedings International Conference on Data Engineering, Sydney, Austrialia, 336-345.
42. Quix, C. (1999). Repository Support for Data Warehouse Evolution. Proceedings International Workshop on Design and Management of Data Warehouses, Heidelberg, Germany.
43. Ravat, F., Teste, O., & Zurfluh, G. (2006). A Multiversion- Based Multidimensional Model. Proceedings International Conference on Data Warehousing and Knowledge Discovery, 65-74.
44. Rechy-Ramírez E.-Jrez, E.-J. ́ Benítez-Guerrero, E. (2006). A Model and Language for Bi-temporal Schema Versioning in DataWarehouses. Proceedings International Conference on Computing, Mexico City, Mexico.
45. Riedewald, M., Agrawal, D. & El Abbadi, A. (2002). Efficient integration and aggregation of historical information. Proceedings SIGMOD Conference, Madison, Wisconsin, 13-24.
46. Rizzi, S., Abelló, A., Lechtenbörger, J., & Trujillo, J. (2006). Research in Data Warehouse Modeling and Design: Dead or Alive? Proceedings International Workshop on Data Warehousing and OLAP, Arlington, USA, 3-10.
47. Roddick, J. (1995). A Survey of Schema Versioning Issues for Database Systems. Information and Software Technology, 37(7), 383-393.
48. SAP Institute (2000). Multi-dimensional Modeling with SAP BW. SAP America Inc. and SAP AG.
49. Sarda, N. L. (1999). Temporal Issues in Data Warehouse Systems. Proceedings International Symposium on Database Applications in Non-Traditional Environments, Kyoto, Japan, 27-34.
50. Tansel, A. U., Clifford, J., Gadia, S. K., Jajodia, S., Segev, A., & Snodgrass, R. T. (1993). Temporal databases: theory, design and implementation. Benjamin Cummings.
51. Snodgrass, R. T. (1995). The TSQL2 Temporal Query Language. Kluwer Academic Publishers.
52. Tao, Y., Papadias, D., & Faloutsos, C. (2004). Approximate Temporal Aggregation. Proceedings International Conference on Data Engineering, Boston, Massachusetts, 190-201.
53. Vaisman, A., Mendelzon, A., Ruaro, W., & Cymerman, S. (2004). Supporting Dimension Updates in an OLAP Server. Information Systems, 29, 165-185.
54. Vaisman, A., & Mendelzon, A. (2001). A Temporal Query Language for OLAP: Implementation and a Case Study. Proceedings DBPL.
55. Wrembel, R. & Bebel, B. (2007). Metadata Management in a Multiversion Data Warehouse. Journal of Data Semantics, 8, 118-157.
56. Yang, J. & Widom, J. (1998). Maintaining Temporal Views over Non-Temporal Information Sources for Data Warehousing. Proceedings International Conference on Extending Database Technology, Valencia, Spain, 389-403.
57. Yang, J. & Widom, J. (2001). Incremental Computation and Maintenance of Temporal Aggregates. Proceedings International Conference on Data Engineering, Heidelberg, Germany, 51-60.