Database visual monitoring method, system, terminal device and storage medium

Abstract

The present application relates to the field of database technology, and in particular to a method, system, terminal device and storage medium for visual monitoring of a database, wherein the method comprises the following steps: obtaining a preset data template; parsing the online database and the local database based on the data template to obtain visual online data information and local data information; analyzing the online data information and the local data information to obtain analysis results; and obtaining updated content of the local data information based on the analysis results. The setting of the present application can uniformly manage the operation and maintenance process of the database and improve the monitoring effect of the database.

Description

Technical Field

[0001] The present application relates to the field of database technology, and in particular to a database visualization monitoring method, system, terminal device and storage medium. Background Art

[0002] In various business applications, application systems usually deploy databases to store data for the entire system. Databases are an important component of application systems, so monitoring the database is very important.

[0003] Databases are generally divided into online databases and local databases. Taking a software as an example, the online database stores all the data of the software, and the local database represents the data that can be edited by the developer. When the software is first launched, the data in the online database and the local database are consistent.

[0004] When developers need to modify or supplement local data, they directly edit and save the files or data in the local database, and the developer records it or the database administrator (DBA) monitors the local database to facilitate subsequent updates to the online database.

[0005] Regarding the above-mentioned related technologies, the inventors believe that the operation and maintenance of the database, whether it is real-time recording by developers or real-time monitoring by DBAs, requires a large amount of manual input, is prone to omissions, and management is relatively chaotic, resulting in incomplete update content and poor monitoring effect. Summary of the invention

[0006] In order to uniformly manage the operation and maintenance process of a database and improve the monitoring effect of the database, the present application provides a database visual monitoring method, system, terminal device and storage medium.

[0007] In a first aspect, the present application provides a database visualization monitoring method, which adopts the following technical solution:

[0008] A database visual monitoring method comprises the following steps:

[0009] Get the preset data template;

[0010] Parsing the online database and the local database based on the data template to obtain visualized online data information and local data information;

[0011] Analyze the online data information and the local data information to obtain analysis results;

[0012] The updated content of the local data information is obtained based on the analysis result.

[0013] By adopting the above technical solution, the online database and the local database are parsed based on the preset data template to obtain visualized online data information and local data information, and to determine whether there are differences between the local data information and the online data information. If there are differences, the updated content is obtained so that the online database can be updated later. This application reduces the manual input in the database operation and maintenance process. Any changes in the local database can be monitored and managed in a unified manner in a timely manner, and the updated content can be automatically obtained so that the online database can be updated, thereby improving the monitoring effect of the database.

[0014] Optionally, parsing the online database and the local database based on the data template to obtain visualized online data information and local data information includes the following steps:

[0015] Acquire template information of the data template;

[0016] The online database and the local database are parsed based on the template information to obtain online data information and local data information matching the template information and display them.

[0017] By adopting the above technical solution, the data in the online database and the local database are intuitively displayed using data templates for easy viewing.

[0018] Optionally, the analyzing the online data information and the local data information to obtain the analysis result comprises the following steps:

[0019] Analyzing whether there is a difference between the online data information and the local data information;

[0020] If there is a difference, it is determined that the local data information is updated;

[0021] If there is no difference, it is determined that the local data information is not updated.

[0022] By adopting the above technical solution, it is possible to determine whether there is a difference between online data information and local data information, and whether the local data information has been updated. There is no need for developers to record in real time, which reduces manual input and facilitates unified management of the database.

[0023] Optionally, the analyzing whether there is a difference between the online data information and the local data information comprises the following steps:

[0024] Respectively obtain a first hash value of the online data information and a second hash value of the local data information;

[0025] Determine whether the first Hash value is consistent with the second Hash value;

[0026] If they are consistent, it is determined that there is no difference between the online data information and the local data information;

[0027] If they are inconsistent, it is determined that there is a difference between the online data information and the local data information.

[0028] By adopting the above technical solution, whether there is a difference between the online data information and the local data information is confirmed based on the comparison between the first hash value and the second hash value, the calculation is more accurate, and the possibility of missing updated content is reduced.

[0029] Optionally, the acquiring the updated content of the local data information based on the analysis result comprises the following steps:

[0030] When it is determined that the local data information is updated, the difference information between the online data information and the local data information is obtained and marked and displayed;

[0031] All the difference information is summarized and output as update content.

[0032] By adopting the above technical solution, the difference information can be managed in a unified manner to form updated content, which is convenient for subsequent updating of the online database.

[0033] Optionally, obtaining difference information between the online data information and the local data information and annotating and displaying the difference information includes the following steps:

[0034] Obtain a difference file between the local data information and the online data information, and use the difference file as difference information;

[0035] The difference fields in the difference file are obtained based on the file search engine, and the difference files and the difference fields are annotated and displayed.

[0036] By adopting the above technical solution, after obtaining the difference file, the difference file is analyzed through the file search engine to obtain the difference fields with differences, and the difference fields are marked and displayed, so as to facilitate viewing and determining the specific modification information in the local data information.

[0037] In a second aspect, the present application also provides a database visualization monitoring system, which adopts the following technical solution:

[0038] A database visual monitoring system comprises: an acquisition module, a parsing module, an analysis module and an output module, wherein the parsing module is connected to the acquisition module, the analysis module is connected to the parsing module, and the output module is connected to the analysis module;

[0039] The acquisition module is used to acquire a preset data template;

[0040] The parsing module is used to parse the online database and the local database based on the data template to obtain visualized online data information and local data information;

[0041] The analysis module is used to analyze the online data information and the local data information to obtain analysis results;

[0042] The output module is used to obtain the updated content of the local data information based on the analysis result.

[0043] By adopting the above technical solution, the parsing module parses the online database and the local database based on the preset data template to obtain visualized online data information and local data information. The analysis module determines whether there is a difference between the local data information and the online data information. If there is a difference, the output module obtains the update content so that the online database can be updated later, reducing the manual input in the database operation and maintenance process. Any changes in the local database can be monitored and managed in a unified manner in a timely manner, and the update content can be automatically obtained so that the online database can be updated, thereby improving the monitoring effect of the database.

[0044] Optionally, the analysis module includes a judgment unit and an analysis unit, and the judgment unit is connected to the analysis unit;

[0045] The judgment unit is used to respectively obtain a first hash value of the online data information and a second hash value of the local data information, and judge whether the first hash value is consistent with the second hash value to obtain a judgment result;

[0046] The analyzing unit is used to analyze whether there is a difference between the online data information and the local data information based on the judgment result, and obtain an analysis result.

[0047] By adopting the above technical solution, whether there is a difference between the online data information and the local data information can be confirmed based on the comparison of the first hash value and the second hash value, and then whether the local data information has been updated can be determined. The updated file can be accurately obtained without the need for developers to record in real time, which reduces manual input and facilitates unified management of the database.

[0048] In a third aspect, the present application provides a terminal device, which adopts the following technical solution:

[0049] A terminal device includes a memory, a processor, and a computer program stored in the memory and capable of running on the processor. When the processor loads and executes the computer program, the above-mentioned database visualization monitoring method is adopted.

[0050] By adopting the above technical solution, a computer program is generated by the above database visualization monitoring method and stored in a memory so as to be loaded and executed by a processor, thereby making a terminal device based on the memory and the processor for easy use.

[0051] In a fourth aspect, the present application provides a computer-readable storage medium, which adopts the following technical solution:

[0052] A computer-readable storage medium stores a computer program, and when the computer program is loaded and executed by a processor, the above-mentioned database visualization monitoring method is adopted.

[0053] By adopting the above technical solution, a computer program is generated by the above database visualization monitoring method and stored in a computer-readable storage medium so as to be loaded and executed by a processor. The computer-readable storage medium facilitates the reading and storage of the computer program. BRIEF DESCRIPTION OF THE DRAWINGS

