CN102521417B - Method for processing multi-dimensional data based on virtual data cube and system of method - Google Patents
Method for processing multi-dimensional data based on virtual data cube and system of method Download PDFInfo
- Publication number
- CN102521417B CN102521417B CN 201110457463 CN201110457463A CN102521417B CN 102521417 B CN102521417 B CN 102521417B CN 201110457463 CN201110457463 CN 201110457463 CN 201110457463 A CN201110457463 A CN 201110457463A CN 102521417 B CN102521417 B CN 102521417B
- Authority
- CN
- China
- Prior art keywords
- data
- virtual data
- cubical
- dimension
- definition
- 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.)
- Expired - Fee Related
Links
- 238000000034 method Methods 0.000 title claims abstract description 15
- 238000012545 processing Methods 0.000 title claims abstract description 8
- 230000008520 organization Effects 0.000 claims description 11
- 238000012986 modification Methods 0.000 claims description 9
- 230000004048 modification Effects 0.000 claims description 9
- 230000008569 process Effects 0.000 claims description 5
- 238000007418 data mining Methods 0.000 claims description 3
- 230000001747 exhibiting effect Effects 0.000 claims description 3
- 238000004321 preservation Methods 0.000 claims description 3
- 238000010586 diagram Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- FGUUSXIOTUKUDN-IBGZPJMESA-N C1(=CC=CC=C1)N1C2=C(NC([C@H](C1)NC=1OC(=NN=1)C1=CC=CC=C1)=O)C=CC=C2 Chemical compound C1(=CC=CC=C1)N1C2=C(NC([C@H](C1)NC=1OC(=NN=1)C1=CC=CC=C1)=O)C=CC=C2 FGUUSXIOTUKUDN-IBGZPJMESA-N 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method for processing multi-dimensional data based on a virtual data cube. The method includes a definition phase of the virtual data cube and a service phase of the virtual data cube. The definition phase of the virtual data cube includes a, creating a virtual data cube structure; b, loading a database structure and displaying the database structure in a graphical manner; c, defining structure relation of data; and d, storing a data structure. The service phase of the virtual data cube includes steps of I, loading information; II, setting dimensions and measure; III, requesting for inquiring data and returning a result set; and IV, displaying in a row and column combined multi-dimensional mode. Simultaneously, the invention further discloses a multi-dimensional data processing system based on the virtual data cube. By the aid of the method, the multi-dimensional data cube structure is directly represented in a relation type database in a virtual manner, so that the data are displayed visually, freely and timely.
Description
Technical field
The present invention relates to a kind of on relational data the method with the mode deal with data of multidimensional, in particular, relate to a kind of based on the cubical multidimensional data disposal route of virtual data.
Background technology
Along with the development gradually of computer technology, data increase gradually, and people are readability, the intuitive of focused data more and more, and the while is freedom and the promptness of focused data displaying also.
On-line analytical processing is a kind of basic data analysis service that data warehouse can provide, and data cube is the main means that realize on-line analytical processing.How efficiently the large-scale data that comprises in the deal with data cube is a key issue of data warehouse research and application.
In traditional data display, data do not represent in the mode of two dimension often, very not intuitively, not readable; And the displaying of data is to be supported by one section fixing code, and the user often must wait for that the technical professional adds new code support, just can see new content, very not free, untimely.
Summary of the invention
Technical matters to be solved by this invention is, overcome the shortcoming of prior art, provide a kind of directly on relevant database virtual expression multi-dimensional data cube structure make data display directly perceived, free, timely based on the cubical multidimensional data disposal route of virtual data.
Another object of the present invention provides a kind of based on the cubical multidimensional data disposal system of virtual data.
In order to solve above technical matters, the invention provides a kind of based on the cubical multidimensional data disposal route of virtual data, comprise cubical definition phase of virtual data and the cubical operational phase of virtual data, wherein, the cubical definition phase of virtual data comprises following steps:
A, virtual data cube structure of establishment, and the database connection is set;
B, connect the loading of databases structure according to the database that arranges among the step a, show in patterned mode, and keep the logical organization of current database;
C, logic-based structure, are estimated and the relation of dimension between estimating, are estimated the set relations of quoting dimension the dimension of definition data;
D, preservation virtual data cube structure are revised in database or file if desired, and execution in step e if do not need to revise, then finishes the cubical definition of virtual data;
The virtual data cube that e, loading have defined, execution in step c and steps d are finished the cubical modification of virtual data;
The cubical operational phase of virtual data comprises following steps:
The virtual data cube that I, selection need be checked, load information is with the form demonstration of tabulation;
II, at least one dimension of selecting to pay close attention to place on the row or column of interrogation zone, and at least one of selection concern estimated on the same row or column that places interrogation zone;
III, request data query, obtain dimension and estimate information, the list structure corresponding relation that definition obtains respective dimensions and estimates according to the virtual data cube, automatically contrast the cubical structure of virtual data, obtain corresponding data query statement, the corresponding data query statement is submitted to database carries out, obtain the query results that database returns;
IV, the query results that obtains in the step III multidimensional mode with ranks is shown.
The technical scheme that the present invention further limits is: after the reading database structure, the data library structure is made amendment among the step b of cubical definition phase of virtual data, revise content and comprise table name, field name and main external key relation.
Further: behind the step c of cubical definition phase of virtual data, based on the dimension of definition with estimate, definition dimension and the internationalization estimated, the internationalization language of support be English, Spanish and French.
Further: after the step IV of the cubical operational phase of virtual data, to showing that data drill through, launch dimension, repeating step III, IV, the number of plies of described data mining is determined by the number of plies of dimension itself.
Further: obtain supporting in the corresponding data query statement process database language of several data storehouse correspondence in the step III automatically, described database comprises ql server, oracle, mysql, db2, sybaseIQ and sybase ASE.
Another technical scheme disclosed by the invention is: a kind of based on the cubical multidimensional data disposal system of virtual data, described system comprises background data base and foreground display module, also comprise virtual data cube module, described virtual data cube module is arranged between described background data base and the foreground display module, comprise definition unit and use the unit, wherein, described definition unit comprises:
Create assembly, be used for creating a virtual data cube structure, and the database connection is set;
Charging assembly 1 is used for loading the database of connection has been set, and shows in patterned mode in the display module of foreground;
Definitions component is used for based on the logical organization in loaded data storehouse, the dimension of definition data, estimates and the relation of dimension between estimating, estimates the set relations of quoting dimension;
Memory module is used for the virtual data cube structure that storage has defined;
Described use unit comprises:
Charging assembly 2 is used for the virtual data cube that selection need be checked, loads described virtual data cube information, shows with tabular form;
Configuration component, at least one dimension that is used for the selection concern places the row or column of interrogation zone, and at least one of selection concern estimated on the same row or column that places interrogation zone;
Processing components for the treatment of the query requests of foreground display module, contrasts the virtual data cube structure automatically, obtains corresponding data query statement, the corresponding data query statement is submitted to background data base carries out, and obtains the query results that database returns;
Component exhibiting is used for the query results that obtains is treated to and is submitted to the foreground display module in ranks multidimensional mode and shows.
The technical scheme that the present invention further limits is: described definition unit also comprises the modification assembly, is used for the virtual data cube structure that has defined is made amendment, and revises content and comprises table name, field name and main external key relation.
Further: described definition unit also comprises the internationalization assembly, the internationalization that is used for the definition dimension and estimates, and described internationalization assembly support internationalization language is English, Spanish and French.
Further: described use unit also comprises and drills through assembly, is used for the expansion to dimension, describedly drills through the number of plies that assembly drills through by the number of plies decision of dimension itself.
The invention has the beneficial effects as follows: method and system of the present invention is applied on the relevant database, virtual expression multi-dimensional data cube structure, and can realize and true multi-dimensional data cube identical function characteristics; The present invention can form the virtual data cube based on any operating system, arbitrary data storehouse, allows the user to check the data that oneself is paid close attention to data combination freely, and applied range is not subjected to the restriction of hardware; The present invention uses the internationalization assembly, is convenient to popularization and commercial application of system; The present invention shows that data are directly perceived, free, in time, and the definition of virtual data cube structure, modification and use all interface words are easy and simple to handle, easy to use, and deal with data speed is efficient, accurately, improved work efficiency, save human cost; Simultaneously, data mode highly versatile of the present invention is widely used in retail trade, telecommunications industry etc.
Description of drawings
Fig. 1 is the process flow diagram of the cubical definition phase of virtual data of the inventive method;
Fig. 2 is the process flow diagram of the cubical operational phase of virtual data of the inventive method;
Fig. 3 is the structural representation of the virtual data cube module of system of the present invention.
Embodiment
Embodiment 1
It is a kind of based on the cubical multidimensional data disposal system of virtual data that present embodiment provides, and described system comprises background data base, foreground display module and virtual data cube module.
Described virtual data cube module is arranged between described background data base and the foreground display module, and its structural representation comprises definition unit and use the unit that wherein, described definition unit comprises as shown in Figure 3:
Create assembly, be used for creating a virtual data cube structure, and the database connection is set.
Charging assembly 1 is used for loading the database of connection has been set, and shows in patterned mode in the display module of foreground.
Definitions component is used for based on the logical organization in loaded data storehouse, the dimension of definition data, estimates and the relation of dimension between estimating, estimates the set relations of quoting dimension.
Revise assembly, be used for the data cube body structure that has defined is made amendment, revise content and comprise table name, field name and main external key relation.
Memory module is used for the virtual data cube structure that storage has defined.
The internationalization assembly, the internationalization that is used for the definition dimension and estimates, described internationalization assembly support internationalization language be English, Spanish and French.
Described use unit comprises:
Charging assembly 2 is used for the virtual data cube that selection need be checked, loads described virtual data cube information, shows with tabular form.
Configuration component, at least one dimension that is used for the selection concern places the row or column of interrogation zone, and at least one of selection concern estimated on the same row or column that places interrogation zone.
Processing components for the treatment of the query requests of foreground display module, contrasts the virtual data cube structure automatically, obtains corresponding data query statement, the corresponding data query statement is submitted to background data base carries out, and obtains the query results that database returns.
Component exhibiting is used for the query results that obtains is treated to and is submitted to the foreground display module in ranks multidimensional mode and shows.
Drill through assembly, be used for the expansion to dimension, describedly drill through the number of plies that assembly drills through by the number of plies decision of dimension itself.
A kind of using method based on the cubical multidimensional data disposal system of virtual data comprises cubical definition phase of virtual data and the cubical operational phase of virtual data, and wherein, the cubical definition phase of virtual data comprises following steps as shown in Figure 1:
A, virtual data cube structure of establishment, and database is set connects, described virtual data cube structure is a notional definition, concrete content will progressively define in the step of back, and described virtual data cube structure can connect the relevant database of any type, and described database comprises ql server, oracle, mysql, db2, sybase IQ and sybase ASE.
B, connect the loading of databases structure according to the database that arranges in the step (a), comprise relation between list structure, table, main external key relation, show in patterned mode, and keep the logical organization of current database, can allow user's browsing data library structure and carry out the interface operation easily thus.
C, according to the database structure that system reads, the user can oneself carry out modification to a certain degree, comprises table name, field name, the main external key relation etc. revised.After modification was finished, the user can select to preserve the logical organization of current database, and system will independently preserve this structure.This structure is that a logical organization of raw data library structure is expressed, and does not influence original database structure.It is virtual data cube and original database structure decoupling zero that system can save as the real structure of database logical organization, is conducive to maintenance and the independence of data.
D, logic-based structure, the dimension of definition data comprises the corresponding relation of title, dimension and the database table field of dimension, the attribute of dimension, the rank division of dimension; Whether estimating of definition data comprises the title of estimating, the type of estimating, self-defined Computer Corp. of estimating, estimates and can assemble; After dimension was estimated definition and finished, the user can define the relation of dimension between estimating, and estimates the set relations of quoting dimension.The dimension of definition and to estimate all be a pure definition does not have real database table and preserves corresponding dimension and estimate data.Illustrated in the definition that dimension is estimated and the logical table structure between corresponding relation, comprise related table and field.
E, based on the definition dimension and estimate, definition dimension and the internationalization of estimating, the user can estimate based on the dimension of definition, the internationalization that the definition dimension is estimated, comprising can be with dimension name, dimension Property Name, dimension hierarchy title, estimate title is translated as various language, concrete literal needs user oneself input, and the internationalization language of support is English, Spanish and French.
F, preservation virtual data cube structure are revised execution in step (g) if desired in database or file, do not revise if do not need, then finish the cubical definition of virtual data, the user can select to preserve the logical organization of current database, and system will independently preserve this structure.This structure is that a logical organization of raw data library structure is expressed, and does not influence original database structure.The user can preserve the definition of virtual data cube structure, and this structure can be saved in the database, also can be saved in the file, can be opened modification again.
The virtual data cube that g, loading have defined, execution in step c, steps d, step e and step f finish the cubical modification of virtual data.
The cubical operational phase of virtual data comprises following steps:
The virtual data cube that I, selection need be checked, system will load the virtual data cube information that the user selects automatically, comprise the dimension set, will estimate set, and show with the form of tabulation.
II, user select the dimension oneself paid close attention to, are dragged to going or listing of data query district; The user can pull a plurality of dimensions; What the user selected oneself to pay close attention to estimates, and is dragged to going or listing of data query district; The user can pull and a plurality ofly estimate, but all estimating must unify to be expert at or to list.With traditional custom-built query, for example by writing fixing query logic code difference, the user can be according to the needs of oneself, arbitrarily customize by the mode that pulls and oneself want the data query seen.
III, request data query, the dimension that system will select according to the user and estimating, carry out data query, obtain dimension and estimate information, the list structure corresponding relation that definition obtains respective dimensions and estimates according to the virtual data cube contrasts the cubical structure of virtual data automatically, obtains corresponding data query statement, the corresponding data query statement is submitted to database carries out, obtain the query results that database returns; Automatically obtain supporting in the corresponding data query statement process database language of several data storehouse correspondence, described database comprises ql server, oracle, mysql, db2, sybase IQ and sybase ASE.
IV, the query results that obtains in the step III multidimensional mode with ranks is shown.
V, drill through showing data, launch dimension, repeating step III, IV, the number of plies of described data mining is by the number of plies decision of dimension itself.
In addition to the implementation, the present invention can also have other embodiments.All employings are equal to the technical scheme of replacement or equivalent transformation formation, all drop on the protection domain of requirement of the present invention.
Claims (9)
1. one kind based on the cubical multidimensional data disposal route of virtual data, it is characterized in that comprise cubical definition phase of virtual data and the cubical operational phase of virtual data, wherein, the cubical definition phase of virtual data comprises following steps:
A, virtual data cube structure of establishment, and the database connection is set;
B, connect the loading of databases structure according to the database that arranges among the step a, show in patterned mode, and keep the logical organization of current database;
C, logic-based structure, are estimated and the relation of dimension between estimating, are estimated the set relations of quoting dimension the dimension of definition data;
D, preservation virtual data cube structure are revised in database or file if desired, and execution in step e if do not need to revise, then finishes the cubical definition of virtual data;
The virtual data cube that e, loading have defined, execution in step c and steps d are finished the cubical modification of virtual data;
The cubical operational phase of virtual data comprises following steps:
The virtual data cube that I, selection need be checked, load information is with the form demonstration of tabulation;
II, at least one dimension of selecting to pay close attention to place on the row or column of interrogation zone, and at least one of selection concern estimated on the same row or column that places interrogation zone;
III, request data query, obtain dimension and estimate information, the list structure corresponding relation that definition obtains respective dimensions and estimates according to the virtual data cube, automatically contrast the cubical structure of virtual data, obtain corresponding data query statement, the corresponding data query statement is submitted to database carries out, obtain the query results that database returns;
IV, the query results that obtains in the step III multidimensional mode with ranks is shown.
2. according to claim 1 a kind of based on the cubical multidimensional data disposal route of virtual data, it is characterized in that, among the step b of cubical definition phase of virtual data after the reading database structure, the data library structure is made amendment, revise content and comprise table name, field name and main external key relation.
3. according to claim 1 a kind of based on the cubical multidimensional data disposal route of virtual data, it is characterized in that, behind the step c of cubical definition phase of virtual data, based on the definition dimension and estimate, definition dimension and the internationalization of estimating, the internationalization language of support are English, Spanish and French.
4. according to claim 1 a kind of based on the cubical multidimensional data disposal route of virtual data, it is characterized in that, after the step IV of the cubical operational phase of virtual data, to showing that data drill through, launch dimension, repeating step III, IV, the number of plies of described data mining is determined by the number of plies of dimension itself.
5. according to claim 1 a kind of based on the cubical multidimensional data disposal route of virtual data, it is characterized in that, automatically obtain supporting in the corresponding data query statement process database language of several data storehouse correspondence in the step III, described database comprises ql server, oracle, mysql, db2, sybaseIQ and sybase ASE.
6. one kind based on the cubical multidimensional data disposal system of virtual data, described system comprises background data base and foreground display module, it is characterized in that, also comprise virtual data cube module, described virtual data cube module is arranged between described background data base and the foreground display module, comprise definition unit and use the unit, wherein, described definition unit comprises:
Create assembly, be used for creating a virtual data cube structure, and the database connection is set;
Charging assembly 1 is used for loading the database of connection has been set, and shows in patterned mode in the display module of foreground;
Definitions component is used for based on the logical organization in loaded data storehouse, the dimension of definition data, estimates and the relation of dimension between estimating, estimates the set relations of quoting dimension;
Memory module is used for the virtual data cube structure that storage has defined;
Described use unit comprises:
Charging assembly 2 is used for the virtual data cube that selection need be checked, loads described virtual data cube information, shows with tabular form;
Configuration component, at least one dimension that is used for the selection concern places the row or column of interrogation zone, and at least one of selection concern estimated on the same row or column that places interrogation zone;
Processing components for the treatment of the query requests of foreground display module, contrasts the virtual data cube structure automatically, obtains corresponding data query statement, the corresponding data query statement is submitted to background data base carries out, and obtains the query results that database returns;
Component exhibiting is used for the query results that obtains is treated to and is submitted to the foreground display module in ranks multidimensional mode and shows.
7. according to claim 6 a kind of based on the cubical multidimensional data disposal system of virtual data, it is characterized in that, described definition unit also comprises the modification assembly, be used for the virtual data cube structure that has defined is made amendment, revise content and comprise table name, field name and main external key relation.
8. according to claim 6 a kind of based on the cubical multidimensional data disposal system of virtual data, it is characterized in that, described definition unit also comprises the internationalization assembly, the internationalization that is used for the definition dimension and estimates, described internationalization assembly support internationalization language is English, Spanish and French.
9. according to claim 6 a kind of based on the cubical multidimensional data disposal system of virtual data, it is characterized in that, described use unit also comprises and drills through assembly, is used for the expansion to dimension, describedly drills through the number of plies that assembly drills through by the number of plies decision of dimension itself.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110457463 CN102521417B (en) | 2011-12-30 | 2011-12-30 | Method for processing multi-dimensional data based on virtual data cube and system of method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110457463 CN102521417B (en) | 2011-12-30 | 2011-12-30 | Method for processing multi-dimensional data based on virtual data cube and system of method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102521417A CN102521417A (en) | 2012-06-27 |
| CN102521417B true CN102521417B (en) | 2013-09-18 |
Family
ID=46292330
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 201110457463 Expired - Fee Related CN102521417B (en) | 2011-12-30 | 2011-12-30 | Method for processing multi-dimensional data based on virtual data cube and system of method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102521417B (en) |
Families Citing this family (23)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103761307A (en) * | 2014-01-22 | 2014-04-30 | 华为技术有限公司 | Data processing device and data processing method |
| CN104361118B (en) * | 2014-12-01 | 2017-07-21 | 中国人民大学 | A kind of mixing OLAP query processing method for adapting to coprocessor |
| CN104408181A (en) * | 2014-12-15 | 2015-03-11 | 北京国双科技有限公司 | Visual data display method and device based on data cubes |
| CN104462444A (en) * | 2014-12-15 | 2015-03-25 | 北京国双科技有限公司 | Data cube based visual data display method and device |
| CN104462453A (en) * | 2014-12-15 | 2015-03-25 | 北京国双科技有限公司 | Data cube based visual data display method and device |
| CN104462450A (en) * | 2014-12-15 | 2015-03-25 | 北京国双科技有限公司 | Data cube based two-dimensional visual data display method and device |
| CN104462440A (en) * | 2014-12-15 | 2015-03-25 | 北京国双科技有限公司 | Data cube based two-dimensional visual data display method and device |
| CN104408187A (en) * | 2014-12-15 | 2015-03-11 | 北京国双科技有限公司 | Visual data display method and device based on data cubes |
| CN104408196A (en) * | 2014-12-15 | 2015-03-11 | 北京国双科技有限公司 | Two-dimensional visual data display method and device based on data cubes |
| CN104462446A (en) * | 2014-12-15 | 2015-03-25 | 北京国双科技有限公司 | Data cube based two-dimensional visual data display method and device |
| CN104462449A (en) * | 2014-12-15 | 2015-03-25 | 北京国双科技有限公司 | Data cube based two-dimensional visual data display method and device |
| CN104408200A (en) * | 2014-12-15 | 2015-03-11 | 北京国双科技有限公司 | Visual data display method and device based on data cubes |
| CN104391997A (en) * | 2014-12-15 | 2015-03-04 | 北京国双科技有限公司 | Data cube based visual data display method and device |
| CN104408184A (en) * | 2014-12-15 | 2015-03-11 | 北京国双科技有限公司 | Two-dimensional visual data display method and device based on data cubes |
| CN104408186A (en) * | 2014-12-15 | 2015-03-11 | 北京国双科技有限公司 | Two-dimensional visual data display method and device based on data cubes |
| CN104794221B (en) * | 2015-04-29 | 2018-05-01 | 苏州国云数据科技有限公司 | A kind of multi-Dimensional Data Analytical System based on business object |
| CN105426501B (en) * | 2015-11-25 | 2018-12-21 | 广州华多网络科技有限公司 | The automatic route implementation method of multi-dimensional database and system |
| CN106487592B (en) * | 2016-10-21 | 2019-09-27 | 国家计算机网络与信息安全管理中心 | A kind of Faults in Distributed Systems diagnostic method based on data cube |
| CN108021589B (en) * | 2016-10-31 | 2020-08-04 | 腾讯科技（北京）有限公司 | Configuration method and device for query dimension of database |
| CN106844713A (en) * | 2017-02-07 | 2017-06-13 | 北京微影时代科技有限公司 | A kind of method and device of data cube generation |
| CN108052513A (en) * | 2017-09-07 | 2018-05-18 | 中国石油化工股份有限公司 | Oilfield development indexes data cube visual data manager and device |
| CN108416047B (en) * | 2018-03-16 | 2020-04-17 | 北京工商大学 | Multi-dimensional cross analysis method and system for pesticide residue data |
| CN108763282B (en) * | 2018-04-12 | 2023-04-18 | 深圳市拓保软件有限公司 | BI screening improved algorithm based on data cube |
Citations (2)
| 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 |
| US7490106B2 (en) * | 2004-07-09 | 2009-02-10 | Microsoft Corporation | Multidimensional database subcubes |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6549907B1 (en) * | 1999-04-22 | 2003-04-15 | Microsoft Corporation | Multi-dimensional database and data cube compression for aggregate query support on numeric dimensions |
-
2011
- 2011-12-30 CN CN 201110457463 patent/CN102521417B/en not_active Expired - Fee Related
Patent Citations (2)
| 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 |
| US7490106B2 (en) * | 2004-07-09 | 2009-02-10 | Microsoft Corporation | Multidimensional database subcubes |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102521417A (en) | 2012-06-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102521417B (en) | Method for processing multi-dimensional data based on virtual data cube and system of method | |
| US11675781B2 (en) | Dynamic dashboard with guided discovery | |
| US7899837B2 (en) | Apparatus and method for generating queries and reports | |
| Bogorny et al. | ST‐DMQL: a semantic trajectory data mining query language | |
| US8719224B2 (en) | Common modeling of data access and provisioning for search, query, reporting and/or analytics | |
| US11288290B2 (en) | Building reports | |
| US20100161644A1 (en) | Contextual Display of Saved Search Queries | |
| US20110252049A1 (en) | Function execution using sql | |
| US11886395B2 (en) | Processes and systems for onboarding data for a digital duplicate | |
| US11727129B2 (en) | Data security using semantic services | |
| US8204895B2 (en) | Apparatus and method for receiving a report | |
| US8239371B2 (en) | Fast search views over business objects | |
| US20080147602A1 (en) | Method for providing a user interface driven by database tables | |
| Wada et al. | Virtual database technology for distributed database in ubiquitous computing environment | |
| Muntean | Toward Agile BI By Using In-Memory Analytics. | |
| CA2663859C (en) | Apparatus and method for updating a report through view time interaction | |
| Mbanusi | Development of a Web based Shopping Cart using the Mongo DB Database for Human Sustainability | |
| Wada et al. | Virtualization technology for ubiquitous databases | |
| Rad | DirectQuery | |
| Dedic et al. | MLED_BI: a new BI design approach to support multilingualism in business intelligence | |
| EP3977260A1 (en) | Digital duplicate | |
| Rao et al. | A Web based Formulation Language for Information Retrieval System in Easy Way | |
| LEGMAN | INTRODUCTORY NOTIONS OF INFORMATICS APPLIED IN ECONOMICS | |
| WO2016071682A1 (en) | Database interrogation system and method | |
| KR20080007852A (en) | Method for building an ontology by extracting information from legacy databases |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| ASS | Succession or assignment of patent right |
Owner name: NANJING ORARO INFORMATION TECHNOLOGY CO., LTD. Free format text: FORMER OWNER: NANJING BOSUO INFORMATION TECHNOLOGY CO., LTD. Effective date: 20120823 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20120823 Address after: 210012 tulip software building 6F, tulip Road 2, Yuhuatai District, Jiangsu, Nanjing Applicant after: NANJING ORARO INFORMATION TECHNOLOGY Co.,Ltd. Address before: Yuhuatai District of Nanjing city Ning dual 210012 Jiangsu province No. 28 room 1107 Applicant before: NANJING BOJUN INFORMATION TECHNOLOGY Co.,Ltd. |
|
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C56 | Change in the name or address of the patentee | ||
| CP03 | Change of name, title or address |
Address after: 1201-1, room 2, building 106, 210000 software Avenue, Yuhuatai District, Jiangsu, Nanjing Patentee after: NANJING ORANGE RED TECHNOLOGY CO.,LTD. Address before: 210012 tulip software building 6F, tulip Road 2, Yuhuatai District, Jiangsu, Nanjing Patentee before: NANJING ORARO INFORMATION TECHNOLOGY Co.,Ltd. |
|
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: Method for processing multi-dimensional data based on virtual data cube and system of method Effective date of registration: 20181109 Granted publication date: 20130918 Pledgee: Industrial Commercial Bank of China Ltd. Nanjing new town science and technology sub branch Pledgor: NANJING ORANGE RED TECHNOLOGY CO.,LTD. Registration number: 2018320000266 |
|
| PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20130918 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |