CA3130318A1

CA3130318A1 - Data acquisition demand processing method and device, computer equipment and storage medium

Info

Publication number: CA3130318A1
Application number: CA3130318A
Authority: CA
Inventors: Xinjian Li; Lei Xu
Original assignee: 10353744 Canada Ltd
Current assignee: 10353744 Canada Ltd
Priority date: 2020-09-09
Filing date: 2021-09-09
Publication date: 2022-03-09
Also published as: CN112069223B; CN112069223A

Abstract

The present application relates to the field of computers, and particularly to a method of and a device for processing a data acquisition request, a computer equipment and a storage medium.
The method comprises: determining a data acquisition request to be currently processed in response to a preset trigger instruction; obtaining request configuration information to which the data acquisition request corresponds; obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information; and performing correlation processing on the primary data to obtain target data that satisfies the data acquisition request.
Embodiments of the present invention enable realization of correlated downloading of cross-library and divided-sheet data, and satisfy the requirement of operating personnel to temporarily download data without having to specifically develop any downloading function.

Description

DATA ACQUISITION DEMAND PROCESSING METHOD AND DEVICE, COMPUTER EQUIPMENT AND STORAGE MEDIUM
BACKGROUND OF THE INVENTION
Technical Field [0001] The present application relates to the field of computers, and more particularly to a method of and a device for processing a data acquisition request, a computer equipment and a storage medium.
Description of Related Art

[0002] Supply chain management is the kernel of business administration no matter for sales enterprises or for the traditional manufacturing industry. With the development of information technology, the relevant information system of supply chain management is also being incessantly perfected, it now quickens the digitalization of such information as relevant to sales, purchases and inventories, breaks the restriction of information islands brought about by fine division of labors of enterprises, provides effective support for routine operation and management of enterprises, and is therefore more and more emphasized by various large-scale enterprises. More and more attention is being paid to data awareness by operating personnel, and irregular derivation of some data for analysis has also become a routine work for the related personnel. However, such nonstandard derivation requests often involve cross-library and cross-sheet correlation of data, the mode of deriving via the database cannot meet the requirement of data derivation, while the dedicated development of corresponding downloading functions for the temporary requirement of business is defective in not being able to timely respond to the business requirement, not to mention the fact that such downloading functions are very rarely used, thereby also causing waste of resources.
SUMMARY OF THE INVENTION

[0003] In view of the defects prevailing in the state of the art, the present invention provides a Date recue / Date received 202 1-1 1-09 method of and a device for processing a data acquisition request, a computer equipment and a storage medium, and embodiments of the present invention enable realization of correlated downloading of cross-library and divided-sheet data, and satisfy the requirement of operating personnel to temporarily download data without having to specifically develop any downloading function.

[0004] According to the first aspect of the present invention, there is provided a method of processing a data acquisition request, and the method comprises, in one embodiment:

[0005] determining a data acquisition request to be currently processed in response to a preset trigger instruction;

[0006] obtaining request configuration information to which the data acquisition request corresponds;

[0007] obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information; and

[0008] performing correlation processing on the primary data to obtain target data that satisfies the data acquisition request.

[0009] In one embodiment, the request configuration information includes main query configuration information and at least one piece of sub-query configuration information, and the step of obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information includes:

[0010] enquiring and obtaining, on the basis of the main query configuration information, primary data from a target datasheet corresponding to the main query configuration information;

[0011] determining a query order and a target datasheet to which each query configuration information in the at least one piece of sub-query configuration information corresponds;
and

[0012] enquiring and obtaining, according to the query order and sequentially on the basis of the sub-query configuration information to which each query order corresponds, primary Date recue / Date received 202 1-1 1-09 data to which the sub-query configuration information corresponds from the target datasheet corresponding thereto.

[0013] In one embodiment, each sub-query configuration information includes query field configuration and correlation field configuration, and, while enquiring and obtaining, on the basis of the sub-query configuration information to which any query order corresponds, primary data to which the sub-query configuration information corresponds from the target datasheet corresponding thereto, the method comprises:

[0014] obtaining, on the basis of the correlation field configuration in the sub-query configuration information to which any query order corresponds, correlation field information from the primary data correlated with the sub-query configuration information to which any query order corresponds, wherein the primary data correlated with the sub-query configuration information with the first query order is primary data to which the main query configuration information corresponds, and the primary data correlated with any sub-query configuration information whose query order is not the first is primary data to which the sub-query configuration information previous in query order to the any sub-query configuration information corresponds; and

[0015] obtaining, on the basis of the correlation field information and the query field configuration in the sub-query configuration information to which the any query order corresponds, primary data from the target datasheet to which the any query order corresponds.

[0016] In one embodiment, the step of obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information includes:

[0017] performing risk inspection on the request configuration information;
and

[0018] obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information after confirming that the request configuration information has passed the risk inspection.

Date recue / Date received 202 1-1 1-09

[0019] In one embodiment, the method further comprises, after the step of performing correlation processing on the primary data to obtain correlated data to which the data acquisition request corresponds:

[0020] writing the correlated data in a file server; and

