The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Oct. 13, 2020
Filed:
Jan. 31, 2017
Salesforce.com, Inc., San Francisco, CA (US);
Simon Wong, San Carlos, CA (US);
Gary Baker, Zephyr Cove, NV (US);
salesforce.com, inc., San Francisco, CA (US);
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 of the database query received, in which the new structured query language statement accesses only a sub-portion of the specified table corresponding to exactly one table partition of the specified table having a partition ID matching the partition_id parameter; and executing the new structured query language statement against the multi-tenant database system. Other related embodiments are disclosed.