Efficient implementation of typed view hierarchies for ORDBMS
US6421658B1 · kind B1 · utility
31Cited by
13References
19Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Jul 30, 1999 |
| Grant date | Jul 16, 2002 |
| Priority date | — |
| Expiry date | Jul 30, 2019 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99945
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method for typed view hierarchies for an object-relational database management (OPDBMS). The views in the hierarchy are merged into a unified hierarchy view through case expressions for mapping and wrapping of overloaded columns. During the merge, the underlying logical tables are eliminated which results in a simplified query graph. The transformation is a non-loss operation which condenses the type information within the case expressions. This allows update, delete and insert operations to be resolved on the query graph on a local level. Using query rewrite rules, the case expressions may be simplified further.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.