TW202036321A - Database data structure change updating system and method thereof for automatic teller machine - Google Patents

Abstract

A database data structure change updating system and a method thereof for automatic teller machine (ATM) are provided. A processing database is copied from an operational database of ATM. The processing database is executed data structure change by database data structure change instruction. The operational database of ATM is interrupted operation. Changed data of the operational database is added to the processing database with data structure after transaction by audit rebuild. The operational database and the processing database are swap that the processing database is become to the operational database. The operational database of ATM is recovered operation. Therefore, the efficiency of reducing time consuming for data structure change updating of operational database of ATM may be achieved.

Description

Database data structure change update system and method suitable for automatic teller machine

A database data structure change update system and method, in particular to a database data structure change update by copying the database, and new data added to the database after the database data structure change update by audit reconstruction , And then exchange the database to apply to the system and method for the update of the database structure of the automatic teller machine.

When the existing database data structure changes for an operating database operating in an automated teller machine (Automated Teller Machine, ATM), the ATM must be completely shut down to make the operating database appear clear before it can operate on the ATM The database data structure is changed in the middle database, which will make it take too long for the database data structure change in the operating database in the ATM.

In summary, it can be seen that in the prior art, there has been a problem that it takes too long to change the database data structure of the operating database in the ATM for a long time. Therefore, it is necessary to propose improved technical means to solve this problem. .

In view of the problem that the prior art has the problem that it takes too long to change the database data structure of the operating database in the automatic teller machine, the present invention discloses a database data structure change update system and method suitable for automatic teller machines. :

The database data structure change update system suitable for automatic teller machines disclosed in the present invention includes: an operating database, a receiving module, a processing database, a data structure change processing module, a control module, a data query module, Database read-write control module and database exchange module.

The database in operation provides each automatic teller machine (Automated Teller Machine, ATM) to store and read data through data transmission; the receiving module is used to receive the database data structure change command; when the database data structure is received When the command is changed, the data in the running database is copied to the processing database; the data structure change processing module is to execute the specified data structure change in the processing database according to the database data structure change command; the control module is used to control each An automatic teller machine interrupts the storage and reading of data in the operating database; the data query module is the execution time of the specified data structure change in the data structure change processing module to process the database according to the database data structure change command Scope, query the updated data in the database in operation; the database read-write control module uses the audit rebuild method to add the updated data in the database that has been queried in the operating database with the changed data structure. Processing database; and the database exchange module will perform database exchange (SWAP) between the processing database and the operating database, so that the processing database is changed to the operating database, and then the operation of the operating database is restored.

The method for updating the database data structure of an automated teller machine disclosed in the present invention includes the following steps:

First, the database in operation provides each ATM to store and read data through data transmission; then, it receives the database data structure change instruction; then, when the database data structure change instruction is received, it will be in operation The database is copied as a processing database; then, the processing database executes the specified data structure change according to the database data structure change command; then, it controls the interruption of each automatic teller machine to the data storage and reading of the operating database; Then, the data structure change processing module will process the database according to the database data structure change command to execute the execution time range of the specified data structure change, and query the updated data in the database during operation; then, rebuild by audit The database in operation is queried and the updated data is added to the processing database with the changed data structure; finally, the processing database is exchanged with the operating database to change the processing database to operating Database, and then resume the operation of the database in operation.

The system and method disclosed in the present invention are as described above. The difference between the operating database and the prior art is that the operating database is copied to the processing database. In the processing database, the specified data structure change is executed according to the database data structure change command, and the processing is interrupted. In the operation of the database in operation, the updated data in the database in the operation will be added to the processing database in the changed data structure by the audit reconstruction method, and the processing database will be exchanged with the operating database in order to Change the processing database to the operating database, and then resume the operation of the operating database.

Through the above-mentioned technical means, the present invention can achieve the technical effect of greatly reducing the time-consuming process of database data structure changes in the operating database of the automatic teller machine.

The following describes the implementation of the present invention in detail with the drawings and embodiments, so as to fully understand and implement the implementation process of how the present invention uses technical means to solve technical problems and achieve technical effects.

Hereinafter, an embodiment will be used to illustrate the operating system and method of the implementation aspect of the present invention, and please refer to both "Figure 1" and "Figure 2". "Figure 1" shows that the present invention is suitable for automatic The system block diagram of the database data structure change update system of the teller machine; "Figure 2" is a schematic diagram of the structure of the database data structure change update applicable to the ATM of the present invention.

