Matches in SemOpenAlex for { <https://semopenalex.org/work/W2786070086> ?p ?o ?g. }
Showing items 1 to 96 of
96
with 100 items per page.
- W2786070086 abstract "Technical debt is a metaphor that describes the long term effects of shortcuts taken in software development activities to achieve near term goals. In this study, we explore a new context of technical debt that relates to database normalization design decisions. We posit that ill normalized databases can have long term ramifications on data quality, performance degradation and maintainability costs over time, just like debts accumulate interest. Conversely, conventional database approaches would suggest normalizing weakly normalized tables, this can be a costly process in terms of effort and expertise it requires for large software systems. As studies have shown that the fourth normal form is often regarded as the ideal form in database design, we claim that database normalization debts are likely to be incurred for tables below this form. We refer to normalization debt item as any table in the database below the fourth normal form. We propose a framework for identifying normalization debt. Our framework makes use of association rule mining to discover functional dependencies between attributes in a table, which will help determine the current normal form of that table and identify debt tables. To manage such debts, we propose a trade off analysis method to prioritize tables that are candidate for normalization. The trade off is between the rework cost and the debt effect on the quality of the system as the metaphoric interest. To evaluate our method, we use a case study from Microsoft, AdventureWorks. The results show that our method can reduce the cost and effort of normalization, while improving the database design." @default.
- W2786070086 created "2018-02-23" @default.
- W2786070086 creator A5030457122 @default.
- W2786070086 creator A5031155155 @default.
- W2786070086 creator A5036794666 @default.
- W2786070086 date "2017-11-16" @default.
- W2786070086 modified "2023-09-27" @default.
- W2786070086 title "Identifying and Managing Technical Debt in Database Normalization Using Machine Learning and Trade-off Analysis" @default.
- W2786070086 cites W132327467 @default.
- W2786070086 cites W1606072989 @default.
- W2786070086 cites W1964639690 @default.
- W2786070086 cites W1987270873 @default.
- W2786070086 cites W2040811166 @default.
- W2786070086 cites W2041034497 @default.
- W2786070086 cites W2058049456 @default.
- W2786070086 cites W2060038150 @default.
- W2786070086 cites W2088108067 @default.
- W2786070086 cites W2089758871 @default.
- W2786070086 cites W2125558765 @default.
- W2786070086 cites W2140190241 @default.
- W2786070086 cites W2153273376 @default.
- W2786070086 cites W2165467455 @default.
- W2786070086 cites W2233258444 @default.
- W2786070086 cites W2324136837 @default.
- W2786070086 cites W2395314218 @default.
- W2786070086 cites W2548459597 @default.
- W2786070086 cites W2559773154 @default.
- W2786070086 cites W2566179807 @default.
- W2786070086 cites W2612650101 @default.
- W2786070086 cites W2963592076 @default.
- W2786070086 cites W782747005 @default.
- W2786070086 hasPublicationYear "2017" @default.
- W2786070086 type Work @default.
- W2786070086 sameAs 2786070086 @default.
- W2786070086 citedByCount "0" @default.
- W2786070086 crossrefType "posted-content" @default.
- W2786070086 hasAuthorship W2786070086A5030457122 @default.
- W2786070086 hasAuthorship W2786070086A5031155155 @default.
- W2786070086 hasAuthorship W2786070086A5036794666 @default.
- W2786070086 hasConcept C10138342 @default.
- W2786070086 hasConcept C115903868 @default.
- W2786070086 hasConcept C120527767 @default.
- W2786070086 hasConcept C124101348 @default.
- W2786070086 hasConcept C136886441 @default.
- W2786070086 hasConcept C144024400 @default.
- W2786070086 hasConcept C159198006 @default.
- W2786070086 hasConcept C160713754 @default.
- W2786070086 hasConcept C162324750 @default.
- W2786070086 hasConcept C19165224 @default.
- W2786070086 hasConcept C199360897 @default.
- W2786070086 hasConcept C2777904410 @default.
- W2786070086 hasConcept C41008148 @default.
- W2786070086 hasConcept C529173508 @default.
- W2786070086 hasConcept C77088390 @default.
- W2786070086 hasConceptScore W2786070086C10138342 @default.
- W2786070086 hasConceptScore W2786070086C115903868 @default.
- W2786070086 hasConceptScore W2786070086C120527767 @default.
- W2786070086 hasConceptScore W2786070086C124101348 @default.
- W2786070086 hasConceptScore W2786070086C136886441 @default.
- W2786070086 hasConceptScore W2786070086C144024400 @default.
- W2786070086 hasConceptScore W2786070086C159198006 @default.
- W2786070086 hasConceptScore W2786070086C160713754 @default.
- W2786070086 hasConceptScore W2786070086C162324750 @default.
- W2786070086 hasConceptScore W2786070086C19165224 @default.
- W2786070086 hasConceptScore W2786070086C199360897 @default.
- W2786070086 hasConceptScore W2786070086C2777904410 @default.
- W2786070086 hasConceptScore W2786070086C41008148 @default.
- W2786070086 hasConceptScore W2786070086C529173508 @default.
- W2786070086 hasConceptScore W2786070086C77088390 @default.
- W2786070086 hasLocation W27860700861 @default.
- W2786070086 hasOpenAccess W2786070086 @default.
- W2786070086 hasPrimaryLocation W27860700861 @default.
- W2786070086 hasRelatedWork W1553029106 @default.
- W2786070086 hasRelatedWork W184890424 @default.
- W2786070086 hasRelatedWork W1984394915 @default.
- W2786070086 hasRelatedWork W2060038150 @default.
- W2786070086 hasRelatedWork W2168431158 @default.
- W2786070086 hasRelatedWork W2168736098 @default.
- W2786070086 hasRelatedWork W2277546321 @default.
- W2786070086 hasRelatedWork W2283297315 @default.
- W2786070086 hasRelatedWork W2463240186 @default.
- W2786070086 hasRelatedWork W2561077410 @default.
- W2786070086 hasRelatedWork W2757581093 @default.
- W2786070086 hasRelatedWork W2769479329 @default.
- W2786070086 hasRelatedWork W2883072231 @default.
- W2786070086 hasRelatedWork W2966838272 @default.
- W2786070086 hasRelatedWork W2980795138 @default.
- W2786070086 hasRelatedWork W3094365833 @default.
- W2786070086 hasRelatedWork W3146378947 @default.
- W2786070086 hasRelatedWork W3196024070 @default.
- W2786070086 hasRelatedWork W3208221124 @default.
- W2786070086 hasRelatedWork W215371053 @default.
- W2786070086 isParatext "false" @default.
- W2786070086 isRetracted "false" @default.
- W2786070086 magId "2786070086" @default.
- W2786070086 workType "article" @default.