CN114281848A - Report generation method and device, computer equipment, storage medium and program product - Google Patents

Report generation method and device, computer equipment, storage medium and program product Download PDF

Info

Publication number
CN114281848A
CN114281848A CN202111573684.0A CN202111573684A CN114281848A CN 114281848 A CN114281848 A CN 114281848A CN 202111573684 A CN202111573684 A CN 202111573684A CN 114281848 A CN114281848 A CN 114281848A
Authority
CN
China
Prior art keywords
report
target
temporary file
query
data
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
CN202111573684.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.)
Zhejiang Taimei Medical Technology Co Ltd
Original Assignee
Zhejiang Taimei Medical Technology 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 Zhejiang Taimei Medical Technology Co Ltd filed Critical Zhejiang Taimei Medical Technology Co Ltd
Priority to CN202111573684.0A priority Critical patent/CN114281848A/en
Publication of CN114281848A publication Critical patent/CN114281848A/en
Pending legal-status Critical Current

Links

Images

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The embodiment of the specification provides a report generation method and device, computer equipment, a storage medium and a computer program product. The method comprises the steps of determining a target temporary file corresponding to a first report query request in a local temporary file set by receiving the first report query request aiming at a target report template; acquiring the target query data from the target temporary file; and filling the target query data into the target report template to obtain a target report. The generated report data of the target report is stored in a local temporary file, so that the occupation of the report data on a memory is reduced, and when a report query request aiming at the target report template is received again, the report data can be directly obtained from the temporary file, so that the report query performance is improved, and the report query efficiency is improved.

Description

