Oracle database full-text retrieval statement restoration synchronization method and device

Abstract

The invention discloses an Oracle database full-text retrieval statement restoration synchronization method. The method comprises the following steps: calling a retrieval configuration object in a synchronization administrator mode to execute full-text retrieval aiming at a preset retrieval target on a database; acquiring a system table operation statement; analyzing the system table operation statement; searching a system table operation statement in the tracking log file; when the system table operation statement is found, obtaining the name of an operation object based on the user name of the current user; according to an operation type in the system table operation statement, determining a to-be-synchronized operation statement when the current user calls the retrieval configuration object to execute full-text retrieval; and sending the to-be-synchronized operation statement to the target end. According to the method, the full-text retrieval operation statement needing to be synchronized can be restored, so that data synchronization of the full-text retrieval operation statement is completed, and the completeness of backup data is guaranteed. The invention further discloses a device for implementing the method, electronic equipment and a computer readable storage medium.

Description

Technical Field

[0001] The present invention relates to the field of database technology, and in particular to an Oracle database full-text search statement restoration synchronization method and device. Background Art

[0002] In the construction of database disaster recovery system, establishing the master-slave database architecture is a key measure to ensure business continuity and data security. The current system has achieved real-time synchronization of business data and DML (Data Manipulation Language) operation data, including data change operations such as insert, modify, and delete. These data can be synchronized from the master database to the backup database in a timely manner, which to a certain extent guarantees the integrity and consistency of the master and backup database data. However, for Oracle database, its full-text search function is a powerful text search tool. The way to use full-text search is to call the ctx_ddl object to implement it. However, for database users, the operation statement that calls the ctx_ddl object cannot be directly obtained from the modification log. When synchronizing data for the Oracle database, the full-text search statement cannot be synchronized and backed up, resulting in incomplete backup data. Summary of the invention

[0003] In order to solve the above problems existing in the prior art, the present invention provides an Oracle database full-text search statement restoration synchronization method and device. The technical problem to be solved by the present invention is achieved through the following technical solutions: A first aspect of an embodiment of the present invention provides an Oracle database full-text search statement restoration and synchronization method, comprising the following steps: An Oracle database full-text search statement restoration and synchronization method, applied to a source end, includes the following steps: In synchronous administrator mode, call the search configuration object to perform a full-text search on the database for the preset search target; In response to the full-text search completion instruction, obtaining a system table operation statement; Analyze the system table operation statement to determine the name of the operation object to be operated when calling the retrieval configuration object in the system table operation statement; wherein the name of the operation object is created based on the user name of the synchronization administrator; When the DML operation information in the modification log is updated, searching the system table operation statement in the tracking log file; When a system table operation statement is found, the name of the operation object based on the user name of the current user is obtained; Determine, according to the operation type in the system table operation statement corresponding to the name of the operation object based on the user name of the current user, the operation statement to be synchronized when the current user calls the search configuration object to perform a full-text search; The to-be-synchronized operation statement is sent to the target end.

[0004] In one embodiment of the present invention, the step of obtaining a system table operation statement in response to a full-text search completion instruction includes: In response to the full-text search completion instruction, obtaining the current tracking log file; The current tracking log file is parsed to obtain system table operation statements.

[0005] In one embodiment of the present invention, when the DML operation information in the modification log is updated, searching the tracking log file for the system table operation statement includes: When DML operation information is added to the modification log, the system table operation statement is searched in the tracking log file.

[0006] In one embodiment of the present invention, determining the operation statement to be synchronized when the current user calls the search configuration object to perform a full-text search based on the operation type in the system table operation statement corresponding to the name of the operation object based on the user name of the current user includes: Determine the operation type when the target calls the search configuration object to perform full-text search according to the operation type in the system table operation statement corresponding to the name of the operation object based on the user name of the current user; According to the operation type when the target calls the retrieval configuration object to perform full-text retrieval, an operation statement to be synchronized when the current user calls the retrieval configuration object to perform full-text retrieval is generated.

[0007] A second aspect of an embodiment of the present invention provides an Oracle database full-text search statement restoration synchronization device, comprising: An execution module, used to call the search configuration object in the synchronous administrator mode to perform a full-text search on the database for a preset search target; A first acquisition module, for acquiring a system table operation statement in response to a full-text search completion instruction; A first determination module is used to analyze the system table operation statement to determine the name of the operation object to be operated when calling the retrieval configuration object in the system table operation statement; wherein the name of the operation object is created based on the user name of the synchronization administrator; A search module, used for searching the system table operation statement in the tracking log file when the DML operation information in the modification log is updated; The second acquisition module is used to acquire the name of the operation object based on the user name of the current user when the system table operation statement is found; A second determination module is used to determine the operation statement to be synchronized when the current user calls the search configuration object to perform full-text search according to the operation type in the system table operation statement corresponding to the name of the operation object based on the user name of the current user; The sending module is used to send the operation statement to be synchronized to the target end.

