Efficient query processing of DML SQL statements

Details Efficient query processing of DML SQL statements Efficient query processing of DML SQL statements

2011-01-18

2011-01-18

Ali, Mohammad (Department: 2158)

Data processing: database and file management or data structures

Database design

Database and data structure management

C707S687000

Reexamination Certificate

active

07873672

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.

REFERENCES:
patent: 5058002 (1991-10-01), Nakamura et al.
patent: 6567928 (2003-05-01), Lyle et al.
patent: 6615219 (2003-09-01), Bruso et al.
patent: 7383246 (2008-06-01), Lohman et al.
patent: 2003/0182276 (2003-09-01), Bossman et al.
patent: 2005/0060314 (2005-03-01), Wang et al.
patent: 2005/0234930 (2005-10-01), Hop Hing et al.
patent: 2009/0182709 (2009-07-01), Ritchie et al.

Affiliated with

Also associated with

Rating

Efficient query processing of DML SQL statements does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Efficient query processing of DML SQL statements, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Efficient query processing of DML SQL statements will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2667848