[0021] updating a file address to which the correlated data in the file server corresponds into a download task table.

[0022] According to the second aspect of the present invention, there is provided a device for processing a data acquisition request, and the method comprises, in one embodiment:

[0023] a request determining module, for determining a data acquisition request to be currently processed in response to a preset trigger instruction;

[0024] a request configuration obtaining module, for obtaining request configuration information to which the data acquisition request corresponds;

[0025] a primary data obtaining module, for obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information;
and

[0026] a correlation processing module, for performing correlation processing on the primary data to obtain target data that satisfies the data acquisition request.

[0027] In one embodiment, the request configuration information includes main query configuration information and at least one piece of sub-query configuration information, and the primary data obtaining module includes:

[0028] a first data obtaining sub-module, for enquiring and obtaining, on the basis of the main query configuration information, primary data from a target datasheet corresponding to the main query configuration information;

[0029] a determining sub-module, for determining a query order and a target datasheet to which each query configuration information in the at least one piece of sub-query configuration information corresponds; and

[0030] a second data obtaining sub-module, for enquiring and obtaining, according to the query order and sequentially on the basis of the sub-query configuration information to which Date recue / Date received 202 1-1 1-09 each query order corresponds, primary data to which the sub-query configuration information corresponds from the target datasheet corresponding thereto.

[0031] In one embodiment, each sub-query configuration information includes query field configuration and correlation field configuration, and the second data obtaining sub-module includes:

[0032] a correlation field information obtaining unit, for obtaining, on the basis of the correlation field configuration in the sub-query configuration information to which any query order corresponds, correlation field information from the primary data correlated with the sub-query configuration information to which any query order corresponds, wherein the primary data correlated with the sub-query configuration information with the first query order is primary data to which the main query configuration information corresponds, and the primary data correlated with any sub-query configuration information whose query order is not the first is primary data to which the sub-query configuration information previous in query order to the any sub-query configuration information corresponds; and

[0033] a primary data obtaining unit, for obtaining, on the basis of the correlation field information and the query field configuration in the sub-query configuration information to which the any query order corresponds, primary data from the target datasheet to which the any query order corresponds.

[0034] According to the third aspect of the present invention, there is provided a computer equipment that comprises a memory, a processor and a computer program stored on the memory and executable on the processor, and the method steps according to anyone of the aforementioned embodiments are realized when the processor executes the computer program.

[0035] According to the fourth aspect of the present invention, there is provided a computer-readable storage medium storing a computer program thereon, and the method steps Date recue / Date received 202 1-1 1-09 according to anyone of the aforementioned embodiments are realized when the computer program is executed by a processor.

[0036] In the aforementioned embodiments of the present invention, by determining a data acquisition request to be currently processed in response to a preset trigger instruction, obtaining request configuration information to which the data acquisition request corresponds, obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information, and performing correlation processing on the primary data to obtain target data that satisfies the data acquisition request, it is made possible to realize correlated downloading of cross-library and divided-sheet data, and satisfy the requirement of operating personnel to temporarily download data without having to specifically develop any downloading function.

[0037] BRIEF DESCRIPTION OF THE DRAWINGS

[0038] Fig. 1 is a flowchart schematically illustrating a method of processing a data acquisition request in an embodiment;

[0039] Fig. 2 is a flowchart schematically illustrating a step of obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information in an embodiment;

[0040] Fig. 3 is a block diagram illustrating the structure of a device for processing a data acquisition request in an embodiment; and

[0041] Fig. 4 is a view illustrating the internal structure of a computer equipment in an embodiment.

[0042] DETAILED DESCRIPTION OF THE INVENTION

Date recue / Date received 202 1-1 1-09

[0043] To make more lucid and clear the objectives, technical solutions and advantages of the present application, the present application is described in greater detail below with reference to the accompanying drawings and embodiments. As should be understood, the specific embodiments as described here are merely meant to explain the present application, rather than to restrict the present application.

[0044] The present invention provides a method of processing a data acquisition request, in one embodiment as shown in Fig. 1, the method comprises the following steps.

[0045] S110 - determining a data acquisition request to be currently processed in response to a preset trigger instruction.

[0046] In this embodiment, the method of processing a data acquisition request can be realized by a server (hereinafter referred to as "processing server") for processing data acquisition requests, and the processing server can be embodied as an independent server or a cluster system consisting of a plurality of servers. Further, a timed task can be preset in the processing server to trigger the processing logic of this method of processing a data acquisition request, and the preset trigger instruction in this embodiment is a trigger instruction of the timed task. When it is needed to acquire business data, the operating personnel configures request configuration information through a predefined data acquisition request configuring rule, and submits the information to the processing server, and the processing server determines the data acquisition request to be processed when this time task is triggered. In another embodiment, the preset trigger instruction can indicate a data downloading instruction issued by the operating personnel to the processing server.
After configuring the request configuration information, the operating personnel submits the request configuration information to the processing server, and issues thereto a data downloading instruction; on receiving the data downloading instruction, the processing server bases on the data downloading instruction to determine the data acquisition request to be currently processed. Different data acquisition requests can be distinguished from one Date recue / Date received 202 1-1 1-09 another via unique request identifications, and each request configuration information corresponds to one request identification.

