A base data initialization method, device and medium

Abstract

This invention relates to the field of data processing, and more particularly to a method, apparatus, and medium for initializing basic data. The method includes: obtaining a database statement; the database statement corresponds to an i-th sub-file, where the i-th sub-file is any sub-file in a j-th type file set of basic data; where i and j are positive integers; checking whether the attribute parameters of the database statement are consistent with the attribute parameters of the i-th sub-file; and determining that the database statement parsing was successful when the attribute parameters of the database statement are consistent with the attribute parameters of the i-th sub-file. This method can solve the problem of unreliable correctness in existing basic data initialization parsing methods.

Description

Technical Field

[0001] This invention relates to the field of data processing, and in particular to a basic data initialization method, apparatus, and medium. Background Technology

[0002] Banks store massive amounts of basic data, which is required for the production and deployment of any new payment or service system. Because the required basic data differs among banks, they currently obtain their respective basic data offline, perform initialization, parsing, and storage accordingly.

[0003] The current method for initializing and parsing basic data has certain drawbacks. Currently, it primarily involves writing corresponding file parsing scripts. However, existing file parsing scripts lack data verification functionality. After initializing and parsing the basic data storage bank's data, it is used directly, which cannot guarantee the correctness of the data obtained during initialization and parsing, potentially leading to the use of incorrect data later. Summary of the Invention

[0004] This invention provides a basic data initialization method, apparatus, and medium to solve the problem that the correctness of existing basic data initialization and parsing methods cannot be guaranteed.

[0005] In a first aspect, embodiments of the present invention provide a basic data initialization method, including:

[0006] Obtain the database statement; the database statement corresponds to the i-th sub-file, and the i-th sub-file is any sub-file in the j-th type file set of the basic data; where i and j are positive integers;

[0007] Check whether the attribute parameters of the database statement are consistent with the attribute parameters of the i-th sub-file;

[0008] The database statement is considered successfully parsed when its attribute parameters match those of the i-th sub-file.

[0009] By employing the above method, the database statement corresponding to any sub-file in any type of file set of basic data is obtained, and the attribute parameters of the database statement and its corresponding sub-file are checked. If the attribute parameters of the two are found to be consistent, the database statement is considered successfully parsed. This ensures the correctness of the initialization parsing of sub-files in the basic data into database statements, solving the problem that existing basic data initialization parsing methods cannot guarantee correctness.

[0010] Optionally, retrieve database statements, including:

[0011] Obtain the complete set of the aforementioned basic data;

[0012] Based on the full set of the basic data, determine the set of database statements corresponding to each type of file set in the basic data;

[0013] Wherein, the j-th type file set belongs to the full set of the basic data, the j-th database statement set is determined based on each sub-file in the j-th type file set, and the j-th database statement set includes the database statements.

[0014] Using the above method, all basic data can be obtained, and all basic data can be initialized and parsed in batches.

[0015] Optionally, after determining that the database statement was successfully parsed, the process includes:

[0016] Obtain an instruction signaling signal, which indicates a set of K types of files in the full set of the underlying data; where K is a positive integer;

[0017] K database statement sets are determined based on the instruction signaling and the database statement sets corresponding to each type of file set in the basic data, and the K database statement sets correspond one-to-one with the K types of file sets.

[0018] Using the above method, after all basic data has been initialized and parsed, a set of partial data statements that have been initialized and parsed can be obtained according to the instruction signaling.

[0019] Optionally, retrieve database statements, including:

[0020] Obtain the complete set of the aforementioned basic data;

[0021] Obtain an instruction signaling signal, which indicates a set of K types of files in the full set of the underlying data; where K is a positive integer;

[0022] The set of K types of files is determined according to the instruction signaling;

[0023] K sets of database statements are determined based on the K sets of files of the K types, and the K sets of database statements correspond one-to-one with the K sets of files of the K types;

[0024] The set of K types of files includes the set of the j-th type of files, the set of the j-th database statements is determined based on each sub-file in the set of the j-th type of files, and the set of the j-th database statements includes the database statements.

[0025] Using the above method, before initializing and parsing the basic data, the basic data files that need to be initialized and parsed can be determined according to the instruction signaling, and then these basic data files can be initialized and parsed into the corresponding set of database statements.

[0026] Optionally, it also includes:

[0027] Store the K sets of database statements into the database;

[0028] Verify, based on the instruction signaling, whether the K sets of database statements correspond one-to-one with the K sets of file types.

[0029] Using the above method, before or after storing the set of database statements parsed according to the instruction signaling into the database, it is verified whether these sets of database statements correspond to the file set of the underlying data, thereby ensuring that the set of database statements stored in the database meets the requirements of the instruction signaling.

[0030] Optionally, before determining that the database statement was successfully parsed, the method further includes:

[0031] The number of sub-files included in the j-th type file set is determined to be the same as the number of database statements included in the j-th database statement set.

[0032] Using the above method, the success of database statement initialization and parsing is verified by checking whether the number of sub-files included in the file set is consistent with the number of database statements included in the corresponding database statement set.

[0033] Optionally, the attribute parameter includes data length.

[0034] Optionally, the database statement may be in MySQL or Oracle format.

[0035] In a second aspect, embodiments of the present invention provide a basic data initialization apparatus, comprising:

[0036] The transceiver unit is used to acquire database statements; the database statement corresponds to the i-th sub-file, and the i-th sub-file is any sub-file in the j-th type file set of the basic data; where i and j are positive integers;

[0037] The processing unit is used to check whether the attribute parameters of the database statement are consistent with the attribute parameters of the i-th sub-file; if the attribute parameters of the database statement are consistent with the attribute parameters of the i-th sub-file, it is determined that the database statement was successfully parsed.

[0038] Optionally, the transceiver unit is configured to obtain the full set of the basic data when obtaining a database statement;

[0039] The processing unit is configured to determine the database statement set corresponding to each type of file set in the basic data based on the full set of the basic data; wherein, the j-th type of file set belongs to the full set of the basic data, the j-th database statement set is determined based on each sub-file in the j-th type of file set, and the j-th database statement set includes the database statements.

[0040] Optionally, the transceiver unit is configured to, after determining that the database statement has been successfully parsed, obtain an indication signaling signal, the indication signaling signaling indicating a set of K types of files in the full set of the basic data; where K is a positive integer;

[0041] The processing unit is configured to determine K sets of database statements based on the instruction signaling and the sets of database statements corresponding to each type of file set in the basic data, wherein the K sets of database statements correspond one-to-one with the K types of file sets.

[0042] Optionally, the transceiver unit is configured to, when obtaining a database statement, obtain the full set of the basic data; and obtain an indication signaling, the indication signaling indicating a set of K types of files in the full set of the basic data; where K is a positive integer;

[0043] The processing unit is configured to determine the K types of file sets according to the instruction signaling; and to determine K sets of database statements according to the K types of file sets, wherein the K sets of database statements correspond one-to-one with the K types of file sets; wherein the K types of file sets include the j-th type of file set, the j-th set of database statements is determined based on each sub-file in the j-th type of file set, and the j-th set of database statements includes the database statements.

[0044] Optionally, the processing unit is configured to store the K sets of database statements into a database; and verify, according to the instruction signaling, whether the K sets of database statements correspond one-to-one with the K sets of file types.

[0045] Optionally, the processing unit is configured to determine, before determining that the database statement parsing is successful, that the number of sub-files included in the j-th type file set is the same as the number of database statements included in the j-th database statement set.

[0046] Optionally, the attribute parameter includes data length.

[0047] Optionally, the database statement may be in MySQL or Oracle format.

[0048] Thirdly, this application also provides an apparatus. This apparatus can perform the above-described method design. The apparatus may be a chip or circuit capable of performing the functions corresponding to the above-described method, or a device including the chip or circuit.

[0049] In one possible implementation, the device includes: a memory for storing computer-executable program code; and a processor coupled to the memory. The program code stored in the memory includes instructions that, when executed by the processor, cause the device or a device equipped with the device to perform any of the methods described above.

[0050] The device may also include a communication interface, which may be a transceiver, or, if the device is a chip or circuit, the communication interface may be the chip's input / output interface, such as input / output pins.

[0051] In one possible design, the device includes corresponding functional units, each used to implement the steps in the above method. The functions can be implemented in hardware or by hardware executing corresponding software. The hardware or software includes one or more units corresponding to the functions described above.

[0052] Fourthly, this application provides a computer-readable storage medium storing a computer program that, when run on a device, executes the method described in any of the above possible designs.

[0053] Fifthly, this application provides a computer program product comprising: computer program code, which, when run on a computer, causes the computer to perform the method described in any one of the first aspects.

[0054] Furthermore, the technical effects of any of the implementation methods in the third to fifth aspects can be found in the technical effects of different implementation methods in the first aspect, and will not be repeated here. Attached Figure Description

[0055] Figure 1 A flowchart of a basic data initialization method provided in an embodiment of the present invention;

[0056] Figure 2 This is a schematic diagram illustrating the construction of a basic data parsing tool provided in an embodiment of the present invention;

[0057] Figure 3 A flowchart of a basic data initialization method in MySQL format provided in an embodiment of the present invention;

[0058] Figure 4A communication device 400 is provided for an embodiment of the present invention;

[0059] Figure 5 A communication device 500 is provided for an embodiment of the present invention. Detailed Implementation

[0060] To make the objectives, technical solutions, and advantages of this invention clearer, the invention will be further described in detail below with reference to the accompanying drawings. Obviously, the described embodiments are merely some embodiments of this invention, and not all embodiments. Based on the embodiments of this invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this invention.

[0061] The application scenarios described in the embodiments of this invention are for the purpose of more clearly illustrating the technical solutions of the embodiments of this invention, and do not constitute a limitation on the technical solutions provided by the embodiments of this invention. Those skilled in the art will understand that with the emergence of new application scenarios, the technical solutions provided by the embodiments of this invention are also applicable to similar technical problems. In the description of this invention, unless otherwise stated, "multiple" means two or more.

[0062] Currently, banks need to obtain basic data from the underlying data storage bank for initial parsing and use. However, existing file parsing scripts lack data verification capabilities. They are used directly after initial parsing the data from the underlying data storage bank, making it impossible to guarantee the correctness of the parsed data. Furthermore, these scripts can only initialize and parse a portion of the basic data types. Whenever a bank needs more types of basic data, a new script for each type must be written, which is time-consuming and labor-intensive. In addition, copying basic data from the underlying data storage bank by each bank is inefficient and wasteful of resources. Moreover, when banks later require more types of basic data, there is a possibility that they cannot obtain it from the underlying data storage bank in a timely manner, necessitating retrieval from other banks, and the accuracy of the data cannot be guaranteed.

[0063] Based on this, this application provides a basic data initialization method to solve the problem that the correctness of existing basic data initialization parsing cannot be guaranteed.

[0064] like Figure 1 As shown, the specific flow of the basic data initialization method provided in this application is as follows:

[0065] Step 100: Obtain the database statement.

[0066] For example, the database statement corresponds to the i-th sub-file, which is any sub-file in the j-th type file set of the basic data. The database statement is generated by initializing and parsing the i-th sub-file in the j-th type file set of the basic data. Here, i and j are positive integers. The database statement can also be called the database statement corresponding to the i-th sub-file in the j-th type file set. The format of this database statement can be either the commonly used MySQL or Oracle format, or any other database statement format; this application does not limit it. This database statement can be obtained by initializing and parsing the i-th sub-file in the j-th type file set using a shell script.

[0067] Specifically, the underlying data may include multiple sets of type files, each of which contains multiple sub-files. Among these, the j-th set of type files is included.

[0068] This application uses the basic data of the basic data storage bank as an example to illustrate the specifics. As shown in Table 1, the basic data of xx bank can specifically include a collection of 21 types of files, such as basic data files, node running status files, participant running status files, etc.

[0069] Table 1

[0070]

[0071]

[0072] The following example illustrates the specific process of obtaining database statements:

[0073] In the first implementation, the entire set of basic data is first obtained, and then the entire set of basic data is initialized and parsed to obtain the database statement sets corresponding to each type of file set in the basic data. At this point, the entire set of basic data contains the j-th type of file set, and its corresponding j-th database statement set is determined based on each sub-file in the j-th type of file set. This database statement is in the j-th database statement set.

[0074] Specifically, taking the basic data shown in Table 1 as an example, obtaining the full set of basic data means obtaining these 21 types of file sets. Then, each of these 21 types of file sets is initialized and parsed to obtain the corresponding 21 sets of database statements. Specifically, this involves initializing and parsing each sub-file contained in each of the 21 types of file sets to obtain the corresponding 21 sets of database statements. Specifically, the basic data of XX Bank can be obtained by applying offline to XX Bank and obtaining a copy of the basic data, or by other methods; this application does not limit the methods used.

[0075] For example, assuming j is 3 and i is 10, let's take the third type of file set out of these 21 file types as an example. This third type of file set includes 1000 sub-files. Each of these 1000 sub-files is initialized and parsed to obtain 1000 corresponding database statements. These 1000 database statements together form the third database statement set. At this point, the 10th database statement is in the third database statement set.

[0076] In the second implementation, the entire set of basic data is first obtained, followed by the acquisition of instruction signaling. Based on the instruction signaling, K file sets of required types are selected from the entire set of basic data, where K is a positive integer. Then, these K file sets of types are initialized and parsed to obtain corresponding K sets of database statements. These K sets of database statements correspond one-to-one with the K file sets of types. The K types can be pre-configured types or types determined according to specific business needs.

