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.

Database Reverse Engineering based on Association Rule Mining

A New Kind of Dynamic Association Rule and Its Mining Algorithms

A Set Operation Based Algorithm for Association Rules Mining

Research of Data Mining Based on Personnel Databases

Effective Mining Algorithm of Association Rules Based on Benefit Measure

Extracting the extended entity-relationship model from a legacy relational database

Density-Based Mining of Quantitative Association Rules

Visual Analysis of User-Driven Association Rule Mining

A Seamless Integration of Association Rule Mining with Database Systems

Mining of Multi-Relational Association Rules

Association Rules Mining Of Silk Relics Database With The Rcfp-Growth Algorithm

Algorithms Research for Re-mining of Association Rules Based on Support Changes

Mining A Complete Set Of Both Positive And Negative Association Rules From Large Databases

A Dynamic Approach Based on Apriorilike Algorithm for Mining Association Rules

Mining Positive and Negative Association Rules from Large Databases

An Object Extraction Model Using Association Rules and Dependence Analysis

Implementation of Association Rule Mining for Network Intrusion Detection

ARMiner: A Data Mining Tool Based on Association Rules

Database mining: a performance perspective

FP-tree and COFI Based Approach for Mining of Multiple Level Association Rules in Large Databases

Identifying and Managing Technical Debt in Database Normalization Using Machine Learning and Trade-off Analysis