WO1991001530A3 - Methods and apparatus for checking the integrity of data base data entries - Google Patents
Methods and apparatus for checking the integrity of data base data entries Download PDFInfo
- Publication number
- WO1991001530A3 WO1991001530A3 PCT/US1990/003767 US9003767W WO9101530A3 WO 1991001530 A3 WO1991001530 A3 WO 1991001530A3 US 9003767 W US9003767 W US 9003767W WO 9101530 A3 WO9101530 A3 WO 9101530A3
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- constraints
- data
- records
- data base
- record
- Prior art date
- Legal status (The legal status 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 status listed.)
- Ceased
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/08—Error detection or correction by redundancy in data representation, e.g. by using checking codes
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computer Security & Cryptography (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Quality & Reliability (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Debugging And Monitoring (AREA)
Abstract
A method and apparatus for testing the integrity of the data in a large data base is described. The constraints on the values of the data are represented by data descriptor records having the same format as the data records. These constraints specify intra-record constraints, inter-record constraints and conditional constraints, i.e., constraints which depend upon the satisfaction of some condition such as a particular data value. These descriptor records are compiled directly into executable code which, in turn, can test each record of the data base for conformance with the constraints specified. Such code can be compiled 'on the fly' as needed to test particular records, or compiled off-line and called whenever needed. The same facilities used to process the application data base records can thus be used to create, modify and delete the constraint descriptor records which may therefore form part of the same data base.
Applications Claiming Priority (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| US37804889A | 1989-07-11 | 1989-07-11 | |
| US378,048 | 1989-07-11 |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| WO1991001530A2 WO1991001530A2 (en) | 1991-02-07 |
| WO1991001530A3 true WO1991001530A3 (en) | 1991-04-04 |
Family
ID=23491517
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| PCT/US1990/003767 Ceased WO1991001530A2 (en) | 1989-07-11 | 1990-07-03 | Methods and apparatus for checking the integrity of data base data entries |
Country Status (2)
| Country | Link |
|---|---|
| CA (1) | CA2020711A1 (en) |
| WO (1) | WO1991001530A2 (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6370534B1 (en) * | 1999-06-01 | 2002-04-09 | Pliant Technologies, Inc. | Blocking techniques for data storage |
| 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 |
| CN114610644B (en) * | 2022-03-24 | 2025-07-25 | 北京奥星贝斯科技有限公司 | Method and device for testing database |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US4479196A (en) * | 1982-11-15 | 1984-10-23 | At&T Bell Laboratories | Hyperedge entity-relationship data base systems |
| US4642764A (en) * | 1984-08-13 | 1987-02-10 | International Business Machines Corporation | Method of developing formal identities and program bases in an optimizing compiler |
| US4646229A (en) * | 1982-11-15 | 1987-02-24 | At&T Bell Laboratories | Time-ordered data base |
| US4774661A (en) * | 1985-11-19 | 1988-09-27 | American Telephone And Telegraph Company, At&T Information Systems | Database management system with active data dictionary |
| US4894771A (en) * | 1987-12-19 | 1990-01-16 | Ricoh Company, Ltd. | Data base management system extending structure |
| US4947320A (en) * | 1988-07-15 | 1990-08-07 | International Business Machines Corporation | Method for referential constraint enforcement in a database management system |
| US4953106A (en) * | 1989-05-23 | 1990-08-28 | At&T Bell Laboratories | Technique for drawing directed graphs |
-
1990
- 1990-07-03 WO PCT/US1990/003767 patent/WO1991001530A2/en not_active Ceased
- 1990-07-09 CA CA002020711A patent/CA2020711A1/en not_active Abandoned
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US4479196A (en) * | 1982-11-15 | 1984-10-23 | At&T Bell Laboratories | Hyperedge entity-relationship data base systems |
| US4646229A (en) * | 1982-11-15 | 1987-02-24 | At&T Bell Laboratories | Time-ordered data base |
| US4642764A (en) * | 1984-08-13 | 1987-02-10 | International Business Machines Corporation | Method of developing formal identities and program bases in an optimizing compiler |
| US4774661A (en) * | 1985-11-19 | 1988-09-27 | American Telephone And Telegraph Company, At&T Information Systems | Database management system with active data dictionary |
| US4894771A (en) * | 1987-12-19 | 1990-01-16 | Ricoh Company, Ltd. | Data base management system extending structure |
| US4947320A (en) * | 1988-07-15 | 1990-08-07 | International Business Machines Corporation | Method for referential constraint enforcement in a database management system |
| US4953106A (en) * | 1989-05-23 | 1990-08-28 | At&T Bell Laboratories | Technique for drawing directed graphs |
Also Published As
| Publication number | Publication date |
|---|---|
| WO1991001530A2 (en) | 1991-02-07 |
| CA2020711A1 (en) | 1991-01-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CA2258252A1 (en) | Delta model processing logic representation and execution system | |
| AU5795490A (en) | Data storage device for a digital data processing system | |
| ATE182241T1 (en) | FRACTAL CODING OF DATA | |
| JPS6426243A (en) | Hardware logical simulator | |
| AU9131791A (en) | Method for diagnosing an engine using computer based models | |
| AU7470891A (en) | Method and apparatus for searching database component files to retrieve information from modified files | |
| CA2292494A1 (en) | System and method for indexing information about entities from different information sources | |
| MY119167A (en) | Optical disk device and replacement processing method | |
| CA2057857A1 (en) | Document generation apparatus and methods | |
| EP0412829A3 (en) | Recording medium, method for preparing the same, recording and reproducing device, and recording, reproducing and erasing method by use of such a recording medium | |
| DE69013189D1 (en) | Method for producing an immunosuppressive substance (demethimmunomycin) by using a strain mutant of a microorganism. | |
| DE68913837D1 (en) | Method and device for producing a magnetic recording medium. | |
| EP0352514A3 (en) | Method for creating, maintaining and using an expert system | |
| DE68921169D1 (en) | Program editing method and apparatus for an information recording reproducing apparatus. | |
| DE69425937D1 (en) | Computer system and method for integrating a data compression system with an operating system | |
| WO1991001530A3 (en) | Methods and apparatus for checking the integrity of data base data entries | |
| DE3885303D1 (en) | METHOD FOR APPROXIMATING A VALUE THAT IS A NON-LINEAR FUNCTION OF THE LINEAR IMAGE ELEMENT DATA VALUES. | |
| CA2157113A1 (en) | An Improved Method and System for Predicting Steady State Conditions of a Product from Transient Monotonic or Cyclic Data | |
| EP0354654A3 (en) | Method and apparatus for marking emulation analysis states | |
| DE3382296D1 (en) | MAGNETIC RECORDING MEDIUM AND METHOD FOR PRODUCING A MAGNETIC RECORDING MEDIUM. | |
| DE68929107D1 (en) | Optical data recording medium and method for its production. | |
| DE68916401D1 (en) | Field effect transistor on an insulator and method for its production. | |
| DE68919753D1 (en) | Magnetic recording medium and method for its production. | |
| DE3172542D1 (en) | Method and arrangement for formatting a magnetic recording disc | |
| DE3585433D1 (en) | METHOD FOR PRODUCING A TEMPERATURE AND HUMIDITY PROBE. |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| AK | Designated states |
Kind code of ref document: A2 Designated state(s): JP |
|
| AL | Designated countries for regional patents |
Kind code of ref document: A2 Designated state(s): AT BE CH DE DK ES FR GB IT LU NL SE |
|
| AK | Designated states |
Kind code of ref document: A3 Designated state(s): JP |
|
| AL | Designated countries for regional patents |
Kind code of ref document: A3 Designated state(s): AT BE CH DE DK ES FR GB IT LU NL SE |