A Formal Suite of Object Relational Database Metrics

Object Relational Databases (ORDB) are complex in nature than traditional relational databases because they combine the characteristics of both object oriented concepts and relational features of conventional databases. Design of an ORDB demands efficient and quality schema considering the structural, functional and componential traits. This internal quality of the schema is assured by metrics that measure the relevant attributes. This is extended to substantiate the understandability, usability and reliability of the schema, thus assuring external quality of the schema. This work institutes a formalization of ORDB metrics; metric definition, evaluation methodology and the calibration of the metric. Three ORDB schemas were used to conduct the evaluation and the formalization of the metrics. The metrics are calibrated using content and criteria related validity based on the measurability, consistency and reliability of the metrics. Nominal and summative scales are derived based on the evaluated metric values and are standardized. Future works pertaining to ORDB metrics forms the concluding note.

Authors:



References:
[1] Henderson-Sellers, B. Object-oriented Metrics - Measures of
complexity, Prentice-Hall, Upper Saddle River, New Jersey, 1996.
[2] Baroni. A.L, C, Calero, F.B. Abreu and Mario Piatini, "Object relational
Metrics Formalization", in Proc. of the Sixth International Conference
on Quality Software. 2006. Available:
doi.ieeecomputersociety.org/10.1109/QSIC.2006.44.
[3] Baroni.A.L, C. Calero, F. Ruiz and F. Brito eAbreu, "Formalizing
Object-Relational Structural Metrics", in Proc. 5th Portuguese
Association of Information Systems Conference, November, 2004.
http://ctp.di.fct.unl.pt/QUASAR/Resourses/Paper/2004/baroni5CAPSI.p
df
[4] Piattini M., Calero C., Sahraoui. H., Lounis H., "Object-Relational
Database Metrics", L'object, March, 2001. Available:
www.iro.umontreal.ca/~sahraouh/papers/lobjet00_1.pdf
[5] Justus S., "Metrics for Object Relational Databases", in Proc.
International Conference on Recent Trends in Information Systems,
ISBN: 81-7764-954-X, 483-496, 2006.
[6] Justus S, and Iyakutti. K., "Assessing the Object-level behavioral
complexity in Object Relational Databases", Conf. Rec. 3rd IEEE
sponsored International Conference on Software Science, Technology
and Engineering, Israel, 2007, pp. 48-59,
Available:doi.ieeecomputersociety.org/10.1109/SWSTE.2007.6
[7] Chidamber. S.R and Kemerer. C.F., A metrics suite for object oriented
design. IEEE Transactions on Software Engineering, Vol. 20, 1994,
pp.476-493.
[8] Ammar. H.H., S.M. Yacoub and T. Robinson, "Dynamic metrics for
object-oriented designs," in Proc. The 5th International Software Metrics
Symposium, Boca Raton, Florida, USA, 1999, pp. 50-61.
[9] Arisholm. E, L.C. Briand, and A. Foyen, 2004. "Dynamic coupling
measures for object-oriented software", IEEE Transactions on Software
Engineering, Vol. 30, No. 8, pp. 491-506, 2004.
[10] Baroni A. L, "Formal Definition of Object-Oriented Design Metrics",
Master Thesis. Vrije Universiteit Brussel - Belgium, 2002.
[11] Berard E. "Metrics for Object-Oriented Software Engineering," an
Internet posting on Computer Software Engineering, January 28th, 1995.
[12] Moris. K., "Metrics for object oriented software development", Masters
Thesis, M.I.T Sloan School of Management, Cambridge, MA, 1998
[13] David P, C.F. Kemerer, Sandra A.S., and James E.T., "The Structural
Complexity of Software: An Experimental Test", IEEE Trans on
Software Engineering, Vol. 31, No. 11, 2005, pp.982-995.
[14] Steve Counsell and Stephen Swift, "The Interpretation and utility of
three cohesion metrics for object-oriented design", ACM Trans on
Software Engineering and Methodology, Vol.15, No.2, 2006, pp.123-
149.
[15] Mitchell and J.F. Power, "Toward a definition of run-time objectoriented
metrics", in Proc. 7th ECOOP Workshop on Quantitative
Approaches in Object-Oriented Software Engineering (QAOOSE-2003),
Darmstadt, Germany, July 2003.
[16] Mitchell and J.F. Power, 2004. "Run-Time Cohesion Metrics: An
Empirical Investigation", in Proc. International Conference on Software
Engineering Research and Practice, Las Vegas, Neveda, USA, June
2004, pp.532-537.
[17] Tobias Mayer, Tracy Hall, "A Critical Analysis of Current OO Design
Metrics", Software Quality Journal, Vol. 8, No.2, Jun 1999.
[18] Elmasri. R and S. Navathe, Fundamentals of Database systems, Fourth
edition, Addison-Wesley, Massachussets, 1999.
[19] Wook-Shin Han, Kyu-Young Whang, Yang-Sae Moon, "A Formal
Framework for Prefecting based on the Type-Level Access Pattern in
Object-Relational DBMSs", IEEE Transactions on Knowledge and Data
Engineering, Vol.17, No.10, 2005, pp.1436-1448.
[20] Calero, C, Ruiz, F., Baroni, A., Brito e Abreu, F., Piattini, M., "An
Ontological approach to describe the SQL: 2003 Object-Relational
Features", International Journal Computer Standards & Interfaces, Vol.
28, 2006, pp.695-713.
[21] Michura. J, Capretz. M.A.M., "Metrics Suite for Class Complexity", in
Proc. International Conference on Information Technology: Coding and
Computing (ITCC-05), 2005.
[22] Pressman R.S., Software Engineering: A Practitioners- Approach,
McGraw-Hill International Edition, Fifth Edition, 2001.
[23] Bunge. M., Treatise on Basic Philosophy: Ontology II: The World of
Systems, Boston, Riedel, 1979.
[24] Baroni, A.L., Coral. C., Mario Piattini and Abreu. F.B., "A Formal
Definition for Object Relational Database Metrics", Url:
http://:ctp.di.fct.unl.pt/QUASAR/Resources/Papers/2005/baroniICEIS.p
df, Visited: January, 2008.
[25] Justus S, and Iyakutti. K., "An Empirical Investigation on the
Understandability of ORDB metrics", in Proc. International Conference
on Modeling and Simulation. India, 2007.
[26] Kothari. C.R., Research Methodology, Methods and Techniques, Wiley
Eastern Limited, ISBN 0852264771, 1990.
[27] E. Weyuker, "Evaluating software complexity measures," IEEE Trans.
Software Eng., vol. 14, 1988, pp. 1357-1365.
[28] Zusc. H., "Properties of Software measures", Software Quality Journal,
Vol. 1, 1992.
[29] Cherniavsky. J.C and C.H. Smith, "On Weyuker-s axioms for software
complexity measures", IEEE Transactions on Software Engineering,
Vol. 17, 1991, pp.197-211.
[30] Justus S, and Iyakutti. K., "Object Relational Database Metrics:
Classified and Evaluated", in Proc. of International Workshop on
Software Engineering, ISBN-10: 3-8322-5611-3, Potsdam, Germany,
2006, pp. 119-131.
[31] Justus S, and Iyakutti. K., "The Theory of Time and Space in Object
Relational Databases", Conf. Rec. IEEE International Conference on
Computing Intelligence and Multimedia Applications, India, 2007,
pp.575-580,
doi.ieeecomputersociety.org/10.1109/ICCIMA.2007.410