CN116680280A

CN116680280A - Data verification method and related device

Info

Publication number: CN116680280A
Application number: CN202210158046.0A
Authority: CN
Inventors: 王春生; 陈春; 刘兵
Original assignee: Shenzhen Xishima Data Technology Co ltd
Current assignee: Shenzhen Xishima Data Technology Co ltd
Priority date: 2022-02-21
Filing date: 2022-02-21
Publication date: 2023-09-01

Abstract

The application provides a data verification method and a related device, wherein the method comprises the following steps: acquiring at least one first index name and to-be-checked index value of each first index name associated with a pre-stored target service parameter; sending a first query statement for querying a reference index value to the server; receiving the reference index value sent by the server; updating the index value of the at least one first index name according to the reference index value. The embodiment of the application can realize the verification of the pre-stored data, can store inquiry sentences to facilitate the subsequent verification work, solves the problems that a tester cannot accurately verify due to manual numerical calculation and can complete the verification only by comparing and inquiring a plurality of data tables for a plurality of times, and can conveniently realize the verification of the data and improve the practicability.

Description

Data verification method and related device

Technical Field

The application relates to the technical field of general data processing in the Internet industry, in particular to a data verification method and a related device.

Background

At present, data on a certain software product page is obtained by a technician inquiring a database in advance or calculating from a front-end page and is stored in the electronic equipment, and the data in the database can change at any time, so that the data needs to be checked in the software testing work. In a normal case, the verification work is to use a simple query statement to query a plurality of tables by a tester, obtain reference data by adopting a mode of manually calculating the data, and then perform manual comparison.

However, with the enhancement of the software function, the fields to be queried and the data to be checked by the testers are gradually increased, and the fields are distributed differently, so that great trouble is brought to the check work of the testers, and errors are easy to occur in the data calculation and comparison work performed manually, so that the problems that the check work efficiency is low and the check needs to be repeated every time are caused.

Disclosure of Invention

The embodiment of the application provides a data verification method and a related device, which are used for providing convenience, efficiency and practicability for data verification of electronic equipment.

In a first aspect, an embodiment of the present application provides a data verification method, including:

Acquiring at least one first index name and to-be-checked index values of each first index name associated with a pre-stored target service parameter, wherein the at least one first index name comprises at least one second index name and at least one third index name, the second index name is an index name of a corresponding value directly stored in a database of a server, the third index name is a parameter value of an intermediate parameter stored in the database of the server, and the electronic equipment is required to obtain the index name of the corresponding value according to a preset formula and the value of the intermediate parameter, and the target service parameter is any one of a plurality of service parameters required in a data analysis and calculation process aiming at a target service requirement;

sending a first query statement for querying a reference index value to the server, wherein the reference index value comprises a reference index value corresponding to each second index name and a reference index value corresponding to each third index name;

receiving the reference index value sent by the server in response to the first query statement;

updating the index value of the at least one first index name according to the reference index value.

In a second aspect, an embodiment of the present application further provides a data extraction method, including:

acquiring the first query statement sent by the electronic equipment;

querying the reference index value in response to the first query statement;

and sending the reference index value to the electronic equipment.

In a third aspect, an embodiment of the present application further provides a data verification apparatus, including:

an acquisition unit: the method comprises the steps of obtaining at least one first index name and to-be-checked index values of each first index name which are associated with a pre-stored target service parameter, wherein the at least one first index name comprises at least one second index name and at least one third index name, index names of corresponding values are directly stored in a database of a server, the third index name is a parameter value of an intermediate parameter stored in the database of the server, and the index names of the corresponding values are needed to be obtained by the electronic equipment according to a preset formula and the values of the intermediate parameter, and the target service parameter is any one of a plurality of service parameters needed in a data analysis calculation process aiming at a target service requirement;

A transmitting unit: the first query statement is used for sending a first query statement used for querying a reference index value to the server, wherein the reference index value comprises a reference index value corresponding to each second index name and a reference index value corresponding to each third index name;

a receiving unit: for receiving the reference index value from the server;

an updating unit: for updating the index value of the at least one first index name based on the reference index value.

In a fourth aspect, an embodiment of the present application further provides a data extraction apparatus, including:

an acquisition unit: for obtaining the first query statement from the electronic device;

and a processing unit: the method comprises the steps of inquiring the database according to the first inquiry statement to obtain the reference index value;

a transmitting unit: for transmitting the reference index value to the electronic device.

In a fifth aspect, embodiments of the present application also provide an electronic device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, the processor implementing the steps of any of the methods of the first aspect as described above.

In a sixth aspect, embodiments of the present application also provide a server comprising a memory, a processor and a computer program stored in said memory and executable on said processor, said processor implementing the steps of any of the methods of the second aspect as described above.

In a seventh aspect, embodiments of the present application also provide a computer readable storage medium storing a computer program which, when executed by a processor, implements the steps of any of the methods of the first or second aspects as described above.

In an eighth aspect, embodiments of the present application provide a computer program product, wherein the computer program product comprises a non-transitory computer readable storage medium storing a computer program operable to cause a computer to perform part or all of the steps described in the first or second aspects of the embodiments of the present application. The computer program product may be a software installation package.

It can be seen that, in the embodiment of the present application, the electronic device first obtains at least one first index name associated with the target service parameter and the index value to be checked corresponding to the first index name and the first index name, then sends a query statement for querying the reference index value corresponding to the first index name and the reference index value to the server, then receives the reference index value sent by the server in response to the query statement, and finally updates the prestored index value to be checked according to the reference index value. Therefore, the reference index values to be referred by all index names to be checked can be obtained only by one time of inquiry, the calculation data is completed by the server, and the comparison and the update of the data are completed by the electronic equipment, so that errors caused by manual calculation and comparison are avoided, the checking efficiency and accuracy are improved, the convenience of the subsequent checking work in the mode of storing the query statement can be realized, and the practicability of the query statement is improved.

Drawings

