KR-20260064100-A - METHOD AND SYSTEM FOR DETECTING DATA CHANGE IN RELATIONAL DATABASE IN REAL TIME

KR20260064100AKR 20260064100 AKR20260064100 AKR 20260064100AKR-20260064100-A

Abstract

A method and system for detecting data changes in a relational database in real time are disclosed. A data change detection method according to one embodiment may include the steps of receiving a data change request for data in a relational database, capturing data before change based on an association with data corresponding to the data change request, changing data corresponding to the data change request, capturing data after change based on an association with the changed data, and merging the captured data before change and the captured data after change to extract data with changed associations.

Inventors

박광용
정귀영
양세찬
윤혜린

Assignees

라인플러스 주식회사

Dates

Publication Date: 20260507
Application Date: 20241031

Claims (16)

In a method for detecting data change in a data change detection system implemented by at least one computer device, A step of receiving a data change request for data in a relational database by at least one processor comprising at least one computer device; A step of capturing pre-change data based on an association with data corresponding to the data change request by the above at least one processor; A step of changing data corresponding to the data change request by at least one processor; A step of capturing data after modification based on an association with the modified data by the at least one processor; and A step of extracting data with changed associations by merging the captured pre-change data and the captured post-change data by the at least one processor. A method for detecting data changes including
In paragraph 1, A data change detection method characterized in that the above association includes a relationship established between records belonging to different tables of the relational database.
In paragraph 1, A data change detection method characterized in that the above association is selected and set as one of the following: a one-to-one relationship established between one record of a source table and one record of a destination table of a relational database, a one-to-many relationship established between multiple records of the source table and one record of the destination table, and a many-to-many relationship established between multiple records of the source table and multiple records of the destination table.
In paragraph 3, A data change detection method characterized by the above one-to-one relationship and the above one-to-many relationship being established by storing the identifier of a record in the destination table that has an association relationship with a record in the source table in the source table.
In paragraph 3, A data change detection method characterized in that the above many-to-many relationship is established through a link table containing information on the association relationship between the identifiers of multiple records of the source table and the identifiers of multiple records of the destination table.
In paragraph 1, The step of capturing the data prior to the above change is, A method for detecting data change characterized by capturing pre-change data including a first record containing data corresponding to the data change request, an identifier of a second record with an association established prior to the change of the data, and an identifier of a third record with an association released from the record by the change of the first record.
In paragraph 6, The step of capturing data after the above change is, A data change detection method characterized by capturing data after change, including an identifier of the first record and an identifier of the fourth record that is associated with the first record after the data change.
In Paragraph 7, The above merging step is, A data change detection method characterized by merging the identifier of the second record and the identifier of the fourth record to extract the identifier of the record in which a change in association has occurred.
In paragraph 8, The step of providing the identifier of the third record, the identifier of the first record, and the extracted identifier as information regarding the finally identified change point by the at least one processor. A data change detection method including further
A computer program stored on a computer-readable recording medium to be combined with a computer device to execute the method of any one of claims 1 to 9 on the computer device.
A computer-readable recording medium having a computer program recorded thereon for executing the method of any one of paragraphs 1 through 9 on a computer device.
In a data change detection system implemented by at least one computer device, It includes at least one processor implemented to execute readable instructions on the above at least one computer device, and By the above at least one processor, Receive a data change request for data in a relational database, and Capture the data prior to the change based on the association with the data corresponding to the above data change request, and Change the data corresponding to the above data change request, and Capture the data after the change based on the association with the above-mentioned changed data, and Extracting data with changed associations by merging the captured pre-change data and the captured post-change data. A data change detection system characterized by
In Paragraph 12, A data change detection system characterized by the above association including a relationship established between records belonging to different tables of the relational database.
In Paragraph 12, The above association is established by selecting one of the following: a one-to-one relationship established between one record of a source table in a relational database and one record of a destination table, a one-to-many relationship established between multiple records of the source table and one record of the destination table, and a many-to-many relationship established between multiple records of the source table and multiple records of the destination table. The above one-to-one relationship and the above one-to-many relationship are established by storing the identifier of a record in the destination table that has an association relationship with a record in the source table in the source table, and The above many-to-many relationship is established through a link table containing information about the association relationship between the identifiers of multiple records of the source table and the identifiers of multiple records of the destination table. A data change detection system characterized by
In Paragraph 12, The step of capturing the data prior to the above change is, Capturing pre-change data including a first record containing data corresponding to the above data change request, an identifier of a second record having an association relationship established prior to the change of said data, and an identifier of a third record having an association relationship with the record released by the change of said first record, and The step of capturing data after the above change is, Capturing post-change data including the identifier of the first record and the identifier of the fourth record, which is associated with the first record after the change of the data. A data change detection system characterized by
In paragraph 15, The above merging step is, A data change detection system characterized by merging the identifier of the second record and the identifier of the fourth record to extract the identifier of the record in which a change in the association relationship has occurred.