[0054] Figure 1 It is a schematic diagram of the overall process of a database visualization monitoring method according to an embodiment of the present application.

[0055] Figure 2 It is a flowchart of step S201-step S202 in a database visualization monitoring method in an embodiment of the present application.

[0056] Figure 3 It is a flowchart of step S301-step S302 in a database visualization monitoring method in an embodiment of the present application.

[0057] Figure 4 It is a flowchart of steps S401 to S404 in a database visualization monitoring method according to an embodiment of the present application.

[0058] Figure 5 It is a flowchart of step S501-step S502 in a database visualization monitoring method in an embodiment of the present application.

[0059] Figure 6 It is a flowchart of step S601-step S602 in a database visualization monitoring method according to an embodiment of the present application.

[0060] Figure 7 It is a schematic diagram of an overall module of a database visual monitoring according to an embodiment of the present application.

[0061] Description of reference numerals:

[0062] 1. Acquisition module; 2. Parsing module; 3. Analysis module; 31. Judgment unit; 32. Analysis unit; 4. Output module; 41. Labeling unit; 42. Output unit. DETAILED DESCRIPTION

[0063] The present application is further described in detail below in conjunction with the accompanying drawings.

[0064] It is worth mentioning that this embodiment is described using SQL Server software as a carrier.

[0065] The present application embodiment discloses a database visualization monitoring method, referring to Figure 1 , including the following steps:

[0066] S101, obtaining a preset data template;

[0067] S102, parsing the online database and the local database based on the data template to obtain visualized online data information and local data information;

[0068] S103, analyzing the online data information and the local data information to obtain analysis results;

[0069] S104: Obtain updated content of local data information based on the analysis result.

[0070] In step S101, a data template is preset according to actual needs, and the data in the database can be parsed using the data template to intuitively display various data in the database.

[0071] In step S102, the online database and the local database are parsed according to the preset data template. Figure 2 , including the following steps:

[0072] S201, obtaining template information of a data template;

[0073] S202: parse the online database and the local database based on the template information, obtain the online data information and the local data information matching the template information, and display them.

[0074] In this embodiment, SQL Server software is used to construct a data template, which includes template information such as defined tables, views, stored procedures, functions, and jobs. For the convenience of explanation, this embodiment uses tables, views, and stored procedures as examples to explain the template information.

[0075] Specifically, a table is the basic unit for storing data, and is used to store business data, such as merchant information; the function of a view is to query multiple target data together; a stored procedure is a database object that stores complex programs in the database for external programs to call. A stored procedure is a set of SQL statements to complete specific functions. It is compiled, created, and saved in the database. Users can call and execute it by specifying the name of the stored procedure and giving parameters (when necessary). After using a data template to parse the data in the database, the data in the database can be intuitively displayed according to the template information, that is, the original data in the database becomes visual data.

[0076] Specifically, by parsing the data in the downloaded online database according to the defined template information, each file in the online data table, each file in the online data view, and each file in the online data storage process can be obtained as online data information; by parsing the data in the local database according to the template information, each file in the local data table, each file in the local data view, and each file in the local data storage process can be obtained as local data information. At the same time, the name, update status, modification time, creation time, and other information of each file in the local data information are also displayed in SQL Server for easy query.

[0077] After obtaining online data information and local data information, analyze the online data information and local data information, refer to Figure 3 , specifically including the following steps:

[0078] S301, analyzing whether there is a difference between online data information and local data information;

[0079] S302: If there is a difference, determine that the local data information is updated;

[0080] S303: If there is no difference, determine that the local data information is not updated.

[0081] Determine whether the developer has updated the local data by judging whether there is a difference between the online data information and the local data information. Figure 4 , the specific analysis process includes the following steps:

[0082] S401, respectively obtaining a first hash value of online data information and a second hash value of local data information;

[0083] S402, determining whether the first hash value is consistent with the second hash value;

[0084] S403: If they are consistent, it is determined that there is no difference between the online data information and the local data information;

