Log break point and log text data collection method of oracle database

Abstract

The present application relates to the technical field of computer, and specifically provides a kind of log breakpoint of Oracle database, log text data acquisition method, device and medium, to solve the problem of low parsing efficiency in the process of log text data breakpoint continuation acquisition, and log text data is easily missed parsing.For this purpose, the present application can save the start SCN of each log text data generated by OracleLogMiner obtained by parsing to the preset distributed database at regular intervals.When the parsing thread is restarted, the last log text data obtained before the parsing thread is restarted can be read from the distributed database The start SCN of the last log text data, and the start SCN is used as the starting position of the log text data after the parsing thread is restarted, to parse the log text data, to realize the acquisition of Oracle log text data, to avoid the case of repeated parsing of log text data, and to avoid some log text data being missed, improve the efficiency of log text data acquisition.

Description

Technical Field

[0001] This invention relates to the field of computer technology, specifically providing a method, apparatus, and medium for logging breakpoints, logging text data acquisition, and other related technologies for Oracle databases. Background Technology

[0002] Data synchronization from an Oracle database to another database (such as MySQL) involves two steps: data parsing in the Oracle database and storage in the MySQL database. For the first step, Oracle's LogMiner can be used to help parse and archive log text data.

[0003] However, during the parsing of log text data, the parsing thread may be interrupted due to various reasons (such as thread downtime or manual restart). In this case, either the log text data needs to be re-parsed from the beginning, which may result in a large amount of previously parsed log text data being parsed repeatedly; or the parsing starts again based on the actual SCN generated by Oracle, which may result in some log text data being missed or not parsed.

[0004] The patent application CN201810150258.8, publication number CN110162448A, entitled "Method and Apparatus for Log Collection," discloses a method for storing the number of collection sub-nodes during log collection to accurately and quickly determine the breakpoint position of a log file in the previous collection, thus enabling a breakpoint resume collection scheme. However, this scheme requires storing the parsed log locally before parsing it, and then modifying the corresponding SCN status after parsing. When the parsing process restarts and the original log file is parsed again, the log file corresponding to the SCN may need to be parsed repeatedly, resulting in low parsing efficiency.

[0005] Accordingly, a new log resuming and acquisition solution is needed in this field to address the above problems. Summary of the Invention

[0006] To overcome the above-mentioned shortcomings, this invention is proposed to provide a solution or at least a partial solution to the problem of low parsing efficiency and the easy occurrence of missing parsing of log text data during the process of resuming data acquisition after a breakpoint.

[0007] In a first aspect, the present invention provides a method for logging breakpoint collection in an Oracle database, the method comprising:

[0008] Based on the parsing results of each log text data generated by Oracle LogMiner by the parsing thread, obtain the startup SCN of each log text data;

[0009] At preset intervals, the startup SCN of the last parsed log text data is stored in a preset distributed database.

[0010] In one technical solution of the above-mentioned Oracle database log breakpoint collection method, the step of obtaining the startup SCN of each log text data based on the parsing result of the parsing thread on each log text data generated by Oracle LogMiner includes:

[0011] The parsing thread is used to parse the log text data to obtain the parsing result of the log text data;

[0012] Based on the parsing results, obtain the startup SCN of the log text data;

[0013] The startup SCN of the log text data is stored in the message queue.

[0014] In one technical solution of the above-mentioned Oracle database log breakpoint collection method, the step of storing the start SCN of the last parsed log text data to a preset distributed database at preset time intervals includes:

[0015] At preset intervals, the startup SCN of the last log text data that has been parsed and completed is read from the message queue and stored in the distributed database.

[0016] In one technical solution of the above-mentioned Oracle database log breakpoint collection method, the method further includes:

[0017] If the startup SCN of the last log text data that has been parsed is not successfully stored, a startup SCN is manually set as the startup SCN of the last log text data.

[0018] In one technical solution of the above-mentioned Oracle database log breakpoint collection method, storing the start SCN of the last log text data in a preset distributed database further includes:

[0019] The startup SCN of the last log text data is stored in the distributed database, overwriting the previously stored startup SCN in the distributed database.

[0020] In a second aspect, the present invention provides a method for collecting log text data from an Oracle database, characterized in that the method includes:

[0021] When the application parsing thread parses the log text data generated by Oracle LogMiner, if the parsing thread restarts, it reads the startup SCN of the last log text data obtained before the restart of the parsing thread from the preset distributed database; the startup SCN of the last log text data is obtained according to the Oracle database log breakpoint collection method according to any one of claims 1 to 5 above.

[0022] The data position corresponding to the SCN startup is used as the starting position of the log text data after the parsing thread restarts.

[0023] Each log text data is parsed based on the starting position to obtain the parsing result of each log text data;

[0024] Based on the parsing results, business application data is obtained to collect Oracle log text data.

[0025] In one technical solution of the above log text data collection method, the parsing result includes the business data to be processed and the start SCN for each log text data;

[0026] The method further includes:

[0027] The startup SCN obtained from parsing each log text data is stored in the message queue.

[0028] In one technical solution of the above-mentioned log text data collection method, the step of obtaining business application data based on the parsing result includes:

[0029] The business data to be processed is processed to obtain business application data;

[0030] The business application data is stored in a message queue for consumption by consumers.

[0031] In a third aspect, a control device is provided, comprising a processor and a storage device, the storage device being adapted to store a plurality of program codes, the program codes being adapted to be loaded and run by the processor to execute the Oracle database log breakpoint acquisition method described in any of the above-described technical solutions for the Oracle database log breakpoint acquisition method or the Oracle database log text data acquisition method described in any of the above-described technical solutions for the Oracle database log text data acquisition method.

[0032] In a fourth aspect, a computer-readable storage medium is provided, wherein a plurality of program codes are stored therein, the program codes being adapted to be loaded and run by a processor to perform the Oracle database log breakpoint acquisition method described in any of the above-described technical solutions of the Oracle database log breakpoint acquisition method or the Oracle database log text data acquisition method described in any of the above-described technical solutions of the Oracle database log text data acquisition method.

[0033] The above-described technical solutions of the present invention have at least one or more of the following beneficial effects:

[0034] In implementing the technical solution of this invention, the invention can periodically save the startup SCN of the last log text data generated by the parsed Oracle LogMiner to a preset distributed database. When the parsing thread restarts, it can read the startup SCN of the last log text data obtained before the parsing thread restarts from the distributed database, and use this startup SCN as the starting position of the log text data after the parsing thread restarts to parse the log text data, thereby realizing the collection of Oracle log text data. Through the above configuration method, this invention can avoid the situation where the parsed log text data needs to be parsed repeatedly when the parsing thread restarts for some reason, and also avoids the situation where some log text data is missed after the parsing thread restarts. Moreover, the method of saving the startup SCN of this invention does not require storing log text data, effectively improving the efficiency of Oracle database log text data collection while avoiding the omission of log text data. Attached Figure Description

[0035] The disclosure of this invention will become more readily understood with reference to the accompanying drawings. It will be readily understood by those skilled in the art that these drawings are for illustrative purposes only and are not intended to limit the scope of protection of this invention. Wherein:

[0036] Figure 1 This is a flowchart illustrating the main steps of an Oracle database log breakpoint collection method according to an embodiment of the present invention.

[0037] Figure 2 This is a flowchart illustrating the main steps of an Oracle database log text data collection method according to an embodiment of the present invention.

[0038] Figure 3 This is a flowchart illustrating the main steps of an Oracle database log text data collection method, which is a specific example of an embodiment of the present invention. Detailed Implementation

[0039] Some embodiments of the present invention will now be described with reference to the accompanying drawings. Those skilled in the art should understand that these embodiments are merely illustrative of the technical principles of the present invention and are not intended to limit the scope of protection of the present invention.

[0040] In the description of this invention, "module" and "processor" can include hardware, software, or a combination of both. A module can include hardware circuitry, various suitable sensors, communication ports, memory, and may also include software components, such as program code, or a combination of software and hardware. A processor can be a central processing unit, a microprocessor, a digital signal processor, or any other suitable processor. The processor has data and / or signal processing capabilities. The processor can be implemented in software, in hardware, or a combination of both. Non-transitory computer-readable storage media include any suitable medium capable of storing program code, such as magnetic disks, hard disks, optical disks, flash memory, read-only memory, random access memory, etc. The term "A and / or B" means all possible combinations of A and B, such as only A, only B, or A and B. The terms "at least one A or B" or "at least one of A and B" have a similar meaning to "A and / or B" and can include only A, only B, or A and B. The singular terms "a" or "this" can also include plural forms.

[0041] See appendix Figure 1 , Figure 1 This is a schematic flowchart illustrating the main steps of an Oracle database log breakpoint collection method according to an embodiment of the present invention. Figure 1 As shown, the Oracle database log breakpoint collection method in this embodiment of the invention mainly includes the following steps S101-S102.

[0042] Step S101: Based on the parsing results of each log text data generated by Oracle LogMiner by the parsing thread, obtain the startup SCN of each log text data.

[0043] In this embodiment, a parsing thread can be used to parse the log text data generated by Oracle LogMiner, and the startup SCN of the log text data can be obtained based on the parsing results. The SCN (System Change Number) is a number that is automatically maintained and incremented by the DBMS (Database Management System) after an Oracle database update. In Oracle databases, there are four types of SCNs: System Checkpoint SCN, Data File Checkpoint SCN, Startup SCN, and Termination SCN. In this embodiment, it is necessary to obtain the startup SCN of each log text data entry. LogMiner is an analysis tool provided by Oracle Corporation, which can be used to easily obtain the specific contents of Oracle archived log files.

[0044] In one implementation, the parsing thread can be a single parsing thread or a batch parsing thread.

[0045] Step S102: At preset time intervals, store the startup SCN of the last log text data that has been parsed to the preset distributed database.

[0046] In this embodiment, the startup SCN of the last log text data that has been parsed can be stored in a preset distributed database at preset time intervals.

[0047] In one implementation, the preset duration can be 5 minutes.

[0048] In one implementation, the distributed database can be ZooKeeper. ZooKeeper is a type of distributed database that primarily addresses data management issues frequently encountered in distributed applications, such as: unified naming service, state synchronization service, cluster management, and management of distributed application configuration items.

[0049] Based on the above steps S101-S102, this embodiment of the invention can periodically save the startup SCN obtained by the parsing thread from parsing the last log text data generated by OracleLogMiner to a preset distributed database, so that the startup SCN of the log text data parsed by the parsing thread can be effectively obtained at any time.

[0050] The following provides a further explanation of steps S101 and S102.

[0051] In one embodiment of the present invention, step S101 may further include steps S1011 to S1013:

[0052] Step S1011: The application parsing thread parses the log text data and obtains the parsing result of the log text data.

[0053] In this implementation, a parsing thread can be first applied to parse the log text data to obtain the parsing result for each log text data. The parsing result may include the pending business data and the start SCN for each log text data.

[0054] Step S1012: Obtain the startup SCN of the log text data based on the parsing results.

[0055] Step S1013: Store the startup SCN of the log text data in the message queue.

[0056] In this embodiment, the parsing result of each log text data can be stored in a message queue, that is, the message queue stores the pending business data and the start SCN of each log text data.

[0057] In one implementation, the message queue can be Kafka.

[0058] In one embodiment of the present invention, step S102 may further include the following step S1021:

[0059] Step S1021: At preset intervals, read the startup SCN of the last log text data that has been parsed and completed from the message queue, and store it in the distributed database.

[0060] In this embodiment, at preset intervals, the startup SCN of the last log text data that has been parsed and completed can be read from the message queue and stored in the distributed database.

[0061] In one implementation, if the startup SCN of the last log text data that has been parsed is not successfully stored, a startup SCN is manually set as the startup SCN of the last log text data.

[0062] In one implementation, when storing the startup SCN of the last log text data in the distributed database, the startup SCN stored earlier in the distributed database is overwritten. That is, the distributed database stores only the startup SCN of the last log text data stored.

[0063] Furthermore, the present invention also provides a method for collecting log text data from an Oracle database.

[0064] See appendix Figure 2 , Figure 2This is a flowchart illustrating the main steps of an Oracle database log text data collection method according to an embodiment of the present invention. Figure 2 As shown, the Oracle database log text data collection method in this embodiment of the invention mainly includes the following steps S201-S204.

[0065] Step S201: When the application parsing thread parses the log text data generated by Oracle LogMiner, if the parsing thread restarts, it reads the startup SCN of the last log text data obtained before the parsing thread restarted from the preset distributed database; wherein, the startup SCN of the last log text data is obtained according to the above-described Oracle database log breakpoint collection method embodiment.

[0066] In this embodiment, if the parsing thread restarts for some reason (such as the parsing thread going down or human error), the startup SCN of the last log text data before the parsing thread restarts can be read from the preset distributed database.

[0067] In one implementation, the parsing thread can be a single parsing thread or a batch parsing thread.

[0068] In one implementation, the distributed database can be ZooKeeper.

[0069] Step S202: Use the data position corresponding to the start of SCN as the starting position of the log text data after the parsing thread restarts.

[0070] In this embodiment, the data position corresponding to the obtained startup SCN can be used as the starting position of the log text data after the parsing thread restarts. That is, the starting position of the log text data after the parsing thread restarts is determined according to the startup SCN.

[0071] Step S203: Parse each log text data according to the starting position and obtain the parsing result of each log text data.

[0072] In this embodiment, each log text data generated by Oracle LogMiner can be parsed starting from the beginning position to obtain the parsing results.

[0073] In one implementation, the parsing result may include the pending business data and the start SCN corresponding to each log text data.

[0074] Step S204: Obtain business application data based on the parsing results to collect Oracle log text data.

[0075] In this embodiment, business application data can be obtained based on the parsing results to achieve the collection of Oracle log text data.

[0076] Based on steps S201-S204 above, in this embodiment of the invention, when the parsing thread restarts, it can read the startup SCN of the last log text data obtained before the parsing thread restarts, stored in the distributed database, and use this startup SCN as the starting position of the log text data after the parsing thread restarts to parse the log text data, thereby achieving the collection of Oracle log text data. Through this configuration method, the present invention avoids the need to repeatedly parse already parsed log text data when the parsing thread restarts for some reason, and also avoids the situation where some log text data is missed after the parsing thread restarts. Furthermore, the method of saving the startup SCN in this invention does not require storing the log text data, effectively improving the efficiency of Oracle database log text data collection while avoiding the omission of log text data.

[0077] In one embodiment of the present invention, in addition to including the steps S201-S204 described above, the present invention may also include the following step S205:

[0078] Step S205: Store the startup SCN obtained from parsing each log text data into the message queue.

[0079] In this embodiment, the startup SCN obtained by the parsing thread can be stored in the message queue.

[0080] In one implementation, the message queue can be Kafka, etc.

[0081] In one embodiment of the present invention, step S204 may further include steps S2041 and S2042:

[0082] Step S2041: Perform business processing on the business data to be processed to obtain business application data.

[0083] Step S2042: Store the business application data in the message queue for consumption by consumers.

[0084] In this embodiment, business data to be processed can be processed to obtain business application data, and the business application data can be stored in a message queue for consumption by consumers.

[0085] In one implementation, business processing can be the conversion of business data to be processed into business application data.

[0086] See the appendix below. Figure 3A specific example of an embodiment of the present invention will be described below. Figure 3 This is a flowchart illustrating the main steps of an Oracle database log text data collection method, which is a specific example of an embodiment of the present invention.

[0087] like Figure 3 As shown, the Oracle LogMiner component generates log text data, which needs to be parsed. The parsing process can utilize either a single parsing thread or a batch parsing thread. A single parsing thread pushes one log text data entry per batch; a batch parsing thread pushes 20,000 log text data entries per batch.

[0088] When the parsing thread starts, it needs to obtain the startup SCN from ZooKeeper.

[0089] The parsing thread parses, processes, validates, deduplicates, transforms, and filters each log text data, obtains business application data, and saves it to Kafka. The scheduled job retrieves the latest startup SCN stored in Kafka and saves it to the zk (zookeeper) node.

[0090] The local cache generates a unique cache identifier for the log text data based on its SSID, SSN, and rowid. This unique cache identifier is used to perform data verification and deduplication of the parsed log text data. Specifically, rowid is a pseudo-column used to uniquely identify rows in the table; SSID is the log text identifier; and SSN is the log text location identifier.

[0091] Without using the Oracle database log text data collection method of this invention, when the single parsing thread and the batch parsing thread restart for some reason, one situation is that the single parsing thread and the batch parsing thread start parsing the log text data from the beginning, i.e., starting with SCN=1. However, in fact, before the restart, some of the business application data corresponding to the log text data has already been parsed and stored, such as parsing and storing the log text data at starting with SCN=3. In this case, there is a situation where the log text data at starting with SCN=1 and 2 is parsed repeatedly.

