CN100573511C - 产生分析数据结构的自定义等级体系的系统和方法 - Google Patents

产生分析数据结构的自定义等级体系的系统和方法 Download PDF

Info

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
custom
hierarchy
query
dimensional
native
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
Application number
CNB2004800412222A
Other languages
English (en)
Chinese (zh)
Other versions
CN101036140A (zh
Inventor
威廉·拉塞尔·惠特尼四世
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Microsoft Technology Licensing LLC
Original Assignee
Proclarity Corp
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 Proclarity Corp filed Critical Proclarity Corp
Publication of CN101036140A publication Critical patent/CN101036140A/zh
Application granted granted Critical
Publication of CN100573511C publication Critical patent/CN100573511C/zh
Anticipated expiration legal-status Critical
Expired - Fee Related 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)
CNB2004800412222A 2003-12-02 2004-12-02 产生分析数据结构的自定义等级体系的系统和方法 Expired - Fee Related CN100573511C (zh)

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 (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 (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1216841A (zh) * 1997-10-31 1999-05-19 国际商业机器公司 用于索引和检索的多维数据聚类和降维
US6418427B1 (en) * 1999-12-30 2002-07-09 Decode Genetics Ehf Online modifications of dimension structures in multidimensional processing
WO2002065327A1 (en) * 2001-02-12 2002-08-22 New York University System, process and software arrangement for providing multidimensional recommendation/suggestions

Family Cites Families (6)

* Cited by examiner, † Cited by third party
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
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 (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1216841A (zh) * 1997-10-31 1999-05-19 国际商业机器公司 用于索引和检索的多维数据聚类和降维
US6418427B1 (en) * 1999-12-30 2002-07-09 Decode Genetics Ehf Online modifications of dimension structures in multidimensional processing
WO2002065327A1 (en) * 2001-02-12 2002-08-22 New York University System, process and software arrangement for providing multidimensional recommendation/suggestions

Also Published As

Publication number Publication date
EP1700095A4 (en) 2010-01-20
KR20070018811A (ko) 2007-02-14
WO2005057164A2 (en) 2005-06-23
JP2007513428A (ja) 2007-05-24
KR101098181B1 (ko) 2011-12-27
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
CN101111835B (zh) 多维企业软件系统中的自动默认维度选择方法
US11966419B2 (en) Systems and methods for combining data analyses
US8612438B2 (en) Techniques for dynamic cross-filtering
US7239985B1 (en) Methods, systems, and data structures for modeling information quality and maturity
Kahn A method for describing information required by the database design process
US10713268B1 (en) Methods and systems for social awareness
US7827478B2 (en) Dynamic generation of form pages for accessing a database
US10552423B2 (en) Semantic tagging of nodes
US9032362B2 (en) System and method for generating high performance calculators for calculation graphs
CN118981475A (zh) 基于大模型的sql语句生成方法及装置
CN110569289A (zh) 基于大数据的列数据处理方法、设备及介质
US7809678B2 (en) Fact dimensions in multidimensional databases
CN100573511C (zh) 产生分析数据结构的自定义等级体系的系统和方法
US20070219957A1 (en) Cross varying dimension support for analysis services engine
CN101044472A (zh) 数据系统中的语义识别方法和系统
Cecelja Manufacturing Information and Data Systems: Analysis, Design and Practice
CN110874366B (zh) 数据处理、查询方法和装置
TW200417884A (en) System and method for automatically classifying bill of material
US8250024B2 (en) Search relevance in business intelligence systems through networked ranking
CN112396280A (zh) 产品对标管理方法、系统、电子设备和介质
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
WO2020091627A1 (en) Method of forming and structuring an electronic database
US9460139B2 (en) Distributed storage system with pluggable query processing
CN112487185A (zh) 一种电力客户领域的数据分类方法
US20260080348A1 (en) System and method for content retrieval and evaluation

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