CN104408169B - Dimension querying method and device based on Multidimensional Expressions language - Google Patents
Dimension querying method and device based on Multidimensional Expressions language Download PDFInfo
- Publication number
- CN104408169B CN104408169B CN201410750941.7A CN201410750941A CN104408169B CN 104408169 B CN104408169 B CN 104408169B CN 201410750941 A CN201410750941 A CN 201410750941A CN 104408169 B CN104408169 B CN 104408169B
- Authority
- CN
- China
- Prior art keywords
- index
- dimension table
- value
- dimension
- value set
- 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.)
- Active
Links
- 230000014509 gene expression Effects 0.000 title claims abstract description 97
- 238000000034 method Methods 0.000 title claims abstract description 25
- 238000001914 filtration Methods 0.000 claims abstract description 49
- 238000012545 processing Methods 0.000 claims abstract description 26
- 238000013507 mapping Methods 0.000 claims description 51
- 238000010586 diagram Methods 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 235000013399 edible fruits Nutrition 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000004148 unit process Methods 0.000 description 1
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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
- G06F16/2264—Multidimensional index structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
- G06F16/2445—Data retrieval commands; View definitions
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Computer And Data Communications (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (8)
- A kind of 1. dimension querying method based on Multidimensional Expressions language, it is characterised in that including:The index for determining to meet the querying condition in querying condition and analytical database and dimension table to be checked;The first dimension table in the dimension table to be checked is obtained, wherein, first dimension table is the dimension to be checked Spend the dimension table that member value quantity in table is more than predetermined threshold value;The first index is determined in the index for meeting the querying condition, wherein, first index is and first dimension The index of mapping relations be present in table;Filtration treatment is carried out to the member value in first dimension table according to first index, obtains member's value set;The instruction of Multidimensional Expressions language inquiry is received, wherein, the Multidimensional Expressions language inquiry instruction is to be based on the member The query statement that value set obtains;AndQuery processing is performed to member's value set according to the instruction of Multidimensional Expressions language inquiry;Filtration treatment is carried out to the member value in first dimension table according to first index, obtains member's value set bag Include:Determine the member value in first dimension table;Judge whether the member value in first dimension table refers to described first Mark whether there is mapping relations;If mapping relations are not present with first index in the member value in first dimension table, Delete the member value;And if the member value in first dimension table has mapping relations with first index, protect Stay the member value.
- 2. according to the method for claim 1, it is characterised in that determine that first refers in the index for meeting the querying condition Mark includes:It is determined that meet the index of the querying condition in true table, wherein, the true table is used to store the analytical database In all index;Obtain the mapping relations between the index of the querying condition and first dimension table;AndThe first index according to corresponding to the mapping relations obtain first dimension table.
- 3. according to the method for claim 1, it is characterised in that receiving the instruction of Multidimensional Expressions language inquiry includes:Determine member's value set;Receive filtering instructions, wherein, the filtering instructions be for being filtered to member's value set, obtain non-NULL into The instruction of member's value set;Member's value set is filtered according to the filtering instructions, obtains member's value set of non-NULL;According to member's value set of the non-NULL, it is determined that Multidimensional Expressions language corresponding with member's value set of the non-NULL is looked into Ask instruction;AndObtain the Multidimensional Expressions language inquiry instruction.
- 4. according to the method for claim 1, it is characterised in that obtain the first dimension table in the dimension table to be checked Including:Determine the member value quantity of each dimension table in the dimension table to be checked;Obtain the dimension table that member value quantity in the dimension table to be checked is more than predetermined threshold value;It is determined that the index in true table, wherein, the true table is used to store index all in the analytical database;AndMember value quantity in the dimension table to be checked is more than the dimension table of predetermined threshold value and the index in the true table Mapping relations are established, obtain the first dimension table.
- A kind of 5. dimension inquiry unit based on Multidimensional Expressions language, it is characterised in that including:First determining unit, for the index that determines to meet the querying condition in querying condition and analytical database and to be checked Dimension table;Acquiring unit, for obtaining the first dimension table in the dimension table to be checked, wherein, first dimension table is institute State the dimension table that member value quantity in dimension table to be checked is more than predetermined threshold value;Second determining unit, for determining the first index in the index for meeting the querying condition, wherein, first index The index of mapping relations with first dimension table to be present;Filter element, for carrying out filtration treatment to the member value in first dimension table according to first index, obtain Member's value set;Receiving unit, for receiving the instruction of Multidimensional Expressions language inquiry, wherein, the Multidimensional Expressions language inquiry instruction is The query statement obtained based on member's value set;AndProcessing unit, for performing query processing to member's value set according to the instruction of Multidimensional Expressions language inquiry;The filter element includes:6th determining module, for determining the member value in first dimension table;Judge module, For judging whether the member value in first dimension table with first index whether there is mapping relations;Removing module, In the case of mapping relations are not present for the member value in first dimension table and first index, delete it is described into Member's value;And reservation module, mapping relations be present for the member value in first dimension table and first index In the case of, retain the member value.
- 6. device according to claim 5, it is characterised in that second determining unit includes:First determining module, for the index for determining to meet the querying condition in true table, wherein, the true table is used to deposit Store up index all in the analytical database;First acquisition module, for obtaining the mapping relations between the index of the querying condition and first dimension table;With AndSecond acquisition module, for the first index corresponding to obtaining first dimension table according to the mapping relations.
- 7. device according to claim 5, it is characterised in that the receiving unit includes:Second determining module, for determining member's value set;Receiving module, for receiving filtering instructions, wherein, the filtering instructions are for being carried out to member's value set Filter, obtains the instruction of member's value set of non-NULL;Filtering module, for being filtered according to the filtering instructions to member's value set, obtain the member value collection of non-NULL Close;3rd determining module, for member's value set according to the non-NULL, it is determined that corresponding with member's value set of the non-NULL Multidimensional Expressions language inquiry instruction;And3rd acquisition module, for obtaining the Multidimensional Expressions language inquiry instruction.
- 8. device according to claim 5, it is characterised in that the acquiring unit includes:4th determining module, for determining the member value quantity of each dimension table in the dimension table to be checked;4th acquisition module, the dimension table of predetermined threshold value is more than for obtaining member value quantity in the dimension table to be checked;5th determining module, for determining the index in true table, wherein, the true table is used to store the analytical database In all index;And5th acquisition module, for member value quantity in the dimension table to be checked to be more than to dimension table and the institute of predetermined threshold value The Index Establishment mapping relations in true table are stated, obtain the first dimension table.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410750941.7A CN104408169B (en) | 2014-12-09 | 2014-12-09 | Dimension querying method and device based on Multidimensional Expressions language |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410750941.7A CN104408169B (en) | 2014-12-09 | 2014-12-09 | Dimension querying method and device based on Multidimensional Expressions language |
Publications (2)
Publication Number | Publication Date |
---|---|
CN104408169A CN104408169A (en) | 2015-03-11 |
CN104408169B true CN104408169B (en) | 2018-02-02 |
Family
ID=52645800
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410750941.7A Active CN104408169B (en) | 2014-12-09 | 2014-12-09 | Dimension querying method and device based on Multidimensional Expressions language |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104408169B (en) |
Families Citing this family (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106933904B (en) * | 2015-12-31 | 2019-12-03 | 北京国双科技有限公司 | The filter method and device of data |
CN106933926B (en) * | 2015-12-31 | 2019-11-12 | 北京国双科技有限公司 | The filter method and device of tables of data |
CN106933909B (en) * | 2015-12-31 | 2020-06-12 | 北京国双科技有限公司 | Multi-dimensional data query method and device |
CN106776834A (en) * | 2016-11-28 | 2017-05-31 | 中通服公众信息产业股份有限公司 | A kind of data analysis based on index is from access method and system |
CN108153776A (en) * | 2016-12-05 | 2018-06-12 | 北京国双科技有限公司 | Data query method and device |
CN108241692B (en) * | 2016-12-26 | 2020-08-11 | 北京国双科技有限公司 | Data query method and device |
CN108255829B (en) * | 2016-12-28 | 2021-10-19 | 腾讯科技(北京)有限公司 | Data searching method and device |
CN108268537B (en) * | 2016-12-30 | 2020-11-06 | 北京国双科技有限公司 | Data filtering method and device |
CN110019544B (en) * | 2017-09-30 | 2022-08-19 | 北京国双科技有限公司 | Data query method and system |
CN109783495B (en) * | 2019-01-11 | 2021-02-23 | 华青融天(北京)软件股份有限公司 | Multi-dimensional data processing method and device and computer equipment |
CN117992516A (en) * | 2024-01-31 | 2024-05-07 | 北京偶数科技有限公司 | Real-time index data query method and device and readable storage medium |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7490106B2 (en) * | 2004-07-09 | 2009-02-10 | Microsoft Corporation | Multidimensional database subcubes |
CN102682118A (en) * | 2012-05-15 | 2012-09-19 | 北京久其软件股份有限公司 | Multidimensional data model access method and device |
CN103942341A (en) * | 2014-05-09 | 2014-07-23 | 北京国双科技有限公司 | Data processing method and device used for multi-dimensional data set |
CN104182544A (en) * | 2014-09-05 | 2014-12-03 | 北京国双科技有限公司 | Dimensionality analyzing method and device for analytic database |
-
2014
- 2014-12-09 CN CN201410750941.7A patent/CN104408169B/en active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7490106B2 (en) * | 2004-07-09 | 2009-02-10 | Microsoft Corporation | Multidimensional database subcubes |
CN102682118A (en) * | 2012-05-15 | 2012-09-19 | 北京久其软件股份有限公司 | Multidimensional data model access method and device |
CN103942341A (en) * | 2014-05-09 | 2014-07-23 | 北京国双科技有限公司 | Data processing method and device used for multi-dimensional data set |
CN104182544A (en) * | 2014-09-05 | 2014-12-03 | 北京国双科技有限公司 | Dimensionality analyzing method and device for analytic database |
Also Published As
Publication number | Publication date |
---|---|
CN104408169A (en) | 2015-03-11 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN104408169B (en) | Dimension querying method and device based on Multidimensional Expressions language | |
CN103678408B (en) | A kind of method and device of inquiry data | |
CN105653611B (en) | Divide table Page sorting querying method and device | |
CN103559300B (en) | The querying method and inquiry unit of data | |
CN105989373B (en) | The acquisition device-fingerprint method and device realized using training pattern | |
CN106708841B (en) | The polymerization and device of website visitation path | |
CN104462420B (en) | The execution method and apparatus of the query task of database | |
CN102915344B (en) | SQL (structured query language) statement processing method and device | |
CN103383665B (en) | Be suitable in url data crawl the method for data buffer storage and device | |
US20120166412A1 (en) | Super-clustering for efficient information extraction | |
CN106354622B (en) | Test the methods of exhibiting and device of webpage | |
CN104303176A (en) | Query processing | |
CN109885651A (en) | A kind of question pushing method and device | |
CN106649385B (en) | Data reordering method and device based on HBase database | |
CN105426407A (en) | Web data acquisition method based on content analysis | |
CN104268293B (en) | The index treating method and apparatus that can not add up in database | |
CN104182546B (en) | The data query method and device of database | |
CN103995831B (en) | Object processing method, system and device based on similarity among objects | |
CN106933926B (en) | The filter method and device of tables of data | |
CN104778202B (en) | The analysis method and system of event evolutionary process based on keyword | |
CN107085603A (en) | A kind of data processing method and device | |
CN103793509B (en) | Group figure grasping means and device | |
CN104885075B (en) | A kind of method and device executing reverse search using crucial link | |
CN106933934A (en) | The connection method of tables of data and device | |
CN106156197A (en) | The querying method of a kind of data base and device |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: Multi-dimensional expression language based dimension query method and device Effective date of registration: 20190531 Granted publication date: 20180202 Pledgee: Shenzhen Black Horse World Investment Consulting Co.,Ltd. Pledgor: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. Registration number: 2019990000503 |
|
PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
CP02 | Change in the address of a patent holder |
Address after: 100083 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing Patentee after: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. Address before: 100086 Beijing city Haidian District Shuangyushu Area No. 76 Zhichun Road cuigongfandian 8 layer A Patentee before: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. |
|
CP02 | Change in the address of a patent holder | ||
PP01 | Preservation of patent right |
Effective date of registration: 20240604 Granted publication date: 20180202 |
|
PP01 | Preservation of patent right |