CN104573065A - Report display engine based on metadata - Google Patents
Report display engine based on metadata Download PDFInfo
- Publication number
- CN104573065A CN104573065A CN201510036708.7A CN201510036708A CN104573065A CN 104573065 A CN104573065 A CN 104573065A CN 201510036708 A CN201510036708 A CN 201510036708A CN 104573065 A CN104573065 A CN 104573065A
- Authority
- CN
- China
- Prior art keywords
- report
- data
- metadata
- presentation engine
- interface
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/951—Indexing; Web crawling techniques
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
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
The invention belongs to Internet technical field, be specifically related to a kind of form presentation engine based on metadata.
Background technology
Existing Report Engine exploitation, configuration trouble, learning difficulty is large, cannot fast Development based on the form of online online business system (OLTP).The report data source SQL request of part is very complicated, and these SQL dynamically generate, and are difficult to again optimize.Current report management system query performance is lower, cannot make form flexibly according to customer demand, as client proposes to add up new field, needs at present to write code to realize, and does not support pictorial statement.
Summary of the invention
In order to overcome above-mentioned technical matters, the object of the present invention is to provide a kind of form presentation engine based on metadata.
The technical solution used in the present invention is:
Based on a form presentation engine for metadata, digital independent logic when carrying out parsing operation by definition metadata, constraint and interface layout, described meta-data pack is containing report heading and form field; This form presentation engine comprises:
Form display module, provides report interface and supplies user by requesting query, download report data after report interface selection querying condition;
Data source, for providing report data;
Report Engine, for: (1) receives the request that report interface is submitted to, resolves form metadata, generates final database SQL script; (2) from the data source of database, corresponding data are asked; (3) raw data that database returns hit condition is received; (4) secondary treating raw data, the data of filtering hazardous, and be converted to the visible data layout of final user.
Wherein, described report heading configuration at least comprises following information: Data Source, statement heading, export type, is used for determining that form obtains data, the statement heading of interface display and the file type of derivation from concrete that database table/view.
Described form field at least configuration packet contains display outward appearance, the behavior definition of field.
Especially, described form display module is realized by same WebForm control, and the business of its form is embodied in the query SQL of data source configuration.
Further, described form display module is used for user's direct interaction, comprises response and selects querying condition and search button; When clicking search button, the querying condition of the page and the report number of current queries are passed to Report Engine process, and wait returns results.
The invention has the beneficial effects as follows:
L can meet the various changeable demand of user, report heading configuration, form field configuration with " simply " for principle of design.
L shows and service detach, and all forms show that the business of its form is embodied in the query SQL of the configuration of database, and the business of form is displayed by the data source of consolidation form by same WebForm control realization.
L is easy to expansion, increases form and without the need to remodifying software by configuration.
L is easy to safeguard, the corresponding a form metadata of a form, and the configuration information of database, can maintain configuration information separately independent of program, and every a configuration information all can generate a form.
L optimization mass data search efficiency, shortening output time, is ensure search efficiency, and use submeter to substitute complicated storing process or direct SQL, each middle table data should retain.For the statistics of historical summary, regularly should file when time form of inquiry, avoid long-time inquiry, improve Consumer's Experience.
L ensures software performance, and use configuration to load querying condition, structure querying condition etc. and should not consume too much network, server resource, configuration information answers buffer memory.
L ensures data security, and all inquiries all should operation parameter, and word first should remove disable instruction after filtration.
Accompanying drawing explanation
Below in conjunction with accompanying drawing, the specific embodiment of the present invention is described further.
Fig. 1 is the schematic diagram of form presentation engine of the present invention;
Fig. 2 is the illustraton of model of metadata of the present invention;
Fig. 3 is the form of form display module two kinds of forms;
Fig. 4 is the process request process flow diagram of Report Engine;
Fig. 5 is the surface chart that application example report query of the present invention is shown;
Fig. 6 is the surface chart that application example of the present invention downloads form.
Embodiment
Shown in figure 1, be a kind of form presentation engine based on metadata of the present invention, digital independent logic when carrying out parsing operation by definition metadata, constraint and interface layout; This form presentation engine comprises:
Form display module, provides report interface and supplies user by requesting query, download report data after report interface selection querying condition;
Data source, for providing report data;
Report Engine, for: (1) receives the request that report interface is submitted to, resolves form metadata, generates final database SQL script; (2) from the data source of database, corresponding data are asked; (3) raw data that database returns hit condition is received; (4) secondary treating raw data, the data of filtering hazardous, and be converted to the visible data layout of final user.
As Fig. 2, described meta-data pack is containing report heading and form field, and report heading configuration mainly comprises following information: Data Source, statement heading, export type.Be used for determining that form obtains data, the statement heading of interface display and the file type of derivation from that database table/view.
Detailed report heading configuration information is as follows:
| Metadata identifies | Describe |
| name | Report name |
| reportType | Report form type, can support multiple form: form, broken line graph, histogram, pie chart |
| dataSource | Data source, supporting database table, data base view |
| fileType | Export type supports Microsoft Office Excel2003/2007, csv file |
| fileName | The filename of deriving |
| pageSize | Online query data form paging size, i.e. every page of line number loaded |
| subtitle | Chart subtitle, is applicable to broken line graph, histogram, pie chart |
| xAxis | Horizontal ordinate title, is applicable to broken line graph, histogram |
| yAxis | Ordinate title, is applicable to broken line graph, histogram |
| isAggregateEnabled | Whether use aggregate function statistical summaries data |
| showTextHeader | Whether display gauge head when deriving csv file |
| delimiter | Derive the data rows separator of csv file |
Form field configuration comprises display outward appearance, the behavior definition of field, and details are as follows:
As above, the metadata of many parts of different forms is defined by a set of metadata defining tool, comprise a series of form field configuration, the form of the different outward appearance of any amount, behavior can be created for specific data source (database table/view), thus make form as required flexibly, rapidly.
Form presentation engine of the present invention, by form display module, Report Engine and data source three decoupling zero, is beneficial to single optimization performance and does not affect respective operation, being convenient to again coordinated development/maintenance work.
As Fig. 3, form display module comprises the form of two kinds of forms:
1) form, the form of namely common two dimensional data layout.
2) graphics package is containing broken line graph, histogram and pie chart, and can be used for needs the data variation trend of display directly perceived and compare.
As Fig. 4, Report Engine, is responsible for the connection of interface and data, provides data, provide inquiry request to data source to interface, and is responsible for the filtration of data, format and output.Wherein, data filtering realizes according to the configuration of form and querying condition, can limit the form field of output; In addition, all right growth data filtering function, encrypted telephone number, password (as cell-phone number 139****1234, password * * * * * *).And data conversion is mainly for the date, exports the date (as 2013-03-15) of specified format, supports multiple date type.
Its workflow is:
1. analytic parameter, resolves the parameter imported into, the report query conditions field be converted into;
2. constructing SQL script, the SQL of dynamic construction inquiry;
3. request msg, performing database request command;
4. filter translation data, filter, transformation result collection exporting.
Data source is by data source supplier development and maintenance, and all report datas all obtain from these data sources.These report datas should ensure the accuracy of data, and the efficiency of inquiry.Do not need the outward appearance being concerned about final form during design data source, only need to pay close attention to the data being supplied to form.
General form only needs regularly to perform SQL script/storing process, statistics is kept in single database table, namely can be used as data source and is supplied to Report Engine.For the data needing real-time query, then need the logical wrapper of inquiry in data base view, Report Engine can be supplied to and use.
The accuracy of data source depends on the SQL script/storing process generating data, so data source supplier needs to provide data accurately, the data that guarantee final user receives are accurately.
The process that form presentation engine of the present invention inquires about form for user is divided into three parts clearly:
(1) form is shown for user's direct interaction, comprises response and selects querying condition and search button.When clicking search button, the querying condition of the page and the report number of current queries are passed to Report Engine process, and wait returns results.
(2) Report Engine is used for proxy data source, filters encapsulation Query Result.According to the report number passed over and querying condition, dynamic construction query SQL, it is only that following simple list is shown to inquire about (not containing the business relations between table) that this SQL should only comprise, and at most only should comprise paging logic: SELECT [field] FROM [table] WHERE [condition] ORDER BY [field].
(3) data source is purely for return data, does not make data filtering, but must ensure the correctness of data, and other form individual may need the data source providing paging.
In order to design of the present invention is described more fully, be below an actual report query interface:
A, selection querying condition
B, the field selecting needs to derive.First can select the field needed before inquiry, derived data, only be comprised the result set choosing field: as Fig. 5;
C, download form, as Fig. 6;
Each derivation form all can have record, again to download later.If the time of deriving is longer and user closes the page in the meantime, system can not stop deriving, but continues on backstage to perform.After " clicking and download ", display " just at generating report forms ... ", at this moment needs wait routine to be finished at once.
The foregoing is only preferred embodiments of the present invention, the present invention is not limited to above-mentioned embodiment, as long as the technical scheme realizing the object of the invention with basic same approach all belongs within protection scope of the present invention.
Claims (5)
1. based on a form presentation engine for metadata, it is characterized in that: digital independent logic when carrying out parsing operation by definition metadata, constraint and interface layout, described meta-data pack is containing report heading and form field; This form presentation engine comprises:
Form display module, provides report interface and supplies user by requesting query, download report data after report interface selection querying condition;
Data source, for providing report data;
Report Engine, for: (1) receives the request that report interface is submitted to, resolves form metadata, generates final database SQL script; (2) from the data source of database, corresponding data are asked; (3) raw data that database returns hit condition is received; (4) secondary treating raw data, the data of filtering hazardous, and be converted to the visible data layout of final user.
2. a kind of form presentation engine based on metadata according to claim 1, it is characterized in that: described report heading configuration at least comprises following information: Data Source, statement heading, export type, be used for determining that form obtains data, the statement heading of interface display and the file type of derivation from concrete that database table/view.
3. a kind of form presentation engine based on metadata according to claim 1, is characterized in that: described form field at least configuration packet contains display outward appearance, the behavior definition of field.
4. a kind of form presentation engine based on metadata according to claim 1, is characterized in that: described form display module is realized by same WebForm control, and the business of its form is embodied in the query SQL of data source configuration.
5. a kind of form presentation engine based on metadata according to claim 1, is characterized in that: described form display module is used for user's direct interaction, comprises response and selects querying condition and search button; When clicking search button, the querying condition of the page and the report number of current queries are passed to Report Engine process, and wait returns results.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510036708.7A CN104573065A (en) | 2015-01-23 | 2015-01-23 | Report display engine based on metadata |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510036708.7A CN104573065A (en) | 2015-01-23 | 2015-01-23 | Report display engine based on metadata |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104573065A true CN104573065A (en) | 2015-04-29 |
Family
ID=53089127
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510036708.7A Pending CN104573065A (en) | 2015-01-23 | 2015-01-23 | Report display engine based on metadata |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104573065A (en) |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105243333A (en) * | 2015-08-28 | 2016-01-13 | 苏州国云数据科技有限公司 | Multi-data-source remote access method |
| CN107193852A (en) * | 2016-08-03 | 2017-09-22 | 上海同豪土木工程咨询有限公司 | General chart expression |
| CN107656733A (en) * | 2017-08-08 | 2018-02-02 | 山东中创软件工程股份有限公司 | The visible processing method and system of a kind of business object |
| CN107832282A (en) * | 2017-11-21 | 2018-03-23 | 苏州正载信息技术有限公司 | A kind of implementation method for defining Visual Report Forms |
| CN108268525A (en) * | 2016-12-30 | 2018-07-10 | 深圳市优朋普乐传媒发展有限公司 | A kind of report implementation method and device based on Excel template |
| CN108345673A (en) * | 2018-02-09 | 2018-07-31 | 弘成科技发展有限公司 | Online adult education institution of higher learning customize report deriving method |
| CN108572945A (en) * | 2018-03-09 | 2018-09-25 | 吉贝克信息技术（北京）有限公司 | Create method, system, storage medium and the electronic equipment of report |
| CN109582937A (en) * | 2017-09-28 | 2019-04-05 | 北京国双科技有限公司 | Report form generation method, device, storage medium and processor |
| CN109933613A (en) * | 2019-03-20 | 2019-06-25 | 南京金信通信息服务有限公司 | A kind of method and system accessing SAP BW report result set |
| CN110032590A (en) * | 2019-04-15 | 2019-07-19 | 重庆天蓬网络有限公司 | A kind of data visualisation system, method, server and storage medium |
| CN111512248A (en) * | 2017-12-27 | 2020-08-07 | 西门子股份公司 | Method for the computer-aided processing of operating data of a technical system |
| CN112256710A (en) * | 2020-09-30 | 2021-01-22 | 中孚安全技术有限公司 | Metadata-based data statistical analysis chart generation system, method and equipment |
| CN113157707A (en) * | 2021-05-20 | 2021-07-23 | 国网信息通信产业集团有限公司 | Irregular report generation method and system |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101667171A (en) * | 2009-09-15 | 2010-03-10 | 金蝶软件（中国）有限公司 | Method for generating report and report generating device |
| US20100211564A1 (en) * | 2006-10-27 | 2010-08-19 | Information Builders, Inc. | Generating a file with integral dynamic reports from queries to an external database |
| US20100262443A1 (en) * | 2009-04-08 | 2010-10-14 | D Albis John N | Systems and methods associated with a collaborative strategy editor |
| CN102289460A (en) * | 2011-07-13 | 2011-12-21 | 中国工商银行股份有限公司 | Method and system for performing report metadata synchronization on testing environments |
| US20120173481A1 (en) * | 2010-12-30 | 2012-07-05 | Sap Ag | System and method of updating related documents |
| CN103064916A (en) * | 2012-12-20 | 2013-04-24 | 成都羿明科技有限公司 | Emin DI data integration engine and report generation method |
| US8856182B2 (en) * | 2008-01-25 | 2014-10-07 | Avaya Inc. | Report database dependency tracing through business intelligence metadata |
-
2015
- 2015-01-23 CN CN201510036708.7A patent/CN104573065A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100211564A1 (en) * | 2006-10-27 | 2010-08-19 | Information Builders, Inc. | Generating a file with integral dynamic reports from queries to an external database |
| US8856182B2 (en) * | 2008-01-25 | 2014-10-07 | Avaya Inc. | Report database dependency tracing through business intelligence metadata |
| US20100262443A1 (en) * | 2009-04-08 | 2010-10-14 | D Albis John N | Systems and methods associated with a collaborative strategy editor |
| CN101667171A (en) * | 2009-09-15 | 2010-03-10 | 金蝶软件（中国）有限公司 | Method for generating report and report generating device |
| US20120173481A1 (en) * | 2010-12-30 | 2012-07-05 | Sap Ag | System and method of updating related documents |
| CN102289460A (en) * | 2011-07-13 | 2011-12-21 | 中国工商银行股份有限公司 | Method and system for performing report metadata synchronization on testing environments |
| CN103064916A (en) * | 2012-12-20 | 2013-04-24 | 成都羿明科技有限公司 | Emin DI data integration engine and report generation method |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105243333A (en) * | 2015-08-28 | 2016-01-13 | 苏州国云数据科技有限公司 | Multi-data-source remote access method |
| CN107193852B (en) * | 2016-08-03 | 2020-09-29 | 上海同豪土木工程咨询有限公司 | General method of graphical representation |
| CN107193852A (en) * | 2016-08-03 | 2017-09-22 | 上海同豪土木工程咨询有限公司 | General chart expression |
| CN108268525A (en) * | 2016-12-30 | 2018-07-10 | 深圳市优朋普乐传媒发展有限公司 | A kind of report implementation method and device based on Excel template |
| CN107656733A (en) * | 2017-08-08 | 2018-02-02 | 山东中创软件工程股份有限公司 | The visible processing method and system of a kind of business object |
| CN109582937A (en) * | 2017-09-28 | 2019-04-05 | 北京国双科技有限公司 | Report form generation method, device, storage medium and processor |
| CN107832282A (en) * | 2017-11-21 | 2018-03-23 | 苏州正载信息技术有限公司 | A kind of implementation method for defining Visual Report Forms |
| CN111512248B (en) * | 2017-12-27 | 2023-06-02 | 西门子股份公司 | Method for computer-aided processing of operating data of a technical system |
| CN111512248A (en) * | 2017-12-27 | 2020-08-07 | 西门子股份公司 | Method for the computer-aided processing of operating data of a technical system |
| CN108345673A (en) * | 2018-02-09 | 2018-07-31 | 弘成科技发展有限公司 | Online adult education institution of higher learning customize report deriving method |
| CN108572945A (en) * | 2018-03-09 | 2018-09-25 | 吉贝克信息技术（北京）有限公司 | Create method, system, storage medium and the electronic equipment of report |
| CN109933613A (en) * | 2019-03-20 | 2019-06-25 | 南京金信通信息服务有限公司 | A kind of method and system accessing SAP BW report result set |
| CN110032590A (en) * | 2019-04-15 | 2019-07-19 | 重庆天蓬网络有限公司 | A kind of data visualisation system, method, server and storage medium |
| CN112256710A (en) * | 2020-09-30 | 2021-01-22 | 中孚安全技术有限公司 | Metadata-based data statistical analysis chart generation system, method and equipment |
| CN112256710B (en) * | 2020-09-30 | 2022-12-06 | 中孚安全技术有限公司 | Metadata-based data statistical analysis chart generation system, method and equipment |
| CN113157707A (en) * | 2021-05-20 | 2021-07-23 | 国网信息通信产业集团有限公司 | Irregular report generation method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104573065A (en) | Report display engine based on metadata | |
| AU2017200613B2 (en) | Enriching database query responses using data from external data sources | |
| CN105138592B (en) | A kind of daily record data storage and search method based on distributed structure/architecture | |
| US20230376487A1 (en) | Processing database queries using format conversion | |
| CN108197237B (en) | Visual data acquisition and display system | |
| CN103559217B (en) | A kind of massive multicast data towards isomeric data storehouse warehouse-in implementation method | |
| CN110717319B (en) | Self-service report generation method, device, computing equipment and system | |
| CN110032604B (en) | Data storage device, translation device and database access method | |
| CN103646073A (en) | Condition query optimizing method based on HBase table | |
| CN104102710A (en) | Massive data query method | |
| CN103020158A (en) | Report form creation method, device and system | |
| CN102917009B (en) | A kind of stock certificate data collection based on cloud computing technology and storage means and system | |
| CN104239572A (en) | System and method for achieving metadata analysis based on distributed cache | |
| CN102880676A (en) | Statistical method for user behavior data and user behavior data statistical system | |
| CN110688399A (en) | Stream type calculation real-time report system and method | |
| CN103488704A (en) | Method and device for storing data | |
| CN107506464A (en) | A kind of method that HBase secondary indexs are realized based on ES | |
| CN104572856A (en) | Converged storage method of service source data | |
| US8781919B2 (en) | Data row packing apparatus, systems, and methods | |
| CN113312376B (en) | Method and terminal for real-time processing and analysis of Nginx logs | |
| CN105608126A (en) | Method and apparatus for establishing secondary indexes for massive databases | |
| CN109388659B (en) | Data storage method, device and computer readable storage medium | |
| US20090022312A1 (en) | Apparatus and method for document synchronization | |
| CN103440302B (en) | The method and system of Real Data Exchangs | |
| US8095532B2 (en) | Apparatus and method for generating report data in a multi-user environment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150429 |
|
| RJ01 | Rejection of invention patent application after publication |