Silcroad Soft, Inc.

Tmaxdata Co., Ltd.

Jeong Il Yoon

Owook Jo

Sang Jin Park

Hyungdo Lee

Seunghun Kang

An exemplary embodiment of the present disclosure discloses a computer program stored a non-transitory computer readable storage medium. When the computer program is executed by one or more processors, the computer program performs operations for Change Data Capture (CDC) by one or more processors, and the operations include: extracting a change data from at least one redo log of an online redo log and an archive redo log; analyzing at least one information of a resource utilization rate information and a remain log information of a source database server; and determining to process the change data in one mode of a first mode saving the change data as a CDC file and a second mode recording the change data in a memory, based on at least one of the remain log information and the resource utilization rate information.

Computer program for providing efficient change data capture in a database system

A computer program stored in a computer readable storage medium is provided. It includes encoded commands, in which when the computer program is executed by one or more processors of a computer system. The computer program allows the one or more processors to perform certain commands for distributing resources of a computing device.

Computer program, method, and device for distributing resources of computing device

Disclosed is a computer program stored in a computer-readable storage including encoded commands. When the computer program is executed by one or more processors of a source database server, the computer program performs steps for Change Data Capture (CDC) by one or more processors. The steps may include: identifying a plurality of Structured Query Language (SQL) operations generated for one or more objects associated with a transaction by analyzing a log record including information about the transaction processed at a source database server; determining whether a previous SQL operation history for an object corresponding to an individual SQL operation is in a CDC file, based on whether an order in which the plurality of identified SQL operations occur; determining information to write on the CDC file based on whether a previous SQL operation history is in the CDC file; writing the determined information on the CDC file; and deciding to send the CDC file to a target database server.

Method for implementing change data capture in database management system

The present invention contemplates steps for a change data capture (CDC) between a first database and a second database when executed by one or more processors of the computer system. The disclosed method contemplates extracting a data in a redo log of a first database by a first management module, the data comprising an encrypted column data included in an encrypted column and a non-encrypted column data included in a non-encrypted column, identifying whether the data extracted is the encrypted column data included in the encrypted column, and determining whether to change the encrypted data included in the encrypted column to a null data and to transmit the encrypted data, when the extracted data is the encrypted column data.

Method for duplexing database

Disclosed is a computer program stored in a computer readable storage medium, which includes encoded commands, wherein executing the computer program by one or more processors of a computer system allows the one or more processors to perform steps for change data capture (CDC) between a source database and a target database. The steps may include: a resource data acquisition step of acquiring resource data which is data obtained by monitoring a current resource of a source database server; a comparison information generation step of generating comparison information by comparing the resource data and a predetermined source database server load threshold value; a mode determination step of determining an operation mode of a changed data capture process which operates in the source database server based on the comparison information, the operation mode including a union mode and a division mode; and a mode changing step of changing the operation mode of the process to a mode determined in the mode determination step.

Consistency recovery method for seamless database duplication

The present invention contemplated the use of Change Data Capture (CDC) between a source database and a target database. To execute CDC, one or more computer processors execute the steps of obtaining a plurality of log records comprising information on transactions processed in the source database, grouping the plurality of log records into a plurality of groups based on a predetermined condition, and determining that the plurality of obtained log records is to be replicated from the source database to the target database in parallel in a unit of a group.

Data replication technique in database management system

Technique for duplexing database

Disclosed is a program for security management in a database, which is stored in a computer readable medium to allow a computer to perform steps including: reading one or more data encrypted at a column level from a persistent storage medium or a memory; decrypting one or more data encrypted at the column level to generate one or more decrypted data; generating an index table based on the one or more generated decrypted data; and performing an operation of encrypting the generated index table at a block level.

Method, server and computer program for security management in database

According to an embodiment of the present invention, a computer program stored in a computer-readable medium for encrypting a data value included in a data table stored in a memory and storing the encrypted data value in a persistent storage medium is disclosed. The computer program allows a computer to perform steps including: generating an encrypted data value based on the data value included in the data table stored in a memory; generating a hash value that matches the encrypted data value at least partially based on the data value and positional information of the data value; and determining to write the encrypted data value and the hash value on a persistent storage medium.

Growing community of inventors

Gyeonggi-do, South Korea

Jeong Il Yoon