Maintaining a class hierarchy of an object-oriented data model using shared columns and/or overflow tables
US10970316B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Oct 10, 2018 |
| Grant date | Apr 6, 2021 |
| Priority date | — |
| Expiry date | May 29, 2039 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F30/00
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Techniques are provided for maintaining a class hierarchy of an object-oriented data model in tables of a relational database that minimize performance impact (e.g., in terms of both processing resources and storage footprint). In one embodiment, an object-relational mapping system accesses a class hierarchy of an object-oriented data model. A plurality of tables of a relational database are generated, including a primary table, a joined table and an overflow table. The object-relational mapping system maps classes of the class hierarchy to the primary table, joined table and overflow table, wherein the mapping maps properties of classes to columns of the primary table and joined table until a column threshold is reached and then maps excess properties to columns of the overflow table, and the mapping shares at least one column of the primary table, joined table or overflow table among classes such that multiple different properties are mapped to the shared column. The properties of the classes are stored to the plurality of tables according to the mapping.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.