[0077] Specifically, at this time, the set of K types of files contains the set of the j-th type of files, and the corresponding set of the j-th database statements is determined based on each sub-file in the set of the j-th type of files. Therefore, the database statements in step 100 are in the set of the j-th database statements.

[0078] Specifically, taking the basic data shown in Table 1 as an example, after obtaining these 21 types of file sets, assume that the obtained instruction signaling indicates that the 1st, 3rd, and 5th types of file sets are specifically needed. Therefore, after obtaining the 1st, 3rd, and 5th types of file sets, the corresponding 3 database statement sets are initialized and parsed, namely the 1st, 3rd, and 5th database statement sets.

[0079] Step 110: Check whether the attribute parameters of the database statement are consistent with the attribute parameters of the i-th sub-file.

[0080] For example, after obtaining the database statement corresponding to the i-th sub-file in step 100, it is also necessary to compare the attribute parameters of the database statement with the attribute parameters of the corresponding i-th sub-file to determine whether the attribute parameters of the two are consistent. Specifically, the attribute parameters can be data length or any other attribute parameters, which is not limited in this application.

[0081] For example, let's take j as 3, i as 10, and data length as the attribute parameter for specific explanation. After obtaining the third type of file set, if the data length of the 10th sub-file is determined to be 4, then the data length of the database statement corresponding to the 10th sub-file in the third database statement set is obtained, and the two are checked to see if they are the same.

[0082] Step 120: If the attribute parameters of the database statement are consistent with the attribute parameters of the i-th sub-file, the database statement is determined to have been successfully parsed.

[0083] For example, when it is determined in step 110 that the attribute parameters of the database statement corresponding to the i-th sub-file are consistent with the attribute parameters of the i-th sub-file, it can be determined that the database statement initialization and parsing were successful.

[0084] For example, let's take j as 3, i as 10, and the attribute parameter as data length as an example for specific explanation. When the data length of the 10th sub-file in the third type of file set is 4, and the data length of the database statement corresponding to the 10th sub-file in the third database statement set is also 4, it means that the database statement corresponding to the 10th sub-file in the third database statement set has been successfully parsed.

[0085] For example, since what is needed is not just a single database statement, but a collection of database statements of a certain type, it is also necessary to compare the number of sub-files contained in the j-th type of file collection with the number of database statements contained in its corresponding j-th database statement collection. If the two numbers are the same, and the attribute parameters of all database statements contained in the j-th database statement collection are consistent with the attribute parameters of their corresponding sub-files, then the initialization and parsing of the j-th database statement collection is considered successful.

[0086] For example, in the first implementation of step 100, after initializing and parsing each type of file set in the full set of basic data into corresponding database statement sets, an instruction signal can be obtained to determine the specific K required database statement sets. These K database statement sets correspond one-to-one with the K types of file sets.

[0087] Before obtaining the instruction signaling, it is necessary to determine whether the file sets of each type in the full set of basic data have been successfully parsed. Specifically, the attribute parameters of each database statement in each database statement set obtained from the full set of basic data parsing and the corresponding sub-files in their respective file sets can be verified. Furthermore, the number of database statements contained in each database statement set obtained from the full set of basic data parsing and the number of sub-files contained in its respective file set can also be verified. If both the attribute parameters and the number of statements are verified successfully, it indicates that the full set of basic data has been successfully initialized and parsed.

[0088] Alternatively, after obtaining the instruction signaling, it is necessary to determine whether the K types of file sets in the full set of basic data have been successfully parsed. In this case, only the attribute parameters of each database statement in each of the K database statement sets and the corresponding sub-files in their respective file sets can be verified. Additionally, the number of database statements contained in each of the K database statement sets and the number of sub-files contained in its corresponding file set can be verified. If both the attribute parameters and the number of sub-files are successfully verified, it indicates that the initial parsing of the K types of file sets has been successful.

[0089] For example, in the second implementation of step 100, after initializing and parsing the K types of file sets into K sets of database statements, it is also necessary to verify the attribute parameters of each database statement in these K sets of database statements and the corresponding sub-files in the corresponding type of file set, as well as to verify the number of database statements contained in each of the K sets of database statements and the number of sub-files contained in the corresponding type of file set. When the attribute parameters and the number are verified successfully, it means that the K types of file sets have been successfully initialized and parsed.