[0008] In one embodiment of the present invention, the step of obtaining a system table operation statement in response to a full-text search completion instruction includes: In response to the full-text search completion instruction, obtaining the current tracking log file; The current tracking log file is parsed to obtain system table operation statements.

[0009] In one embodiment of the present invention, when the DML operation information in the modification log is updated, searching the tracking log file for the system table operation statement includes: When DML operation information is added to the modification log, the system table operation statement is searched in the tracking log file.

[0010] In one embodiment of the present invention, determining the operation statement to be synchronized when the current user calls the search configuration object to perform a full-text search based on the operation type in the system table operation statement corresponding to the name of the operation object based on the user name of the current user includes: Determine the operation type when the target calls the search configuration object to perform full-text search according to the operation type in the system table operation statement corresponding to the name of the operation object based on the user name of the current user; According to the operation type when the target calls the retrieval configuration object to perform full-text retrieval, an operation statement to be synchronized when the current user calls the retrieval configuration object to perform full-text retrieval is generated.

[0011] A third aspect of an embodiment of the present invention provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the program, an Oracle database full-text search statement restoration and synchronization method provided by the first aspect of an embodiment of the present invention is implemented.

[0012] A fourth aspect of an embodiment of the present invention provides a computer-readable storage medium having a computer program stored thereon. When the computer program is executed by a processor, the Oracle database full-text search statement restoration and synchronization method provided by the first aspect of the embodiment of the present invention is implemented.

[0013] Beneficial effects of the present invention: The present invention analyzes the system table operation statement, thereby determining the name of the operation object of the operation executed when the retrieval configuration object is called in the system table operation statement, and then, when it is necessary to synchronously call the retrieval configuration object to perform a full-text search operation statement, the operation type in the system table operation statement corresponding to the name of the operation object based on the user name of the current user is obtained from the system table operation statement, and then the operation statement of calling the retrieval configuration object to perform the full-text search that needs to be synchronized can be restored, so that the operation statement can be synchronized to complete the data synchronization of the full-text search operation statement, thereby ensuring the integrity of the backup data.

[0014] Other features and advantages of the present invention will be described in the following description, and partly become apparent from the description, or understood by practicing the present invention. The purpose and other advantages of the present invention can be realized and obtained by the structures particularly pointed out in the written description, claims, and drawings.

[0015] The technical solution of the present invention is further described in detail below through the accompanying drawings and embodiments. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] The accompanying drawings are used to provide a further understanding of the present invention and constitute a part of the specification. Together with the embodiments of the present invention, they are used to explain the present invention and do not constitute a limitation of the present invention. In the accompanying drawings: Figure 1 A flowchart of an Oracle database full-text search statement restoration and synchronization method provided by an embodiment of the present invention; Figure 2 A schematic block diagram of an Oracle database full-text search statement restoration and synchronization device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0017] The present invention is further described in detail below with reference to specific embodiments, but the embodiments of the present invention are not limited thereto.

[0018] like Figure 1 As shown, a first aspect of an embodiment of the present invention provides an Oracle database full-text search statement restoration and synchronization method, which is applied to a source end and includes the following steps: Step 11, in the synchronous administrator mode, call the search configuration object to perform a full-text search on the database for a preset search target.

[0019] Step 12: In response to the full-text search completion instruction, obtain a system table operation statement.

[0020] Step 13: Analyze the system table operation statement to determine whether the system table operation statement contains the name of the operation object to be operated when calling the retrieval configuration object.

[0021] The name of the operation object is created based on the user name of the synchronization administrator.

[0022] Step 14: When the DML operation information in the modification log is updated, the system table operation statement is searched in the tracking log file.

[0023] Step 15, when a system table operation statement is found, the name of the operation object based on the user name of the current user is obtained.

[0024] Step 16, determining the operation statement to be synchronized when the current user calls the search configuration object to perform full-text search based on the operation type in the system table operation statement corresponding to the name of the operation object based on the user name of the current user.

[0025] Step 17: Send the statement to be synchronized to the target end.

[0026] In this embodiment, the system table operation statement is analyzed to determine the name of the operation object for the operation performed when the retrieval configuration object is called in the system table operation statement. Furthermore, when it is necessary to synchronize the operation statement for calling the retrieval configuration object to perform a full-text search, the operation type in the system table operation statement corresponding to the name of the operation object based on the user name of the current user can be obtained from the system table operation statement. Thus, the operation statement for calling the retrieval configuration object to perform a full-text search that needs to be synchronized can be restored, and the operation statement can be synchronized to complete the data synchronization of the full-text search operation statement, thereby ensuring the integrity of the backup data.

