Method for optimizing the performance of a database
US6606618B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Feb 23, 2001 |
| Grant date | Aug 12, 2003 |
| Priority date | — |
| Expiry date | Jun 9, 2021 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99952
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A relational installation database for storing data elements in the form of strings, objects, etc. is aliased with integer identifiers corresponding to each data element is disclosed. The integer identifiers are obtained from an index that sequentially stores a copy of each unique occurrences of a data element. Populating an installation database with only integers reduces persistent size and provides uniformity to the data fields underlying the database tables, and provides a significant improvement in database performance The uniform data fields may be expanded and contracted to add temporary rows and columns directly to a database table. Database tables may be created in a modular fashion and may be efficiently merged together when the software product is complete. Also, differences between various versions of the software product may be recorded in database transforms.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.