Semantic Integrity Considerations for Effective Data Management: Important Issues for the Database Course

Abstract

Semantic integrity constraints are time invariant properties of the world of interest being represented by a database. They constrain the values that may appear in a valid database instance. Despite their crucial role in data modeling, support for them has been largely ignored by database management system (DBMS) vendors. As a result, in most database applications today, either integrity constraints are not enforced resulting in database instances that are not reflections of reality, or precious programmer time is spent in specifying and enforcing integrity constraints as application program logic. Neither of the two situations are acceptable. This article calls for a more systematic coverage of semantic integrity constraints in the database course with the intent of training informed users who can voice their discontent and put pressure on the DBMS vendors to correct the current direction.

Get full access to this article

View all access options for this article.

References

Peckham

and Maryanski

, Semantic Data Models, ACM Computing Surveys, 20, pp. 153–189, 1988.

Tsichritzis

D. C.

and Lochovsky

F. H.

, Data Models, Prentice-Hall, Englewood Cliffs, New Jersey, 1982.

Date

C. J.

, An Introduction to Database Systems, Volume 1, (5th Edition), Addison-Wesley, Reading, Massachusetts, 1990.

Hammer

M. M.

and McLeod

D. J.

, Semantic Integrity in Relational Database Systems, Proceedings of the 1st International Conference on Very Large Database, 1975.

Guynes

C. S.

, Metadata Considerations for Effective Data Administration: Important Issues for the Data Administration Course, Journal of Computer Information Systems, pp. 16–18, 1988.

Date

C. J.

, A Guide to DB2, Addison-Wesley, Reading, Massachusetts, 1984.

Date

C. J.

, A Guide to the SQL Standard, (2nd Edition), Addison-Wesley, Reading, Massachusetts, 1989.

Brown

R. G.

, Referential Integrity Checking and SQL, Database Programming & Design, 1: 3, pp. 36–45, 1988.

Eswaran

K. P.

and Chamberlin

D. D.

, Functional Specification of a Subsystem for Data Base Integrity, Proceedings of the 1st International Conference on Very Large Databases, IEEE, New York, pp. 48–68, 1975.

10.

Hammer

M. M.

and Sarin

S. K.

, Efficient Monitoring of Database Assertions, Proceedings of ACM/SIGMOD International Conference on Management of Data, ACM, New York, pp. 159–168, 1978.

11.

Stonebraker

M. R.

, Implementation of Integrity Constraints and Views by Query Modification, Proceedings of ACM/SIGMOD International Conference on Management of Data, ACM, New York, pp. 65–78, 1975.

12.

Chamberlin

D. D.

, SEQUEL2: A Unified Approach to Data Definition, Manipulation, and Control, IBM Journal of Research & Development, 20, pp. 560–575, 1976.

13.

Kroenke

D. M.

and Dolan

K. A.

, Database Processing, (3rd Edition), Science Research Associates, Chicago, 1988.

14.

Stemple

D. W.

Simon

Mazumdar

, and Jarke

, Assuring Database Integrity, Journal of Database Administration, 1: 1, pp. 12–26, 1990.

15.

Eswaran

K. P.

, Aspects of a Trigger Subsystem in an Integrated Data Base System, Proceedings of the 2nd International Conference in Software Engineering, IEEE, New York, pp. 243–250, 1976.

16.

Buneman

and Clemons

, Efficiently Monitoring Relational Databases, ACM Transactions on Database Systems, 4: 3, pp. 368–382, 1979.

17.

Loomis

M. E. S.

, The Database Book, Macmillan, New York, 1987.

18.

Jarke

and Koch

, Query Optimization in Database Systems, ACM Computing Surveys, 16, pp. 111–152, 1984.

19.

King

J. J.

, QUIST: A System for Semantic Query Optimization in Relational Databases, Proceedings of the 7th International Conference on Very Large Databases, IEEE, New York, pp. 510–517, 1981.

20.

Rob

and Adams

C. N.

, Microcomputer Databases in the Classroom: It's Time to Pay the (Design) Piper, Journal of 'Computer Information Systems, pp. 18–24, 1990.