CN103390033A - Commercial intelligent data template as well as generating, mixing and offline using method thereof - Google Patents
Commercial intelligent data template as well as generating, mixing and offline using method thereof Download PDFInfo
- Publication number
- CN103390033A CN103390033A CN2013102869229A CN201310286922A CN103390033A CN 103390033 A CN103390033 A CN 103390033A CN 2013102869229 A CN2013102869229 A CN 2013102869229A CN 201310286922 A CN201310286922 A CN 201310286922A CN 103390033 A CN103390033 A CN 103390033A
- Authority
- CN
- China
- Prior art keywords
- data
- template
- business intelligence
- subregion
- data stream
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a generating method for a commercial intelligent data template. The generating method comprises the following steps of carrying out partition on a to-be-generated template and establishing subregional cascading relationship; respectively generating corresponding data flow on each cascaded graph zone; and generating a layout structural document, storing all data flows into a single document and establishing an index to form the commercial intelligent data template. Additionally, the invention further provides a mixing and offline using method for the commercial intelligent data template. The commercial intelligent data template as well as the generating, mixing and offline using method thereof has the beneficial effects that the adaptability is strong, the commercial intelligent data template can be used in various complex places, remarkable compatibility is also provided, and the commercial intelligent data template is convenient to be mixed with different templates for use.
Description
Technical field
The invention belongs to data processing field, especially relate to a kind of business intelligence data template and generation thereof, mixing and off-line using method.
Background technology
Business intelligence refers to utilize data warehouse, data mining technology systematically store and manage customer data, and by various data statistic analysis instruments, customer data is analyzed, provide various analysis reports, for the various business activities of enterprise provide decision information.In the business intelligence field, we often present data in templating.Present data in a kind of mode more intuitively.For decision-maker's reference.
Summary of the invention
The problem to be solved in the present invention is to provide a kind of business intelligence data template and generation, mixing and off-line using method, is particluarly suitable for using in the Various Complex situation.
1. for solving the problems of the technologies described above, the technical solution used in the present invention is: a kind of generation method of business intelligence data template comprises:
1) template that wish is generated is carried out subregion and is set up the cascade connection of subregion;
2) each chart zone of cascade is generated respectively corresponding data stream;
3) generate the layout structure file, and all data stream are deposited in single file and set up index, form the business intelligence data template.
Further, described method also comprises: comprising:
1) chart that wish is generated carries out subregion and sets up the cascade connection of subregion;
2) each chart zone of cascade is generated respectively corresponding data stream;
The data stream that 3) will generate uses respectively lossless compression algorithm to compress;
4) generate the layout structure file, and all packed datas are deposited in single file and set up index, form the business intelligence data template.
According to a further aspect in the invention, the present invention also provides a kind of business intelligence data template, and described business intelligence data template comprises:
Subregion with cascade connection;
The data stream that is used for storage icon module information;
The index that is used for explanation data stream storage information.
Further, described business intelligence data template also comprises: the data stream that is used for storage icon component institute corresponding data.
According to another aspect of the invention, the present invention also provides a kind of generation method of off-line business intelligence data template, comprising:
1) extract the data of the current demonstration of each chart assembly and buffer memory from commercial intelligent graphic table;
2) data that extraction obtained are carried out subregion by the subregion of business intelligence data template;
3) data that extract are flowed according to the subregion generated data;
4) deposit all data stream in single file, upgrade concordance list and layout structure file.
Another aspect of the present invention also provides a kind of using method of off-line business intelligence data template, comprising:
1) read business intelligence data template and generate cascade connection, and carry out layout and show;
2) search corresponding chart module data stream by concordance list;
3) use the business intelligence assembly to present template;
4) read the data stream of subregion;
5) call and present assembly, will be presented on chart for the data stream of storage icon component institute corresponding data.
According to another aspect of the invention, also provide one kind of multiple business intelligence data templates to mix the method for using, having comprised:
1) read the business intelligence data template of mixing, and carry out layout and show;
2) press concordance list and find the corresponding data stream of describing the chart subregion;
3), one by one according to each subregion inner formword form, call different product and present;
4), according to template subregion cascade connection, merge the result that presents of a plurality of products.
Advantage and good effect that the present invention has are: applicability of the present invention is strong, can use the business intelligence data template in the field of various complexity, has simultaneously good compatibility, can facilitate different templates to mix and use.
Description of drawings
Fig. 1 is business intelligence data template schematic diagram in an example of the present invention
Fig. 2 is business intelligence data template cascade connection schematic diagram in an example of the present invention
Fig. 3 is the method flow schematic diagram that an example of the present invention generates the business intelligence template
Fig. 4 is the method flow schematic diagram that an example of the present invention generates off-line business intelligence template
Fig. 5 is the method flow schematic diagram that an example of the present invention reads off-line business intelligence template
Fig. 6 is that the multiple business intelligence template of an example of the present invention is mixed the method flow schematic diagram that uses
Embodiment
Business intelligence refers to utilize data warehouse, data mining technology systematically store and manage customer data, and by various data statistic analysis instruments, customer data is analyzed, provide various analysis reports, for the various business activities of enterprise provide decision information.The business intelligence template is a kind of visual specification that presents, and is used for presenting the business intelligence data of particular topic.Be exhibition method and the effect of business intelligence data template only for given data, and do not limit data itself.In the time of running by data and business intelligence data template dynamic binding are demonstrated final business intelligence chart.
Fig. 1 is an example of the present invention, as shown in Figure 1, utilizes data model, by abundant graphical and interaction, presents data.Compare with simple data form form, more easily embody the situation of change of data, and incidence relation between data.
Simultaneously, we can also carry out interaction with chart, mouse is moved to upper left broken line graph click on certain time, and remaining three chart will carry out association and change, and shows the data message in corresponding time.
, for creating chart as described in Figure 1, at first chart is carried out subregion according to its content, and according to subregion, set up cascade connection.Chart as described in Figure 1, its classification relationship as shown in Figure 2.
With the regional chart in chart 1, for example the prize-winning situation analysis figure of each year Olympic Games, the prize-winning analysis chart of each age group, gold and silver bronze medal distribution plan and the prize-winning situation analysis figure generated data of annual project flow.
, in order to increase the attractive in appearance of whole intelligent business template and to clearly demonstrate, also can add background picture module data stream and subject text module data stream on the basis of above-mentioned data stream.
Can adopt various lossless compression algorithms to compress to each data stream, adopt in this example standard ZIP algorithm to compress, data stream after compression can can't harm and reduce the resource that it takies, adopted in this example the way that each data stream is compressed respectively, make system to carry out compression/decompression to each data stream independent (walking abreast) and process, accelerated system and processed and response speed.
After completing corresponding step, generate corresponding layout structure file, adopt in this example the XML file, XML is applicable to the electroactive marker son file makes it have structural markup language, can be used for flag data, the definition data type, the source language that to be a kind of user of permission define oneself markup language, and at XML, simply make it be easy to read and write data in any application program.And above-mentioned compressed data stream is deposited in a single binary data file, set up the corresponding relation of each compressed data stream and data model, and for above-mentioned compressed data stream, set up index, compressed data stream and formation business intelligence data template.
, for six compressed data streams of above-mentioned chart, set up the packed data concordance list as follows:
| Index number | The compressive flow position | Compressive flow length | Compressive flow is described |
| 1 | 0x40000 | 0x17 | Background picture assembly compressive flow |
| 2 | 0x40400 | 0x33 | Subject text assembly compressive flow |
| 3 | 0x40800 | 0x123 | Each year Olympic Games situation analysis figure compressive flow of winning a prize |
| 4 | 0x40C00 | 0x72 | The each age group analysis chart compressive flow of winning a prize |
| 5 | 0x41000 | 0x68 | Gold and silver bronze medal distribution plan compressive flow |
| 6 | 0x41400 | 0x54 | The prize-winning situation analysis figure compressive flow of year project |
Generate layout structure xml file following (, for clear directly perceived, having removed the attributes such as element position: left, top, width, height):
Can find out from above xml file, module information not therein, but is kept in compressed data stream, uses template-index to remove addressing packed data concordance list.
In the business intelligence field, often can not be connected with data model,, for demonstration needs, can demonstrate by off-line data.
Still, take Fig. 1 as example, can generate through the following steps off-line data
Extracted data from commercial intelligent graphic table
The extraction display data ability that can use chart assembly (the Component node in the xml file) to provide, extract the data of the current demonstration of each chart assembly and buffer memory.
The data that extraction obtains are carried out subregion by the business intelligence data template;
The method of data being carried out subregion is identical with the method that creates the business intelligence data template, is all, according to its content, chart is carried out subregion.
Data after subregion are generated corresponding data stream;
Can the data stream contents of above-mentioned generation be compressed by standard ZIP algorithm, can generate following compressed data stream altogether:
1) background picture off-line data compressive flow;
2) subject text off-line data compressive flow;
3) the prize-winning situation analysis figure off-line data compressive flow of each year Olympic Games;
4) the prize-winning analysis chart off-line data compressive flow of each age group;
5) gold and silver bronze medal distribution plan off-line data compressive flow;
6) the prize-winning situation analysis figure off-line data compressive flow of annual project
7) background picture assembly compressive flow
8) subject text assembly compressive flow
9) the prize-winning situation analysis figure compressive flow of each year Olympic Games
10) the prize-winning analysis chart compressive flow of each age group
11) gold and silver bronze medal distribution plan compressive flow
12) the prize-winning situation analysis figure compressive flow of annual project.
, according to the index situation, add the concordance list of compressed data stream as follows:
| Index number | The compressive flow position | Compressive flow length | Compressive flow is described |
| 1 | 0x40000 | 0x17 | Background picture assembly compressive flow |
| 2 | 0x40400 | 0x33 | Subject text assembly compressive flow |
| 3 | 0x40800 | 0x123 | Each year Olympic Games situation analysis figure compressive flow of winning a prize |
| 4 | 0x40C00 | 0x72 | The each age group analysis chart compressive flow of winning a prize |
| 5 | 0x41000 | 0x68 | Gold and silver bronze medal distribution plan compressive flow |
| 6 | 0x41400 | 0x54 | The prize-winning situation analysis figure compressive flow of year project |
| 7 | 0x41800 | 0x1230 | Background picture assembly off-line data stream |
| 8 | 0x42C00 | 0x8 | Subject text assembly off-line data stream |
| 9 | 0x43400 | 0x356 | The prize-winning situation analysis figure off-line data stream of each year Olympic Games |
| 10 | 0x44C00 | 0x1823 | The prize-winning analysis chart off-line data stream of each age group |
| 11 | 0x46400 | 0x1633 | Gold and silver bronze medal distribution plan off-line data stream |
| 12 | 0x47800 | 0x1208 | The prize-winning situation analysis figure off-line data stream of year project |
Simultaneously, layout structure xml file is as follows:
Can find out from above xml file, use template-index to remove addressing packed data concordance list, use data-index to remove addressing off-line data stream.
The display packing of business intelligence off-line data template still is described as an example of Fig. 1 example, and its process of display packing is for generating the inverse process of business intelligence off-line data template, and its main process is as follows:
1. read layout structure xml from commercial intelligent data template, generate tree-shaped cascade connection figure as shown in Figure 2.Start to travel through and show from tree root.System is carried out chart layout according to the Area node and is presented.
2. press index and use ZIP algorithm decompressed data template;
When the Area node is seen Component type child node, read template-index, and obtain data-bias position and data length, decompressed data in the packed data concordance list.
3. use the business intelligence product to present template;
According to the Component node type, use the suitable assembly that presents, after the use decompress(ion), module information presents;
4. read the business intelligence off-line data and decompress;
If the Component node contains the data-index attribute, according to the data-index attribute, obtain data-bias position and data length in the packed data concordance list, read and decompressed data.
With data content according to the template requirement, be presented in template for displaying.
Call and present assembly, the off-line data content is presented in chart.
In routine use, different product produces dissimilar data template usually, and these templates generally need product separately to show, the invention provides a kind of different business intelligence data template and mixes using method:
1. read the business intelligence data template of mixing, and carry out layout and show;
At first read layout structure xml from commercial intelligent data template, generate tree-shaped cascade connection figure.Start to travel through and show from tree root.System is carried out chart layout according to the Area node and is presented.
2., one by one according to each subregion inner formword form, call different product and present;
According to the Component node type, use the suitable assembly that presents, after the use decompress(ion), module information presents; According to component type, this presents assembly itself can be a gChart, and gReport or other third parties show (web control etc.), can load and show.
3., according to template subregion cascade connection, merge the result that presents of a plurality of products.
Because subregion exists, the interior assembly of subregion can not exceed zone and show, the subregion assembly, according to area size, carries out cutting to the assembly viewing area in zone and also finally is merged together, and forms a complete business intelligence chart.
In step 1, if the business intelligence data template is to compress by algorithm, by index, use its implementation procedure of algorithm decompressed data template as follows: when the Area node is seen Component type child node, read template-index, and obtain data-bias position and data length, decompressed data in the packed data concordance list.
Above one embodiment of the present of invention are had been described in detail, but described content is only preferred embodiment of the present invention, can not be considered to be used to limiting practical range of the present invention.All equalizations of doing according to the present patent application scope change and improve etc., within all should still belonging to patent covering scope of the present invention.
Claims (8)
1. the generation method of a business intelligence data template comprises:
1) template that wish is generated is carried out subregion and is set up the cascade connection of subregion;
2) each chart zone of cascade is generated respectively corresponding data stream;
3) generate the layout structure file, and all data stream are deposited in single file and set up index, form the business intelligence data template.
2. the generation method of business intelligence data template according to claim 1 comprises:
1) template that wish is generated is carried out subregion and is set up the cascade connection of subregion;
2) each chart zone of cascade is generated respectively corresponding in order to describe each chart partition data, flowing;
The data stream that 3) will generate uses respectively lossless compression algorithm to compress;
4) generate the layout structure file, and all packed datas are deposited in single file and set up index, form the business intelligence data template.
3. the generation method of business intelligence data template according to claim 2, it is characterized in that: described step 3 Application standard ZIP algorithm compresses.
4. one kind generates the business intelligence data template that the method for claim 1 generates, and described business intelligence data template comprises:
Subregion with cascade connection;
Be used for describing the data stream of storage icon module information;
The index that is used for explanation data stream storage information.
5. business intelligence data template according to claim 4, it is characterized in that: described business intelligence data template also comprises: the data stream that is used for storage icon component institute corresponding data.
6. method that generates business intelligence data template as claimed in claim 5 comprises:
1) extract the data of the current demonstration of each chart assembly and buffer memory from commercial intelligent graphic table;
2) data that extraction obtained are carried out subregion by the subregion of business intelligence data template;
3) data that extract are flowed according to the subregion generated data;
4) deposit all data stream in single file, upgrade concordance list and layout structure file.
7. the display packing of a business intelligence data template as claimed in claim 5 comprises:
1) read business intelligence data template and generate cascade connection, and carry out layout and show;
2) search corresponding chart module data stream by concordance list;
3) use the business intelligence assembly to present template;
4) read the data stream that is used for storage icon component institute corresponding data of each subregion;
5) call and present assembly, will be presented on chart for the data stream of storage icon component institute corresponding data.
8. method of mixing multiple business intelligence data template as claimed in claim 4 comprises:
1) read the business intelligence data template of mixing, and carry out layout and show;
2) press concordance list and find the corresponding data stream of describing the chart subregion;
3), one by one according to each subregion inner formword form, call different product and present;
4), according to template subregion cascade connection, merge the result that presents of a plurality of products.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013102869229A CN103390033A (en) | 2013-07-09 | 2013-07-09 | Commercial intelligent data template as well as generating, mixing and offline using method thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013102869229A CN103390033A (en) | 2013-07-09 | 2013-07-09 | Commercial intelligent data template as well as generating, mixing and offline using method thereof |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103390033A true CN103390033A (en) | 2013-11-13 |
Family
ID=49534305
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2013102869229A Pending CN103390033A (en) | 2013-07-09 | 2013-07-09 | Commercial intelligent data template as well as generating, mixing and offline using method thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103390033A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060116859A1 (en) * | 2004-11-30 | 2006-06-01 | Thomas Legault | Reporting model generation within a multidimensional enterprise software system |
| CN101344881A (en) * | 2007-07-09 | 2009-01-14 | 中国科学院大气物理研究所 | Index generation method and device and search system for mass file type data |
| CN101620591A (en) * | 2009-08-12 | 2010-01-06 | 国网电力科学研究院 | Method for designing module report form layout based on cell mode |
| CN101950299A (en) * | 2010-09-21 | 2011-01-19 | 浙江大学 | Method for compressing and verifying zip file format of mobile widget |
| CN102129476A (en) * | 2011-04-22 | 2011-07-20 | 上海网达软件有限公司 | Application of virtual file system by utilizing ZIP compression format |
| CN102609967A (en) * | 2012-02-17 | 2012-07-25 | 杭州电子科技大学 | Generating and typesetting method of image-text report |
-
2013
- 2013-07-09 CN CN2013102869229A patent/CN103390033A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060116859A1 (en) * | 2004-11-30 | 2006-06-01 | Thomas Legault | Reporting model generation within a multidimensional enterprise software system |
| CN101344881A (en) * | 2007-07-09 | 2009-01-14 | 中国科学院大气物理研究所 | Index generation method and device and search system for mass file type data |
| CN101620591A (en) * | 2009-08-12 | 2010-01-06 | 国网电力科学研究院 | Method for designing module report form layout based on cell mode |
| CN101950299A (en) * | 2010-09-21 | 2011-01-19 | 浙江大学 | Method for compressing and verifying zip file format of mobile widget |
| CN102129476A (en) * | 2011-04-22 | 2011-07-20 | 上海网达软件有限公司 | Application of virtual file system by utilizing ZIP compression format |
| CN102609967A (en) * | 2012-02-17 | 2012-07-25 | 杭州电子科技大学 | Generating and typesetting method of image-text report |
Non-Patent Citations (1)
| Title |
|---|
| 畅享博客: "[原创]图表联动——三个图表的联动", 《畅享博客，HTTP://BLOG.VSHARING.COM/FANFANZHENG/A1692168.HTML》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Burgess et al. | Social media rituals: The uses of celebrity death in digital culture | |
| Boellstorff | When marriage falls: Queer coincidences in straight time | |
| Wilkins | The history of multinational enterprise | |
| Dent | The Roaring 2000's: Building the Wealth and Lifestyle You Desire in the Greatest Boom in History | |
| CN105512382B (en) | The conversion of floor piecemeal and combined method and system based on BIM | |
| Shneiderman et al. | Interactive network exploration to derive insights: Filtering, clustering, grouping, and simplification | |
| CN103019682A (en) | Method for displaying date by combining user-defined graphics into SVG (Scalable Vector Graphics) | |
| Thomas | The mediatization of religion–as temptation, seduction, and illusion | |
| Wang et al. | SentiCompass: Interactive visualization for exploring and comparing the sentiments of time-varying Twitter data | |
| CN105138532B (en) | The methods, devices and systems of business data processing | |
| Simoni et al. | Boosting the pre-purchase experience through virtual reality. Insights from the cruise industry | |
| Earle | Exchange systems in prehistory | |
| Broccolini | Intangible cultural heritage scenarios within the bureaucratic Italian state | |
| Hanusch | Journalism and everyday life | |
| Kuznetsova et al. | Phenomenon of mass culture: problems and controversies | |
| Kozachenko | Horizon scanning report: ICT and migration | |
| CN103390033A (en) | Commercial intelligent data template as well as generating, mixing and offline using method thereof | |
| Torche | Social status and public cultural consumption: Chile in comparative perspective | |
| Roderick | Form from form: The case for exaptation in rhetorical genre evolution | |
| Nicholson | Looming Large: America and the Late-Victorian Press, 1865-1902 | |
| Arriagada et al. | Not natural, nor neutral: The cultural configurations of social media affordances within Chilean influencer industry | |
| Taqiyuddin et al. | THEOSEMIOTIC: NEW APPROACH IN THE NEW TRENDS OF ISLAMIC DA'WA | |
| Svarin | The Meaning of Geopolitical Space: The Importance of Eurasia for Russia and Turkey | |
| Mutanda et al. | Demography of African Family: Nineteenth to Twenty-First Century | |
| Bowditch et al. | May We Have Your Attention Please? Climate Change is Urgent and Change Needs to Happen Now |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20131113 |