[0027] On the basis of the first aspect of the embodiment of the present invention, the second aspect of the embodiment of the present invention further describes in detail an Oracle database full-text search statement restoration synchronization method. The second aspect of the embodiment of the present invention provides an Oracle database full-text search statement restoration synchronization method, which is applied to the source end and includes the following steps: Step 21, in the synchronous administrator mode, calls the search configuration object ctx_ddl to perform a full-text search on the database for a preset search target.

[0028] In this step, some of the operation statements of the full-text search function of the Oracle database will be associated with the user name. When the full-text search is performed in the synchronization administrator mode, the operation statements will be associated with the user name of the synchronization administrator, so that the operation statements associated with the user name can be easily identified.

[0029] The example exec ctx_ddl.create_preference('ctfs_lexer','chinese_vgram_lexer') is a full-text search operation statement that calls ctx_ddl, where ctfs in 'ctfs_lexer' represents the user's username. However, the operation statement cannot be directly obtained from the redo log. The redo log is a log that records DML operations such as inserting, modifying, and deleting data in the database. The method of this embodiment is required to restore the information of the operation statement.

[0030] Step 22, in response to the full-text search completion instruction, obtain the system table operation statement.

[0031] Specifically, in response to the full-text search completion instruction, the current trace log file is obtained; then the current trace log file is parsed to obtain the system table operation statement. The trace log file is a trace file. The trace file records the DML operation statements of the ctxsys.drXXX system table (ctxsys.dr$index_set, ctxsys.dr$index_object, ctxsys.DR$PREFERENCE, etc.). By parsing the trace file, the system table operation statement can be obtained.

[0032] For example, a system table operation statement is obtained: SQL>select * from ctxsys.DR$PREFERENCE where rowid='AAANh4AACAAACVPAAD'; PRE_ID PRE_OWNER# PRE_NAMEPRE_OBJ_ID PRE_CLA_ID PRE_VALID 1064293 CTFS_LEXER46N This operation indicates that the database inserted a record into the DR$PREFERENCE table when executing ctx_ddl.create_preference. Therefore, when performing a full-text search, the database will operate on the system table.

[0033] Step 23, analyzing the system table operation statement to determine whether the system table operation statement contains the name of the operation object to be operated when calling the retrieval configuration object.

[0034] The name of the operation object is created based on the user name of the synchronization administrator.

[0035] In this step, the system table operation statement is searched and analyzed. There is a name in the system table statement, which includes the user name of the synchronization administrator and the operation object to be operated when calling the retrieval configuration object. This name is related to the full-text search operation. Therefore, it can be determined that when calling the retrieval configuration object for full-text search, the system table operation statement can generate information related to the full-text search, and the full-text search operation statement that calls ctx_ddl can be restored using this information later.

[0036] For example, in the statement of step 22, SQL>select * from ctxsys.DR$PREFERENCE where rowid='AAANh4AACAAACVPAAD'; PRE_ID PRE_OWNER# PRE_NAMEPRE_OBJ_ID PRE_CLA_ID PRE_VALID 1064293 CTFS_LEXER46N CTFS_LEXER is the name of the operation object to be operated when calling the retrieval configuration object, where CTFS is the user name of the synchronization administrator and LEXER is the operation object to be operated when calling the retrieval configuration object, which is the same as the ctfs_lexer in the example in step 21.

[0037] Step 24: When the DML operation information in the modification log is updated, the system table operation statement is searched in the tracking log file.

[0038] Specifically, when DML operation information is added to the modification log, the system table operation statement is searched in the tracking log file. When the DML operation statement in the modification log redo increases, it indicates that a change operation has been performed on the database, such as inserting, modifying, deleting and other data change operations. At this time, the database synchronization program needs to be started to synchronize the modified content of the database to the target database. At this time, the database may also perform full-text search operations. If so, the related operations of the full-text search operation can also be synchronized to the target.

[0039] Step 25, when the system table operation statement is found, it is determined whether there is a name of an operation object based on the user name of the current user in the system table operation statement.

[0040] After obtaining the system table operation statement in the trace file, search for the name of the operation object based on the current user's username in the system table operation statement, that is, the name of the operation object to be operated when the current user uses the Oracle database to perform the full-text search function and calls the retrieval configuration object. This name is related to the current user's username as described in the above steps.

[0041] If the name is not found, it means that there is no database and no full-text search is performed. There is no need to synchronize the data, and the newly added DML operation information can be synchronized. If the name is found, execute step 26.

[0042] Step 26, if the name is found, then determine the operation type when the target calls the search configuration object to perform full-text search according to the operation type in the system table operation statement corresponding to the name of the operation object based on the user name of the current user.

[0043] In this step, if the name is found, the system table operation statement where the name is located can be obtained based on the name, and then based on the correspondence between the operation type in the system table operation statement and the operation type when calling the retrieval configuration object to perform a full-text search, the operation type when the target calling the retrieval configuration object performs a full-text search corresponding to the system table operation statement where the name is located can be obtained.

[0044] The correspondence between the operation type in the system table operation statement and the operation type when the search configuration object is called to perform full-text search may be a relationship mapping table.

[0045] Step 27, according to the operation type when the target calls the retrieval configuration object to perform full-text retrieval, generate the operation statement to be synchronized when the current user calls the retrieval configuration object to perform full-text retrieval.

[0046] In this step, after obtaining the operation type, the corresponding operation statement can be generated, that is, the operation statement when calling the retrieval configuration object to perform a full-text search is restored. For example, in the above example, the operation type when the target calls the retrieval configuration object to perform a full-text search is create_preference, and the restored operation statement to be synchronized is ctx_ddl.create_preference. For example, if other operation types can be restored to obtain operation statements to be synchronized such as ctx_ddl.create_index_set, ctx_ddl.drop_index_set, begin ctx_ddl.add_index, ctx_ddl.remove_index, ctx_ddl.drop_shadow_index, ctx_ddl.drop_policy, these statements indicate the corresponding operations when calling the retrieval configuration object to perform a full-text search.

[0047] Step 28: Send the operation statement to be synchronized to the target end to complete the synchronization.

[0048] like Figure 2 As shown, a third aspect of an embodiment of the present invention provides an Oracle database full-text search statement restoration synchronization device, including: An execution module 31 is used to call a search configuration object in a synchronous administrator mode to perform a full-text search on a database for a preset search target; A first acquisition module 32, for acquiring a system table operation statement in response to a full-text search completion instruction; The first determination module 33 is used to analyze the system table operation statement to determine the name of the operation object to be operated when calling the retrieval configuration object in the system table operation statement; wherein the name of the operation object is created based on the user name of the synchronization administrator; A search module 34 is used to search for system table operation statements in the tracking log file when the DML operation information in the modification log is updated; The second acquisition module 35 is used to acquire the name of the operation object based on the user name of the current user when the system table operation statement is found; The second determination module 36 is used to determine the operation statement to be synchronized when the current user calls the search configuration object to perform full-text search according to the operation type in the system table operation statement corresponding to the name of the operation object based on the user name of the current user; The sending module 37 is used to send the operation statement to be synchronized to the target end.

[0049] In one embodiment of the present invention, in response to a full-text search completion instruction, a system table operation statement is obtained, including: In response to the full-text search completion instruction, obtaining the current tracking log file; Parse the current trace log file and obtain system table operation statements.

[0050] In one embodiment of the present invention, when the DML operation information in the modification log is updated, searching the tracking log file for the system table operation statement includes: When DML operation information is added to the modification log, the system table operation statement is searched in the tracking log file.

[0051] In one embodiment of the present invention, determining the operation statement to be synchronized when the current user calls the search configuration object to perform a full-text search based on the operation type in the system table operation statement corresponding to the name of the operation object based on the user name of the current user includes: Determine the operation type when the target calls the search configuration object to perform full-text search according to the operation type in the system table operation statement corresponding to the name of the operation object based on the user name of the current user; According to the operation type when the target calls the retrieval configuration object to perform full-text retrieval, an operation statement to be synchronized when the current user calls the retrieval configuration object to perform full-text retrieval is generated.

[0052] A fourth aspect of an embodiment of the present invention provides an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the program, an Oracle database full-text search statement restoration and synchronization method provided by the above-mentioned embodiment of the present invention is implemented.

[0053] A fifth aspect of an embodiment of the present invention further provides a computer-readable storage medium having a computer program stored thereon. When the computer program is executed by a processor, the steps of an Oracle database full-text search statement restoration and synchronization method provided by the above-mentioned embodiment of the present invention are implemented.

[0054] The memory may include a random access memory (RAM) or a non-volatile memory (NVM), such as at least one disk memory. Optionally, the memory may also be at least one storage device located away from the aforementioned processor.