Description

Method and System for Detecting Data Changes in a Relational Database in Real Time The following description concerns a method and system for detecting data changes in a relational database in real time. A relational database is a database that uses unique identifiers to link two or more databases or tables, and can refer to a data structure configured so that each item and its attributes can be linked to all other items and their attributes. Such relational databases are a powerful and flexible type of database where data is multi-linked, allowing it to be connected to various other fields. Typically, a relational query searches for records that satisfy specific conditions applied to one or more fields. To detect changes in data stored in such relational databases, periodic database scans must be performed or log files analyzed. However, these log files are structured in a way that makes it difficult to identify the associations inherent to relational databases, making it difficult to detect changes in data relationships. [Prior Literature Number] Korean Registered Patent No. 10-1892067 FIG. 1 is a drawing illustrating an example of a network environment according to an embodiment of the present invention. FIG. 2 is a block diagram illustrating an example of a computer device according to an embodiment of the present invention. FIG. 3 is a diagram illustrating an example of an environment in which a data change detection system operates in an embodiment of the present invention. FIG. 4 is a drawing illustrating examples of a project, a collection, and a field in an embodiment of the present invention. FIG. 5 is a drawing illustrating an example of an item in an embodiment of the present invention. FIG. 6 is a diagram illustrating an example of a relationship in an embodiment of the present invention. FIG. 7 is a diagram illustrating an example of a database schema of a one-to-one relationship in an embodiment of the present invention. FIG. 8 is a diagram illustrating an example of a database schema of a one-to-many relationship in one embodiment of the present invention. FIG. 9 is a diagram illustrating an example of a database schema of a many-to-many relationship in one embodiment of the present invention. FIG. 10 is a diagram illustrating an example of an application schema in one embodiment of the present invention. FIG. 11 is a drawing illustrating an example of collections with a one-to-one relationship in one embodiment of the present invention. FIG. 12 is a drawing illustrating an example of collections with a one-to-many relationship in one embodiment of the present invention. FIG. 13 is a drawing illustrating an example of many-to-many relationship collections in one embodiment of the present invention. FIG. 14 is a flowchart illustrating an example of a data change detection method according to an embodiment of the present invention. FIG. 15 is a diagram illustrating an example of a process for detecting data changes in an embodiment of the present invention. FIG. 16 is a diagram illustrating another example of a process for detecting data changes in one embodiment of the present invention. FIGS. 17 to 20 are drawings illustrating examples of a user interface that provides information about data changes in an embodiment of the present invention. FIG. 21 is a diagram illustrating an example of a change between records in a one-to-many relationship in an embodiment of the present invention. FIG. 22 is a diagram illustrating an example of a change between records of a many-to-many relationship in an embodiment of the present invention. Hereinafter, embodiments will be described in detail with reference to the attached drawings. A data change detection system according to embodiments of the present invention may be implemented by at least one computer device. In this case, a computer program according to one embodiment of the present invention may be installed and run on the computer device, and the computer device may perform a data change detection method according to embodiments of the present invention under the control of the run computer program. The above-described computer program may be stored in a computer-readable recording medium to be combined with the computer device to execute the data change detection method on the computer. FIG. 1 is a diagram illustrating an example of a network environment according to an embodiment of the present invention. The network environment of FIG. 1 illustrates an example including a plurality of electronic devices (110, 120, 130, 140), a plurality of servers (150, 160), and a network (170). FIG. 1 is an example for explaining the invention, and the number of electronic devices or servers is not limited to that shown in FIG. 1. Furthermore, the network environment of FIG. 1 is merely an example of one of the environments applicable to the present embodiments, and the environments applicable to the present embodiments are not limited to the network environ