is a set of activities that begins with the
identification of a need and concludes with
delivering a product that satisfies the need
a DW handles of revolve around the
design, development, and implementation
of the data warehouse
Development tasks in DWP include e
business requirements analysis, data design,
architecture design, data mapping
Data warehouses are geared toward
addressing the analytic questions of
business managers and executives,
as opposed to processing routine
transactions in OLTP systems
Metadata
Metadata in a DWP can be broadly classified into three types operational metadata, extraction and
transformation metadata, and end-user metadata Operational metadata describes the operational data
sources, while extraction and, transformation metadatacontains information on the extraction of data
from source systems and its subsequent transformation in the staging area. End-user metadata provides
a navigational map for users to browse and find the information that they are interested in
Maturity Models
The concept of maturity implies progress from some initial state to a more advanced state The notion
of evolution is implicit in the stages of growth, suggesting that the progress transitions through a number
of intermediate states on the way to higher maturity levels
In his Quality Management Maturity Grid
describes the typical behavior exhibited by
firms at five levels of maturity with respect to
various aspects of quality management
Crosby framework has been adopted by many disciplines, including
software development, To determine the inherent characteristics of a
maturity model, we analyze a representative sample of maturity models,
based on a set of attributes, which include inherent maturity abstraction,
focus of maturity support, model benefits, model scope, related
technologies, and stakeholders.
Maturity Levels
Maturity levels. The idea of levels originated from Crosby’s work. The number of levels in a model
typically ranges from three to six Each level usually has a descriptor that serves as a name for the level.
The Capability Maturity Model developed by the Software Engineering Institute (SEI) for software
development process reflects the best practices in software development and emphasizes the need to
conduct periodic software process assessments and introduce improvements
Key process areas. Each level in the maturity model indicates a level of process capability. A level is
decomposed into a set of key process areas (KPAs) that an organization should focus on to improve its
process. The levels and KPAs form a grid for a maturity model. All maturity models invoke this grid
approach and provide textual descriptions for the performance characteristics/ traits at each level . Each
KPA includes a cluster of related activities that, when performed, collectively achieve a set of goals
considered important for enhancing process capability. Processes at each level provide the foundation
for the higher level processes.
Activities in key process areas. The objective of each process area can be summarized by its key
practices, also known as activities. Each activity must have goals and commitments.