[0055] The above-mentioned processor can be a general-purpose processor, including a central processing unit (CPU), a network processor (NP), etc.; it can also be a digital signal processor (DSP), an application specific integrated circuit (ASIC), a field programmable gate array (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware systems.

[0056] The method provided in the embodiment of the present invention can be applied to electronic devices. Specifically, the electronic device can be: a desktop computer, a portable computer, an intelligent mobile terminal, a server, etc. This is not limited here, and any electronic device that can implement the present invention belongs to the protection scope of the present invention.

[0057] As for the device / electronic device embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.

[0058] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0059] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0060] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0061] Obviously, those skilled in the art can make various changes and modifications to the present invention without departing from the spirit and scope of the present invention. Thus, if these modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include these modifications and variations.

Claims

1. A method for restoring and synchronizing full-text search statements in an Oracle database, characterized in that: Applied to the source end, it includes the following steps: In synchronous administrator mode, call the search configuration object to perform a full-text search on the database for the preset search target; In response to the full-text search completion instruction, obtaining a system table operation statement; Analyze the system table operation statement to determine the name of the operation object to be operated when calling the retrieval configuration object in the system table operation statement; wherein the name of the operation object is created based on the user name of the synchronization administrator; When the DML operation information in the modification log is updated, the system table operation statement is searched in the tracking log file; When a system table operation statement is found, the name of the operation object based on the user name of the current user is obtained; Determine, according to the operation type in the system table operation statement corresponding to the name of the operation object based on the user name of the current user, the operation statement to be synchronized when the current user calls the search configuration object to perform a full-text search; The to-be-synchronized operation statement is sent to the target end.

2. The method according to claim 1, characterized in that The step of obtaining a system table operation statement in response to the full-text search completion instruction includes: In response to the full-text search completion instruction, obtaining the current tracking log file; The current tracking log file is parsed to obtain system table operation statements.

3. The method according to claim 1, characterized in that When the DML operation information in the modification log is updated, searching the tracking log file for system table operation statements includes: When DML operation information is added to the modification log, the system table operation statement is searched in the tracking log file.

4. The method according to claim 1, characterized in that The step of determining the operation statement to be synchronized when the current user calls the search configuration object to perform a full-text search based on the operation type in the system table operation statement corresponding to the name of the operation object based on the user name of the current user comprises: Determine the operation type when the target calls the search configuration object to perform full-text search according to the operation type in the system table operation statement corresponding to the name of the operation object based on the user name of the current user; According to the operation type when the target calls the retrieval configuration object to perform full-text retrieval, an operation statement to be synchronized when the current user calls the retrieval configuration object to perform full-text retrieval is generated.

5. An Oracle database full-text search statement restoration synchronization device, characterized in that: include: An execution module, used to call the search configuration object in the synchronous administrator mode to perform a full-text search on the database for a preset search target; A first acquisition module, for acquiring a system table operation statement in response to a full-text search completion instruction; A first determination module is used to analyze the system table operation statement to determine the name of the operation object to be operated when calling the retrieval configuration object in the system table operation statement; wherein the name of the operation object is created based on the user name of the synchronization administrator; A search module is used to search for system table operation statements in the tracking log file when the DML operation information in the modification log is updated; The second acquisition module is used to acquire the name of the operation object based on the user name of the current user when the system table operation statement is found; A second determination module is used to determine the operation statement to be synchronized when the current user calls the search configuration object to perform full-text search according to the operation type in the system table operation statement corresponding to the name of the operation object based on the user name of the current user; The sending module is used to send the operation statement to be synchronized to the target end.

6. The device according to claim 5, characterized in that The step of obtaining a system table operation statement in response to the full-text search completion instruction includes: In response to the full-text search completion instruction, obtaining the current tracking log file; The current tracking log file is parsed to obtain system table operation statements.

7. The device according to claim 5, characterized in that When the DML operation information in the modification log is updated, searching the tracking log file for system table operation statements includes: When DML operation information is added to the modification log, the system table operation statement is searched in the tracking log file.

8. The device according to claim 5, characterized in that The step of determining the operation statement to be synchronized when the current user calls the search configuration object to perform a full-text search based on the operation type in the system table operation statement corresponding to the name of the operation object based on the user name of the current user comprises: Determine the operation type when the target calls the search configuration object to perform full-text search according to the operation type in the system table operation statement corresponding to the name of the operation object based on the user name of the current user; According to the operation type when the target calls the retrieval configuration object to perform full-text retrieval, an operation statement to be synchronized when the current user calls the retrieval configuration object to perform full-text retrieval is generated.

9. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the program, the Oracle database full-text search statement restoration and synchronization method as described in any one of claims 1 to 4 is implemented.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the Oracle database full-text search statement restoration and synchronization method described in any one of claims 1 to 4 is implemented.

Images