Report generation method and device, computer equipment, storage medium and program product
Technical Field
Embodiments of the present description relate to the field of computer technologies, and in particular, to a report generation method, an apparatus, a computer device, a storage medium, and a computer program product.
Background
The report can clearly show the relationship between the filled data, so the report plays an important role in various fields. In the using process of the report, the server executes a Structured Query Language (SQL) statement, and queries the data in the report based on the SQL statement.
In the conventional technology, if SQL association is complex (such as multi-table nested association) or a small number of data sets are obtained from massive data through complex calculation, data query will consume relatively large resources (such as CPU, memory).
Disclosure of Invention
In view of this, embodiments of the present disclosure provide a report generating method, apparatus, computer device, storage medium, and computer program product, so as to solve the technical problem that data query occupies relatively large resources in the conventional technology.
An embodiment of the present specification provides a report generation method, including: receiving a first report query request aiming at a target report template; determining a target temporary file corresponding to the first report form query request in a local temporary file set; wherein the temporary file set comprises a plurality of temporary files; the target temporary file is provided with target query data generated when a second report query request aiming at the target report template is executed; the second report inquiry request is executed before the first report inquiry request; acquiring the target query data from the target temporary file; and filling the target query data into the target report template to obtain a target report.
In some embodiments, the first report query request is attached with a report identifier of the target report template; before the receiving the first report query request for the target report template, the method further comprises: receiving the second report inquiry request aiming at the target report template; the second report query request is attached with the report identifier; inquiring in a database according to the second report inquiry request to obtain the target inquiry data; generating the target temporary file based on the target query data; the target temporary file is named by the report identifier; determining a target temporary file corresponding to the first report query request in the local temporary file set, including: and searching in the local temporary file set according to the report identifier attached to the first report query request to obtain a target temporary file named by the report identifier.
In some embodiments, after the receiving the first report query request for the target report template, the method further comprises: and if the target temporary file corresponding to the first report query request is not searched in the local temporary file set, querying in a database according to the first report query request to obtain the target query data.
In some embodiments, the method further comprises: and persistently storing the target query data into a local memory to generate the target temporary file.
In some embodiments, the obtaining the target query data from the target temporary file includes: reading file content data from the target temporary file; and performing deserialization processing on the read file content data to obtain the target query data.
In some embodiments, the method further comprises: acquiring the creation time and the current time of each temporary file; determining the local storage time of each temporary file based on the creation time and the current time; and if the storage duration of any temporary file exceeds a duration threshold, deleting the temporary file from the local.
In some embodiments, the method further comprises: acquiring the access request times of each temporary file; setting a time length threshold value of each temporary file according to the access request times of each temporary file; and if the storage duration of any temporary file exceeds a duration threshold, deleting the temporary file from the local.
An embodiment of the present specification provides a report generation apparatus, including: the query request receiving module is used for receiving a first report query request aiming at the target report template; the target file determining module is used for determining a target temporary file corresponding to the first report form query request in a local temporary file set; wherein the temporary file set comprises a plurality of temporary files; the target temporary file is provided with target query data generated when a second report query request aiming at the target report template is executed; the second report inquiry request is executed before the first report inquiry request; the target data acquisition module is used for acquiring the target query data from the target temporary file; and the target report generation module is used for filling the target query data into the target report template to obtain a target report.
The present specification provides a computing device, comprising a memory and a processor, wherein the memory stores a computer program, and the processor implements the method steps of the above embodiments when executing the computer program.
The present specification provides a computer readable storage medium, on which a computer program is stored, which when executed by a processor implements the method steps in the above embodiments.
The present specification embodiments provide a computer program product, which includes instructions that, when executed by a processor of a computer device, enable the computer device to perform the method steps in the above embodiments.
In an embodiment of the present specification, a first report query request for a target report template is received, and a target temporary file corresponding to the first report query request is determined in a local temporary file set; acquiring the target query data from the target temporary file; and filling the target query data into the target report template to obtain a target report. The generated report data of the target report is stored in a local temporary file, so that the occupation of the report data on a memory is reduced, and when a report query request aiming at the target report template is received again, the report data can be directly obtained from the temporary file, so that the report query performance is improved, and the report query efficiency is improved.
Drawings
Fig. 1 is an application environment diagram of a report generation method according to an embodiment;
fig. 2 is a schematic flow chart illustrating a report generation method according to an embodiment;
fig. 3 is a schematic flow chart illustrating a report generation method according to an embodiment;
fig. 4 is a schematic flow chart illustrating a report generation method according to an embodiment;
FIG. 5 is a flowchart illustrating a report generation method according to an embodiment;
FIG. 6 is a flowchart illustrating a report generation method according to an embodiment;
fig. 7 is a block diagram illustrating a structure of a report generation apparatus according to an embodiment;
fig. 8 is a diagram illustrating an internal structure of a computer device according to an embodiment.
Detailed Description
The technical solutions in the embodiments of the present disclosure will be clearly and completely described below with reference to the drawings in the embodiments of the present disclosure, and it is obvious that the described embodiments are only a part of the embodiments of the present disclosure, and not all of the embodiments. All other embodiments obtained by a person of ordinary skill in the art without any inventive work based on the embodiments in the present specification belong to the protection scope of the present specification.
Referring to fig. 1, an embodiment of the present disclosure provides a report generation system, and the report generation method provided by the present disclosure is applied to the report generation system. The report generating system may include a hardware environment formed by the terminal 110 and the server 120. The terminal 110 communicates with the server 120 through a network. The server 120 receives a first report query request for the target report template; determining a target temporary file corresponding to the first report form query request in a local temporary file set; wherein, the temporary file set comprises a plurality of temporary files; the target temporary file is provided with target query data generated when a second report query request aiming at the target report template is executed; the second report form query request is executed before the first report form query request; acquiring target query data from the target temporary file; and filling the target query data into a target report template to obtain a target report.
The terminal 110 may be, but is not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices. The server 120 may be implemented as a stand-alone server or a server cluster composed of a plurality of servers. With the development of scientific technology, new computing devices, such as quantum computing servers, may be developed, and may also be applied to the embodiments of the present specification.
Referring to fig. 2, an embodiment of the present disclosure provides a report generating method. The report generation method may include the following steps.
S210, receiving a first report query request aiming at the target report template.
The target report template can be understood as a report template meeting the actual requirements of the user. The target report template defines which fields of data are obtained from the database and in which arrangement format the obtained data are presented. The report query request may be computer instructions for obtaining report data from a database. Further, the first report query request for the target report template may be a query instruction for obtaining data related to the target report template from the database.
Specifically, several report templates may be provided in the user interface of the terminal. The report template has a fixed report structure. The report template may be a predefined format file for generating a table. The user may specify a target report template among several report templates in conjunction with the actual demand for the report structure. After the target report template is appointed, the terminal sends a first report query request to the server, wherein the first report query request is used for acquiring field data related to the target report template from the database.
S220, determining a target temporary file corresponding to the first report form query request in the local temporary file set.
And S230, acquiring target query data from the target temporary file.
Wherein, the temporary file set comprises a plurality of temporary files. In some embodiments, the set of temporary files may be stored in local persistent memory. Persistent memory (PMEM), also known as non-volatile memory (NVM), can keep data from being lost even after power is removed, and is used by applications that are sensitive to downtime and require high performance. In some embodiments, the temporary set of files may be stored locally on disk. The temporary files in the temporary file set keep the data stored in the temporary files from being lost after power failure. Although the temporary files in the temporary file set are not cleared immediately after the corresponding application program exits or stops running, the temporary files in the temporary file set can be periodically cleared periodically to release the storage space occupied by the temporary files.
And the target temporary file is provided with target query data generated when a second report query request aiming at the target report template is executed. The second report query request for the target report template may be a query instruction for obtaining target query data from the database, the target query data satisfying the target report template. The second report query request is executed prior to the first report query request. That is, the second report query request has been received before the first report query request is received. And acquiring target query data meeting the target report template format from the database according to the second report query request, and storing the target query data locally in the form of a temporary file.
Specifically, before the first report query request is received, other report query requests may have been received, query is performed in the database according to the other report query requests, query data satisfying the other report query requests is obtained, and the query data is stored locally in the form of a temporary file, so that a temporary file set is provided locally. And if the report query is detected to be performed on the target report template in advance, storing the target query data meeting the target report template in the target temporary file, and determining the target temporary file corresponding to the first report query request in the local temporary file set. Further, the target query data may be directly read from the target temporary file, or may be indirectly obtained from the target temporary file. For example, file content data is read from the target temporary file, and the file content data needs to be processed, such as format adjustment, and the processed file content is processed as target query data.
In some embodiments, the query data is stored locally in the form of a temporary file, the temporary file may be marked based on the report template, for example, a correspondence between the temporary file and the report template is established, and when a report query request for any report template is received, whether a temporary file for any report template exists in a local temporary file set is determined based on the correspondence between the temporary file and the report template.
And S240, filling the target query data into the target report template to obtain a target report.
The target report template is blank and has a data structure, and the data structure can be understood as the presentation form of the report data required by the target report template. Specifically, target query data is obtained from a database, a target report template requires a presentation form of report data, and the target query data is filled into the target report template according to the presentation form required by the target report template to generate a target report.
The report generation method comprises the steps of determining a target temporary file corresponding to a first report query request in a local temporary file set by receiving the first report query request aiming at a target report template; acquiring target query data from the target temporary file; and filling the target query data into a target report template to obtain a target report. The generated report data of the target report is stored in a local temporary file, so that the occupation of the report data on a memory is reduced, and when a report query request aiming at the target report template is received again, the report data can be directly obtained from the temporary file, so that the report query performance is improved, and the report query efficiency is improved.
In some embodiments, the first report query is accompanied by a report identification of the target report template. Referring to FIG. 3, prior to receiving a first report query request for a target report template, the method can further include the following steps.
S310, receiving a second report form query request aiming at the target report form template.
And the second report form query request is attached with a report form identifier. Specifically, several report templates may be provided in the user interface of the terminal. The user may specify a target report template among several report templates in conjunction with the actual demand for the report structure. After the target report template is appointed, the terminal sends a second report query request to the server, and the second report query request is used for acquiring field data related to the target report template from the database.
And S320, inquiring in the database according to the second report inquiry request to obtain target inquiry data.
S330, generating a target temporary file based on the target query data.
Wherein, the target temporary file is named by the report identifier. Specifically, the second report query request has pertinence to the target report template, and therefore, based on the second query request, it can be determined which data needs to be acquired from the database as query data for generating the report. Therefore, the query is carried out in the database according to the second report query request, and the target query data can be obtained. And storing the target query data obtained by query to a target temporary file. Further, the target temporary file is generated based on the second report query request, and the second report query request is accompanied by the report identifier, so that the corresponding relationship between the target temporary file and the report identifier can be generated.
Determining a target temporary file corresponding to the first report query request in the local temporary file set may include the following steps.
S340, searching in the local temporary file set according to the report identifier attached to the first report query request to obtain a target temporary file named by the report identifier.
Specifically, the temporary file may be marked based on any report identifier of any report template, for example, a corresponding relationship between any report identifier of any report template and the temporary file is established, when a first report query request for a target report template is received, a query is performed according to the corresponding relationship between the report identifier and the temporary file of the report identifier carried in the first report query request, and whether the target temporary file corresponding to the report identifier exists in a local temporary file set is determined.
In some embodiments, when a report query request for any report template is received, a query is performed according to a correspondence between any report identifier carried in the report query request and a temporary file, and whether a temporary file corresponding to any report identifier exists in a local temporary file set is determined.
In this embodiment, the target query data corresponding to the second report query request is stored in the local temporary file, instead of being based on the memory, and compared with the memory with a small capacity, more report data can be stored, thereby improving the report query performance.
In some embodiments, after receiving the first report query request for the target report template, the report generation method may further include: and if the target temporary file corresponding to the first report query request is not searched in the local temporary file set, querying in a database according to the first report query request to obtain target query data.
Specifically, a first report query request for a target report template is received, whether a target temporary file corresponding to the first report query request exists is detected in a local temporary file set, and if the target temporary file corresponding to the first report query request is not searched, which data need to be acquired from a database as query data for generating a report can be determined based on the first query request. Therefore, the query is carried out in the database according to the first report query request, and the target query data can be obtained. Further, the target query data is stored in a local memory in a persistent mode, and a target temporary file is generated. The target temporary file is generated based on the first report query request, and the report identifier is attached to the first report query request, so that the corresponding relation between the target temporary file and the report identifier can be generated.
In some embodiments, the first report query request is accompanied by a report identifier of the target report template, and the report identifier accompanied by the first report query request is searched in a corresponding relationship between the temporary file and the report identifier, and it is determined that there is no target temporary file corresponding to the report identifier accompanied by the first report query request, so that the first report query request is queried in the database to obtain target query data.
In this embodiment, if the target temporary file corresponding to the first report query request is not searched in the local temporary file set, the corresponding report data may be further acquired from the database, and the target report may be generated in time.
In some embodiments, referring to fig. 4, obtaining the target query data from the target temporary file may include the following steps.
And S410, reading file content data from the target temporary file.
And S420, performing deserialization processing on the read file content data to obtain target query data.
Where serialization is the process of converting query data obtained from a database into a form that can be stored or transmitted. During serialization, query data retrieved from the database is written from the current state to a temporary or persistent store. Specifically, after a target temporary file corresponding to the first report query request is determined in the local temporary file set, file content data is read from the target temporary file, and the file content data needs to be re-created to meet the requirement of the application program, so that the read file content data is subjected to deserialization processing to obtain target query data.
In some embodiments, referring to fig. 5, the report generation method may further include the following steps.
And S510, acquiring the creation time and the current time of each temporary file.
S520, determining the storage time of each temporary file in the local area based on the creation time and the current time.
S530, if the storage time of any temporary file exceeds a time threshold, deleting any temporary file from the local.
Compared with the memory, the space of the disk or the persistent memory is larger, but as time goes on, the temporary files increase, and the occupied storage space needs to be released, so that a part of the temporary files in the local temporary file set needs to be periodically cleared. Specifically, the creation time of the temporary file is stored when the temporary file is generated. And acquiring the creation time and the current time of each temporary file. And subtracting the creation time and the current time from the current time to obtain the local storage time of each temporary file. The method comprises the steps of obtaining a preset time length threshold value of a temporary file, comparing the storage time length of any temporary file with the time length threshold value, and deleting any temporary file from the local if the storage time length of any temporary file exceeds the time length threshold value.
In the embodiment, the local storage space can be cleared in time through a mechanism for regularly clearing the temporary file, so that the actual query requirement is further met, and the query performance is improved.
In some embodiments, referring to fig. 6, the report generation method may further include the following steps.
S610, obtaining the access request times of each temporary file.
S620, setting a time length threshold value of each temporary file according to the access request times of each temporary file.
And S630, if the storage time of any temporary file exceeds a time threshold, deleting any temporary file from the local.
The access request times of each temporary file are different, the access request times of partial temporary files are more, the access request times of partial temporary files are less, and the storage strategy of each temporary file is formulated according to the access request times of the temporary files. Specifically, the access request times of the temporary files are obtained after counting the access request times of the temporary files. And judging whether the access request times of the temporary files meet preset conditions or not, and if the access request times of any temporary file meet the preset conditions, storing any temporary file into a local memory. In some embodiments, the local storage may be a local disk, which may be persistent memory. The predetermined condition may be set in association with an actual situation, for example, in association with a space size of a local memory. In some embodiments, the time length threshold of each temporary file is set according to the access request times of each temporary file. And if the storage duration of any temporary file exceeds a duration threshold, deleting any temporary file from the local.
In the embodiment, the storage strategy of each temporary file is flexibly set according to the access request times of each temporary file, and the stored temporary files are ensured to meet the actual query requirements.
The embodiment of the specification provides a report generation method, which can comprise the following steps.
S702, receiving a second report form query request aiming at the target report form template.
And the second report form query request is attached with a report form identifier.
And S704, inquiring in the database according to the second report inquiry request to obtain target inquiry data.
S706, generating a target temporary file based on the target query data; wherein, the target temporary file is named by the report identifier.
S708, receiving a first report query request aiming at the target report template.
S710, searching in the local temporary file set according to the report identifier attached to the first report query request to obtain a target temporary file named by the report identifier.
Wherein, the temporary file set comprises a plurality of temporary files; the target temporary file is provided with target query data generated when a second report query request aiming at the target report template is executed; the second report query request is executed prior to the first report query request.
In some embodiments, if the target temporary file corresponding to the first report query request is not searched in the local temporary file set, the query is performed in the database according to the first report query request to obtain the target query data. And storing the target query data into a local memory in a persistent mode to generate a target temporary file.
And S712, reading the file content data from the target temporary file.
And S714, performing deserialization processing on the read file content data to obtain target query data.
S716, obtaining the access request times of each temporary file.
S718, setting a time length threshold value of each temporary file according to the access request times of each temporary file.
S720, acquiring the creation time and the current time of each temporary file.
And S722, determining the storage time of each temporary file in the local area based on the creation time and the current time.
S724, if the storage time length of any temporary file exceeds a time length threshold value, deleting any temporary file from the local.
It should be understood that, although the steps in the above-described flowcharts are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a part of the steps in the above-mentioned flowcharts may include a plurality of steps or a plurality of stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of performing the steps or the stages is not necessarily performed in sequence, but may be performed alternately or alternately with other steps or at least a part of the steps or the stages in other steps.
Referring to fig. 7, an embodiment of the present disclosure provides a report generating apparatus 700. The report generating apparatus 700 includes a query request receiving module 710, a target file determining module 720, a target data obtaining module 730, and a target report generating module 740.
A query request receiving module 710, configured to receive a first report query request for a target report template;
a target file determining module 720, configured to determine a target temporary file corresponding to the first report query request in the local temporary file set; wherein, the temporary file set comprises a plurality of temporary files; the target temporary file is provided with target query data generated when a second report query request aiming at the target report template is executed; the second report form query request is executed before the first report form query request;
a target data obtaining module 730, configured to obtain target query data from the target temporary file;
and the target report generation module 740 is configured to fill the target query data into the target report template to obtain a target report.
For the specific definition of the report generation apparatus, reference may be made to the above definition of the report generation method, which is not described herein again. All or part of the modules in the report generation device can be realized by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In some embodiments, a computer device is provided, which may be a terminal, and its internal structure diagram may be as shown in fig. 8. The computer device includes a processor, a memory, a communication interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless communication can be realized through WIFI, an operator network, NFC (near field communication) or other technologies. The computer program is executed by a processor to implement a report generating method. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.
Those skilled in the art will appreciate that the architecture shown in fig. 8 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing device to which the disclosed aspects apply, and that a computing device may in particular include more or less components than those shown, or combine certain components, or have a different arrangement of components.
In some embodiments, a computer device is provided, comprising a memory having a computer program stored therein and a processor that, when executing the computer program, performs the method steps of the above embodiments.
In some embodiments, a computer-readable storage medium is provided, on which a computer program is stored, which when executed by a processor implements the method steps in the above-described embodiments.
In some embodiments, a computer program product is also provided, which comprises instructions that are executable by a processor of a computer device to implement the method steps in the above-described embodiments.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the various embodiments provided herein can include at least one of non-volatile and volatile memory. Non-volatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical storage, or the like. Volatile Memory can include Random Access Memory (RAM) or external cache Memory. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM), among others.
The features of the above embodiments may be arbitrarily combined, and for the sake of brevity, all possible combinations of the features in the above embodiments are not described, but should be construed as being within the scope of the present specification as long as there is no contradiction between the combinations of the features.
The above description is only for the purpose of illustrating the preferred embodiments of the present disclosure and is not to be construed as limiting the present disclosure, and any modifications, equivalents and the like that are within the spirit and principle of the present disclosure are intended to be included within the scope of the present disclosure.

