US 12,265,539 B2
Systems and methods for managing structured query language on dynamic schema databases
Ryan Chipman, Westwood, MA (US); Patrick Meredith, New York, NY (US); Matthew Chiaravalloti, New York, NY (US); and Huan Li, Jersey City, NJ (US)
Assigned to MongoDB, Inc., New York, NY (US)
Filed by MongoDB, Inc., New York, NY (US)
Filed on Jul. 1, 2022, as Appl. No. 17/856,379.
Claims priority of provisional application 63/219,885, filed on Jul. 9, 2021.
Claims priority of provisional application 63/220,297, filed on Jul. 9, 2021.
Prior Publication US 2023/0039860 A1, Feb. 9, 2023
Int. Cl. G06F 16/00 (2019.01); G06F 16/21 (2019.01); G06F 16/22 (2019.01); G06F 16/242 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/24553 (2019.01) [G06F 16/211 (2019.01); G06F 16/2291 (2019.01); G06F 16/2433 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A distributed database system comprising:
at least one processor operatively connected to a memory;
a distributed database including data stored under a dynamic schema architecture or an unstructured architecture;
a query engine, executed by the at least one processor, configured to:
accept a user defined query;
execute the user defined query against the distributed database;
identify structured query language elements and native query language elements comprising at least in part unstructured query operators in the user defined query;
define a first native query stage of execution for the native query language elements and a first structured query language stage for execution of the structured query language elements;
map structured query language semantics for execution on unstructured data in the distributed database;
execute both of the first structured query stage and the first native query stage on source database data comprising the unstructured data wherein at least some functions of the unstructured query operators are performed on the unstructured data directly in the first native query stage and at least some functions of the structured query language elements are performed on the unstructured data directly in the first structured query stage; and
output results of the executed stages, including results from the structured query language semantics for communication to the user or for further processing by another query stage.