Invention Grant
- Patent Title: Efficient query processing of DML SQL statements
- Patent Title (中): DML SQL语句的高效查询处理
-
Application No.: US12018809Application Date: 2008-01-24
-
Publication No.: US07873672B2Publication Date: 2011-01-18
- Inventor: Stefano Stefani , Srikumar Rangarajan , Marcel van der Holst
- Applicant: Stefano Stefani , Srikumar Rangarajan , Marcel van der Holst
- Applicant Address: US WA Redmond
- Assignee: Microsoft Corporation
- Current Assignee: Microsoft Corporation
- Current Assignee Address: US WA Redmond
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Various technologies and techniques are disclosed for efficiently processing DML SQL statements through minimal logging and optimized insertions. Rows are inserted into a table in a database in a sorted order. When an insertion of a particular row into the table causes a page split and a new page created during the page split is empty, the new page is locked until an end of a transaction associated with the insertion is completed. When the page split is caused by appending monotonically increasing values at an end of the table, the sorted order will guarantee that the new page is empty. Minimal logging is performed. When the transaction associated with the insertion is completed, a forced checkpoint is performed.
Public/Granted literature
- US20090193060A1 EFFICIENT QUERY PROCESSING OF DML SQL STATEMENTS Public/Granted day:2009-07-30
Information query