Claims (11)

1. A report generation method is characterized by comprising the following steps:
receiving a first report query request aiming at a target report template;
determining a target temporary file corresponding to the first report form query request in a local temporary file set; wherein the temporary file set comprises a plurality of temporary files; the target temporary file is provided with target query data generated when a second report query request aiming at the target report template is executed; the second report inquiry request is executed before the first report inquiry request;
acquiring the target query data from the target temporary file;
and filling the target query data into the target report template to obtain a target report.
2. The method according to claim 1, wherein the first report query request is accompanied by a report identification of the target report template; before the receiving the first report query request for the target report template, the method further comprises:
receiving the second report inquiry request aiming at the target report template; the second report query request is attached with the report identifier;
inquiring in a database according to the second report inquiry request to obtain the target inquiry data;
generating the target temporary file based on the target query data; the target temporary file is named by the report identifier;
determining a target temporary file corresponding to the first report query request in the local temporary file set, including:
and searching in the local temporary file set according to the report identifier attached to the first report query request to obtain a target temporary file named by the report identifier.
3. The method of claim 1, wherein after the receiving a first report query request for a target report template, the method further comprises:
and if the target temporary file corresponding to the first report query request is not searched in the local temporary file set, querying in a database according to the first report query request to obtain the target query data.
4. The method of claim 3, further comprising:
and persistently storing the target query data into a local memory to generate the target temporary file.
5. The method of claim 1, wherein the obtaining the target query data from the target temporary file comprises:
reading file content data from the target temporary file;
and performing deserialization processing on the read file content data to obtain the target query data.
6. The method of claim 1, further comprising:
acquiring the creation time and the current time of each temporary file;
determining the local storage time of each temporary file based on the creation time and the current time;
and if the storage duration of any temporary file exceeds a duration threshold, deleting the temporary file from the local.
7. The method of claim 1, further comprising:
acquiring the access request times of each temporary file;
setting a time length threshold value of each temporary file according to the access request times of each temporary file;
and if the storage duration of any temporary file exceeds a duration threshold, deleting the temporary file from the local.
8. A report generation apparatus, characterized in that the apparatus comprises:
the query request receiving module is used for receiving a first report query request aiming at the target report template;
the target file determining module is used for determining a target temporary file corresponding to the first report form query request in a local temporary file set; wherein the temporary file set comprises a plurality of temporary files; the target temporary file is provided with target query data generated when a second report query request aiming at the target report template is executed; the second report inquiry request is executed before the first report inquiry request;
the target data acquisition module is used for acquiring the target query data from the target temporary file;
and the target report generation module is used for filling the target query data into the target report template to obtain a target report.
9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor, when executing the computer program, implements the steps of the method of any of claims 1 to 7.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
11. A computer program product comprising instructions, characterized in that said instructions, when executed by a processor of a computer device, enable said computer device to perform the steps of the method according to any one of claims 1 to 7.
CN202111573684.0A 2021-12-21 2021-12-21 Report generation method and device, computer equipment, storage medium and program product Pending CN114281848A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111573684.0A CN114281848A (en) 2021-12-21 2021-12-21 Report generation method and device, computer equipment, storage medium and program product

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111573684.0A CN114281848A (en) 2021-12-21 2021-12-21 Report generation method and device, computer equipment, storage medium and program product