The database data structure change update system suitable for automatic teller machines disclosed in the present invention includes: an operating database 21, a receiving module 22, a processing database 24, a data structure change processing module 25, a control module 26, The data query module 27, the database read-write control module 28, and the database exchange module 29.

The present invention is applicable to the execution process when the operating database 21 operating in each automatic teller machine (Automated Teller Machine, ATM) 10 performs a database data structure change. Each automatic teller machine 10 includes a processor, a memory device, Connecting devices...etc. The memory devices are for example: ROM, RAM...etc. The connecting devices are cable connecting devices, optical fiber connecting devices... etc., which are just examples for illustration and do not limit the present invention. In the application area, the ATM 10 connects with the server 20 through a connection device. The ATM 10 stores and reads data in the database 21 during the operation of the server 20 through data transmission, and receives the data in the receiving module 22. When the data structure of the database is changed, the data in the database 21 in operation is copied to the processing database 24. The aforementioned server 20 includes a processor, a memory device, a connection device, etc. The memory device is, for example, ROM, RAM... etc., the connection devices are, for example, cable connection devices, optical fiber connection devices... etc. This is only an example for illustration, which does not limit the scope of application of the present invention. The database 21 and the processing database 24 are in operation. The data in the data is read, written, and copied through the database read/write control module 28. This is only an example for illustration and does not limit the scope of application of the present invention.

The present invention uses a single server 20 to implement the database data structure change update system of the present invention suitable for automatic teller machines as an illustration. According to actual hardware configuration requirements, the present invention can also use more than two servers 20 to The implementation of the present invention is applicable to the database data structure change update system of the automatic teller machine, for example: a server 20 is used to provide each automatic teller machine 10 with data transmission in the operation of the server 20 to store data in the database 21 And read, a server 20 is used to provide subsequent receiving module 22, processing database 24, data structure change processing module 25, control module 26, data query module 27, database read-write control module 28 And the realization of the database exchange module 29; or a server 20 is provided for each ATM 10 to store and read data in the database 21 during the operation of the server 20 through a data transmission method. The server 20 provides the realization of the receiving module 22, the processing database 24, the data structure change processing module 25, the data query module 27, the database reading and writing control module 28, and the database exchange module 29. The realization of the control module 26 provided by the server 20 is only an example here, and the application scope of the present invention is not limited by this.

When copying the data of the operating database 21 to the processing database 24, the operating database 21 is still provided to each ATM 10 for operation, and the data structure change processing module 25 can then transfer the processing database 24 according to the data The database data structure change command executes the specified data structure change. Specifically, assuming that the database data structure change command is to add a field in the database, the data structure change processing module 25 will process the database 24 according to the database data The structure change command adds fields. Assuming that the database data structure change command is to change the name of a field in the database, the data structure change processing module 25 will process the database 24 according to the database data structure change command. The change of the name is just an example here, and it does not limit the scope of application of the present invention.

After the data structure change processing module 25 executes the specified data structure change in the processing database 24 according to the database data structure change command, the control module 26 can control each ATM 10 to perform data processing on the database 21 in operation. When the storage and reading are interrupted, the data query module 27 can process the database 24 in the data structure change processing module 25 to execute the specified data structure change execution time range according to the database data structure change command, and the database is in operation. 21 Query the updated data of the transaction. For example, the data in the database 21 in operation is changed by depositing and the data of the corresponding account in the database 21 in operation is changed, and the data of the corresponding account in the database 21 in operation is changed by withdrawal. The data change, the remittance (including export and import) of the data change, which causes the data change of the corresponding account in the database 21 in operation, etc., are only examples for illustration, and the application scope of the present invention is not limited by this.

Specifically, suppose that the specified data structure change in the processing database 24 is executed from 9 o'clock to 10 o'clock, that is, it is necessary to find the updated data in the operating database 21 from 9 o'clock to 10 o'clock. This is only To illustrate, the scope of application of the present invention is not limited by this.

In the data query module 27, the data structure change processing module 25 will process the database 24 according to the database data structure change command to execute the specified data structure change execution time range. After the database 21 queries the updated data during the operation, The database read-write control module 28 will use the audit rebuild method to add the data that has been queried for transaction updates in the operating database 21 to the processing database 24 with the changed data structure. Specifically, that is The updated data in the database 21 in operation will first change the original data structure of the updated data to the changed data structure according to the data structure changes executed by the processing database 24, and then update the changed data structure after the change. The data is added to the processing database 24, which is only an example for illustration, and does not limit the scope of application of the present invention.