[0047] S1120 - obtaining request configuration information to which the data acquisition request corresponds.

[0048] In this embodiment, after determining the data acquisition request to be currently processed, the processing server obtains request configuration information to which the data acquisition request corresponds. The request configuration information includes main query configuration information for obtaining relevant data from a main sheet and at least one piece of sub-query configuration information for obtaining relevant data from a sub-sheet.

[0049] S130 - obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration infollnation.

[0050] In this embodiment, the data to be downloaded by the operating personnel would be dispersedly stored in different datasheets, and it usually involves cross-library and cross-sheet correlation of query data when the operating personnel processes such nonstandard data derivation requests, so it is required, after obtaining the request configuration information, for the processing server to obtain primary data from various relevant datasheets (namely the relevant main sheet and sub-sheet) on the basis of the request configuration information. Specifically, the processing server automatically generates an SQL statement on the basis of the request configuration information, and enquires and obtains the primary data from corresponding datasheets through the SQL
statement.

[0051] In one embodiment, the step of obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information includes:

[0052] performing risk inspection on the request configuration information;
and Date recue / Date received 202 1-1 1-09

[0053] obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information after confirming that the request configuration information has passed the risk inspection.

[0054] Specifically, the processing server performs risk inspection on the request configuration information to inspect whether the SQL statement generated on the basis of the request configuration information is a high-risk SQL statement (for example, by inspecting whether the SQL statement contains any preset sensitive field), if yes, the subsequent operation would not be executed to ensure safety of the operation.

[0055] S140 - performing correlation processing on the primary data to obtain target data that satisfies the data acquisition request.

[0056] In this embodiment, after obtaining primary data dispersedly stored in a plurality of datasheets, the processing server performs correlation processing on the primary data obtained from the various relevant datasheets according to the request configuration information, so as to obtain data (namely target data) that satisfies the data acquisition request of the operating personnel. The primary data is data obtained from various datasheets according to the request configuration information.

[0057] In this embodiment, by determining a data acquisition request to be currently processed in response to a preset trigger instruction, thereafter obtaining request configuration information to which the data acquisition request corresponds, firstly obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information, and then performing correlation processing on the primary data to obtain target data that satisfies the data acquisition request, it is made possible to solve the problem of being not able to perform correlated downloading of cross-library and divided-sheet data under the conventional general function, whenever there is a data acquisition request, it is merely required for the operating personnel to configure the corresponding request Date recue / Date received 202 1-1 1-09 configuration information on the basis of the specific request, then the processing server automatically generates an SQL statement on the basis of the request configuration information, and enquires and obtains the corresponding data through the generated SQL
statement, whereby it is not required for the operating personnel to compile the SQL
statement each time when it is needed to obtain data, thus reducing workload of the operating personnel; in addition, management of the derived data acquisition request by the mode of configuration is not only directed to single business, but such configuration also meets all data acquisition requests of the operating personnel under not very special circumstances, and timely meets the temporary data acquisition request of the operating personnel in comparison with the conventional mode of developing a downloading function again. Further, the operating personnel can self-define the data derivation time, so that the processing server can process the data acquisition request at a time that is intentionally avoided from the business peak, thereby greatly reducing machine pressure;
moreover, the operating personnel can set a logic that periodically derives the data according to practical data derivation requests, or periodically enquires data through timed tasks.

[0058] In one embodiment, the method comprises, after the step of performing correlation processing on the primary data to obtain correlated data to which the data acquisition request corresponds:

[0059] writing the correlated data in a file server; and

[0060] updating a file address to which the correlated data in the file server corresponds into a download task table.

[0061] Specifically, the processing server writes the correlated data obtained through the correlation processing in a file server, and updates the file address of the correlated data into a download task table at the same time, so that the operating personnel can download the correlated data from the download task table.
Date recue / Date received 202 1-1 1-09

[0062] In one embodiment as shown in Fig. 2, step S130 - obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information includes:

[0063] S131 - enquiring and obtaining, on the basis of main query configuration information, primary data from the target datasheet corresponding to the main query configuration information.

[0064] In this embodiment, the request configuration information includes main query configuration information and at least one piece of sub-query configuration information.

[0065] In this embodiment, the main query configuration information includes at least one of such configuration fields required to be configured by the operating personnel as main sheet name, primary key name, query field, query condition, number of pages, and execution period.

[0066] Exemplarily, functions or explanations of the configuration fields in the various main query configuration information are as shown in the following Table 1.

[0067] Table 1:
Configuration Fields Remarks Main Sheet Name deriving data with the data of this sheet as the main body Primary Key Name sequencing with this field, while avoiding the problem of in-depth query Query Field field of the main business sheet required by the business Query Condition filter condition of the main sheet satisfying business requirement Number of Pages divided-sheet enquiring and downloading Date recue / Date received 202 1-1 1-09 required for large data size Execution Period supporting timed and periodic downloading

[0068] In one embodiment, each sub-query configuration information in the at least one piece of sub-query configuration information includes query field configuration and correlation field configuration. The query field configuration includes such configuration fields as sub-sheet name and query condition, and the correlation field configuration includes correlation field name.

