KR101098181B1 - N-차원 원시 olap 큐브 내의 데이터를 분석하기 위한 방법 및 시스템과, n-차원 원시 olap 큐브에 의한 실행을 위해 (n+q)-차원 주문형 질의를 n-차원 질의로 변환하기 위한 방법 - Google Patents

N-차원 원시 olap 큐브 내의 데이터를 분석하기 위한 방법 및 시스템과, n-차원 원시 olap 큐브에 의한 실행을 위해 (n+q)-차원 주문형 질의를 n-차원 질의로 변환하기 위한 방법 Download PDF

Info

Publication number
KR101098181B1
KR101098181B1 KR1020067013355A KR20067013355A KR101098181B1 KR 101098181 B1 KR101098181 B1 KR 101098181B1 KR 1020067013355 A KR1020067013355 A KR 1020067013355A KR 20067013355 A KR20067013355 A KR 20067013355A KR 101098181 B1 KR101098181 B1 KR 101098181B1
Authority
KR
South Korea
Prior art keywords
demand
dimensional
query
axis
layer
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 - Lifetime
Application number
KR1020067013355A
Other languages
English (en)
Korean (ko)
Other versions
KR20070018811A (ko
Inventor
윌리암 러셀 4세 휘트니
Original Assignee
마이크로소프트 코포레이션
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by 마이크로소프트 코포레이션 filed Critical 마이크로소프트 코포레이션
Publication of KR20070018811A publication Critical patent/KR20070018811A/ko
Application granted granted Critical
Publication of KR101098181B1 publication Critical patent/KR101098181B1/ko
Assigned to 마이크로소프트 테크놀로지 라이센싱, 엘엘씨 reassignment 마이크로소프트 테크놀로지 라이센싱, 엘엘씨 권리의 전부이전등록 Assignors: 마이크로소프트 코포레이션
Anticipated expiration legal-status Critical
Expired - Lifetime legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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 OR CALCULATING; 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 OR CALCULATING; 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)
KR1020067013355A 2003-12-02 2004-12-02 N-차원 원시 olap 큐브 내의 데이터를 분석하기 위한 방법 및 시스템과, n-차원 원시 olap 큐브에 의한 실행을 위해 (n+q)-차원 주문형 질의를 n-차원 질의로 변환하기 위한 방법 Expired - Lifetime KR101098181B1 (ko)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US52624603P 2003-12-02 2003-12-02
US60/526,246 2003-12-02
PCT/US2004/040229 WO2005057164A2 (en) 2003-12-02 2004-12-02 System and method for generating custom hierarchies in an analytical data structure

Publications (2)

Publication Number Publication Date
KR20070018811A KR20070018811A (ko) 2007-02-14
KR101098181B1 true KR101098181B1 (ko) 2011-12-27

Family

ID=34676606

Family Applications (1)

Application Number Title Priority Date Filing Date
KR1020067013355A Expired - Lifetime KR101098181B1 (ko) 2003-12-02 2004-12-02 N-차원 원시 olap 큐브 내의 데이터를 분석하기 위한 방법 및 시스템과, n-차원 원시 olap 큐브에 의한 실행을 위해 (n+q)-차원 주문형 질의를 n-차원 질의로 변환하기 위한 방법

Country Status (6)

Country Link
US (1) US7219093B2 (https=)
EP (1) EP1700095B1 (https=)
JP (1) JP4602349B2 (https=)
KR (1) KR101098181B1 (https=)
CN (1) CN100573511C (https=)
WO (1) WO2005057164A2 (https=)

Families Citing this family (9)

* Cited by examiner, † Cited by third party
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
KR20100135789A (ko) * 2008-04-16 2010-12-27 인터내셔널 비지네스 머신즈 코포레이션 질의 처리 시각화 시스템 및 방법과 컴퓨터 프로그램 제품
KR101117649B1 (ko) * 2010-10-13 2012-03-20 세종대학교산학협력단 Ｏｌａｐ 기반의 ３차원 공간에서 데이터 분석 객체의 선택 방법 및 시스템
US9465523B2 (en) 2013-06-27 2016-10-11 Sap Se Visual exploration of multidimensional data
US10769175B1 (en) * 2014-06-20 2020-09-08 Amazon Technologies, Inc. Real-time hosted system analytics
US10776397B2 (en) 2014-06-20 2020-09-15 Amazon Technologies, Inc. Data interest estimation for n-dimensional cube computations
EP3158478B1 (en) 2014-06-20 2023-06-07 Amazon Technologies, Inc. Embeddable cloud analytics
US11868372B1 (en) 2014-06-20 2024-01-09 Amazon Technologies, Inc. Automated hierarchy detection for cloud-based analytics

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040103092A1 (en) 2001-02-12 2004-05-27 Alexander Tuzhilin System, process and software arrangement for providing multidimensional recommendations/suggestions

