Tmaxdata Co., Ltd.

Hakyong Lee

Sang Young Park

Minho Lee

Jaehyeong Cho

Jaemin Oh

Taikyoung Kim

Chanho Hwang

Tai Kyoung Kim

Jeongho Na

Disclosed is a computer program stored in a computer-readable storage medium including encoded commands according to an exemplary embodiment of the present disclosure. When the computer program is executed by one or more processors, the computer program allows the one or more processors to perform a method for managing undo information in a database management system (DBMS). The method may include: forming undo information corresponding to an update request by a first transaction in response to the update request by the first transaction in the database management system (DBMS); determining an undo memory chunk to be allocated to the undo information from an undo memory pool on a memory, the undo memory chunk having a variable size; and maintaining the undo information on a space of the memory by using the determined undo memory chunk.

Technique for log records management in database management system

According to some exemplary embodiments of the present disclosure, a method for index recovery performed by a database server is disclosed. The method is an index redo logging method performed by a database server. The method may include performing a first recovery step of determining, by an instruction for recovering via an index redo log comprising an index physical redo log and an index logical redo log, an index tree structure by applying the index physical redo log, wherein the index physical redo log is generated by first index redo logging corresponding to a change of the index tree structure; and performing a second recovery step of performing an index tree search on the determined index tree structure to obtain physical information of the index logical redo log, and applying the index logical redo log to the determined index tree structure using the obtained physical information, wherein the index logical redo log is generated by second index redo logging corresponding to a data change in the index or generated based on a table redo log by the instruction for recovering.

Method, server, and computer readable medium for index recovery using index redo log

Growing community of inventors

Gyeonggi-do, South Korea

Hakyong Lee