JP7465870B2 - 多次元データベース環境における依存関係分析のためのシステムおよび方法 - Google Patents

多次元データベース環境における依存関係分析のためのシステムおよび方法 Download PDF

Info

Publication number
JP7465870B2
JP7465870B2 JP2021521186A JP2021521186A JP7465870B2 JP 7465870 B2 JP7465870 B2 JP 7465870B2 JP 2021521186 A JP2021521186 A JP 2021521186A JP 2021521186 A JP2021521186 A JP 2021521186A JP 7465870 B2 JP7465870 B2 JP 7465870B2
Authority
JP
Japan
Prior art keywords
members
dynamic member
multidimensional database
dynamic
run
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.)
Active
Application number
JP2021521186A
Other languages
English (en)
Japanese (ja)
Other versions
JPWO2020081586A5 (https=
JP2022505230A5 (https=
JP2022505230A (ja
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 JP2022505230A publication Critical patent/JP2022505230A/ja
Publication of JPWO2020081586A5 publication Critical patent/JPWO2020081586A5/ja
Publication of JP2022505230A5 publication Critical patent/JP2022505230A5/ja
Priority to JP2024051603A priority Critical patent/JP7770453B2/ja
Application granted granted Critical
Publication of JP7465870B2 publication Critical patent/JP7465870B2/ja
Active legal-status Critical Current
Anticipated expiration legal-status Critical

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/23—Updating
    • G06F16/2365—Ensuring data consistency and integrity
    • 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/245—Query processing
    • G06F16/2455—Query execution

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Computer Security & Cryptography (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
JP2021521186A 2018-10-18 2019-10-15 多次元データベース環境における依存関係分析のためのシステムおよび方法 Active JP7465870B2 (ja)

Priority Applications (1)

Application Number Priority Date Filing Date Title
JP2024051603A JP7770453B2 (ja) 2018-10-18 2024-03-27 多次元データベース環境における依存関係分析のためのシステムおよび方法

Applications Claiming Priority (5)

Application Number Priority Date Filing Date Title
IN201841039503 2018-10-18
IN201841039503 2018-10-18
US16/439,532 2019-06-12
US16/439,532 US11200223B2 (en) 2018-10-18 2019-06-12 System and method for dependency analysis in a multidimensional database environment
PCT/US2019/056363 WO2020081586A1 (en) 2018-10-18 2019-10-15 System and method for dependency analysis in a multidimensional database environment

Related Child Applications (1)

Application Number Title Priority Date Filing Date
JP2024051603A Division JP7770453B2 (ja) 2018-10-18 2024-03-27 多次元データベース環境における依存関係分析のためのシステムおよび方法

Publications (4)

Publication Number Publication Date
JP2022505230A JP2022505230A (ja) 2022-01-14
JPWO2020081586A5 JPWO2020081586A5 (https=) 2022-08-03
JP2022505230A5 JP2022505230A5 (https=) 2022-08-03
JP7465870B2 true JP7465870B2 (ja) 2024-04-11

Family

ID=70279278

Family Applications (2)

Application Number Title Priority Date Filing Date
JP2021521186A Active JP7465870B2 (ja) 2018-10-18 2019-10-15 多次元データベース環境における依存関係分析のためのシステムおよび方法
JP2024051603A Active JP7770453B2 (ja) 2018-10-18 2024-03-27 多次元データベース環境における依存関係分析のためのシステムおよび方法

Family Applications After (1)

Application Number Title Priority Date Filing Date
JP2024051603A Active JP7770453B2 (ja) 2018-10-18 2024-03-27 多次元データベース環境における依存関係分析のためのシステムおよび方法

Country Status (5)

Country Link
US (2) US11200223B2 (https=)
EP (1) EP3867774B1 (https=)
JP (2) JP7465870B2 (https=)
CN (1) CN112912872B (https=)
WO (1) WO2020081586A1 (https=)

Families Citing this family (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US11200223B2 (en) 2018-10-18 2021-12-14 Oracle International Corporation System and method for dependency analysis in a multidimensional database environment
US11620541B1 (en) 2019-10-17 2023-04-04 Splunk Inc. Custom use case framework in computer analytics system
USD959477S1 (en) 2019-12-20 2022-08-02 Sap Se Display system or portion thereof with a virtual three-dimensional animated graphical user interface
US11205296B2 (en) * 2019-12-20 2021-12-21 Sap Se 3D data exploration using interactive cuboids
USD959476S1 (en) 2019-12-20 2022-08-02 Sap Se Display system or portion thereof with a virtual three-dimensional animated graphical user interface
USD959447S1 (en) 2019-12-20 2022-08-02 Sap Se Display system or portion thereof with a virtual three-dimensional animated graphical user interface
CN117633025A (zh) * 2022-08-09 2024-03-01 北京国双科技有限公司 数据预聚合的处理方法及装置
US12158865B2 (en) * 2022-12-01 2024-12-03 Business Objects Software Ltd Automated database artifact update using design definitions
US11868672B1 (en) 2023-03-30 2024-01-09 Brelyon, Inc. Methods and systems for interactive displays with intelligent generative content and tandem computing
US12608377B2 (en) 2024-09-26 2026-04-21 Oracle International Corporation System and method for bottom up multidimensional data analysis in complex formulas types

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20120185425A1 (en) 2009-09-29 2012-07-19 Zap Holdings Limited Content based approach to extending the form and function of a business intelligence system
US20170116309A1 (en) 2015-10-23 2017-04-27 Oracle International Corporation System and method for automatic dependency analysis for use with a multidimensional database
JP2017525072A (ja) 2014-06-20 2017-08-31 アマゾン テクノロジーズ インコーポレイテッド 組み込み可能なクラウド分析

Family Cites Families (52)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5574952A (en) 1994-05-11 1996-11-12 International Business Machines Corporation Data storage system and method for operating a disk controller including allocating disk space for compressed data
US5915129A (en) 1994-06-27 1999-06-22 Microsoft Corporation Method and system for storing uncompressed data in a memory cache that is destined for a compressed file system
CA2205836C (en) 1994-11-21 2005-05-24 Oracle Corporation Method and apparatus for multidimensional database using binary hyperspatial code
JP3952518B2 (ja) * 1996-03-29 2007-08-01 株式会社日立製作所 多次元データ処理方法
US6574720B1 (en) 1997-05-30 2003-06-03 Oracle International Corporation System for maintaining a buffer pool
US6167396A (en) * 1999-05-12 2000-12-26 Knosys, Inc. Method and apparatus for navigating and displaying data points stored in a multidimensional database
US9208213B2 (en) 1999-05-28 2015-12-08 Microstrategy, Incorporated System and method for network user interface OLAP report formatting
US6766325B1 (en) 1999-12-02 2004-07-20 Microsoft Corporation System and method for maintaining data for performing “what if” analysis
US20020029207A1 (en) 2000-02-28 2002-03-07 Hyperroll, Inc. Data aggregation server for managing a multi-dimensional database and database management system having data aggregation server integrated therein
US7222130B1 (en) * 2000-04-03 2007-05-22 Business Objects, S.A. Report then query capability for a multidimensional database model
US6629102B1 (en) 2000-07-28 2003-09-30 International Business Machines Corporation Efficiently updating a key table during outline restructure of a multi-dimensional database
US7133876B2 (en) 2001-06-12 2006-11-07 The University Of Maryland College Park Dwarf cube architecture for reducing storage sizes of multidimensional data
US6880154B2 (en) 2001-06-29 2005-04-12 Intel Corporation Alias-free test for dynamic array structures
US7058783B2 (en) 2002-09-18 2006-06-06 Oracle International Corporation Method and mechanism for on-line data compression and in-place updates
US7392242B1 (en) 2004-02-27 2008-06-24 Hyperion Solutions Corporation Query costing in a multidimensional database
US7647356B2 (en) 2004-05-07 2010-01-12 Oracle International Corporation Methods and apparatus for facilitating analysis of large data sets
US7562086B2 (en) 2004-07-09 2009-07-14 Microsoft Corporation Custom grouping for dimension members
US20060106769A1 (en) 2004-11-12 2006-05-18 Gibbs Kevin A Method and system for autocompletion for languages having ideographs and phonetic characters
US8510329B2 (en) 2005-05-25 2013-08-13 Experian Marketing Solutions, Inc. Distributed and interactive database architecture for parallel and asynchronous data processing of complex data and for real-time query processing
AU2006260795A1 (en) 2005-06-20 2006-12-28 Future Route Limited Analytical system for discovery and generation of rules to predict and detect anomalies in data and financial fraud
US7792847B2 (en) 2005-09-09 2010-09-07 Microsoft Corporation Converting structured reports to formulas
US7805433B2 (en) 2005-10-14 2010-09-28 Microsoft Corporation Multidimensional cube functions
US20070094668A1 (en) 2005-10-17 2007-04-26 Jacquot Bryan J Method and apparatus for dynamically allocating resources used by software
US8156083B2 (en) 2005-12-01 2012-04-10 Oracle International Corporation Database system that provides for history-enabled tables
US8484252B2 (en) * 2006-11-30 2013-07-09 International Business Machines Corporation Generation of a multidimensional dataset from an associative database
US8108399B2 (en) 2007-05-18 2012-01-31 Microsoft Corporation Filtering of multi attribute data via on-demand indexing
US8234298B2 (en) 2007-07-25 2012-07-31 International Business Machines Corporation System and method for determining driving factor in a data cube
US8082239B2 (en) * 2008-02-04 2011-12-20 Microsoft Corporation Defining sub-cube scope based upon a query
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
US8606803B2 (en) 2008-04-01 2013-12-10 Microsoft Corporation Translating a relational query to a multidimensional query
US8169481B2 (en) 2008-05-05 2012-05-01 Panasonic Corporation System architecture and process for assessing multi-perspective multi-context abnormal behavior
US10360527B2 (en) 2010-11-10 2019-07-23 International Business Machines Corporation Casual modeling of multi-dimensional hierarchical metric cubes
US9081830B1 (en) * 2011-10-08 2015-07-14 Bay Dynamics Updating a view of a multidimensional cube
US9390082B1 (en) * 2011-10-08 2016-07-12 Bay Dynamics, Inc. Generating multiple views of a multidimensional cube
US9020991B2 (en) 2012-08-10 2015-04-28 Ca, Inc. System and method for analyzing available space in data blocks
US20140122413A1 (en) 2012-10-29 2014-05-01 Paris Technologies, Inc. Bulk read and write between multi-dimensional data structures
US10083195B2 (en) 2014-04-24 2018-09-25 Futurewei Technologies, Inc. System and method for composing a multidimensional index key in data blocks
US10909178B2 (en) * 2015-03-05 2021-02-02 Workday, Inc. Methods and systems for multidimensional analysis of interconnected data sets stored in a graph database
US10984020B2 (en) * 2015-10-23 2021-04-20 Oracle International Corporation System and method for supporting large queries in a multidimensional database environment
WO2017070385A1 (en) * 2015-10-23 2017-04-27 Oracle International Corporation System and method for sandboxing support in a multidimensional database environment
US20170116311A1 (en) 2015-10-23 2017-04-27 Oracle International Corporation System and method for use of automatic slice merge in a multidimensional database environment
US11226987B2 (en) 2015-10-23 2022-01-18 Oracle International Corporation System and method for in-place data writes to reduce fragmentation in a multidimensional database environment
US10318498B2 (en) 2015-10-23 2019-06-11 Oracle International Corporation System and method for parallel support of multidimensional slices with a multidimensional database
US10346435B2 (en) 2015-10-23 2019-07-09 Oracle International Corporation System and method for improved performance in a multidimensional database environment
US10628451B2 (en) 2015-10-23 2020-04-21 Oracle International Corporation System and method for supporting queries having sub-select constructs in a multidimensional database environment
US10552393B2 (en) 2015-10-23 2020-02-04 Oracle International Corporation System and method for use of a dynamic flow in a multidimensional database environment
US10909134B2 (en) 2017-09-01 2021-02-02 Oracle International Corporation System and method for client-side calculation in a multidimensional database environment
US10983972B2 (en) 2017-09-08 2021-04-20 Oracle International Corporation System and method for slowing changing dimension and metadata versioning in a multidimensional database environment
US11593402B2 (en) 2017-09-29 2023-02-28 Oracle International Corporation System and method for enabling multiple parents with weights in a multidimensional database environment
US20190102447A1 (en) 2017-09-29 2019-04-04 Oracle International Corporation System and method for metadata sandboxing and what-if analysis in a multidimensional database environment
US11042569B2 (en) 2017-09-29 2021-06-22 Oracle International Corporation System and method for load, aggregate and batch calculation in one scan in a multidimensional database environment
US11200223B2 (en) 2018-10-18 2021-12-14 Oracle International Corporation System and method for dependency analysis in a multidimensional database environment

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20120185425A1 (en) 2009-09-29 2012-07-19 Zap Holdings Limited Content based approach to extending the form and function of a business intelligence system
JP2017525072A (ja) 2014-06-20 2017-08-31 アマゾン テクノロジーズ インコーポレイテッド 組み込み可能なクラウド分析
US20170116309A1 (en) 2015-10-23 2017-04-27 Oracle International Corporation System and method for automatic dependency analysis for use with a multidimensional database

Also Published As

Publication number Publication date
US11768825B2 (en) 2023-09-26
CN112912872B (zh) 2024-08-06
JP2024096728A (ja) 2024-07-17
US20220067026A1 (en) 2022-03-03
US20200125550A1 (en) 2020-04-23
EP3867774B1 (en) 2024-06-19
US11200223B2 (en) 2021-12-14
CN112912872A (zh) 2021-06-04
EP3867774A1 (en) 2021-08-25
WO2020081586A1 (en) 2020-04-23
JP7770453B2 (ja) 2025-11-14
JP2022505230A (ja) 2022-01-14

Similar Documents

Publication Publication Date Title
JP7770453B2 (ja) 多次元データベース環境における依存関係分析のためのシステムおよび方法
US12197408B2 (en) System and method for use of a dynamic flow in a multidimensional database environment
US11789978B2 (en) System and method for load, aggregate and batch calculation in one scan in a multidimensional database environment
US12079245B2 (en) System and method for supporting large queries in a multidimensional database environment
US20210286787A1 (en) System and method for slowly changing dimension and metadata versioning in a multidimensional database environment
US7574424B2 (en) Database system with methodology for parallel schedule generation in a query optimizer
US20190102447A1 (en) System and method for metadata sandboxing and what-if analysis in a multidimensional database environment
US20060218123A1 (en) System and Methodology for Parallel Query Optimization Using Semantic-Based Partitioning
JP7202442B2 (ja) 多次元データベース環境における仮想キューブでのリアルタイムデータ集約のためのシステムおよび方法
US20070040094A1 (en) Method and system for handling large data sets in a statistical language
US11704345B2 (en) Inferring location attributes from data entries
Cafaro et al. Frequent itemset mining
US12608377B2 (en) System and method for bottom up multidimensional data analysis in complex formulas types
CN116306630A (zh) 业务架构的定位方法、装置、电子设备、介质和程序产品
Mondol et al. An efficient method to build a standard data entry system by extracting OLAP cubes from NoSQL data sources
Shah Revisiting Statistical Techniques for Result Cardinality Estimation
Hagedorn Efficient processing of large-scale spatio-temporal data
Ray High performance spatial and spatio-temporal data processing

Legal Events

Date Code Title Description
A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20220726

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20220726

A977 Report on retrieval

Free format text: JAPANESE INTERMEDIATE CODE: A971007

Effective date: 20230816

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20231003

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20231208

TRDD Decision of grant or rejection written
A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

Effective date: 20240305

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20240401

R150 Certificate of patent or registration of utility model

Ref document number: 7465870

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150