Abstract
Previous research has provided metadata models that enable the capturing of the static components of a Data Warehouse (DW) architecture, along with information on different quality factors over these components. This paper complements this work with the modeling of the dynamic parts of the DW, i.e., with a metamodel for DW operational processes. The proposed metamodel is capable of modeling complex activities, their interrelationships, and the relationship of activities with data sources and execution details. Finally, the metamodel complements proposed architecture and quality models in a coherent fashion, resulting in a full framework for DW metamodeling, capable of supporting the design, administration and evolution of a DW. We have implemented this metamodel using the language Telos and the metadata repository system ConceptBase.
Chapter PDF
Similar content being viewed by others
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
References
Z. Bellahsène. Structural View Maintenance in Data Warehousing Systems. Journées Bases de Données Avancées (BDA’ 98), Tunis, October 1998.
M. Bouzeghoub, F. Fabret, M. Matulovic. Modeling Data Warehouse Refreshment Process as a Workflow Application. Workshop on Design and Management of Data Warehouses (DMDW’99), Heidelberg, Germany, 1999.
F. Casati, S. Ceri, B. Pernici, G. Pozzi. Conceptual Modeling of Workflows. Conf. On Object-Oriented and Entity-Relationship Modelling (OOER’95), Australia, 1995.
D. Calvanese, G. De Giacomo, M. Lenzerini, D. Nardi, R. Rosati. A principled approach to data integration and reconciliation in data warehousing. Workshop on Design and Management of Data Warehouses (DMDW’99), Heidelberg, 1999.
Richard A. Ganski, Harry K. T. Wong. Optimization of Nested SQL Queries Revisited. In Proc. of ACM SIGMOD Conference, San Francisco, pp. 23–33, 1987
D. Georgakopoulos, M. Hornick, A. Sheth. An overview of workflow management: From process modeling to workflow automation infrastructure. Distributed and parallel databases, 3(2):119–153, 1995.
D. Georgakopoulos, M. Rusinkiewicz. Workflow management: From business process automation to inter-organizational collaboration. Tutorials of the 23rd International Conference on Very Large Data Bases, Athens, Greece, 1997.
A. Gupta, I. Mumick, K. Ross. Adapting Materialized Views after Redefinitions. In Proc. of ACM SIGMOD Conference, San Jose, CA, pp. 211–222, 1995.
ISO/IEC 9126 International Standard. Intl. Organization for Standardization. 1991
M. Jarke, M.A. Jeusfeld, T. Rose. A software process data model for knowledge engineering in information systems. Information Systems, 15(1):85–116, 1990.
M. Jarke, R. Gallersdörfer, M.A. Jeusfeld, M. Staudt, S. Eherer. ConceptBase-a deductive objectbase for meta data management. J. Intelligent Information Systems, 4(2):167–192, 1995.
M. Jarke, M.A. Jeusfeld, C. Quix, P. Vassiliadis: Architecture and quality in data warehouses: An extended repository approach. Information Systems, 24(3):229–253, 1999. (a previous version appeared in CAiSE’ 98, Pisa, Italy, 1998)
M.A. Jeusfeld, C. Quix, M. Jarke. Design and Analysis of Quality Information for Data Warehouses. 17th Conf. Entity Relationship Approach (ER’98), Singapore, pp. 349–262, 1998.
W. Kim. On Optimizing an SQL-like Nested Query. ACM TODS 7(3):443–469, 1982.
A. Levy, I. Mumick, Y. Sagiv. Query Optimization by Predicate Move-Around. In Proc. of 20th VLDB Conference, Chile, pp. 96–107, 1994.
O. Marjanovic, M. Orlowska. On Modeling and Verification of Temporal Constraints in Production Workflows. Knowledge and Information Systems, 1(2):157–192, 1999.
I. Mumick, S. Finkelstein, H. Pirahesh, R. Ramakrishnan. Magic is Relevant. In Proc. of ACM SIGMOD Conference, Atlantic City, NJ, pp. 247–258, 1990.
M. Muralikrishna. Optimization and Dataflow Algorithms for Nested Tree Queries. In Proc. of 15th VLDB Conference, Amsterdam, The Netherlands, pp. 77–85, 1989.
M. Muralikrishna. Improved Unnesting Algorithms for Join Aggregate SQL Queries. In Proc. of 18th VLDB Conference, Vancouver, Canada, pp. 91–102, 1992.
W. Nutt, Y. Sagiv, S. Shurin. Deciding Equivalences among Aggregate Queries. In Proc. of 17th Symposium on the Principles of Databases (PODS’98), Seattle, pp. 214–223, 1998.
M. Oivo, V. Basili. Representing software engineering models: the TAME goal-oriented approach. IEEE Trans. Software Engineering, 18(10):886–898, 1992.
H. Pirahesh, J. Hellerstein, W. Hasan. Extensible/Rule Based Query Rewrite Optimization in Starburst. In Proc. of ACM SIGMOD Conference, San Diego, CA, pp. 39–48, 1992.
B. Ramesh, V. Dhar. Supporting systems development by capturing deliberations during requirements engineering. IEEE Trans. Software Eng., 18(6):498–510, 1992.
W. Sadiq, M. Orlowska. Applying Graph Reduction Techniques for Identifying Structural Conflicts in Process Models. In Proc. of 11th Intl. Conf. Advanced Information Systems Engineering, (CAiSE’99), Heidelberg, Germany, pp. 195–209, 1999.
D. Srivastava, S. Dar, H.V. Jagadish, A.Y. Levy. Answering Queries with Aggregation Using Views. In Proc. of 22nd VLDB Conference, Bombay, India, pp. 318–329, 1996.
P. Vassiliadis. Modeling Multidimensional Databases, Cubes and Cube Operations. In Proc. of 10th SSDBM Conference, Capri, Italy, pp. 53–62, 1998.
P. Vassiliadis, M. Bouzeghoub, C. Quix. Towards Quality-Oriented Data Warehouse Usage and Evolution. In Proc. of 11th Conference of Advanced Information Systems Engineering (CAiSE’ 99), Heidelberg, Germany, pp. 164–179, 1999.
P. Vassiliadis, C. Quix, Y. Vassiliou, M. Jarke. A Model for Data Warehouse Operational Processes (long version). Available at http://www.dblab.ece.ntua.gr/~pvassil/publications/process-model00.gz
Workflow Management Coalition. Interface 1: Process Definition Interchange Process Model. Doc. No. WfMC TC-1016-P, 1998. (http://www.wfmc.org)
E. Yu. Strategic Modelling for Enterprise Integration. In Proc. 14th World Congress of Int. Federation of Automatic Control, China 1999.
E. Yu, J. Mylopoulos. Understanding ‘Why’ in Software Process Modelling, Analysis and Design. In Proc. of 16th Intl. Conference Software Engineering, Sorrento, Italy, pp. 159–168, 1994.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2000 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Vassiliadis, P., Quix, C., Vassiliou, Y., Jarke, M. (2000). A Model for Data Warehouse Operational Processes. In: Wangler, B., Bergman, L. (eds) Advanced Information Systems Engineering. CAiSE 2000. Lecture Notes in Computer Science, vol 1789. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-45140-4_30
Download citation
DOI: https://doi.org/10.1007/3-540-45140-4_30
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-67630-0
Online ISBN: 978-3-540-45140-2
eBook Packages: Springer Book Archive