Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and system for exporting million-level records to table from database with browser

A data export and browser technology, applied in transmission systems, electrical digital data processing, special data processing applications, etc., can solve problems such as data server crashes, and achieve the effect of optimizing processing speed and reducing size

Inactive Publication Date: 2017-09-12
CHENGDU SANLING KAITIAN COMM IND
View PDF4 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The purpose of the present invention is to overcome the deficiencies of the prior art, provide a method and system for exporting millions of records from a database to a form through a browser, and solve the problem that the server will crash when the data volume reaches millions of data when the browser exports data , and optimize the data processing speed, reduce the size of the downloaded file through the compression method, and make the browser download millions of data faster and more stable

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system for exporting million-level records to table from database with browser
  • Method and system for exporting million-level records to table from database with browser

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] The technical solution of the present invention will be further described in detail below in conjunction with the accompanying drawings, but the protection scope of the present invention is not limited to the following description.

[0024] like figure 1 As shown, the method for exporting millions of records from a database to a table through a browser is characterized in that it specifically includes the following steps:

[0025] S0001 User request: The user requests to export data, and the server extracts the user request parameters after receiving the user request;

[0026] S0002 Data processing: Query the database according to the preset conditions through the value of the request parameter, and obtain the data to be exported;

[0027] S0003 Data assembly: Assemble the data to be exported into an excel form, if the amount of data is small, directly export a file in the form of an excel form to the browser, otherwise assemble the data into multiple excel forms;

[...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method and system for exporting million-level records to a table from a database with a browser, and relates to the field of JavaWeb engineering. The method comprises the following steps: making a request with a user, processing data, assembling the data, storing the data, compressing the data, sending download information to the user and receiving the download information with the user. The system comprises a data processing module, a data assembling module, a data storage module, a data compression module and a data exporting module. The exported data is shown in an excel table, so that the problem that a server is corrupted when million-level data is exported by the browser, and the data processing speed is optimized; the size of a download file is reduced by a compression method, so that the million-level data can be faster and more stably downloaded by the browser.

Description

technical field [0001] The invention relates to the field of JavaWeb engineering, in particular to a method and a system for exporting millions of records from a database to a table through a browser. Background technique [0002] Statistical reports are a very common application in large-scale WEB application systems, and exporting data to files such as Excel is a core function of reports. When the system is deployed in different places, due to the different application scenarios in different places, the requirements for the format and style of the exported data are also different. The more places are deployed, the more differences there will be. It is necessary to develop corresponding functions and modify the program of the export module to deal with it, which greatly increases the cost of development and testing. At present, the general solution is to realize the diversification of export styles through the configuration of a large number of attributes in the configurat...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30H04L29/08
CPCG06F16/248G06F16/258H04L67/06
Inventor 李金海吴震牟文炬
Owner CHENGDU SANLING KAITIAN COMM IND
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com