SG41966A1 - Method and apparatus for maintaining referential integrity within a relational database in data processing system - Google Patents

Method and apparatus for maintaining referential integrity within a relational database in data processing system

Info

Publication number
SG41966A1
SG41966A1 SG1995002313A SG1995002313A SG41966A1 SG 41966 A1 SG41966 A1 SG 41966A1 SG 1995002313 A SG1995002313 A SG 1995002313A SG 1995002313 A SG1995002313 A SG 1995002313A SG 41966 A1 SG41966 A1 SG 41966A1
Authority
SG
Singapore
Prior art keywords
data processing
processing system
relational database
referential integrity
maintaining referential
Prior art date
Application number
SG1995002313A
Other languages
English (en)
Inventor
Gary Randall Horn
Timothy Ray Malkemus
Original Assignee
Ibm
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Ibm filed Critical Ibm
Publication of SG41966A1 publication Critical patent/SG41966A1/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23—Updating
    • G06F16/2365—Ensuring data consistency and integrity
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • G06F16/24564—Applying rules; Deductive queries
    • G06F16/24565—Triggers; Constraints
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99951—File or database maintenance
    • Y10S707/99952—Coherency, e.g. same view to multiple users

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computer Security & Cryptography (AREA)
  • Computational Linguistics (AREA)
  • Mathematical Physics (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
SG1995002313A 1989-05-24 1990-05-21 Method and apparatus for maintaining referential integrity within a relational database in data processing system SG41966A1 (en)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
US07/356,141 US5226158A (en) 1989-05-24 1989-05-24 Method and apparatus for maintaining referential integrity within a relational database

Publications (1)

Publication Number Publication Date
SG41966A1 true SG41966A1 (en) 1997-08-15

Family

ID=23400298

Family Applications (1)

Application Number Title Priority Date Filing Date
SG1995002313A SG41966A1 (en) 1989-05-24 1990-05-21 Method and apparatus for maintaining referential integrity within a relational database in data processing system

Country Status (9)

Country Link
US (1) US5226158A (de)
EP (1) EP0399744B1 (de)
JP (1) JPH0695336B2 (de)
KR (1) KR940002344B1 (de)
CN (1) CN1029049C (de)
AU (1) AU629928B2 (de)
DE (1) DE69030282T2 (de)
HK (1) HK1000089A1 (de)
SG (1) SG41966A1 (de)

Families Citing this family (36)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5604899A (en) * 1990-05-21 1997-02-18 Financial Systems Technology Pty. Ltd. Data relationships processor with unlimited expansion capability
US5873088A (en) * 1990-08-31 1999-02-16 Fujitsu Limited Derived data base processing system enabling one program to access a plurality of data basis
DE69217228T2 (de) * 1991-08-07 1997-08-21 Unisys Corp Verfahren zum aufstellen von multi-objekt-bedingungen in dateien
US5499359A (en) * 1994-01-18 1996-03-12 Borland International, Inc. Methods for improved referential integrity in a relational database management system
US5649190A (en) * 1994-06-14 1997-07-15 Harris Corporation Multi-model database system for dynamic creation and maintenance of complex objects in a real time environment
US5740427A (en) * 1994-12-29 1998-04-14 Stoller; Lincoln Modular automated account maintenance system
US5706494A (en) * 1995-02-10 1998-01-06 International Business Machines Corporation System and method for constraint checking bulk data in a database
US5899993A (en) * 1996-08-07 1999-05-04 Oracle Corporation Method and apparatus for achieving an enforced and valid constraint state
US5895465A (en) * 1997-09-09 1999-04-20 Netscape Communications Corp. Heuristic co-identification of objects across heterogeneous information sources
US6098075A (en) * 1997-12-16 2000-08-01 International Business Machines Corporation Deferred referential integrity checking based on determining whether row at-a-time referential integrity checking would yield the same results as deferred integrity checking
US6427143B1 (en) * 1998-04-10 2002-07-30 Computer Associates Think, Inc. Method for loading rows into a database table while enforcing constraints
US6304876B1 (en) 1998-06-05 2001-10-16 Computer Associates Think, Inc. Method for enforcing integrity constraints in a database table using an index
US6189010B1 (en) 1998-06-10 2001-02-13 Platinum Technology, Inc. Method for repairing constraint violations in a database management system
JP2003529814A (ja) * 1999-07-20 2003-10-07 インメンティア インク データ整理のための方法及びシステム
US6424969B1 (en) 1999-07-20 2002-07-23 Inmentia, Inc. System and method for organizing data
US6339777B1 (en) 1999-07-30 2002-01-15 International Business Machines Corporation Method and system for handling foreign key update in an object-oriented database environment
US6453314B1 (en) 1999-07-30 2002-09-17 International Business Machines Corporation System and method for selective incremental deferred constraint processing after bulk loading data
US6542904B2 (en) * 1999-07-30 2003-04-01 International Business Machines Corporation Method and system for efficiently providing maintenance activity on a relational database that is utilized within a processing system
US6965888B1 (en) * 1999-09-21 2005-11-15 International Business Machines Corporation Method, system, program, and data structure for cleaning a database table using a look-up table
US7120638B1 (en) * 1999-09-21 2006-10-10 International Business Machines Corporation Method, system, program, and data structure for cleaning a database table
US6466945B1 (en) * 1999-12-20 2002-10-15 Chartered Semiconductor Manufacturing Ltd Accurate processing through procedure validation in software controlled environment
US7143108B1 (en) * 2000-04-06 2006-11-28 International Business Machines Corporation Apparatus and method for deletion of objects from an object-relational system in a customizable and database independent manner
CA2326805A1 (en) 2000-11-24 2002-05-24 Ibm Canada Limited-Ibm Canada Limitee Method and apparatus for deleting data in a database
US6944619B2 (en) 2001-04-12 2005-09-13 Primentia, Inc. System and method for organizing data
US7620664B2 (en) * 2002-04-02 2009-11-17 Mcgoveran David O Computer-implemented method for translating among multiple representations and storage structures
US7263512B2 (en) * 2002-04-02 2007-08-28 Mcgoveran David O Accessing and updating views and relations in a relational database
US20040158561A1 (en) * 2003-02-04 2004-08-12 Gruenwald Bjorn J. System and method for translating languages using an intermediate content space
US20040236744A1 (en) * 2003-05-22 2004-11-25 Desai Paramesh S. Method for ensuring referential integrity in highly concurrent datbase environments
CN100390789C (zh) * 2003-08-26 2008-05-28 华为技术有限公司 一种性能任务描述库的自动输入方法
US7599948B2 (en) * 2003-10-10 2009-10-06 Oracle International Corporation Object relational mapping layer
US20060004801A1 (en) * 2004-05-03 2006-01-05 Hoefer Felix F Data consistency in a multi-layer datawarehouse
US20060005118A1 (en) * 2004-05-28 2006-01-05 John Golze Systems, methods, and graphical tools for representing fundamental connectedness of individuals
US8719304B2 (en) * 2004-05-28 2014-05-06 John Golze Systems, methods, and graphical tools for representing connectedness of individuals
US7650358B2 (en) * 2005-09-22 2010-01-19 International Business Machines Corportion AUTO COMMIT n option in a relational database
US20080108027A1 (en) * 2006-10-20 2008-05-08 Sallin Matthew D Graphical radially-extending family hedge
KR20190008606A (ko) 2017-07-17 2019-01-25 정덕교 팽창성 유-무기 복합 그라우팅 약액 조성물 및 이를 이용한 시공방법

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
AU566330B2 (en) * 1983-08-17 1987-10-15 Wang Laboratories, Inc. Data base
JPS62173545A (ja) * 1986-01-27 1987-07-30 Hitachi Ltd デ−タデイクシヨナリ・デイレクトリの維持管理方式
US4918593A (en) * 1987-01-08 1990-04-17 Wang Laboratories, Inc. Relational database system
US4933848A (en) * 1988-07-15 1990-06-12 International Business Machines Corporation Method for enforcing referential constraints in a database management system
US4947320A (en) * 1988-07-15 1990-08-07 International Business Machines Corporation Method for referential constraint enforcement in a database management system

Also Published As

Publication number Publication date
EP0399744A2 (de) 1990-11-28
AU5506590A (en) 1990-11-29
AU629928B2 (en) 1992-10-15
HK1000089A1 (en) 1997-11-21
KR900018853A (ko) 1990-12-22
EP0399744A3 (de) 1992-11-19
JPH0695336B2 (ja) 1994-11-24
EP0399744B1 (de) 1997-03-26
CN1047744A (zh) 1990-12-12
US5226158A (en) 1993-07-06
JPH0320867A (ja) 1991-01-29
CN1029049C (zh) 1995-06-21
DE69030282T2 (de) 1997-09-18
DE69030282D1 (de) 1997-04-30
KR940002344B1 (ko) 1994-03-23

Similar Documents

Publication Publication Date Title
SG41966A1 (en) Method and apparatus for maintaining referential integrity within a relational database in data processing system
GB2297180B (en) Method and apparatus for parallel processing in a database system
EP0425413A3 (en) Process and apparatus for processing time consuming queries in an object oriented database management system
EP0420425A3 (en) A data processing system and method for updating a database therein
EP0423725A3 (en) Method and apparatus for concurrency control in database system
EP0425415A3 (en) Process and apparatus for preserving data integrity of a database
GB9318554D0 (en) Method and system for processing and presenting on-line-multimedia information in a tree structure
EP0425412A3 (en) Process and apparatus for handling time consuming and reusable queries in an object oriented database management system
EP0475869A3 (en) Method and apparatus for automated document distribution in a data processing system
IL117524A0 (en) Method and apparatus for transaction processing in a distributed database system
GB2321743B (en) Method and apparatus for securely handling data in a database of biometrics and associated data
EP0520459A3 (en) A method and apparatus for indexing and retrieval of object versions in a versioned data base
EP0428264A3 (en) A method for generating an access plan in a database system
GB2307574B (en) A method and apparatus for preparation of a database document in a local processing apparatus and loading the database document with data from remote sources
EP0475871A3 (en) Method and apparatus for automated meeting agenda generation in a data processing system
EP0475872A3 (en) Method and appparatus for automated procedure initiation in a data processing system
EP0343580A3 (en) Method and apparatus for matching fingerprints
EP0276424A3 (en) Electronic calendaring method for use in a data processing system
EP0276429A3 (en) Electronic calendaring method for use in a data processing system
AU7524494A (en) Method and apparatus for altering information in a database
EP0423723A3 (en) Data retrieval system for relational database
EP0476810A3 (en) Method and system for retrieving data from joined tables in a computer database
GB9020776D0 (en) Method and apparatus for parallel processing data
IL91929A0 (en) Apparatus and method for data acquisition and processing
EP0457707A3 (en) Method for hierarchical grouping of documents in a data processing system