CN110413610B - Method and system for improving export efficiency of business data report forms and database server - Google Patents
Method and system for improving export efficiency of business data report forms and database server Download PDFInfo
- Publication number
- CN110413610B CN110413610B CN201910529385.3A CN201910529385A CN110413610B CN 110413610 B CN110413610 B CN 110413610B CN 201910529385 A CN201910529385 A CN 201910529385A CN 110413610 B CN110413610 B CN 110413610B
- Authority
- CN
- China
- Prior art keywords
- report
- business data
- export
- data report
- database server
- 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.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application relates to a method and a system for improving export efficiency of a business data report and a database server. The method for improving the export efficiency of the business data report comprises the following steps: according to the scheme, the database server generates the responsive business data report in advance through the export rule in the preset time, sends all the business data reports to the download server, establishes the mapping relation between the report export interfaces of the user terminals and the corresponding business data reports, and exports the business data reports. When the user terminal sends a request for exporting the business data report, the user can directly download the business data report from the download server through the user terminal, so that the efficiency of the database server for processing the business data report of each user is improved, the storage capacity of the database server is reduced, the exporting efficiency of the user in a large amount of data is improved, and the user experience is further improved.
Description
Technical Field
The present application relates to the field of internet technologies, and in particular, to a method and system for improving service data report export efficiency, a database server, and a storage medium.
Background
At present, when a large amount of data is exported, a user sends a data export request through a browser, after receiving the request, a server queries data from a database through query sentences, the database returns the queried result to the server, the server reorganizes the returned result and then sends the returned result to the user, along with the use of a system, the number of accumulated and stored data is increased, and the requirement cannot be met by exporting a large amount of data in a synchronous mode.
When users are more and more, the stored data volume is more and more, and when the user derives from a large amount of data after a certain data volume is reached, the server can also be slower and slower when inquiring the data, and meanwhile, the memory capacity of the server is huge, and the server cannot process the data. When the response time of the request is too long, a response timeout of the server occurs, which may cause failure of exporting data. In addition, when a large amount of data is exported, the processing time is long, the reaction is slow, the stay time of a user on a page after the user requests to submit is long, and the user experience is quite bad.
Disclosure of Invention
The application mainly solves the technical problem of providing a method and a system for improving the export efficiency of a business data report and a database server, and can solve the problems of long processing time and slow response when a user exports a large amount of data.
In order to solve the above technical problems, the embodiments of the present application provide a method, a system, and a database server for improving the export efficiency of a business data report, which adopt the following technical schemes:
a method for improving the export efficiency of a business data report comprises the following steps:
the database server pre-generates a corresponding business data report according to a preset export rule of each user terminal in preset time;
all the business data reports are sent to a download server;
and establishing a mapping relation between a report export interface of each user terminal and the corresponding business data report, and exporting the business data report.
When the business data report is a daily report, the database server calculates and processes the business data report of the current day in the range of 0:00-8:00 of the next day; when the business data report is a weekly report, the database server calculates and processes the business data report of the week in the range of 0:00-8:00 of the next day of the week; when the business data report is a month report, the database server calculates and processes the business data report of the month in the next day of each month from 0:00 to 8:00.
The database server acquires the business data report and the corresponding report export interfaces of different user terminals, determines the priority of the user terminals according to the report export interfaces of the different user terminals, and performs priority processing on the user terminals with high priority.
If the database server identifies that the report export interface of the user terminal is a leading terminal, determining the priority of the user terminal as a first priority; and if the database server identifies that the report export interface of the user terminal is an employee terminal, determining the priority of the user terminal as a second priority.
And deleting all the business data reports when the preset time is exceeded.
And acquiring a export request of the business data report, re-inquiring by the database server, generating a new data report and sending the new data report to the download server.
And the database server sends a download address to the user terminal through the report export interface of the user terminal corresponding to the service data report.
In order to solve the above technical problems, the embodiment of the present application further provides a database server, which adopts the following technical schemes:
the generation module is used for the database server to pre-generate a corresponding service data report according to the preset export rule of each user terminal in preset time;
the sending module is used for sending all the business data reports to a download server;
and the export module is used for establishing the mapping relation between the report export interfaces of the user terminals and the corresponding business data reports and exporting the business data reports.
In order to solve the above technical problems, the embodiment of the present application further provides a system for improving the export efficiency of a business data report, which adopts the following technical scheme:
a system for improving the export efficiency of a business data report comprises a memory and a processor, wherein a computer program is stored in the memory, and the processor realizes the method for improving the export efficiency of the business data report when executing the computer program.
In order to solve the above technical problems, an embodiment of the present application further provides a computer readable storage medium, which adopts the following technical schemes:
a computer readable storage medium, wherein a computer program is stored on the computer readable storage medium, and the computer program when executed by a processor implements the method for improving the efficiency of exporting a business data report according to any one of the above.
Compared with the prior art, the embodiment of the application has the following main beneficial effects:
according to the scheme, the database server generates the responsive business data report in advance through the export rule in the preset time, sends all the business data reports to the download server, establishes the mapping relation between the report export interfaces of the user terminals and the corresponding business data reports, and exports the business data reports. When the user terminal sends a request for exporting the business data report, the user can directly download the business data report from the download server through the user terminal, so that the efficiency of the database server for processing the business data report of each user is improved, the storage capacity of the database server is reduced, the exporting efficiency of the user in a large amount of data is improved, and the user experience is further improved.
Drawings
In order to more clearly illustrate the solution of the present application, a brief description will be given below of the drawings required for the description of the embodiments of the present application, it being apparent that the drawings in the following description are some embodiments of the present application, and that other drawings may be obtained from these drawings without the exercise of inventive effort for a person of ordinary skill in the art.
FIG. 1 is a flow chart of an embodiment of a method for improving export efficiency of a business data report according to the present application;
FIG. 2 is a flowchart illustrating another embodiment of a method for improving export efficiency of a business data report according to the present application;
FIG. 3 is a schematic diagram illustrating the structure of a database server according to an embodiment of the present application;
FIG. 4 is a schematic diagram of another embodiment of a database server according to the present application;
FIG. 5 is a schematic diagram illustrating one embodiment of a system for improving business data report export efficiency in accordance with the present application.
Detailed Description
Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application belongs; the terminology used in the description of the application herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the application; the terms "comprising" and "having" and any variations thereof in the description of the application and the claims and the description of the drawings above are intended to cover a non-exclusive inclusion. The terms first, second and the like in the description and in the claims or in the above-described figures, are used for distinguishing between different objects and not necessarily for describing a sequential or chronological order.
Reference herein to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment may be included in at least one embodiment of the application. The appearances of such phrases in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. Those of skill in the art will explicitly and implicitly appreciate that the embodiments described herein may be combined with other embodiments.
In order to make the person skilled in the art better understand the solution of the present application, the technical solution of the embodiment of the present application will be clearly and completely described below with reference to the accompanying drawings.
Referring to fig. 1, fig. 1 is a flow chart of a method for improving the export efficiency of a business data report according to an embodiment of the present application, and it should be noted that, if there are substantially the same results, the method of the present application is not limited to the flow sequence shown in fig. 1, and the method includes the following steps:
s101: and the database server pre-generates a corresponding business data report according to the preset export rule of each user terminal in preset time.
Wherein the database server: one or more computers running in the local area network and the database management system software together form a database server that provides services for user applications, such as querying, updating, transaction management, indexing, caching, query optimization, security, and multiuser access control. And the database server queries and processes the data in a preset time, and generates a corresponding business data report in advance according to a preset export rule of each user terminal. The user terminal can be a mobile phone, a computer, an electronic device, etc.
The preset export rule: when the business data report is a daily report, the database server calculates and processes the business data report of the current day in the range of 0:00-8:00 of the next day; when the business data report is a weekly report, the database server calculates and processes the business data report of the week in the range of 0:00-8:00 of the next day of the week; when the business data report is a month report, the database server calculates and processes the business data report of the month in the range of 0:00-8:00 of the next day of each month. The database server performs periodic operation according to the priorities of different user terminals, and performs priority processing on the user terminals with high priority levels.
The database server acquires the business data report and the report export interfaces of the corresponding different user terminals, determines the priority of the user terminals according to the report export interfaces of the different user terminals, and performs priority processing on the user terminals with high priority.
If the database server identifies that the report export interface of the user terminal is the leading terminal, determining the priority of the user terminal as a first priority; and if the database server identifies that the report export interface of the user terminal is the employee terminal, determining the priority of the user terminal as the second priority.
The method comprises the steps that report export interfaces of different corresponding user terminals are divided into a leader terminal and employee terminals, a database server obtains business data reports and report export interfaces of the leader terminals corresponding to the business data reports, and if more business data reports need to be processed by the corresponding leader terminals, priority inquiry and processing are carried out, and corresponding business data reports are generated. The database server acquires the business data report and the report export interface of the corresponding employee terminal, and the corresponding employee terminal has less business data report to be processed, and after the business data report of the leading terminal is preferentially processed, the business data report of the employee terminal is correspondingly inquired and processed, and the corresponding business data report is generated.
S102: and sending all the business data reports to a download server.
The database server generates a business data report in advance according to a preset export rule of each user terminal, and sends all business data reports to the download server. The business data report can be divided into a daily report, a weekly report and a monthly report.
S103: and establishing a mapping relation between the report export interfaces of the user terminals and the corresponding business data reports, and exporting the business data reports.
And establishing mapping relations between report export interfaces corresponding to the user terminals and corresponding business data reports, and exporting the business data reports. And the database server analyzes the identity information of the user, and sends the business data report corresponding to the user account to the download server together, and the download server derives the corresponding business data report through the user account.
In this embodiment, through the above scheme, the database server generates the responsive service data report in advance through the export rule in a preset time, sends all the service data reports to the download server, and establishes the mapping relationship between the report export interfaces of the user terminals and the corresponding service data reports. When the user terminal sends a request for exporting the business data report, the user can directly download the business data report from the download server through the user terminal, so that the efficiency of the database server for processing the business data report of each user is improved, the storage capacity of the database server is reduced, the exporting efficiency of the user in a large amount of data is improved, and the user experience is further improved.
Referring to fig. 2, fig. 2 is a flowchart illustrating a method for improving export efficiency of a business data report according to another embodiment of the present application. The method comprises the following steps:
s201: and the database server pre-generates a corresponding business data report according to the preset export rule of each user terminal in preset time.
Wherein the database server: one or more computers running in the local area network and the database management system software together form a database server that provides services for user applications, such as querying, updating, transaction management, indexing, caching, query optimization, security, and multiuser access control. And the database server queries and processes the data in a preset time, and generates a corresponding business data report in advance according to a preset export rule of each user terminal. The user terminal can be a mobile phone, a computer, an electronic device, etc.
The preset export rule: when the business data report is a daily report, the database server calculates and processes the business data report of the current day in the range of 0:00-8:00 of the next day; when the business data report is a weekly report, the database server calculates and processes the business data report of the week in the range of 0:00-8:00 of the next day of the week; when the business data report is a month report, the database server calculates and processes the business data report of the month in the range of 0:00-8:00 of the next day of each month. The database server performs periodic operation according to the priorities of different user terminals, and performs priority processing on the user terminals with high priority levels.
The database server acquires the business data report and the report export interfaces of the corresponding different user terminals, determines the priority of the user terminals according to the report export interfaces of the different user terminals, and performs priority processing on the user terminals with high priority.
If the database server identifies that the report export interface of the user terminal is the leading terminal, determining the priority of the user terminal as a first priority; and if the database server identifies that the report export interface of the user terminal is the employee terminal, determining the priority of the user terminal as the second priority.
When the report export interfaces of the corresponding different user terminals are divided into a leader terminal and an employee terminal, the database server acquires the business data report and the report export interfaces of the corresponding leader terminal, and if the corresponding leader terminal needs more business data reports to be processed, priority inquiry and processing are performed, and corresponding business data reports are generated. The database server acquires the business data report and the report export interface of the corresponding employee terminal, and the corresponding employee terminal has less business data report to be processed, and after the business data report of the leading terminal is preferentially processed, the business data report of the employee terminal is correspondingly inquired and processed, and the corresponding business data report is generated. Therefore, the database server can also determine the priority of the user terminal according to the report export interfaces of the different user terminals by acquiring the service data report and the corresponding report export interfaces of the different user terminals, thereby improving the priority processing of the service data report by the user terminal and reducing the redundancy of the database server.
S202: and sending all the business data reports to a download server.
And establishing mapping relations between report export interfaces corresponding to the user terminals and corresponding business data reports. And the database server analyzes the identity information of the user, and sends the business data report corresponding to the user account to the download server together, and the download server derives the corresponding business data report through the user account.
S203: and when the preset time is exceeded, deleting all the business data reports.
After all the business data reports are sent to the download server, deleting the business data reports when the business data reports reach to exceed the preset time. The download server records the starting time of receiving all the business data reports, and when the starting time exceeds the preset time for 24 hours, the download server deletes the business data reports. The download server may send a message informing the user of the download within 24 hours from the point in time of receipt of the service data report.
For example, the service data report of the user terminal on the same day is processed at 0:00 of the next day, the service data report is generated, the service data report is sent to the download server, the download server records the time point of receiving the service data report, and after 24 hours from the time point of receiving the service data report, the download server deletes the service data report. Therefore, when the preset time is exceeded, the download server can delete the business data report, and the storage capacity space of the download server is reduced.
S204, obtaining the export request of the business data report, re-inquiring the database server, generating a new data report and sending the new data report to the download server.
And acquiring a export request of the business data report, re-inquiring by the database server, generating a new data report and sending the new data report to the download server.
For example, when the database server stores the business data report of the user on the day 1, the database server processes the business data report at the time 0:00 of the next day to generate a business data report, the business data report is sent to the download server, after the download server receives the business data report for 24 hours, the download server automatically deletes the business data report of the user, the user wants to download the business data report again, the user can send a request for obtaining the export of the business data report to the database server, and the database server inquires again, generates a new report file, sends the new report file to the download server, and sends the new report file to the user. Therefore, when the user does not download the business data report in time after exceeding the preset time for 24 hours, the database server can be requested again to generate a new business data report, and further the user experience is improved.
S205: and establishing a mapping relation between the report export interfaces of the user terminals and the corresponding business data reports, and exporting the business data reports.
And establishing mapping relations between report export interfaces corresponding to the user terminals and corresponding service data reports, and exporting the service data reports. And the database server analyzes the identity information of the user, and sends the business data report corresponding to the user account to the download server together, and the download server derives the corresponding business data report through the user account.
S206: and acquiring a service data report export request sent by the user terminal, and sending a download address to the user terminal by the database server through the correspondence of the report export interface of the user terminal and the service data report.
The method comprises the steps of acquiring a service data report export request sent by a user terminal, and sending a download address to the user terminal by a database server through the correspondence between a report export interface of the user terminal and the service data report.
The user can click the export button on the page of the user terminal, before the user clicks the export button, the download server can also send a notification message of the download address to the user terminal, and the database server sends the download address to the user terminal through the service data report export interface of the corresponding user terminal.
Referring to fig. 3, fig. 3 is a schematic structural diagram of a database server according to an embodiment of the application. Unlike the previous embodiment, the database server 30 of the present embodiment further includes: a generation module 31, a transmission module 32 and a derivation module 33.
The generating module 31 is configured to pre-generate, by the database server, a corresponding service data report according to a preset export rule of each user terminal within a preset time.
The sending module 32 is configured to send all the service data reports to the download server.
The export module 33 is configured to establish a mapping relationship between the report export interfaces of the user terminals and the corresponding service data reports, and export the service data reports.
Specifically, the generating module 31 is further configured to preset export rules: when the business data report is a daily report, the database server calculates and processes the business data report of the current day in the range of 0:00-8:00 of the next day; when the business data report is a weekly report, the database server calculates and processes the business data report of the week in the range of 0:00-8:00 of the next day of the week; when the business data report is a month report, the database server calculates and processes the business data report of the month in the range of 0:00-8:00 of the next day of each month.
Specifically, the generating module 31 is further configured to obtain the report export interfaces of the service data report and the corresponding different user terminals by using the database server, determine the priority of the user terminal according to the report export interfaces of the different user terminals, and perform priority processing on the user terminal with a high priority level.
Specifically, the generating module 31 is further configured to determine that the priority of the user terminal is the first priority if the database server identifies that the report export interface of the user terminal is the lead terminal; and if the database server identifies that the report export interface of the user terminal is the employee terminal, determining the priority of the user terminal as the second priority.
Specifically, the sending module 32 obtains the export request of the service data report, and the database server performs re-query, generates a new data report, and sends the new data report to the download server.
Specifically, the sending module 32 is further configured to obtain a service data report export request sent by a user terminal, and the database server sends a download address to the user terminal through the service data report export interface corresponding to the user terminal.
Referring to fig. 4, fig. 4 is a schematic structural diagram of another embodiment of a database server according to the present application. Unlike the previous embodiment, the database server 40 of the present embodiment further includes: a generation module 41, a transmission module 42, a deletion module 43 and an export module 44.
The generating module 41 is configured to pre-generate, by the database server, a corresponding service data report according to a preset export rule of each user terminal within a preset time.
The sending module 42 is configured to send all the service data reports to the download server.
The deleting module 43 is configured to delete all the business data reports when the preset time is exceeded.
The export module 43 is configured to establish a mapping relationship between the report export interfaces of the user terminals and the corresponding service data reports, and export the service data reports.
Specifically, the generating module 41 is further configured to preset export rules: when the business data report is a daily report, the database server calculates and processes the business data report of the current day in the range of 0:00-8:00 of the next day; when the business data report is a weekly report, the database server calculates and processes the business data report of the week in the range of 0:00-8:00 of the next day of the week; when the business data report is a month report, the database server calculates and processes the business data report of the month in the range of 0:00-8:00 of the next day of each month.
Specifically, the generating module 41 is further configured to obtain the report export interfaces of the service data report and the corresponding different user terminals by using the database server, determine the priority of the user terminal according to the report export interfaces of the different user terminals, and perform priority processing on the user terminal with a high priority level.
Specifically, the generating module 41 is further configured to determine that the priority of the user terminal is the first priority if the database server identifies that the report export interface of the user terminal is the lead terminal; and if the database server identifies that the report export interface of the user terminal is the employee terminal, determining the priority of the user terminal as the second priority.
Specifically, the sending module 42 is further configured to obtain a service data report export request sent by the user terminal, and the database server sends the download address to the user terminal through the report export interface of the user terminal and the correspondence of the service data report.
Referring to fig. 5, fig. 5 is a schematic structural diagram of an embodiment of a system for improving export efficiency of a business data report according to the present application. The system for improving the export efficiency of the business data report can execute the system for improving the export efficiency of the business data report in the method. For details, please refer to the above method, and detailed description is omitted herein.
In this embodiment, the system for improving the export efficiency of the business data report includes: a memory 51 and a processor 52.
The memory 51 is used for storing an operating system, instructions executed by the processor 52, processing data traffic report information, and the like.
The processor 52 is configured to generate, in advance, a corresponding service data report according to a preset export rule of each user terminal in a preset time by the database server.
The processor 52 is configured to process all of the business data reports to the download server.
The processor 52 is configured to process and establish a mapping relationship between the report export interfaces of the user terminals and the corresponding service data reports, and export the service data reports.
The processor 52 is configured to process preset derived rules: when the business data report is a daily report, the database server calculates and processes the business data report of the current day in the range of 0:00-8:00 of the next day; when the business data report is a weekly report, the database server calculates and processes the business data report of the week in the range of 0:00-8:00 of the next day of the week; when the business data report is a month report, the database server calculates and processes the business data report of the month in the range of 0:00-8:00 of the next day of each month.
The processor 52 is configured to process the report export interfaces of the database server to obtain the service data report and the corresponding different user terminals, determine the priority of the user terminal according to the report export interfaces of the different user terminals, and perform priority processing on the user terminal with a high priority level.
The processor 52 is configured to process determining that the priority of the user terminal is the first priority if the database server identifies that the report export interface of the user terminal is the lead terminal; and if the database server identifies that the report export interface of the user terminal is the employee terminal, determining the priority of the user terminal as the second priority.
The processor 52 is configured to process all the business data reports for deletion when a preset time is exceeded.
The processor 52 is configured to process the export request for obtaining the service data report, and the database server performs a re-query, generates a new data report, and sends the new data report to the download server.
The processor 52 is configured to process and obtain a service data report export request sent by the user terminal, and the database server sends a download address to the user terminal through a report export interface of the user terminal and a correspondence of the service data report.
The system for improving the export efficiency of the business data report comprises a memory 51 and a processor 52 which are mutually connected in communication through a system bus. It should be noted that only a system with components 51-52 that improves business data report export efficiency is shown in the figures, but it should be understood that not all of the illustrated components need be implemented and that more or fewer components may be implemented instead. It will be appreciated by those skilled in the art that the system for improving the efficiency of exporting a business data report herein is a device capable of automatically performing numerical calculation and/or information processing according to a preset or stored instruction, and its hardware includes, but is not limited to, a microprocessor, an application specific integrated circuit (Application Specific Integrated Circuit, ASIC), a programmable gate array (Field-Programmable Gate Array, FPGA), a digital processor (Digital Signal Processor, DSP), an embedded device, and the like.
The system for improving the export efficiency of the business data report can be computing equipment such as a desktop computer, a notebook computer, a palm computer, a cloud server and the like. The system for improving the exporting efficiency of the business data report forms can perform man-machine interaction with a user through a keyboard, a mouse, a remote controller, a touch pad or voice control equipment and the like.
The memory 51 includes at least one type of readable storage medium including flash memory, hard disk, multimedia card, card memory (e.g., SD or DX memory, etc.), random Access Memory (RAM), static Random Access Memory (SRAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), programmable Read Only Memory (PROM), magnetic memory, magnetic disk, optical disk, etc. In some embodiments, the memory 51 may be an internal storage unit of a system that improves the export efficiency of the business data report, such as a hard disk or a memory of the system that improves the export efficiency of the business data report. In other embodiments, the memory 51 may also be an external storage device of a system for improving the exporting efficiency of the service data report, for example, a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash Card (Flash Card) or the like. Of course, the memory 51 may also include both internal storage units and external storage devices of the system that increase the efficiency of exporting the business data statement. In this embodiment, the memory 51 is generally used for storing an operating system and various application software installed in the method for improving the export efficiency of the business data report, for example, program codes of a system method for improving the export efficiency of the business data report, and the like. Further, the memory 51 may be used to temporarily store various types of data that have been output or are to be output.
Processor 52 may be a central processing unit (Central Processing Unit, CPU), controller, microcontroller, microprocessor, or other data processing chip in some embodiments. The processor 42 is generally used to control the overall operation of the system that improves the efficiency of the export of business data reports. In this embodiment, the processor 52 is configured to execute the program code stored in the memory 51 or process data, such as the program code for executing a method for improving the export efficiency of the business data report.
The present application also provides another embodiment, namely, a computer readable storage medium, where a program for improving the export efficiency of a business data report is stored, where the program for improving the export efficiency of a business data report can be executed by at least one processor, so that the at least one processor performs the method for improving the export efficiency of a business data report as described above.
From the above description of the embodiments, it will be clear to those skilled in the art that the above-described embodiment method may be implemented by means of software plus a necessary general hardware platform, but of course may also be implemented by means of hardware, but in many cases the former is a preferred embodiment. Based on such understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art in the form of a software product stored in a storage medium (e.g. ROM/RAM, magnetic disk, optical disk) comprising instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the method according to the embodiments of the present application
Those skilled in the art will appreciate that implementing all or part of the above-described methods in accordance with the embodiments may be accomplished by way of a computer program stored in a computer-readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. The storage medium may be a nonvolatile storage medium such as a magnetic disk, an optical disk, a Read-Only Memory (ROM), or a random access Memory (Random Access Memory, RAM).
It should be understood that, although the steps in the flowcharts of the figures are shown in order as indicated by the arrows, these steps are not necessarily performed in order as indicated by the arrows. The steps are not strictly limited in order and may be performed in other orders, unless explicitly stated herein. Moreover, at least some of the steps in the flowcharts of the figures may include a plurality of sub-steps or stages that are not necessarily performed at the same time, but may be performed at different times, the order of their execution not necessarily being sequential, but may be performed in turn or alternately with other steps or at least a portion of the other steps or stages.
It is apparent that the above-described embodiments are only some embodiments of the present application, but not all embodiments, and the preferred embodiments of the present application are shown in the drawings, which do not limit the scope of the patent claims. This application may be embodied in many different forms, but rather, embodiments are provided in order to provide a thorough and complete understanding of the present disclosure. Although the application has been described in detail with reference to the foregoing embodiments, it will be apparent to those skilled in the art that modifications may be made to the embodiments described in the foregoing description, or equivalents may be substituted for elements thereof. All equivalent structures made by the content of the specification and the drawings of the application are directly or indirectly applied to other related technical fields, and are also within the scope of the application.
Claims (5)
1. The method for improving the export efficiency of the business data report is characterized by comprising the following steps:
the database server pre-generates a corresponding business data report according to a preset export rule of each user terminal in preset time;
all the business data reports are sent to a download server;
establishing a mapping relation between a report export interface of each user terminal and the corresponding business data report, and exporting the business data report;
the step of establishing a mapping relation between the report export interface of each user terminal and the corresponding service data report, and exporting the service data report, further comprising: the service data report comprises a user account, and the download server exports a corresponding service data report to a report export interface corresponding to the user account through the user account;
when the preset time is exceeded, deleting all the business data reports;
and when the preset time is exceeded, deleting all the business data reports, and further comprising the following steps: obtaining a export request of the business data report, and re-inquiring by the database server, generating a new data report and sending the new data report to the download server;
the preset export rule further comprises: the database server acquires business data reports and report export interfaces of different corresponding user terminals, determines the priority of the user terminals according to the report export interfaces of the different user terminals, and carries out priority processing on the user terminals with high priority level;
the database server obtains the business data report and the corresponding report export interfaces of different user terminals, determines the priority of the user terminals according to the report export interfaces of different user terminals, and carries out priority processing on the user terminals with high priority level, and the method specifically comprises the following steps: if the database server identifies that the report export interface of the user terminal is a leading terminal, determining the priority of the user terminal as a first priority; if the database server identifies that the report export interface of the user terminal is an employee terminal, determining that the priority of the user terminal is a second priority;
the step of establishing a mapping relation between the report export interface of each user terminal and the corresponding service data report, and exporting the service data report, further comprising the following steps: and acquiring a service data report export request sent by the user terminal, and sending a download address to the user terminal by the database server through the correspondence of the report export interface of the user terminal and the service data report.
2. The method for improving the export efficiency of the business data report according to claim 1, wherein the generating a corresponding report in advance according to export rules preset by each user terminal specifically further comprises:
when the business data report is a daily report, the database server calculates and processes the business data report of the current day in the range of 0:00-8:00 of the next day;
when the business data report is a weekly report, the database server calculates and processes the business data report of the week in the range of 0:00-8:00 of the next day of the week;
when the business data report is a month report, the database server calculates and processes the business data report of the month in the next day of each month from 0:00 to 8:00.
3. A database server, wherein the database server is operative to implement the method for improving export efficiency of a business data report according to any one of claims 1 to 2, the database server comprising:
the generation module is used for the database server to pre-generate a corresponding service data report according to the preset export rule of each user terminal in preset time;
the sending module is used for sending all the business data reports to a download server;
and the export module is used for establishing the mapping relation between the report export interfaces of the user terminals and the corresponding business data reports and exporting the business data reports.
4. A system for improving the export efficiency of a business data report, comprising a memory and a processor, wherein the memory stores a computer program, and the processor implements the method for improving the export efficiency of a business data report according to any one of claims 1 to 2 when the computer program is executed.
5. A computer readable storage medium, wherein a computer program is stored on the computer readable storage medium, the computer program, when executed by a processor, implementing the method for improving the efficiency of exporting a business data report according to any one of claims 1 to 2.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910529385.3A CN110413610B (en) | 2019-06-19 | 2019-06-19 | Method and system for improving export efficiency of business data report forms and database server |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910529385.3A CN110413610B (en) | 2019-06-19 | 2019-06-19 | Method and system for improving export efficiency of business data report forms and database server |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110413610A CN110413610A (en) | 2019-11-05 |
| CN110413610B true CN110413610B (en) | 2023-10-27 |
Family
ID=68359291
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910529385.3A Active CN110413610B (en) | 2019-06-19 | 2019-06-19 | Method and system for improving export efficiency of business data report forms and database server |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110413610B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110515967B (en) * | 2019-08-30 | 2020-09-08 | 望海康信(北京)科技股份公司 | Spark calculation framework-based data analysis method and electronic equipment |
| CN113761037A (en) * | 2020-09-28 | 2021-12-07 | 西安京迅递供应链科技有限公司 | Import and export method, device, server, medium and service system |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103699557A (en) * | 2013-09-04 | 2014-04-02 | 中国四维测绘技术有限公司 | Report processing method and report processing system |
| CN105138686A (en) * | 2015-09-17 | 2015-12-09 | 国家电网公司 | Real-time application method for multi-level storage data |
| CN107508860A (en) * | 2017-07-21 | 2017-12-22 | 深圳市金立通信设备有限公司 | One kind service current-limiting method, server and terminal |
| CN107908659A (en) * | 2017-10-17 | 2018-04-13 | 深圳前海微众银行股份有限公司 | Data sheet collocation method, report platform and computer-readable recording medium |
| CN108377268A (en) * | 2018-02-26 | 2018-08-07 | 深圳微众税银信息服务有限公司 | A kind of method and system of adjustment task priority |
| CN108804402A (en) * | 2017-04-28 | 2018-11-13 | 北京京东尚科信息技术有限公司 | Report generating system based on big data platform and method |
| CN109189812A (en) * | 2018-08-14 | 2019-01-11 | 中国平安人寿保险股份有限公司 | A kind of index querying method, computer readable storage medium and server |
-
2019
- 2019-06-19 CN CN201910529385.3A patent/CN110413610B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103699557A (en) * | 2013-09-04 | 2014-04-02 | 中国四维测绘技术有限公司 | Report processing method and report processing system |
| CN105138686A (en) * | 2015-09-17 | 2015-12-09 | 国家电网公司 | Real-time application method for multi-level storage data |
| CN108804402A (en) * | 2017-04-28 | 2018-11-13 | 北京京东尚科信息技术有限公司 | Report generating system based on big data platform and method |
| CN107508860A (en) * | 2017-07-21 | 2017-12-22 | 深圳市金立通信设备有限公司 | One kind service current-limiting method, server and terminal |
| CN107908659A (en) * | 2017-10-17 | 2018-04-13 | 深圳前海微众银行股份有限公司 | Data sheet collocation method, report platform and computer-readable recording medium |
| CN108377268A (en) * | 2018-02-26 | 2018-08-07 | 深圳微众税银信息服务有限公司 | A kind of method and system of adjustment task priority |
| CN109189812A (en) * | 2018-08-14 | 2019-01-11 | 中国平安人寿保险股份有限公司 | A kind of index querying method, computer readable storage medium and server |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110413610A (en) | 2019-11-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108427705B (en) | Electronic device, distributed system log query method and storage medium | |
| CN107943828B (en) | Service state query method and device, computer equipment and storage medium | |
| WO2022110444A1 (en) | Dynamic prediction method and apparatus for cloud native resources, computer device and storage medium | |
| CN110413610B (en) | Method and system for improving export efficiency of business data report forms and database server | |
| CN113254445B (en) | Real-time data storage method, device, computer equipment and storage medium | |
| CN112199442B (en) | Method, device, computer equipment and storage medium for distributed batch downloading files | |
| CN109684270B (en) | Database archiving method, device, system, equipment and readable storage medium | |
| CN110457255B (en) | Method, server and computer readable storage medium for archiving data | |
| CN112422450A (en) | Computer equipment, and flow control method and device for service request | |
| CN113010542B (en) | Service data processing method, device, computer equipment and storage medium | |
| CN110443441B (en) | Rule efficiency monitoring method, device, computer equipment and storage medium | |
| CN111475468A (en) | Log access method, device, equipment and storage medium of newly added system | |
| CN112650940A (en) | Recommendation method and device of application program, computer equipment and storage medium | |
| CN113342502B (en) | Performance diagnosis method and device for data lake, computer equipment and storage medium | |
| CN113283759B (en) | Account risk portrait updating method, device, equipment and storage medium | |
| CN115203672A (en) | Information access control method and device, computer equipment and medium | |
| CN112002352B (en) | Random music playing method and device, computer equipment and storage medium | |
| CN114138401A (en) | Container configuration method, device, equipment and medium based on artificial intelligence | |
| CN111026746B (en) | Method, device, computer equipment and storage medium for calling multi-channel data | |
| CN114048059A (en) | Method and device for adjusting timeout time of interface, computer equipment and storage medium | |
| CN113590310A (en) | Resource allocation method and device based on rule touch rate scoring and electronic equipment | |
| CN114650252B (en) | Routing method and device based on enterprise service bus and computer equipment | |
| CN115914361B (en) | Method, device, computer equipment and storage medium for obtaining information of block chain | |
| CN110633299B (en) | Caching method and device for business data, computer equipment and storage medium | |
| CN116796093A (en) | Interface data setting method and device, computer equipment and 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |