CN104217032B - 数据库维度的处理方法及装置 - Google Patents
数据库维度的处理方法及装置 Download PDFInfo
- Publication number
- CN104217032B CN104217032B CN201410510719.XA CN201410510719A CN104217032B CN 104217032 B CN104217032 B CN 104217032B CN 201410510719 A CN201410510719 A CN 201410510719A CN 104217032 B CN104217032 B CN 104217032B
- Authority
- CN
- China
- Prior art keywords
- data
- dimension
- dimension table
- true
- warehouse
- 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
- 238000012545 processing Methods 0.000 title claims abstract description 38
- 238000003672 processing method Methods 0.000 title claims abstract description 18
- 238000000034 method Methods 0.000 claims abstract description 14
- 238000013507 mapping Methods 0.000 claims description 18
- 241001269238 Data Species 0.000 claims description 11
- 238000001514 detection method Methods 0.000 claims description 2
- 230000000694 effects Effects 0.000 abstract description 8
- 238000013500 data storage Methods 0.000 description 15
- 238000010586 diagram Methods 0.000 description 6
- 238000004458 analytical method Methods 0.000 description 3
- 230000015572 biosynthetic process Effects 0.000 description 2
- 230000001186 cumulative effect Effects 0.000 description 2
- 238000012517 data analytics Methods 0.000 description 2
- 238000005259 measurement Methods 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 238000012935 Averaging Methods 0.000 description 1
- 235000013361 beverage Nutrition 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000008521 reorganization Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000026676 system process Effects 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/2282—Tablespace storage structures; Management thereof
-
- 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)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410510719.XA CN104217032B (zh) | 2014-09-28 | 2014-09-28 | 数据库维度的处理方法及装置 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410510719.XA CN104217032B (zh) | 2014-09-28 | 2014-09-28 | 数据库维度的处理方法及装置 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN104217032A CN104217032A (zh) | 2014-12-17 |
CN104217032B true CN104217032B (zh) | 2017-10-03 |
Family
ID=52098521
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410510719.XA Active CN104217032B (zh) | 2014-09-28 | 2014-09-28 | 数据库维度的处理方法及装置 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104217032B (zh) |
Families Citing this family (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106897303B (zh) * | 2015-12-18 | 2020-09-15 | 北京国双科技有限公司 | 数据查询方法及装置 |
CN109062992A (zh) * | 2018-07-03 | 2018-12-21 | 深圳市前海数据服务有限公司 | 一种经济数据分析方法及系统 |
CN115455149B (zh) * | 2022-09-20 | 2023-05-30 | 城云科技(中国)有限公司 | 基于编码查询方式的数据库构建方法及其应用 |
CN116431736B (zh) * | 2023-02-06 | 2023-10-20 | 北京三维天地科技股份有限公司 | 一种在线数据仓库模型的构建方法及系统 |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CA2425033A1 (en) * | 2003-04-08 | 2004-10-08 | Ibm Canada Limited - Ibm Canada Limitee | Multi-level locking hierarchy in a database with multi-dimensional clustering |
CN1774711A (zh) * | 2003-04-18 | 2006-05-17 | 国际商业机器公司 | 管理递归可缩放模板实例中的删除操作的数据表中的系统和方法 |
Family Cites Families (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7185279B2 (en) * | 2000-01-07 | 2007-02-27 | Master Mine Software, Inc. | Data mining and reporting |
US20050278281A1 (en) * | 2004-05-28 | 2005-12-15 | Samson Frederick E | Multi-dimensional data editor |
-
2014
- 2014-09-28 CN CN201410510719.XA patent/CN104217032B/zh active Active
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CA2425033A1 (en) * | 2003-04-08 | 2004-10-08 | Ibm Canada Limited - Ibm Canada Limitee | Multi-level locking hierarchy in a database with multi-dimensional clustering |
CN1774711A (zh) * | 2003-04-18 | 2006-05-17 | 国际商业机器公司 | 管理递归可缩放模板实例中的删除操作的数据表中的系统和方法 |
Also Published As
Publication number | Publication date |
---|---|
CN104217032A (zh) | 2014-12-17 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US8868535B1 (en) | Search engine optimizer | |
EP2924594B1 (en) | Data encoding and corresponding data structure in a column-store database | |
Hong et al. | Large-scale order batching in parallel-aisle picking systems | |
CN102855309B (zh) | 一种基于用户行为关联分析的信息推荐方法及装置 | |
US11200223B2 (en) | System and method for dependency analysis in a multidimensional database environment | |
CN104217032B (zh) | 数据库维度的处理方法及装置 | |
US8805767B1 (en) | Machine learning memory management and distributed rule evaluation | |
EP3217296A1 (en) | Data query method and apparatus | |
Catak et al. | Fuzzy analytic hierarchy based DBMS selection in Turkish national identity card management project | |
CN104182544B (zh) | 分析数据库的维度剖析方法及装置 | |
Lin et al. | Integer nonlinear programming and optimized weighted-average approach for mobile hotel recommendation by considering travelers’ unknown preferences | |
CN104182546B (zh) | 数据库的数据查询方法及装置 | |
Kvet et al. | Concept of temporal data retrieval: Undefined value management | |
US9875278B2 (en) | Modified data query function instantiations | |
US20210004360A1 (en) | Indexing structured data with security information | |
CN104462480B (zh) | 基于典型性的评论大数据挖掘方法 | |
Singh et al. | Nonreplicated Static Data Allocation in Distributed Databases Using Biogeography‐Based Optimization | |
Alwahaishi et al. | Analysis of the dblp publication classification using concept lattices | |
Barquero et al. | Trading Accuracy for Performance in Data Processing Applications. | |
Wenwen | [Retracted] Building an Urban Smart Community System Based on Association Rule Algorithms | |
KR20180119104A (ko) | 무정형 빅데이터의 개인정보 비식별화 처리 방법 | |
WO2021024966A1 (ja) | 企業類似度算出サーバ及び企業類似度算出方法 | |
Martinez-Llario et al. | Improving dissolve spatial operations in a simple feature model | |
Kakkar et al. | Interactive analysis of big geospatial data with high‐performance computing: A case study of partisan segregation in the United States | |
Drakopoulos et al. | Comparing algorithmic principles for fuzzy graph communities over Neo4j |
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 | ||
PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: Method and device for processing database dimensions Effective date of registration: 20190531 Granted publication date: 20171003 Pledgee: Shenzhen Black Horse World Investment Consulting Co.,Ltd. Pledgor: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. Registration number: 2019990000503 |
|
CP02 | Change in the address of a patent holder | ||
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. |
|
PP01 | Preservation of patent right |
Effective date of registration: 20240604 Granted publication date: 20171003 |