[0090] Furthermore, after confirming that all K file sets of different types have been successfully initialized and parsed, the corresponding K sets of database statements can be stored in their respective databases. These corresponding databases are those that require the use of the K sets of database statements; the K sets of database statements can reside in the same database or different databases.

[0091] Before and / or after storing the set of database statements into the corresponding database, the set of K database statements can also be verified according to the instruction signaling.

[0092] For example, before storing them in the database, it can be verified whether the K sets of database statements correspond one-to-one with the K sets of type files, that is, whether the K sets of database statements to be stored are the preset ones or obtained after initializing and parsing the K sets of type files to be stored.

[0093] For example, after storing them in the database, it can be verified whether these K sets of database statements correspond one-to-one with the K sets of type files. That is, it can be verified whether the K sets of database statements already stored in the database are the preset ones or the K sets of type files to be stored that were obtained after initialization and parsing.

[0094] For example, after determining that there is a one-to-one correspondence between the K sets of database statements and the K sets of files of different types, the attribute parameters and their numbers can be verified again for the K sets of database statements. Specifically, this involves verifying whether the number of database statements in each of the K sets of database statements is consistent with the number of subfiles in its corresponding file set, and whether the attribute parameters of each database statement in each of the K sets of database statements are consistent with the attribute parameters of the corresponding subfiles in its corresponding file set. This ensures the correctness of the storage of the K sets of database statements.

[0095] Using the above method, this application can obtain the full set of basic data, perform initialization parsing on the full set of data, and thus obtain all database statement sets obtained from the initialization parsing at once. Furthermore, the correctness of all database statement sets obtained from the initialization parsing can be verified, avoiding the possibility of obtaining inaccurate basic data from third parties when more types of basic data are needed later, while ensuring the correctness of the database statement sets obtained from the initialization parsing. Therefore, after determining the preset or required types of basic data, the database statement sets corresponding to these basic data can be directly stored in the corresponding database.

[0096] Alternatively, this application can obtain the full set of basic data. When determining the type of basic data to be obtained, the application directly retrieves the required type of basic data from the full set of basic data, initializes and parses this basic data to obtain the corresponding set of database statements, and verifies the correctness of these sets of database statements to ensure their correctness. Furthermore, this application also verifies the set of database statements to be stored before and / or after storing it in the database to ensure the correctness of the stored set of database statements.

[0097] Therefore, this application not only enables banks to uniformly copy and obtain basic data before selecting the desired basic data, ensuring the accuracy of the data source, but also allows for batch initialization and parsing of a large amount of data at once; at the same time, it also verifies the set of database statements obtained from initialization and parsing multiple times to ensure the correctness of the data.

[0098] For example, the aforementioned process of initializing, parsing, and validating basic data can be implemented using a basic data parsing tool, which may include shell scripts and database syntax, etc. Specifically, Figure 2 This is a schematic diagram illustrating the construction of a basic data parsing tool proposed in this application, as shown below. Figure 2 As shown, the basic data parsing tool includes a basic data file set parsing module and a database statement verification module. The basic data file set parsing module can perform the initialization and parsing of multiple types of file sets into corresponding database statement sets based on the database type, as described in step 100 above. The database statement verification module can perform the operations involved in steps 110 and 120 above, such as verifying whether the attribute parameters of the database statements are consistent with the attribute parameters of their corresponding subfiles, and verifying whether the number of database statements included in the database statement set is consistent with the number of subfiles contained in the corresponding type of file set, etc.

[0099] For example, Figure 3 This is a flowchart illustrating a basic data initialization method proposed in this application. Figure 3 As shown, this application uses the MySQL database statement format and the above-mentioned format. Figure 1 The first implementation method will be used as an example for detailed explanation.

[0100] Step 301: Obtain the full set of basic data.

[0101] Specifically, the entire set of all basic data was obtained by applying offline to xx bank.

[0102] Step 302: Initialize the full set of parsed basic data.

[0103] Specifically, referring to the first implementation method in step 100, a basic data parsing tool is used to initialize and parse the entire set of basic data. Since the database statements are in MySQL format at this time, therefore... Figure 2 The basic data file set parsing module in the basic data parsing tool shown can initialize and parse the entire set of basic data into a set of database statements in MySQL format.

[0104] Step 303: Verify whether the full set of basic data has been successfully initialized and parsed.

[0105] Specifically, referring to the verification method for whether the initialization and parsing were successful in the first implementation method in step 120, the basic data file set parsing module in the basic data parsing tool puts the initialized and parsed MySQL format database statement set into the database statement verification module for verification. If the attribute parameters and number of the database statement set corresponding to the full set of basic data are verified successfully, step 304 is executed; otherwise, verification failure is indicated.

