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.
