US 11,995,078 B2
Query intake for legacy databases
Sarah Gerweck, San Mateo, CA (US); Rouzbeh Safaie, San Francisco, CA (US); and Gaurav Nitin Shetti, San Mateo, CA (US)
Assigned to AtScale, Inc., Boston, MA (US)
Filed by Atscale, Inc., San Mateo, CA (US)
Filed on Nov. 18, 2021, as Appl. No. 17/529,878.
Claims priority of provisional application 63/115,781, filed on Nov. 19, 2020.
Prior Publication US 2022/0156263 A1, May 19, 2022
Int. Cl. G06F 16/2453 (2019.01)
CPC G06F 16/24534 (2019.01) 19 Claims
OG exemplary drawing
 
1. A method of interpreting query syntax, comprising:
receiving a query statement having a conditional expression for data retrieval from a multidimensional database;
identifying a Boolean expression in the query statement directed towards the multidimensional database by:
tagging Boolean expressions appearing in a filter context in the query statement, the query statement defined by SQL in a first pass; and
tagging all Boolean expressions irrespective of a filter context in a successive second pass;
determining that the conditional expression contains a value of an unsupported type based on the Boolean expression occurring in a value context based on whether the Boolean expression is double-tagged, where the query statement is directed to a database that rejects Boolean expressions in a value context;
removing the double-tagged Boolean expressions;
transforming, based on the determination of an unsupported type denoted by the remaining tagged Boolean Expressions, the unsupported value of the conditional expression to a value of a supported type by replacing the identified Boolean expression with a sentinel value denoting a Boolean constant.