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

Method and system for querying data and exporting report

A technology of data query and query statistics, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of reducing enterprise work efficiency, slow data query speed, wasting valuable time of users, etc., to save precious time , Improve work efficiency, high-efficiency effect

Inactive Publication Date: 2013-04-10
FUJIAN RAYNEN TECH
View PDF3 Cites 25 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When the amount of exported data is large, the process of waiting for the data export not only wastes the valuable time of the user, but also reduces the work efficiency of the enterprise, such as figure 1 shown
[0007] Therefore, in the process of big data query and report export, how to solve the problem of slow data query and export speed has become the primary technical problem to be solved at present

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 querying data and exporting report
  • Method and system for querying data and exporting report
  • Method and system for querying data and exporting report

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0042] The preferred embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings. It should be understood that the preferred embodiments described below are only used to illustrate and explain the present invention, and are not intended to limit the present invention.

[0043] figure 2 A schematic diagram of a method for data query and report file export provided by the present invention is shown, as figure 2 As shown, the steps include:

[0044] Step 201: the client sends the data query request input by the user on the data query page to the Web server via the Internet.

[0045] Step 202: After receiving the data query request, the web server extracts the query condition information, grouping mode information, and sorting mode information, and generates a query statistics command.

[0046] The step 202 includes: the Web server extracts the report name and output file path from the data query request.

[0047] The s...

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 a system for querying data and exporting a report. The method comprises the following steps: a client side sends a data querying request input by a user at a data querying page through an internet to a Web server; the Web server receives the data querying request, extracts query condition information, packet mode information and sorting mode information of the data querying request, and generates a querying statistics command; a database server queries a database according to the querying statistics command and generates a report file; and the database server duplicates the report file to the Web server for the client side to download. According to the method and the system for querying the data and exporting the report, the system resource can be saved; the working efficiency is improved; the valuable time is saved for the user; and the higher benefit can be brought for the enterprises.

Description

technical field [0001] The invention relates to data query and report export technology, in particular to a method for fast big data query and report export implemented on a Web server and a related system. Background technique [0002] With the continuous development of enterprises, ERP (Enterprise Resource Planning, enterprise resource planning) data increases day by day, and the ever-expanding data volume makes the data query and export of the system extremely slow. [0003] At present, the data on the server side is sent to the client side for caching, viewing and exporting through a list control. For example, the DataSet object loads the data that the customer needs to view and export into the client memory, then binds the DataSet data through the DataGrid visual control used to display the data, and outputs the DataSet data to an Excel file to form a report document. That is to say, the DataSet can be regarded as a database in the memory of the client, and the data r...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 杨寿标
Owner FUJIAN RAYNEN TECH
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