In order to more clearly illustrate the embodiments of the application or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the application, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.

FIG. 1a is a schematic diagram of a data verification system according to an embodiment of the present application;

fig. 1b is a schematic structural diagram of an electronic device according to an embodiment of the present application;

fig. 1c is a schematic structural diagram of a server according to an embodiment of the present application;

FIG. 2a is a schematic diagram illustrating a data verification method according to an embodiment of the present application;

FIG. 2b is a schematic diagram of a query statement set based on a multi-way tree model according to an embodiment of the present application;

fig. 3 is a schematic flow chart of a data extraction method according to an embodiment of the present application;

FIG. 4 is a functional block diagram of a data verification device according to an embodiment of the present application;

FIG. 5 is a block diagram showing the functional units of a data extraction device according to an embodiment of the present application;

FIG. 6 is a block diagram of a data verification device according to an embodiment of the present application;

fig. 7 is a block diagram of a data extraction device according to an embodiment of the present application.

Detailed Description

In order that those skilled in the art will better understand the present application, a technical solution in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present application, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.

The terms first, second and the like in the description and in the claims and in the above-described figures are used for distinguishing between different objects and not necessarily for describing a sequential or chronological order. Furthermore, the terms "comprise" and "have," as well as any variations thereof, are intended to cover a non-exclusive inclusion. For example, a process, method, system, article, or apparatus that comprises a list of steps or elements is not limited to only those listed steps or elements but may include other steps or elements not listed or inherent to such process, method, article, or apparatus.

Reference herein to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment may be included in at least one embodiment of the application. The appearances of such phrases in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. Those of skill in the art will explicitly and implicitly appreciate that the embodiments described herein may be combined with other embodiments.

In order to better understand the technical scheme of the embodiment of the present application, a data verification system and an electronic device that may be related to the embodiment of the present application are described below.

Referring to fig. 1a, fig. 1a is a schematic diagram of a data verification system according to an embodiment of the application, as shown in the drawing, a data verification system 100 includes a server 101 and an electronic device 102, where the server 101 is communicatively connected to the electronic device 102. The electronic device 102 sends a first query statement to the server 101, so that the server 101 can know index names of the electronic device 102 which want to be queried in the database, then obtain values of the index names stored in the database, calculate corresponding third index names according to a calculation formula contained in the first query statement to obtain reference index values of the third index names, and extract the reference index values of the index names to be checked, one server 101 can also correspond to a plurality of electronic devices at the same time, or the data checking system 100 comprises a plurality of servers, and each server corresponds to one or a plurality of electronic devices.

Specifically, the structure of the electronic device as shown in fig. 1a may refer to fig. 1b, and fig. 1b is a schematic structural diagram of an electronic device according to an embodiment of the present application. As shown in fig. 1b, the electronic device 110 may implement steps in a data verification method, the electronic device 110 comprising a processor 120, a memory 130, a communication interface 140, and one or more programs 131, wherein the one or more programs 131 are stored in the memory 130 and configured to be executed by the processor 120, the one or more programs 131 comprising instructions for performing any of the steps of the method embodiments described above. The structure of the server as shown in fig. 1a may refer to fig. 1c, and fig. 1c is a schematic structural diagram of a server according to an embodiment of the present application. As shown in fig. 1c, the server 210 may implement steps in a data extraction method, the server 210 comprising a processor 220, a memory 230, a communication interface 240, and one or more programs 231, wherein the one or more programs 231 are stored in the memory 230 and configured to be executed by the processor 220, the one or more programs 231 comprising instructions for performing any of the steps of the method embodiments described above.

The communication interface may also be a transceiver, a transceiver circuit, etc. for supporting communication between the first electronic device and other devices. The memory is used for storing program codes and data of the terminal. The processor may also be a controller, such as a central processing unit (Central Processing Unit, CPU), a general purpose processor, a digital signal processor (Digital Signal Processor, DSP), an Application-specific integrated circuit (ASIC), a field programmable gate array (Field Programmable Gate Array, FPGA) or other programmable logic device, transistor logic device, hardware component, or any combination thereof. Which may implement or perform the various exemplary logic blocks, units and circuits described in connection with this disclosure. The processor may also be a combination that performs the function of a computation, e.g., a combination comprising one or more microprocessors, a combination of a DSP and a microprocessor, and the like.

The memory may be volatile memory or nonvolatile memory, or may include both volatile and nonvolatile memory. The nonvolatile memory may be a read-only memory (ROM), a Programmable ROM (PROM), an Erasable PROM (EPROM), an electrically Erasable EPROM (EEPROM), or a flash memory. The volatile memory may be random access memory (random access memory, RAM) which acts as an external cache. By way of example but not limitation, many forms of random access memory (random access memory, RAM) are available, such as Static RAM (SRAM), dynamic Random Access Memory (DRAM), synchronous Dynamic Random Access Memory (SDRAM), double data rate synchronous dynamic random access memory (DDR SDRAM), enhanced Synchronous Dynamic Random Access Memory (ESDRAM), synchronous Link DRAM (SLDRAM), and direct memory bus RAM (DR RAM).

In a specific implementation, the processor is configured to perform any step performed by the electronic device in the above method embodiment, and when performing data transmission such as sending, the communication interface is optionally invoked to complete a corresponding operation.

At present, software testing works mainly perform functional and nonfunctional testing on a system, often meet the situation that data needs to be checked, for example, correctness checking is performed on index values corresponding to indexes in a plurality of service parameters under a target service requirement, some of the index values can be directly obtained by querying a database, and some of the index values need to be obtained by calculating intermediate parameters. The commonly adopted verification method is to use a plurality of simple query sentences to query the numerical values of a plurality of data tables, then manually compare the numerical values with index numerical values which can be directly obtained, then manually calculate the numerical values according to a plurality of intermediate parameters obtained by query, and then manually compare the rest numerical values. The problems caused by the method are that the query work is difficult due to excessive fields and irregular distribution, negligence and errors are easy to occur in manual calculation and comparison, the verification work is time-consuming and labor-consuming and has low efficiency, and the verification needs to be carried out by a heavy head each time.

In order to solve the above problems, an embodiment of the present application provides a data verification method, which may be applied to electronic device verification data. The method comprises the steps of obtaining a prestored index name to be checked and a corresponding index value to be checked, sending a query statement for querying the reference index value to a server, obtaining the server to extract all the reference index values through single query, and finally updating the prestored index value to be checked according to the reference index value so as to realize efficient and accurate check of the index value corresponding to the index under the target service parameter.

The following describes the data verification method according to the embodiment of the present application from the perspective of the method embodiment.

Referring to fig. 2a, fig. 2a is a schematic process diagram of a data verification method according to an embodiment of the present application, applied to an electronic device, the method includes the following steps:

step 201, obtaining at least one first index name and to-be-checked index value of each first index name associated with a pre-stored target service parameter;

the at least one first index name comprises at least one second index name and at least one third index name, the index names of corresponding values are directly stored in a database of a server, the third index name is a parameter value of an intermediate parameter stored in the database of the server, the index names of the corresponding values are needed to be obtained by the electronic equipment according to a preset formula and the value of the intermediate parameter, and the target service parameter is any one of a plurality of service parameters needed in a data analysis calculation process aiming at the target service requirement.

In a possible embodiment, before the obtaining at least one first index name associated with the pre-stored target service parameter and the index value to be verified of each first index name, the method further includes: sending a second query statement for querying an index name associated with a target service parameter and an original numerical value corresponding to the index name to the server, wherein the original numerical value comprises the original index numerical value corresponding to each index name associated with the target service parameter and an original parameter numerical value of an intermediate parameter stored in a database of the server; receiving the at least one first index name and the original value of the at least one first index name transmitted from the server; judging whether each first index name has the corresponding original index value or not: if yes, determining that the original index value of the first index name processed currently is the index value to be checked, and determining that the first index name processed currently is the second index name; if not, calculating according to the preset formula and the original parameter value of the first index name of the current process to obtain the index value to be checked, and determining that the first index name of the current process is the third index name; storing the at least one second index name and the at least one third index name, and the index value to be checked of the at least one second index name and the index value to be checked of the at least one third index name.

In order to facilitate users to directly view all indexes and corresponding values of the indexes under the target service parameters on the page, technicians are required to query the associated indexes and values of the target service parameters in the early software design stage and store the indexes and values in the electronic equipment. In this embodiment, a technician may query a plurality of tables in the database to obtain the associated index names and corresponding values by writing a simple query statement, or may query a plurality of tables to obtain the associated index names and corresponding values by writing an associated query statement, which is not limited in this case. And because one part of indexes can directly inquire the index value from the database, the other part of indexes can only inquire the intermediate parameter in the database, and the index value is required to be calculated by the front-end page according to a formula, the index names are required to be classified so as to be convenient for different operations aiming at the index names of different categories in the subsequent verification.

For example, in an application scenario for financial analysis, there are four business parameters of corporate data, financial statement, financial index analysis, and financial comprehensive analysis under a financial analysis module in a software page. Under the condition of aiming at the business parameter of the financial statement, a technician inquires all indexes and corresponding numerical values under the financial statement from a database in a server in advance by writing a structured statement (Structured Query Language, SQL), stores the indexes and the numerical values into electronic equipment, and pops up all indexes and numerical values under the financial statement to be consulted when a user clicks to check the financial statement.

In this example, the index name and the value under the target service parameter are obtained through the previous query or calculation, so that the user can check the information of the target service parameter without writing a query sentence and waiting for the response of the server when using the software, the user experience is improved, and the user trouble is reduced. And index names are classified in advance during query, query sentences can be written for indexes of different classifications in advance to directly finish data extraction at one time in the subsequent verification process, the burden of technicians is reduced, and the verification work efficiency is improved.

Step 202, a first query statement for querying a reference index value is sent to a server;

the reference index values comprise a reference index value corresponding to each second index name and a reference index value corresponding to each third index name.

In one possible embodiment, when in an application scenario of invoking a query statement, before the sending the first query statement to the server for querying the reference index value, the method further comprises: acquiring key word information used for determining recommendation candidates in natural sentences input by a user, wherein the key word information comprises the following steps: a first object name and a first function statement in the natural statement; determining a preset number of candidate query sentences based on a historical query sentence set through the key word information; and displaying the query sentences with the preset number as recommendation candidates after the input box.

Optionally, the functional statement may include: one or more of selecting, conditioning, modifying, deleting, adding, inserting rows/columns, the object names may include: one or more of a data table name, a field name, a database name.

Optionally, before the determining the candidate query sentences with the preset number based on the historical query sentence set through the key word information, the method further includes; acquiring the at least one historical query statement; analyzing the at least one historical query statement to obtain at least one statement information corresponding to the at least one historical query statement one by one, wherein the statement information comprises a second object name and a second functional statement; storing the at least one historical query statement and the at least one statement information into a set of historical query statements.

Optionally, the determining the candidate query sentences with the preset number based on the historical query sentence set through the keyword information includes: judging whether the second functional statement of each historical query statement contains the first functional statement or not: if yes, determining the historical query statement as a related query statement; obtaining at least one association coefficient according to the second object name and the first object name of each related query statement, wherein the association coefficient is used for representing the association degree of the first object name and the second object name; determining the priority of the at least one related query statement according to the at least one association coefficient; and selecting a preset number as the candidate query statement according to the order of the priority from high to low.

It can be seen that, in this example, by obtaining the key word information in the natural sentence input by the user, and then determining the candidate query sentences with preset number in the historical query sentence set according to the key word information, these query sentences are displayed as recommended candidates after the input box. Thus, the repeated utilization of the historical query sentences can be realized, similar query sentences can be displayed for the testers to change, and the difficulty and burden of writing sentences by the testers are reduced. Meanwhile, only natural sentences are input, so that query sentences in the historical query sentence set can be called, and high-quality experience is brought to users who do not understand programming.