Family Cites Families (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6122628A (en) * 1997-10-31 2000-09-19 International Business Machines Corporation Multidimensional data clustering and dimension reduction for indexing and searching
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
US6418427B1 (en) * 1999-12-30 2002-07-09 Decode Genetics Ehf Online modifications of dimension structures in multidimensional processing
WO2002003251A2 (en) * 2000-06-29 2002-01-10 Alphablox Corporation Caching scheme for multi-dimensional data
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

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040103092A1 (en) 2001-02-12 2004-05-27 Alexander Tuzhilin System, process and software arrangement for providing multidimensional recommendations/suggestions

Also Published As

Publication number Publication date
EP1700095A4 (en) 2010-01-20
CN100573511C (zh) 2009-12-23
KR20070018811A (ko) 2007-02-14
WO2005057164A2 (en) 2005-06-23
JP2007513428A (ja) 2007-05-24
US7219093B2 (en) 2007-05-15
EP1700095A2 (en) 2006-09-13
JP4602349B2 (ja) 2010-12-22
CN101036140A (zh) 2007-09-12
US20050120018A1 (en) 2005-06-02
EP1700095B1 (en) 2018-02-21
WO2005057164A3 (en) 2006-10-19

Similar Documents

Publication Publication Date Title
US6970874B2 (en) Populating data cubes using calculated relations
US6578028B2 (en) SQL query generator utilizing matrix structures
US6418427B1 (en) Online modifications of dimension structures in multidimensional processing
US7236972B2 (en) Identifier vocabulary data access method and system
US6801910B1 (en) Method and system for guiding drilling in a report generated by a reporting system
US5895465A (en) Heuristic co-identification of objects across heterogeneous information sources
US20160292227A1 (en) Processing database queries using format conversion
US20050034064A1 (en) Method and system for creating and following drill links
US7243106B2 (en) Static drill-through modelling
US7827478B2 (en) Dynamic generation of form pages for accessing a database
US20040181518A1 (en) System and method for an OLAP engine having dynamic disaggregation
US8065343B2 (en) Data storage and retrieval system with optimized categorization of information items based on category selection
KR101098181B1 (ko) N-차원 원시 olap 큐브 내의 데이터를 분석하기 위한 방법 및 시스템과, n-차원 원시 olap 큐브에 의한 실행을 위해 (n+q)-차원 주문형 질의를 n-차원 질의로 변환하기 위한 방법
Černjeka et al. NoSQL document store translation to data vault based EDW
US8214321B2 (en) Systems and methods for data processing
Cecelja Manufacturing Information and Data Systems: Analysis, Design and Practice
KR20010104871A (ko) 검색결과의 자동분류 기능을 갖는 인터넷 사이트 검색서비스 시스템
US7440969B2 (en) Data processing systems and methods for processing a plurality of application programs requiring an input database table having a predefined set of attributes
CA2435861C (en) Static drill-through modelling
CN119597820B (zh) 基于数据模型资产目录的报表生成方法及系统
Chattratichat et al. A visual language for internet-based data mining and data visualisation
Ranjan et al. A bottom-up approach for creating goal hierarchy using olap query recommendation technique
Schussel Advent of information and inquiry services
Westman Design and implementation of a data model for the NPS ARGOS project
Meng Swarm oriented data organization and model analysis for libraries information service

Legal Events

Date Code Title Description
PA0105 International application

Patent event date: 20060703

Patent event code: PA01051R01D

Comment text: International Patent Application

PG1501 Laying open of application
A201 Request for examination
PA0201 Request for examination

Patent event code: PA02012R01D

Patent event date: 20091202

Comment text: Request for Examination of Application

N231 Notification of change of applicant
PN2301 Change of applicant

Patent event date: 20100322

Comment text: Notification of Change of Applicant

Patent event code: PN23011R01D

E902 Notification of reason for refusal
PE0902 Notice of grounds for rejection

Comment text: Notification of reason for refusal

Patent event date: 20110324

Patent event code: PE09021S01D

E701 Decision to grant or registration of patent right
PE0701 Decision of registration

Patent event code: PE07011S01D

Comment text: Decision to Grant Registration

Patent event date: 20111129

GRNT Written decision to grant
PR0701 Registration of establishment

Comment text: Registration of Establishment

Patent event date: 20111219

Patent event code: PR07011E01D

PR1002 Payment of registration fee

Payment date: 20111220

End annual number: 3

Start annual number: 1

PG1601 Publication of registration
FPAY Annual fee payment

Payment date: 20141117

Year of fee payment: 4

PR1001 Payment of annual fee

Payment date: 20141117

Start annual number: 4

End annual number: 4

FPAY Annual fee payment

Payment date: 20151118

Year of fee payment: 5

PR1001 Payment of annual fee

Payment date: 20151118

Start annual number: 5

End annual number: 5

FPAY Annual fee payment

Payment date: 20161123

Year of fee payment: 6

PR1001 Payment of annual fee

Payment date: 20161123

Start annual number: 6

End annual number: 6

FPAY Annual fee payment

Payment date: 20171117

Year of fee payment: 7

PR1001 Payment of annual fee

Payment date: 20171117

Start annual number: 7

End annual number: 7

FPAY Annual fee payment

Payment date: 20181115

Year of fee payment: 8

PR1001 Payment of annual fee

Payment date: 20181115

Start annual number: 8

End annual number: 8

PR1001 Payment of annual fee

Payment date: 20201117

Start annual number: 10

End annual number: 10

PR1001 Payment of annual fee

Payment date: 20211118

Start annual number: 11

End annual number: 11

PR1001 Payment of annual fee

Payment date: 20221116

Start annual number: 12

End annual number: 12

PR1001 Payment of annual fee

Payment date: 20231128

Start annual number: 13

End annual number: 13

PC1801 Expiration of term

Termination date: 20250602

Termination category: Expiration of duration