A Model of Data Warehousing Process Maturity

A Model of Data Warehousing Process Maturity

1. Is

   • It is a collection-oriented data in a particular field such as a company or an organization, nonvolatile and time variant, which helps decision making in the state in which it is used.
   • This was a great project because it was an immense growth in the last decade, was so important that was featured as the millennium project by several executives.
   • These storage projects tend to be very expensive which also lead to a large investment is made speaking in terms of time and money.
     • As though it were a good invention everything in life has its problem with this mechanism was that more than 50% failed, and who asked to devote more design, development, implementation and management at the time of creating a DW.
       • These problems were
         • No could increase storage capacity.
         • The performance was unacceptable.
         • Problem to handle each instrument.

2. The Capability Maturity Model (CMM)

   • They began in 1990 with ISO 9001 developed an effort to develop and evaluate quality standards in software process of each organization.
   • A data storage (DWP) can be seen as a data or process production process including sub processes such as
     • Analysis of business requirements
     • Data design
     • Data mapping

3. MOTIVATION FOR A DWP MATURITY MODEL

   • First of all, this project was designed for development tasks that revolve around the design, development, and implementation of the data warehouse. development tasks DWP included in the analysis of business requirements , data design , implementation and as such this project to the end user.
   • Thanks to experts, start working on recovery management , financial services management , governance, data storage , data governance and service level management .
   • Each process performs charge of the whole process is complex, a good software processes and helps the problem you have and the more expensive it is less agile .
   • CMM and CMMI do a very effective for users or companies using software as they help their development process and product quality contribution .

4. EXTANT LITERATURE ON MATURITY MODELS

   • Crosby typical behavior exhibited by companies described five levels of maturity with respect to various aspects of quality management 1uncertainty , 2 awakening 3 enlightenment , 4 wisdom , and 5 Certainty .

5. DESIGNING A DWP MATURITY MODEL

   • Se basa en un modelo conceptual de madurez; basado en la ciencia de la investigación, la literatura de calidad y servicios de TI.
   • La madurez se basa en la literatura ya que se especifica en los niveles de cartografia.
   • Design-Science Research
     • According to Hevner design science paradigm , wanted to expand the limits of humanity and capabilities of the organization by CreAcción new artifacts .
   • Initial Model
     • Se crea una construccion de un artefacto que representa las entidades de interes, este artefacto se diseña en un modelo de madurez ya que suelen defniri muy conceptual cada nivel de madurez.
   • Knowledge Acquisition
     • DW professionals are sought for their skills are reflected in the developer of the model is to be made , here the exchange of ideas among professionals and interviews arise .
   • Evolution of the DWP-M Model
     • An initial model which passes through various locations to verify its validity is created.
       • Predictability of data warehouse project duration
       • . Good documentation
       • Trust in the data
       • Ability to perform better data analysis
       • Satisfied user base.
       • Verifiable ROI.
       • Ability to see process improvement
   • Design Evaluation
     • The most spoken throughout the maturity of the project is to evaluate which ensures that the design of the device is adequate and cunfione perfectly.

6. DISCUSSION

   • Where stands a step by step of all proposed and project software and rectify that this project ends in l steps properly .

7. CONCLUSION AND FUTURE DIRECTIONS

   • Se identifica el grado mas alto de madures, también se diseñan artefactos , más específicamente las construcciones o representaciones de interés en el dominio de la madurez DWP . El DWP -M modelo también captura las relaciones entre áreas de proceso , que representa las interacciones entre las KPA en términos de flujo de información y KPA requisitos previos.