Patent ID: 7974981

Claim:
A computerized method to be executed at least in part in a computing device for storing and searching multi-value schema properties in a database system incapable of handling multi-value properties, the method comprising: determining single value properties associated with a schema, wherein the schema includes an assigned unique identifier, wherein the unique identifier serves as a prefix to a name for each of the multi-value properties, wherein the name comprises a unique namespace decorated name for the schema, wherein the decorated name is utilized to create a property in a search index schema to create an asset key; generating a base table using the single value properties; determining the multi-value properties; generating a row-based table for each of a plurality of distinct multi-value property types using the multi-value properties, wherein the plurality of distinct multi-value property types comprises a plurality of string types, a plurality of integer types and a date type, wherein each row-based table is generated for a group of compatible ones of the distinct multi-value property types, wherein the group of compatible ones of the distinct multi-value property types comprises two distinct string multi-value property types comprising strings of varying lengths; storing the base table and the row-based tables in the database system, wherein storing the row-based tables comprises storing at least one row-based table comprising the group of compatible ones of the distinct multi-value property types to reduce a total number of the row-based tables stored and to reduce a total number of the row-based tables queried; and executing a query based on a user request for the schema on the base table and the row-based tables associated with the schema, wherein each row-based table includes a property identifier column, a property name column and a property value column.