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:
Jan. 02, 2024
Filed:
Feb. 19, 2021
Microsoft Technology Licensing, Llc, Redmond, WA (US);
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);
Naveen Prakash, Sammamish, WA (US);
MICROSOFT TECHNOLOGY LICENSING, LLC, Redmond, WA (US);
Abstract
Methods for page split detection and affinity in query processing pushdowns are performed by systems and devices. Page servers perform pushdown operations based on specific, and specifically formatted or generated, information, instructions, and data provided thereto from a compute node. Page servers also determine that page splits have occurred during reading of data pages maintained by page servers during pushdown operations, and also during fulfillment of compute node data requests. To detect a data page has split, page servers utilize information from a compute node of an expected next data page which is compared to a next data page in the page server page index. A mismatch in the comparison by page servers indicates data page was split. Compute nodes and page servers store and maintain off-row data generated during data operations via page affinity considerations where the off-row data is stored at the same page server as the data.