CN100573511C - 产生分析数据结构的自定义等级体系的系统和方法 - Google Patents
产生分析数据结构的自定义等级体系的系统和方法 Download PDFInfo
- Publication number
- CN100573511C CN100573511C CNB2004800412222A CN200480041222A CN100573511C CN 100573511 C CN100573511 C CN 100573511C CN B2004800412222 A CNB2004800412222 A CN B2004800412222A CN 200480041222 A CN200480041222 A CN 200480041222A CN 100573511 C CN100573511 C CN 100573511C
- Authority
- CN
- China
- Prior art keywords
- self
- hierarchical system
- dimension
- inquiry
- primary
- 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 description 23
- 238000004458 analytical method Methods 0.000 claims description 22
- 238000012545 processing Methods 0.000 claims description 12
- 238000006243 chemical reaction Methods 0.000 claims description 11
- 230000032683 aging Effects 0.000 description 34
- 239000003245 coal Substances 0.000 description 9
- 238000010586 diagram Methods 0.000 description 5
- 230000008569 process Effects 0.000 description 5
- 230000004044 response Effects 0.000 description 4
- 230000008859 change Effects 0.000 description 2
- 238000009795 derivation Methods 0.000 description 2
- 238000013459 approach Methods 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000000295 complement effect Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000011156 evaluation Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
Images
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
-
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
- G06F17/40—Data acquisition and logging
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99932—Access augmentation or optimizing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99933—Query processing, i.e. searching
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99933—Query processing, i.e. searching
- Y10S707/99935—Query augmenting and refining, e.g. inexact access
Abstract
Description
原生等级体系/维度 | 级别 | 属性 |
公司等级体系 | 所有>市场(家具、杂货、生物技术、煤炭、...)>>公司 | 时效性(timeliness)(1..5) |
财力 | 所有>财力(A+、 |
A++、...)>>公司 | ||
度量 | 度量(ROI) |
原生等级体系/维度 | 级别 | 属性 |
公司等级体系 | 所有>市场(家具、杂货、生物技术、煤炭、...)>>公司 | 时效性(1..5) |
财力 | 所有>财力(A+、A++、...)>>公司 | |
时效性 | 所有>时效性(1..5)>>公司 | |
度量 | 度量(ROI) |
原生等级体系/维度 | 级别 | 属性 |
公司等级体系 | 所有>市场(家具、杂货、生物技术、煤炭、...)>>公司 | 时效性(1..5) |
财力 | 所有>财力(A+、A++、...)>>公司 | |
时效性 | 所有>时效性(1..5)>>公司 | |
度量 | 度量(ROI) |
原生等级体系/维度 | 级别 | 属性 |
公司等级体系 | 所有>市场(家具、杂货、生物技术、煤炭、...)>>公司 | 时效性(1..5) |
财力 | 所有>财力(A+、A++、...)>>公司 | |
时效性 | 所有>时效性(1..5)>>公司 | |
度量 | 度量(ROI) |
市场 | 生物技术 | 煤炭 |
时效性 | ||
1 | 1.28% | 5.33% |
2 | 0.35% | 0.72% |
3 | 0.65% | 0.76% |
4 | 0.24% | 4.20% |
5 | 8.38% |
Claims (18)
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US52624603P | 2003-12-02 | 2003-12-02 | |
US60/526,246 | 2003-12-02 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN101036140A CN101036140A (zh) | 2007-09-12 |
CN100573511C true CN100573511C (zh) | 2009-12-23 |
Family
ID=34676606
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CNB2004800412222A Expired - Fee Related CN100573511C (zh) | 2003-12-02 | 2004-12-02 | 产生分析数据结构的自定义等级体系的系统和方法 |
Country Status (6)
Country | Link |
---|---|
US (1) | US7219093B2 (zh) |
EP (1) | EP1700095B1 (zh) |
JP (1) | JP4602349B2 (zh) |
KR (1) | KR101098181B1 (zh) |
CN (1) | CN100573511C (zh) |
WO (1) | WO2005057164A2 (zh) |
Families Citing this family (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CA2519015A1 (en) * | 2005-09-13 | 2007-03-13 | Cognos Incorporated | System and method of providing relational set operations for olap data sources |
US8005818B2 (en) * | 2008-03-31 | 2011-08-23 | Business Objects, S.A. | Apparatus and method for maintaining metadata version awareness during set evaluation for OLAP hierarchies |
CN102007476A (zh) * | 2008-04-16 | 2011-04-06 | 国际商业机器公司 | 查询处理可视化系统和可视化查询处理的方法 |
KR101117649B1 (ko) * | 2010-10-13 | 2012-03-20 | 세종대학교산학협력단 | Olap 기반의 3차원 공간에서 데이터 분석 객체의 선택 방법 및 시스템 |
US9465523B2 (en) | 2013-06-27 | 2016-10-11 | Sap Se | Visual exploration of multidimensional data |
WO2015196177A1 (en) | 2014-06-20 | 2015-12-23 | Amazon Technologies, Inc. | Embeddable cloud analytics |
US10430438B2 (en) | 2014-06-20 | 2019-10-01 | Amazon Technologies, Inc. | Dynamic n-dimensional cubes for hosted analytics |
US11868372B1 (en) | 2014-06-20 | 2024-01-09 | Amazon Technologies, Inc. | Automated hierarchy detection for cloud-based analytics |
US10769175B1 (en) * | 2014-06-20 | 2020-09-08 | Amazon Technologies, Inc. | Real-time hosted system analytics |
Family Cites Families (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6438537B1 (en) * | 1999-06-22 | 2002-08-20 | Microsoft Corporation | Usage based aggregation optimization |
US6477536B1 (en) | 1999-06-22 | 2002-11-05 | Microsoft Corporation | Virtual cubes |
WO2002003251A2 (en) * | 2000-06-29 | 2002-01-10 | Alphablox Corporation | Caching scheme for multi-dimensional data |
WO2002065327A1 (en) | 2001-02-12 | 2002-08-22 | New York University | System, process and software arrangement for providing multidimensional recommendation/suggestions |
US6643646B2 (en) * | 2001-03-01 | 2003-11-04 | Hitachi, Ltd. | Analysis of massive data accumulations using patient rule induction method and on-line analytical processing |
US7171427B2 (en) * | 2002-04-26 | 2007-01-30 | Oracle International Corporation | Methods of navigating a cube that is implemented as a relational object |
US20040181519A1 (en) * | 2002-07-09 | 2004-09-16 | Mohammed Shahbaz Anwar | Method for generating multidimensional summary reports from multidimensional summary reports from multidimensional data |
-
2004
- 2004-12-02 KR KR1020067013355A patent/KR101098181B1/ko active IP Right Grant
- 2004-12-02 EP EP04812681.7A patent/EP1700095B1/en active Active
- 2004-12-02 WO PCT/US2004/040229 patent/WO2005057164A2/en active Application Filing
- 2004-12-02 US US11/002,910 patent/US7219093B2/en not_active Expired - Fee Related
- 2004-12-02 CN CNB2004800412222A patent/CN100573511C/zh not_active Expired - Fee Related
- 2004-12-02 JP JP2006542713A patent/JP4602349B2/ja active Active
Also Published As
Publication number | Publication date |
---|---|
WO2005057164A2 (en) | 2005-06-23 |
JP4602349B2 (ja) | 2010-12-22 |
EP1700095B1 (en) | 2018-02-21 |
WO2005057164A3 (en) | 2006-10-19 |
JP2007513428A (ja) | 2007-05-24 |
EP1700095A2 (en) | 2006-09-13 |
US7219093B2 (en) | 2007-05-15 |
US20050120018A1 (en) | 2005-06-02 |
CN101036140A (zh) | 2007-09-12 |
KR101098181B1 (ko) | 2011-12-27 |
EP1700095A4 (en) | 2010-01-20 |
KR20070018811A (ko) | 2007-02-14 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20220035815A1 (en) | Processing database queries using format conversion | |
Hui et al. | Data mining for customer service support | |
CN104123374B (zh) | 分布式数据库中聚合查询的方法及装置 | |
US6839714B2 (en) | System and method for comparing heterogeneous data sources | |
US8219564B1 (en) | Two-dimensional indexes for quick multiple attribute search in a catalog system | |
CN102362276B (zh) | 测试数据库查询引擎的效率和稳定性 | |
US7743058B2 (en) | Co-clustering objects of heterogeneous types | |
US6834287B1 (en) | Classification engine for managing attribute-based data | |
CN103927346B (zh) | 基于数据量的查询连接方法 | |
CN104182405A (zh) | 一种连接查询方法及装置 | |
CN105518658A (zh) | 用于将数据记录分组的设备、系统以及方法 | |
Hamouda et al. | Document-oriented data schema for relational database migration to NoSQL | |
CN107016001A (zh) | 一种数据查询方法及装置 | |
CN103793422A (zh) | 基于增强星型模型的立方体元数据及查询语句生成 | |
US20110022581A1 (en) | Derived statistics for query optimization | |
CN102270225A (zh) | 数据变更日志监控方法和数据变更日志监控装置 | |
CN107491476B (zh) | 一种适用于多种大数据管理系统的数据模型转换及查询分析方法 | |
CN104268247A (zh) | 一种基于模糊层次分析的主数据归集方法 | |
WO2001003032A9 (en) | Apparatus, systems and methods for constructing large numbers of travel fares | |
CN100573511C (zh) | 产生分析数据结构的自定义等级体系的系统和方法 | |
CN102867065B (zh) | 基于关系型数据库的数据汇总装置和方法 | |
JPH1097544A (ja) | データベース処理システム | |
CN106156040A (zh) | 多维度数据管理方法及装置 | |
US9031930B2 (en) | Data browser for group-by data access | |
Fong et al. | Data mining for decision support |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C14 | Grant of patent or utility model | ||
GR01 | Patent grant | ||
ASS | Succession or assignment of patent right |
Owner name: MICROSOFT CORP. Free format text: FORMER OWNER: PUUKKO CO., LTD. Effective date: 20100317 |
|
C41 | Transfer of patent application or patent right or utility model | ||
COR | Change of bibliographic data |
Free format text: CORRECT: ADDRESS; FROM: IDAHO,U.S.A. TO: WASHINGTON, U.S.A. |
|
TR01 | Transfer of patent right |
Effective date of registration: 20100317 Address after: Washington, USA Patentee after: Microsoft Corp. Address before: Idaho Patentee before: Proclarity Corp. |
|
ASS | Succession or assignment of patent right |
Owner name: MICROSOFT TECHNOLOGY LICENSING LLC Free format text: FORMER OWNER: MICROSOFT CORP. Effective date: 20150428 |
|
C41 | Transfer of patent application or patent right or utility model | ||
TR01 | Transfer of patent right |
Effective date of registration: 20150428 Address after: Washington State Patentee after: MICROSOFT TECHNOLOGY LICENSING, LLC Address before: Washington, USA Patentee before: Microsoft Corp. |
|
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20091223 |
|
CF01 | Termination of patent right due to non-payment of annual fee |