Deferred referential integrity checking based on determining whe

Details Deferred referential integrity checking based on determining whe Deferred referential integrity checking based on determining whe

1997-12-16

2000-08-01

Alam, Hosain T.

Data processing: database and file management or data structures

Database design

Data structure types

707 2, 3642821, 3642834, G06F 1730

Patent

active

060980753

ABSTRACT:
A method, apparatus, and article of manufacture for a computer implemented data manager. A statement is executed in a computer. The statement being performed by the computer to access data from a database stored on a data storage device connected to the computer. A determination is made as to whether to defer referential integrity checking when executing the statement. When it is determined that referential integrity checking is to be deferred, each record is processed that is specified in the statement. Keys for select records are stored as each record is processed. Then, after executing the statement, referential integrity checking is performed on the stored keys.

REFERENCES:
patent: 4833679 (1989-05-01), Anderson et al.
patent: 4933848 (1990-06-01), Haderle et al.
patent: 4947320 (1990-08-01), Crus et al.
patent: 5226158 (1993-07-01), Horn et al.
patent: 5497486 (1996-03-01), Stolfo et al.
patent: 5546576 (1996-08-01), Cochrane et al.
Jukka Teuhola, "deferred maintenance of replicated objects", IEEE, pp. 476-481, Jan. 1996.
Chundi et al., "Deferred updates and data placement in distributed databases", IEEE, pp. 469-476, Jan. 1996.
Victor M. Markowitz, "A relation merging technique for relational databases", IEEE, pp. 428-437, Jan. 1992.
Urpi et al., "Semantic change computation optimization in active database", IEEE, pp. 19-27, Jan. 1994.
Albert et al., "Automatic importation of relational schemas in pegasus", IEEE, pp. 105-113.
Quass et al., "Making views self maintainable for data warehousing", pp. 158-169, Jan. 1996.
Bruce M. Horowitz, "Arun time execution model referential integrity maintenance", IEEE, pp. 548-556, Jan. 1992.
Mukhopahyay et al., "Practical approaches to maintaining referential integrity in multidatabase systems", IEEE, pp. 42-49.
IBM Technical Disclosure Bulletin, "Relationships: Improved Integrity for Relational-Based Computer Aided Design/Computer Aided Manufacturing/Geographic Information Systems", vol. 39, No. 12, pp. 241-246, Dec. 1996.
IBM Technical Disclosure Bulletin, "Referential Integrity Implementation Details And Advantages", vol. 38, No. 3, pp. 477-487, Mar. 1995.
Stephanie Cammarata, et al., "Extending a Relational Database With Deferred Referential Integrity Checking And Intelligent Joins", ACM, pp. 88-97, 1989.
VAX Rdb/VMS Reference Manual, pp. 43-46, Dec. 1984.
Bill Noyce, "Component Software Product--Specification For VAX-11 RDMS V1.0", Digital Equipment Corporation, pp. 22-23, Sep. 28, 1982.
Bruce M. Horowitz, "Update Anomalies For Referential Integrity Schemes", Bell Communications Research, pp. 1-3, Sep. 19, 1986.
Burce M. Horowitz, "Propagating Multi-Column Primary Key Updates", Bell Communications Research, pp. 1-4, Nov. 13, 1986.
L. Sailagner, "Referential Integrity", pp. 1-17, Nov. 24, 1986.
Phil Shaw, "Referential Integrity Changes", pp. 1-7, Jan. 31, 1986.
Phil Shaw, Referential Integrity Change, pp. 1-9, May 30, 1986.
Laila G. Robinson, et al., "A Cursory Review of SQL Addendum-1," pp. 1-6, Jul. 22, 1986.
Laila G. Robinson, "ANSI Extended SQL Issues And Questions", pp. 1-3 with Figures 1 and 2), Jun. 5, 1986.
Tony Hatoun, "The Data Consistency Conundrum: Deferred Versus Immediate Checking", Journal of Information Systems Management, vol. 6, No. 3, pp. 65-67, 1989.
Rainer Eberhard, et al., "DB2 Referential Integrity Performance", IBM Corporation, 1989.

Affiliated with

Also associated with

Rating

Deferred referential integrity checking based on determining whe does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Deferred referential integrity checking based on determining whe, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Deferred referential integrity checking based on determining whe will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-673570