Systems, methods, and apparatuses for implementing a by partition command term within a multi-tenant aware structured query language
US10803062B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jan 31, 2017 |
| Grant date | Oct 13, 2020 |
| Priority date | — |
| Expiry date | Jul 7, 2038 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/289
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
In accordance with disclosed embodiments, there are provided systems, methods, and apparatuses for implementing a BY PARTITION command term within a multi-tenant aware structured query language within a computing environment. For instance, such an exemplary system having a processor and a memory therein includes means for operating a multi-tenant database system having customer data stored therein for a plurality of distinct customer organizations; maintaining a plurality of tables within the multi-tenant database system to store the customer data, in which one or more of the tables is partitioned into a plurality of table partitions; receiving a database query specifying a command term to restrict a specified table accessed pursuant to execution of the database query by a partition_id parameter; parsing the database query to identify the command term specified; parsing the database query to identify any part of the received database query corresponding to the specified table within the multi-tenant database system to be restricted by the partition_id parameter; generating a new structured query language statement to execute against the multi-tenant database system in fulfillment o…
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.