In a possible embodiment, the first query statement includes one or more calculation formulas corresponding to the at least one third index name one by one.

The index names are classified when the index names are stored in advance, so that a query statement can be written according to the classified second index names and third index names, when the server queries according to the query statement, the corresponding index values stored in the database are directly queried when the server queries the second index names, when the server queries the third index names, the corresponding intermediate parameters of the third index names in the database are queried first, and then the index values corresponding to the third index names are calculated according to the corresponding calculation formulas designed in the query statement in advance.

For example, the index names associated with the financial index analysis such business parameter have a rendering capability ratio, an asset management ratio, a property ratio, a profitability ratio, wherein the rendering capability ratio and the asset management ratio are the second index names, and the property ratio and the profitability ratio are the third index names. When a technician writes an SQL sentence, the title ratio = liability sum/stakeholder equity, profitability ratio = net profit/average net asset is written as an SQL sentence and stored in an SQL script. In this way, when the server queries according to the SQL statement, index values of the change capability ratio and the asset management ratio, and values of the liability sum, the equity, the net profit and the average net asset can be directly queried from the database, and then the index values of the property ratio and the profitability ratio are obtained by calculating according to the SQL statement written by the formula stored in the SQL script and the values of the intermediate parameters queried previously.

It can be seen that, in this example, a calculation formula corresponding to the third index name one-to-one is designed in the first query statement sent to the server, so that the server can directly complete the acquisition of the index value of the third index name according to the query statement. Therefore, the server can directly complete calculation work instead of a tester, so that an accurate reference index value is obtained, the workload of the tester and the possible calculation problems are reduced, and the efficiency and the accuracy of data verification are improved.

Step 203, receiving a reference index value sent by a server in response to the first query statement;

step 204, updating the index value of the at least one first index name according to the reference index value.

In a possible embodiment, the updating the index value of the at least one first index name according to the reference index value includes: judging whether the index value to be checked of each first index name is the same as the corresponding reference index value; if yes, keeping the index value of the currently processed first index name unchanged; if not, updating the index value of the first index name processed currently from the index value to be checked to the reference index value.

The index value to be checked displayed on the page needs to be checked because of the inaccuracy of the index value stored in the database due to the error of the automatic calculation of the page or the change of the data stored in the database, and the index value to be checked is obtained by checking the data obtained by searching the database or the server according to the corresponding formula.

In this example, the index value of the at least one first index name is updated according to the reference index value, so that the accuracy of the index value displayed on the page is guaranteed, the value acquired by the user through the page is the latest and most accurate, and the requirements of the user on the real-time property and the accuracy of the data can be met.

In one possible embodiment, after said updating the index value of said at least one first index name according to said reference index value, the method further comprises: storing the first query statement into a pre-created query statement set based on a multi-way tree model.

The root node of the multi-tree model corresponds to the target service requirement, the middle node of the multi-tree model corresponds to the service parameters, and the leaf nodes of the multi-tree model correspond to query sentences associated with the service parameters.

The multi-way tree model is used for establishing the query statement set, because the tree structure is used for establishing indexes to facilitate query data, and compared with the binary tree model, the multi-way tree model can store enough data, and meanwhile, the disk reading times can be reduced when the set is traversed, and the performance is enhanced. In addition, the multi-tree model is established according to the association relation between the target service requirement and a plurality of service parameters associated with the service requirement and the association relation between the service parameters and query sentences associated with the service parameters.

For example, referring to fig. 2b, fig. 2b is a schematic diagram of a query statement set based on a multi-tree model, where a root node corresponds to a financial analysis according to an embodiment of the present application. The intermediate nodes in the model are in one-to-one correspondence with a plurality of business parameters under financial analysis, namely company data, financial statement, financial index analysis and financial comprehensive analysis. The leaf nodes in the model respectively correspond to three leaf nodes under the intermediate node corresponding to one query statement such as a financial statement, namely a query statement A, a query statement B and a query statement C. Wherein the root node refers to the topmost node in the model, and no parent node exists. An intermediate node refers to a node other than the root node, and to which a node is connected below itself. Leaf nodes refer to nodes, i.e. ends, below which no node is connected anymore.

Optionally, when creating the query statement set, the root node is corresponding to the software according to the association relationship among the software, the service requirements, the service parameters and the query statements associated with the service parameters, the intermediate node of the first layer is corresponding to a plurality of service requirements under the software, the intermediate node of the second layer is corresponding to the service parameters, and the leaf node is corresponding to the query statements, so that under the condition of creating one query statement set, the query statements associated with all the service parameters under the software product can be stored.

Therefore, in the example, through the multi-tree model created according to the association relation, the storage and the calling of the query statement can be realized, the query statement written by the tester can be reused, and the workload of the tester is reduced.

In one possible embodiment, the storing the first query statement into a pre-created multi-tree model-based query statement set includes: determining a first intermediate node in the query statement set according to the first query statement; determining that query sentences corresponding to the leaf nodes with the same function as the first query sentences exist under the first intermediate node; judging whether the first query statement and the query statement with the same function are repeated or not: if yes, keeping the query statement with the same function unchanged; if not, replacing the query statement with the same function with the first query statement.

According to the using function of the query sentences and the function of the first query sentence, it is determined that the query sentences with the same function as the first query sentence already exist in the query sentences, and then only two situations can occur, namely that the query sentences are completely consistent with the first query sentences in format and content or have differences in format and content. If both query statements are completely repeated, it is not necessary to store the first query statement or to change the previously stored query statement, then the previously stored query statement is kept unchanged. If the two query sentences have differences, the previously stored query sentences are replaced by the first query sentence, so that the query sentences with the same function can be correspondingly updated under the condition that the data change or the test personnel simplify the query sentences.

