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

Method and system of generating dynamic data table

A data report and report generation technology, applied in data processing applications, electrical digital data processing, special data processing applications, etc., can solve the problems of long learning period, high learning cost, expensive expenses, etc., and achieve the effect of efficient statistics

Inactive Publication Date: 2013-06-19
QTONE EDUCATION GROUP (GUANGDONG) CO LTD
View PDF1 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

It aims to solve the problems of high cost, high learning cost and long learning period caused by using BI tools for report generation in the prior art

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 of generating dynamic data table
  • Method and system of generating dynamic data table
  • Method and system of generating dynamic data table

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] The present invention provides a dynamic data report generation method and system. In order to make the objectives, technical solutions and effects of the present invention clearer and clearer, the present invention will be described in further detail below. It should be understood that the specific embodiments described herein are only used to explain the present invention, but not to limit the present invention.

[0025] See figure 1 , Which is a flowchart of the dynamic data report generation method of the present invention. As shown in the figure, the dynamic data report generation method is used to generate several data reports, including the following steps:

[0026] S1. According to user needs, use the method of dynamically configuring SQL to process the data source and generate the first data report;

[0027] S2, according to the configured time point and generation rules, generate an intermediate cache data table corresponding to the first data report at a specified ...

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 of generating a dynamic data table. The method and the system of generating the dynamic data table adapt to flexible and variable statistic requirements through a dynamic allocating structured query language (SQL) method, deal with a Chinese enterprise statistic table with high individual requirements by means of a self-defined template method, utilize an intermediate cache table technology and permit self-defined generated cache table time, and are capable of effectively summing up a large quantity of data.

Description

Technical field [0001] The invention relates to the technical field of report generation, in particular to a method and system for generating a dynamic data report. Background technique [0002] At present, the requirements for business reports, operation reports, and operation and maintenance reports are changing, and there will be a considerable number of special statistical requirements in different periods. Traditional report statistics require R&D engineers to modify the statistical procedures and republish them according to changes in demand each time. The response cycle is long and manpower is wasted. However, the use of BI (Business Intelligence) tools is expensive, high learning costs, and long learning cycles. The statistical report uses BI overkill; especially the Chinese-style enterprise statistical report, which has relatively high individual requirements, and BI cannot fully meet it. [0003] In view of this, the existing technology needs to be improved and improved....

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/30G06Q10/10
Inventor 陈炽昌胡磊高祖辉邱友雄肖少龙
Owner QTONE EDUCATION GROUP (GUANGDONG) CO LTD
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