System for enabling access to a relational database from an object oriented program
US5937402A · kind A · utility
Assignee
Inventor
Key dates
| Filing date | Jun 19, 1997 |
| Grant date | Aug 10, 1999 |
| Priority date | — |
| Expiry date | Jun 19, 2017 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99934
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Logical tables and logical keys are employed to facilitate interaction between user applications and a relational database. Each logical table is a group of at least one column from a table or view associated with a relational database, and can be utilized like a relational table or view. Each logical primary or foreign key is a key between logical and physical tables that behaves like an actual primary or foreign key. A normalization process allows creation of integrator relational schema objects from existing captured tables. Once a denormalized table is captured from a database the normalization process allows the user to define different logical tables using subsets of the columns of the table. One or more columns of the logical table are designated as primary key. The logical tables interact with the mapping process in the same manner as physical tables.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.