System and methods of improving a multi-tenant database query using contextual knowledge about non-homogeneously distributed tenant data
US8543566B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Nov 10, 2006 |
| Grant date | Sep 24, 2013 |
| Priority date | — |
| Expiry date | Jan 6, 2028 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24575
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A query optimizing system and methods employ contextual knowledge about the types and use of data and/or applications in tables underlying a relational database to provide improved queries and/or make recommendations to a query optimizer of a database based upon knowledge of the data and/or application gathered. A multi-tenant database, in which querying is conducted on multiple tenant data stored in a single table, provides for determining tenant-level statistics, data sharing, user/tenant views, user-level access/capacities, custom entities, custom fields and/or other contextual information about users and tenants, and for providing query optimization and/or query optimizer recommendations corresponding to such information.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.