Abstract − Previous research has provided metadata models that enable the capturing of the static components of a data warehouse 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 data warehouse. The proposed metamodel of data warehouse operational processes is capable of modeling complex activities, their interrelationships, and the relationship of activities with data sources and execution details. Moreover, the metamodel complements the existing architecture and quality models in a coherent fashion, resulting in a full framework for quality-oriented data warehouse management, capable of supporting the design, administration and especially evolution of a data warehouse. Finally, we exploit our framework to revert the widespread belief that data warehouses can be treated as collections of materialized views. We have implemented this metamodel using the language Telos and the metadata repository system ConceptBase. Key words: data warehousing, process modeling, evolution, quality 1.
|
477
|
An Overview of Workflow Management: From Process Modeling to Workflow Automation Infrastructure. Distributed and Parallel Databases
– Georgakopoulos, Hornick, et al.
- 1995
|
|
216
|
Optimizing queries with materialized views
– Chaudhuri, Krishnamurthy, et al.
- 1995
|
|
116
|
On Optimizing an SQL-like Nested Query
– Kim
- 1982
|
|
107
|
Telos: A language for representing knowledge about information systems
– Mylopoulos, Borgida, et al.
- 1991
|
|
98
|
Anchoring data quality dimensions in ontological foundations
– Wand, Wang
- 1996
|
|
92
|
Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates and Quantifiers
– Dayal
- 1987
|
|
84
|
Supporting systems development by capturing deliberations during requirements engineering
– Ramesh, Dhar
- 1992
|
|
83
|
Extensible/Rule Based Query Rewrite Optimization
– Pirahesh, Hellerstein, et al.
- 1992
|
|
68
|
Conceptual Modeling of Workflows
– Casati, Ceri, et al.
- 1995
|
|
66
|
Optimization of nested sql queries revisited
– Ganski, Wong
|
|
64
|
Adapting Materialized Views After Redefinitions
– Gupta, Mumick, et al.
- 1995
|
|
64
|
A Product Perspective on Total Data Quality Management
– Wang
- 1998
|
|
54
|
A Framework for Analysis of Data Quality Research
– Wang, Storey, et al.
- 1995
|
|
53
|
Software Risk Management
– Boehm
- 1989
|
|
53
|
Ajax: An extensible data cleaning tool
– Galhardas, Florescu, et al.
- 2000
|
|
50
|
Answering Queries with Aggregation Using Views
– Dar, Jagadish, et al.
- 1996
|
|
44
|
Architecture and quality in data warehouses: An extended repository approach
– Jarke, Jeusfeld, et al.
- 1999
|
|
41
|
Improved unnesting algorithms for join aggregate SQL queries
– Muralikrishna
- 1992
|
|
39
|
Query optimization by predicate move-around
– Levy, Mumick, et al.
- 1994
|
|
39
|
Understanding `why' in software process modeling, analysis and design
– Yu, Mylopoulos
- 1994
|
|
37
|
Modeling multidimensional databases, cubes and cube operations
– Vassiliadis
- 1998
|
|
35
|
Factors in Software Quality
– McCall, Richards, et al.
- 1977
|
|
32
|
A principled approach to data integration and reconciliation in data warehousing
– Calvanese, Giacomo, et al.
- 1999
|
|
31
|
Description logics with concrete domains and aggregation
– Baader, Sattler
- 1998
|
|
29
|
Magic is Relevant
– Mumick, Finkelsein, et al.
|
|
29
|
Representing Software Engineering Models: The TAME Goal Oriented Approach
– Oivo, Basili
|
|
28
|
Examining Data Quality
– Tayi, Ballou
- 1998
|
|
27
|
Design and analysis of quality information for data warehouses
– Jeusfeld, Quix, et al.
- 1998
|
|
27
|
Data quality requirements analysis and modelling
– Wang, Kon, et al.
- 1993
|
|
25
|
T.: Meta-data support for data transformations using microsoft repository
– Bernstein, Bergstraesser
- 1999
|
|
25
|
Applying Graph Reduction Techniques for Identifying Structural Conflicts in Process Models
– Sadiq, Orlowska
- 1999
|
|
23
|
Deciding equivalences among aggregate queries
– Nutt, Sagiv, et al.
- 1998
|
|
22
|
Optimizing queries with aggregate views
– Chaudhuri, Shim
- 1996
|
|
21
|
A software process data model for knowledge engineering in information systems
– Jarke, Jeusfeld, et al.
- 1990
|
|
20
|
Modeling Data Warehouse Refreshment Process as a Workflow Application
– Bouzeghoub, Fabret, et al.
- 1999
|
|
16
|
Towards quality-oriented data warehouse usage and evolution
– Vassiliadis, Bouzeghoub, et al.
- 1999
|
|
15
|
Venky Harinarayan and Dallan Quass, Aggregatequery processing in data warehousing environments
– Gupta
- 1995
|
|
15
|
Optimization and dataflow algorithms for nested tree queries
– Muralikrishna
- 1989
|
|
15
|
Data Warehouse Modeling and Quality Issues
– Vassiliadis
- 2000
|
|
13
|
A comprehensive view of process engineering
– Rolland
- 1998
|
|
11
|
A General Model for Nested Transactional Workflows
– Kuo, Lawley, et al.
- 1996
|
|
11
|
in the land of data warehousing: practical experiences and observations of a researcher
– Gulliver
- 2000
|
|
11
|
Strategic Modelling for Enterprise Integration
– Yu
- 1999
|
|
10
|
A Software Quality Model and Metrics for Identifying Project Risks and Assessing Software Quality
– Hyatt, Rosenberg
- 1996
|
|
10
|
Information Systems Quality and Quality Information Systems
– Jarke, Pohl
- 1992
|
|
10
|
On Modeling and Verification of Temporal Constraints
– MARJANOVIC, ORLOWSKA
- 1999
|
|
9
|
Yehoshua Sagiv, and Divesh Srivastava. Answering queries using views
– Levy, Mendelzon
- 1995
|
|
8
|
Vassiliadis (eds.). Fundamentals of Data Warehouses
– Jarke, Lenzerini, et al.
- 2000
|
|
7
|
Workflow management --- from business process automation to inter-organizational collaboration
– Georgakopoulos, Rusinkiewicz
- 1997
|
|
7
|
Eherer: ConceptBase - a deductive objectbase for meta data management
– Jarke, Gallersdörfer, et al.
- 1995
|
