CN104317936A - ROLAP (relational on-line analysis processing) analysis engine design method and device on basis of star models - Google Patents
ROLAP (relational on-line analysis processing) analysis engine design method and device on basis of star models Download PDFInfo
- Publication number
- CN104317936A CN104317936A CN201410602643.3A CN201410602643A CN104317936A CN 104317936 A CN104317936 A CN 104317936A CN 201410602643 A CN201410602643 A CN 201410602643A CN 104317936 A CN104317936 A CN 104317936A
- Authority
- CN
- China
- Prior art keywords
- rolap
- dimensional database
- data
- designer
- buffer memory
- 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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
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)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a ROLAP (relational on-line analysis processing) analysis engine design method and device on the basis of star models. The ROLAP analysis engine design method on the basis of the star models includes defining a ROLAP analyzer comprising a plurality of areas, wherein the ROLAP analyzer at least comprises a data set area and a design panel area; acquiring data pattern information of multi-dimensional database in the data set area, and displaying the acquired data pattern information in the design panel area in a list manner; setting up a ROLAP analysis mode of the multi-dimensional database according to the acquired data mode information; organizing the star models of the multi-dimensional database according to the setup ROLAP analysis mode of the multi-dimensional database and storing the organized star models of the multi-dimensional database into semantic object storage files. By the ROLAP analysis engine design method, the problem that existing ROLAP analysis engines are too complicated can be solved.
Description
Technical field
The present invention relates to multidimensional analysis technical field, be specifically related to a kind of ROLAP analytics engine method for designing based on Star Model and device.
Background technology
ROLAP (Relational On-Line Analysis Processing, relation on-line analytical processing) represents that the OLAP based on relational database realizes (Relational OLAP).Take relational database as core, relational structures carries out expression and the storage of multidimensional data.The multidimensional structure of multi-dimensional database is divided into two class tables by ROLAP: a class is fact table, is used for storing data and dimension key word; Another kind of is dimension table, namely at least uses a table to deposit the descriptor of the dimension such as level, member's classification of dimension to each dimension.From technical standpoint, ROLAP (MicroStrategy realization) and MOLAP (realization such as Metacube or Cognos) is each has something to recommend him.The former is based on relevant database, its OLAP engine is exactly operated by the OLAP of user, as above brill, lower brill, filtration or merging etc., convert SQL statement to be submitted in database and to perform, and provide aggregation navigation function, the fact table according to the dimension of user operation and tolerance SQL query being navigated to most coarseness gets on.Comparatively speaking, combined data calculates by MOLAP in advance, leaves in oneself specific multi-dimensional database, and the OLAP operation of user can map directly to the access of multi-dimensional database, does not need to be accessed by SQL.Therefore, both differences are alternatively that ROLAP provides larger flexibility ratio, but may this flexibility ratio just, cause the unfriendly impression that user is used, ROLAP compares Metacube and Cognos, and complicated operation is many, but this problem can be improved.Up to now, existing many foreign vendors are proposed OLAP solution and the product of comparative maturity, but due to factors such as language, custom, prices, are not necessarily applicable to domestic enterprise; A lot of more ripe OLAP scheme be C/S (client/server) structure need client is installed; And current ROLAP is by generating SQL dynamically, do query relation type database, if database does not do performance optimization, time data volume is very large, performance issue will seem to compare and highlight.
Summary of the invention
Technical matters to be solved by this invention is to provide a kind of ROLAP analytics engine method for designing based on Star Model and device, can solve the problem that other similar system is too complicated.
According to one aspect of the present invention, provide a kind of ROLAP analytics engine method for designing based on Star Model, comprising:
Definition one comprises the ROLAP designer in multiple region, and described ROLAP designer at least comprises a data set region and a design panel zone;
Obtain the data pattern information of multi-dimensional database in described data set region, and the data pattern information of described acquisition is represented at described design panel zone in the mode of list;
According to the data pattern information of described acquisition, set up the ROLAP analytical model of multi-dimensional database;
Organize the Star Model of multi-dimensional database according to the ROLAP analytical model of the multi-dimensional database set up, and the Star Model of the multi-dimensional database of described tissue is stored in semantic object storage file.
According to another aspect of the present invention, provide a kind of ROLAP analytics engine design apparatus based on Star Model, comprising:
Designer definition module, for defining the ROLAP designer that comprises multiple region, described ROLAP designer at least comprises a data set region and a design panel zone;
Data obtaining module, for obtaining the data pattern information of multi-dimensional database in described data set region, and represents the data pattern information of described acquisition at described design panel zone in the mode of list;
Analytical model sets up module, for the data pattern information according to described acquisition, sets up the ROLAP analytical model of multi-dimensional database;
Star Model molded tissue block, for organizing the Star Model of multi-dimensional database according to the ROLAP analytical model of the multi-dimensional database set up, and is stored in the Star Model of the multi-dimensional database of described tissue in semantic object storage file.
A kind of ROLAP analytics engine method for designing based on Star Model provided by the invention and device, first the ROLAP designer that comprises multiple region is defined, then on the data set region of ROLAP designer, obtain the data pattern information of multi-dimensional database, and present in the mode of list; According to the data pattern information obtained, set up the ROLAP analytical model of multi-dimensional database, finally organize the Star Model of multi-dimensional database according to the ROLAP analytical model set up, and be stored in semantic object storage file.By definition ROLAP designer, pull operation in the pop-up of designer panel and namely can complete modelling work, solve the problem that other similar system is too complicated, original system constructing is become more easy-to-use, more intuitively, more rapidly " Web page application program ", improves the friendliness at interface; The contrast at present ROLAP designer of a lot of C/S framework does not need to install client, can auto-update.
Accompanying drawing explanation
Fig. 1 is a kind of ROLAP analytics engine method for designing process flow diagram based on Star Model of the embodiment of the present invention one;
Fig. 2 is the ROLAP designer panel schematic diagram of definition in the embodiment of the present invention one;
Fig. 3 obtains data pattern information failure schematic diagram in the embodiment of the present invention one;
Fig. 4 is fact table schematic diagram of the present invention;
Fig. 5 is the field information obtained from data set region in the embodiment of the present invention one;
Fig. 6 is definition tolerance and compute mode schematic diagram in the embodiment of the present invention one;
Fig. 7 is computation measure schematic diagram in the embodiment of the present invention one;
Fig. 8 builds Star Model schematic diagram in the embodiment of the present invention one;
Fig. 9 is a kind of ROLAP analytics engine design apparatus schematic diagram based on Star Model of the embodiment of the present invention two.
Embodiment
Be described principle of the present invention and feature below in conjunction with accompanying drawing, example, only for explaining the present invention, is not intended to limit scope of the present invention.
Embodiment one, a kind of ROLAP analytics engine method for designing based on Star Model.Below in conjunction with Fig. 1-Fig. 9, the method that the present embodiment provides is described in detail.
In Fig. 1, the ROLAP designer that S101, definition one comprise multiple region, this ROLAP designer at least comprises a data set region and a design panel zone.
Concrete, the present embodiment adopts Flex rich client visualization technique to design ROLAP (Relation On-Line Analysis Processing, relation on-line analytical processing) analysis tool, Flex technology can be integrated with enterprise-level application architecture usually well, is built into by original analytics engine more easy-to-use, more intuitively, more rapidly " Web page application program ".Under the prerequisite that can not have influence on original application, RIA (Rich Internet Applications, rich internet is applied) technology carried out significantly strengthening to presentation layer, improve the friendliness at interface further, reduce the remote interaction frequency of user and system, reduce bandwidth demand, contrast is a lot of C/S (Client/Server at present, Client/Server) the ROLAP designer of framework, ROLAP designer in the present embodiment is based on B/S (Browser/Server, Browser/Server Mode) framework, do not need additionally client to be installed, browser is only needed to have flash plug-in unit.
During concrete enforcement, this enforcement adopts Flex technology definition one to comprise the ROLAP designer in multiple region, is the ROLAP designer panel schematic diagram of definition see Fig. 2, Fig. 2.Wherein, the ROLAP designer panel of definition comprises multiple region, is respectively data set region, multidimensional table section, design panel zone and tool bar region.Designer can load corresponding tables of data (as fact table and Wei Biao etc.) to the data set region of ROLAP designer and multidimensional table section, checks for designer and subscription client.
S102, obtain the data pattern information of multi-dimensional database in data set region, and the data pattern information of acquisition is represented at design panel zone in the mode of list.
Concrete, above-mentioned steps S101, designer defines the ROLAP designer that comprises multiple region, and is loaded with corresponding tables of data wherein, and this step obtains the data pattern information of multi-dimensional database in data set region.During concrete enforcement, fact table title can be inputted on the data set node in the data set region of ROLAP designer, wherein, the fact is data most interested in decision operation, usually have recorded often dynamically event in enterprise, in relevant database, the table of those recorded frequent dynamic changes can as fact table.See Fig. 4, fact table comprises some field informations.If inquire the fact table that the fact table title of input is corresponding on data set node, then obtain the field information in this fact table, and the field information of acquisition is presented in the mode of list on the design panel of the ROLAP designer of definition, see Fig. 5.If there is not fact table corresponding to the fact table title of input (namely inquiring about the fact table less than correspondence) on data set node, see Fig. 3, prompting obtains failure information, such as point out " this result table does not exist; please revise table name and claim ", prompting designer re-enters fact table title.
S103, according to obtain data pattern information, set up the ROLAP analytical model of multi-dimensional database.
Concrete, step S102 obtains the data pattern information (mainly obtaining the field information of fact table in the present embodiment) of Water demand in the data set region of ROLAP designer, this step is according to the data pattern information obtained, set up the ROLAP analytical model of multi-dimensional database, such as, the logical schema of definition multi-dimensional database, the logical schema of multi-dimensional database mainly comprises analyzes theme, tolerance and compute mode, computation measure, dimension field and date field.Wherein, analyze theme and mainly determine according to the logic business of fact table corresponding to field, such as goods sales volume; Numeric field in fact table has weighed factural information from multiple angle, logical model can be set up on this basis and analyze tolerance used and compute mode, tolerance is generally the ethod of remittance (such as, sum, the avg of these numeric fields of definition, count, max, mix etc.), as sum (sale_account), wherein sale_account is tolerance, and sum is its compute mode; Namely computation measure can be specified by the formula operation device edited in advance, such as increase by computing formula on a year-on-year basis: (when issue-front issue)/front issue, tolerance and compute mode and computation measure can see Fig. 6 and Fig. 7.
Namely the logical schema that the present embodiment sets up multi-dimensional database analyzes which as the row field in data result table and row field and the field determining Water demand, according to the tables of data (also can be described as dimension table) of the field composition Water demand of these Water demand; In addition, set up the logical schema of multi-dimensional database, thus concrete physical store information is masked to analyst, make analyst on model, directly adopt the mode cut into slices, drill through and rotate to obtain required analysis data, and need not need understand inquiry and write complicated querying condition statement as in conventional relationship type database.
The ROLAP analytical model of the multi-dimensional database that S104, basis have been set up organizes the Star Model of multi-dimensional database, and is stored in semantic object storage file by the Star Model of the multi-dimensional database of tissue.
Concrete, this step can organize the Star Model of multi-dimensional database according to the ROLAP analytical model of the multi-dimensional database set up in step S103, can see Fig. 8, main foreign key relationship can be defined to fact table in multi-dimensional database with from the dimension table that the multidimensional table section of the ROLAP designer of definition obtains, such as, fact table dimension field in multi-dimensional database is specified with the main foreign key relationship between dimension table, after defining main foreign key relationship, to be organized the Star Model of multi-dimensional database by left outside connection (left join) mode; Also the dimensional information of multidimensional data table (as result table and dimension table) can be obtained by main foreign key relationship, and specify specific form for date field wherein, also for field wherein carries out Chinese business note, such user does not need the physical name knowing field just can carry out service definition.Wherein, can take on the multidimensional table section node of ROLAP designer, input multidimensional table name to claim to obtain corresponding dimension table.
After having organized the Star Model of multi-dimensional database, the format storage of the information conveniently in Star Model and the easy transmission of data, XML (eXtensible Markup Language, extend markup language) language is a kind of data representation language of flexible dynamic scalable, it provide the semantic label easily for understanding that can customize, XML has strict semantic format can by computer recognizing, and its this data describe mechanism and become a kind of general exchanges data carrier.Therefore the information in the Star Model of the multi-dimensional database of tissue is stored in semantic object storage file with the form of XML by the present embodiment, inquires about for subscription client.Wherein, the logical schema of ROLAP analysis data, multiplicative model and the correspondence relationship information between logical schema and multiplicative model is stored in semantic object storage file.
In addition, for relevant database, data query certainly will cause very large pressure to relevant database frequently, in order to reduce the pressure of database and reduce query responding time, can define buffer memory plan to database.
During concrete enforcement, two-level cache can be set up to relevant database, be respectively first order buffer memory and second level buffer memory.Wherein, from database, inquire about by adopting querying condition at every turn the data obtained and be stored in first order buffer memory, these data store using querying condition as key word, if inquire about with identical querying condition next time, then and the direct data obtaining coupling from first order buffer memory.
The combination of fixed time section all querying condition inquires about down the Data import that obtains in second level buffer memory, second level buffer setting is under different database users ownership, namely second level buffer memory and database user have corresponding relation, only have the data could inquired about by the user of Authority Verification in the buffer memory of the corresponding second level.Certainly, when data query, first by obtaining the data of coupling in querying condition (i.e. key word) to first order buffer memory, if there are the data of coupling in first order buffer memory, directly from first order buffer memory, obtain data; If there are not the data of coupling in first order buffer memory, in the second level buffer memory of associated databases user, obtain data; If all there are not the data of coupling in first order buffer memory and second level buffer memory, then by inquiring about in querying condition to database.
Embodiment two, a kind of ROLAP analytics engine design apparatus based on Star Model.Below in conjunction with Fig. 9, the device that the present embodiment provides is described in detail.
In Fig. 9, the device that the present embodiment provides comprises designer definition module 901, data obtaining module 902, information reminding module 903, analytical model set up module 904, Star Model molded tissue block 905, buffer memory set up module 906.
Wherein, designer definition module 901 is mainly used in the ROLAP designer that definition one comprises multiple region, and ROLAP designer at least comprises a data set region and a design panel zone.
Concrete, designer definition module 901 adopts Flex technology definition one to comprise the ROLAP designer in multiple region, wherein, the design panel of the ROLAP designer of definition comprises multiple region, is respectively data set region, multidimensional table section, design panel zone and tool bar region.Designer can load corresponding tables of data (as fact table and Wei Biao etc.) to the data set region of ROLAP designer and multidimensional table section, checks for designer and subscription client.
Data obtaining module 902 is mainly used in the data pattern information of the data set region acquisition multi-dimensional database of the ROLAP designer designed at designer definition module 901, and the data pattern information of acquisition is represented at design panel zone in the mode of list.
Concrete, designer definition module 901 defines the ROLAP designer that comprises multiple region, and being loaded with corresponding tables of data (such as fact table and Wei Biao) wherein, data obtaining module 902 obtains the data pattern information of multi-dimensional database in the data set region of the ROLAP designer of definition.During concrete enforcement, fact table title can be inputted on the data set node in the data set region of ROLAP designer, the fact is data most interested in decision operation, usually have recorded often dynamically event in enterprise, the table of those recorded frequent dynamic changes in relevant database can as fact table, and fact table comprises some field informations.If inquire the fact table that the fact table title of input is corresponding on data set node, data obtaining module 902 obtains the field information in this fact table, and the field information of this acquisition is presented in the design panel zone of the ROLAP designer of definition in the mode of list.
When information reminding module 903 is mainly used in the fact table title that there is not input on the data set node in data set region, prompting obtains failure information.
Concrete, if there is not fact table corresponding to the fact table title of input (namely inquiring about the fact table less than correspondence) on data set node, then information reminding module 903 is pointed out and is obtained failure information, such as point out " this result table does not exist; please revise table name and claim ", prompting designer re-enters fact table title.
Analytical model sets up the data pattern information that module 904 is mainly used in obtaining according to data obtaining module 902, sets up the ROLAP analytical model of multi-dimensional database.
Concrete, data obtaining module 902 obtains the data pattern information (mainly obtaining the field information of fact table in the present embodiment) of Water demand in the data set region of ROLAP designer, analytical model sets up the data pattern information that module 904 obtains according to data obtaining module 902, set up the ROLAP analytical model of multi-dimensional database, such as, the logical schema of definition multi-dimensional database, the logical schema of multi-dimensional database mainly comprises analyzes theme, tolerance and compute mode, computation measure, dimension field and date field.
The ROLAP analytical model that Star Model molded tissue block 905 is mainly used in setting up according to analytical model the multi-dimensional database that module 904 has been set up organizes the Star Model of multi-dimensional database, and is stored in semantic object storage file by the Star Model of the multi-dimensional database of tissue.
Concrete, Star Model molded tissue block 905 can set up according to analytical model the Star Model that the ROLAP analytical model of multi-dimensional database that module 904 sets up organizes multi-dimensional database, specifically can define main foreign key relationship to fact table in multi-dimensional database with from the dimension table that the multidimensional table section of the ROLAP designer of definition obtains, such as, specify fact table dimension field with the main foreign key relationship between dimension table, after defining main foreign key relationship, organized the Star Model of multi-dimensional database by left outside connection (left join) mode; Also the dimensional information of multidimensional data table (as result table and dimension table) can be obtained by main foreign key relationship, and specify specific form for date field wherein, also for field wherein carries out Chinese business note, such user does not need the physical name knowing field just can carry out service definition.
After Star Model molded tissue block 905 has set up Star Model, the information in the Star Model of the multi-dimensional database of tissue is stored in semantic object storage file with the form of XML, inquires about for subscription client.Wherein, the logical schema of ROLAP analysis data, multiplicative model and the correspondence relationship information between logical schema and multiplicative model is stored in semantic object storage file.
Buffer memory is set up module 906 and is mainly used in setting up first order buffer memory and second level buffer memory to multi-dimensional database; Wherein, first order buffer memory, for storing the data of inquiring about in multi-dimensional database at every turn, and stores using querying condition as key word; Second level buffer memory, itself and database user have corresponding relation, for storing the data of inquiring about in multi-dimensional database under all querying conditions of fixed time section combine.
Concrete, for relevant database, data query certainly will cause very large pressure to relevant database frequently, in order to reduce the pressure of database and reduce query responding time, can define buffer memory plan to database.
During concrete enforcement, buffer memory sets up module 906 can set up two-level cache to relevant database, is respectively first order buffer memory and second level buffer memory.Wherein, from multi-dimensional database, inquire about by adopting querying condition at every turn the data obtained and be stored in first order buffer memory, these data store using querying condition as key word, if inquire about with identical querying condition next time, then and the direct data obtaining coupling from first order buffer memory.
Equally, second level buffer memory is stored in by inquiring about the data obtained under all for fixed time section querying condition combinations in multi-dimensional database, second level buffer setting is under different database users ownership, namely second level buffer memory and database user have corresponding relation, only have the data could inquired about by the user of Authority Verification in the buffer memory of the corresponding second level.Certainly, when data query, first by obtaining the data of coupling in querying condition (i.e. key word) to first order buffer memory, if there are the data of coupling in first order buffer memory, directly from first order buffer memory, obtain data; If there are not the data of coupling in first order buffer memory, in the second level buffer memory of associated databases user, obtain data; If all there are not the data of coupling in first order buffer memory and second level buffer memory, then by inquiring about in querying condition to database.
A kind of ROLAP analytics engine method for designing based on Star Model provided by the invention and device, first Flex technology definition one is utilized to comprise the ROLAP designer in multiple region, then on the data set region of ROLAP designer, obtain the data pattern information of multi-dimensional database, and present in the mode of list; According to the data pattern information obtained, set up the ROLAP analytical model of multi-dimensional database, finally organize the Star Model of multi-dimensional database according to the ROLAP analytical model set up, and be stored in semantic object storage file.By Flex technology definition ROLAP designer, pull operation by Flex technology in the pop-up of designer panel and namely can complete modelling work, solve the problem that other similar system is too complicated, original system constructing is become more easy-to-use, more intuitively, more rapidly " Web page application program ", under the prerequisite not affecting original application, RIA Rich Client Technology has carried out significantly strengthening to presentation layer, improve the friendliness at interface, decrease the remote interaction frequency of user and system, decrease bandwidth demand; ROLAP designer in the present invention is based on B/S framework, and the contrast at present ROLAP designer of a lot of C/S framework does not need to install client, can auto-update.
Utilize Flex platform technology to possess the advantage of RIA rich client, support many services device language (such as, JAVA .NET, PHP etc.) and main flow framework simultaneously, the resource of main flow development platform can be made full use of; Utilize the installation popularization degree of FlashPlayer, easily realize browser-cross cross-platform, utilize Flash to use multimedia resource, dynamic interactivity is strong; The ROLAP analytics engine reusability of the present invention's design is high, is conducive to modular design.
In addition, the present invention is Relational Database Design multi-level buffer, solves the problem that current MOLAP needs extra cube server and regularly refreshes, can improve the speed of subscription client data query.
The foregoing is only preferred embodiment of the present invention, not in order to limit the present invention, 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 (10)
1., based on a ROLAP analytics engine method for designing for Star Model, it is characterized in that, comprising:
The ROLAP designer that step S101, definition one comprise multiple region, described ROLAP designer at least comprises a data set region and a design panel zone;
Step S102, obtain the data pattern information of multi-dimensional database in described data set region, and the data pattern information of described acquisition is represented at described design panel zone in the mode of list;
Step S103, data pattern information according to described acquisition, set up the ROLAP analytical model of multi-dimensional database;
The ROLAP analytical model of the multi-dimensional database that step S104, basis have been set up organizes the Star Model of multi-dimensional database, and is stored in semantic object storage file by the Star Model of the multi-dimensional database of described tissue.
2. as claimed in claim 1 based on the ROLAP analytics engine method for designing of Star Model, it is characterized in that, define a ROLAP designer at least comprising multiple region in described step S101 and specifically comprise:
Flex technology definition one is adopted to comprise the ROLAP designer in multiple region.
3., as claimed in claim 1 based on the ROLAP analytics engine method for designing of Star Model, it is characterized in that, described step S102 comprises:
The data set node in described data set region inputs fact table title, obtains the field information in fact table corresponding to described fact table title, and represent the field information of described acquisition in the mode of list at described design panel zone.
4., as claimed in claim 3 based on the ROLAP analytics engine method for designing of Star Model, it is characterized in that, described step S102 also comprises:
When there is not the fact table title of input on the data set node in described data set region, prompting obtains failure information.
5., as claimed in claim 3 based on the ROLAP analytics engine method for designing of Star Model, it is characterized in that, described step S103 comprises:
According to the field information in the fact table of described acquisition, the logical schema of definition multi-dimensional database, wherein, the logical schema of described multi-dimensional database comprises analyzes theme, tolerance and compute mode, computation measure, dimension field and date field.
6. as claimed in claim 5 based on the ROLAP analytics engine method for designing of Star Model, it is characterized in that, the ROLAP designer of described step S101 definition also comprises multidimensional table section, and described step S104 comprises:
According to the ROLAP analytical model of the multi-dimensional database set up, main foreign key relationship is defined to the fact table of described multi-dimensional database and multidimensional table section obtains from described ROLAP designer dimension table, and organized the Star Model of multi-dimensional database by the mode of left outside connection, and the Star Model of the multi-dimensional database of described tissue is stored in semantic object storage file with the form of XML.
7., as claimed in claim 1 based on the ROLAP analytics engine method for designing of Star Model, it is characterized in that, also comprise:
First order buffer memory and second level buffer memory are set up to multi-dimensional database;
The data of at every turn inquiring about at multi-dimensional database are stored in first order buffer memory using querying condition as key word;
By under the combination of all for fixed time section querying conditions at the Data import of multidimensional data library inquiry in second level buffer memory, described second level buffer memory and database user have corresponding relation.
8., based on a ROLAP analytics engine design apparatus for Star Model, it is characterized in that, comprising:
Designer definition module, for defining the ROLAP designer that comprises multiple region, described ROLAP designer at least comprises a data set region and design panel zone;
Data obtaining module, for obtaining the data pattern information of multi-dimensional database in described data set region, and represents the data pattern information of described acquisition at described design panel zone in the mode of list;
Analytical model sets up module, for the data pattern information according to described acquisition, sets up the ROLAP analytical model of multi-dimensional database;
Star Model molded tissue block, for organizing the Star Model of multi-dimensional database according to the ROLAP analytical model of the multi-dimensional database set up, and is stored in the Star Model of the multi-dimensional database of described tissue in semantic object storage file.
9. as claimed in claim 8 based on the ROLAP analytics engine design apparatus of Star Model, it is characterized in that, the data pattern information that described data obtaining module is used for obtaining in described data set region multi-dimensional database specifically comprises:
The data set node in described data set region inputs fact table title, obtains the field information in fact table corresponding to described fact table title;
Described analytics engine design apparatus also comprises:
Information reminding module, when there is not the fact table title of input on the data set node when described data set region, prompting obtains failure information.
10., as claimed in claim 8 based on the ROLAP analytics engine design apparatus of Star Model, it is characterized in that, also comprise:
Buffer memory sets up module, for setting up first order buffer memory and second level buffer memory to multi-dimensional database;
Described first order buffer memory, for storing the data of inquiring about in multi-dimensional database at every turn, and stores using querying condition as key word;
Described second level buffer memory, itself and database user have corresponding relation, for storing the data of inquiring about in multi-dimensional database under all querying conditions of fixed time section combine.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410602643.3A CN104317936A (en) | 2014-10-31 | 2014-10-31 | ROLAP (relational on-line analysis processing) analysis engine design method and device on basis of star models |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410602643.3A CN104317936A (en) | 2014-10-31 | 2014-10-31 | ROLAP (relational on-line analysis processing) analysis engine design method and device on basis of star models |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104317936A true CN104317936A (en) | 2015-01-28 |
Family
ID=52373168
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410602643.3A Pending CN104317936A (en) | 2014-10-31 | 2014-10-31 | ROLAP (relational on-line analysis processing) analysis engine design method and device on basis of star models |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104317936A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105404637A (en) * | 2015-09-18 | 2016-03-16 | 北京锐安科技有限公司 | Data mining method and device |
| CN105787052A (en) * | 2016-02-26 | 2016-07-20 | 广州品唯软件有限公司 | Data processing model building method and data screening method based on data processing model |
| CN109086354A (en) * | 2018-07-17 | 2018-12-25 | 于果鑫 | A kind of big data analysis processing system based on extended node cluster |
| CN112269792A (en) * | 2020-12-11 | 2021-01-26 | 腾讯科技（深圳）有限公司 | Data query method, device, equipment and computer readable storage medium |
| CN112765168A (en) * | 2021-01-08 | 2021-05-07 | 深圳市酷开网络科技股份有限公司 | Star data management and storage method and device, terminal equipment and storage medium |
| CN113342843A (en) * | 2021-07-06 | 2021-09-03 | 多点生活(成都)科技有限公司 | Big data online analysis method and system |
| CN113868266A (en) * | 2021-12-06 | 2021-12-31 | 广州市玄武无线科技股份有限公司 | Method and device for generating star model layout of web front end and electronic equipment |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1564160A (en) * | 2004-04-22 | 2005-01-12 | 重庆市弘越科技有限公司 | Method of seting up and inquirying multiple-demensional data cube |
| US20060112137A1 (en) * | 2003-03-28 | 2006-05-25 | Microsoft Corporation | Systems and methods for proactive caching utilizing olap variants |
| CN101556602A (en) * | 2009-04-08 | 2009-10-14 | 王珊 | Memory OLAP What-if analytical method based on a difference table |
| CN102004741A (en) * | 2009-09-01 | 2011-04-06 | 上海杉达学院 | Database access system |
-
2014
- 2014-10-31 CN CN201410602643.3A patent/CN104317936A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060112137A1 (en) * | 2003-03-28 | 2006-05-25 | Microsoft Corporation | Systems and methods for proactive caching utilizing olap variants |
| CN1564160A (en) * | 2004-04-22 | 2005-01-12 | 重庆市弘越科技有限公司 | Method of seting up and inquirying multiple-demensional data cube |
| CN101556602A (en) * | 2009-04-08 | 2009-10-14 | 王珊 | Memory OLAP What-if analytical method based on a difference table |
| CN102004741A (en) * | 2009-09-01 | 2011-04-06 | 上海杉达学院 | Database access system |
Non-Patent Citations (2)
| Title |
|---|
| 杭晓骏: "基于关系数据库的ROLAP建模工具的设计与实现", 《计算机工程与设计》 * |
| 田忠和等: "ROLAP中星型模型的索引优化策略", 《计算机应用》 * |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105404637A (en) * | 2015-09-18 | 2016-03-16 | 北京锐安科技有限公司 | Data mining method and device |
| CN105404637B (en) * | 2015-09-18 | 2019-03-01 | 北京锐安科技有限公司 | Data digging method and device |
| CN105787052A (en) * | 2016-02-26 | 2016-07-20 | 广州品唯软件有限公司 | Data processing model building method and data screening method based on data processing model |
| CN109086354A (en) * | 2018-07-17 | 2018-12-25 | 于果鑫 | A kind of big data analysis processing system based on extended node cluster |
| CN112269792A (en) * | 2020-12-11 | 2021-01-26 | 腾讯科技（深圳）有限公司 | Data query method, device, equipment and computer readable storage medium |
| CN112765168A (en) * | 2021-01-08 | 2021-05-07 | 深圳市酷开网络科技股份有限公司 | Star data management and storage method and device, terminal equipment and storage medium |
| CN112765168B (en) * | 2021-01-08 | 2023-08-29 | 深圳市酷开网络科技股份有限公司 | Star-shaped data management storage method and device, terminal equipment and storage medium |
| CN113342843A (en) * | 2021-07-06 | 2021-09-03 | 多点生活(成都)科技有限公司 | Big data online analysis method and system |
| CN113868266A (en) * | 2021-12-06 | 2021-12-31 | 广州市玄武无线科技股份有限公司 | Method and device for generating star model layout of web front end and electronic equipment |
| CN113868266B (en) * | 2021-12-06 | 2022-02-25 | 广州市玄武无线科技股份有限公司 | Method and device for generating star model layout of web front end and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20230376487A1 (en) | Processing database queries using format conversion | |
| US11210316B1 (en) | Join key recovery and functional dependency analysis to generate database queries | |
| US7668860B2 (en) | Apparatus and method for constructing and using a semantic abstraction for querying hierarchical data | |
| CN104317936A (en) | ROLAP (relational on-line analysis processing) analysis engine design method and device on basis of star models | |
| US8086592B2 (en) | Apparatus and method for associating unstructured text with structured data | |
| CN111971666A (en) | Dimension context propagation technology for optimizing SQL query plan | |
| US8316012B2 (en) | Apparatus and method for facilitating continuous querying of multi-dimensional data streams | |
| KR102330547B1 (en) | Building reports | |
| CN105550241A (en) | Multidimensional database query method and apparatus | |
| US20130311454A1 (en) | Data source analytics | |
| US20070260582A1 (en) | Method and System for Visual Query Construction and Representation | |
| US20140279839A1 (en) | Integration of transactional and analytical capabilities of a database management system | |
| US7814045B2 (en) | Semantical partitioning of data | |
| CN106294695A (en) | A kind of implementation method towards the biggest data search engine | |
| US20130086547A1 (en) | Real-time operational reporting and analytics on development entities | |
| US8156144B2 (en) | Metadata search interface | |
| US9177037B2 (en) | In-memory runtime for multidimensional analytical views | |
| US8260772B2 (en) | Apparatus and method for displaying documents relevant to the content of a website | |
| US20110078569A1 (en) | Value help user interface system and method | |
| CN108345646B (en) | Method for rapidly and automatically constructing multi-dimensional report by applying interception technology | |
| US20080313153A1 (en) | Apparatus and method for abstracting data processing logic in a report | |
| US9489438B2 (en) | Systems and methods for visualizing master data services information | |
| US8386497B2 (en) | Query generation based on hierarchical filters | |
| CA2663859C (en) | Apparatus and method for updating a report through view time interaction | |
| Dedic et al. | MLED_BI: a new BI design approach to support multilingualism in business intelligence |
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: 20150128 |