Publications (1)

Publication Number Publication Date
CN114281848A true CN114281848A (en) 2022-04-05

Family

ID=80873602

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111573684.0A Pending CN114281848A (en) 2021-12-21 2021-12-21 Report generation method and device, computer equipment, storage medium and program product

Country Status (1)

Country Link
CN (1) CN114281848A (en)

Similar Documents

Publication Publication Date Title
US20160357740A1 (en) Metadata Updating Method and Apparatus Based on Columnar Storage in Distributed File System, and Host
CN110427386B (en) Data processing method, device and computer storage medium
CN104035938A (en) Performance continuous integration data processing method and device
CN112506486A (en) Search system establishing method and device, electronic equipment and readable storage medium
CN111885184A (en) Method and device for processing hot spot access keywords in high concurrency scene
CN111913917A (en) File processing method, device, equipment and medium
CN111400578B (en) Cargo data query method, cargo data query device, computer equipment and storage medium
CN110222046B (en) List data processing method, device, server and storage medium
CN115470156A (en) RDMA-based memory use method, system, electronic device and storage medium
CN112866339B (en) Data transmission method and device, computer equipment and storage medium
CN116991800A (en) File acquisition system, method, device, computer equipment and storage medium
CN112511612A (en) Cloud storage data storage method, device, system, equipment and storage medium
CN114281848A (en) Report generation method and device, computer equipment, storage medium and program product
CN113515518A (en) Data storage method and device, computer equipment and storage medium
CN110851452B (en) Data table connection processing method and device, electronic equipment and storage medium
CN116185578A (en) Scheduling method of computing task and executing method of computing task
CN112783866B (en) Data reading method, device, computer equipment and storage medium
CN112818021B (en) Data request processing method, device, computer equipment and storage medium
CN112800123A (en) Data processing method, data processing device, computer equipment and storage medium
CN115809015A (en) Method for data processing in distributed system and related system
CN107679093B (en) Data query method and device
CN111782834A (en) Image retrieval method, device, equipment and computer readable storage medium
CN111475535A (en) Data storage and access method and device
CN110442447B (en) Message queue-based load balancing method and device and computer equipment
CN111046241B (en) Graph storage method and device for flow graph processing

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