[0106] Step 304: Determine the required set of database statements based on the instruction signaling.

[0107] Specifically, after confirming that the entire set of basic data has been successfully initialized and parsed, assuming that the obtained instruction signaling indicates that the 1st, 7th, and 10th type of file set are required, then it is determined that the 1st, 7th, and 10th database statement sets corresponding to these 3 types are required.

[0108] Step 305: Verify whether the obtained set of database statements corresponds one-to-one with the corresponding set of type files.

[0109] Specifically, after determining in step 304 that the 1st, 7th, and 10th database statement sets are needed, the database statement verification module compares and verifies these three database statement sets with their corresponding file sets of the 1st, 7th, and 10th types, respectively. This ensures that the 1st database statement set corresponds to the file set of the 1st type, the 7th database statement set corresponds to the file set of the 7th type, and the 10th database statement set corresponds to the file set of the 10th type. If verification is successful, the process proceeds to step 306; otherwise, verification fails.

[0110] Step 306: Store the set of successfully verified database statements into the corresponding database.

[0111] Specifically, assuming the first set of database statements is needed by database 1, the seventh set is needed by database 2, and the tenth set is needed by database 3, then these three sets of database statements will be stored in their respective databases. Specifically, as follows... Figure 2 As shown, assuming the first database is database 1, the second database is database 2, and the Qth database is database 3, then storing the three database statement sets into the corresponding databases is specifically as follows: storing the first database statement set into the first database, storing the seventh database statement set into the second database, and storing the tenth database statement set into the Qth database.

[0112] Alternatively, assuming that the 1st, 7th, and 10th database statement sets are all needed by database 1, then these three database statement sets should all be stored in database 1. Specifically, as follows... Figure 2 As shown, assuming the first database is database 1, the 1st, 7th, and 10th database statement sets are all stored in the first database.

[0113] Step 307: Verify again whether the set of database statements stored in the database corresponds one-to-one with the set of corresponding type files.

[0114] Specifically, after storing the three database statements into their respective databases, the database statement verification module needs to be used again to verify that the first set of database statements corresponds to the first type of file set, the seventh set of database statements corresponds to the seventh type of file set, and the tenth set of database statements corresponds to the tenth type of file set, to prevent deviations during database storage. If verification is successful, proceed to step 308; otherwise, it indicates a problem with the database statement set.

[0115] Step 308: Verify the attribute parameters and number of the database statement set stored in the database.

[0116] Specifically, after the three sets of database statements are successfully verified in step 307, the attribute parameters and their numbers from step 120 need to be verified again to prevent issues with the attribute parameters or their numbers when the database statement sets are stored in the corresponding database. This verification process also uses the database statement verification module. Successful verification indicates successful data storage; otherwise, it indicates a problem with the database statement sets.

[0117] The acquisition, storage, use, and processing of data in this application all comply with the relevant provisions of national laws and regulations.

[0118] The division of units in the embodiments of this invention is illustrative and represents only one logical functional division. In actual implementation, other division methods may be used. Furthermore, the functional units in the various embodiments of this invention can be integrated into a single processor, exist as separate physical units, or be integrated into a single unit. The integrated units described above can be implemented in hardware or as software functional units.

[0119] This invention also provides a communication device 400, see [link to documentation]. Figure 4 As shown, it includes: a processing module 410 and a transceiver module 420.

[0120] The transceiver module 420 may include a receiving unit and a transmitting unit. The processing module 410 is used to control and manage the operation of the communication device 400. The transceiver module 420 is used to support communication between the communication device 400 and other devices. Optionally, the communication device 400 may also include a storage unit for storing the program code and data of the communication device 400.

[0121] Optionally, each module in the communication device 400 can be implemented by software.

[0122] Optionally, the processing module 410 may be a processor or controller, such as a general-purpose central processing unit (CPU), a general-purpose processor, a digital signal processing unit (DSP), an application-specific integrated circuit (ASIC), a field-programmable gate array (FPGA), or other programmable logic devices, transistor logic devices, hardware components, or any combination thereof. It can implement or execute various exemplary logic blocks, modules, and circuits described in conjunction with the embodiments of this application. The processor may also be a combination that implements computing functions, such as a combination of one or more microprocessors, a combination of a DSP and a microprocessor, etc. The transceiver module 420 may be a communication interface, a transceiver, or a transceiver circuit, etc., wherein the communication interface is a general term, and in a specific implementation, the communication interface may include multiple interfaces, and the storage unit may be a memory.

