US 12,235,851 B2
Operation fragmentation with metadata serialization in query processing pushdowns
Craig S. Freedman, Sammamish, WA (US); Adrian-Leonard Radu, Sammamish, WA (US); Daniel G. Schall, Woodinville, WA (US); Hanumantha R. Kodavalla, Sammamish, WA (US); Panagiotis Antonopoulos, Redmond, WA (US); Raghavendra Thallam Kodandaramaih, Redmond, WA (US); Alejandro Hernandez Saenz, Kirkland, WA (US); and Naveen Prakash, Sammamish, WA (US)
Assigned to MICROSOFT TECHNOLOGY LICENSING, LLC, Redmond, WA (US)
Filed by Microsoft Technology Licensing, LLC, Redmond, WA (US)
Filed on Sep. 26, 2022, as Appl. No. 17/935,156.
Application 17/935,156 is a continuation of application No. 17/180,516, filed on Feb. 19, 2021, granted, now 11,487,766.
Claims priority of provisional application 63/127,821, filed on Dec. 18, 2020.
Prior Publication US 2023/0014697 A1, Jan. 19, 2023
Int. Cl. G06F 16/2457 (2019.01); G06F 16/2453 (2019.01); G06F 16/2455 (2019.01); G06F 16/248 (2019.01); G06F 16/28 (2019.01)
CPC G06F 16/24573 (2019.01) [G06F 16/24542 (2019.01); G06F 16/24564 (2019.01); G06F 16/248 (2019.01); G06F 16/284 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method performed by a processor-based computing system in which query operations are pushed from a compute node down to a first page server of a plurality of distributed page servers, the method comprising:
receiving, by the compute node of the computing system, a query that is directed to data stored in a database;
receiving, by the compute node, a first metadata from the first page server;
receiving, by the compute node a second metadata from a second page server of the distributed page servers;
serializing the first metadata and the second metadata to generate serialized metadata;
determining an operation of the received query that returns a first amount of data from the first page server to the compute node when executed by the compute node;
determining, based on the first amount of data and a resource availability associated with the compute node, to perform the operation by the first page server as a pushdown query operation;
providing, to the first page server of the computing system from the compute node, the serialized metadata and one or more text fragments of the query corresponding to the operation, enabling the first page server to perform the operation, the first page server storing the data in at least one data page; and
receiving, by the compute node from the first page server, resultant data from performing the operation as a pushdown query operation, the resultant data including a second amount of data that is less than the first amount of data.