Method and system for supporting multivalue attributes in a database system
US7409401B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Feb 23, 2005 |
| Grant date | Aug 5, 2008 |
| Priority date | — |
| Expiry date | Nov 16, 2025 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99945
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and system for supporting multivalue attributes in a database system is disclosed. The method and system includes defining an index class by designating a plurality of attributes associated with the index class, wherein the plurality of attributes includes single value attributes and at least one multivalue attribute, generating an attribute value table for the index class for storing attribute values for the single value attributes, and generating a multiple value table for each of the at least one multivalue attributes for storing attribute values for the at least one multivalue attributes.By generating the multiple value table for the multivalue attribute, each row in the multiple value table corresponds to a single value of the multivalue attribute of the index class. Accordingly, an index scan can be performed to retrieve or update data corresponding to the associated multivalue attribute. Thus, data management becomes more efficient and less costly.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.