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

Report display engine based on metadata

A metadata and report technology, applied in the Internet field, can solve the problems of report engine development, troublesome configuration, low query performance, and difficult learning

Inactive Publication Date: 2015-04-29
GUANGDONG NENGLONG EDUCATION
View PDF7 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] The existing report engine development and configuration are cumbersome and difficult to learn, making it impossible to quickly develop reports based on the online business system (OLTP)
SQL requests for some report data sources are extremely complex, and these SQLs are dynamically generated and difficult to optimize
The query performance of the current report management system is low, and reports cannot be flexibly produced according to customer needs. If the customer proposes a new field for statistics, it is currently necessary to write code to achieve it, and does not support graphical reports.

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
  • Report display engine based on metadata
  • Report display engine based on metadata
  • Report display engine based on metadata

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] refer to figure 1 As shown, it is a metadata-based report display engine of the present invention, which analyzes the runtime data reading logic, constraints and interface layout by defining metadata; the report display engine includes:

[0029] The report display module provides a report interface and allows users to request query and download report data after selecting query conditions through the report interface;

[0030] Data source, used to provide report data;

[0031] The report engine is used to: (1) receive the request submitted by the report interface, parse the report metadata, and generate the final database SQL script; (2) request the corresponding data from the data source of the database; (3) receive the hit condition returned by the database (4) Secondary processing of raw data, filtering dangerous data, and converting it into a data format visible to end users.

[0032] Such as figure 2 , the metadata includes the report header and report fields, ...

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 report display engine based on metadata. By defining the metadata, data reading logic, constraint and interface layout during the operation are analyzed. The metadata include a report header and a report field definition. The report engine determines data sources, report titles, the file outputting type and other main information by reading the report header, then integrates the report field definition to search and filter the data during operation and returns to a result set, and finally, based on the report header and the report field definition, determines the report display mode and outputs the same to the clients. The report display engine has the advantages that the standard metadata model is defined, flexible configuration is characterized, and the further metadata expanding is supported; at the premise that the maintainability is guaranteed, the report yield is increased, fast development is supported, and adaptability to the report system requiring frequent changes is achieved.

Description

technical field [0001] The invention belongs to the technical field of the Internet, and in particular relates to a report display engine based on metadata. Background technique [0002] The existing report engine is cumbersome to develop and configure, and difficult to learn, making it impossible to quickly develop reports based on the online business system (OLTP). SQL requests for some report data sources are extremely complex, and these SQLs are dynamically generated and difficult to optimize. The query performance of the current report management system is low, and reports cannot be flexibly produced according to customer needs. If the customer proposes a new field for statistics, it is currently necessary to write code to implement it, and does not support graphical reports. Contents of the invention [0003] In order to overcome the above technical problems, the purpose of the present invention is to provide a report display engine based on metadata. [0004] The ...

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/30
CPCG06F16/951G06F16/248
Inventor 余敬龙
Owner GUANGDONG NENGLONG EDUCATION
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