For example, referring to fig. 2b, fig. 2b is a schematic diagram of a query statement set based on a multi-tree model according to an embodiment of the present application, and it is assumed that the function of the first query statement is to query all index names under the financial statement, and after the first query statement is compiled, it is stored in the query statement set. Firstly, the electronic equipment determines that the electronic equipment is a query statement for querying data under the financial statement according to the function of the electronic equipment, and then the query statement A, the query statement B and the query statement C are stored under the corresponding intermediate node of the query financial statement. Then the electronic device finds that the function of the query statement A is the same as that of the first query statement, and the function is used for querying all index names under the financial statement, judges whether the query statement A and the first query statement are repeated, if so, the first query statement is not required to be stored again, and if not, the first query statement is stored under the node corresponding to the query statement A.

It can be seen that in this example, in the case where there is the same function in the first query sentence as in the query sentences stored under the associated target parameter node, the replacement of the query sentence is selected or kept unchanged according to the result of judging whether or not they are repeated. Therefore, the stored query sentences can be ensured to be updated and changed in real time under the condition of aiming at the same function, and the problem of redundancy of the query sentences in the set is solved.

In one possible embodiment, after determining the first intermediate node according to the first query statement, the method further comprises: determining that no query statement corresponding to the leaf node with the same function as the first query statement exists under the first intermediate node; creating a new leaf node under the first intermediate node and storing the first query statement into the new leaf node.

Wherein if it is determined that there is no query statement under the same intermediate node that is functionally identical to the first query statement, a new leaf node is created under the intermediate node for storing the first query statement.

In this example, the new leaf node is created to store the first query sentence, so that the function of the query sentence stored in the query sentence set can be gradually improved, redundancy of the query sentence under the same function can not occur, and the practicability is improved.

It can be seen that, in the process schematic diagram of a data verification method provided in the embodiment of the present application in fig. 2a, at least one first index name associated with a pre-stored target service parameter and an index value to be verified of each first index name are obtained, then a first query statement for querying a reference index value is sent to a server, the reference index value sent from the server is received, and finally the index value of the at least one first index name is updated according to the reference index value. The embodiment of the application can realize the verification of the pre-stored data, can store the query statement to facilitate the subsequent verification work, solves the problems that the verification is inaccurate due to the fact that a tester manually calculates the numerical value and can complete the verification only by comparing and querying a plurality of data tables for a plurality of times, and can conveniently realize the verification of the data and increase the practicability of the used query statement.

Referring to fig. 3, fig. 3 is a flow chart of a data extraction method according to an embodiment of the present application, and provides a data extraction method applied to a server, the method includes the following steps:

Step 301, acquiring a first query statement sent by electronic equipment;

in one possible embodiment, before the acquiring the first query statement sent by the electronic device, the method further includes: receiving the second query statement sent by the electronic equipment; inquiring the database according to the second inquiry statement, and determining at least one second data table, wherein index names associated with the target service parameters are contained in index name fields in the at least one second data table; obtaining the original numerical value of the at least one first index name according to the at least one second data table; and sending the at least one first index name and the original numerical value of the at least one first index name to the electronic equipment.

The server responds to the second query statement, queries the database according to the query statement, determines at least one second data table, and can obtain all index names associated with the target service parameters.

It can be seen that, in this example, the server may query, in response to the second query statement sent from the electronic device, index names associated with the target service parameters from multiple tables in the database, and then query the index values corresponding to the index names obtained by the query. Therefore, the integrity of data extraction can be ensured, the index name and the original numerical value which are sent to the electronic equipment are obtained after traversing the database, and the index name or the original numerical value is not absent.

Step 302, inquiring the reference index value in response to the first inquiry statement;

in one possible embodiment, the querying the reference index value in response to the first query statement includes: inquiring a preset database according to the first inquiry statement, and determining at least one first data table, wherein the database comprises a plurality of data tables, the data tables comprise index name fields, index value fields and/or intermediate parameter fields, and the index name fields in the at least one first data table comprise the at least one second index name and the at least one third index name; obtaining a basic index value of each second index name and a basic reference value of the intermediate parameter of each third index name according to the at least one first data table; calculating each datum reference value through the at least one calculation formula in the first query statement to obtain a datum index value of the at least one third index name; summarizing the reference index value to obtain the reference index value.

In order to ensure the integrity of query data, the server determines at least one first data table containing index name fields, index value fields and/or intermediate parameter fields according to a first query statement sent by the electronic device, and obtains data corresponding to all index names according to the determined at least one first data table. The index value of the second index name can be obtained directly through inquiring the database, the index value of the third index name is obtained through calculation according to a preset formula and the value of an intermediate parameter, so that in data obtained through inquiring, the index value can be directly inquired for the second index name, the value of the intermediate parameter related to the third index name is required to be inquired for the third index name, and then the reference index name of the third index name is obtained through calculation according to the preset formula in an inquiring statement.

Therefore, in the example, the simplification of the query statement and the obtaining of the numerical values of different index names through the differentiated operation can be realized according to the classification of the index names, so that the server can quickly and accurately query and process the data at one time according to the first query statement, the reference index numerical value which we want to obtain finally is obtained, the efficiency and the accuracy of the checking work are improved, and the work difficulty degree of the testers and the burden of the server are reduced.

Step 303, sending the reference index value to the electronic device.

It can be seen that fig. 3 is a flow chart of a data extraction method according to an embodiment of the present application, where a first query statement sent by an electronic device is obtained, then a reference index value is queried in response to the first query statement, and finally the reference index value is sent to the electronic device. Therefore, the interactive operation of the electronic equipment can be realized, a tester can extract and process data by writing a query statement, the server can access the database only by carrying out one query, the burden on the database is reduced, and meanwhile, the accuracy of the data is ensured.

The following are embodiments of the apparatus of the present application, which are within the same concept as embodiments of the method of the present application, for performing the methods described in the embodiments of the present application. For convenience of explanation, the embodiments of the present application are only shown in the parts related to the embodiments of the present application, and specific technical details are not disclosed, please refer to the description of the embodiments of the present application method, which is not repeated here.

