TWI693526B - 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

Abnormal update system and method for data structure of database in ATM

A database data structure transaction update system and method thereof, in particular to a database that updates database data structure by copying the database, and adds new data to the database after the database data structure transaction update by means of audit reconstruction , And then exchange the database to apply to the system and method for updating the data structure of the database of the ATM.

Existing operational databases for ATM (Automated Teller Machine, ATM) When the database data structure is changed, the ATM needs to be completely shut down to make the database in operation clear. The data structure of the database is changed in the middle database, which will make the database in the ATM in operation take too long to change the data structure of the database.

To sum up, it can be seen that the prior art has long existed the problem that it takes too long to change the database data structure of the database in operation in the ATM. Therefore, it is necessary to propose improved technical means to solve this problem. .

In view of the prior art's existing problem that it takes too long for the database data structure change of the database in operation in the ATM, the present invention discloses a database data structure change update system and method for the ATM :

The database data structure transaction update system applicable to ATMs disclosed by the present invention includes: an operational database, a receiving module, a processing database, a data structure transaction processing module, a control module, a data query module, Database read-write control module and database exchange module.

The database in operation provides each automated teller machine (Automated Teller Machine, ATM) to store and read data through the data transmission method; the receiving module is used to receive the database data structure change command; when the database data structure is received When the transaction command is executed, the data of the operating database is copied to the processing database; the data structure transaction processing module is to execute the specified data structure transaction according to the database data structure transaction 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 executes the specified data structure transaction execution time according to the database data structure transaction command in the data structure transaction processing module Scope, query the transaction updated data in the operating database; the database read-write control module will audit the renewed (audit rebuild) method to query the transaction database and update the updated data as the transaction data structure is added to In the processing database; and the database exchange module exchanges the processing database with the operating database (SWAP) to change the processing database to the operating database, and then resumes the operation of the operating database.

The method for updating the database data structure of the automatic teller machine disclosed by 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 transaction instruction; then, when the database data structure transaction instruction is received, it will be in operation The database is copied as a processing database; then, the processing database is executed according to the database data structure transaction instruction to execute the specified data structure transaction; then, each ATM is controlled to interrupt the data storage and reading of the operating database; Then, the data structure transaction processing module will process the database to execute the specified data structure transaction execution time range according to the database data structure transaction instruction, and query the transaction database for updated data in operation; then, the audit reconstruction method will The data in operation database is queried out of transaction update. The data structure after transaction is added to the processing database. Finally, the processing database is exchanged with the operating database to change the processing database to operation. Database, and then resume the operation of the database in operation.

The system and method disclosed by the present invention are as above. The difference from the prior art is that the operating database is copied into a processing database. In the processing database, the specified data structure transaction is executed according to the database data structure transaction instruction, and the interruption is performed. In the operation of the database in operation, the data of the transaction update in the database in operation is added to the processing database in the data structure after the transaction by means of audit reconstruction, and the database is exchanged between the processing database and the database in operation to Change the processing database to an operational database, and then resume the operation of the operational database.

Through the above-mentioned technical means, the present invention can achieve the technical effect of greatly reducing the time-consuming of database data structure change of the database in operation in the ATM.

The embodiments of the present invention will be described in detail below in conjunction with the drawings and examples, 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.

The following will describe the operation system and method of the implementation mode of the present invention with an embodiment, and please refer to both "Picture 1" and "Picture 2" as shown. "Picture 1" shows that the present invention is suitable for automatic A system block diagram of the database data structure transaction update system of the ATM; "Figure 2" shows a schematic diagram of the structure of the database data structure transaction update applicable to the automatic teller machine of the present invention.

The database data structure transaction update system applicable to ATMs disclosed by the present invention includes: an operational database 21, a receiving module 22, a processing database 24, a data structure transaction 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 of the database 21 in the operation of each automated teller machine (Automated Teller Machine, ATM) 10 when the database data structure is changed. Each ATM 10 includes a processor, a memory device, Connection devices...etc. Memory devices such as ROM, RAM... etc. Connection devices such as cable connection devices, optical fiber connection devices...etc., are only examples here, not to limit the invention Application areas: The ATM 10 is connected to the server 20 through a connection device. The ATM 10 uses the data transmission method to store and read data in the database 21 during the operation of the server 20 and receives it at the receiving module 22 When the database data structure is changed, the data in the operating database 21 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: ROM, RAM, etc., the connection device is, for example, a cable connection device, an optical fiber connection device, etc., which are only examples here, and do not limit the scope of application of the present invention. The database 21 and the processing database 24 in operation The data in is read, written, copied, etc. through the database read-write control module 28, which is only an example, 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 transaction update system applicable to ATMs as an illustration. According to the actual hardware configuration requirements, the present invention can also use more than two servers 20 to Implementation of the present invention is applicable to a database data structure transaction update system suitable for ATMs, for example, a server 20 is used to provide each ATM 10 with a data transmission method to store data in the database 21 during the operation of the server 20 And read, a server 20 is used to provide the subsequent receiving module 22, processing database 24, data structure transaction processing module 25, control module 26, data query module 27, database read-write control module 28 And the implementation of the database exchange module 29; or a server 20 to provide each ATM 10 with the data transmission method to store and read data in the database 21 during the operation of the server 20, with one The server 20 provides the realization of the receiving module 22, the processing database 24, the data structure transaction processing module 25, the data query module 27, the database read-write control module 28, and the database exchange module 29. The server 20 provides the implementation of the control module 26, which is only an example here, and does not limit the application scope of the present invention.

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

