CN104615725A - Web-based online self-defined reporting method - Google Patents
Web-based online self-defined reporting method Download PDFInfo
- Publication number
- CN104615725A CN104615725A CN201510065070.XA CN201510065070A CN104615725A CN 104615725 A CN104615725 A CN 104615725A CN 201510065070 A CN201510065070 A CN 201510065070A CN 104615725 A CN104615725 A CN 104615725A
- Authority
- CN
- China
- Prior art keywords
- data
- report
- selects
- self
- sing
- 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.)
- Granted
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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- 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
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Information Transfer Between Computers (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a Web-based online self-defined reporting method. The method comprises the steps that 1, a data exchange tool extracts data in an isomerous database to a center database in a unified mode; 2, predefined unified formatting is conducted on the data by the center database; 3, the formatted data are stored in the center database in a unified mode; 4, the basic information of a report is initialized according to a predefined configuration rule; 5, self-defined reporting is achieved by means of a front navigation type self-defined reporting tool. The method has the advantage that online self-defined reporting is achieved through the HTML5 language and the JavaScript language, access can be achieved simply through a browser based on the simplicity of Internet, and smooth and good user experience is obtained.
Description
Technical field
The present invention relates to computer information and information visualization switching technology field, in particular to a kind of online self-defined report implementation method of sing on web.
Background technology
Form is ingredient important in information system, particularly intelligent analysis system, the raising required along with social informatization and the development of Information Visualization Technology, complex report forms presents the features such as Data Source difference, data structure is different, data content is changeable, report style is various, and traditional fixing form and flexible report technology have been not suitable with the new demand of form.For many B/S and C/S application systems, user needs a large amount of statistical forms, particularly needs remote inquiry, and the mode based on browser provides Web form to be most convenient.
Summary of the invention
For solving the problem, a kind of mode based on browser is the object of the present invention is to provide to provide the method for Web form.
The invention provides a kind of online self-defined report implementation method of sing on web, the method comprises the following steps:
Step 1, data exchange tool extracts unified for the data in heterogeneous database to central database;
Step 2, described central database carries out predefined consolidation form to described data;
Step 3, the data after unified storage format are to described central database;
Step 4, according to predefined configuration rule, the Back ground Information of initialization form;
Step 5, the navigation-type self-defined report instrument utilizing front end to realize completes self-defined report.
Wherein, step 5 comprises:
Step 501, selects data source, the tables of data of data source described in Auto-matching;
Step 502, selects described tables of data, the data rows of tables of data described in Auto-matching;
Step 503, selects described data rows;
Step 504, selects whether create figure, if then carry out step 505, otherwise carry out step 507;
Step 505, selects pattern classes and creates figure, selects the type generating figure;
Step 506, selects the layout pattern of report pattern and grid;
Step 507, selects dimension to carry out packet, divides into groups and sort to described data rows;
Step 508, according to the report data that above-mentioned steps generates in real time, carries out form preview;
Step 509, form is submitted to, is preserved by the configuration information of above-mentioned steps, is completed the inquiry of form by the configuration of authority.
Further improve as the present invention, front end adopts HTML5 language and JavaScript language to build view MAC layer, service layer adopts Web Api framework to carry out the mutual of data and transmission, rear end adopts SQL SERVER language as persistent layer, carries out gathering of data and clean data source.
Further improve as the present invention, described data exchange tool adopts ETL.
Further improve as the present invention, described data comprise data source, tables of data, data rows and data rows type.
Further improve as the present invention, described navigation-type self-defined report instrument realizes report form template rule, described report form template rule is divided into form immobilized substance and form variation content, described form immobilized substance comprises form classification, form field and statement form, and described form variation content comprises form content, form dimension, report pattern and Report layouts's pattern.
Further improve as the present invention, the type of figure described in step 505 comprises: pie chart, column diagram and trend map.
Further improve as the present invention, described in step 506, layout pattern comprises: described figure is positioned on the left of described grid, described figure is positioned on the right side of described grid, described figure is positioned at above described grid and described figure is positioned at below described grid.
Beneficial effect of the present invention is: achieve online self-defined report implementation method by HTML5 language and JavaScript language, based on the parsimony of internet, just can need only be conducted interviews by browser, obtains smooth and good Consumer's Experience.
Accompanying drawing explanation
The process flow diagram of the online self-defined report implementation method that Fig. 1 is a kind of sing on web described in the embodiment of the present invention.
Fig. 2 is the process flow diagram of step 5 in the embodiment of the present invention.
Embodiment
Also by reference to the accompanying drawings the present invention is described in further detail below by specific embodiment.
As shown in Figure 1, the online self-defined report implementation method of a kind of sing on web described in the embodiment of the present invention, the method comprises the following steps:
Step 1, data exchange tool ETL extracts unified for the data in heterogeneous database to central database;
Step 2, central database carries out predefined consolidation form to data;
Step 3, the data after unified storage format are to central database;
Step 4, according to predefined configuration rule, the Back ground Information of initialization form;
Step 5, the navigation-type self-defined report instrument utilizing front end to realize completes self-defined report.
Wherein, data comprise data source, tables of data, data rows and data rows type.
As shown in Figure 2, step 5 specifically comprises the following steps:
Step 501, selects data source, the tables of data in Automatic Adaptation Data source;
Step 502, selects tables of data, the data rows of Automatic Adaptation Data table;
Step 503, selects data rows;
Step 504, selects whether create figure, if then carry out step 505, otherwise carry out step 507;
Step 505, selects pattern classes and creates figure, selects the type generating figure, comprises pie chart, column diagram and trend map;
Step 506, selects the layout pattern of report pattern and grid, comprises that figure is positioned on the left of grid, figure is positioned on the right side of grid, figure is positioned at above grid and figure is positioned at below grid;
Step 507, selects dimension to carry out packet, divides into groups and sort to data rows;
Step 508, according to the report data that above-mentioned steps generates in real time, carries out form preview;
Step 509, form is submitted to, is preserved by the configuration information of above-mentioned steps, is completed the inquiry of form by the configuration of authority.
Front end adopts HTML5 language and JavaScript language to build view MAC layer, and service layer adopts Web Api framework to carry out the mutual of data and transmission, and rear end adopts SQL SERVER language as persistent layer, carries out gathering of data and clean data source.
Navigation-type self-defined report instrument realizes report form template rule, and report form template rule is divided into form immobilized substance and form variation content.Form immobilized substance comprises form classification, form field and statement form.Form variation content comprises form content, form dimension, report pattern and Report layouts's pattern.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (8)
1. an online self-defined report implementation method for sing on web, is characterized in that, comprise the following steps:
Step 1, data exchange tool extracts unified for the data in heterogeneous database to central database;
Step 2, described central database carries out predefined consolidation form to described data;
Step 3, the data after unified storage format are to described central database;
Step 4, according to predefined configuration rule, the Back ground Information of initialization form;
Step 5, the navigation-type self-defined report instrument utilizing front end to realize completes self-defined report.
2. the online self-defined report implementation method of a kind of sing on web according to claim 1, it is characterized in that, step 5 specifically comprises the following steps:
Step 501, selects data source, the tables of data of data source described in Auto-matching;
Step 502, selects described tables of data, the data rows of tables of data described in Auto-matching;
Step 503, selects described data rows;
Step 504, selects whether create figure, if then carry out step 505, otherwise carry out step 507;
Step 505, selects pattern classes and creates figure, selects the type generating figure;
Step 506, selects the layout pattern of report pattern and grid;
Step 507, selects dimension to carry out packet, divides into groups and sort to described data rows;
Step 508, according to the report data that above-mentioned steps generates in real time, carries out form preview;
Step 509, form is submitted to, is preserved by the configuration information of above-mentioned steps, is completed the inquiry of form by the configuration of authority.
3. the online self-defined report implementation method of a kind of sing on web according to claim 1, it is characterized in that, front end adopts HTML5 language and JavaScript language to build view MAC layer, service layer adopts Web Api framework to carry out the mutual of data and transmission, rear end adopts SQL SERVER language as persistent layer, carries out gathering of data and clean data warehouse.
4. the online self-defined report implementation method of a kind of sing on web according to claim 1, is characterized in that, described data exchange tool adopts ETL.
5. the online self-defined report implementation method of a kind of sing on web according to claim 1, is characterized in that, described data comprise data source, tables of data, data rows and data rows type.
6. the online self-defined report implementation method of a kind of sing on web according to claim 1, it is characterized in that, described navigation-type self-defined report instrument realizes report form template rule, described report form template rule is divided into form immobilized substance and form variation content, described form immobilized substance comprises form classification, form field and statement form, and described form variation content comprises form content, form dimension, report pattern and Report layouts's pattern.
7. the online self-defined report implementation method of a kind of sing on web according to claim 2, it is characterized in that, the type of figure described in step 505 comprises: pie chart, column diagram and trend map.
8. the online self-defined report implementation method of a kind of sing on web according to claim 2, it is characterized in that, described in step 506, layout pattern comprises: described figure is positioned on the left of described grid, described figure is positioned on the right side of described grid, described figure is positioned at above described grid and described figure is positioned at below described grid.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510065070.XA CN104615725B (en) | 2015-02-09 | 2015-02-09 | A kind of online self-defined report implementation method based on Web |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510065070.XA CN104615725B (en) | 2015-02-09 | 2015-02-09 | A kind of online self-defined report implementation method based on Web |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104615725A true CN104615725A (en) | 2015-05-13 |
| CN104615725B CN104615725B (en) | 2018-03-16 |
Family
ID=53150167
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510065070.XA Active CN104615725B (en) | 2015-02-09 | 2015-02-09 | A kind of online self-defined report implementation method based on Web |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104615725B (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105677835A (en) * | 2016-01-04 | 2016-06-15 | 浪潮软件集团有限公司 | Method and device for making data visualization chart |
| CN106503202A (en) * | 2016-10-26 | 2017-03-15 | 广州市勤思网络科技有限公司 | The Dynamic Configuration that a kind of data drawing list linkage shows |
| CN106528741A (en) * | 2016-11-04 | 2017-03-22 | 浪潮软件集团有限公司 | Visualization implementation method based on big data |
| CN106598925A (en) * | 2016-11-22 | 2017-04-26 | 广州悦审软件科技有限公司 | Method and system for quickly generating department final statement report data |
| CN106599267A (en) * | 2016-12-22 | 2017-04-26 | 北京锐安科技有限公司 | Method and device for deleting data |
| CN106980670A (en) * | 2017-03-23 | 2017-07-25 | 深圳市证通电子股份有限公司 | Transaction message generation method and system |
| CN108446309A (en) * | 2018-02-05 | 2018-08-24 | 深圳市资本在线金融信息服务有限公司 | The application process and device of WEB intelligent report forms |
| CN112000644A (en) * | 2020-08-21 | 2020-11-27 | 北京浪潮数据技术有限公司 | Data processing method and system, electronic equipment and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120019089A1 (en) * | 2010-07-21 | 2012-01-26 | Asmo Co., Ltd. | Motor |
| CN103984755A (en) * | 2014-05-28 | 2014-08-13 | 中国地质大学（北京） | Multidimensional model based oil and gas resource data key system implementation method and system |
| CN104281447A (en) * | 2014-09-01 | 2015-01-14 | 国家电网公司 | Report form fast generating and issuing system and method |
-
2015
- 2015-02-09 CN CN201510065070.XA patent/CN104615725B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120019089A1 (en) * | 2010-07-21 | 2012-01-26 | Asmo Co., Ltd. | Motor |
| CN103984755A (en) * | 2014-05-28 | 2014-08-13 | 中国地质大学（北京） | Multidimensional model based oil and gas resource data key system implementation method and system |
| CN104281447A (en) * | 2014-09-01 | 2015-01-14 | 国家电网公司 | Report form fast generating and issuing system and method |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105677835A (en) * | 2016-01-04 | 2016-06-15 | 浪潮软件集团有限公司 | Method and device for making data visualization chart |
| CN106503202A (en) * | 2016-10-26 | 2017-03-15 | 广州市勤思网络科技有限公司 | The Dynamic Configuration that a kind of data drawing list linkage shows |
| CN106528741A (en) * | 2016-11-04 | 2017-03-22 | 浪潮软件集团有限公司 | Visualization implementation method based on big data |
| CN106598925A (en) * | 2016-11-22 | 2017-04-26 | 广州悦审软件科技有限公司 | Method and system for quickly generating department final statement report data |
| CN106599267A (en) * | 2016-12-22 | 2017-04-26 | 北京锐安科技有限公司 | Method and device for deleting data |
| CN106980670A (en) * | 2017-03-23 | 2017-07-25 | 深圳市证通电子股份有限公司 | Transaction message generation method and system |
| CN108446309A (en) * | 2018-02-05 | 2018-08-24 | 深圳市资本在线金融信息服务有限公司 | The application process and device of WEB intelligent report forms |
| CN112000644A (en) * | 2020-08-21 | 2020-11-27 | 北京浪潮数据技术有限公司 | Data processing method and system, electronic equipment and storage medium |
| CN112000644B (en) * | 2020-08-21 | 2022-08-02 | 北京浪潮数据技术有限公司 | Data processing method and system, electronic equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104615725B (en) | 2018-03-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104615725A (en) | Web-based online self-defined reporting method | |
| Colezea et al. | CLUeFARM: Integrated web-service platform for smart farms | |
| Anderson | Reflections on environmental communication and the challenges of a new research agenda | |
| CN105843945A (en) | Report generation method and system | |
| CN106462559B (en) | Arbitrary size content item generates | |
| CN105518658A (en) | Apparatus, systems, and methods for grouping data records | |
| Marcus et al. | Tweets as data: demonstration of tweeql and twitinfo | |
| CN106503202A (en) | The Dynamic Configuration that a kind of data drawing list linkage shows | |
| Derudder et al. | The connectivity of South Asian cities in infrastructure networks | |
| CN104361054A (en) | Method and system for restructuring, positioning and visualizing line loss of electric power system | |
| CN103310362A (en) | Intelligent broadcast and television marketing assisting method and system based on GPS (globe positioning system) positioning | |
| CN101877087A (en) | System and method for monitoring and surveying floating population based on space position | |
| CN103136791A (en) | Data association method and data association device used for airplane digitalization maintenance and application | |
| Widjaja et al. | Modeling coordinated multiple views of heterogeneous data cubes for urban visual analytics | |
| CN104268238A (en) | Configurable cost distribution calculation method based on open source technology | |
| CN109360106A (en) | Portrait construction method, system, medium and computer system | |
| CN104794637A (en) | Base station radio based user data aggregation and interaction method and system | |
| CN104317600B (en) | A kind of configurable curve drawing generating method and system | |
| CN107515913A (en) | A kind of multivariate data model integrated construction method and its virtual interactive interface system | |
| CN102522045B (en) | Network video on-line geographic positioning system based on social information | |
| Aguilar Morales et al. | Designing of an enterprise resource planning for the optimal management of agricultural plots regarding quality and environmental requirements | |
| Wu et al. | The analysis method of visual information searching in the human-computer interactive process of intelligent control system | |
| CN103984724A (en) | Visualization interaction method based on space optimization tree layout | |
| US9128908B2 (en) | Converting reports between disparate report formats | |
| Palmer | Birds of a feather: the geographic interconnection of Australian universities on Twitter |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20180207 Address after: 430000, East Lake New Technology Development Zone, Wuhan, Hubei, China. 33, huomin science and Technology Park, innovation base, office building 18, 2 floors, 9 rooms, Kamel, new media, 08, Applicant after: Wuhan Zhong Lian Technology Co., Ltd. Address before: 430000 Hubei Province, Wuhan city Hongshan District Luoyu Road No. 1037 Applicant before: WUHAN ZHONGLIAN INFORMATION TECHNOLOGY CO., LTD. |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |