TWI423052B - System and method for scanning of the database - Google Patents

Description

Database active scanning system and method

The invention relates to a database active scanning system and method.

Today, with the rapid development of office automation, the database system can be said to be the most widely used software. Almost 90% of the systems we use in our work and life can be called database systems. Whether these systems are web-based or desktop applications, they all share a common feature: database technology.

At present, the methods for accessing the database in the Web system and the application system are both passive and global access, that is, once the data is changed, the database passively receives the message, and then globally scans the entire database to find the modified data. Finally, the changed data is presented on the user side. In this way, even if the user modifies a very simple piece of data, the database must scan all the data, and most of the data are unnecessary to be scanned. data of. Every time a database is accessed, a large part of the resources and time are wasted on the scanning of the data that has not changed, and too frequent access to the database will put a lot of pressure on the database, which may lead to the database. Crash and loss of data.

In view of the above, it is necessary to provide an effective database active scanning system and method.

The computer system actively scanning the database, the computer system includes: an acquisition module, configured to acquire IDs of all data tables in the database, and The obtained ID is stored in a data structure; a setting module is configured to set an attribute value of each ID in the data structure, and each ID includes two attribute values: a first attribute value and a second attribute value, and The initial value of the attribute of the ID is a second attribute value, and the setting module is further configured to change the attribute of the ID of the modified data table in the data structure from the second attribute value to the first attribute value; a group, configured to: when an application system modifies a database, receive an ID of a modified data table in a database sent by the application system; and a control module, configured to control the application system to acquire all attributes in the data structure The ID of the first attribute value is further used to control the application system to obtain the data in the data table corresponding to the ID in the database according to the ID of the first attribute value; and the setting module is further After the application system acquires the IDs of all the attributes in the data structure as the first attribute value, the attributes in the data structure whose attributes are the IDs of the first attribute values are reset to the second attribute values. .

The database active scanning method, the method comprising the steps of: obtaining an ID of all data tables in the database, and storing the obtained ID in a data structure; setting an attribute value of each ID in the data structure, Each ID includes two attribute values: a first attribute value and a second attribute value, and the attribute initial value of the ID is a second attribute value; receiving an ID of the modified data table in the database sent by the application system; Changing an attribute of the ID of the modified data table in the data structure from a second attribute value to a first attribute value; the application system acquires an ID of all attributes in the data structure as a first attribute value; The attribute in the data structure is reset to the attribute of the ID of the first attribute value to the second attribute value; and the application system is based on the attribute Obtaining, in the ID of the first attribute value, the data in the data table corresponding to the ID in the database.

Compared with the prior art, the database actively scans the system and the method, so that the database can actively observe and scan, which reduces the invalid access to the database, reduces the burden of data access on the database, and improves the access of the database. effectiveness.

As shown in FIG. 1, it is a hardware architecture diagram of a preferred embodiment of a computer system for actively scanning a database of the present invention. The computer system 1 runs a plurality of application systems 2, and the application system 2 is connected to a database 3, which may be in the computer or outside the computer. The database 3 is used to store all the materials of the application system 2. The application system 2 also provides a user interface for the user to view the data and data updates in the database. The database 3 has a plurality of data tables 4, each of which has a plurality of data, and each of the data tables 4 corresponds to an ID. In the present embodiment, the present invention will be described by taking an application system 2 as an example. The application system 2 simultaneously sends a notification that the database 3 is modified to the computer system 1 when a command to modify the data is presented to the database 3.

As shown in FIG. 2, it is a functional module diagram of a preferred embodiment of a computer system for actively scanning the database of the present invention. The computer system includes an acquisition module 10, a setting module 12, a receiving module 14, a control module 16, and a display module 18.

The obtaining module 10 is configured to acquire the IDs of all the data tables 4 in the database 3 and obtain the notification that the database 3 sent by the application system 2 is modified, and store the acquired IDs in a data structure. Data knot The structure can be a two-dimensional array, a linked list, or the like.

The setting module 12 is configured to set two attribute values for each ID in the data structure: change and original. The attribute value change indicates that the data in the data table 4 corresponding to the ID has been modified, and the attribute value original indicates that the data in the data table 4 corresponding to the ID has not been modified. The attribute initial value of the ID of all the data sheets 4 is set to original. The setting module 12 is further configured to change the attribute of the ID of the corresponding modified data table 4 in the data structure from original to change.

The receiving module 14 is configured to receive the ID of the modified data table 4 in the database 3 sent by the application system 2.

The control module 16 is configured to control the application system 2 to obtain an ID whose all attributes in the data structure are change. The control module 16 is further configured to control the application system 2 to access the data table in the database 3, the ID of the data table is the obtained ID whose attribute is change, and the application system 2 accesses the data table, and Get all the information in this fact sheet.

The setting module 12 is further configured to: after the application system 2 obtains all the IDs whose attributes are changed in the data structure, the ID of the attribute in the data structure is changed to original, which is convenient for distinguishing when accessing the data structure next time. The ID of the modified data sheet.

The display module 18 is configured to update and display the data acquired by the application system 2 on the interface of the application system 2.

As shown in FIG. 3, it is a flowchart of the operation of the preferred embodiment of the active scanning method of the database of the present invention.

Step S30, the obtaining module 10 obtains all the data tables in the database 3. The ID of 4, and the obtained ID is stored in a data structure, which may be a two-dimensional array, a linked list, or the like.

In step S32, the setting module 12 sets each attribute ID in the data structure with two attribute values: change and original. The attribute value change indicates that the data in the data table 4 corresponding to the ID has been modified, and the attribute value original indicates that the data in the data table 4 corresponding to the ID has not been modified. The attribute initial value of the ID of all the data sheets 4 is set to original.