[0085] S404: If they are inconsistent, it is determined that there is a difference between the online data information and the local data information.

[0086] Hash value, i.e. HASH value, is a set of binary values ​​obtained by encrypting the file content, and is mainly used for file verification or signature. It is precisely because of this feature that this embodiment uses hash value to determine whether two files are the same.

[0087] Obtain the first hash value of each file in the online data information and the second hash value of each file in the local data information, and determine whether there is a difference between the local file and the online file by judging whether the first hash value is consistent with the second hash value, and then determine whether there is a difference between the local data information and the online data information. If the first hash value is consistent with the second hash value, it is determined that there is no difference between the online data information and the local data information at this time, that is, it is determined that the local data information has not been updated; if the first hash value is inconsistent with the second hash value, it is determined that there is a difference between the online data information and the local data information at this time, that is, it is determined that the local data information has been updated.

[0088] For example, when the hash value of file X in the online data table is M, and the hash value of file X in the local data table is N, and M is different from N, it is determined that the local data table has changed, that is, file X in the local data table has been updated.

[0089] Among them, refer to Figure 5 , after confirming that the local data information has been updated, perform the following steps:

[0090] S501, when it is determined that the local data information is updated, obtain the difference information between the online data information and the local data information, and mark and display it;

[0091] S502: Summarize all difference information and output it as update content.

[0092] In this embodiment, after determining that the local data information has been updated, since the online data information and the local data information have been visualized, the difference information can be determined at this time. Referring to the figure, the following steps are specifically included:

[0093] S601, obtaining a difference file between the local data information and the online data information, and using the difference file as difference information;

[0094] S602: Obtain difference fields in the difference files based on a file search engine, and annotate and display the difference files and the difference fields.

[0095] Specifically, the difference file is used as the difference information, and the difference file is marked with a special color (such as green), or other marking methods are used to display the difference information, so as to capture the file name, update status, modification time and creation time, etc. of the difference file, so as to facilitate viewing the modification history of the difference file.

[0096] In addition, after determining the difference file, the online fields and local fields in the difference file are compared one by one through the comparison program algorithm, and the specific fields with differences can be obtained, so that the specific modification information of the fields can be determined.

[0097] For example, if the developer increases the length of the From_Ip field in the local data table, the Y file including the From_Ip field will be changed, that is, updated. At this time, the Y file will be marked in green in SQL Server. When you click on the Y file, the original information of the From_Ip field of the Y file in the specific online data table and the specific modification information of the From_Ip field of the Y file in the local data table can be displayed for comparison and confirmation.

[0098] In step S502, after confirming the difference information, all the difference information in the local data information is summarized and output as update content, so as to facilitate subsequent updating of the online database according to the update content.

[0099] The implementation principle of a database visualization monitoring method in an embodiment of the present application is: the online database and the local database are parsed through a preset data template to obtain visualized online data information and local data information, the first hash value of all files in the online data information and the second hash value of all files in the local data information are obtained, and whether there is a difference between the local data information and the online data information is determined by judging whether the first hash value and the second hash value are consistent. If there is a difference, the difference information is obtained, and all the difference information is summarized as update content, so as to update the online database later. The setting of the present application can greatly reduce the manual input in the database operation and maintenance process. Any changes in the local database can be monitored in time, uniformly managed, and the update content can be automatically obtained to update the online database, thereby improving the monitoring effect of the database.

[0100] The present application also discloses a database visualization monitoring system, referring to Figure 6, including an acquisition module 1, a parsing module 2, an analysis module 3 and an output module 4, wherein the parsing module 2 is connected to the acquisition module 1, the analysis module 3 is connected to the parsing module 2, and the output module 4 is connected to the analysis module 3; the acquisition module 1 is used to obtain a preset data template; the parsing module 2 is used to parse the online database and the local database based on the data template to obtain visualized online data information and local data information; the analysis module 3 is used to analyze the online data information and the local data information to obtain analysis results; the output module 4 is used to obtain updated content of the local data information based on the analysis results.