After the data structure transaction processing module 25 processes the database 24 to execute the specified data structure transaction according to the database data structure transaction instruction, the control module 26 can control each ATM 10 to perform data processing on the operating database 21 If the storage and reading are interrupted, the data query module 27 can process the database 24 in the data structure transaction processing module 25 according to the database data structure transaction instruction to execute the specified data structure transaction execution time range, and the database is in operation. 21 Query the transaction update data. The transaction changes of the data in the database 21 in operation are, for example, deposits and changes in the data of the corresponding account in the database 21 in operation, and withdrawals make the corresponding accounts in the database 21 in operation Changes in data transactions, remittances (including remittance and remittance) and changes in data transactions in the corresponding accounts in the database 21, etc., are only examples here, and do not limit the scope of application of the present invention.

Specifically, assuming that the specified data structure transaction performed in the database 24 is executed from 9:00 to 10:00, that is, it is necessary to find the data of the transaction update in the operational database 21 from 9:00 to 10:00, here only For example, it does not limit the application scope of the present invention.

In the data query module 27, the data structure transaction processing module 25 will process the database 24 to execute the specified data structure transaction execution time range according to the database data structure transaction instruction, and after querying the transaction update data in the operational database 21, The database read-write control module 28 will use the audit rebuild method to add the updated data of the operating database 21 that has been queried out to the processing database 24 with the changed data structure, specifically, namely, The data of transaction update in the database 21 in operation will first change the original data structure of the transaction update data to the data structure after the transaction according to the data structure transaction performed by the processing database 24, and then update the transaction after the data structure is changed The data is added to the processing database 24, which is only an example here, 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 to change the processing database 24 to the operating database 21, and then restore the operating database 21 This operation can avoid the operation of the ATM 10 when the database 21 in the operation of the data structure is changed, and the execution time of the data structure change after the database 21 is cleared in the operation is too long.

Please refer to "Figure 3", which shows a method flow chart of the method for updating the database data structure of the automatic 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, receives the database data structure transaction instruction (step 102); then, when the database data structure transaction is received When instructing, copy the working database as the processing database (step 103); then, execute the specified data structure transaction according to the database data structure transaction instruction (step 104); then, control each ATM pair Interruption of data storage and reading by the database during operation (step 105); Then, the data structure transaction processing module will process the database to execute the specified data structure transaction execution time range according to the database data structure transaction instruction. The database in operation queries the updated data (step 106); then, the audited reconstruction method is used to add the updated data in the database in operation to the processing database with the changed data structure (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 providing verification of the data transaction update of the database 21 in operation in the ATM 10, that is, when the database 21 in operation is requested to update the data in operation, the verification information sending module 31 is based on the transaction The updated data sends verification information 51 with a 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 computer, a smart wearable device (for example, a smart watch)... Etc., which are only examples here, and do not limit the scope of application of the present invention. Sending the verification information 51 with a verification code to the electronic device 50 corresponding to the updated data can be transmitted by wire or wirelessly Method, the aforementioned wired transmission method is for example: cable network, fiber optic network, etc., and the aforementioned wireless transmission method is for example: Wi-Fi, 3G, 4G, etc., which are only examples here, not This limits the scope of application of the present invention.

Please refer to "Figure 4", which is a schematic diagram of the verification interface display for updating the database data structure of the automatic teller machine according to the present invention.

The control module 26 controls the automatic update of the ATM 10 corresponding to the request to update the data, and the verification interface 41 can be displayed. 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 data transmission, and the verification code is verified by the verification module 32. Verification of the verification code is to compare whether the verification code received from the display verification interface 41 is compatible 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 passes the verification. At this time, the database 21 is requested to perform The transaction update of the data is a legal transaction update. The database read-write control module 28 is requested to perform the transaction update of the data to change the data in the operating database 21 to write the transaction update requested to The database 21 is in operation. On the contrary, if the verification code received from the display verification interface 41 is inconsistent with the verification code in the verification information 51 generated by the system, the verification code has not passed the verification. At this time, the database 21 is requested to perform data transaction The update is an illegal transaction update. The database read-write control module 28 is requested to perform a transaction update of data, that is, it is unable to change the data in the operating database 21. The requested transaction update is prohibited from writing to the operation data. Library 21.

The database read-write control module 28 will further when the database 21 is in operation, and when an abnormal event occurs in the data update of the database in operation, the requested data update is prohibited from being written to the database 21 in operation. The warning module 33 generates and issues warning information about abnormal events that occur when the data is updated.

In addition, when the database 21 is performing data storage, the newly added data corresponds to adding a storage mark, and the storage mark stored in the operating database 21 is deleted. When the database 21 is performing data storage When an abnormal event occurs in the transaction update, the requested transaction update is prohibited from being written to the active database 21, and the active database 21 stores the data again according to the storage mark.

When the operating database 21 is in operation and the database is requested to update the data, the judgment module 34 can determine whether the amount of the data update exceeds the preset value or whether the accumulated amount of the data update exceeds the preset value. If the amount of data transaction update exceeds the preset value or the accumulated 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 alert module 33 generates and issues a transaction update of the data to update the alert information of a transaction abnormal event.

When the database 21 in operation is requested to update the data in the database during operation, the determination module 34 can determine whether the number of data updates in the data update exceeds the preset number in the preset time range. When the number of data changes in the data transaction update exceeds the preset number in the time range, the database read-write control module 28 prohibits the account corresponding to the data transaction update from storing and reading data in the operating database 21, and then the warning module The group 33 generates and sends out the transaction update of the data to update the warning information of the occurrence of the transaction abnormal event.

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, and the specified data structure transaction is executed according to the database data structure transaction instruction in the processing database, interrupting the operation In the operation of the database, the data updated by the transaction in the operating database is added to the processing database by the audited reconstruction method, and the data structure of the transaction database is exchanged with the operating database to enable the processing The database is changed to the active database, and the operation of the active database is resumed.

This technical method can solve the problem that the existing technology takes too long to change the database data structure of the operating database in the ATM, and thus achieves a significant reduction in the database of the operating database in the ATM. Time-consuming technical effects of data structure changes.

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

10: ATM

20: Server

21: Operating database

22: Receive module

24: Processing database

25: Data structure transaction processing module

26: Control module

27: Data query module

28: Database read-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: The operational database provides each ATM with data transmission methods for data storage and reading

Step 102: Receive a database data structure change instruction

Step 103: When receiving the database data structure change command, copy the data of the active database to the processing database

Step 104: The processing database will execute the specified data structure transaction according to the database data structure transaction instruction

Step 105: Control the interruption of storage and reading of data in the operational database by each ATM

Step 106: The data structure transaction processing module will process the database according to the database data structure transaction instruction to execute the specified data structure transaction execution time range, and query the transaction update data in the operating database

Step 107: Use the audit and reconstruction method to add the updated data of the active database to the processing database and add the updated data structure to the processing database

Step 108: Perform database exchange between the processing database and the operating database to change the processing database to the operating database, and then resume the operation of the operating database

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

10: ATM

20: Server

21: Operating database

22: Receive module

24: Processing database

25: Data structure transaction processing module

26: Control module

27: Data query module

28: Database read-write control module

29: Database exchange module

31: Verification information sending module

32: Verification module

33: Warning module

34: Judgment module

Claims (8)

A database data structure transaction update system suitable for ATMs, which includes: an operational database that provides each automated teller machine (ATM) with a data transmission method for data storage And reading; a verification information sending module, used to send a verification message with a verification code to the updated data according to the updated data when the database in operation is requested to update the data The electronic device corresponding to the data; a receiving module to receive a database data structure transaction instruction; a processing database to copy the data of the database in operation when the database data structure transaction instruction is received To the processing database; a data structure transaction processing module that executes the specified data structure transaction according to the database data structure transaction instruction; a control module to control each ATM pair Interruption of data storage and reading by the database during the operation; and the automatic teller machine corresponding to the control request for data update update displays a verification interface to receive the verification code from the verification interface through the receiving module; A verification module for verifying the received verification code; a data query module for performing the designation of the processing database in accordance with the database data structure transaction instruction in the data structure transaction processing module The execution time range of the data structure transaction is changed, and the database of the operation is queried to find the updated data of the transaction; A database read-write control module, the database read-write control module uses an audit rebuild to add the updated data of the database in operation and the updated data structure is added to the In the processing database; when the received verification code passes the verification of the verification module, the transaction update requested of the data is a legal transaction update, so that the transaction update requested of the data is written to The database in operation; and when the received verification code does not pass the verification of the verification module, the transaction update of the data requested is illegal and the transaction update of the data requested is prohibited Write to the database in operation; and a database exchange module, the database exchange module exchanges the processing database with the database in operation (SWAP), so that the The processing database is changed to the operating database, and then the operation of the operating database is resumed. The database data structure transaction update system applicable to ATMs as described in item 1 of the patent application scope, wherein the system further includes: the database read-write control module is used for data in the database in operation When an abnormal event occurs in a transaction update, the requested transaction update is prohibited from being written to the database in operation; and a warning module is used to generate and issue warning information about the abnormal event of the transaction update update. As mentioned in item 2 of the patent application scope, the database data structure transaction update system applicable to ATMs, wherein the system further includes: When the database read-write control module stores data in the operating database, a storage mark is added corresponding to the newly added data, and the storage mark stored in the operating database is deleted And a database read-write control module re-stores the data in the database in operation according to the storage mark. The database data structure transaction update system for ATMs as described in item 1 of the patent application scope, wherein the system further includes: a judgment module when the database is requested to perform transaction update of the data during the operation To determine whether the amount of the data transaction update exceeds the preset value or to determine whether the accumulated amount of the data transaction update exceeds the preset value; or when the database in operation is requested to update the data Whether the number of data updates of the data transaction update exceeds the preset number within the preset time range; the database read-write control module is if the amount of the data transaction update exceeds the preset value or the data transaction When the cumulative amount of updates exceeds the preset value, the account corresponding to the data transaction update is prohibited from storing and reading data in the operating database; or if the data transaction update data within the preset time range When the number of pens exceeds the preset number, the account corresponding to the data transaction update is prohibited from storing and reading data in the database in operation; and a warning module is used to generate and issue transactions for data transaction updates Warning information for abnormal events. A method for updating the database data structure of ATMs, which includes the following steps: A database in operation provides each automated teller machine (ATM) with data transmission to store and read data; receives a database data structure transaction instruction; when it receives the database data structure transaction instruction , Copy the data of the database in operation to a processing database; execute the specified data structure transaction according to the database data structure transaction instruction of the database; control each ATM to the operation Interruption of data storage and reading by the database; in the data structure transaction processing module, the processing database executes the specified data structure transaction execution time range according to the database data structure transaction instruction in the The database in operation queries the updated data of the transaction; the data of the database updated in the operation is queried out by audit rebuild and the data structure after the transaction is added to the processing database; Performing database exchange (SWAP) between the processing database and the operating database to change the processing database to the operating database, and then resuming the operation of the operating database; When the database in operation is requested to update the data, a verification message with a verification code is sent to the electronic device corresponding to the updated data according to the updated data; The automatic teller machine corresponding to the control request for data update displays a verification interface to receive the verification code from the verification interface; verifies the received verification code; when the received verification code passes verification, Then, the transaction update requested for the data is a legal transaction update, so that the transaction update requested for the data is written to the database in operation; and when the verification code received is not verified, it is requested The transaction update of the data is an illegal transaction update, and the transaction update of the requested data is prohibited from being written to the database in operation. The method for updating the database data structure of the database applicable to the ATM as described in item 5 of the scope of the patent application, wherein the method further includes the following steps: when an abnormal event occurs during the data update of the database in operation, the Requesting to update data is prohibited from writing to the database in operation; and generating and issuing warning information about abnormal events in the data update. The method for updating the database data structure of the ATM as described in item 6 of the patent application scope, wherein the method further includes the following steps: when the database is storing data during the operation, the newly added data Correspondingly adding a storage mark and deleting the storage mark stored in the operating database; and re-storing the data in the operating database according to the storage mark. The method for updating the database data structure of an ATM as described in item 5 of the patent application scope, wherein the method further includes the following steps: when the database in operation is requested to update the data, determine Whether the amount of the data transaction update exceeds the preset value or whether the accumulated amount of the data transaction update exceeds the preset value, or whether the number of data updates of the data transaction update exceeds the preset value within a preset time range The number of transactions; if the amount of the data transaction update exceeds the preset value or the accumulated 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 updates of the data transaction update exceeds the preset number in the preset time range, the account corresponding to the data transaction update is prohibited from storing and reading data in the operating database Fetch; and generate and issue data transaction updates to alert information on transaction anomalies.

Images