Then, the database exchange module 29 can perform database exchange (SWAP) between the processing database 24 and the operating database 21, so that the processing database 24 is changed to the operating database 21, and then the operating database 21 is restored. This can avoid the need to completely suspend the service of the automated teller machine 10 when the data structure changes of the database 21 in operation, and the execution time of the data structure changes after the database 21 is cleared is too long.

Please refer to "Figure 3". "Figure 3" shows a flowchart of the method for updating the database data structure of an automated teller machine according to the present invention.

The database in operation provides each ATM to store and read data through data transmission (step 101); then, receive the database data structure change command (step 102); then, when the database data structure change is received When instructing, copy the operating database as a processing database (step 103); then, the processing database will execute the specified data structure change according to the database data structure change instruction (step 104); then, control each pair of ATMs The data storage and reading of the database are interrupted during operation (step 105); then, the data structure change processing module will process the database according to the database data structure change command to execute the specified data structure change execution time range, in The database in operation is queried for the changed and updated data (step 106); then, the database is queried and updated with the changed data structure to the processing database by audit reconstruction (step 107) ; Finally, exchange the processing database with the operating database to change the processing database to the operating database, and then resume the operation of the operating database (step 108).

The present invention further includes the provision of verification of the data change update of the database 21 in operation in the automatic teller machine 10, that is, when the database 21 in operation is requested to update the data in the database 21, the verification information sending module 31 is based on the changed data. The updated data sends the verification information 51 with the verification code to the electronic device 50 corresponding to the updated data. The aforementioned electronic device 50 is, for example, a smart phone, a tablet, a smart wearable device (such as a smart watch)... This is just an example, and does not limit the scope of application of the present invention. Sending the verification information 51 with the verification code to the electronic device 50 corresponding to the data updated by the change can be transmitted through wired transmission or wireless transmission. The aforementioned wired transmission methods are, for example, cable networks, optical fiber networks, etc., and the aforementioned wireless transmission methods are, for example, Wi-Fi, 3G, 4G, and so on. This is only an example for illustration and not This limitation limits the scope of application of the present invention.

Please refer to "Figure 4". "Figure 4" shows a schematic diagram of the verification interface for the update of the database data structure of an automated teller machine according to the present invention.

The control module 26 controls the request to update the data. The corresponding ATM 10 can display the verification interface 41, and the operator of the ATM 10 can input the verification code in the verification information 51 displayed by the electronic device 50. The receiving module 22 can receive the verification code from the display verification interface 41 through the data transmission method, and the verification module 32 verifies the verification code. The verification of the verification code is to compare the self-display verification interface 41 with the system The verification code in the generated verification information 51 is the same. If the verification code received from the display verification interface 41 is consistent with the verification code in the verification information 51 generated by the system, the verification code is verified. At this time, the database 21 is requested to proceed. The change update of the data is a legal change update, and the database read-write control module 28 can change the data of the database 21 in operation when requested to perform the change update of the data, so as to write the requested change update of the data to The database 21 is in operation. On the contrary, if the verification code received from the verification interface 41 is inconsistent with the verification code in the verification information 51 generated by the system, the verification code is not verified. At this time, the database 21 is requested to change data The update is an illegal transaction update. When the database read/write control module 28 is requested to update the data, it cannot change the data of the operating database 21. If the data update is requested, it is forbidden to write to the operating data. Library 21.

The database read-write control module 28 further prohibits writing to the operating database 21 when an abnormal event occurs during the abnormal update of data in the operating database 21. The warning module 33 generates and sends out the change of data to update the warning information of the occurrence of abnormal events.

In addition, when data is stored in the database 21 in operation, a storage mark is added corresponding to the newly added data, and the storage mark stored in the database 21 in operation is deleted. When the database 21 in operation performs data When an abnormal event occurs in the change update of the data, the change update of the requested data is prohibited from being written to the operating database 21, and the data is stored in the operating database 21 again according to the storage flag.

When the database 21 in operation is requested to update the data, the determining module 34 can determine whether the amount of the data update exceeds the preset value or whether the cumulative amount of the data update exceeds the preset value. If the amount of data transaction update exceeds the preset value or the cumulative amount of data transaction update exceeds the preset value, the database read-write control module 28 prohibits the account corresponding to the data transaction update from storing data in the operating database 21 And read, and then the warning module 33 generates and sends out data changes to update the warning information of abnormal transaction events.

When the database 21 in operation is requested to update the data, the determining module 34 can determine whether the number of data transactions updated in the preset time range exceeds the preset number. When the number of data items updated by the data transaction exceeds the preset number within the time range, the database read-write control module 28 prohibits the account corresponding to the data transaction update from storing and reading data from the operating database 21, and then the warning mode Group 33 generates and sends out data changes to update the alert information of abnormal transaction events.