[0101] Specifically, the acquisition module 1 presets a data template according to actual needs, and the data in the database can be parsed using the data template to intuitively display each data in the database.

[0102] Specifically, in this embodiment, SQL Server software is used to construct a data template, which includes template information of defined tables, views, stored procedures, functions, jobs, etc. For the convenience of explanation, this embodiment uses tables, views and stored procedures as examples to explain the template information.

[0103] More specifically, a table is the basic unit for storing data, which is used to store business data, such as merchant information; the function of a view is to query multiple target data together; a stored procedure is a database object that stores complex programs in the database for external programs to call. A stored procedure is a set of SQL statements to complete specific functions. It is compiled, created and saved in the database. Users can call and execute it by specifying the name of the stored procedure and giving parameters (when necessary). After the data template is used to parse the data in the database, the data in the database can be intuitively displayed according to the template information, that is, the original data in the database becomes visual data.

[0104] Specifically, the parsing module 2 parses the data in the downloaded online database according to the defined template information, and can obtain online data tables, online data views and online data storage processes as online data information; and parses the data in the local database according to the template information, and can obtain local data tables, local data views and local data storage processes as local data information.

[0105] Specifically, the analysis module 3 includes a judgment unit 31 and an analysis unit 32. The judgment unit 31 is used to obtain the first hash value of the online data information and the second hash value of the local data information, and judge whether the first hash value is consistent with the second hash value to obtain a judgment result. The analysis unit 32 is used to analyze whether there is a difference between the online data information and the local data information according to the judgment result, and obtain an analysis result.

[0106] More specifically, the judgment unit 31 obtains the first hash value of each file in the online data information and the second hash value of each file in the local data information, and determines whether there is a difference between the local file and the online file by judging whether the first hash value is consistent with the second hash value, and then determines whether there is a difference between the local data information and the online data information. If the first hash value is consistent with the second hash value, the judgment unit 31 determines that there is no difference between the online data information and the local data information at this time, that is, it is determined that the local data information has not been updated; if the first hash value is inconsistent with the second hash value, the judgment unit 31 determines that there is a difference between the online data information and the local data information at this time, that is, it is determined that the local data information has been updated.

[0107] For example, when the hash value of file X in the online data table is M and the hash value of file X in the local data table is N, and M is different from N, the judgment unit 31 determines that the local data table has changed, that is, file X in the local data table has been updated.

[0108] More specifically, the analysis unit 32 receives the judgment result of the judgment unit 31. If the judgment unit 31 determines that there is no difference between the online data information and the local data information at this time, the analysis unit 32 determines that the local data information has not been updated. If the judgment unit 31 determines that there is a difference between the online data information and the local data information at this time, the analysis unit 32 determines that the local data information has been updated.

[0109] Among them, the output module 4 includes a marking unit 41 and an output unit 42. In this embodiment, after determining that the local data information has been updated, since the online data information and the local data information have been visualized, the marking unit 41 obtains the difference file, uses the difference file as the difference information, and marks the difference file with a special color (such as green). Other marking methods can also be used to display the difference information, so as to capture the file name, update status, modification time and creation time of the difference file, etc., so as to facilitate viewing the modification history of the difference file.

[0110] In addition, after determining the difference file, the analysis unit 32 compares the online fields and local fields in the difference file one by one through the comparison program algorithm, and can also obtain the specific fields with differences, so as to determine the specific modification information of the fields.

[0111] For example, if the developer increases the length of the From_Ip field in the local data table, the Y file including the From_Ip field is changed, that is, it is updated. At this time, the marking unit 41 marks the Y file in green in SQL Server. When the Y file is clicked, the original information of the From_Ip field of the Y file in the specific online data table and the specific modification information of the From_Ip field of the Y file in the local data table can be displayed for comparison and confirmation.

[0112] The output unit 42 collects all the difference information annotated by the annotation unit 41 to form updated content and outputs it, so that the online database can be updated according to the updated content later.

