Information Technology Reference
In-Depth Information
become important. On the taxonomy side, such defects as
implicit foreign key
,
concatenated columns
and
missing primary key
will appear.
At the present time, we have defined about 20 equivalence classes with their
rankings, as well as an extended taxonomy of conceptual defects for Entity-
relationship schemas. We are also developing a suite of tools to identify instances
of schema patterns (based on a declarative pattern description language), to
compute various metrics of these instances and to apply improvement transfor-
mations.
The future work will address (1) the validation of the framework
8
and of
the tools with the collaboration of experts in database engineering and (2) the
extension of the framework to relational database evaluation and improvement.
References
1. Lemaitre, J., Hainaut, J.L.: Transformation-based framework for the evaluation
and improvement of database schemas. In: Pernici, B. (ed.) CAiSE 2010. LNCS,
vol. 6051, pp. 317-331. Springer, Heidelberg (2010)
2. Hainaut, J.L.: Bases de données: Concepts, utilisation et développement. Dunod
(2009)
3. McBrien, P., Poulovassilis, A.: A formal framework for er schema transformation.
In: Embley, D.W. (ed.) ER 1997. LNCS, vol. 1331, pp. 408-421. Springer, Heidel-
berg (1997)
4. Codd, E.F.: Normalized data structure: A brief tutorial. In: SIGFIDET Workshop,
pp. 1-17. ACM, New York (1971)
5. Burton-Jones, A., Weber, R.: Understanding relationships with attributes in entity-
relationship diagrams. In: ICIS 1999: Proc. of the 20th International Conference
on Information Systems, Atlanta, GA, USA. Association for Information Systems,
pp. 214-228 (1999)
6. Gemino, A., Wand, Y.: Complexity and clarity in conceptual modeling: comparison
of mandatory and optional properties. Data Knowl. Eng. 55(3), 301-326 (2005)
7. Assenova, P., Johannesson, P.: Improving quality in conceptual modelling by the
use of schema transformations. In: Thalheim, B. (ed.) ER 1996. LNCS, vol. 1157,
pp. 277-291. Springer, Heidelberg (1996)
8. Rauh, O., Stickel, E.: Standard transformations for the normalization of er
schemata. In: CAiSE, pp. 313-326. Springer, Heidelberg (1995)
9. Hainaut, J.L.: The transformational approach to database engineering. In: Läm-
mel, R., Saraiva, J., Visser, J. (eds.) GTTSE 2005. LNCS, vol. 4143, pp. 95-143.
Springer, Heidelberg (2006)
10. Davis, A., Overmyer, S., Jordan, K., Caruso, J., Dandashi, F., Dinh, A., Kincaid,
G.,Ledeboer,G.,Reynolds,P.,Sitaram,P.,Ta,A.,Theofanos,M.:Identifyingand
measuring quality in a software requirements specification. In: Proceedings of the
First International Software Metrics Symposium, pp. 141-152 (1993)
11. Moody, D.L., Shanks, G.G.: Improving the quality of data models: empirical vali-
dation of a quality management framework. Inf. Syst. 28(6), 619-650 (2003)
12. ISO/IEC: ISO 9126-1:2001, Software engineering - Product quality, Part 1: Quality
model. ISO/IEC (2001)
8
As suggested by a reviewer, the use of social network could help in the scoring of
constructs.
