主权项 |
1. A database that implements a method of moving data from a memory to a disk, wherein the method, which is performed by a computer and uses a single structural query language (SQL) statement, comprises:
searching for and reading a record that satisfies a certain condition in the memory; when the record that satisfies the certain condition is read, generating a destination record by using data within a column list in which the record read in the memory is comprised; and receiving a new page from the disk and inserting the destination record into the new page, wherein the searching for and reading, the generating, and the receiving and inserting are repeatedly performed in the database until the record that satisfies the certain condition is no longer found in the memory in the searching for and reading, and if the record that satisfies the certain condition is no longer found, all records that are searched for in the memory and satisfy the certain condition are deleted. |