To sum up, it can be seen that the difference between the present invention and the prior art is that the operating database is copied as a processing database. In the processing database, the specified data structure change is executed according to the database data structure change command, and the operation is interrupted. For database operations, use audit reconstruction to add the changed and updated data in the operating database to the processing database with the changed data structure, and exchange the processing database with the operating database to enable processing Change the database to a working database, and then resume the operation of the working database.

This technical means can solve the problem of the existing prior art that it takes too long to change the database data structure of the operating database in the ATM, thereby achieving a significant reduction in the number of databases in the operating database of the ATM. Time-consuming technical effects of data structure changes.

Although the embodiments disclosed in the present invention are as above, the content described is not used to directly limit the scope of patent protection of the present invention. Anyone with ordinary knowledge in the technical field to which the present invention belongs can make slight changes in the form and details of the implementation without departing from the spirit and scope of the present invention. The patent protection scope of the present invention shall still be subject to those defined by the attached patent application scope.

10: ATM 20: Server 21: Operating database 22: Receiving module 24: Processing database 25: Data structure change processing module 26: Control module 27: Data query module 28: Database read and write control Module 29: Database Exchange Module 31: Verification Information Sending Module 32: Verification Module 33: Warning Module 34: Judgment Module 41: Verification Interface 50: Electronic Device 51: Verification Information Step 101: Database in Operation Provide each ATM to store and read data through data transmission. Step 102: Receive the database data structure change command. Step 103: When the database data structure change command is received, copy the data in the operating database to Database processing step 104: The processing database will execute the specified data structure change according to the database data structure change command. Step 105: Control the interruption of each ATM to store and read data in the operating database. Step 106: In the data The structure change processing module will process the database according to the database data structure change command to execute the specified data structure change execution time range, and query the data of the change update in the operating database. Step 107: Rebuild the operating database by audit The data that has been queried for transaction updates is added to the processing database with the changed data structure. Step 108: Exchange the processing database with the operating database to change the processing database to the operating database. Resume the operation of a running database

Figure 1 is a system block diagram of the system for updating the database structure of an automated teller machine according to the present invention. Figure 2 is a schematic diagram of the structure of the present invention applicable to the update of the database data structure of the ATM. Figure 3 is a flow chart of the method for updating the database structure of an automated teller machine according to the present invention. FIG. 4 is a schematic diagram showing the verification interface display of the data structure change update of the database of the automatic teller machine according to the present invention.

10: ATM

20: server

21: Database in operation

22: receiving module

24: Processing the database

25: Data structure change processing module

26: control module

27: Data query module

28: Database read and write control module

29: Database Exchange Module

31: Verification information sending module

32: Verification Module

33: Warning module

34: Judgment module

Claims (10)

