Disclosure of Invention
The invention mainly aims to provide a data table updating method, device, equipment and storage medium, and aims to solve the technical problems of low accuracy of changing corresponding fields of the existing data table and low updating efficiency.
In order to achieve the above object, the present invention provides a method for updating a data table, the method for updating a data table comprising the steps of:
After determining that a management system detects an acquisition instruction for acquiring external system data table change information, acquiring the change information of the data table according to the acquisition instruction;
acquiring a source file corresponding to the data table according to the change information;
And determining the field length of the change information corresponding to the original field information, and updating the source file according to the change information and the field length.
Optionally, the step of determining a field length of the change information corresponding to the source field information, and updating the source file according to the change information and the field length includes:
calculating the field length of the change information corresponding to the field information;
sorting the original field information according to the sequence of the field lengths from large to small to obtain sorted original field information;
And correspondingly replacing the original field information with new field information in the change information from front to back according to the ordered original field information so as to update the source file.
Optionally, after the determining management system detects an acquisition instruction for acquiring the change information of the external system data table, the step of acquiring the change information of the data table according to the acquisition instruction includes:
After the management system is determined to detect an acquisition instruction for acquiring external system data table change information, determining the authority level of the acquisition instruction;
if the authority level is high, accessing a library table structure of the external system according to the acquisition instruction, and accessing the external system database through the library table structure to acquire change information of a data table in the external system database;
and if the permission level is medium, acquiring an interface table preset between the permission level and the external system according to the acquisition instruction, and acquiring change information of a data table in the interface table.
If the authority level is low, acquiring an interface file generated by the external system when the data table is changed according to the acquisition instruction, and acquiring change information of the data table in the interface file;
Optionally, before the step of determining the permission level in the acquisition instruction after the determining management system detects the acquisition instruction for acquiring the external system data table change information, the method further includes:
Detecting whether a user name and a password of the external system are stored in a database of the management system;
if the fact that the user name and the password are stored in the database of the management system is detected, determining that the permission level of the acquisition instruction is high;
if the user name and the password are not detected, detecting whether an interface table identifier of an interface table is stored in a database of the management system;
if the interface table identifier is detected, determining that the authority level of the acquired instruction is a medium level;
and if the user name, the password and the interface table identifier are not detected, determining that the permission level of the acquisition instruction is a low level.
Optionally, after the step of determining the field length of the source file corresponding to the change information and updating the source file according to the change information and the field length, the method further includes:
Acquiring the current change time in the change information and acquiring the historical change time corresponding to the data table;
And calculating a time difference according to the current change time and the historical change time, and determining the change condition of the data table according to the time difference.
Optionally, the step of calculating a time difference according to the current change time and the historical change time, and determining the change condition of the data table according to the time difference includes:
Sequencing the current change time and the historical change time according to the sequence from front to back of time to obtain a change time sequence;
Calculating the time difference of every two adjacent changing times in the changing time sequence to obtain the time difference corresponding to the changing time sequence, and judging whether the average value of the time differences corresponding to the changing time sequence is larger than a preset value;
if the average value is larger than a preset value, determining that the data table is normally changed;
and if the average value is smaller than or equal to a preset value, determining that the data table is abnormally changed.
Optionally, the step of obtaining the source file corresponding to the data table according to the change information includes:
And acquiring a data table identifier corresponding to a data table in the change information, and acquiring a source file of a source code corresponding to the change information from a preset source code catalog through the data table identifier.
In addition, in order to achieve the above object, the present invention also provides an apparatus for updating a data table, the apparatus for updating a data table comprising:
the acquisition module is used for acquiring the change information of the data table according to the acquisition instruction; acquiring a source file corresponding to the data table according to the change information;
the determining module is used for determining the field length of the original field information corresponding to the change information;
and the updating module is used for updating the source file according to the change information and the field length.
In addition, in order to achieve the above object, the present invention also provides an update apparatus of a data table, the update apparatus of a data table including a memory, a processor, and an update program of a data table stored on the memory and running on the processor, the update program of a data table implementing the steps of the update method of a data table as described above when executed by the processor.
In addition, in order to achieve the above object, the present invention also provides a computer-readable storage medium having stored thereon an update program of a data table, which when executed by a processor, implements the steps of the data table update method as described above.
After the determination management system detects an acquisition instruction for acquiring the change information of the external system data table, the change information of the data table is acquired according to the acquisition instruction, then the source file corresponding to the data table is acquired according to the change information, the field length corresponding to the original field information in the change information is determined, and the source file is updated according to the change information and the field length. Therefore, in the process of updating the data table, the management system acquires the change information and the source file of the data table according to the acquisition instruction, and completes the updating of the source file by determining the field length of the original field information in the change information, the acquisition of the source file, the acquisition of the field degree and the updating of the source file are all automatically completed in the management system without manual participation, so that the error of the change of the field of the data table and the time length required for the updating of the field of the data table are reduced, the change accuracy of the field of the data table is improved, and the updating efficiency of the field of the data table is improved.
Detailed Description
It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention.
Referring to fig. 1, fig. 1 is a flow chart of a first embodiment of a method for updating a data table according to the present invention.
The embodiments of the present invention provide embodiments of a method for updating a data table, and it should be noted that although a logic sequence is shown in the flowchart, under certain data, the steps shown or described may be performed in a different order than that shown or described herein.
The updating method of the data table comprises the following steps:
Step S10, after the determination management system detects an acquisition instruction for acquiring the change information of the external system data table, the change information of the data table is acquired according to the acquisition instruction.
The management system detects whether an acquisition instruction of external system data table change information is acquired in real time or at regular time, and after detecting the acquisition instruction of the external system data table change information, the management system acquires the information change of the data table in the external system according to the acquisition instruction. The acquiring instruction can be manually triggered in the management system by a user, or can be triggered by the management system at fixed time according to a preset fixed-time task. The change information includes, but is not limited to, original field information before the change of the data table, new field information after the change, a sequence number and a change time, and the sequence number is the sequence number of the changed field. For example, the original field information of the a field of the data table in the external system database is "AC046", and the new field information after the a field is changed may be "AC048". It should be noted that a database includes at least one data table.
The step S10 further includes:
step a, after a determining management system detects an obtaining instruction for obtaining external system data table change information, determining the authority level of the obtaining instruction;
Specifically, after detecting an acquisition instruction for acquiring external system data table change information, the management system determines the authority level of the acquisition instruction according to the coupling degree by determining the coupling degree with the external system. The coupling degree refers to the degree of association between two mutually independent systems, and in this embodiment, the coupling degree may be divided into high coupling, medium coupling and low coupling, which correspond to the authority levels of high, medium and low levels, respectively.
B, if the authority level is high, accessing a library table structure of the external system according to the acquisition instruction, and accessing the external system database through the library table structure to acquire change information of a data table in the external system database;
When the management system determines that the coupling degree with the external system is high, namely the authority level of the acquisition instruction is high, the management system acquires a database address, a database identifier, a user name, a password and the like of the external system according to the acquisition instruction, wherein the database address, the database identifier, the user name and the password are stored in the management system in advance. And the management system determines a database corresponding to the external system according to the database address and the database identifier, and logs in the database of the external system through the user name and the password. After the management system logs in the database of the external system, the management system can access the database table structure of the external system according to the acquisition instruction, access the first structural information of the data table in the database of the external system through the database table structure, and compare the first structural information with the second structural information of the data table in the database of the external system accessed through the database table structure last time, thereby determining the change information of the data table in the database of the external system and acquiring the change information of the data table in the database of the external system.
Further, the management system encrypts the user name and the password by adopting an encryption algorithm negotiated with the external system, and loads the encrypted user name and the encrypted password into the acquisition instruction to be transmitted to the external system together after obtaining the encrypted user name and the encrypted password. The embodiment does not limit the type of encryption algorithm, for example, the encryption algorithm is a binary key algorithm, the user name before encryption is abc, the password is 1234, the user name after encryption is 123 after the conversion of the binary key, the password after encryption is 141232, and it should be noted that english letters a to z respectively correspond to 1 to 26. Meanwhile, the management system can only access the database of the external system through the user name and the password, obtain the change information of the data table from the database, and cannot modify and delete the data stored in the database.
Step c, if the permission level is medium, acquiring an interface table preset between the permission level and the external system according to the acquisition instruction, and acquiring change information of a data table in the interface table;
when the coupling degree between the management system and the external system is moderately coupled, the management system determines that the authority level of the acquisition instruction is a medium level, and at the moment, the management system acquires an interface table preset between the acquisition instruction and the external system according to the acquisition instruction, and acquires change information of the data table through the interface table. Wherein the interface table stores the field corresponding to the change information. The external system detects whether the data table in the database changes in real time or at regular time, and after detecting that the data table in the database changes, the external system writes the change condition of the data table into the interface table, wherein the interface table is an independent table in the database of the external system. In this embodiment, when the external system detects that the data table in the database changes, the external system automatically generates a data table update instruction after writing the change condition of the data table into the interface table, and sends the data table update instruction to the management system. After receiving the data table updating instruction, the management system automatically triggers the acquisition instruction.
And d, if the permission level is low, acquiring an interface file generated by the external system when the data table is changed according to the acquisition instruction, and acquiring the change information of the data table in the interface file.
When the management system determines that the coupling degree with the external system is low coupling, namely, the permission level of the acquisition instruction is low, the management system acquires an interface file generated by the external system when the data table changes according to the acquisition instruction, and acquires the change information of the data table in the interface file. When the external system detects that the data table in the database changes, the external system exports the change condition of the data table in the database to form an interface file, or a user corresponding to the external system fills the change condition of the data table in the database into an interface file preset by the external system, wherein the interface file is an EXCEL table independently generated by the external system.
The step a further comprises:
Step i, detecting whether a user name and a password of the external system are stored in a database of the management system;
step j, if the fact that the user name and the password are stored in the database of the management system is detected, determining that the authority level of the acquisition instruction is high;
Specifically, after the management system determines that an acquisition instruction for acquiring external system data table change information is detected, the management system determines whether the authority level of the acquisition instruction is high by detecting whether a user name and a password of the external system are stored in a database of the management system. And if the management system detects that the user name and the password of the external system are stored in the database, namely, the coupling degree of the management system and the external system is determined to be high coupling, the authority level of the acquisition instruction is determined to be high.
Step k, if the user name and the password are not detected, detecting whether an interface table identifier of an interface table is stored in a database of the management system;
step l, if the interface table identification is detected, determining that the authority level of the acquisition instruction is a medium level;
And n, if the user name, the password and the interface table identifier are not detected, determining that the permission level of the acquisition instruction is a low level.
If the management system does not detect the user name and the password of the external system stored in the database, further detecting whether the interface table identifier of the interface table is stored in the database, wherein the interface table identifier is only a specific mark of the interface table, and no method or attribute exists. If the management system detects that the interface table identifier of the interface table is stored in the management system database, the management system determines that the coupling degree of the management system and the external system is moderate coupling, so that the permission level of the acquisition instruction is determined to be the moderate level. If the management system does not detect the user name and the password of the external system and the interface table identifier of the interface table stored in the management system database, that is, the coupling degree of the management system and the external system is determined to be low coupling, the authority level of the acquisition instruction is determined to be low.
Step S20, obtaining a source file corresponding to the data table according to the change information.
After the management system acquires the change information of the data table, the management system acquires the source file corresponding to the data table according to the change information. The source file is also called a source code file, which refers to an uncompiled text file written according to a certain programming language specification, and is a series of human-readable computer language instructions.
The step S20 further includes:
And e, acquiring a data table identifier corresponding to the data table in the change information, and acquiring a source file of the source code corresponding to the change information from a preset source code catalog through the data table identifier.
Specifically, the management system presets the source code catalog corresponding to the change information, acquires the data table identifier of the data table carried in the change information, and determines the source file corresponding to the data table in the source code catalog through the data table identifier. The extension of the source file supports development languages such as java, cpp (C plus plus, compiled programming language), py (python, computer programming language), and the like. It should be noted that, after the management system obtains the source file, the source file is opened in a text format in a coding mode of UTF8 (Unicode Transformation Format,8 bits). In the change information, each data table has a unique data table identification.
Step S30, determining the field length of the original field information corresponding to the change information, and updating the source file according to the change information and the field length.
After the management system obtains the source file of the change information, the management system obtains the size of each field length in the change information by calculating the field length of the change information corresponding to the field information, and updates the source file according to the field information and the size of the field length in the change information.
The step S30 further includes:
F, calculating the field length of the change information corresponding to the field information;
step g, sorting the original field information according to the sequence of the field lengths from large to small to obtain sorted original field information;
And h, correspondingly replacing the original field information with new field information in the change information from front to back according to the ordered original field information so as to update the source file.
Specifically, the management system calculates the field length corresponding to each original field information in the change information to obtain the size of each field length corresponding to the original field information, and sorts the original field information according to the sequence from the large field length to the small field length to obtain the sorted original field information. After the management system obtains the source file, the new field information in the change information is replaced with the original field information in the source file according to the sequence from front to back of the ordered original field information, so that the source file is updated. It should be noted that, the management system may also sort the original field information according to the order of the lengths of the fields from small to large to obtain the sorted original field information, and then replace the original field information in the source file with the new field information in the change information according to the order of the sorted original field information from back to front, so as to update the source file. The embodiment is to replace the field with longer field length preferentially, so as to avoid that when the field with shorter field length is replaced before, the field with shorter field length is replaced with the field with longer field length, and then when the field with longer field length is replaced subsequently, the field is replaced again, thereby improving the accuracy of changing the data table field.
Further, in this embodiment, the source file may be updated with the replaced identifier, specifically, when the management system performs replacement of the original field information, after a certain original field information is replaced, the replaced identifier is added to the replaced original field information, and in the process of replacing the field information, the management system detects whether the original field information to be replaced has the replaced identifier. If the management system detects that the original field information to be replaced has a replaced identifier, the original field information is not replaced, and if the management system detects that the original field information to be replaced does not have a replaced identifier, the management system replaces the field information. Further, a unique field identifier can be set for each field information, and the field identifiers of the original field information and the new field information of the same field information are the same, so that the field information is replaced by the field identifier.
After the management system receives an acquisition instruction for acquiring the change information of the external system data table, the management system acquires the change information of the data table in different acquisition modes according to the authority level of the acquisition instruction, acquires the source file corresponding to the data table according to the change information, and updates the source file according to the new field information and the field length in the change information by determining the field length corresponding to the field information in the change information. Therefore, in the process of updating the data table, the method and the device for updating the data table acquire the change information, acquire the source file, acquire the field degree and update the source file automatically and are completed in the management system without manual participation, so that the error of changing the data table field and the time length required for updating the data table field are reduced, the accuracy of changing the data table field is improved, and the updating efficiency of the data table field is improved.
Further, a second embodiment of the method for updating a data table of the present invention is presented.
The second embodiment of the method for updating a data table is different from the first embodiment of the method for updating a data table in that the method for updating a data table further includes:
Step m, acquiring the current change time in the change information and acquiring the historical change time corresponding to the data table;
and step o, calculating a time difference according to the current change time and the historical change time, and determining the change condition of the data table according to the time difference.
The method comprises the steps that each historical change time in the historical change process of a data table is stored in a database of a management system, the management system obtains each historical change time of the data table and the current change time of change information in the database of the management system, then difference calculation is carried out on each historical change time and the current change time to obtain a time difference, and the change condition of the data table is determined according to the time difference, wherein the change condition comprises abnormal change and normal change.
Further, the step o includes:
Step p, sorting the current change time and the historical change time according to the sequence from front to back to obtain a change time sequence;
Step q, calculating the time difference of every two adjacent changing times in the changing time sequence to obtain the time difference corresponding to the changing time sequence, and judging whether the average value of the time differences corresponding to the changing time sequence is larger than a preset value;
Specifically, the management system sequences the current change time and each historical change time from front to back according to the sequence of time to obtain a change time sequence, the change time sequence can be obtained by subtracting the change time arranged in front from the change time arranged in back, or the change time arranged in front from the change time arranged in front can be obtained by subtracting the change time arranged in back from the change time arranged in front, then the absolute value of the difference is calculated, and the time difference between every two adjacent change times in the change time sequence is obtained. The management system calculates an average value of the time differences and judges whether the average value is larger than a preset value, wherein the size of the preset value can be set according to specific requirements, and the size of the preset value is not limited in the embodiment.
Step r, if the average value is larger than a preset value, determining that the data table is normally changed;
And step s, if the average value is smaller than or equal to a preset value, determining that the data table is abnormally changed.
Specifically, if the average value is determined to be greater than the preset value, the management system determines that the data table is normally changed, and if the average value is determined to be less than or equal to the preset value, the management system determines that the data table is abnormally changed.
Further, in this embodiment, the management system may further determine a change condition of the data table according to the time difference ratio and the preset ratio. Specifically, after the management system calculates the time difference, the total number of the time differences is calculated, the number of the time differences larger than a preset value in the time differences is calculated, and then the time difference ratio that the time difference is larger than the preset value is obtained by dividing the number of the time differences by the total number. If the time difference proportion is larger than the preset proportion, the management system determines that the data table is changed abnormally, and if the time difference proportion is smaller than or equal to the preset proportion, the management system determines that the data table is changed normally. It should be noted that, the size of the preset ratio may be set according to specific needs, and the size of the preset ratio is not limited in this embodiment. It should be noted that the preset values in the above two embodiments may be the same value or different values.
According to the management system, the historical change time corresponding to the data table and the current change time in the change information are obtained, the time difference between the current change time and each historical change time is calculated, and whether the time difference is larger than a preset value is judged, so that the change condition of the data table is determined, and the real-time monitoring of the change condition of the data table is ensured.
Further, a third embodiment of the data table updating method of the present invention is proposed.
The third embodiment of the method for updating a data table is different from the second embodiment of the method for updating a data table in that the method for updating a data table further includes:
and step t, generating prompt information of abnormal change of the data table, and sending the prompt information to the external system so that the external system can output the prompt information after receiving the prompt information, and prompting operation and maintenance personnel of abnormal change of the data table according to the prompt information.
Specifically, after the management system determines that the data table is abnormally changed, the management system generates corresponding prompt information, and the management system can output the prompt information by itself or send the prompt information to an external system. When the external system receives the prompt information, the external system outputs the prompt information, and prompts the corresponding operation and maintenance personnel that the data table is changed abnormally according to the prompt information, so that the data table is possibly tampered illegally. If the management system determines that the data table is changed normally, the notification information corresponding to the normal change of the data table may not be generated, or the notification information corresponding to the normal change of the data table may be generated. If the management system generates the prompt information, the prompt information is output according to the step of abnormal change of the data table, so that the external system prompts the operation and maintenance personnel to normally change the data table according to the prompt information.
According to the embodiment, the management system determines abnormal change of the data table, generates corresponding prompt information according to the abnormal change, and outputs the prompt information so that the external system prompts the corresponding operation and maintenance personnel data table to change abnormally according to the prompt information, and maintenance of the external system is completed, so that normal operation of the data table in the database of the external system is ensured.
In addition, the present invention also provides an updating device of a data table referring to fig. 2, the updating device of the data table includes:
an obtaining module 10, configured to obtain change information of the data table according to the obtaining instruction; acquiring a source file corresponding to the data table according to the change information;
A determining module 20, configured to determine a field length of the change information corresponding to the original field information;
an updating module 30, configured to update the source file according to the change information and the field length.
Further, the update module 30 includes:
the first calculation unit is used for calculating the field length of the change information corresponding to the field information;
the first ordering unit is used for ordering the original field information according to the sequence from the big field length to the small field length to obtain ordered original field information;
And the replacing unit is used for correspondingly replacing the original field information with new field information in the change information from front to back according to the ordered original field information so as to update the source file.
Further, the acquisition module 10 includes:
the first determining unit is used for determining the authority level of the acquisition instruction after the determination management system detects the acquisition instruction for acquiring the external system data table change information;
The access unit is used for accessing the library table structure of the external system according to the acquisition instruction if the permission level is high, and accessing the external system database through the library table structure so as to acquire the change information of the data table in the external system database;
The acquisition unit is used for acquiring an interface table preset between the external system and the data table according to the acquisition instruction if the permission level is medium, and acquiring the change information of the data table in the interface table; and if the permission level is low, acquiring an interface file generated by the external system when the data table is changed according to the acquisition instruction, and acquiring the change information of the data table in the interface file.
Further, the first determination unit includes:
the detection subunit is used for detecting whether a user name and a password of the external system are stored in a database of the management system after the management system is determined to detect an acquisition instruction for acquiring the change information of the external system data table;
a determining subunit, configured to determine that the permission level of the obtaining instruction is a high level if it is detected that the user name and the password are stored in the database of the management system;
The detection subunit is further configured to detect whether an interface table identifier of an interface table is stored in a database of the management system if the user name and the password are not detected;
The determining subunit is further configured to determine that the permission level of the obtaining instruction is a middle level if the interface table identifier is detected; and if the user name, the password and the interface table identifier are not detected, determining that the permission level of the acquisition instruction is a low level.
Further, the obtaining module 10 is further configured to obtain a current change time in the change information, and obtain a historical change time corresponding to the data table;
Further, the updating device of the data table further comprises:
the calculation module is used for calculating a time difference according to the current change time and the historical change time;
The determining module 20 is further configured to determine a change condition of the data table according to the time difference.
Further, the determining module 20 further includes:
the second sorting unit is used for sorting the current change time and the historical change time according to the sequence from front to back in time to obtain a change time sequence;
The second calculation unit is used for calculating the time difference of every two adjacent change times in the change time sequence to obtain the time difference corresponding to the change time sequence;
The judging unit is used for judging whether the average value of the time differences corresponding to the changed time sequence is larger than a preset value;
The second determining unit is used for determining that the data table is normally changed if the average value is larger than a preset value; and if the average value is smaller than or equal to a preset value, determining that the data table is abnormally changed.
Further, the obtaining module 10 is further configured to obtain a data table identifier corresponding to a data table in the change information, and obtain, by using the data table identifier, a source file of a source code corresponding to the change information in a preset source code directory.
The specific implementation manner of the updating device based on the data table is basically the same as that of each embodiment of the updating method based on the data table, and is not repeated here.
In addition, the invention also provides a data table updating device. As shown in fig. 3, fig. 3 is a schematic structural diagram of a hardware running environment according to an embodiment of the present invention.
It should be noted that fig. 3 is a schematic structural diagram of a hardware running environment of the update device of the data table.
FIG. 3 is a schematic diagram of a hardware operating environment of an update device for a data table.
As shown, the updating apparatus of the data table may include: a processor 1001, such as a CPU, memory 1005, user interface 1003, network interface 1004, communication bus 1002. Wherein the communication bus 1002 is used to enable connected communication between these components. The user interface 1003 may include a Display, an input unit such as a Keyboard (Keyboard), and the optional user interface 1003 may further include a standard wired interface, a wireless interface. The network interface 1004 may optionally include a standard wired interface, a wireless interface (e.g., WI-FI interface). The memory 1005 may be a high-speed RAM memory or a stable memory (non-volatile memory), such as a disk memory. The memory 1005 may also optionally be a storage device separate from the processor 1001 described above.
Optionally, the updating device of the data table may further include an RF (Radio Frequency) circuit, a sensor, a WiFi module, and the like.
It will be appreciated by those skilled in the art that the update device structure of the data table shown in fig. 3 does not constitute a limitation of the update device of the data table, and may include more or fewer components than shown, or may combine certain components, or may be a different arrangement of components.
As shown in fig. 3, an operating system, a network communication module, a user interface module, and an update program of a data table may be included in the memory 1005 as one type of computer storage medium. The operating system is a program for managing and controlling the updating equipment hardware and software resources of the data table, and supports the updating program of the data table and the running of other software or programs.
In the update apparatus of the data table shown in the figure, the user interface 1003 mainly uses an external system; the network interface 1004 is mainly used for managing the system and communicating data with an external system; the processor 1001 may be configured to call an update program of the data table stored in the memory 1005 and execute the steps of the control method of the data table updating apparatus as described above.
The specific implementation manner of the data table updating device of the present invention is basically the same as that of each embodiment of the data table updating method, and will not be described herein.
In addition, the embodiment of the invention also provides a computer readable storage medium, wherein the computer readable storage medium stores a data table updating program, and the data table updating program realizes the steps of the data table updating method when being executed by a processor.
The specific implementation manner of the computer readable storage medium of the present invention is basically the same as the above embodiments of the method for updating the data table, and will not be described herein.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
The foregoing embodiment numbers of the present invention are merely for the purpose of description, and do not represent the advantages or disadvantages of the embodiments.
From the above description of the embodiments, it will be clear to those skilled in the art that the above embodiment method may be implemented by means of software plus necessary general hardware platform, or of course by means of hardware, but the former is a preferred embodiment under many data. Based on such understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art in the form of software goods stored in a storage medium (e.g. ROM/RAM, magnetic disk, optical disk) comprising instructions for causing an updating device of a data table to perform the method according to the embodiments of the present invention.