The data verification device provided by the embodiment of the application can be an electronic device, and is particularly used for executing the steps executed by the electronic device in the data verification method. The data verification device provided by the embodiment of the application can comprise modules corresponding to the corresponding steps.

The embodiment of the application can divide the functional modules of the data checking device according to the method example, for example, each functional module can be divided corresponding to each function, and two or more functions can be integrated in one processing module. The integrated modules can be realized in a hardware mode or a software functional module mode. The division of the modules in the embodiment of the application is schematic, only one logic function is divided, and other division modes can be adopted in actual implementation.

Fig. 4 is a functional unit block diagram of a data verification device according to an embodiment of the present application in the case where respective functional modules are divided by corresponding respective functions. As shown in fig. 4, the data verification apparatus 400 includes: an obtaining unit 401, configured to obtain at least one first index name associated with a pre-stored target service parameter and an index value to be verified of each first index name, where the at least one first index name includes at least one second index name and at least one third index name, the second index name is an index name of a corresponding value directly stored in a database of a server, the third index name is an index name of a corresponding value stored in a database of the server, and the index name of the corresponding value needs to be obtained by the electronic device according to a preset formula and the value of the intermediate parameter, and the target service parameter is any one of a plurality of service parameters required in a data analysis and calculation process for a target service requirement; a sending unit 402, configured to send, to the server, a first query statement for querying a reference index value, where the reference index value includes a reference index value corresponding to each second index name and a reference index value corresponding to each third index name; a receiving unit 403, configured to receive the reference index value from the server; an updating unit 404, configured to update the index value of the at least one first index name according to the reference index value.

In one possible embodiment, in terms of said sending the first query statement to the server, the sending unit 402 is specifically configured to: the first query sentence contains one or more calculation formulas corresponding to the at least one third index name one by one.

In one possible embodiment, in terms of the prestored index name and the corresponding value to be checked, the sending unit 402 is specifically configured to: sending a second query statement for querying an index name associated with a target service parameter and an original numerical value corresponding to the index name to the server, wherein the original numerical value comprises the original index numerical value corresponding to each index name associated with the target service parameter and an original parameter numerical value of an intermediate parameter stored in a database of the server; receiving the at least one first index name and the original value of the at least one first index name transmitted from the server; judging whether each first index name has the corresponding original index value or not: if yes, determining that the original index value of the first index name processed currently is the index value to be checked, and determining that the first index name processed currently is the second index name; if not, calculating according to the preset formula and the original parameter value of the first index name of the current process to obtain the index value to be checked, and determining that the first index name of the current process is the third index name; storing the at least one second index name and the at least one third index name, and the index value to be checked of the at least one second index name and the index value to be checked of the at least one third index name.

In a possible embodiment, in terms of updating the index value of the at least one first index name according to the reference index value, the updating unit 404 is specifically configured to: judging whether the index value to be checked of each first index name is the same as the corresponding reference index value; if yes, keeping the index value of the currently processed first index name unchanged; if not, updating the index value of the first index name processed currently from the index value to be checked to the reference index value.

In a possible embodiment, in terms of the stored query statement, the updating unit 404 is configured to: storing the first query statement to a query statement set which is created in advance and is based on a multi-way tree model, wherein a root node of the multi-way tree model corresponds to the target service requirement, an intermediate node of the multi-way tree model corresponds to the plurality of service parameters, and leaf nodes of the multi-way tree model correspond to the query statement associated with the service parameters.

In one possible embodiment, in the aspect of storing the first query term into a pre-created set of query terms based on a multi-tree model, the updating unit 404 is specifically configured to: determining a first intermediate node in the query statement set according to the first query statement; determining that query sentences corresponding to the leaf nodes with the same function as the first query sentences exist under the first intermediate node; judging whether the first query statement and the query statement with the same function are repeated or not: if yes, keeping the query statement with the same function unchanged; if not, replacing the query statement with the same function with the first query statement.

In one possible embodiment, in determining the first intermediate node according to the first query statement, the updating unit 404 is specifically configured to: determining that no query statement corresponding to the leaf node with the same function as the first query statement exists under the first intermediate node; creating a new leaf node under the first intermediate node and storing the first query statement into the new leaf node.

It can be seen that the data verification device provided by the embodiment of the application can obtain the index name and the corresponding index value to be verified, which are associated with the target service parameter and are stored in advance, and then the reference index value obtained by responding to the query statement from the server is received for verification of the index value by sending the first query statement to the server. Therefore, the method can be realized, the server can complete the extraction of index values of two types of index names at one time through the query statement, and the data verification is completed according to the extracted data. Compared with the traditional verification method, the verification method greatly improves the verification efficiency, eliminates the possibility of calculation and comparison errors caused by manpower, and the transmitted query statement can be stored for repeated use, so that the method has certain practicability.

The embodiment of the application also provides a data extraction device which can be a server. Specifically, the data extraction device is configured to perform the steps performed by the server in the above data extraction method. The data extraction device provided by the embodiment of the application can comprise modules corresponding to the corresponding steps.

The embodiment of the application can divide the functional modules of the data extraction device according to the method example, for example, each functional module can be divided corresponding to each function, or two or more functions can be integrated in one processing module. The integrated modules can be realized in a hardware mode or a software functional module mode. The division of the modules in the embodiment of the application is schematic, only one logic function is divided, and other division modes can be adopted in actual implementation.

Fig. 5 is a block diagram showing the functional units of a data extraction device according to an embodiment of the present application in the case where respective functional modules are divided corresponding to respective functions. As shown in fig. 5, the data extraction device 500 includes: an obtaining unit 501, configured to obtain the first query sentence from the electronic device; a processing unit 502, configured to query the database according to the first query statement to obtain the reference index value; a transmitting unit 503, configured to transmit the reference index value to the electronic device.