A database data structure change update system suitable for automatic teller machines, which includes: an operating database, which provides each automatic teller machine (Automated Teller Machine, ATM) for data storage through data transmission And read; a receiving module for receiving a database data structure change instruction; a processing database, when the database data structure change instruction is received, the data in the operating database is copied to all The processing database; a data structure change processing module that executes a specified data structure change in the processing database according to the database data structure change instruction; a control module for controlling each ATM to respond to the The data storage and reading interrupt of the database in operation; a data query module, in the data structure change processing module, the processing database executes the specified data structure change according to the database data structure change command In the execution time range of the database, the database is inquired about the updated data; a database read-write control module, the database read-write control module uses the audit rebuild method to perform the audit rebuild The database is queried to find out that the updated data is added to the processing database with the changed data structure; and a database exchange module that combines the processing database with the operation The middle database performs a database exchange (SWAP), so that the processing database is changed to the running database, and then the operation of the running database is resumed. As described in item 1 of the scope of patent application, the database data structure change update system suitable for automatic teller machines, wherein the system further includes: a verification information sending module for performing data when the database is requested When the data is updated by the change, a verification message with a verification code is sent to the electronic device corresponding to the data updated by the change according to the data updated by the change; the control module controls the request for the data change update corresponding to the ATM to display a The verification interface is used to receive the verification code from the verification interface through the receiving module; a verification module is used to verify the verification code; the database read-write control module is used as the verification code When the verification by the verification module is passed, the requested data transaction update is a legal transaction update, so that the requested data transaction update is written to the operating database; and when the verification code is not When the verification by the verification module is passed, the requested data transaction update is an illegal transaction update, and the requested data transaction update is prohibited from being written to the operating database. As described in item 1 of the scope of patent application, the database data structure change update system suitable for automatic teller machines, wherein the system further includes: the database read-write control module is used when the database is in operation When an abnormal event occurs in the transaction update, the requested transaction update of the data is prohibited from being written to the operating database; and a warning module is used to generate and issue a warning message that the abnormal event occurs in the transaction update of the data. As described in item 3 of the scope of patent application, the database data structure change update system suitable for automatic teller machines, wherein the system further includes: the database read-write control module stores data in the database during operation When the newly added data corresponds to adding a storage mark, and delete the storage mark stored in the operating database; the database read-write control module is used when the operating database performs data When an abnormal event occurs in the transaction update of, the requested transaction update of data is prohibited from being written to the operating database; and a database read-write control module re-executes the operating database pair based on the storage flag The storage of the data. As described in item 1 of the scope of patent application, the database data structure change update system suitable for automatic teller machines, wherein the system further includes: a judgment module, when the database is requested to perform data change update during the operation , Determine whether the amount of the data change update exceeds the preset value or determine whether the cumulative amount of the data change update exceeds the preset value; or when the database in operation is requested to update the data, determine Whether the number of data items updated by the data transaction within the preset time range exceeds the preset number; the database read-write control module is if the amount of the data transaction update exceeds the preset value or the data is changed When the updated cumulative amount exceeds the preset value, the account corresponding to the data change update is prohibited from storing and reading data in the operating database; or if the data is updated within the preset time range When the number of transactions exceeds the preset number, the account corresponding to the data transaction update is prohibited from storing and reading the data in the operating database; and a warning module is used to generate and send the transaction update transaction of the data Alert information for abnormal events. A database data structure change update method suitable for automatic teller machines, which includes: an operating database provides each automatic teller machine (Automated Teller Machine, ATM) for storing and reading data through data transmission; receiving a data Database data structure change instruction; when the database data structure change instruction is received, copy the data of the operating database to a processing database; the processing database is based on the database data structure change instruction Execute designated data structure changes; Control the interruption of data storage and reading of the operating database by each ATM; In the data structure change processing module, the processing database is based on the database data The structure change command executes the execution time range of the specified data structure change, and queries the database in the operation to find out the changed and updated data; in the way of audit rebuild, the database is inquired about the changed and updated data in the operation. Add the changed data structure to the processing database; and perform a database exchange (SWAP) between the processing database and the operating database to change the processing database to the operation Database, and then resume the operation of the database in operation. As described in item 6 of the scope of patent application, the method for updating the database structure of an automated teller machine, wherein the method further includes the following steps: When the database is requested to update the data in the operating database, according to the The data updated by the transaction sends a verification information with a verification code to the electronic device corresponding to the data updated by the transaction; the ATM corresponding to the transaction update request for the data displays a verification interface to receive the verification from the verification interface Code; verify the verification code; when the verification code is verified, the requested data transaction update is a legal transaction update, so as to write the requested data transaction update to the operating data Database; and when the verification code fails the verification, the requested data transaction update is an illegal transaction update, and the requested data transaction update is prohibited from being written to the operating database. As described in item 6 of the scope of patent application, the method for updating the database data structure of an automated teller machine, wherein the method further includes the following steps: When an abnormal event occurs in the database's data update during operation, Request for data update is forbidden to be written to the operating database; and generate and issue warning information about abnormal events in data update. As described in item 8 of the scope of patent application, the method for updating the database data structure of an automatic teller machine, wherein the method further includes the following steps: When the database is storing data in the operation, the new data is added Correspondingly add a storage mark, and delete the storage mark stored in the operating database; when an abnormal event occurs during a data update in the operating database, the data update request is prohibited. Write to the operating database; and re-save the data in the operating database according to the storage mark. As described in item 6 of the scope of patent application, the method for updating the database data structure of an automated teller machine, wherein the method further includes the following steps: When the database is requested to update the data in the operation, it is determined Whether the amount of the data transaction update exceeds the preset value or whether the cumulative amount of the data transaction update exceeds the preset value, or whether the number of data transactions updated within the preset time range exceeds the preset value The number of transactions; if the amount of the data transaction update exceeds the preset value or the cumulative amount of the data transaction update exceeds the preset value, the account corresponding to the data transaction update is prohibited from performing data on the operating database Storage and reading; if the number of data transactions updated within the preset time range exceeds the preset number, the account corresponding to the data transaction update is prohibited from storing and reading data in the operating database Take; Generate and send out data changes to update the warning information of abnormal transaction events.

Images