Method and apparatus for redefining a group of related objects in a relational database system
US7366741B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Nov 2, 2006 |
| Grant date | Apr 29, 2008 |
| Priority date | — |
| Expiry date | Nov 2, 2026 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99954
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Techniques for redefining a group of related objects in a relational database system by redefining a table belonging to the group of related objects and then redefining the other related objects in the group so that they are in conformity with the redefined table. The techniques permit DDL to be used to redefine a view and are also useful in a versioned relational database system for redefining the table from which the versions are generated. In the versioned relational database system which employs the technique, the versions are generated from a view. To redefine the view, the technique is employed as follows: the view's definition in the relational database system is used to make a base table that has a form which is substantially similar to that of the view. DDL is then applied to the base table to redefine it. The redefined base table definition and the definitions of the objects belonging to the versioned relational database system are then used to redefine the definitions of the objects belonging to the versioned relational database system so that they are in conformity with the base table as redefined by the DDL.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.