CN101036140A - 产生分析数据结构的自定义等级体系的系统和方法 - Google Patents
产生分析数据结构的自定义等级体系的系统和方法 Download PDFInfo
- Publication number
- CN101036140A CN101036140A CNA2004800412222A CN200480041222A CN101036140A CN 101036140 A CN101036140 A CN 101036140A CN A2004800412222 A CNA2004800412222 A CN A2004800412222A CN 200480041222 A CN200480041222 A CN 200480041222A CN 101036140 A CN101036140 A CN 101036140A
- Authority
- CN
- China
- Prior art keywords
- self
- dimension
- hierarchical system
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims description 25
- 238000006243 chemical reaction Methods 0.000 claims description 11
- 238000004458 analytical method Methods 0.000 claims description 6
- 230000032683 aging Effects 0.000 description 37
- 239000003245 coal Substances 0.000 description 12
- 238000010586 diagram Methods 0.000 description 5
- 230000008569 process Effects 0.000 description 5
- 238000012545 processing Methods 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Computer Hardware Design (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
原生等级体系/维度 | 级别 | 属性 |
公司等级体系 | 所有>市场(家具、杂货、生物技术、煤炭、...)>>公司 | 时效性(timeliness)(1..5) |
财力 | 所有>财力(A+、 |
A++、...)>>公司 | ||
度量 | 度量(ROI) |
原生等级体系/维度 | 级别 | 属性 |
公司等级体系 | 所有>市场(家具、杂货、生物技术、煤炭、...)>>公司 | 时效性(1..5) |
财力 | 所有>财力(A+、A++、...)>>公司 | |
时效性 | 所有>时效性(1..5)>>公司 | |
度量 | 度量(ROI) |
市场 | 时效性 | |
家具 | 1 | |
2 | ||
3 | 4.61% | |
4 | 2.15% | |
5 | 7.05% | |
杂货 | 1 | -4.36% |
2 | -2.18% | |
3 | -2.32% | |
4 | -1.10% | |
5 |
原生等级体系/维度 | 级别 | 属性 |
公司等级体系 | 所有>市场(家具、杂货、生物技术、煤炭、...)>>公司 | 时效性(1..5) |
财力 | 所有>财力(A+、A++、...)>>公司 | |
时效性 | 所有>时效性(1..5)>>公司 | |
度量 | 度量(ROI) |
市场 | 生物技术 | 煤炭 | |
财力 | 时效性 | ||
A++ | 1 | 2.58% | 5.79% |
2 | 0.35% | 2.18% | |
3 | 0.68% | -2.21% | |
4 | -1.17% | 2.82% | |
5 | 7.04% | ||
A+ | 1 | -0.69% | 4.25% |
2 | -1.26% | ||
3 | 0.63% | 2.89% | |
4 | 1.35% | 5.84% | |
5 | 10.77% |
原生等级体系/维度 | 级别 | 属性 |
公司等级体系 | 所有>市场(家具、杂货、生物技术、煤炭、...)>>公司 | 时效性(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% |
市场 | 生物技术 | 煤炭 |
时效性 | ||
1 | 1.28% | 5.33% |
2 | 0.35% | 0.72% |
3 | 0.65% | 0.76% |
4 | 0.24% | 4.20% |
5 | 8.38% |
生物技术 | 煤炭 | ||||||||
1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 4 | 5 |
1.28% | 0.35% | 0.65% | 0.24% | 8.38% | 5.33% | 0.72% | 0.76% | 4.20% |
Claims (23)
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 true CN101036140A (zh) | 2007-09-12 |
CN100573511C 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 |
WO2009127639A1 (en) * | 2008-04-16 | 2009-10-22 | International Business Machines Corporation | Query processing visualization system and method of visualizing query processing |
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 |
US10430438B2 (en) | 2014-06-20 | 2019-10-01 | Amazon Technologies, Inc. | Dynamic n-dimensional cubes for hosted analytics |
JP6410932B2 (ja) | 2014-06-20 | 2018-10-24 | アマゾン テクノロジーズ インコーポレイテッド | 組み込み可能なクラウド分析 |
US11868372B1 (en) | 2014-06-20 | 2024-01-09 | Amazon Technologies, Inc. | Automated hierarchy detection for cloud-based analytics |
US9882949B1 (en) | 2014-06-20 | 2018-01-30 | Amazon Technologies, Inc. | Dynamic detection of data correlations based on realtime data |
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 |
US8185487B2 (en) * | 2001-02-12 | 2012-05-22 | Facebook, Inc. | System, process and software arrangement for providing multidimensional recommendations/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 US US11/002,910 patent/US7219093B2/en not_active Expired - Fee Related
- 2004-12-02 JP JP2006542713A patent/JP4602349B2/ja active Active
- 2004-12-02 CN CNB2004800412222A patent/CN100573511C/zh not_active Expired - Fee Related
- 2004-12-02 EP EP04812681.7A patent/EP1700095B1/en active Active
- 2004-12-02 WO PCT/US2004/040229 patent/WO2005057164A2/en active Application Filing
Also Published As
Publication number | Publication date |
---|---|
KR20070018811A (ko) | 2007-02-14 |
CN100573511C (zh) | 2009-12-23 |
WO2005057164A2 (en) | 2005-06-23 |
US7219093B2 (en) | 2007-05-15 |
JP4602349B2 (ja) | 2010-12-22 |
JP2007513428A (ja) | 2007-05-24 |
EP1700095A2 (en) | 2006-09-13 |
KR101098181B1 (ko) | 2011-12-27 |
WO2005057164A3 (en) | 2006-10-19 |
EP1700095B1 (en) | 2018-02-21 |
EP1700095A4 (en) | 2010-01-20 |
US20050120018A1 (en) | 2005-06-02 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20230376487A1 (en) | Processing database queries using format conversion | |
US7908242B1 (en) | Systems and methods for optimizing database queries | |
JP3952518B2 (ja) | 多次元データ処理方法 | |
US8712972B2 (en) | Query optimization with awareness of limited resource usage | |
CN110618983A (zh) | 基于json文档结构的工业大数据多维分析与可视化方法 | |
US20040024790A1 (en) | Data base and knowledge operating system | |
CN102362276A (zh) | 测试数据库查询引擎的效率和稳定性 | |
US20110022581A1 (en) | Derived statistics for query optimization | |
US20100235344A1 (en) | Mechanism for utilizing partitioning pruning techniques for xml indexes | |
US20100138456A1 (en) | System, method, and computer-readable medium for a locality-sensitive non-unique secondary index | |
CN105488231A (zh) | 一种基于自适应表维度划分的大数据处理方法 | |
CN101075249A (zh) | 一种地理信息系统的数据仓库系统及其构建方法 | |
WO2001003032A9 (en) | Apparatus, systems and methods for constructing large numbers of travel fares | |
CN104268247A (zh) | 一种基于模糊层次分析的主数据归集方法 | |
CN102411600A (zh) | 一种基于蕴涵规则的数据质量自动检测方法 | |
CN100573511C (zh) | 产生分析数据结构的自定义等级体系的系统和方法 | |
EP4150484A1 (en) | Efficient indexing for querying arrays in databases | |
CN116361487A (zh) | 一种多源异构政策知识图谱构建和存储方法及系统 | |
Černjeka et al. | NoSQL document store translation to data vault based EDW | |
KR20050061557A (ko) | 데이터 처리방법 및 데이터 처리 프로그램 | |
US7127457B1 (en) | Method and system for executing database queries | |
CN111125045B (zh) | 一种轻量级etl处理平台 | |
CN1211745C (zh) | 校验参照完整性中涉及的表空间的方法 | |
CN112487015B (zh) | 基于增量重划分的分布式rdf系统及其查询优化方法 | |
CN117390064B (zh) | 一种基于可嵌入子图的数据库查询优化方法 |
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 |