发明名称 METHOD AND APPARATUS FOR MOVING DATA IN DATABASE MANAGEMENT SYSTEM
摘要 Provided are a method of moving data from a memory to a disk by using a single structural query language (SQL) statement and a method of moving data between tables.
申请公布号 US2015378992(A1) 申请公布日期 2015.12.31
申请号 US201414520903 申请日期 2014.10.22
申请人 Altibase Corp. 发明人 Choi Jae Nam
分类号 G06F17/30 主分类号 G06F17/30
代理机构 代理人
主权项 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.
地址 Seoul KR