CN110413610A - Improve method and system, the database server of business datum report export efficiency - Google Patents
Improve method and system, the database server of business datum report export efficiency Download PDFInfo
- Publication number
- CN110413610A CN110413610A CN201910529385.3A CN201910529385A CN110413610A CN 110413610 A CN110413610 A CN 110413610A CN 201910529385 A CN201910529385 A CN 201910529385A CN 110413610 A CN110413610 A CN 110413610A
- Authority
- CN
- China
- Prior art keywords
- business datum
- report
- user terminal
- database server
- export
- 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.)
- Granted
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
Originally it is related to method and system, the database server of a kind of raising business datum report export efficiency.Wherein, it is a kind of improve business datum report export efficiency method include: through the above scheme, database server is within a preset time, pass through the business datum report of the pre-generated response of derived rule, all business datum reports are sent to download server, the mapping relations of the corresponding business datum report of report export interface by establishing each user terminal, and business datum report is exported.When user terminal sends export business datum report request, user can be by user terminal directly from download server finishing service data sheet, improve the efficiency of the business datum report of each user of database server processes, to reduce the capacity of database server storage, user's derived efficiency in mass data is improved, and then improves the experience of user.
Description
Technical field
The present invention relates to Internet technical field more particularly to it is a kind of improve business datum report export efficiency method and
System, database server and storage medium.
Background technique
Currently, user issues data export request by browser when carrying out mass data export, server is being received
To after the request, by query statement, from data base querying data, the result inquired is returned to server by database, clothes
After device be engaged in the recombination of the result progress business of return, it is then forwarded to user, with the use of system, user is more and more, tires out
The data volume for accumulating storage is also just more and more, and exporting mass data by the method for synchronization can no longer meet demand.
When user is more and more, the data volume of storage is also more and more, and after reaching certain data volume, user is largely being counted
When according to middle export, server also can be slower and slower when carrying out inquiry data, while causing, clothes huge to server memory capacity
Business device processing does not come.After the response time of request is too long, it may appear that server response timeout may result in export data
Failure.In addition, processing time length, reaction are slow when mass data export, user is after request is submitted, in page stop
Between it is very long, user experience is very bad.
Summary of the invention
The invention mainly solves the technical problem of providing a kind of method of raising business datum report export efficiency and it is
System, database server, are able to solve user when exporting mass data, the problem that the processing time is long, reaction is slow.
In order to solve the above-mentioned technical problem, the embodiment of the present invention provide improve business datum report export efficiency method and
System, database server, using technical solution as described below:
A method of it improving business datum report and exports efficiency, include the following steps:
Database server pre-generates corresponding industry within a preset time, according to the preset derived rule of each user terminal
Business data sheet；
All business datum reports are sent to download server；
The mapping relations of the corresponding business datum report of report export interface of each user terminal are established,
And the business datum report is exported.
Wherein, when the business datum report is daily sheet, then 0:00-8 of the database server on next:
The business datum report on the 00 calculation process same day；When the business datum report is weekly return, then the database takes
The business datum report of the business device in the 0:00-8:00 calculation process this week of next day on every Sundays；When the business datum
When report is moon sheet, then industry of the database server in next day of end of each month 0:00-8:00 calculation process this month
Business data sheet.
Wherein, the database server obtains the report of the corresponding difference user terminal of business datum report
Export interface determines the priority of user terminal according to the report export interface of the different user terminals, and to the user
The high carry out priority processing of the priority-level of terminal.
Wherein, if the database server recognizes the report export interface of the user terminal as leader's terminal,
The priority for then determining the user terminal is the first priority；If the database server recognizes the user terminal
When report export interface is employee's terminal, it is determined that the priority of the user terminal is the second priority.
Wherein, when reaching more than preset time, then all business datum reports are deleted.
Wherein, the export request of the business datum report is obtained, the database server is inquired again, and raw
The data sheet of Cheng Xin is sent to the download server.
Wherein, the business datum report export request that the user terminal is sent is obtained, the database server passes through
The report export interface of the user terminal is corresponding with the business datum report, and it is whole that download address is sent to the user
End.
In order to solve the above-mentioned technical problem, the embodiment of the present invention also provides a kind of database server, uses following institute
The technical solution stated:
Generation module, it is within a preset time for database server, pre- according to the preset derived rule of each user terminal
First generate corresponding business datum report；
Sending module, for all business datum reports to be sent to download server；
Export module, the corresponding business datum report of report export interface for establishing each user terminal
The mapping relations of table, and the business datum report is exported.
In order to solve the above-mentioned technical problem, the embodiment of the present invention also provides a kind of raising business datum report export effect
The system of rate, using technical solution as described below:
A kind of system improving business datum report export efficiency, including memory and processor are deposited in the memory
Computer program is contained, the processor realizes described in any item raising business numbers among the above when executing the computer program
According to the method for report export efficiency.
In order to solve the above-mentioned technical problem, the embodiment of the present invention also provides a kind of computer readable storage medium, uses
Technical solution as described below:
A kind of computer readable storage medium, which is characterized in that calculating is stored on the computer readable storage medium
Machine program realizes described in any item raising business datum report export among the above when the computer program is executed by processor
The method of efficiency.
Compared with prior art, the embodiment of the present invention mainly have it is following the utility model has the advantages that
Through the above scheme, database server within a preset time, passes through the business of the pre-generated response of derived rule
All business datum reports are sent to download server by data sheet, and the report by establishing each user terminal exports
The mapping relations of the corresponding business datum report of interface, and business datum report is exported.It is exported when user terminal is sent
When business datum report request, user can by user terminal directly from download server finishing service data sheet,
The efficiency of the business datum report of each user of database server processes is improved, to reduce database server storage
Capacity, improve user's derived efficiency in mass data, and then improve the experience of user.
Detailed description of the invention
It, below will be to needed in description of the embodiment of the present invention in order to illustrate more clearly of the scheme in the present invention
Attached drawing makees a simple introduction, it should be apparent that, drawings in the following description are some embodiments of the invention, for this field
For those of ordinary skill, without creative efforts, it is also possible to obtain other drawings based on these drawings.
Fig. 1 is a kind of flow diagram for one embodiment of method for improving business datum report export efficiency of the present invention；
Fig. 2 is a kind of flow diagram for another embodiment of method for improving business datum report export efficiency of the present invention；
Fig. 3 is a kind of structural schematic diagram of one embodiment of database server of the present invention；
Fig. 4 is a kind of structural schematic diagram of another embodiment of database server of the present invention；
Fig. 5 is a kind of structure of one embodiment of system for improving business datum report export efficiency according to the present invention
Schematic diagram.
Specific embodiment
Unless otherwise defined, all technical and scientific terms used herein and belong to technical field of the invention
The normally understood meaning of technical staff is identical；It is specific that description is intended merely in the term used in the description of invention herein
Embodiment purpose, it is not intended that in limitation the present invention；Description and claims of this specification and above-mentioned Detailed description of the invention
In term " includes " and " having " and their any deformation, it is intended that cover and non-exclusive include.Of the invention says
Bright book and claims or term " first " in above-mentioned attached drawing, " second " etc. rather than are used for distinguishing different objects
In description particular order.
Referenced herein " embodiment " is it is meant that a particular feature, structure, or characteristic described can wrap in conjunction with the embodiments
Containing at least one embodiment of the present invention.Each position in the description occur the phrase might not each mean it is identical
Embodiment, nor the independent or alternative embodiment with other embodiments mutual exclusion.Those skilled in the art explicitly and
Implicitly understand, embodiment described herein can be combined with other embodiments.
In order to enable those skilled in the art to better understand the solution of the present invention, below in conjunction with attached drawing, to of the invention real
The technical solution applied in example is clearly and completely described.
Referring to Fig. 1, Fig. 1 is a kind of process for one embodiment of method for improving business datum report export efficiency of the present invention
Schematic diagram, it should be noted that, if having substantially the same as a result, method of the invention is not with process sequence shown in FIG. 1
Limit, this method comprises the following steps:
S101: database server pre-generates phase within a preset time, according to the preset derived rule of each user terminal
The business datum report answered.
Wherein, database server: running one or more computer in a local network and data base management system is soft
Part together constitutes database server, and database server provides service for user's application, these services be inquiry, update,
Transaction management, index, cache, query optimization, safety and multi-user access control etc..Database server is in preset time
It is interior, inquiry and processing to data are carried out, corresponding business is pre-generated according to the preset derived rule of each user terminal
Data sheet.The user terminal can be mobile phone, computer and electronic equipment etc..
The preset derived rule: when business datum report be daily sheet when, then database server next day 0:
The business datum report on the 00-8:00 calculation process same day；When business datum report is weekly return, then database server is every
The business datum report of the 0:00-8:00 calculation process this week of next day of Sunday；When business datum report is moon sheet, then
Business datum report of the database server in next day of end of each month 0:00-8:00 calculation process this month.Database service
Device carries out regular operation according to the priority of different user terminals, and the carry out high for the priority-level of user terminal is preferential
Processing.
Wherein, the report export that database server obtains the corresponding different user terminals of business datum report connects
Mouthful, the priority of user terminal is determined according to the report export interface of different user terminals, and to the priority grade of user terminal
Not high carry out priority processing.
Wherein, if database server recognizes the report export interface of user terminal as leader's terminal, it is determined that use
The priority of family terminal is the first priority；If the report export interface that database server recognizes user terminal is that employee is whole
When end, it is determined that the priority of user terminal is the second priority.
It is divided into leader's terminal and employee's terminal, data according to the report export interface of different corresponding different user terminals
Library server obtains the report export interface of the corresponding leader's terminal of business datum report, and corresponding leader's terminal needs to locate
The business datum report of reason is more, then is preferentially inquired and handled, and generates corresponding business datum report.Database service
Device obtains the report export interface of the corresponding employee's terminal of business datum report, corresponding employee's terminal industry to be treated
Being engaged in, data sheet is few, then priority processing leads the business datum report of terminal and then corresponds to inquiry and processing employee's terminal
Business datum report, and generate corresponding business datum report.
S102: all business datum reports are sent to download server.
Wherein, database server pre-generates business datum report according to the preset derived rule of each user terminal, will
All business datum reports are sent to download server.The business datum report can be divided into daily sheet, weekly return and monthly magazine
Table.
S103: the mapping relations of the corresponding business datum report of the report export interface of each user terminal of foundation,
And business datum report is exported.
Wherein, the mapping for establishing the corresponding business datum report of the corresponding report export interface of each user terminal is closed
System, and the business datum report is exported.Each user terminal corresponds to the business datum report of user, wherein user terminal
Being sent in the packet of the business datum report of database server has user account, and database server parses user's
Identity information, and the corresponding business datum report of user account is sent jointly into download server, download server passes through use
Family account exports its corresponding business datum report.
In the present embodiment, through the above scheme, database server is within a preset time, pre-generated by derived rule
All business datum reports are sent to download server, by the report for establishing each user terminal by the business datum report of response
The mapping relations of the corresponding business datum report of table export interface.When user terminal sends export business datum report request
When, user can improve database directly from download server finishing service data sheet by user terminal
The efficiency of the business datum report of each user of server process improves to reduce the capacity of database server storage
User derived efficiency in mass data, and then improve the experience of user.
Referring to Fig. 2, Fig. 2 is a kind of stream for another embodiment of method for improving business datum report export efficiency of the present invention
Journey schematic diagram.This method comprises the following steps:
S201: database server pre-generates phase within a preset time, according to the preset derived rule of each user terminal
The business datum report answered.
Wherein, database server: running one or more computer in a local network and data base management system is soft
Part together constitutes database server, and database server provides service for user's application, these services be inquiry, update,
Transaction management, index, cache, query optimization, safety and multi-user access control etc..Database server is in preset time
It is interior, inquiry and processing to data are carried out, corresponding business is pre-generated according to the preset derived rule of each user terminal
Data sheet.The user terminal can be mobile phone, computer and electronic equipment etc..
The preset derived rule: when business datum report be daily sheet when, then database server next day 0:
The business datum report on the 00-8:00 calculation process same day；When business datum report is weekly return, then database server is every
The business datum report of the 0:00-8:00 calculation process this week of next day of Sunday；When business datum report is moon sheet, then
Business datum report of the database server in next day of end of each month 0:00-8:00 calculation process this month.Database service
Device carries out regular operation according to the priority of different user terminals, and the carry out high for the priority-level of user terminal is preferential
Processing.
Wherein, the report export that database server obtains the corresponding different user terminals of business datum report connects
Mouthful, the priority of user terminal is determined according to the report export interface of different user terminals, and to the priority grade of user terminal
Not high carry out priority processing.
Wherein, if database server recognizes the report export interface of user terminal as leader's terminal, it is determined that use
The priority of family terminal is the first priority；If the report export interface that database server recognizes user terminal is that employee is whole
When end, it is determined that the priority of user terminal is the second priority.
When being divided into leader's terminal and employee's terminal, data according to the report export interface of corresponding different user terminals
Library server obtains the report export interface of the corresponding leader's terminal of business datum report, and corresponding leader's terminal needs to locate
The business datum report of reason is more, then is preferentially inquired and handled, and generates corresponding business datum report.Database service
Device obtains the report export interface of the corresponding employee's terminal of business datum report, corresponding employee's terminal industry to be treated
Being engaged in, data sheet is few, then priority processing leads the business datum report of terminal and then corresponds to inquiry and processing employee's terminal
Business datum report, and generate corresponding business datum report.In this way, database server can also be by obtaining business number
According to the report export interface of the corresponding different user terminals of report, according to true according to the report export interface of different user terminals
The priority for determining user terminal improves user terminal to business datum report priority processing, it is possible to reduce database server
Superfluous amount.
S202: all business datum reports are sent to download server.
Wherein, the mapping for establishing the corresponding business datum report of the corresponding report export interface of each user terminal is closed
System.Each user terminal corresponds to the business datum report of user, wherein user terminal is sent to the business number of database server
According to there is user account in the packet of report, database server parses the identity information of user, and user account is corresponding
Business datum report send jointly to download server, download server exports its corresponding business datum by user account
Report.
S203: when reaching more than preset time, then all business datum reports are deleted.
Wherein, it after all business datum reports being sent to download server, when reaching more than preset time, is then deleted
It removes.Download server records all received starting times of business datum report, when reach more than preset time 24 it is small when, then under
Server is carried to be deleted.Download server is within business datum report received time point to 24 hours, download server
The message for notifying user to download can be sent.
For example, the business datum report of the user terminal on the same day was handled in next day 0:00, business datum is generated
Business datum report is sent to download server by report, download server by record traffic data sheet received time point,
It starts from business data sheet received time point to after 24 hours, download server is deleted.In this way, when being more than default
Time, download server can delete business datum report, reduce the memory capacity space of download server.
S204: the export request of business datum report is obtained, database server is inquired again, and generates new number
Download server is sent to according to report.
Wherein, the export request of business datum report is obtained, database server is inquired again, and generates new number
Download server is sent to according to report.
For example, then database server exists when database server stores business datum report of the user on the day of No. 1
Next day 0:00 is handled, and generates business datum report, business datum report is sent to download server, download service
After device receives 24 hours, download server is then automatically deleted the business datum report of user, and user wants to re-download business number
According to report, user can send the derived request for obtaining business datum report to database server, then database server
Again it is inquired, and generates new report file and be sent to download server, and be sent to user.In this way, when user is more than
Without timely downloading service data sheet after preset time 24 hours, database server can also be re-requested and generated newly
Business datum report, and then improve the experience of user.
S205: establishing the mapping relations of the corresponding business datum report of report export interface of each user terminal, and
Business datum report is exported.
Wherein, the mapping for establishing the corresponding business datum report of the corresponding report export interface of each user terminal is closed
System, and business datum report is exported.Each user terminal corresponds to the business datum report of user, wherein user terminal is sent
To having user account in the packet of the business datum report of database server, database server parses the identity of user
Information, and the corresponding business datum report of user account is sent jointly into download server, download server passes through user's account
Number export its corresponding business datum report.
S206: it obtains the business datum report that user terminal is sent and exports request, database server passes through user terminal
Report export interface it is corresponding with business datum report, download address is sent to user terminal.
Wherein, it obtains the business datum report that user terminal is sent and exports request, database server passes through user terminal
Report export interface it is corresponding with business datum report, download address is sent to user terminal.
User can export button by clicking on the page of user terminal, before user clicks export button, under
The notification information of a download address can also be sent to user terminal by carrying server, and database server passes through relative users end
Download address is sent to user terminal by the business datum report export interface at end.
Referring to Fig. 3, Fig. 3 is a kind of structural schematic diagram of one embodiment of database server of the present invention.It is different from one
Embodiment, the present embodiment database server 30 further include: generation module 31, sending module 32 and export module 33.
Generation module 31 is used for database server within a preset time, pre- according to the preset derived rule of each user terminal
First generate corresponding business datum report.
Sending module 32 is used to all business datum reports being sent to download server.
The corresponding business datum report of report export interface of the export module 33 for establishing each user terminal reflects
Relationship is penetrated, and business datum report is exported.
Specifically, generation module 31 is also used to preset derived rule: when business datum report is daily sheet, then data
Business datum report of the library server the next day 0:00-8:00 calculation process same day；When business datum report is weekly return
When, then the business datum report of the database server in the 0:00-8:00 calculation process this week of next day on every Sundays；When
When business datum report is moon sheet, then 0:00-8:00 calculation process this month of the database server at next day of the end of each month
Business datum report.
Specifically, generation module 31, which is also used to database server, obtains the corresponding different user of business datum report
The report export interface of terminal, determines the priority of user terminal according to the report export interface of different user terminals, and to
The high carry out priority processing of the priority-level of family terminal.
Specifically, if generation module 31, which is also used to database server, recognizes the report export interface of user terminal as neck
When leading terminal, it is determined that the priority of user terminal is the first priority；If database server recognizes the report of user terminal
When table export interface is employee's terminal, it is determined that the priority of user terminal is the second priority.
Specifically, sending module 32 obtains the export request of the business datum report, the database server is carried out
Again it inquires, and generates the new data sheet and be sent to the download server.
Specifically, sending module 32 is also used to obtain the business datum report export request of user terminal transmission, the number
By the business datum report export interface of the corresponding user terminal download address is sent to according to library server described
User terminal.
Referring to Fig. 4, Fig. 4 is a kind of structural schematic diagram of another embodiment of database server of the present invention.It is different from
One embodiment, the present embodiment database server 40 further include: generation module 41, sending module 42, removing module 43 and lead
Module 44 out.
Generation module 41 is used for database server within a preset time, pre- according to the preset derived rule of each user terminal
First generate corresponding business datum report.
Sending module 42 is used to all business datum reports being sent to download server.
Removing module 43 is used for when reaching more than preset time, then is deleted all business datum reports.
The corresponding business datum report of report export interface of the export module 43 for establishing each user terminal reflects
Relationship is penetrated, and the business datum report is exported.
Specifically, generation module 41 is also used to preset derived rule: when business datum report is daily sheet, then data
Business datum report of the library server the next day 0:00-8:00 calculation process same day；When business datum report is weekly return
When, then the business datum report of the database server in the 0:00-8:00 calculation process this week of next day on every Sundays；When
When business datum report is moon sheet, then 0:00-8:00 calculation process this month of the database server at next day of the end of each month
Business datum report.
Specifically, generation module 41, which is also used to database server, obtains the corresponding different user of business datum report
The report export interface of terminal, determines the priority of user terminal according to the report export interface of different user terminals, and to
The high carry out priority processing of the priority-level of family terminal.
Specifically, if generation module 41, which is also used to database server, recognizes the report export interface of user terminal as neck
When leading terminal, it is determined that the priority of user terminal is the first priority；If database server recognizes the report of user terminal
When table export interface is employee's terminal, it is determined that the priority of user terminal is the second priority.
Specifically, sending module 42 is also used to obtain the business datum report export request of user terminal transmission, database
Server is corresponding with business datum report by the report export interface of user terminal, and download address is sent to user's end
End.
Referring to Fig. 5, Fig. 5 is an a kind of reality of system for improving business datum report export efficiency according to the present invention
Apply the structural schematic diagram of example.The system of raising business datum report export efficiency can execute raising business number in the above method
It is executed according to the system of report export efficiency.Related content refers to the detailed description in the above method, no longer superfluous herein to chat.
In the present embodiment, the system which exports efficiency includes: memory 51 and processor 52.
Memory 51 is used to store operating system, the instruction that processor 52 executes and processing data service report messages
Deng.
Processor 52 is used for database server within a preset time, preparatory according to the preset derived rule of each user terminal
Generate corresponding business datum report.
All business datum reports are sent to download server for handling by processor 52.
Processor 52 is used to handle the corresponding business datum report of report export interface for establishing each user terminal
Mapping relations, the export of business datum report.
Processor 52 is for handling preset derived rule: when business datum report is daily sheet, then database service
Business datum report of the device the next day 0:00-8:00 calculation process same day；When business datum report is weekly return, then count
According to library server the 0:00-8:00 calculation process this week of next day on every Sundays business datum report；When business datum report
When table is moon sheet, then business datum of the database server in next day of end of each month 0:00-8:00 calculation process this month
Report.
Processor 52 is used to handle database server and obtains the corresponding different user terminals of business datum report
Report export interface determines the priority of user terminal according to the report export interface of different user terminals, and to user terminal
The high carry out priority processing of priority-level.
If processor 52 recognizes the report export interface of user terminal for handling database server as leader's terminal
When, it is determined that the priority of user terminal is the first priority；If database server recognizes the report export of user terminal
When interface is employee's terminal, it is determined that the priority of user terminal is the second priority.
Processor 52 then deletes all business datum reports for handling when reaching more than preset time.
Processor 52 is used to handle in the export request for obtaining the business datum report, and the database server carries out
Again it inquires, and generates the new data sheet and be sent to the download server.
Processor 52, which is used to handle, obtains the business datum report export request that the user terminal is sent, the database
Server is corresponding with the business datum report by the report export interface of the user terminal, and download address is sent to
The user terminal.
The system for improving business datum report export efficiency includes that connection memory 51, place are in communication with each other by system bus
Manage device 52.It should be pointed out that illustrate only the raising business datum report export efficiency with component 51-52 in figure is
System, it should be understood that it is not required for implementing all components shown, more or less groups of the implementation that can be substituted
Part.Wherein, the system that those skilled in the art of the present technique are appreciated that the export efficiency of raising business datum report here is a kind of
Can be according to the instruction for being previously set or storing, the automatic equipment for carrying out numerical value calculating and/or information processing, hardware include but
Be not limited to microprocessor, specific integrated circuit (Application Specific Integrated Circuit, ASIC), can
Program gate array (Field-Programmable Gate Array, FPGA), digital processing unit (Digital Signal
Processor, DSP), embedded device etc..
The system for improving business datum report export efficiency can be desktop PC, notebook, palm PC and cloud
Server etc. is held to calculate equipment.The system for improving business datum report export efficiency can pass through keyboard, mouse, remote control with user
The modes such as device, touch tablet or voice-operated device carry out human-computer interaction.
Memory 51 includes at least a type of readable storage medium storing program for executing, and readable storage medium storing program for executing includes flash memory, hard disk, more matchmakers
Body card, card-type memory (for example, SD or DX memory etc.), random access storage device (RAM), static random-access memory
(SRAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), programmable read only memory
(PROM), magnetic storage, disk, CD etc..In some embodiments, memory 51 can be raising business datum report and lead
The internal storage unit of the system of efficiency out, such as the raising business datum report export the hard disk or memory of the system of efficiency.
In further embodiments, the external storage that memory 51 is also possible to improve the system of business datum report export efficiency is set
Plug-in type hard disk that is standby, such as being equipped in the system of raising business datum report export efficiency, intelligent memory card (Smart
Media Card, SMC), secure digital (Secure Digital, SD) card, flash card (Flash Card) etc..Certainly, it stores
Device 51 can also be both including improving the internal storage unit of the system of business datum report export efficiency or including its external storage
Equipment.In the present embodiment, memory 51 is installed on the method that the raising business datum report exports efficiency commonly used in storage
Operating system and types of applications software, such as improve business datum report export efficiency systems approach program code etc..
In addition, the memory 51 can be also used for temporarily storing the Various types of data that has exported or will export.
Processor 52 can be in some embodiments central processing unit (Central Processing Unit, CPU),
Controller, microcontroller, microprocessor or other data processing chips.The processor 42 is commonly used in control raising business number
According to the overall operation of the system of report export efficiency.In the present embodiment, journey of the processor 52 for being stored in run memory 51
Sequence code or processing data, such as operation improve the program code of the method for business datum report export efficiency.
Present invention also provides another embodiments, that is, provide a kind of computer readable storage medium, the computer
Readable storage medium storing program for executing storage is improved the program of business datum report export efficiency, and the raising business datum report exports efficiency
Program can be executed by least one processor so that at least one described processor is executed such as above-mentioned raising business datum report
The method of table export efficiency.
Through the above description of the embodiments, those skilled in the art can be understood that above-described embodiment side
Method can be realized by means of software and necessary general hardware platform, naturally it is also possible to by hardware, but in many cases
The former is more preferably embodiment.Based on this understanding, the technical solution of the application substantially in other words does the prior art
The part contributed out can be embodied in the form of software products, which is stored in a storage medium
In (such as ROM/RAM, magnetic disk, CD), including some instructions are used so that a terminal device (can be mobile phone, computer, clothes
Business device, air conditioner or the network equipment etc.) execute method described in each embodiment of the application
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, which can be stored in a computer-readable storage and be situated between
In matter, the program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein, storage medium above-mentioned can be
The non-volatile memory mediums such as magnetic disk, CD, read-only memory (Read-Only Memory, ROM) or random storage note
Recall body (Random Access Memory, RAM) etc..
It should be understood that although each step in the flow chart of attached drawing is successively shown according to the instruction of arrow,
These steps are not that the inevitable sequence according to arrow instruction successively executes.Unless expressly stating otherwise herein, these steps
Execution there is no stringent sequences to limit, can execute in the other order.Moreover, at least one in the flow chart of attached drawing
Part steps may include that perhaps these sub-steps of multiple stages or stage are not necessarily in synchronization to multiple sub-steps
Completion is executed, but can be executed at different times, execution sequence, which is also not necessarily, successively to be carried out, but can be with other
At least part of the sub-step or stage of step or other steps executes in turn or alternately.
Obviously, embodiments described above is only a part of the embodiment of the present invention, instead of all the embodiments, attached
Presently preferred embodiments of the present invention is given in figure, but is not intended to limit the scope of the patents of the invention.The present invention can be with many differences
Form realize, on the contrary, purpose of providing these embodiments is keeps the understanding to the disclosure more thorough
Comprehensively.Although the present invention is described in detail referring to the foregoing embodiments, for coming for those skilled in the art,
Can still modify to technical solution documented by aforementioned each specific embodiment, or to part of technical characteristic into
Row equivalence replacement.All equivalent structures done using description of the invention and accompanying drawing content, are directly or indirectly used in other
Relevant technical field, similarly within the invention patent protection scope.
Claims (10)
1. a kind of method for improving business datum report export efficiency characterized by comprising
Database server pre-generates corresponding business number within a preset time, according to the preset derived rule of each user terminal
According to report；
All business datum reports are sent to download server；
The mapping relations of the corresponding business datum report of report export interface of each user terminal are established, and will
The business datum report export.
2. a kind of method for improving business datum report export efficiency according to claim 1, which is characterized in that described
Corresponding report is pre-generated according to the preset derived rule of each user terminal, specifically further include:
When the business datum report is daily sheet, then the database server is at 0:00-8:00 operation in next day
Should day the business datum report；
When the business datum report is weekly return, then the database server is in next day 0:00-8 on every Sundays:
The business datum report of 00 calculation process this week；
When the business datum report is moon sheet, then next day 0:00-8 of the database server in the end of each month:
The business datum report of 00 calculation process this month.
3. a kind of method for improving business datum report export efficiency according to claim 1 or 2, which is characterized in that institute
State preset derived rule further include:
The database server obtains the report export interface of the corresponding difference user terminal of business datum report,
The priority of user terminal is determined according to the report export interface of the different user terminals, and to the preferential of the user terminal
The high carry out priority processing of grade rank.
4. a kind of method for improving business datum report export efficiency according to claim 3, which is characterized in that the number
It is led according to the report that database server described in the server of library obtains the corresponding difference user terminal of business datum report
Outgoing interface determines the priority of user terminal according to the report export interface of the different user terminals, and whole to the user
The high carry out priority processing of the priority-level at end, specifically further include:
If the database server recognizes the report export interface of the user terminal as leader's terminal, it is determined that described
The priority of user terminal is the first priority；If the report export that the database server recognizes the user terminal connects
When mouth is employee's terminal, it is determined that the priority of the user terminal is the second priority.
5. a kind of method for improving business datum report export efficiency according to claim 1, which is characterized in that described to incite somebody to action
All business datum reports are sent to after download server step further include:
When reaching more than preset time, then all business datum reports are deleted.
6. a kind of method for improving business datum report export efficiency according to claim 5, which is characterized in that described to work as
The step of reaching more than preset time, then deleting all business datum reports, further comprises:
The export request of the business datum report is obtained, the database server is inquired again, and generates new institute
It states data sheet and is sent to the download server.
7. a kind of method for improving business datum report export efficiency according to claim 1, which is characterized in that described to build
Found the mapping relations step of the corresponding business datum report of report export interface of each user terminal, and by institute
The step of stating the export of business datum report, further comprises:
The business datum report export request that the user terminal is sent is obtained, the database server is whole by the user
The report export interface at end is corresponding with the business datum report, and download address is sent to the user terminal.
8. a kind of database server characterized by comprising
Generation module, within a preset time for database server, according to the pre- Mr. of the preset derived rule of each user terminal
At corresponding business datum report；
Sending module, for all business datum reports to be sent to download server；
Export module, the corresponding business datum report of report export interface for establishing each user terminal
Mapping relations, and the business datum report is exported.
9. a kind of system for improving business datum report export efficiency, including memory and processor are stored in the memory
There is computer program, mentioning as described in any one of claims 1 to 7 is realized when the processor executes the computer program
The method of high business datum report export efficiency.
10. a kind of computer readable storage medium, which is characterized in that be stored with computer on the computer readable storage medium
Program realizes the raising business datum as described in any one of claims 1 to 7 when the computer program is executed by processor
The method of report export efficiency.
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 true CN110413610A (en) | 2019-11-05 |
| CN110413610B 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) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110515967A (en) * | 2019-08-30 | 2019-11-29 | 北京东软望海科技有限公司 | Data analysing method and electronic equipment based on spark Computational frame |
| CN113761037A (en) * | 2020-09-28 | 2021-12-07 | 西安京迅递供应链科技有限公司 | Import and export method, device, server, medium and service system |
| CN117931952A (en) * | 2024-03-21 | 2024-04-26 | 无锡学院 | Industrial equipment data synchronous processing method and 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 |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110515967A (en) * | 2019-08-30 | 2019-11-29 | 北京东软望海科技有限公司 | Data analysing method and electronic equipment based on spark Computational frame |
| CN113761037A (en) * | 2020-09-28 | 2021-12-07 | 西安京迅递供应链科技有限公司 | Import and export method, device, server, medium and service system |
| CN117931952A (en) * | 2024-03-21 | 2024-04-26 | 无锡学院 | Industrial equipment data synchronous processing method and system |
| CN117931952B (en) * | 2024-03-21 | 2024-07-05 | 无锡学院 | Industrial equipment data synchronous processing method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110413610B (en) | 2023-10-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN100478956C (en) | Method and corresponding system for creating and obtaining report forms | |
| CN110413610A (en) | Improve method and system, the database server of business datum report export efficiency | |
| CN110928905B (en) | Data processing method and device | |
| CN109684270B (en) | Database archiving method, device, system, equipment and readable storage medium | |
| CN109240607B (en) | File reading method and device | |
| CN110677462A (en) | Access processing method, system, device and storage medium for multi-block chain network | |
| CN107992516A (en) | Electronic device, the method for data query and storage medium | |
| CN109842621A (en) | A kind of method and terminal reducing token storage quantity | |
| CN106844721A (en) | Date storage method, device, system, computer-readable recording medium and storage control | |
| CN111782304A (en) | Logic control method and device for paging loading data, computer equipment and medium | |
| CN107766160A (en) | Queue message processing method and terminal device | |
| CN107451301B (en) | Processing method, device, equipment and storage medium for real-time delivery bill mail | |
| WO2021012506A1 (en) | Method and apparatus for realizing load balancing in speech recognition system, and computer device | |
| CN112381514A (en) | Service data reminding method and device and server | |
| CN111813517A (en) | Task queue allocation method and device, computer equipment and medium | |
| CN109697019A (en) | The method and system of data write-in based on FAT file system | |
| CN113254106B (en) | Task execution method and device based on Flink, computer equipment and storage medium | |
| CN113342502B (en) | Performance diagnosis method and device for data lake, computer equipment and storage medium | |
| CN102761617B (en) | Workflow queue server and workflow scheduling system and method | |
| CN105763616A (en) | Resource-downloading method and device | |
| CN106850707A (en) | Method, apparatus and system that material batch is uploaded | |
| CN100378663C (en) | Method, system and module for dynamic downloading of applied programe to user identification | |
| CN112217849B (en) | Task scheduling method, system and computer equipment in SD-WAN system | |
| CN107819823A (en) | A kind of information processing method, server and computer-readable recording medium | |
| CN111475468A (en) | Log access method, device, equipment and storage medium of newly added system |
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 |