JP2018536909A5 - - Google Patents

Download PDF

Info

Publication number
JP2018536909A5
JP2018536909A5 JP2017558695A JP2017558695A JP2018536909A5 JP 2018536909 A5 JP2018536909 A5 JP 2018536909A5 JP 2017558695 A JP2017558695 A JP 2017558695A JP 2017558695 A JP2017558695 A JP 2017558695A JP 2018536909 A5 JP2018536909 A5 JP 2018536909A5
Authority
JP
Japan
Prior art keywords
columns
cube
directed graph
cube schema
pair
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
Application number
JP2017558695A
Other languages
English (en)
Japanese (ja)
Other versions
JP2018536909A (ja
JP6846356B2 (ja
Filing date
Publication date
Application filed filed Critical
Priority claimed from PCT/US2016/058209 external-priority patent/WO2017070533A1/en
Publication of JP2018536909A publication Critical patent/JP2018536909A/ja
Publication of JP2018536909A5 publication Critical patent/JP2018536909A5/ja
Application granted granted Critical
Publication of JP6846356B2 publication Critical patent/JP6846356B2/ja
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

JP2017558695A 2015-10-23 2016-10-21 表形式データから、多次元データベース環境に使用されるキューブスキーマを自動的に推論するためのシステムおよび方法 Active JP6846356B2 (ja)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US201562245885P 2015-10-23 2015-10-23
US62/245,885 2015-10-23
PCT/US2016/058209 WO2017070533A1 (en) 2015-10-23 2016-10-21 System and method for automatic inference of a cube schema from a tabular data for use in a multidimensional database environment

Publications (3)

Publication Number Publication Date
JP2018536909A JP2018536909A (ja) 2018-12-13
JP2018536909A5 true JP2018536909A5 (enExample) 2019-11-07
JP6846356B2 JP6846356B2 (ja) 2021-03-24

Family

ID=57219058

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2017558695A Active JP6846356B2 (ja) 2015-10-23 2016-10-21 表形式データから、多次元データベース環境に使用されるキューブスキーマを自動的に推論するためのシステムおよび方法

Country Status (5)

Country Link
US (2) US10846273B2 (enExample)
EP (1) EP3365810B1 (enExample)
JP (1) JP6846356B2 (enExample)
CN (1) CN107533570B (enExample)
WO (1) WO2017070533A1 (enExample)

Families Citing this family (17)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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
US10733155B2 (en) 2015-10-23 2020-08-04 Oracle International Corporation System and method for extracting a star schema from tabular data for use in a multidimensional database environment
US10977435B2 (en) * 2015-12-28 2021-04-13 Informatica Llc Method, apparatus, and computer-readable medium for visualizing relationships between pairs of columns
US10747736B2 (en) * 2016-11-09 2020-08-18 Sap Se Aggregation database for external dataset
US10650050B2 (en) * 2016-12-06 2020-05-12 Microsoft Technology Licensing, Llc Synthesizing mapping relationships using table corpus
US10061637B1 (en) * 2017-01-19 2018-08-28 Amdocs Development Limited System, method, and computer program for automatic root cause analysis
KR101758219B1 (ko) * 2017-01-24 2017-07-14 김훈 수치정보 검색이 가능한 수치정보 관리장치
JP6815931B2 (ja) * 2017-05-10 2021-01-20 Kddi株式会社 統計量データ処理装置、統計量データ処理方法およびプログラム
CN110019440B (zh) * 2017-08-30 2021-06-08 北京国双科技有限公司 数据的处理方法及装置
CN107678531B (zh) * 2017-09-30 2020-12-01 Oppo广东移动通信有限公司 应用清理方法、装置、存储介质及电子设备
US10509805B2 (en) 2018-03-13 2019-12-17 deFacto Global, Inc. Systems, methods, and devices for generation of analytical data reports using dynamically generated queries of a structured tabular cube
CN110727840B (zh) * 2019-09-27 2022-07-05 浙江大搜车软件技术有限公司 车辆问询标签推送方法、装置、计算机设备和存储介质
CN110728124B (zh) * 2019-10-15 2021-01-08 深圳逻辑汇科技有限公司 用于可视化电子表格的方法、装置、设备及存储介质
CN111143412A (zh) * 2019-12-24 2020-05-12 中科金审(北京)科技有限公司 数据对比方法、装置、计算机及计算机可读存储介质
WO2021176572A1 (ja) * 2020-03-03 2021-09-10 富士通株式会社 機械学習プログラム、機械学習方法及び機械学習装置
US12216650B2 (en) * 2020-09-25 2025-02-04 Oracle International Corporation System and method for use of a fragmented query model in an analytic applications environment
US11789704B2 (en) 2021-01-26 2023-10-17 Donyati, Llc Dynamic application builder for multidimensional database environments

Family Cites Families (73)

* 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
EP0793831B1 (en) 1994-11-21 2002-12-04 Oracle Corporation Method and apparatus for multidimensional database using binary hyperspatial code
US6574720B1 (en) 1997-05-30 2003-06-03 Oracle International Corporation System for maintaining a buffer pool
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
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
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
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
US6873994B2 (en) 2001-08-31 2005-03-29 I2 Technologies Us, Inc. Conflict detection and resolution in association with data allocation
US7146375B2 (en) 2002-01-25 2006-12-05 Decode Genetics, Ehf Inference control method in a data cube
US8386296B2 (en) 2002-03-08 2013-02-26 Agile Software Corporation System and method for managing and monitoring supply costs
US7366730B2 (en) * 2002-04-26 2008-04-29 Oracle International Corporation Registration of solved cubes within a relational database management system
US7058783B2 (en) 2002-09-18 2006-06-06 Oracle International Corporation Method and mechanism for on-line data compression and in-place updates
US7181450B2 (en) 2002-12-18 2007-02-20 International Business Machines Corporation Method, system, and program for use of metadata to create multidimensional cubes in a relational database
US20040193633A1 (en) * 2003-03-28 2004-09-30 Cristian Petculescu Systems, methods, and apparatus for automated dimensional model definitions and builds utilizing simplified analysis heuristics
US7089266B2 (en) 2003-06-02 2006-08-08 The Board Of Trustees Of The Leland Stanford Jr. University Computer systems and methods for the query and visualization of multidimensional databases
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
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
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
EP1894151A2 (en) * 2005-06-20 2008-03-05 Future Route Limited Analytical system for discovery and generation of rules to predict and detect anomalies in data and financial fraud
JP2008544382A (ja) * 2005-06-24 2008-12-04 オービタル・テクノロジーズ・インコーポレーテッド 関係データベースクエリと多次元データベースクエリとを変換するシステムおよび方法
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
EP2041676A4 (en) 2006-06-26 2012-05-16 Nielsen Co Us Llc METHOD AND DEVICES FOR IMPROVING THE DATA WAREHOUSE EFFICIENCY
US20080027966A1 (en) * 2006-07-25 2008-01-31 Parees Benjamin M Dynamic creation of star-schema database structures and cubes
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
US8380748B2 (en) * 2008-03-05 2013-02-19 Microsoft Corporation Multidimensional data cubes with high-cardinality attributes
US9483537B1 (en) * 2008-03-07 2016-11-01 Birst, Inc. Automatic data warehouse generation using automatically generated schema
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
US7970728B2 (en) 2008-10-23 2011-06-28 International Business Machines Corporation Dynamically building and populating data marts with data stored in repositories
US20120005153A1 (en) * 2009-02-10 2012-01-05 Mark Joseph Ledwich Creation of a data store
US8195643B2 (en) * 2010-10-28 2012-06-05 Sap Ag Database calculation engine
US10360527B2 (en) * 2010-11-10 2019-07-23 International Business Machines Corporation Casual modeling of multi-dimensional hierarchical metric cubes
US10102236B2 (en) * 2011-11-15 2018-10-16 Pvelocity Inc. Method and system for providing business intelligence data
US20130332221A1 (en) 2012-06-12 2013-12-12 Siemens Aktiengesellschaft Method And System For Determining Critical Information Interfaces
US9020991B2 (en) 2012-08-10 2015-04-28 Ca, Inc. System and method for analyzing available space in data blocks
WO2014041699A1 (ja) * 2012-09-14 2014-03-20 株式会社日立製作所 データ分析方法、データ分析装置及びその処理プログラムを格納した記憶媒体
US20140122413A1 (en) 2012-10-29 2014-05-01 Paris Technologies, Inc. Bulk read and write between multi-dimensional data structures
CN103793422B (zh) * 2012-10-31 2017-05-17 国际商业机器公司 基于增强星型模型的立方体元数据及查询语句生成
US9760571B1 (en) * 2013-07-23 2017-09-12 jSonar Inc. Tabular DB interface for unstructured data
US9898501B2 (en) * 2013-09-12 2018-02-20 Neustar, Inc. Method and system for performing transactional updates in a key-value store
US10353923B2 (en) * 2014-04-24 2019-07-16 Ebay Inc. Hadoop OLAP engine
US10083195B2 (en) 2014-04-24 2018-09-25 Futurewei Technologies, Inc. System and method for composing a multidimensional index key in data blocks
US10698924B2 (en) * 2014-05-22 2020-06-30 International Business Machines Corporation Generating partitioned hierarchical groups based on data sets for business intelligence data models
CA2901718C (en) * 2015-06-25 2022-08-30 Dundas Data Visualization, Inc. Systems and methods for intelligent data preparation and visualization
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
US10467251B2 (en) 2015-10-23 2019-11-05 Oracle International Corporation System and method for automatic dependency analysis for use with a multidimensional database
US10838982B2 (en) 2015-10-23 2020-11-17 Oracle International Corporation System and method for aggregating values through risk dimension hierarchies 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
US10984020B2 (en) 2015-10-23 2021-04-20 Oracle International Corporation System and method for supporting large queries in a multidimensional database environment
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
US10733155B2 (en) * 2015-10-23 2020-08-04 Oracle International Corporation System and method for extracting a star schema from tabular data for use 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
US9773029B2 (en) 2016-01-06 2017-09-26 International Business Machines Corporation Generation of a data model
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
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
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

Similar Documents

Publication Publication Date Title
JP2018536909A5 (enExample)
JP6846356B2 (ja) 表形式データから、多次元データベース環境に使用されるキューブスキーマを自動的に推論するためのシステムおよび方法
US8856157B2 (en) Automatic detection of columns to be obfuscated in database schemas
Singh et al. Wavelet collocation method based on Legendre polynomials and its application in solving the stochastic fractional integro-differential equations
JP4878624B2 (ja) 文書処理装置および文書処理方法
JP2008287744A5 (enExample)
JP2004362595A5 (enExample)
JP2017522630A5 (enExample)
CN104133870A (zh) 一种网页相似度计算方法及装置
US10380133B2 (en) Information landscape modeling, analysis and validation
US10671668B2 (en) Inferring graph topologies
CN103999079A (zh) 对准文档的字段的注解
CN104850623B (zh) 多维度数据分析模型动态扩展方法和系统
US8694918B2 (en) Conveying hierarchical elements of a user interface
US8527552B2 (en) Database consistent sample data extraction
Chevalier et al. Document-oriented data warehouses: Complex hierarchies and summarizability
US10198473B2 (en) Hierarchical document flow determination
WO2016132472A1 (ja) データ検索装置及びデータ検索方法及びデータ検索プログラム
KR20170128666A (ko) 질의 처리 방법 및 시스템
Druskat A proposal for the measurement and documentation of research software sustainability in interactive metadata repositories
JP2014149613A (ja) 項目間関連解析装置
Tomingas et al. Rule-based impact analysis for enterprise business intelligence
Solodovnikova et al. Query-driven method for improvement of data warehouse conceptual model
Weiss et al. The chunking pattern
Egami et al. Building of industrial parts lod for edi-a case study