CN110991154A - Report generation method, system, computer equipment and computer readable storage medium - Google Patents

Report generation method, system, computer equipment and computer readable storage medium Download PDF

Info

Publication number
CN110991154A
CN110991154A CN201911327877.0A CN201911327877A CN110991154A CN 110991154 A CN110991154 A CN 110991154A CN 201911327877 A CN201911327877 A CN 201911327877A CN 110991154 A CN110991154 A CN 110991154A
Authority
CN
China
Prior art keywords
server
task
file
identification information
data identification
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201911327877.0A
Other languages
Chinese (zh)
Inventor
王伟
李恺
何柄融
许煜彬
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shenzhen Qianhai Huanrong Lianyi Information Technology Service Co Ltd
Original Assignee
Shenzhen Qianhai Huanrong Lianyi Information Technology Service Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Shenzhen Qianhai Huanrong Lianyi Information Technology Service Co Ltd filed Critical Shenzhen Qianhai Huanrong Lianyi Information Technology Service Co Ltd
Priority to CN201911327877.0A priority Critical patent/CN110991154A/en
Publication of CN110991154A publication Critical patent/CN110991154A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10File systems; File servers
    • G06F16/14Details of searching files based on file metadata
    • G06F16/148File search processing
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10File systems; File servers
    • G06F16/16File or folder operations, e.g. details of user interfaces specifically adapted to file systems

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Human Computer Interaction (AREA)
  • Library & Information Science (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a report generation method, a system, computer equipment and a computer readable storage medium, wherein the method comprises the following steps: receiving a report export request sent by a user, and acquiring a data query condition according to the export request; inquiring data identification information matched with the inquiry condition from a database according to the inquiry condition, wherein the data identification information can identify each data in the database; generating a task corresponding to the data identification information according to a preset generation rule; sending the task to the server execution terminal so that the server execution terminal generates a corresponding file according to the task; and receiving the file uploaded by the server execution terminal and sending the file to the user terminal in a report form. By the method, the data needing to be exported is exported through the server execution terminal, so that the overflow of the memory of the server is effectively avoided, and the efficiency of exporting the data report is improved.

Description

Report generation method, system, computer equipment and computer readable storage medium
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a method and a system for generating a report, a computer device, and a computer-readable storage medium.
Background
In the prior art, a large amount of real-time data reports are exported on a single machine, if the export efficiency needs to be improved, a multithreading mode is often used, when a large amount of data needs to be exported and operation is involved, a large amount of memory needs to be occupied, and even the service memory is overflowed due to overlarge data amount. Therefore, the prior art method has the problem of low efficiency of data export.
Disclosure of Invention
The embodiment of the invention provides a report generation method, a report generation system, computer equipment and a computer readable storage medium, and aims to solve the problem of low data export efficiency in the prior art.
In a first aspect, an embodiment of the present invention provides a report generating method, including:
receiving a report export request sent by a user, and acquiring a data query condition according to the export request;
inquiring data identification information matched with the inquiry condition from a database according to the inquiry condition, wherein the data identification information can identify each data in the database;
generating a task corresponding to the data identification information according to a preset generation rule;
sending the task to the server execution terminal so that the server execution terminal generates a corresponding file according to the task; and
and receiving the file uploaded by the server execution terminal and sending the file to the user terminal in a report form.
In a second aspect, an embodiment of the present invention provides a report generating system, which includes:
the server and the server execution terminal are included, and the server comprises:
the query condition acquisition unit is used for receiving a report export request sent by a user and acquiring a data query condition according to the export request;
the data generating unit is used for inquiring data identification information matched with the inquiry condition from a database according to the inquiry condition, wherein the data identification information can identify each data in the database;
the task generating unit is used for generating a task corresponding to the data identification information according to a preset generating rule;
the task sending unit is used for sending the task to the server execution terminal so that the server execution terminal generates a corresponding file according to the task; and
the report sending unit is used for receiving the file uploaded by the server execution terminal and sending the file to the user terminal in a report form;
the server execution terminal includes:
the task obtaining unit is used for obtaining a task corresponding to a task processing request according to the task processing request from the server;
the task allocation unit is used for allocating the tasks to the applications conforming to the tasks according to a preset scheduling rule;
the file sending unit is used for calling the application to generate a corresponding file according to the task and sending the file to the server;
and the ending notification unit is used for calling the application to send the notification of the task ending to the server.
In a third aspect, an embodiment of the present invention further provides a computer device, which includes a memory, a processor, and a computer program stored on the memory and executable on the processor, where the processor, when executing the computer program, implements the report generating method according to the first aspect.
In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, where the computer-readable storage medium stores a computer program, and the computer program, when executed by a processor, causes the processor to execute the report generation method according to the first aspect.
The embodiment of the invention provides a report generation method, a report generation system, computer equipment and a computer readable storage medium, wherein the method comprises the following steps: receiving a report export request sent by a user, and acquiring a data query condition according to the export request; inquiring data identification information matched with the inquiry condition from a database according to the inquiry condition, wherein the data identification information can identify each data in the database; generating a task corresponding to the data identification information according to a preset generation rule; sending the task to the server execution terminal so that the server execution terminal generates a corresponding file according to the task; and receiving the file uploaded by the server execution terminal and sending the file to the user terminal in a report form. By the method, the data needing to be exported is exported through the server execution terminal, so that the overflow of the memory of the server is effectively avoided, and the efficiency of exporting the data report is improved.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
Fig. 1 is a schematic flow chart of a report generation method according to an embodiment of the present invention;
fig. 2 is a schematic view of an application scenario of the report generation method according to the embodiment of the present invention;
FIG. 3 is a sub-flow diagram of a report generation method according to an embodiment of the present invention;
fig. 4 is another schematic flow chart of the report generating method according to the embodiment of the present invention;
FIG. 5 is a schematic view of another sub-process of the report generation method according to the embodiment of the present invention;
FIG. 6 is a schematic block diagram of a report generation system according to an embodiment of the present invention;
FIG. 7 is a schematic block diagram of a computer device provided by an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It will be understood that the terms "comprises" and/or "comprising," when used in this specification and the appended claims, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.
It is also to be understood that the terminology used in the description of the invention herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. As used in the specification of the present invention and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.
It should be further understood that the term "and/or" as used in this specification and the appended claims refers to and includes any and all possible combinations of one or more of the associated listed items.
Referring to fig. 1 and fig. 2, fig. 1 is a schematic flow chart of a report generation method according to an embodiment of the present invention, and fig. 2 is a schematic application scenario diagram of the report generation method according to the embodiment of the present invention. The report generation method is applied to the server 10, the server 10 exports data required by the user terminal 30 and sends the data to the server execution terminal 20 for execution, the server execution terminal 20 generates a file corresponding to the data and sends the file to the server 10, and finally the server 10 sends the file to the user terminal 30 in a report form.
As shown in fig. 1, the method includes steps S110 to S150.
S110, receiving a report export request sent by a user, and acquiring a data query condition according to the export request.
Receiving a report export request sent by a user, and acquiring a data query condition according to the export request. Specifically, when a user inputs a request for exporting a large amount of data in a form of a report, the user front end receives an instruction of a report export request input by the user and sends the instruction to the server 10, and the server 10 receives the instruction and then obtains a relevant data query condition so that the server 10 queries the data needed to be obtained by the user according to the query condition.
And S120, inquiring data identification information matched with the inquiry condition from a database according to the inquiry condition, wherein the data identification information can identify each data in the database.
And querying data identification information matched with the query condition from a database according to the query condition, wherein the data identification information can identify each data in the database. Specifically, the data identification information is a unique ID on each piece of data in the database, and the server 10 queries, according to the query condition, the identification information on the data that matches the query condition from the database of the server 10. The database in the server 10 is used to store information related to the user, where the information may be personal information of the user, information consumed by the user, or recorded information queried by the user in real time.
And S130, generating a task corresponding to the data identification information according to a preset generation rule.
And generating a task corresponding to the data identification information according to a preset generation rule. Specifically, when a user needs to export a large amount of data, the efficiency of exporting the data by the server 10 is low due to the capacity limit of the server 10 itself, and the large amount of data cannot be exported and sent to the user in a file form quickly. The preset generation rule is a rule that the server 10 needs to generate a corresponding task according to the quantity of the data identification information.
In an embodiment, as shown in fig. 3, step S130 includes sub-steps S131, S132, and S133.
S131, judging whether the data identification information accords with a preset slicing rule or not according to a preset judgment rule.
And judging whether the data identification information accords with a preset slicing rule or not according to a preset judgment rule. Specifically, the preset judgment rule is used to judge the number of pieces of data identification information queried from the database of the server 10, and judge whether the data identification information conforms to the preset slicing rule according to the number of pieces of data identification information, where the preset slicing rule is a slicing rule of a service key in the server 10 when slicing data. For example, if the preset slicing rule specifies that the number of pieces of data identification information exceeds one hundred thousand and meets the preset slicing rule, and the number of pieces of data identification information does not exceed one hundred thousand and does not meet the preset slicing rule, the preset judgment rule may judge whether the number of pieces of data identification information exceeds one hundred thousand. If the number of the data identification information exceeds one hundred thousand, the data identification information can be judged to accord with the preset rule, and if the number of the data identification information does not exceed one hundred thousand, the data identification information can be judged to not accord with the preset rule.
S132, if the data identification information accords with a preset slicing rule, slicing the data identification information according to the preset slicing rule to obtain sliced data identification information.
And if the data identification information accords with a preset slicing rule, slicing the data identification information according to the preset slicing rule to obtain sliced data identification information. Specifically, the data identification information is sliced in the server 10 by a service key, and the slice is used for dividing the data identification information into a predetermined number of pieces of data identification information according to the number of pieces of data identification information. For example, when the number of the data identification information is one million, the data identification information may be divided into ten groups, where one hundred thousand pieces of data identification information exist in each group of data identification information; when the number of the data identification information is one hundred and ten thousand, the data identification information can be divided into ten groups, wherein the ten groups of data identification information have one hundred thousand pieces of data identification information, and the last group of data identification information has one ten thousand pieces of data identification information.
And S133, generating a corresponding task according to the sliced data identification information.
And generating a corresponding task according to the sliced data identification information. Specifically, after the data identification information is sliced according to a preset rule, a plurality of groups of data identification information are obtained, each group of data identification information includes a certain number of data identification information, and each group of data identification information generates corresponding tasks respectively and sends the tasks to an external application through the server 10 to be executed. For example, after the sliced data identification information is divided into ten sets of data identification information, ten tasks can be generated according to the ten sets of data identification information, and each task can be respectively sent to an external application through the server 10 to be executed.
S140, the task is sent to the server execution terminal so that the server execution terminal can generate a corresponding file according to the task.
And sending the task to the server execution terminal so that the server execution terminal generates a corresponding file according to the task. Specifically, the server 10 generates a task corresponding to the data identification information according to a preset generation rule and sends the task to the server execution terminal 20 for execution, and after receiving the task, the server execution terminal 20 derives the data from the database of the server 10 according to the data identification information and generates a corresponding file from the data, thereby reducing the pressure of the server 10.
In an embodiment, as shown in fig. 4, step S140 includes sub-steps S141, S142, S143, and S144.
And S141, acquiring a task corresponding to the task processing request according to the task processing request from the server.
And acquiring a task corresponding to the task processing request according to the task processing request from the server. Specifically, the server 10 sends a processing request to the server execution terminal 20, where the server execution terminal 20 needs to execute the task, according to the task, and after receiving the task processing request, the server execution terminal 20 obtains a task corresponding to the task request from the task processing request, so that the execution server 10 generates a task corresponding to the data according to a preset generation rule.
And S142, distributing the tasks to the applications conforming to the tasks according to a preset scheduling rule.
And distributing the tasks to the applications which accord with the tasks according to a preset scheduling rule. Specifically, before the server execution terminal 20 allocates the task to the application that meets the task according to the preset scheduling rule, the server execution terminal needs to register in the application, and the task can be allocated to the application by knowing whether the application is idle. The server execution terminal 20 may be registered in at least one application, and when the server execution terminal 20 receives a plurality of tasks, the server execution terminal 20 needs to perform a search among all registered applications to determine an application that meets the task processing.
And S143, calling the application to generate a corresponding file according to the task and sending the file to the server.
And calling the application to generate a corresponding file according to the task and sending the file to the server. Specifically, the application is configured to read data from a database of the server 10 according to the task to generate a file, and send the file to the server 10, so that the server 10 exports and sends the file to the user terminal in a form of a report. In the embodiment of the invention, the data required by the user is written in and exported by using the application at the server execution terminal 20, so that the pressure of the server 10 is greatly reduced, and the efficiency of exporting the data report is improved.
And S144, calling the application to send the notice of task completion to the server.
And calling the application to send the notification of the task ending to the server. Specifically, after the application exports all data required by the user in the form of a file and sends the data to the server 10, the application sends a notification that all data are exported in the form of a file and sent to the server 10.
S150, receiving the file uploaded by the server execution terminal and sending the file to the user terminal in a report form.
And receiving the file uploaded by the server execution terminal and sending the file to the user terminal in a report form. Specifically, after the server 10 receives a file required by the user and generated by the server execution terminal 20, the server 10 sends the file to the user terminal so that the file can be exported by the user terminal in the form of a report.
In one embodiment, as shown in fig. 5, step S150 includes sub-steps S151, S152, and S153.
And S151, receiving the file uploaded by the server execution terminal.
And receiving the file uploaded by the server execution terminal. Specifically, the file uploaded by the server execution terminal 20 and received by the server 10 may be composed of a plurality of files or may be composed of a single file, the size of the file uploaded by the server execution terminal 20 is mainly determined by the size of the data that needs to be exported by the user, when the data that needs to be exported by the user is more, the file uploaded by the server execution terminal 20 is composed of a plurality of files, and when the data that needs to be exported by the user is less, the file uploaded by the server execution terminal 20 may be composed of a single file.
S152, merging the files according to a preset merging rule to generate a merged file.
And merging the files according to a preset merging rule to generate a merged file. Specifically, the preset merge rule may be a time sequence in which the server execution terminal 20 uploads the files to merge the files uploaded to the server 10, may also be a size sequence in which the server execution terminal 20 uploads the files to merge, and may also be a sequence before the data in the files are split to merge.
In another embodiment, step S152 is preceded by step S152 a.
S152a, receiving the notification of the task end sent by the server execution terminal.
And receiving a notice of task ending sent by the server execution terminal. Specifically, the server 10 receives a notification that all files sent by the server execution terminal 20 have been uploaded to the server 10, and sends the notification to the server 10, so as to remind the server 10 that the subsequent operations can be performed.
S153, sending the merged file to the user terminal in a report form.
And sending the merged file to a user terminal in a report form. Specifically, the server 10 combines all the received files into one file, and sends the file to the user terminal for the user terminal to export in the form of a report.
The report generation method provided by the embodiment of the invention receives a report export request sent by a user, and acquires a data query condition according to the export request; inquiring data identification information matched with the inquiry condition from a database according to the inquiry condition, wherein the data identification information can identify each data in the database; generating a task corresponding to the data identification information according to a preset generation rule; sending the task to the server execution terminal so that the server execution terminal generates a corresponding file according to the task; and receiving the file uploaded by the server execution terminal and sending the file to the user terminal in a report form. By the method, the data needing to be exported is exported through the server execution terminal, so that the overflow of the memory of the server is effectively avoided, and the efficiency of exporting the data is improved.
The invention also provides a report generating system, which comprises a server 10 and a server execution terminal 20, the system exports the data required by the user terminal 30 through the server 10 and sends the data to the server execution terminal 20 for execution, the server execution terminal 20 generates the file corresponding to the data and sends the file to the server 10, and finally the server 10 sends the file to the user terminal 30 in the form of a report. Specifically, referring to fig. 6, fig. 6 is a schematic block diagram of a report generation system according to an embodiment of the present invention.
As shown in fig. 6, the server 10 includes a query condition acquisition unit 110, a data generation unit 120, a task generation unit 130, a task transmission unit 140, and a report transmission unit 150.
The query condition obtaining unit 110 is configured to receive a report export request sent by a user, and obtain a data query condition according to the export request.
Receiving a report export request sent by a user, and acquiring a data query condition according to the export request. Specifically, when a user inputs a request for exporting a large amount of data in a form of a report, the user front end receives an instruction of a report export request input by the user and sends the instruction to the server 10, and the server 10 receives the instruction and then obtains a relevant data query condition so that the server 10 queries the data needed to be obtained by the user according to the query condition.
The data generating unit 120 is configured to query, according to the query condition, data identification information matched with the query condition from a database, where the data identification information may identify each data in the database.
And querying data identification information matched with the query condition from a database according to the query condition, wherein the data identification information can identify each data in the database. Specifically, the data identification information is a unique ID on each piece of data in the database, and the server 10 queries the data identification information matching the query condition from the database of the server 10 according to the query condition. The database in the server 10 is used to store information related to the user, where the information may be personal information of the user, information consumed by the user, or recorded information queried by the user in real time.
And a task generating unit 130, configured to generate a task corresponding to the data identification information according to a preset generating rule.
And generating a task corresponding to the data identification information according to a preset generation rule. Specifically, when a user needs to export a large amount of data, the efficiency of exporting the data by the server 10 is low due to the capacity limit of the server 10 itself, and the large amount of data cannot be exported and sent to the user in a file form quickly. The preset generation rule is a rule that the server 10 needs to generate a corresponding task according to the quantity of the data identification information.
In other invention embodiments, the task generating unit 130 includes a judging unit 131, a slicing unit 132, and a generating unit 133.
The judging unit 131 is configured to judge whether the data identification information conforms to a preset slicing rule according to a preset judgment rule.
And judging whether the data identification information accords with a preset slicing rule or not according to a preset judgment rule. Specifically, the preset judgment rule is used to judge the number of pieces of data identification information queried from the database of the server 10, and judge whether the data identification information conforms to the preset slicing rule according to the number of pieces of data identification information, where the preset slicing rule is a slicing rule of a service key in the server 10 when slicing the data identification information.
The segmentation unit 132 is configured to, if the data identification information conforms to a preset slicing rule, slice the data identification information according to the preset slicing rule to obtain sliced data identification information.
And if the data accords with a preset slicing rule, slicing the data identification information according to the preset slicing rule to obtain the sliced data identification information. Specifically, the data identification information is sliced in the server 10 by a service key, and the slice is used for dividing the data identification information into a predetermined number of pieces of data identification information according to the number of pieces of data identification information.
The generating unit 133 is configured to generate corresponding tasks from the sliced data identification information.
And generating a corresponding task according to the sliced data identification information. Specifically, after the data identification information is sliced according to a preset rule, a plurality of groups of data identification information are obtained, each group of data identification information includes a certain number of data identification information, and each group of data identification information generates corresponding tasks respectively and sends the tasks to an external application through the server 10 to be executed.
A task sending unit 140, configured to send the task to the server execution terminal, so that the server execution terminal generates a corresponding file according to the task.
And sending the task to the server execution terminal 20 so that the server execution terminal 20 generates a corresponding file according to the task. Specifically, the server 10 generates a task corresponding to the data identification information according to a preset generation rule and sends the task to the server execution terminal 20 for execution, and after receiving the task, the server execution terminal 20 derives the data from the database of the server 10 according to the data identification information and generates a corresponding file from the data, thereby reducing the pressure of the server 10.
And a report sending unit 150, configured to receive the file uploaded by the server execution terminal and send the file to the user terminal in a form of a report.
And receiving the file uploaded by the server execution terminal and sending the file to the user terminal in a report form. Specifically, after the server 10 receives a file required by the user and generated by the server execution terminal 20, the server 10 sends the file to the user terminal so that the file can be exported by the user terminal in the form of a report.
In other embodiments of the present invention, the report sending unit 150 includes a file receiving unit 151, a file merging unit 152, and a sending unit 153.
A file receiving unit 151, configured to receive a file uploaded by the server execution terminal.
And receiving the file uploaded by the server execution terminal 20. Specifically, the file uploaded by the server execution terminal 20 and received by the server 10 may be composed of a plurality of files or may be composed of a single file, and the size of the file uploaded by the server execution terminal 20 is mainly determined by the size of the data that the user needs to export.
The file merging unit 152 is configured to merge the files according to a preset merging rule to generate a merged file.
And merging the files according to a preset merging rule to generate a merged file. Specifically, the preset merge rule may be a time sequence in which the server execution terminal 20 uploads the files to merge the files uploaded to the server 10, may also be a size sequence in which the server execution terminal 20 uploads the files to merge, and may also be a sequence before the data in the files are split to merge.
A sending unit 153, configured to send the merged file to the user terminal in the form of a report.
And sending the merged file to a user terminal in a report form. Specifically, the server 10 combines all the received files into one file, and sends the file to the user terminal for the user terminal to export in the form of a report.
In another embodiment, the server 10 further includes an end notification receiving unit 152 a.
An end notification receiving unit 152a, configured to receive a notification that the task sent by the server execution terminal ends.
And receiving a notice of task ending sent by the server execution terminal. Specifically, the server 10 receives a notification that all files sent by the server execution terminal 20 have been uploaded to the server 10, and sends the notification to the server 10, so as to remind the server 10 that the subsequent operations can be performed.
In other embodiment of the invention, the server execution terminal 20 includes a task acquisition unit 141, a task allocation unit 142, a file transmission unit 143, and an end notification unit 144.
The task obtaining unit 141 is configured to obtain a task corresponding to the task processing request according to the task processing request from the server.
And acquiring a task corresponding to the task processing request according to the task processing request from the server. Specifically, the server 10 sends a processing request to the server execution terminal 20, where the server execution terminal 20 needs to execute the task, according to the task, and after receiving the task processing request, the server execution terminal 20 obtains a task corresponding to the task request from the task processing request, so that the execution server 10 generates a task corresponding to the data according to a preset generation rule.
And the task allocation unit 142 is configured to allocate the task to an application that conforms to the task according to a preset scheduling rule.
And distributing the tasks to the applications which accord with the tasks according to a preset scheduling rule. Specifically, before the server execution terminal 20 allocates the task to the application that meets the task according to the preset scheduling rule, the server execution terminal needs to register in the application, and the task can be allocated to the application by knowing whether the application is idle.
And the file sending unit 143 is configured to generate a corresponding file according to the task and send the file to the server.
And the application generates a corresponding file according to the task and sends the file to the server. Specifically, the application is configured to read data from a database of the server 10 according to the task to generate a file, and send the file to the server 10, so that the server 10 exports and sends the file to the user terminal in a form of a report.
An end notification unit 144, configured to send a notification that the task is ended to the server by the application.
And the application sends a notice of the task ending to the server. Specifically, after the application exports all data required by the user in the form of a file and sends the data to the server 10, the application sends a notification that all data are exported in the form of a file and sent to the server 10.
The report generation system provided by the embodiment of the invention is used for executing the report generation method, receiving a report export request sent by a user, and acquiring a data query condition according to the export request; inquiring data identification information matched with the inquiry condition from a database according to the inquiry condition, wherein the data identification information can identify each data in the database; generating a task corresponding to the data identification information according to a preset generation rule; sending the task to the server execution terminal so that the server execution terminal generates a corresponding file according to the task; and receiving the file uploaded by the server execution terminal and sending the file to the user terminal in a report form. Through the system, the data needing to be exported is exported through the server execution terminal 20, the memory overflow of the server 10 is effectively avoided, and the efficiency of exporting the data is improved.
The report generating system described above may be implemented in the form of a computer program that can be run on a computer device as shown in fig. 7.
Referring to fig. 7, fig. 7 is a schematic block diagram of a computer device according to an embodiment of the present invention.
Referring to fig. 7, the computer device 500 includes a processor 502, memory, and a network interface 505 connected by a system bus 501, where the memory may include a non-volatile storage medium 503 and an internal memory 504.
The non-volatile storage medium 503 may store an operating system 5031 and a computer program 5032. The computer program 5032, when executed, may cause the processor 502 to perform a blockchain-based information storage method.
The processor 502 is used to provide computing and control capabilities that support the operation of the overall computer device 500.
The internal memory 504 provides an environment for the execution of the computer program 5032 in the non-volatile storage medium 503, and when the computer program 5032 is executed by the processor 502, the processor 502 can be caused to execute the block chain-based information storage method.
The network interface 505 is used for network communication, such as providing transmission of data information. Those skilled in the art will appreciate that the configuration shown in fig. 7 is a block diagram of only a portion of the configuration associated with aspects of the present invention and is not intended to limit the computing device 500 to which aspects of the present invention may be applied, and that a particular computing device 500 may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
The processor 502 is configured to run a computer program 5032 stored in the memory to implement the information storage method based on the block chain according to the embodiment of the present application.
Those skilled in the art will appreciate that the embodiment of a computer device illustrated in fig. 7 does not constitute a limitation on the specific construction of the computer device, and that in other embodiments a computer device may include more or fewer components than those illustrated, or some components may be combined, or a different arrangement of components. For example, in some embodiments, the computer device may only include a memory and a processor, and in such embodiments, the structures and functions of the memory and the processor are consistent with those of the embodiment shown in fig. 7, and are not described herein again.
It should be understood that, in the embodiment of the present invention, the Processor 502 may be a Central Processing Unit (CPU), and the Processor 502 may also be other general purpose processors, Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field Programmable Gate Arrays (FPGAs) or other Programmable logic devices, discrete Gate or transistor logic devices, discrete hardware components, and the like. Wherein a general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
In another embodiment of the invention, a computer-readable storage medium is provided. The computer readable storage medium may be a non-volatile computer readable storage medium. The computer readable storage medium stores a computer program, and the computer readable storage medium is installed in the server 10 or the server execution terminal 20, wherein when executed by a processor, computer readable instructions in the server 10 implement a method executable by the server 10 in the report generation method according to the embodiment of the present application, and when executed by a processor, computer readable instructions in the server execution terminal 20 implement a method executable by the server execution terminal 20 in the report generation method according to the embodiment of the present application.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described apparatuses, systems and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again. Those of ordinary skill in the art will appreciate that the elements and algorithm steps of the examples described in connection with the embodiments disclosed herein may be embodied in electronic hardware, computer software, or combinations of both, and that the components and steps of the examples have been described in a functional general in the foregoing description for the purpose of illustrating clearly the interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
In the embodiments provided by the present invention, it should be understood that the disclosed apparatus, system, and method may be implemented in other ways. For example, the above-described system embodiments are merely illustrative, and for example, the division of the units is only a logical division, and there may be other divisions in actual implementation, or units with the same function may be grouped into one unit, for example, multiple units or components may be combined or integrated into another system, or some features may be omitted, or not executed. Further, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, systems or units, and may also be an electrical, mechanical or other form of connection.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment of the present invention.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention essentially contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product stored in a computer-readable storage medium, which includes several instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. The computer-readable storage medium is a physical non-transitory storage medium, the computer-readable storage medium is a non-volatile storage medium, and the computer-readable storage medium may be an internal storage unit of the foregoing device, for example, a physical storage medium such as a hard disk or a memory of the device. The storage medium may also be an external storage device of the device, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and other physical storage Media provided on the device.
While the invention has been described with reference to specific embodiments, the invention is not limited thereto, and various equivalent modifications and substitutions can be easily made by those skilled in the art within the technical scope of the invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.

Claims (10)

1. A report generation method is applied to a server, the server is communicated with a server execution terminal, and the method is characterized by comprising the following steps:
receiving a report export request sent by a user, and acquiring a data query condition according to the export request;
inquiring data identification information matched with the inquiry condition from a database according to the inquiry condition, wherein the data identification information can identify each data in the database;
generating a task corresponding to the data identification information according to a preset generation rule;
sending the task to the server execution terminal so that the server execution terminal generates a corresponding file according to the task; and
and receiving the file uploaded by the server execution terminal and sending the file to the user terminal in a report form.
2. The report generation method according to claim 1, wherein the generating a task corresponding to the data identification information according to a preset generation rule includes:
judging whether the data identification information accords with a preset slicing rule or not according to a preset judgment rule;
if the data identification information accords with a preset slicing rule, slicing the data identification information according to the preset slicing rule to obtain sliced data identification information;
and generating a corresponding task according to the sliced data identification information.
3. The report generation method according to claim 1, wherein the receiving the file uploaded by the server execution terminal and sending the file to the user terminal in the form of a report comprises:
receiving a file uploaded by the server execution terminal;
merging the files according to a preset merging rule to generate a merged file;
and sending the merged file to a user terminal in a report form.
4. A report generation method according to claim 3, before said merging said files according to a preset merging rule to generate a merged file, further comprising:
and receiving a notice of task ending sent by the server execution terminal.
5. A report generation method is applied to a server execution terminal and is characterized by comprising the following steps:
acquiring a task corresponding to a task processing request according to the task processing request from a server;
distributing the tasks to applications conforming to the tasks according to a preset scheduling rule;
calling the application to generate a corresponding file according to the task and sending the file to the server; and
and calling the application to send the notification of the task ending to the server.
6. A report generation system comprising a server and a server execution terminal, the server comprising:
the query condition acquisition unit is used for receiving a report export request sent by a user and acquiring a data query condition according to the export request;
the data generating unit is used for inquiring data identification information matched with the inquiry condition from a database according to the inquiry condition, wherein the data identification information can identify each data in the database;
the task generating unit is used for generating a task corresponding to the data identification information according to a preset generating rule;
the task sending unit is used for sending the task to the server execution terminal so that the server execution terminal generates a corresponding file according to the task; and
the report sending unit is used for receiving the file uploaded by the server execution terminal and sending the file to the user terminal in a report form;
the server execution terminal includes:
the task obtaining unit is used for obtaining a task corresponding to a task processing request according to the task processing request from the server;
the task allocation unit is used for allocating the tasks to the applications conforming to the tasks according to a preset scheduling rule;
the file sending unit is used for calling the application to generate a corresponding file according to the task and sending the file to the server;
and the ending notification unit is used for calling the application to send the notification of the task ending to the server.
7. A report generation system according to claim 6, characterized in that the task generation unit comprises:
the judging unit is used for judging whether the data identification information accords with a preset slicing rule or not according to a preset judging rule;
the segmentation unit is used for segmenting the data identification information according to a preset slicing rule to obtain the sliced data identification information if the data identification information accords with the preset slicing rule;
and the generating unit is used for generating the sliced data identification information into a corresponding task.
8. A report generation system according to claim 6, characterized in that the report transmission unit comprises:
the file receiving unit is used for receiving the file uploaded by the server execution terminal;
the file merging unit is used for merging the files according to a preset merging rule to generate a merged file;
and the sending unit is used for sending the combined file to the user terminal in a report form.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor is configured to execute the computer program to perform the steps of the method according to any one of claims 1 to 4 or to perform the steps of the method according to claim 5.
10. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program which, when executed by a processor, implements the steps of the method according to any one of claims 1-4, or implements the steps of the method according to claim 5.
CN201911327877.0A 2019-12-20 2019-12-20 Report generation method, system, computer equipment and computer readable storage medium Pending CN110991154A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911327877.0A CN110991154A (en) 2019-12-20 2019-12-20 Report generation method, system, computer equipment and computer readable storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911327877.0A CN110991154A (en) 2019-12-20 2019-12-20 Report generation method, system, computer equipment and computer readable storage medium

Publications (1)

Publication Number Publication Date
CN110991154A true CN110991154A (en) 2020-04-10

Family

ID=70073612

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911327877.0A Pending CN110991154A (en) 2019-12-20 2019-12-20 Report generation method, system, computer equipment and computer readable storage medium

Country Status (1)

Country Link
CN (1) CN110991154A (en)

Cited By (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111626866A (en) * 2020-05-22 2020-09-04 泰康保险集团股份有限公司 Data report processing method and device, electronic equipment and computer medium
CN111930772A (en) * 2020-07-30 2020-11-13 中粮招商局(深圳)粮食电子交易中心有限公司 Data export method, device and system and computer readable storage medium
CN112100134A (en) * 2020-08-25 2020-12-18 深圳市星砺达科技有限公司 Method and device for exporting large file, storage medium and computer equipment
CN112115693A (en) * 2020-09-25 2020-12-22 平安国际智慧城市科技股份有限公司 Method and device for exporting Word document with dynamic rendering chart and computer equipment
CN112541635A (en) * 2020-12-16 2021-03-23 平安养老保险股份有限公司 Service data statistical prediction method and device, computer equipment and storage medium
CN113297261A (en) * 2021-06-17 2021-08-24 中国农业银行股份有限公司 Early warning method and device for data processing, server and storage medium
CN113297222A (en) * 2021-05-25 2021-08-24 北京京东振世信息技术有限公司 Report data acquisition method and device, electronic equipment and storage medium
CN113761037A (en) * 2020-09-28 2021-12-07 西安京迅递供应链科技有限公司 Import and export method, device, server, medium and service system
CN115600567A (en) * 2022-10-14 2023-01-13 安芯网盾(北京)科技有限公司(Cn) Report exporting method and device

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103699618A (en) * 2013-12-16 2014-04-02 广东威创视讯科技股份有限公司 Data report generation method and system
CN108460140A (en) * 2018-03-13 2018-08-28 广州供电局有限公司 Equipment-patrolling report-generating method, device, system and computer equipment

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103699618A (en) * 2013-12-16 2014-04-02 广东威创视讯科技股份有限公司 Data report generation method and system
CN108460140A (en) * 2018-03-13 2018-08-28 广州供电局有限公司 Equipment-patrolling report-generating method, device, system and computer equipment

Cited By (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111626866A (en) * 2020-05-22 2020-09-04 泰康保险集团股份有限公司 Data report processing method and device, electronic equipment and computer medium
CN111626866B (en) * 2020-05-22 2023-08-01 泰康保险集团股份有限公司 Data report processing method and device, electronic equipment and computer medium
CN111930772A (en) * 2020-07-30 2020-11-13 中粮招商局(深圳)粮食电子交易中心有限公司 Data export method, device and system and computer readable storage medium
CN112100134A (en) * 2020-08-25 2020-12-18 深圳市星砺达科技有限公司 Method and device for exporting large file, storage medium and computer equipment
CN112115693A (en) * 2020-09-25 2020-12-22 平安国际智慧城市科技股份有限公司 Method and device for exporting Word document with dynamic rendering chart and computer equipment
CN113761037A (en) * 2020-09-28 2021-12-07 西安京迅递供应链科技有限公司 Import and export method, device, server, medium and service system
CN112541635A (en) * 2020-12-16 2021-03-23 平安养老保险股份有限公司 Service data statistical prediction method and device, computer equipment and storage medium
CN113297222A (en) * 2021-05-25 2021-08-24 北京京东振世信息技术有限公司 Report data acquisition method and device, electronic equipment and storage medium
CN113297261A (en) * 2021-06-17 2021-08-24 中国农业银行股份有限公司 Early warning method and device for data processing, server and storage medium
CN115600567A (en) * 2022-10-14 2023-01-13 安芯网盾(北京)科技有限公司(Cn) Report exporting method and device
CN115600567B (en) * 2022-10-14 2023-08-11 安芯网盾(北京)科技有限公司 Report export method and device

Similar Documents

Publication Publication Date Title
CN110991154A (en) Report generation method, system, computer equipment and computer readable storage medium
US10558498B2 (en) Method for scheduling data flow task and apparatus
CN110830577B (en) Service request call tracking method and device, computer equipment and storage medium
CN108683720B (en) Container cluster service configuration method and device
CN108959292B (en) Data uploading method, system and computer readable storage medium
CN102255926B (en) Method for allocating tasks in Map Reduce system, system and device
CN108491301B (en) Electronic device, abnormality early warning method based on redis and storage medium
CN111988419A (en) File uploading method, file downloading method, file uploading device, file downloading device, computer equipment and storage medium
CN111858055A (en) Task processing method, server and storage medium
CN111651595A (en) Abnormal log processing method and device
CN109167819B (en) Data synchronization system, method, device and storage medium
CN109327499B (en) Service interface management method and device, storage medium and terminal
CN112965809A (en) Deep learning task processing system and method
CN112396480B (en) Order business data processing method, system, computer equipment and storage medium
CN112052144B (en) Information management method, device, electronic equipment and storage medium
CN113656248A (en) PDM system file uploading process monitoring and capturing method, system, medium and device
CN111382141B (en) Master-slave architecture configuration method, device, equipment and computer readable storage medium
CN109885384B (en) Task parallelism optimization method and device, computer equipment and storage medium
CN109165135B (en) Data management method, computer readable storage medium and terminal equipment
CN116016653A (en) Information pushing method and device of blockchain, electronic equipment and storage medium
CN115221041A (en) Multi-device testing method and device, electronic device and storage medium
CN106776597B (en) Structured data downloading method and device
CN114675954A (en) Task scheduling method and device
CN109040990B (en) Information acquisition method and device, computer equipment and storage medium
CN109033189B (en) Compression method and device of link structure log, server and readable storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination