US Patent No: RE40235
Number of patents in Portfolio can not be more than 2000
Data processing system and method for detecting mandatory relations violation in a relational database
Stats
-
Apr 8, 2008
Issued date -
Jun 14, 2005
filing date -
11/152,838
serial no -
In Force
status
Importance
Loading Importance Indicators...
Abstract
Machine automated techniques are described for a method of data processing called Relationships Processing. A computing system is disclosed which provides for the high speed recording and extraction of data objects (entities) and for the development of data representing a queried relationship between the entities. Furthermore, methods and systems are disclosed to detect mandatory relations violation between entities by examining whether certain relations exist. The system is expandable to handle the relatively voluminous data bases of large commercial data repositories. A user defines a set of entities and allowed relationships between the entities. The user can expand this set of allowed entities and relationships at any time during the life of the system without reprogramming or compiling of computer program code or disrupting concurrent operational use of the system. Large systems can now be built that are no longer limited to the scope of design requirements known during initial system development. For a given set of defined relationships the system allows the user to perform complex inquiries (again without programming at the code level) that would normally require multiple nested inquiries to be coded programmatically and would not achieve the performance levels of the Relationships Processor.
Loading the Abstract Image...
First Claim
Related Publications
Loading Related Publications...
International Classification(s)
- [Classification Symbol]
- [Patents Count]
Cited Art
| Patent Info | (Count) | # Cites | Year |
|---|---|---|---|
|
|
|||
| 4,498,145 Method for assuring atomicity of multi-row update operations in a database system | 95 | 1982 | |
| 4,575,798 External sorting using key value distribution and range formation | 58 | 1983 | |
| 4,933,848 Method for enforcing referential constraints in a database management system | 56 | 1988 | |
| 4,947,320 Method for referential constraint enforcement in a database management system | 58 | 1988 | |
| 5,226,158 Method and apparatus for maintaining referential integrity within a relational database | 39 | 1989 | |
| 5,133,068 Complied objective referential constraints in a relational database having dual chain relationship descriptors linked in data record tables | 75 | 1991 | |
| 5,386,559 Variant domains and variant maps in a versioned database management system | 62 | 1992 | |
| 5,459,860 Computerized system and process for managing a distributed database system | 90 | 1992 | |
| 5,386,557 Enforcement of referential constraints in a database system | 45 | 1992 | |
| 5,488,722 System and method for automating implementation and execution of constraint most likely to be violated in a database | 19 | 1993 | |
| 5,542,073 Computer program product for choosing largest selectivities among eligible predicates of join equivalence classes for query optimization | 32 | 1995 | |
| 5,893,108 System, method, and computer program product for efficiently translating relational tuples to object-oriented objects | 50 | 1997 | |
|
|
|||
| 4,497,039 Join operation processing system in relational model | 54 | 1982 | |
| 4,855,908 POS system | 36 | 1985 | |
|
|
|||
| 5,664,177 Data processing system having a data structure with a single, simple primitive | 44 | 1988 | |
| 5,379,419 Methods and apparatus for accesssing non-relational data files using relational queries | 162 | 1990 | |
|
|
|||
| 4,901,229 Parallelized rules processing system using associative memory for pipelined execution of plural join operations and concurrent condition comparing | 27 | 1986 | |
| 4,967,341 Method and apparatus for processing data base | 39 | 1989 | |
|
|
|||
| 5,297,279 System and method for database management supporting object-oriented programming | 206 | 1990 | |
| 5,504,885 O-R gateway: a system for connecting object-oriented application programs and relational databases | 105 | 1993 | |
|
|
|||
| 4,918,593 Relational database system | 69 | 1987 | |
| 4,791,561 Interactive construction of means for database maintenance | 99 | 1988 | |
|
|
|||
| 5,262,942 Financial transaction network | 237 | 1990 | |
|
|
|||
| 5,239,663 Self-adapting and multifunctional process and structure for the automated evaluation of logical or arithmetic expressions, particularly for extended database consultation | 29 | 1992 | |
|
|
|||
| 5,369,761 Automatic and transparent denormalization support, wherein denormalization is achieved through appending of fields to base relations of a normalized database | 41 | 1990 | |
|
|
|||
| 4,829,427 Database query code generation and optimization based on the cost of alternate access methods | 112 | 1984 | |
|
|
|||
| 5,581,785 Starting system of disk storage device and data reading/writing system of the same | 16 | 1994 | |
|
|
|||
| 5,539,870 Computerized system and process for interactively managing a distributed database system | 30 | 1992 | |
|
|
|||
| 4,930,071 Method for integrating a knowledge-based system with an arbitrary database system | 173 | 1987 | |
|
|
|||
| 5,197,005 Database retrieval system having a natural language interface | 178 | 1989 | |
|
|
|||
| 4,893,232 Data management system for efficiently searching data elements and having a flexible registration order of data elements | 31 | 1988 | |
|
|
|||
| 6,105,035 Method by which notions and constructs of an object oriented programming language can be implemented using a structured query language (SQL) | 26 | 1998 | |
|
|
|||
| 5,548,749 Semantic orbject modeling system for creating relational database schemas | 109 | 1993 | |
|
|
|||
| 4,807,122 Information storage system | 17 | 1986 | |
|
|
|||
| 4,930,072 Method for computing transitive closure | 29 | 1987 | |
|
|
|||
| 5,168,565 Document retrieval system | 97 | 1989 | |
|
|
|||
| 5,193,183 System for accessing design data of modeler subsystems by reference to partnership set and for dynamically correlating design data of modeler subsystems | 42 | 1990 | |
|
|
|||
| 4,670,848 Artificial intelligence system | 110 | 1985 | |
|
|
|||
| 4,631,664 Partnership data base management system and method | 82 | 1983 | |
|
|
|||
| 5,408,657 Method of imposing multi-object constraints on data files in a data processing system | 30 | 1994 | |
|
|
|||
| 5,247,575 Information distribution system | 717 | 1992 | |
Patent Citation Ranking
Maintenance Fees
| Fee | Large entity fee | small entity fee | micro entity fee | due date |
|---|---|---|---|---|
| 7.5 Year Payment | $3600.00 | $1800.00 | $900.00 | Oct 8, 2015 |
| 11.5 Year Payment | $7400.00 | $3700.00 | $1850.00 | Oct 8, 2019 |
| Fee | Large entity fee | small entity fee | micro entity fee |
|---|---|---|---|
| Surcharge - 7.5 year - Late payment within 6 months | $160.00 | $80.00 | $40.00 |
| Surcharge - 11.5 year - Late payment within 6 months | $160.00 | $80.00 | $40.00 |
| Surcharge after expiration - Late payment is unavoidable | $700.00 | $350.00 | $175.00 |
| Surcharge after expiration - Late payment is unintentional | $1,640.00 | $820.00 | $410.00 |