Database Complexity Metrics

Metrics are useful mechanisms for improving the quality of soji`vvare products and also for determim.ng the best ways ro help practitioners and researchers. UnfortunateLy, almost all the metrics put forward focus on program characteristz`cs disregardz.ng databases. However, databases are becomz`ng more compLex, and it is necessary to measure schemata complexity in order to understand, monz.tor, control, predict and z.mprove database development and ma"zntenance projects. In fizz's paper, we will present dierent measures in order to measure the complexz-ty that aJTects the maintainabz"Iz.ty of the relational, object-relatz`onal and active database schemas. However it is not enough to propose the metrics, a formaL validatz.on is also needed for know!ng thez.r mathematz.caL characteristics. We wz.II present the two main tendencz.es in metrics formal validation, axz`omatz.c approaches and measurement theory" However, research !nto sofiware measurement is needed from a theoretz`caL but also jrom a practical point of view ( (121). For thz`s reason, we wz`LL also present some of the experz ments that we have developedfor the dijferent ia`nds of databases.

[1]  Mario Piattini,et al.  Validation of Metrics for Object-Relational Databases , 1999, ECOOP Workshops.

[2]  Paola Sebastiani,et al.  Bayesian methods for intelligent data analysis , 1998 .

[3]  Mario Piattini,et al.  Metrics for Active Database Maintainability , 1999, CAiSE.

[4]  Mario Piattini,et al.  Metrics for Managing Quality in Information Modeling , 2001, Information Modeling in the New Millennium.

[5]  Elaine J. Weyuker,et al.  Evaluating Software Complexity Measures , 2010, IEEE Trans. Software Eng..

[6]  Sandro Morasca,et al.  Property-Based Software Engineering Measurement , 1996, IEEE Trans. Software Eng..

[7]  Anas N. Al-Rabadi,et al.  A comparison of modified reconstructability analysis and Ashenhurst‐Curtis decomposition of Boolean functions , 2004 .

[8]  Justus D. Naumann,et al.  The Effectiveness of Data Representation Characteristics on User Validation , 1985, ICIS.

[9]  Norman E. Fenton,et al.  Measurement : A Necessary Scientific Basis , 2004 .

[10]  Irwin Weiser,et al.  The Relationship between Theory and Practice. , 1988 .

[11]  Carolyn Seaman,et al.  Practical Software Maintenance , 2000, J. Softw. Maintenance Res. Pract..

[12]  Stephen G. MacDonell.  Metrics for database systems: an empirical study , 1997, Proceedings Fourth International Software Metrics Symposium.

[13]  Robert P. Bostrom,et al.  A Comparison of User Performance between the Relational and the Extended Entity Relationship Models in the Discovery phase of Database Design , 1988, ICIS.

[14]  J Kneedler.  Evaluating software for the OR. , 1985, OR manager.

[15]  Jennifer Widom,et al.  Static analysis techniques for predicting the behavior of active database rules , 1995, TODS.

[16]  J. Ross Quinlan,et al.  C4.5: Programs for Machine Learning , 1992 .

[17]  Sjaak Brinkkemper,et al.  Complexity Metrics for Systems Development Methods and Techniques , 1996, Inf. Syst..

[18]  Sandro Morasca,et al.  Towards a theoretical framework for measuring software attributes , 1997, Proceedings Fourth International Software Metrics Symposium.

[19]  Sirkka L. Jarvenpaa,et al.  End User Learning Behavior in Data Analysis and Data Modeling Tools , 1986, ICIS.

[20]  Horst Zuse,et al.  A Framework of Software Measurement , 1998 .

[21]  Robert L. Glass,et al.  The relationship between theory and practice in software engineering , 1996, CACM.

[22]  Peretz Shoval,et al.  Database schema design: an experimental comparison between normalization and information analysis , 1987, DATB.

[23]  H. F. Li,et al.  An Empirical Study of Software Metrics , 1987, IEEE Transactions on Software Engineering.

[24]  Mario Piattini,et al.  AN EMPIRICAL STUDY WITH OBJECT-RELATIONAL DATABASES METRICS , 2000 .

[25]  Carma McClure,et al.  The three Rs of software automation: re-engineering, repository, reusability , 1992 .

[26]  Scott A. Whitmire,et al.  Object-Oriented Design Measurement , 1997 .

[27]  Harry M. Sneed,et al.  Measuring Legacy Database Structures , 1999 .

[28]  Daniel L. Moody,et al.  Metrics for Evaluating the Quality of Entity Relationship Models , 1998, ER.