In one possible embodiment, in the aspect of querying the reference index value in response to the first query statement, the processing unit 502 is specifically configured to: inquiring a preset database according to the first inquiry statement, and determining at least one first data table, wherein the database comprises a plurality of data tables, the data tables comprise index name fields, index value fields and/or intermediate parameter fields, and the index name fields in the at least one first data table comprise the at least one second index name and the at least one third index name; obtaining a basic index value of each second index name and a basic reference value of the intermediate parameter of each third index name according to the at least one first data table; calculating each datum reference value through the at least one calculation formula in the first query statement to obtain a datum index value of the at least one third index name; summarizing the reference index value to obtain the reference index value.

In one possible embodiment, in querying the original value in response to the second query statement, the processing unit 502 is specifically configured to: receiving the second query statement sent by the electronic equipment; inquiring the database according to the second inquiry statement, and determining at least one second data table, wherein index names associated with the target service parameters are contained in index name fields in the at least one second data table; obtaining the original numerical value of the at least one first index name according to the at least one second data table; and sending the at least one first index name and the original numerical value of the at least one first index name to the electronic equipment.

It can be seen that, according to the data extraction device provided by the embodiment of the application, the query statement from the electronic device is obtained and executed, and then the reference index value obtained after the data extraction processing is sent back to the electronic device. Therefore, the interaction with the electronic equipment device can be realized, the extraction and the processing of the data can be completed according to the query statement sent by the electronic equipment, the data required by the data verification work obtained by the electronic equipment is ensured, and the data is obtained by querying a database according to the query statement and processing the data by a server. Therefore, the extracted data can be ensured to be complete and accurate, and the data verification work can be smoothly and normally implemented.

It should be noted that the small game installation package processing device described in the embodiment of the present device is presented in the form of a functional unit. The term "unit" as used herein should be understood in the broadest possible sense, and the objects used to implement the functions described by the various "units" may be, for example, an integrated circuit ASIC, a single circuit, a processor (shared, dedicated, or group) and memory that execute one or more software or firmware programs, a combinational logic circuit, and/or other suitable components that provide the described functionality.

In the case of using an integrated unit, as shown in fig. 6, fig. 6 is a block diagram of a data verification device according to an embodiment of the present application. In fig. 6, the data verification apparatus 600 includes: a processing module 602 and a communication module 601. The processing module 602 is configured to control and manage actions of the data verification device, e.g., the steps of the acquisition unit 401, the transmission unit 402, the reception unit 403, and the update unit 404, and/or other processes for performing the techniques described herein. The communication module 601 is used for supporting interaction between the data verification starting device and other devices. As shown in fig. 6, the data verification device may further include a storage module 603, where the storage module 603 is configured to store program codes and data of the data verification device.

The processing module 602 may be a processor or controller, such as a central processing unit (Central Processing Unit, CPU), general purpose processor, digital signal processor (Digital Signal Processor, DSP), ASIC, FPGA or other programmable logic device, transistor logic device, hardware components, or any combination thereof. Which may implement or perform the various exemplary logic blocks, modules and circuits described in connection with this disclosure. The processor may also be a combination that performs the function of a computation, e.g., a combination comprising one or more microprocessors, a combination of a DSP and a microprocessor, and the like. The communication module 601 may be a transceiver, an RF circuit, a communication interface, or the like. The memory module 603 may be a memory.

In the case of using an integrated unit, as shown in fig. 7, fig. 7 is a block diagram of a data extraction apparatus according to an embodiment of the present application. In fig. 7, the data extraction apparatus 700 includes: a processing module 702 and a communication module 701. The processing module 702 is used to control and manage the actions of the data extraction device, e.g., the steps of the acquisition unit 501, the processing unit 502, and the sending unit 503, and/or other processes for performing the techniques described herein. The communication module 701 is used to support interactions between the data extraction apparatus and other devices. As shown in fig. 7, the data extraction device may further include a storage module 703, where the storage module 703 is configured to store program codes and data of the data extraction device.

The processing module 702 may be a processor or controller, such as a central processing unit (Central Processing Unit, CPU), general purpose processor, digital signal processor (Digital Signal Processor, DSP), ASIC, FPGA or other programmable logic device, transistor logic device, hardware components, or any combination thereof. Which may implement or perform the various exemplary logic blocks, modules and circuits described in connection with this disclosure. The processor may also be a combination that performs the function of a computation, e.g., a combination comprising one or more microprocessors, a combination of a DSP and a microprocessor, and the like. The communication module 701 may be a transceiver, an RF circuit, or a communication interface, etc. The memory module 703 may be a memory.

The above embodiments may be implemented in whole or in part by software, hardware, firmware, or any other combination. When implemented in software, the above-described embodiments may be implemented in whole or in part in the form of a computer program product. The computer program product comprises one or more computer instructions or computer programs. When the computer instructions or computer program are loaded or executed on a computer, the processes or functions described in accordance with embodiments of the present application are produced in whole or in part. The computer may be a general purpose computer, a special purpose computer, a computer network, or other programmable apparatus. The computer instructions may be stored in a computer-readable storage medium or transmitted from one computer-readable storage medium to another computer-readable storage medium, for example, the computer instructions may be transmitted from one website site, computer, server, or data center to another website site, computer, server, or data center by wired or wireless means. The computer readable storage medium may be any available medium that can be accessed by a computer or a data storage device such as a server, data center, etc. that contains one or more sets of available media. The usable medium may be a magnetic medium (e.g., floppy disk, hard disk, magnetic tape), an optical medium (e.g., DVD), or a semiconductor medium. The semiconductor medium may be a solid state disk.

The embodiment of the application also provides a computer storage medium, wherein the computer storage medium stores a computer program for electronic data exchange, and the computer program makes a computer execute part or all of the steps of any one of the above method embodiments, and the computer includes an electronic device.

