ScienceDirect® Home Skip Main Navigation Links
You have guest access to ScienceDirect. Find out more.
 
Home
Browse
My Settings
Alerts
Help
 Quick Search
 Search tips (Opens new window)
    Clear all fields    
Information Systems
Volume 26, Issue 1, March 2001, Pages 15-34
 
Font Size: Decrease Font Size  Increase Font Size
 Abstract - selected
Purchase PDF (1948 K)

 
 
 
Related Articles in ScienceDirect
View More Related Articles
 
View Record in Scopus
 
doi:10.1016/S0306-4379(01)00007-2    How to Cite or Link Using DOI (Opens New Window)
Copyright © 2001 Published by Elsevier Science Ltd. All rights reserved.

Measuring triggering-interaction complexity on active databases*1

Oscar Díaza, Mario Piattinib and Coral Calerob

a Departamento de Lenguajes y Sistemas Informáticos, University of the Basque Country San Sebastián, Spain b Departamento de Informática, University of Castilla-La Mancha, Ciudad Real, Spain

Received 3 August 1999; 
revised 15 November 2000. 
Available online 18 October 2001.

Purchase the full-text article



References and further reading may be available for this article. To view references and further reading you must purchase this article.

Abstract

Distinct software metrics have been proposed for programs. By contrast, metrics for databases have been neglected on the grounds that databases were mere plain files that do not affect considerably information systems maintainability. However, later enhancements on database systems have considerable increase the complexity of the elements kept within the database realm. Such complexity makes metrics a valuable tool to understand, monitor, control, predict and improve software development and maintenance database projects. Triggers are a case in point. Several reports warned about the difficulties to cope with large sets of triggers. Based on the difficulty to ascertain the causes that make a given rule to be triggered, this paper proposes three different metrics for measuring trigger complexity, namely, the triggering potential, the number of anchors and the distance of a trigger. These measures are characterised above the level of the ordinal scale using the measurement theory. Validation of the proposed metrics has been conducted through a set of empirical experiments.

Author Keywords: Triggers; Metrics; Databases

Article Outline

• References

Information Systems
Volume 26, Issue 1, March 2001, Pages 15-34
 
Home
Browse
My Settings
Alerts
Help
Elsevier.com (Opens new window)
About ScienceDirect  |  Contact Us  |  Information for Advertisers  |  Terms & Conditions  |  Privacy Policy
Copyright © 2008 Elsevier B.V. All rights reserved. ScienceDirect® is a registered trademark of Elsevier B.V.