Invention Grant
- Patent Title: Systems, methods, and apparatuses for implementing conditional statement execution within a multi-tenant aware structured query language
-
Application No.: US15421092Application Date: 2017-01-31
-
Publication No.: US10649987B2Publication Date: 2020-05-12
- Inventor: Simon Wong , Gary Baker
- Applicant: salesforce.com, Inc.
- Applicant Address: US CA San Francisco
- Assignee: salesforce.com, inc.
- Current Assignee: salesforce.com, inc.
- Current Assignee Address: US CA San Francisco
- Agency: Elliot, Ostrander & Preston, P.C.
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/242 ; G06F16/33

Abstract:
In accordance with disclosed embodiments, there are provided systems, methods, and apparatuses for implementing conditional statement execution 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; receiving a database query specifying a command term to conditionally execute a sub-portion of the database query when a Boolean evaluation specified with the database query resolves to true and to negate execution of the sub-portion of the database query when the Boolean evaluation resolves to false; 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 sub-portion of the database query to be conditionally executed or negated pursuant to the Boolean evaluation; 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 includes a semantic structure to execute the sub-portion of the database query when the Boolean evaluation resolves to true and to omit from execution the sub-portion of the database query when the Boolean evaluation resolves to false; and executing the new structured query language statement against the multi-tenant database system. Other related embodiments are disclosed.
Public/Granted literature
Information query