Referential integrity in a relational database management system

Patent 5745896 Issued on April 28, 1998. Estimated Expiration Date:

March 8, 2016. Estimated Expiration Date is calculated based on simple USPTO term provisions. It does not account for terminal disclaimers, term adjustments, failure to pay maintenance fees, or other factors which might affect the term of a patent.

Abstract Claims Description Full Text

Patent References

Method for enforcing referential constraints in a database management system
Patent #: 4933848
Issued on: 06/12/1990
Inventor: Haderle, et al.

Method for referential constraint enforcement in a database management system
Patent #: 4947320
Issued on: 08/07/1990
Inventor: Crus, et al.

Direct access storage device with independently stored parity
Patent #: 5072378
Issued on: 12/10/1991
Inventor: Manka

Complied objective referential constraints in a relational database having dual chain relationship descriptors linked in data record tables
Patent #: 5133068
Issued on: 07/21/1992
Inventor: Crus, et al.

System for accessing design data of modeler subsystems by reference to partnership set and for dynamically correlating design data of modeler subsystems
Patent #: 5193183
Issued on: 03/09/1993
Inventor: Bachman

Method and apparatus for maintaining referential integrity within a relational database
Patent #: 5226158
Issued on: 07/06/1993
Inventor: Horn, et al.

5237556

System for providing user access control within a distributed data processing system having multiple resource managers
Patent #: 5263165
Issued on: 11/16/1993
Inventor: Janis

Data structures and algorithms for managing lock states of addressable element ranges
Patent #: 5285528
Issued on: 02/08/1994
Inventor: Hart

Method and apparatus for releasing and obtaining shared and exclusive locks
Patent #: 5287521
Issued on: 02/15/1994
Inventor: Nitta, et al.

More ...

Inventor

Vijaykumar, Narayanan

Application

No. 612638 filed on 03/08/1996

US Classes:

707/100, DATABASE SCHEMA OR DATA STRUCTURE707/1, DATABASE OR FILE ACCESSING707/4Query formulation, input preparation, or translation

Examiners

Primary: Lintz, Paul R.

International Class

G06F 017/30

Abstract

A system of the present invention includes a PC-based relational database management system (PC RDBMS) with data integrity facilities. Methods are described for maintaining referential integrity between data tables which may be freely moved to various remote workstations--ones which do not have ready access to a centrally-maintained data dictionary. The system provides each table with descriptors for tracking referential integrity links or relationships among various tables, regardless of a particular situs where a table resides. A preferred interface is also described for permitting end-users to easily define referential integrity links between data tables.

Other References

Date, C., An Introduction to Database Systems, vol. I, 5th Ed., Addison-Wesley Publishing Co., 1990, pp. 275-288
Pascal, F., SQL and Relational Basics, Chapter 4: Integrity Features, M&T Books, 1990, pp. 71-81
Bill Lawrence, Paradox for Windows, Lotus, V8, No. 9, Sep., 1992, pp. 58-59
Paradox Version 4.0 User's Guide, Borland International (Scotts Valley, CA, 1992), pp. 271-272, 569-582
Venditto, et al., 9 Multiuser Databases: Robust and Ready to Share, PC Magazine, V11, No. 6, Mar. 31, 1992, pp. 289-317
Anonymous, Multi-User Databases, Computing Canada, V18, No. 11, May 25, 1992, pp. 18-19
Catchings, et al., Paradox for Windows: More than a Face-Lift, PC Week, V9, No. 19, May 11, 1992
Brian J. Smith, Paradox 4.0: The Excellent Gets Better, Data-Based Advisor, V10, No. 6, Jun., 1992, pp. 108-114
Rick Scott, Paradox for Windows Builds Powerful Apps., PC-Computing, V5, No. 7, Jul., 1992, pp. 40-4