Multi-value property storage and query support
AssigneeMicrosoft Corporation
InventorsLei Zhao, Yanbiao Zhao, Lijiang Fang
Life of this patent
Estimating the term…
Abstract
Optimized storage and query of multi-value properties is enabled by generating a base table for single value properties associated with a user-defined schema and a number of row-based tables for each different type of multi-value properties. By combining multi-value properties into row-based tables or even into compatible type tables, a number of tables to be created for a database system such as SQL system is reduced at the same time optimizing create/read/update/delete operations.
Claims20
A 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;
- generating a base table using the single value properties;
- determining the multi-value properties;
- and
- generating a row-based table for each distinct multi-value property type using the multi-value properties.
A system for mapping multi-value schema properties in an SQL database system, the system comprising:
- a memory;
- a processor coupled to the memory, capable of executing an Application Programming Interface (API) configured to:
- receive a user-defined schema
- determine single value properties associated with the schema;
- generate a base table for the single value properties;
- determine multi-value properties associated with the schema;
- and
- generate a row-based table for the multi-value properties based on compatible multi-value property types.
A computer-readable storage medium with instructions encoded thereon for mapping multi-value schema properties in an SQL database system, the instructions comprising:
- receiving a user-defined schema;
- determining single value properties associated with the schema;
- assigning a unique identifier to each single value property;
- generating a base table for the single value properties;
- determining multi-value properties associated with the schema;
- assigning a unique identifier to each multi-value property;
- and
- generating a row-based table for the multi-value properties based on compatible multi-value property types.
Dependencies are inferred from the claim text.