[0113] The implementation principle of a database visualization monitoring system in an embodiment of the present application is as follows: the parsing module 2 parses the online database and the local database through a preset data template to obtain visualized online data information and local data information, the analysis module 3 obtains the first hash value of all files in the online data information and the second hash value of all files in the local data information, and determines whether there is a difference between the local data information and the online data information by judging whether the first hash value and the second hash value are consistent. If there is a difference, the output module 4 obtains the difference information and summarizes all the difference information as update content, so as to update the online database later. The setting of the present application can greatly reduce the manual input in the database operation and maintenance process, and any changes in the local database can be monitored in time, uniformly managed, and automatically obtain the update content to update the online database, thereby improving the monitoring effect of the database.

[0114] An embodiment of the present application also discloses a terminal device, including a memory, a processor, and a computer program stored in the memory and capable of running on the processor, wherein when the processor executes the computer program, a database visualization monitoring method in the above embodiment is adopted.

[0115] The terminal device may be a computer device such as a desktop computer, a laptop computer or a cloud server, and the terminal device includes but is not limited to a processor and a memory. For example, the terminal device may also include input and output devices, a network access device and a bus.

[0116] Among them, the processor can adopt a central processing unit (CPU). Of course, according to actual usage, other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. can also be adopted. The general-purpose processor can adopt a microprocessor or any conventional processor, etc., and this application does not impose any restrictions on this.

[0117] Among them, the memory can be an internal storage unit of the terminal device, such as a hard disk or memory of the terminal device, or it can be an external storage device of the terminal device, such as a plug-in hard disk, a smart memory card (SMC), a secure digital card (SD) or a flash memory card (FC) equipped on the terminal device, and the memory can also be a combination of an internal storage unit and an external storage device of the terminal device. The memory is used to store computer programs and other programs and data required by the terminal device. The memory can also be used to temporarily store data that has been output or is to be output, and this application does not impose any restrictions on this.

[0118] Among them, through this terminal device, a database visualization monitoring method in the above embodiment is stored in the memory of the terminal device, and is loaded and executed on the processor of the terminal device for easy use.

[0119] An embodiment of the present application further discloses a computer-readable storage medium, and the computer-readable storage medium stores a computer program, wherein when the computer program is executed by a processor, a database visualization monitoring method in the above embodiment is adopted.

[0120] Among them, the computer program can be stored in a computer-readable medium, the computer program includes computer program code, the computer program code can be in the form of source code, object code, executable file or certain middleware, etc. The computer-readable medium includes any entity or device that can carry the computer program code, recording medium, USB flash drive, mobile hard disk, magnetic disk, optical disk, computer memory, read-only memory (ROM), random access memory (RAM), electrical carrier signal, telecommunication signal and software distribution medium, etc. It should be noted that the computer-readable medium includes but is not limited to the above-mentioned components.

[0121] Among them, through this computer-readable storage medium, a database visualization monitoring method in the above embodiment is stored in a computer-readable storage medium, and is loaded and executed on a processor to facilitate the storage and application of the above method.

[0122] The above are all preferred embodiments of the present application, and the protection scope of the present application is not limited thereto. Therefore, any equivalent changes made according to the structure, shape, and principle of the present application should be included in the protection scope of the present application.

Claims

1. A database visual monitoring method, characterized in that: The following steps are involved: Obtain a preset data template; the data template includes defined tables, views, stored procedures, and functions. The table is a basic unit for storing data and is used to store business data. The view can be used to perform associated queries on data in multiple tables. The stored procedure is a stored program in the database and is used to call and execute a set of SQL statements with preset functions. Parsing the online database and the local database based on the data template to obtain visualized online data information and local data information; Parsing the data in the online database according to the data template, the obtained visualized online data information includes: each file in the online data table, each file in the online data view, and each file in the online data storage process; Parse the data in the local database according to the template information, and obtain visualized local data information including: each file in the local data table, each file in the local data view, and each file in the local data storage process; Analyze the online data information and the local data information to obtain analysis results; Acquire updated content of the local data information based on the analysis result; The step of parsing the online database and the local database based on the data template to obtain visualized online data information and local data information comprises the following steps: Acquire template information of the data template; The online database and the local database are parsed based on the template information to obtain online data information and local data information matching the template information and display them.