[0069] Exemplarily, functions or explanations of the configuration fields in any sub-query configuration information are as shown in the following Table 2.

[0070] Table 2:
Configuration Fields Remarks Sub-sheet Name sheet in which the remaining fields as required locate besides the main sheet Correlation Field Name correlation condition of the main sheet and sub-sheet that may support plurality of such Query Condition data filter condition of the sub-sheet that can be nil (i.e., not to configure)

[0071] After obtaining the request configuration information, the processing server obtains the main query configuration information in the request configuration information, automatically generates an SQL statement of the main sheet on the basis of the main query configuration information, and enquires and obtains the primary data from the main sheet through the generated SQL statement.

Date recue / Date received 202 1-1 1-09

[0072] S132 - determining a query order and a target datasheet to which each query configuration information in the at least one piece of sub-query configuration information corresponds.

[0073] In this embodiment, after obtaining the request configuration information, the processing server determines the number of sub-query configuration infolination included in the request configuration information, and determines a query order and a target datasheet (namely each sub-sheet) to which each sub-query configuration information corresponds.

[0074] S133 - enquiring and obtaining, according to the query order and sequentially on the basis of the sub-query configuration information to which each query order corresponds, primary data to which the sub-query configuration information corresponds from the target datasheet corresponding thereto.

[0075] In this embodiment, the processing server automatically generates the SQL statement of each sub-sheet, and enquires each sub-sheet through the SQL statement to which each sub-sheet corresponds, to obtain the corresponding primary data from each sub-sheet.

[0076] As should be noted, because there is correlation between the sheets, when the processing server obtains the primary data from each sub-sheet according to the query order, it bases on the sub-query configuration information to which the current query order corresponds to obtain correlation field information from the primary data to which the previous query order corresponds, then bases on the correlation field information to obtain the corresponding SQL statement, and then bases on the SQL statement to obtain the primary data from the sub-sheet to which the current query order corresponds.

[0077] In one embodiment, while enquiring and obtaining, on the basis of the sub-query Date recue / Date received 202 1-1 1-09 configuration information to which any query order corresponds, primary data to which the sub-query configuration information corresponds from the target datasheet corresponding thereto, the processing process includes the following steps:

[0078] obtaining, on the basis of the correlation field configuration in the sub-query configuration information to which any query order corresponds, correlation field information from the primary data correlated with the sub-query configuration information to which the any query order corresponds, wherein the primary data correlated with the sub-query configuration information with the first query order is primary data to which the main query configuration information corresponds, and the primary data correlated with any sub-query configuration information whose query order is not the first is primary data to which the sub-query configuration information previous in query order to the any sub-query configuration information corresponds; and

[0079] obtaining, on the basis of the correlation field information and the query field configuration in the sub-query configuration information to which the any query order corresponds, primary data from the target datasheet to which the any query order corresponds.

[0080] In this embodiment, while obtaining primary data from each sub-sheet according to the query order, the processing server bases on the correlation field configuration in the sub-query configuration information to which the current query order corresponds to obtain correlation field information from the primary data to which the previous query order corresponds, then bases on the correlation field information to obtain the corresponding SQL statement, and finally obtains the primary data from the sub-sheet to which the current query order corresponds through the SQL statement.

[0081] An example is taken below to explain how the processing server obtains primary data dispersedly stored in a plurality of datasheets on the basis of the request configuration information.

Date recue / Date received 202 1-1 1-09

[0082] Suppose that a certain data acquisition request is to derive order related data of a supplier 10001011 after the creation time of 2020-01-01, the fields that should be derived are as shown in Table 3.

[0083] Table 3:
Ltable_po (order table, modular po code (order table order code) library storage with order supplier (order table supplier code) number): potime (order table creation time) 2.table_poitem (order item table, p0 _item (order item table order item modular library storage with order number) item number): productcode (order item table product code) plant (order item table plant code) qty (order item table order quantity) price (order item table price) 3.table deliveryitem (delivery delycode (delivery order code) order table, modular library delycodeitem (delivery order item number) storage with delivery order delytime (delivery time) number): delyqty (delivery quantity) reveivecode (receipt order code) reveivetime (receipt time) reveiveqty (receipt quantity) 4.table reveiveitem (receipt order reveivecode (receipt order code) table, modular library storage reveivetime (receipt time) with receipt order number): reveiveqty (receipt quantity)

[0084] The request configuration information configured by the operating personnel for the data acquisition request is as shown in the following Tables, of which Table 4 shows the Date recue / Date received 202 1-1 1-09 main query configuration information, and Tables 5 and 6 respectively show sub-query configuration information 1 and sub-query configuration information 2.