Embodiments of the present application also provide a computer program product comprising a non-transitory computer-readable storage medium storing a computer program operable to cause a computer to perform part or all of the steps of any one of the methods described in the method embodiments above. The computer program product may be a software installation package, said computer comprising an electronic device.

It should be understood that, in various embodiments of the present application, the sequence numbers of the foregoing processes do not mean the order of execution, and the order of execution of the processes should be determined by the functions and internal logic thereof, and should not constitute any limitation on the implementation process of the embodiments of the present application.

In the several embodiments provided in the present application, it should be understood that the disclosed method, apparatus and system may be implemented in other manners. For example, the device embodiments described above are merely illustrative; for example, the division of the units is only one logic function division, and other division modes can be adopted in actual implementation; for example, multiple units or components may be combined or may be integrated into another system, or some features may be omitted, or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices or units, which may be in electrical, mechanical or other form.

The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

In addition, each functional unit in the embodiments of the present invention may be integrated in one processing unit, or each unit may be physically included separately, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in hardware plus software functional units.

The integrated units implemented in the form of software functional units described above may be stored in a computer readable storage medium. The software functional unit is stored in a storage medium, and includes several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (Random Access Memory, RAM), a magnetic disk, or an optical disk, or other various media capable of storing program codes.

Although the present invention is disclosed above, the present invention is not limited thereto. Variations and modifications, including combinations of the different functions and implementation steps, as well as embodiments of the software and hardware, may be readily apparent to those skilled in the art without departing from the spirit and scope of the invention.

Claims

1. A data verification method, applied to an electronic device, the method comprising:

2. The method of claim 1, wherein updating the index value of the at least one first index name based on the reference index value comprises:

judging whether the index value to be checked of each first index name is the same as the corresponding reference index value;

if yes, keeping the index value of the currently processed first index name unchanged;

if not, updating the index value of the first index name processed currently from the index value to be checked to the reference index value.

3. The method according to claim 1 or 2, wherein before said obtaining at least one first indicator name associated with a pre-stored target service parameter and the indicator value to be verified for each of said first indicator names, the method further comprises:

Sending a second query statement for querying an index name associated with a target service parameter and an original numerical value corresponding to the index name to the server, wherein the original numerical value comprises the original index numerical value corresponding to each index name associated with the target service parameter and an original parameter numerical value of an intermediate parameter stored in a database of the server;

receiving the at least one first index name and the original value of the at least one first index name transmitted from the server;

judging whether each first index name has the corresponding original index value or not:

if yes, determining that the original index value of the first index name processed currently is the index value to be checked, and determining that the first index name processed currently is the second index name;

if not, calculating according to the preset formula and the original parameter value of the first index name of the current process to obtain the index value to be checked, and determining that the first index name of the current process is the third index name;

storing the at least one second index name and the at least one third index name, and the index value to be checked of the at least one second index name and the index value to be checked of the at least one third index name.

4. The method of claim 1, wherein the first query statement includes one or more calculation formulas that are in one-to-one correspondence with the at least one third index name.

5. The method of claim 1, wherein after said updating the index value of the at least one first index name from the reference index value, the method further comprises:

storing the first query statement to a query statement set which is created in advance and is based on a multi-way tree model, wherein a root node of the multi-way tree model corresponds to the target service requirement, an intermediate node of the multi-way tree model corresponds to the plurality of service parameters, and leaf nodes of the multi-way tree model correspond to the query statement associated with the service parameters.

6. The method of claim 5, wherein the storing the first query statement into a pre-created set of multi-tree model-based query statements comprises:

determining a first intermediate node in the query statement set according to the first query statement;

determining that query sentences corresponding to the leaf nodes with the same function as the first query sentences exist under the first intermediate node;

Judging whether the first query statement and the query statement with the same function are repeated or not:

if yes, keeping the query statement with the same function unchanged;

if not, replacing the query statement with the same function with the first query statement.

7. The method of claim 6, wherein after determining a first intermediate node in the set of query statements from the first query statement, the method further comprises:

determining that no query statement corresponding to the leaf node with the same function as the first query statement exists under the first intermediate node;

creating a new leaf node under the first intermediate node and storing the first query statement into the new leaf node.

8. A data extraction method, applied to a server, the method comprising:

acquiring the first query statement sent by the electronic equipment;

querying the reference index value in response to the first query statement;

and sending the reference index value to the electronic equipment.

9. The method of claim 8, wherein querying the reference index value in response to the first query statement comprises:

Inquiring a preset database according to the first inquiry statement, and determining at least one first data table, wherein the database comprises a plurality of data tables, the data tables comprise index name fields, index value fields and/or intermediate parameter fields, and the index name fields in the at least one first data table comprise the at least one second index name and the at least one third index name;

obtaining a basic index value of each second index name and a basic reference value of the intermediate parameter of each third index name according to the at least one first data table;

calculating each datum reference value through the at least one calculation formula in the first query statement to obtain a datum index value of the at least one third index name;

summarizing the reference index value to obtain the reference index value.

10. The method of claim 8, wherein prior to the retrieving the first query statement sent by the electronic device, the method further comprises:

receiving the second query statement sent by the electronic equipment;

inquiring the database according to the second inquiry statement, and determining at least one second data table, wherein index names associated with the target service parameters are contained in index name fields in the at least one second data table;

Obtaining the original numerical value of the at least one first index name according to the at least one second data table;

and sending the at least one first index name and the original numerical value of the at least one first index name to the electronic equipment.

11. A data verification apparatus for use with an electronic device, the apparatus comprising:

a receiving unit: for receiving the reference index value from the server;

12. A data extraction apparatus for use with a server, the apparatus comprising:

13. An electronic device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the processor implements the steps of the method according to any of claims 1-7 when the computer program is executed.

14. A server comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the processor implements the steps of the method according to any of claims 8-10 when the computer program is executed.

15. A computer readable storage medium storing a computer program, characterized in that the computer program when executed by a processor implements the steps of the method according to any one of claims 1-7 or 8-10.