[0123] Processing module 410 calls transceiver module 420 to execute:

[0124] The transceiver module 420 is used to obtain database statements; the database statement corresponds to the i-th sub-file, and the i-th sub-file is any sub-file in the j-th type file set in the basic data; where i and j are positive integers;

[0125] The processing module 410 is used to check whether the attribute parameters of the database statement are consistent with the attribute parameters of the i-th sub-file; if the attribute parameters of the database statement are consistent with the attribute parameters of the i-th sub-file, it is determined that the database statement was successfully parsed.

[0126] This invention also provides another communication device 500, see [link to previous document]. Figure 5 As shown, it includes:

[0127] Communication interface 501, memory 502, and processor 503;

[0128] The communication device 500 communicates with other devices through the communication interface 501, such as sending and receiving messages; the memory 502 is used to store program instructions; and the processor 503 is used to call the program instructions stored in the memory 502 and execute them according to the obtained program.

[0129] Processor 503 executes program instructions stored in communication interface 501 and memory 502:

[0130] Obtain the database statement; the database statement corresponds to the i-th sub-file, and the i-th sub-file is any sub-file in the j-th type file set of the basic data; where i and j are positive integers;

[0131] Check whether the attribute parameters of the database statement are consistent with the attribute parameters of the i-th sub-file;

[0132] The database statement is considered successfully parsed when its attribute parameters match those of the i-th sub-file.

[0133] In this embodiment of the invention, the specific connection medium between the communication interface 501, the memory 502 and the processor 503 is not limited, such as a bus. A bus can be divided into an address bus, a data bus, a control bus, etc.

[0134] In this embodiment of the invention, the processor may be a general-purpose processor, a digital signal processor, an application-specific integrated circuit (ASIC), a field-programmable gate array (FPGA), or other programmable logic devices, discrete gate or transistor logic devices, or discrete hardware components, capable of implementing or executing the methods, steps, and logic block diagrams disclosed in this embodiment of the invention. The general-purpose processor may be a microprocessor or any conventional processor. The steps of the methods disclosed in this embodiment of the invention can be directly manifested as being executed by a hardware processor, or executed by a combination of hardware and software modules within the processor.

[0135] In embodiments of the present invention, the memory can be non-volatile memory, such as a hard disk drive (HDD) or a solid-state drive (SSD), or it can be volatile memory, such as random-access memory (RAM). The memory can also be any other medium capable of carrying or storing desired program code having an instruction or data structure form and accessible by a computer, but is not limited thereto. The memory in embodiments of the present invention can also be a circuit or any other device capable of implementing a storage function for storing program instructions and / or data.

[0136] This invention also provides a computer-readable storage medium including program code. When the program code is run on a computer, the program code is used to cause the computer to perform the steps of the method provided in the above embodiments of this invention.

[0137] This invention also provides a computer program product comprising: computer program code, which, when run on a computer, causes the computer to perform the steps of the method provided in this invention.

[0138] Those skilled in the art will understand that embodiments of the present invention can be provided as methods, systems, or computer program products. Therefore, the present invention can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present invention can take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0139] This invention is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart illustrations and / or block diagrams. Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0140] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0141] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1The steps of the function specified in one or more boxes.

[0142] Although preferred embodiments of the invention have been described, those skilled in the art, upon learning the basic inventive concept, can make other changes and modifications to these embodiments. Therefore, the appended claims are intended to be interpreted as including both the preferred embodiments and all changes and modifications falling within the scope of the invention.

[0143] Obviously, those skilled in the art can make various modifications and variations to this invention without departing from its scope. Therefore, if these modifications and variations fall within the scope of the claims of this invention and their equivalents, this invention also intends to include these modifications and variations.

Claims

1. A method for initializing basic data, characterized in that, The method includes: Obtaining database statements includes: obtaining the full set of basic data; and determining the set of database statements corresponding to each type of file set in the basic data based on the full set of basic data. Wherein, the j-th type file set belongs to the full set of the basic data; the j-th database statement set is determined based on each sub-file in the j-th type file set; the j-th database statement set includes database statements; the database statements are generated by initializing and parsing based on the i-th sub-file in the j-th type file set of the basic data; the i-th sub-file is any sub-file in the j-th type file set of the basic data; where i and j are positive integers. Check whether the attribute parameters of the database statement are consistent with the attribute parameters of the i-th sub-file; The database statement is considered successfully parsed when its attribute parameters match those of the i-th sub-file.

