A method and device for automatically updating reports

An automatic update and report technology, applied in the database field, can solve the problems of increasing the load of the report server, slow report access, insufficient server resources, etc., to achieve the effect of improving the viewing speed, reducing the load, and avoiding insufficient server resources.

Active Publication Date: 2017-05-03
ADVANCED NEW TECH CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The problem in the above prior art is that if a report uses multiple tables with a large amount of data for association, it will take a long time to refresh the report and consume a lot of computing resources; and when multiple people view a report at the same time or multiple reports, opening each report needs to be refreshed again, a large number of refreshes will increase the load on the report server, slow down the access to other reports, and may even lead to insufficient server resources, affecting the normal operation of the system

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
  • A method and device for automatically updating reports
  • A method and device for automatically updating reports
  • A method and device for automatically updating reports

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0050] In order to make the above objects, features and advantages of the present application more obvious and comprehensible, the present application will be further described in detail below in conjunction with the accompanying drawings and specific implementation methods.

[0051] refer to figure 1 , which shows a flow chart of Embodiment 1 of a method for automatic report update of the present application, which may specifically include the following steps:

[0052] Step 101, collecting reports and dependencies of each task in the data warehouse.

[0053] In a preferred embodiment of the present application, the step 101 may include:

[0054] Sub-step S11, extracting the dependency relationship between the report and the data table at the report application side;

[0055] Sub-step S12 , for each report, search the data warehouse for the tasks corresponding to the data tables on which each data table depends, and obtain the tasks on which each report depends.

[0056] T...

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 provides a method and a device for automatically updating reports. The method comprises the steps that the dependency relationship of all tasks in a report and data warehouse is collected; all the tasks in the report and data warehouse are dispatched and executed, and whether the tasks which all the reports depend on are executed is judged according to the dependency relationship; and if yes, the application end of the reports is triggered and the corresponding reports are refreshed. By utilizing the method, the latest data can be obtained without manual refreshing, and the load of a server is relieved.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a method and device for automatically updating reports. Background technique [0002] The data warehouse is an independent data environment. Through the extraction process, data is imported from the online transaction processing environment, external data sources and offline data storage media (such as databases) into the data warehouse, and the data of different data sources is separated to form Unified and effective data sets, and finally processed and converted into data tables (tables) suitable for extraction of various reports (reports). [0003] The data warehouse manages the tasks of the data warehouse through the scheduling system, such as Figure 5 A schematic diagram of the report generation is given. Before the data warehouse scheduling system starts tasks, it will generate the scheduling tasks of the day to manage the execution of multiple tasks. Each tas...

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 Patents(China)
IPC IPC(8): G06F17/30
CPCG06F16/28G06F16/283
Inventor 李小健
Owner ADVANCED NEW TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap