Methods and systems for optimizing queries in a multi-tenant store
US8447754B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Dec 20, 2010 |
| Grant date | May 21, 2013 |
| Priority date | — |
| Expiry date | Apr 7, 2031 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/256
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Methods and systems for optimizing queries in a multi-tenant store are described. In one embodiment, such a method includes retrieving data from a multi-tenant database system having a relational data store and a non-relational data store, receiving a request specifying data to be retrieved, retrieving one or more locations of the data to be retrieved, generating a database query based on the request, in which the database query specifies a plurality of data elements to be retrieved, the plurality of data elements including one or more data elements residing within the non-relational data store and one or more other data elements residing within the relational data store, generating an optimized database query having an optimized query syntax that is distinct from a query syntax of the database query, and executing the optimized database query against the multi-tenant database system to retrieve the data.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.