Emulation of empty database tables using database views
US7702696B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Apr 16, 2007 |
| Grant date | Apr 20, 2010 |
| Priority date | — |
| Expiry date | Oct 6, 2027 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/22
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Methods and a system for managing database usage. The methods and system include receiving a request to create a table, determining the table is an empty table, and storing a pseudo-table in a data store in response to determining the table is empty. The pseudo-table may be a database view. Metadata related to a table may be stored in the pseudo-table to describe characteristics of the table. The pseudo-table occupies less space than a corresponding empty table. The system may implement the methods in middleware transparent to the applications.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.