In step S34, when the application system 2 issues a command to modify the data in the database 3, the notification of the modification of the database 3 is also sent to the computer system 1, and the acquisition module 10 acquires the notification that the database 3 is modified.

In step S36, the receiving module 14 receives the ID of the modified data table 4 in the database 3 sent by the application system 2.

In step S38, the setting module 12 changes the attribute of the ID of the corresponding modified data table 4 in the data structure from original to change.

In step S40, the control module 16 controls the application system 2 to acquire the ID of the data table whose attributes are change in the data structure.

In step S42, after the application system 2 acquires all IDs whose attributes are change in the data structure, the setting module 12 resets the attribute of the ID whose attribute is change in the data structure to original, which is convenient for accessing the data structure next time. Identify the ID of the modified data sheet.

Step S44, the application system 2 accesses the data table in the database 3, the ID of the data table is the obtained ID whose attribute is change, and the application system 2 accesses the data table and obtains the data table. All information.

Step S46, the display module 18 is updated on the interface of the application system 2. Show the information obtained.

The above is only the preferred embodiment of the present invention, and has been used in a wide range of applications. Any other equivalent changes or modifications which are not departing from the spirit of the present invention should be included in the following claims. Inside.

Computer system ‧‧1

Application System‧‧‧2

Database ‧ ‧

Information sheet ‧‧4

Get the module ‧‧10

Setting up the module ‧‧12

Receiving module ‧‧14

Control module ‧‧16

Display module ‧‧18

Get the ID of all the data sheets in the database and store them in a data structure. ‧‧S30

Set the attribute to the ID in the data structure ‧‧‧S32

Obtain notification that the information in the database has been modified ‧‧S34

ID of the revised data sheet in the receiving database.‧‧S36

Change the ID of the modified data table to the attribute of the corresponding ID in the data structure from original to change‧‧‧S38

The application system obtains the ID of each data sheet whose attribute is change in the data structure.‧‧S40

Change the ID of all attributes in the data structure to change to original‧‧‧S42

The application system obtains the data in the data table of the corresponding ID from the database according to the obtained attribute as the ID of the change ‧‧‧S44

Display the information in the obtained data sheet on the user interface of the application system ‧‧‧S46

1 is a hardware architecture diagram of a preferred embodiment of a computer system for actively scanning a database of the present invention.

2 is a functional block diagram of a preferred embodiment of the computer system 1 of FIG. 1.

3 is a flow chart showing the operation of a preferred embodiment of the active scanning method of the database of the present invention.

Get the ID of all the data sheets in the database and store them in a data structure. ‧‧S30

Set the attribute to the ID in the data structure ‧‧‧S32

Obtain notification that the information in the database has been modified ‧‧S34

ID of the revised data sheet in the receiving database.‧‧S36

Change the ID of the modified data table to the attribute of the corresponding ID in the data structure from original to change‧‧‧S38

The application system obtains the ID of each data sheet whose attribute is change in the data structure.‧‧S40

Change the ID of all attributes in the data structure to change to original‧‧‧S42

The application system obtains the data in the data table of the corresponding ID from the database according to the obtained attribute as the ID of the change ‧‧‧S44

Display the information in the obtained data sheet on the user interface of the application system ‧‧‧S46

Claims (8)

A computer system for actively scanning a database, the computer system comprising: an acquisition module, configured to acquire an ID of all data tables in the database, and store the acquired ID in a data structure; and set a module for Setting an attribute value of each ID in the data structure, each ID includes two attribute values: a first attribute value and a second attribute value, and the initial value of the ID attribute is a second attribute value, and the setting module And is further configured to change an attribute of the ID of the modified data table in the data structure from a second attribute value to a first attribute value; and a receiving module, configured to receive the application system when the application system modifies the database An ID of the modified data table in the sent database; a control module, configured to control the application system to obtain an ID of all attributes in the data structure as a first attribute value, and also to use the attribute as a first attribute The ID of the value, the application system is configured to obtain the data in the data table corresponding to the ID in the database; and the setting module is further configured to: when the application system acquires the attribute in the data structure, the first After the ID of the attribute value, will The attribute in the data structure is reset to the attribute of the ID of the first attribute value to the second attribute value. The computer system for actively scanning the database according to the first aspect of the patent application, the obtaining module is further configured to: when the application system issues a command to modify the data in the database, obtain a notification that the database is modified. The computer system for actively scanning the database according to the first aspect of the invention, wherein the computer system further comprises: a display module, configured to update and display the acquired data on the interface of the application system. The computer system actively scanning the database according to the first aspect of the patent application, wherein the first attribute value is change and the second attribute value is original. A database active scanning method, the method comprising the steps of: obtaining an ID of all data tables in a database, and storing the obtained ID in a data structure; setting an attribute value of each ID in the data structure, each The ID includes two attribute values: a first attribute value and a second attribute value, and the attribute initial value of the ID is a second attribute value; receiving an ID of a modified data table in a database sent by the application system; The attribute of the ID of the modified data table in the data structure is changed from the second attribute value to the first attribute value; the application system acquires an ID of all attributes in the data structure as the first attribute value; The attribute in the structure is reset to the attribute of the ID of the first attribute value to the second attribute value; and the application system acquires the data table corresponding to the ID in the database according to the ID of the attribute as the first attribute value. data. The method for actively scanning the database according to claim 5, before receiving the ID of the modified data table in the database sent by the application system, the method further includes: when the application system issues a modified database When the command of the data is obtained, the notification that the database is modified is obtained. The active scanning method of the database as described in claim 5, the method further comprising: updating the display on the interface of the application system Information obtained by the system. The active scanning method of the database according to claim 5, wherein the first attribute value is change and the second attribute value is original.