Model of Data Warehousing ProcessMaturity


Mind Map by Stiven Villa, updated more than 1 year ago
Created by Stiven Villa about 9 years ago

Resource summary

Model of Data Warehousing ProcessMaturity
  1. Data Warehousing
    1. is a set of activities that begins with the identification of a need and concludes with delivering a product that satisfies the need
      1. a DW handles of revolve around the design, development, and implementation of the data warehouse
        1. Development tasks in DWP include e business requirements analysis, data design, architecture design, data mapping
          1. Data warehouses are geared toward addressing the analytic questions of business managers and executives, as opposed to processing routine transactions in OLTP systems
          2. Metadata
            1. 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
            2. Maturity Models
              1. 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
                1. 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
                  1. 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.
                  2. Maturity Levels
                    1. 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
                      1. 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.
                        1. 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.
                        Show full summary Hide full summary


                        Respiratory System
                        Gender Theorists
                        Hazel Meades
                        Italian: Basics
                        Selam H
                        Lord of the Flies Quotes
                        GCSE Biology AQA
                        carolyn ebanks
                        Test your English grammar skills
                        Brad Hegarty
                        Junior Cert Physics formulas
                        Sarah Egan
                        New GCSE Maths
                        Sarah Egan
                        How the European Union Works
                        Sarah Egan
                        General Pathoanatomy Final MCQs (1-110)- 3rd Year- PMU
                        Med Student