2. A database visual monitoring method according to claim 1, characterized in that: Analyzing the online data information and the local data information to obtain the analysis result comprises the following steps: Analyzing whether there is a difference between the online data information and the local data information; If there is a difference, it is determined that the local data information is updated; If there is no difference, it is determined that the local data information is not updated.

3. A database visual monitoring method according to claim 2, characterized in that: The analyzing whether there is a difference between the online data information and the local data information comprises the following steps: Respectively obtain a first hash value of the online data information and a second hash value of the local data information; Determine whether the first Hash value is consistent with the second Hash value; If they are consistent, it is determined that there is no difference between the online data information and the local data information; If they are inconsistent, it is determined that there is a difference between the online data information and the local data information.

4. A database visual monitoring method according to claim 2, characterized in that: The obtaining of the updated content of the local data information based on the analysis result comprises the following steps: When it is determined that the local data information is updated, the difference information between the online data information and the local data information is obtained and marked and displayed; All the difference information is summarized and output as update content.

5. A database visual monitoring method according to claim 4, characterized in that: Obtaining difference information between the online data information and the local data information and annotating and displaying the difference information comprises the following steps: Obtain a difference file between the local data information and the online data information, and use the difference file as difference information; The difference fields in the difference file are obtained based on the file search engine, and the difference file and the difference fields are annotated and displayed.

6. A database visual monitoring system, characterized in that: include: An acquisition module (1), a parsing module (2), an analysis module (3) and an output module (4), wherein the parsing module (2) is connected to the acquisition module (1), the analysis module (3) is connected to the parsing module (2), and the output module (4) is connected to the analysis module (3); The acquisition module (1) is used to acquire a preset data template; the data template includes a defined table, view, stored procedure, and function; the table is a basic unit for storing data and is used to store business data; the view can be used to perform an associated query on the data in multiple tables; the stored procedure is a stored program in the database and is used to call and execute a set of SQL statements with preset functions; The parsing module (2) is used to parse the online database and the local database based on the data template to obtain visualized online data information and local data information; Parsing the data in the online database according to the data template, the obtained visualized online data information includes: each file in the online data table, each file in the online data view, and each file in the online data storage process; Parse the data in the local database according to the template information, and obtain visualized local data information including: each file in the local data table, each file in the local data view, and each file in the local data storage process; The analysis module (3) is used to analyze the online data information and the local data information to obtain analysis results; The output module (4) is used to obtain updated content of the local data information based on the analysis result; The step of parsing the online database and the local database based on the data template to obtain visualized online data information and local data information comprises the following steps: Acquire template information of the data template; The online database and the local database are parsed based on the template information to obtain online data information and local data information matching the template information and display them.

7. A database visual monitoring system according to claim 6, characterized in that: The analysis module (3) comprises a judgment unit (31) and an analysis unit (32), wherein the judgment unit (31) is connected to the analysis unit (32); The judgment unit (31) is used to respectively obtain a first hash value of the online data information and a second hash value of the local data information, and judge whether the first hash value is consistent with the second hash value to obtain a judgment result; The analysis unit (32) is used to analyze whether there is a difference between the online data information and the local data information based on the judgment result, and obtain an analysis result.

8. A terminal device, comprising a memory, a processor, and a computer program stored in the memory and capable of running on the processor, characterized in that: When the processor loads and executes the computer program, the method according to any one of claims 1 to 5 is adopted.

9. A computer-readable storage medium having a computer program stored therein, characterized in that: When the computer program is loaded and executed by a processor, the method according to any one of claims 1 to 5 is adopted.

Images