Note: Descriptions are shown in the official language in which they were submitted.
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
1
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
2
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.
3
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
4
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
6
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
7
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
8
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
9
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
11
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.
12
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
13
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.
14
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)
16
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
17
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
18
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;
19
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
21
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
22
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
23
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
24
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.
26
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.
27
Date recue / Date received 202 1-1 1-09