2. The method as described in claim 1, characterized in that, After confirming that the database statement was successfully parsed, the following steps are taken: Obtain an instruction signaling signal, which indicates a set of K types of files in the full set of the underlying data; where K is a positive integer; K database statement sets are determined based on the instruction signaling and the database statement sets corresponding to each type of file set in the basic data, and the K database statement sets correspond one-to-one with the K types of file sets.

3. The method as described in claim 1, characterized in that, The database retrieval statement also includes: Obtain the complete set of the aforementioned basic data; Obtain an instruction signaling signal, which indicates a set of K types of files in the full set of the underlying data; where K is a positive integer; The set of K types of files is determined according to the instruction signaling; K sets of database statements are determined based on the K sets of files of the K types, and the K sets of database statements correspond one-to-one with the K sets of files of the K types; The set of K types of files includes the set of the j-th type of files, the set of the j-th database statements is determined based on each sub-file in the set of the j-th type of files, and the set of the j-th database statements includes the database statements.

4. The method as described in claim 2 or 3, characterized in that, Also includes: Store the K sets of database statements into the database; Verify, based on the instruction signaling, whether the K sets of database statements correspond one-to-one with the K sets of file types.

5. The method as described in claim 1 or 3, characterized in that, Before determining that the database statement was successfully parsed, the following steps are also included: The number of sub-files included in the j-th type file set is determined to be the same as the number of database statements included in the j-th database statement set.

6. The method as described in claim 1, characterized in that, The attribute parameters include data length.

7. The method as described in claim 1, characterized in that, The database statements are in either MySQL or Oracle format.

8. A basic data initialization device, characterized in that, The device includes: The transceiver unit is used to obtain database statements, including: obtaining the full set of basic data; and determining the set of database statements corresponding to each type of file set in the basic data based on the full set of basic data. Wherein, the j-th type file set belongs to the full set of the basic data; the j-th database statement set is determined based on each sub-file in the j-th type file set; the j-th database statement set includes database statements; the database statements are generated by initializing and parsing based on the i-th sub-file in the j-th type file set of the basic data; the i-th sub-file is any sub-file in the j-th type file set of the basic data; where i and j are positive integers. The processing unit is used to check whether the attribute parameters of the database statement are consistent with the attribute parameters of the i-th sub-file; if the attribute parameters of the database statement are consistent with the attribute parameters of the i-th sub-file, it is determined that the database statement was successfully parsed.

9. The apparatus as claimed in claim 8, characterized in that, The transceiver unit is configured to obtain an indication signaling after determining that the database statement has been successfully parsed. The indication signaling indicates a set of K types of files in the full set of the basic data; where K is a positive integer. The processing unit is configured to determine K sets of database statements based on the instruction signaling and the sets of database statements corresponding to each type of file set in the basic data, wherein the K sets of database statements correspond one-to-one with the K types of file sets.

10. The apparatus as claimed in claim 8, characterized in that, The transceiver unit is further configured to, when obtaining a database statement, obtain the full set of the basic data; and obtain an indication signaling, the indication signaling indicating a set of K types of files in the full set of the basic data; where K is a positive integer; The processing unit is configured to determine the K types of file sets according to the instruction signaling; and to determine K sets of database statements according to the K types of file sets, wherein the K sets of database statements correspond one-to-one with the K types of file sets; wherein the K types of file sets include the j-th type of file set, the j-th set of database statements is determined based on each sub-file in the j-th type of file set, and the j-th set of database statements includes the database statements.

11. The apparatus as claimed in claim 9 or 10, characterized in that, The processing unit is further configured to store the K sets of database statements into a database; and to verify, according to the instruction signaling, whether the K sets of database statements correspond one-to-one with the K sets of file types.

12. The apparatus as claimed in claim 8 or 10, characterized in that, The processing unit is configured to determine, before determining that the database statement parsing is successful, that the number of sub-files included in the j-th type file set is the same as the number of database statements included in the j-th database statement set.

13. The apparatus as claimed in claim 8, characterized in that, The attribute parameters include data length.

14. The apparatus as claimed in claim 8, characterized in that, The database statements are in either MySQL or Oracle format.

15. A computing device, characterized in that, The device includes a processor and an interface circuit, the interface circuit being used to receive signals from other devices outside the device and transmit them to the processor or to send signals from the processor to other devices outside the device, the processor being used to implement the method as described in any one of claims 1 to 7 via logic circuits or execution code instructions.

16. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer instructions that, when executed on a computer, cause the computer to perform the method of any one of claims 1 to 7.

17. A computer program product, characterized in that, The computer program product includes: computer program code that, when run on a computer, causes the computer to perform the method as described in any one of claims 1 to 7.

Images