摘要 |
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 mulitvalue 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.
|