FRINK Linked Data Fragments server

Matches in SemOpenAlex for { <https://semopenalex.org/work/W139538433> ?p ?o ?g. }

• W139538433 abstract "MotivationThe field of data warehousing has emerged over the last decades. A data warehouse is developed at a moment in time to support business intelligence for an indefinite period of time. During the life of the data warehouse the world around it evolves, including the systems that are a source for the data warehouse. In order for a data warehouse to remain functioning and guarantee the quality of its data, it needs to be adjusted to the evolving world around it. The concept of Delta Impact Analysis is used by the company BI4U for the activities of analysing the impact of specific changes. This concept is important because it provides insight into how a data warehouse can be adjusted to the evolving world around it. The motivation to perform this research was the fact that a clear definition on the concept of DIA and what it comprehends was lacking.GoalsThe main goals of the research were to examine the topic of DIA in practice, to gather insights from literature and other research, to design and develop a practical model for DIA, to test the DIA model, and to provide recommendations to better support changes in data warehouse source systems. These goals resulted in the following main problem statement: How can a Delta Impact Analysis model be designed that supports the process of analyzing the impact of changes in a data warehouse source system situation?ApproachThe research approach is based on the design science framework by Hevner in combination with action science theory to validate the resulting DIA model from the research. The design science perspective resulted in an approach that is both rigorous, by performing a literature study, and relevant, by applying the research to practice. The research started by investigating the concept of DIA in practice at BI4U, in order to provide more insight into what it comprehends and what was relevant for the focus of the research. Next a thorough literature study was performed. Finally an artifact was proposed, a model for the process of DIA, which was validated in practice with a field study.ResultsThe research offers several contributions. The first contribution is the fact that it was established that several aspects of DIA were unclear at BI4U. No clear guidelines existed with regard to what tasks exactly were part of DIA, and how these should be performed. Also no clear framework was present concerning which types of changes could occur and what kind impact these could have. However, a better vision on the scope of DIA was established, which provided a point of focus for the literature study.The second contribution is the fact that in the literature study insights from the field of impact analysis were applied to that of data warehousing. Categorizations are offered to classify delta and impact. The delta can be distinguished by its origin: schema, semantic or business rule. A schema delta concerns structural changes to a source database, a semantic delta concerns changes to the meaning or representation of data in the source, and a business rule delta concerns changes to the meaning of source data for the data warehouse. The impact can be distinguished as: information-preserving or information-changing impact on the information supply to the data warehouse. The ‘changing’ type can be divided by an information supply that has been reduced, increased and redefined. For the different delta categories it is specified what impact categories can apply, this provides a bridge between defining a delta and determining the impact in impact analysis. To deal with the different types of information-changing impact one has the choice if the core of the data warehouse is not modified, modified and/or modified with regard to historic data.The final and most significant contribution of this research is that the results of the first two contributions are combined and applied in an artifact. This artifact is a model for the process of Delta Impact Analysis. The model describes seven main steps that should be performed to execute a solid DIA, from identifying the concrete change and impact till a proposed solution including required resources and costs, communication of this and an evaluation. Evaluation criteria for the process were determined and used for a practical field study to validate the proposed model of this research. The field study provided insight into which aspects can be improved in the future.Conclusions and discussionThe result of this research, the model for the process of Delta Impact Analysis, provides a solid starting point for tackling source system change situations for BI4U, and also for others in the field of data warehousing.Several recommendations can be given with regard to practice. First of all the model should be improved by consistently using it to execute Delta Impact Analyses and adjusting it according to the outcome of the evaluation of the process. Also it will be interesting to perform future research on the usability of existing tools and/or the development of a tool to support the steps in the DIA process. With regard to the scientific field several recommendations can be given for future research. For instance more research could be done concerning which resource and cost estimation models and techniques could be used for DIA. Also it will be interesting to research how the DIA model can be expanded to a model that can be applied to tackle any type of change in implemented data warehouse solutions. The topics of data warehouse evolution and meta warehouse were identified as topics of interest that can support the process of DIA." @default.
• W139538433 created "2016-06-24" @default.
• W139538433 creator A5084041508 @default.
• W139538433 date "2007-12-05" @default.
• W139538433 modified "2023-09-26" @default.
• W139538433 title "The design of a Delta Impact analysis model for data warehouses" @default.
• W139538433 cites W151017439 @default.
• W139538433 cites W1512383973 @default.
• W139538433 cites W1515036872 @default.
• W139538433 cites W1765266268 @default.
• W139538433 cites W1983385867 @default.
• W139538433 cites W1987092770 @default.
• W139538433 cites W2072764742 @default.
• W139538433 cites W2104830231 @default.
• W139538433 cites W2123520467 @default.
• W139538433 cites W3144409617 @default.
• W139538433 hasPublicationYear "2007" @default.
• W139538433 type Work @default.
• W139538433 sameAs 139538433 @default.
• W139538433 citedByCount "0" @default.
• W139538433 crossrefType "dissertation" @default.
• W139538433 hasAuthorship W139538433A5084041508 @default.
• W139538433 hasConcept C111472728 @default.
• W139538433 hasConcept C111919701 @default.
• W139538433 hasConcept C127413603 @default.
• W139538433 hasConcept C135572916 @default.
• W139538433 hasConcept C138885662 @default.
• W139538433 hasConcept C143008350 @default.
• W139538433 hasConcept C176217482 @default.
• W139538433 hasConcept C202444582 @default.
• W139538433 hasConcept C21547014 @default.
• W139538433 hasConcept C24756922 @default.
• W139538433 hasConcept C2522767166 @default.
• W139538433 hasConcept C2767350 @default.
• W139538433 hasConcept C2779530757 @default.
• W139538433 hasConcept C33923547 @default.
• W139538433 hasConcept C41008148 @default.
• W139538433 hasConcept C56739046 @default.
• W139538433 hasConcept C77088390 @default.
• W139538433 hasConcept C9652623 @default.
• W139538433 hasConcept C98045186 @default.
• W139538433 hasConceptScore W139538433C111472728 @default.
• W139538433 hasConceptScore W139538433C111919701 @default.
• W139538433 hasConceptScore W139538433C127413603 @default.
• W139538433 hasConceptScore W139538433C135572916 @default.
• W139538433 hasConceptScore W139538433C138885662 @default.
• W139538433 hasConceptScore W139538433C143008350 @default.
• W139538433 hasConceptScore W139538433C176217482 @default.
• W139538433 hasConceptScore W139538433C202444582 @default.
• W139538433 hasConceptScore W139538433C21547014 @default.
• W139538433 hasConceptScore W139538433C24756922 @default.
• W139538433 hasConceptScore W139538433C2522767166 @default.
• W139538433 hasConceptScore W139538433C2767350 @default.
• W139538433 hasConceptScore W139538433C2779530757 @default.
• W139538433 hasConceptScore W139538433C33923547 @default.
• W139538433 hasConceptScore W139538433C41008148 @default.
• W139538433 hasConceptScore W139538433C56739046 @default.
• W139538433 hasConceptScore W139538433C77088390 @default.
• W139538433 hasConceptScore W139538433C9652623 @default.
• W139538433 hasConceptScore W139538433C98045186 @default.
• W139538433 hasLocation W1395384331 @default.
• W139538433 hasOpenAccess W139538433 @default.
• W139538433 hasPrimaryLocation W1395384331 @default.
• W139538433 hasRelatedWork W1159079591 @default.
• W139538433 hasRelatedWork W1191081113 @default.
• W139538433 hasRelatedWork W1428386313 @default.
• W139538433 hasRelatedWork W2132713118 @default.
• W139538433 hasRelatedWork W2494381559 @default.
• W139538433 hasRelatedWork W2530482929 @default.
• W139538433 hasRelatedWork W2552237707 @default.
• W139538433 hasRelatedWork W2570327615 @default.
• W139538433 hasRelatedWork W2588241782 @default.
• W139538433 hasRelatedWork W2610286884 @default.
• W139538433 hasRelatedWork W2627062108 @default.
• W139538433 hasRelatedWork W2779532708 @default.
• W139538433 hasRelatedWork W2808339546 @default.
• W139538433 hasRelatedWork W2929653265 @default.
• W139538433 hasRelatedWork W2929878346 @default.
• W139538433 hasRelatedWork W2977974447 @default.
• W139538433 hasRelatedWork W2993752457 @default.
• W139538433 hasRelatedWork W3162119998 @default.
• W139538433 hasRelatedWork W576872240 @default.
• W139538433 hasRelatedWork W2787835468 @default.
• W139538433 isParatext "false" @default.
• W139538433 isRetracted "false" @default.
• W139538433 magId "139538433" @default.
• W139538433 workType "dissertation" @default.