METHOD, SYSTEM, AND COMPUTER PROGRAM PRODUCT FOR OPTIMIZING A DATABASE QUERY
1 Assignment
0 Petitions
Accused Products
Abstract
More efficient querying of a multi-tenant database using dynamic tuning of database indices. A layer of meta-data associates data items with tenants, e.g., via tags, and the meta-data is used to optimize searches by channeling processing resources during a query to only those pieces of data bearing the relevant tenant'"'"'s unique tag.
60 Citations
46 Claims
-
1-25. -25. (canceled)
-
26. A method of querying in a multi-tenant database, the database having one or more data tables, each table having one or more logical columns defining data categories and one or more logical rows associated with a plurality of tenants, the method comprising:
-
generating tenant-level statistics from data stored in each of the data tables, the data stored in the data tables comprising tenant-specific data, and the data tables being stored in one database; receiving a database query; and optimizing the database query based on the tenant-level statistics. - View Dependent Claims (27, 28, 29, 30, 31, 32)
-
-
33. A multi-tenant database system comprising:
-
a database having one or more data tables, each table having one or more logical columns defining data categories and one or more logical rows associated with a plurality of tenants; logic for generating tenant-level statistics from data stored in each of the data tables, the data stored in the data tables comprising tenant-specific data, and the data tables being stored in one database; logic for receiving a database query; and logic for optimizing the database query based on the tenant-level statistics. - View Dependent Claims (34, 35, 36, 37, 38, 39)
-
-
40. A computer program product embodied on a tangible computer-readable medium for querying in a multi-tenant database, the database having one or more data tables, each table having one or more logical columns defining data categories and one or more logical rows associated with a plurality of tenants, the computer program product comprising:
-
computer code for generating tenant-level statistics from data stored in each of the data tables, the data stored in the data tables comprising tenant-specific data, and the data tables being stored in one database; computer code for receiving a database query; and computer code for optimizing the database query based on the tenant-level statistics. - View Dependent Claims (41, 42, 43, 44, 45, 46)
-
Specification