KR101340817B1 - 유연한 큐브 데이터 웨어하우징 - Google Patents

유연한 큐브 데이터 웨어하우징 Download PDF

Info

Publication number
KR101340817B1
KR101340817B1 KR1020100079551A KR20100079551A KR101340817B1 KR 101340817 B1 KR101340817 B1 KR 101340817B1 KR 1020100079551 A KR1020100079551 A KR 1020100079551A KR 20100079551 A KR20100079551 A KR 20100079551A KR 101340817 B1 KR101340817 B1 KR 101340817B1
Authority
KR
South Korea
Prior art keywords
dimension
metadata
template
olap cube
olap
Prior art date
Application number
KR1020100079551A
Other languages
English (en)
Korean (ko)
Other versions
KR20110023756A (ko
Inventor
라울 마하잔
디네쉬 판데이
스티븐 데니스 커비
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 KR20110023756A publication Critical patent/KR20110023756A/ko
Application granted granted Critical
Publication of KR101340817B1 publication Critical patent/KR101340817B1/ko

Links

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/24—Querying
    • G06F16/248—Presentation of query results
    • 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/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
    • G06F16/83—Querying
    • G06F16/832—Query formulation
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
    • G06F16/83—Querying
    • G06F16/835—Query processing
    • G06F16/8358—Query translation

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
KR1020100079551A 2009-08-31 2010-08-17 유연한 큐브 데이터 웨어하우징 KR101340817B1 (ko)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US23837309P 2009-08-31 2009-08-31
US61/238,373 2009-08-31

Publications (2)

Publication Number Publication Date
KR20110023756A KR20110023756A (ko) 2011-03-08
KR101340817B1 true KR101340817B1 (ko) 2013-12-11

Family

ID=43483762

Family Applications (1)

Application Number Title Priority Date Filing Date
KR1020100079551A KR101340817B1 (ko) 2009-08-31 2010-08-17 유연한 큐브 데이터 웨어하우징

Country Status (7)

Country Link
US (1) US8521755B2 (zh)
EP (1) EP2312465A1 (zh)
JP (2) JP2011054160A (zh)
KR (1) KR101340817B1 (zh)
CN (1) CN102004752B (zh)
AU (1) AU2010212392B2 (zh)
CA (1) CA2713039C (zh)

Families Citing this family (18)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8938416B1 (en) * 2012-01-13 2015-01-20 Amazon Technologies, Inc. Distributed storage of aggregated data
CN102663117B (zh) * 2012-04-18 2013-11-20 中国人民大学 面向数据库与Hadoop混合平台的OLAP查询处理方法
US9411874B2 (en) * 2012-06-14 2016-08-09 Melaleuca, Inc. Simplified interaction with complex database
US20150242867A1 (en) * 2012-09-25 2015-08-27 Vizdynamics Pty Ltd System and method for processing digital traffic metrics
US9460172B2 (en) * 2013-03-13 2016-10-04 Sas Institute Inc. Method to reduce large OLAP cube size using cell selection rules
JP6188011B2 (ja) * 2013-04-19 2017-08-30 株式会社日立システムズ データ提供システム及びデータ提供システムにおける開示ステータス設定方法
CN103227750B (zh) * 2013-04-26 2016-05-25 华为技术有限公司 控制报文传输的方法、装置和系统
CN103559586B (zh) * 2013-11-15 2017-07-21 拉卡拉支付股份有限公司 一种报表文档管理装置、系统及方法
US10042902B2 (en) 2014-01-29 2018-08-07 International Business Machines Corporation Business rules influenced quasi-cubes with higher diligence of data optimization
CN103870571B (zh) 2014-03-14 2017-06-06 华为技术有限公司 多维联机分析处理系统中的立方体重构方法和装置
US20150370882A1 (en) 2014-06-20 2015-12-24 Amazon Technologies, Inc. Use of dependency graphs to dynamically update n-dimensional cubes
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
JP6410932B2 (ja) * 2014-06-20 2018-10-24 アマゾン テクノロジーズ インコーポレイテッド 組み込み可能なクラウド分析
CN105488048A (zh) * 2014-09-16 2016-04-13 中兴通讯股份有限公司 一种数据查询的方法及装置
KR101829198B1 (ko) * 2016-08-29 2018-02-19 (주)비아이매트릭스 보고서의 중요도를 분석하는 메타 데이터 기반 온라인 분석 프로세싱 시스템
CN107515899B (zh) * 2017-07-24 2020-05-22 北京中电普华信息技术有限公司 数据库联合分片方法、装置以及存储介质
US11263226B2 (en) * 2019-12-02 2022-03-01 Bank Of America Corporation Real-time intelligence engine for data asset discovery

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH11316766A (ja) * 1998-04-30 1999-11-16 Pfu Ltd 多次元分析構築システム及び分析処理用データベース
US20020059183A1 (en) * 2000-09-25 2002-05-16 Li-Wen Chen Method and system for managing event attributes

Family Cites Families (16)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2000285128A (ja) 1999-03-31 2000-10-13 Toshiba System Kaihatsu Kk 業務分析システム
US6477536B1 (en) * 1999-06-22 2002-11-05 Microsoft Corporation Virtual cubes
US7167859B2 (en) 2000-04-27 2007-01-23 Hyperion Solutions Corporation Database security
US6775675B1 (en) * 2001-04-04 2004-08-10 Sagemetrics Corporation Methods for abstracting data from various data structures and managing the presentation of the data
US7953694B2 (en) * 2003-01-13 2011-05-31 International Business Machines Corporation Method, system, and program for specifying multidimensional calculations for a relational OLAP engine
US20040215656A1 (en) 2003-04-25 2004-10-28 Marcus Dill Automated data mining runs
US7305408B2 (en) * 2003-08-12 2007-12-04 Oracle International Corporation System and method for cross attribute analysis and manipulation in online analytical processing (OLAP) and multi-dimensional planning applications by dimension splitting
US7421740B2 (en) * 2004-06-10 2008-09-02 Sap Ag Managing user authorizations for analytical reporting based on operational authorizations
US7505888B2 (en) 2004-11-30 2009-03-17 International Business Machines Corporation Reporting model generation within a multidimensional enterprise software system
US7593955B2 (en) * 2004-11-30 2009-09-22 International Business Machines Corporation Generation of aggregatable dimension information within a multidimensional enterprise software system
US7800613B2 (en) * 2004-12-02 2010-09-21 Tableau Software, Inc. Computer systems and methods for visualizing data with generation of marks
US7734649B2 (en) * 2004-12-28 2010-06-08 Intel Corporation Deriving and using data access control information to determine whether to permit derivations of data elements
US7587410B2 (en) * 2005-03-22 2009-09-08 Microsoft Corporation Dynamic cube services
US20070078823A1 (en) * 2005-09-30 2007-04-05 Microsoft Corporation Expression templates and object classes for multidimensional analytics expressions
US7743071B2 (en) 2007-02-26 2010-06-22 Microsoft Corporation Efficient data handling representations
CN101178732A (zh) * 2007-12-12 2008-05-14 江苏省电力公司 基于元数据快速实现数据仓库过程的方法

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH11316766A (ja) * 1998-04-30 1999-11-16 Pfu Ltd 多次元分析構築システム及び分析処理用データベース
US20020059183A1 (en) * 2000-09-25 2002-05-16 Li-Wen Chen Method and system for managing event attributes

Also Published As

Publication number Publication date
JP2014002792A (ja) 2014-01-09
JP2011054160A (ja) 2011-03-17
US8521755B2 (en) 2013-08-27
KR20110023756A (ko) 2011-03-08
EP2312465A1 (en) 2011-04-20
CA2713039C (en) 2014-06-10
CA2713039A1 (en) 2011-02-28
US20110055146A1 (en) 2011-03-03
CN102004752B (zh) 2016-11-23
AU2010212392B2 (en) 2012-06-28
JP5771253B2 (ja) 2015-08-26
CN102004752A (zh) 2011-04-06
AU2010212392A1 (en) 2011-03-17

Similar Documents

Publication Publication Date Title
KR101340817B1 (ko) 유연한 큐브 데이터 웨어하우징
US8200618B2 (en) System and method for analyzing data in a report
US10872162B2 (en) Role-based security policy for an object-oriented database system
US7480663B2 (en) Model based optimization with focus regions
US8135698B2 (en) Techniques for representing relationships between queries
Tao et al. Range search on multidimensional uncertain data
CN107533570B (zh) 用于从表格数据自动推断立方体模式的系统和方法
RU2402060C2 (ru) Доступ к данным и организация данных, осуществляемые посредством диаграмм
US9535970B2 (en) Metric catalog system
US7080090B2 (en) Allocation measures and metric calculations in star schema multi-dimensional data warehouse
US10824613B2 (en) Preconfiguring measures and dimensions in a database analytics application
US8219547B2 (en) Indirect database queries with large OLAP cubes
US20020016924A1 (en) Database security
US20140181151A1 (en) Query of multiple unjoined views
US20130124484A1 (en) Persistent flow apparatus to transform metrics packages received from wireless devices into a data store suitable for mobile communication network analysis by visualization
Šaltenis et al. Indexing of now-relative spatio-bitemporal data
US9811931B2 (en) Recommendations for creation of visualizations
Wajszczyk et al. Optimization of the efficiency of search operations in the relational database of radio electronic systems

Legal Events

Date Code Title Description
A201 Request for examination
E902 Notification of reason for refusal
N231 Notification of change of applicant
AMND Amendment
E902 Notification of reason for refusal
AMND Amendment
E601 Decision to refuse application
AMND Amendment
X701 Decision to grant (after re-examination)
GRNT Written decision to grant
FPAY Annual fee payment

Payment date: 20161028

Year of fee payment: 4

FPAY Annual fee payment

Payment date: 20171027

Year of fee payment: 5

FPAY Annual fee payment

Payment date: 20181115

Year of fee payment: 6