[0092] Another scenario involves recording the actual parsing position of the parsing thread. For example, if the current parsing thread is parsing log text data with a startup SCN of 6, and then restarts, it will continue parsing the log text data based on the actual parsing position. In this case, although the parsing thread has already parsed the data position with startup SCN=6 before restarting, the log text data collection process requires further processing after parsing, including data verification, deduplication, transformation, filtering, and storage in Kafka. Therefore, it's possible that even if the log text data at the startup SCN=6 is successfully parsed, only the business application data corresponding to the log text data at the SCN=4 position might actually be successfully saved to Kafka. If the parsing thread restarts and continues parsing from the startup SCN=6, the business application data at the SCN=5 position might be lost.

[0093] By applying the embodiments of the present invention, the loss of business application data can be effectively avoided, and it is not necessary to start parsing from scratch every time the parsing thread is restarted. This ensures parsing efficiency while ensuring that no business application data is lost during the collection of log text data.

[0094] It should be noted that although the steps in the above embodiments are described in a specific order, those skilled in the art will understand that in order to achieve the effects of the present invention, different steps do not necessarily have to be executed in such an order. They can be executed simultaneously (in parallel) or in other orders, and these variations are all within the scope of protection of the present invention.

[0095] Those skilled in the art will understand that all or part of the processes in the method of the above embodiment of the present invention can also be implemented by a computer program instructing related hardware. The computer program can be stored in a computer-readable storage medium, and when executed by a processor, it can implement the steps of the various method embodiments described above. The computer program includes computer program code, which can be in the form of source code, object code, executable file, or some intermediate form. The computer-readable storage medium can include any entity or device capable of carrying the computer program code, a medium, a USB flash drive, a portable hard drive, a magnetic disk, an optical disk, a computer memory, a read-only memory, a random access memory, an electrical carrier signal, a telecommunication signal, and a software distribution medium, etc. It should be noted that the content included in the computer-readable storage medium can be appropriately added or removed according to the requirements of legislation and patent practice in the jurisdiction. For example, in some jurisdictions, according to legislation and patent practice, the computer-readable storage medium does not include electrical carrier signals and telecommunication signals.

[0096] Furthermore, the present invention also provides a control device. In one embodiment of the control device according to the present invention, the control device includes a processor and a storage device. The storage device can be configured to store a program for executing the Oracle database log breakpoint acquisition method of the above-described method embodiments. The processor can be configured to execute the program in the storage device, which includes, but is not limited to, a program for executing the Oracle database log breakpoint acquisition method of the above-described method embodiments. For ease of explanation, only the parts related to the embodiments of the present invention are shown; for specific technical details not disclosed, please refer to the method section of the embodiments of the present invention. This control device can be a control device device comprising various electronic devices.

[0097] Furthermore, the present invention also provides a computer-readable storage medium. In one embodiment of the computer-readable storage medium according to the present invention, the computer-readable storage medium can be configured to store a program for executing the Oracle database log breakpoint acquisition method of the above-described method embodiments. This program can be loaded and run by a processor to implement the above-described Oracle database log breakpoint acquisition method. For ease of explanation, only the parts related to the embodiments of the present invention are shown; for specific technical details not disclosed, please refer to the method section of the embodiments of the present invention. The computer-readable storage medium can be a storage device comprising various electronic devices. Optionally, in the embodiments of the present invention, the computer-readable storage medium is a non-transitory computer-readable storage medium.

[0098] Furthermore, the present invention also provides a control device. In one embodiment of the control device according to the present invention, the control device includes a processor and a storage device. The storage device can be configured to store a program for executing the Oracle database log text data acquisition method of the above-described method embodiments. The processor can be configured to execute the program in the storage device, which includes, but is not limited to, a program for executing the Oracle database log text data acquisition method of the above-described method embodiments. For ease of explanation, only the parts related to the embodiments of the present invention are shown; for specific technical details not disclosed, please refer to the method section of the embodiments of the present invention. This control device can be a control device device comprising various electronic devices.

[0099] Furthermore, the present invention also provides a computer-readable storage medium. In one embodiment of the computer-readable storage medium according to the present invention, the computer-readable storage medium can be configured to store a program for executing the Oracle database log text data collection method of the above-described method embodiments. This program can be loaded and run by a processor to implement the above-described Oracle database log text data collection method. For ease of explanation, only the parts related to the embodiments of the present invention are shown; for specific technical details not disclosed, please refer to the method section of the embodiments of the present invention. The computer-readable storage medium can be a storage device comprising various electronic devices. Optionally, in the embodiments of the present invention, the computer-readable storage medium is a non-transitory computer-readable storage medium.

[0100] Furthermore, it should be understood that since the various modules are only provided to illustrate the functional units of the device of the present invention, the physical devices corresponding to these modules may be the processor itself, or a part of the processor's software, hardware, or a combination of software and hardware. Therefore, the number of modules shown in the figures is merely illustrative.

[0101] Those skilled in the art will understand that the various modules in the device can be adaptively split or combined. Such splitting or combining of specific modules will not cause the technical solution to deviate from the principles of the present invention; therefore, the technical solutions after splitting or combining will fall within the protection scope of the present invention.

[0102] The technical solution of the present invention has been described above with reference to the preferred embodiments shown in the accompanying drawings. However, it will be readily understood by those skilled in the art that the scope of protection of the present invention is obviously not limited to these specific embodiments. Without departing from the principles of the present invention, those skilled in the art can make equivalent changes or substitutions to the relevant technical features, and the technical solutions after such changes or substitutions will all fall within the scope of protection of the present invention.

Claims

1. A method for log breakpoint collection in Oracle databases, characterized in that, The method includes: Based on the parsing results of each log text data generated by Oracle LogMiner by the parsing thread, obtain the startup SCN of each log text data; At preset intervals, the startup SCN of the last log text data that has been parsed is stored in a preset distributed database; The method further includes: If the startup SCN of the last log text data that has been parsed is not successfully stored, a startup SCN is manually set as the startup SCN of the last log text data.

2. The Oracle database log breakpoint collection method according to claim 1, characterized in that, The step of obtaining the startup SCN for each log text data based on the parsing result of each log text data generated by Oracle LogMiner by the parsing thread includes: The parsing thread is used to parse the log text data to obtain the parsing result of the log text data; Based on the parsing results, obtain the startup SCN of the log text data; The startup SCN of the log text data is stored in the message queue.

3. The Oracle database log breakpoint collection method according to claim 2, characterized in that, The step of storing the SCN of the last parsed log text data in a preset distributed database at each preset time interval includes: At preset intervals, the startup SCN of the last log text data that has been parsed and completed is read from the message queue and stored in the distributed database.

4. The Oracle database log breakpoint collection method according to claim 1, characterized in that, The method further includes: If the startup SCN of the last log text data that has been parsed is not successfully stored, a startup SCN is manually set as the startup SCN of the last log text data.

5. A method for collecting log text data from an Oracle database, characterized in that, The method includes: When the application parsing thread parses the log text data generated by Oracle LogMiner, if the parsing thread restarts, it reads the startup SCN of the last log text data obtained before the parsing thread restarted from the preset distributed database; the startup SCN of the last log text data is obtained according to the Oracle database log breakpoint collection method according to any one of claims 1 to 4 above. The data position corresponding to the SCN startup is used as the starting position of the log text data after the parsing thread restarts. Each log text data is parsed based on the starting position to obtain the parsing result of each log text data; Based on the parsing results, business application data is obtained to collect Oracle log text data.

6. The log text data acquisition method according to claim 5, characterized in that, The parsing results include the pending business data and the starting SCN for each log text data; The method further includes: The startup SCN obtained from parsing each log text data is stored in the message queue.

7. The log text data acquisition method according to claim 6, characterized in that, The step of obtaining business application data based on the parsing result includes: The business data to be processed is processed to obtain business application data; The business application data is stored in a message queue for consumption by consumers.

8. A control device, comprising a processor and a storage device, said storage device being adapted to store a plurality of program codes, characterized in that, The program code is adapted to be loaded and run by the processor to perform the Oracle database log breakpoint acquisition method according to any one of claims 1 to 4 or the Oracle database log text data acquisition method according to any one of claims 5 to 7.

9. A computer-readable storage medium storing a plurality of program codes, characterized in that, The program code is adapted to be loaded and run by a processor to perform the Oracle database log breakpoint acquisition method according to any one of claims 1 to 4 or the Oracle database log text data acquisition method according to any one of claims 5 to 7.

Images