[0085] Table 4:
Configuration Fields Field Information Main Sheet Name table_po (order table) Primary Key po id Query Field po code (order table order code) supplier (order table supplier code) potime (order table creation time) p0 _item (order item table order item number) productcode (order item table product code) plant (order item table plant code) qty (order item table order quantity) price (order item table price) Query Condition supplier=10001011 potime>=2020-01-01 Number of Pages 200 Execution Period periodically-01:00 (i.e., 1 o'clock every morning)

[0086] Table 5:
Configuration Fields Field Information Sub-sheet Name table deliveryitem (delivery order table) Query Field delycode (delivery order code) Date recue / Date received 202 1-1 1-09 delycodeitem (delivery order item number) delytime (delivery time) Correlation Field po code (order table order code) p0 _item (order item table order item number) Query Condition nil

[0087] Table 6:
Configuration Fields Field Information Sub-sheet Name table reveiveitem (receipt order table) Query Field reveivecode (receipt order code) reveivetime (receipt time) reveiveqty (receipt quantity) Correlation Field delycode (delivery order code) delycodeitem (delivery order item number) Query Condition nil

[0088] The processing server bases on the aforementioned request configuration information to obtain the relevant primary data with the operation logic described below.

[0089] The processing server first bases on the field information to which two configuration fields, namely order table supplier code (supplier) and order table creation time (potime), correspond to enquire the order table (table_po) and the order item table (table_poitem) to obtain a collection of results pre result (including 200 piece of main sheet data).
Specifically, the contents obtained via the query include not only the business fields (such Date recue / Date received 202 1-1 1-09 configuration fields as productcode, plant, qty, and price) but also the field information of the three configuration fields, namely order table order code (po code), order item table order item number (p0 item), and order table primary key (po id), in which the order table primary key (p0 _id) is used to avoid in-depth query in the case of very large data size of the order table and to lessen memory load, and the two configuration fields, namely order table order code (po code) and order item table order item number (p0 item), are used to enquire cross-library delivery order data.

[0090] Query orders of the two sub-sheets, namely the delivery order table and the receipt order table, are so ordered that the delivery order table is enquired before the receipt order table is enquired. After enquiring and obtaining 200 pieces of main sheet data through the main query configuration information in Table 4, the processing server cyclically extracts from the row data of the above collection of results pre result the correlation field configuration in the sub-query configuration information to which the current query order corresponds, namely the field information (namely partial correlation data) to which the correlation fields --- order table order code (po code) and order item table order item number (p0 _item) --- in Table 5 correspond, takes the field information to which the obtained order table order code (po code) and order item table order item number (p0 _item) correspond as parameters to replace the two values of $pocode and $po item in the SQL statement generated on the basis of Table 5 to obtain a new SQL statement, and thereafter executes the new SQL
statement to enquire and obtain partial primary data from the delivery order table, by which time it is required to combine the partial primary data obtained via the query with the row data of pre result to which the process currently circulates, the next cycle is continuously performed after the combining operation, and a new collection of results deal result1 (the number of data of this collection of results might be greater than that of the collection of results pre result) can be obtained when the cycle ends.

[0091] Subsequently, the processing server cyclically extracts from the row data of the above collection of results deal resultl the correlation field configuration in the sub-query Date recue / Date received 202 1-1 1-09 configuration information to which the current query order corresponds, namely the field information to which the correlation fields --- delivery order code (delycode) and delivery order item number (delycodeitem) --- in Table 6 correspond, takes the field information to which the obtained delivery order code (delycode) and delivery order item number (delycodeitem) correspond as parameters to replace the two values of $dely code and $delycodeitem in the SQL statement generated on the basis of Table 6 to obtain a new SQL
statement, and thereafter executes the new SQL statement to enquire and obtain partial primary data from the receipt order table, by which time it is required to combine the partial primary data obtained via the query with the row data of deal result1 to which the process currently circulates, the next cycle is continuously performed after the combining operation, a new collection of results deal result2 can be obtained when the cycle ends, and deal resu1t2 is thereafter written in a temporary file.

[0092] If the main sheet data obtained via the query is relatively large, it is possible to put the data obtained via the query into pages, in which case the processing server performs the aforementioned process of obtaining relevant primary data on the data of each page until the data of all pages has been processed, and correlation processing is then performed on the primary data obtained by processing each page, that is to say, the data is organized according to a preset data processing format, for instance, the obtained data is organized with excel format to obtain an excel file, this excel file can be subsequently written in a file server, and the file address of this file in the file server is updated into a download task table for subsequent downloading by the operating personnel.

[0093] Based on the same inventive conception as the method embodiments, the present invention provides a device for processing a data acquisition request. In one embodiment as shown in Fig. 3, the device for processing a data acquisition request comprises the following modules:

[0094] a request determining module 110, for determining a data acquisition request to be currently processed in response to a preset trigger instruction;

Date recue / Date received 202 1-1 1-09

[0095] a request configuration obtaining module 120, for obtaining request configuration information to which the data acquisition request corresponds;

[0096] a primary data obtaining module 130, for obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information;
and

[0097] a correlation processing module 140, for performing correlation processing on the primary data to obtain target data that satisfies the data acquisition request.

[0098] In one embodiment, the request configuration information includes main query configuration information and at least one piece of sub-query configuration information.
The primary data obtaining module includes:

[0099] a first data obtaining sub-module, for enquiring and obtaining, on the basis of the main query configuration information, primary data from a target datasheet corresponding to the main query configuration information;

[0100] a determining sub-module, for determining a query order and a target datasheet to which each query configuration information in the at least one piece of sub-query configuration information corresponds; and

[0101] a second data obtaining sub-module, for enquiring and obtaining, according to the query order and sequentially on the basis of the sub-query configuration information to which each query order corresponds, primary data to which the sub-query configuration information corresponds from the target datasheet corresponding thereto.

[0102] In one embodiment, each sub-query configuration information includes query field configuration and correlation field configuration. The second data obtaining sub-module includes:

[0103] a correlation field information obtaining unit, for obtaining, on the basis of the correlation field configuration in the sub-query configuration information to which any query order corresponds, correlation field information from the primary data correlated with the sub-query configuration information to which any query order corresponds, wherein the primary data correlated with the sub-query configuration information with the Date recue / Date received 202 1-1 1-09 first query order is primary data to which the main query configuration information corresponds, and the primary data correlated with any sub-query configuration information whose query order is not the first is primary data to which the sub-query configuration information previous in query order to the any sub-query configuration information corresponds; and

[0104] a primary data obtaining unit, for obtaining, on the basis of the correlation field information and the query field configuration in the sub-query configuration information to which the any query order corresponds, primary data from the target datasheet to which the any query order corresponds.

[0105] In one embodiment, the primary data obtaining module includes:

[0106] a risk inspecting sub-module, for performing risk inspection on the request configuration information; and

[0107] a primary data obtaining sub-module, for obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information after confirming that the request configuration information has passed the risk inspection.

[0108] In one embodiment, the device for processing a data acquisition request further comprises the following modules:

[0109] a data writing module, for writing the correlated data in a file server; and

[0110] a file address updating module, for updating a file address to which the correlated data in the file server corresponds into a download task table.

[0111] Specific definitions relevant to the device for processing a data acquisition request may be inferred from the aforementioned definitions to the method of processing a data acquisition request, while no repetition is made in this context. The various modules in the aforementioned device for processing a data acquisition request can be wholly or partly realized via software, hardware, and a combination of software with hardware.
The various modules can be embedded in the form of hardware in a processor in a computer equipment Date recue / Date received 202 1-1 1-09 or independent of any computer equipment, and can also be stored in the form of software in a memory in a computer equipment, so as to facilitate the processor to invoke and perform operations corresponding to the aforementioned various modules.

[0112] In one embodiment, a computer equipment is provided, whose internal structure can be as shown in Fig. 4. The computer equipment comprises a processor, a memory, a network interface and a database connected to each other via a system bus. The processor of the computer equipment is employed to provide computing and controlling capabilities. The memory of the computer equipment includes a nonvolatile storage medium and an internal memory. The nonvolatile storage medium stores therein an operating system, a computer program and a database. The internal memory provides environment for the running of the operating system and the computer program in the nonvolatile storage medium.
The database of the computer equipment is employed to store a plurality of datasheets and such data as the request configuration information to which the data acquisition request corresponds. The network interface of the computer equipment is employed to connect to an external terminal via network for communication. The computer program realizes a method of processing a data acquisition request when it is executed by a processor.

[0113] As understandable to persons skilled in the art, the structure illustrated in Fig. 4 is merely a block diagram of partial structure relevant to the solution of the present application, and does not constitute any restriction to the computer equipment on which the solution of the present application is applied, as the specific computer equipment may comprise component parts that are more than or less than those illustrated in Fig. 4, or may combine certain component parts, or may have different layout of component parts.

[0114] In one embodiment, there is provided a computer equipment that comprises a memory, a processor and a computer program stored on the memory and executable on the processor, and the following steps are realized when the processor executes the computer program:
determining a data acquisition request to be currently processed in response to a preset Date recue / Date received 202 1-1 1-09 trigger instruction; obtaining request configuration information to which the data acquisition request corresponds; obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information; and performing correlation processing on the primary data to obtain target data that satisfies the data acquisition request.

[0115] In one embodiment, the request configuration information includes main query configuration information and at least one piece of sub-query configuration information, and the following steps are further realized when the processer executes the computer program to realize the step of obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information:

[0116] enquiring and obtaining, on the basis of the main query configuration information, primary data from a target datasheet corresponding to the main query configuration information; determining a query order and a target datasheet to which each query configuration information in the at least one piece of sub-query configuration information corresponds; and enquiring and obtaining, according to the query order and sequentially on the basis of the sub-query configuration information to which each query order corresponds, primary data to which the sub-query configuration information corresponds from the target datasheet corresponding thereto.

[0117] In one embodiment, each sub-query configuration information includes query field configuration and correlation field configuration, and the following steps are further realized when the processor executes the computer program to realize the step of enquiring and obtaining, on the basis of the sub-query configuration information to which any query order corresponds, primary data to which the sub-query configuration information corresponds from the target datasheet corresponding thereto:

[0118] obtaining, on the basis of the correlation field configuration in the sub-query configuration information to which any query order corresponds, correlation field information from the primary data correlated with the sub-query configuration information Date recue / Date received 202 1-1 1-09 to which any query order corresponds, wherein the primary data correlated with the sub-query configuration information with the first query order is primary data to which the main query configuration information corresponds, and the primary data correlated with any sub-query configuration information whose query order is not the first is primary data to which the sub-query configuration information previous in query order to the any sub-query configuration information corresponds; and obtaining, on the basis of the correlation field information and the query field configuration in the sub-query configuration information to which the any query order corresponds, primary data from the target datasheet to which the any query order corresponds.

[0119] In one embodiment, when the processor executes the computer program to realize the step of obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information, the following steps are further realized:

[0120] performing risk inspection on the request configuration information;
and obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information after confirming that the request configuration information has passed the risk inspection.

[0121] In one embodiment, after the processor executes the computer program to realize the step of performing correlation processing on the primary data to obtain correlated data to which the data acquisition request corresponds, the following steps are further realized:

[0122] writing the correlated data in a file server; and updating a file address to which the correlated data in the file server corresponds into a download task table.

[0123] In one embodiment, there is provided a computer-readable storage medium storing thereon a computer program, and the following steps are realized when the computer program is executed by a processor: determining a data acquisition request to be currently processed in response to a preset trigger instruction; obtaining request configuration information to which the data acquisition request corresponds; obtaining primary data Date recue / Date received 202 1-1 1-09 stored dispersedly in a plurality of datasheets according to the request configuration information; and performing correlation processing on the primary data to obtain target data that satisfies the data acquisition request.

[0124] In one embodiment, the request configuration information includes main query configuration information and at least one piece of sub-query configuration information, and the following steps are further realized when the computer program is executed by a processor to realize the step of obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information:

[0125] enquiring and obtaining, on the basis of the main query configuration information, primary data from a target datasheet corresponding to the main query configuration information; determining a query order and a target datasheet to which each query configuration information in the at least one piece of sub-query configuration information corresponds; and enquiring and obtaining, according to the query order and sequentially on the basis of the sub-query configuration information to which each query order corresponds, primary data to which the sub-query configuration information corresponds from the target datasheet corresponding thereto.

[0126] In one embodiment, each sub-query configuration information includes query field configuration and correlation field configuration, and the following steps are further realized when the computer program is executed by a processor to realize the step of enquiring and obtaining, on the basis of the sub-query configuration information to which any query order corresponds, primary data to which the sub-query configuration information corresponds from the target datasheet corresponding thereto:

[0127] obtaining, on the basis of the correlation field configuration in the sub-query configuration information to which any query order corresponds, correlation field information from the primary data correlated with the sub-query configuration information to which any query order corresponds, wherein the primary data correlated with the sub-query configuration information with the first query order is primary data to which the Date recue / Date received 202 1-1 1-09 main query configuration information corresponds, and the primary data correlated with any sub-query configuration information whose query order is not the first is primary data to which the sub-query configuration information previous in query order to the any sub-query configuration information corresponds; and obtaining, on the basis of the correlation field information and the query field configuration in the sub-query configuration information to which the any query order corresponds, primary data from the target datasheet to which the any query order corresponds.

[0128] In one embodiment, when the computer program is executed by a processor to realize the step of obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration infolination, the following steps are further realized:

[0129] performing risk inspection on the request configuration information;
and obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information after confirming that the request configuration information has passed the risk inspection.

[0130] In one embodiment, after the computer program is executed by a processor to realize the step of performing correlation processing on the primary data to obtain correlated data to which the data acquisition request corresponds, the following steps are further realized:

[0131] writing the correlated data in a file server; and updating a file address to which the correlated data in the file server corresponds into a download task table.

[0132] As comprehensible to persons ordinarily skilled in the art, the entire or partial flows in the methods according to the aforementioned embodiments can be completed via a computer program instructing relevant hardware, the computer program can be stored in a nonvolatile computer-readable storage medium, and the computer program can include the flows as embodied in the aforementioned various methods when executed. Any reference to the memory, storage, database or other media used in the various embodiments provided by the present application can all include nonvolatile and/or volatile memory/memories.

Date recue / Date received 202 1-1 1-09 The nonvolatile memory can include a read-only memory (ROM), a programmable ROM
(PROM), an electrically programmable ROM (EPROM), an electrically erasable and programmable ROM (EEPROM) or a flash memory. The volatile memory can include a random access memory (RAM) or an external cache memory. To serve as explanation rather than restriction, the RAM is obtainable in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), dual data rate SDRAM
(DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM
(SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct Rambus dynamic RAM (DRDRAM), and Rambus dynamic RAM (RDRAM), etc.

[0133] Technical features of the aforementioned embodiments are randomly combinable, while all possible combinations of the technical features in the aforementioned embodiments are not exhausted for the sake of brevity, but all these should be considered to fall within the scope recorded in the Description as long as such combinations of the technical features are not mutually contradictory.

[0134] The foregoing embodiments are merely directed to several modes of execution of the present application, and their descriptions are relatively specific and detailed, but they should not be hence misunderstood as restrictions to the inventive patent scope. As should be pointed out, persons with ordinary skill in the art may further make various modifications and improvements without departing from the conception of the present application, and all these should pertain to the protection scope of the present application.
Accordingly, the patent protection scope of the present application shall be based on the attached Claims.

Date recue / Date received 202 1-1 1-09

Claims

What is claimed is:

1. A method of processing a data acquisition request, characterized in comprising:
determining a data acquisition request to be currently processed in response to a preset trigger instruction;
obtaining a request configuration information to which the data acquisition request corresponds;
obtaining a primary data stored dispersedly in a plurality of datasheets according to the request configuration information; and performing correlation processing on the primary data to obtain a target data that satisfies the data acquisition request.

2. The method of processing a data acquisition request according to Claim 1, characterized in that the request configuration information includes a main query configuration information and at least one piece of sub-query configuration information; and that the step of obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information includes:
enquiring and obtaining, on the basis of the main query configuration information, primary data from a target datasheet corresponding to the main query configuration information;
determining a query order and a target datasheet to which each query configuration Date recue / Date received 2021-11-09 information in the at least one piece of sub-query configuration information corresponds;
and enquiring and obtaining, according to the query order and sequentially on the basis of the sub-query configuration information to which each query order corresponds, primary data to which the sub-query configuration information corresponds from the target datasheet corresponding thereto.

3. The method of processing a data acquisition request according to Claim 2, characterized in that each sub-query configuration information includes a query field configuration and a correlation field configuration; and that, while enquiring and obtaining, on the basis of the sub-query configuration information to which any query order corresponds, primary data to which the sub-query configuration information corresponds from the target datasheet corresponding thereto, the method comprises:
obtaining, on the basis of the correlation field configuration in the sub-query configuration information to which any query order corresponds, correlation field information from the primary data correlated with the sub-query configuration information to which any query order corresponds; wherein the primary data correlated with the sub-query configuration information with the first query order is primary data to which the main query configuration information corresponds, and the primary data correlated with any sub-query configuration information whose query order is not the first is primary data to which the sub-query configuration information previous in query order to the any sub-query configuration information corresponds; and obtaining, on the basis of the correlation field information and the query field configuration in the sub-query configuration information to which the any query order corresponds, primary data from the target datasheet to which the any query order corresponds.

Date recue / Date received 2021-11-09

4. The method of processing a data acquisition request according to Claim 1, characterized in that the step of obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information includes:
performing risk inspection on the request configuration information; and obtaining primary data stored dispersedly in a plurality of datasheets according to the request configuration information after confirming that the request configuration information has passed the risk inspection.

5. The method of processing a data acquisition request according to Claim 1, characterized in further comprising, after the step of performing correlation processing on the primary data to obtain correlated data to which the data acquisition request corresponds:
writing the correlated data in a file server; and updating a file address to which the correlated data in the file server corresponds into a download task table.

6. A device for processing a data acquisition request, characterized in comprising:
a request determining module, for determining a data acquisition request to be currently processed in response to a preset trigger instruction;
a request configuration obtaining module, for obtaining a request configuration information to which the data acquisition request corresponds;
a primary data obtaining module, for obtaining a primary data stored dispersedly in a plurality Date recue / Date received 2021-11-09 of datasheets according to the request configuration information; and for performing correlation processing on the primary data to obtain a target data that satisfies the data acquisition request.

7. The device for processing a data acquisition request according to Claim 6, characterized in that the request configuration information includes a main query configuration information and at least one piece of sub-query configuration information; and that the primary data obtaining module includes:
a first data obtaining sub-module, for enquiring and obtaining, on the basis of the main query configuration information, primary data from a target datasheet corresponding to the main query configuration information;
a determining sub-module, for determining a query order and a target datasheet to which each query configuration information in the at least one piece of sub-query configuration information corresponds; and a second data obtaining sub-module, for enquiring and obtaining, according to the query order and sequentially on the basis of the sub-query configuration information to which each query order corresponds, primary data to which the sub-query configuration information corresponds from the target datasheet corresponding thereto.

8. The device for processing a data acquisition request according to Claim 7, characterized in that each sub-query configuration information includes a query field configuration and a correlation field configuration; and that the second data obtaining sub-module includes:
a correlation field information obtaining unit, for obtaining, on the basis of the correlation Date recue / Date received 2021-11-09 field configuration in the sub-query configuration information to which any query order corresponds, correlation field information from the primary data correlated with the sub-query configuration information to which any query order corresponds; wherein the primary data correlated with the sub-query configuration information with the first query order is primary data to which the main query configuration information corresponds, and the primary data correlated with any sub-query configuration information whose query order is not the first is primary data to which the sub-query configuration information previous in query order to the any sub-query configuration information corresponds; and a primary data obtaining unit, for obtaining, on the basis of the correlation field information and the query field configuration in the sub-query configuration information to which the any query order corresponds, primary data from the target datasheet to which the any query order corresponds.

9. A computer equipment, comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the method steps according to anyone of Claims 1 to 5 are realized when the processor executes the computer program.

10. A computer-readable storage medium, storing a computer program thereon, characterized in that the method steps according to anyone of Claims 1 to 5 are realized when the computer program is executed by a processor.

Date recue / Date received 2021-11-09