JP5826831B2 - データマート自動化 - Google Patents

データマート自動化 Download PDF

Info

Publication number
JP5826831B2
JP5826831B2 JP2013512642A JP2013512642A JP5826831B2 JP 5826831 B2 JP5826831 B2 JP 5826831B2 JP 2013512642 A JP2013512642 A JP 2013512642A JP 2013512642 A JP2013512642 A JP 2013512642A JP 5826831 B2 JP5826831 B2 JP 5826831B2
Authority
JP
Japan
Prior art keywords
data
business intelligence
intelligence server
levels
aggregation
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
JP2013512642A
Other languages
English (en)
Japanese (ja)
Other versions
JP2013531844A (ja
JP2013531844A5 (enExample
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 JP2013531844A publication Critical patent/JP2013531844A/ja
Publication of JP2013531844A5 publication Critical patent/JP2013531844A5/ja
Application granted granted Critical
Publication of JP5826831B2 publication Critical patent/JP5826831B2/ja
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

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/245—Query processing
    • G06F16/2455—Query execution
    • G06F16/24553—Query execution of query operations
    • G06F16/24554—Unary operations; Data partitioning operations
    • G06F16/24556—Aggregation; Duplicate elimination
    • 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/25—Integrating or interfacing systems involving database management systems
    • G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
JP2013512642A 2010-05-27 2011-05-11 データマート自動化 Active JP5826831B2 (ja)

Applications Claiming Priority (5)

Application Number Priority Date Filing Date Title
US34913610P 2010-05-27 2010-05-27
US61/349,136 2010-05-27
US13/100,264 2011-05-03
US13/100,264 US9218408B2 (en) 2010-05-27 2011-05-03 Method for automatically creating a data mart by aggregated data extracted from a business intelligence server
PCT/US2011/036037 WO2011149666A2 (en) 2010-05-27 2011-05-11 Data mart automation

Publications (3)

Publication Number Publication Date
JP2013531844A JP2013531844A (ja) 2013-08-08
JP2013531844A5 JP2013531844A5 (enExample) 2014-04-17
JP5826831B2 true JP5826831B2 (ja) 2015-12-02

Family

ID=44121205

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2013512642A Active JP5826831B2 (ja) 2010-05-27 2011-05-11 データマート自動化

Country Status (5)

Country Link
US (1) US9218408B2 (enExample)
EP (1) EP2577507B1 (enExample)
JP (1) JP5826831B2 (enExample)
CN (1) CN102918530B (enExample)
WO (1) WO2011149666A2 (enExample)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR101769848B1 (ko) * 2015-12-30 2017-08-22 (주)비아이매트릭스 상용 인터프리터를 이용한 스크립트 기반 데이터 처리 시스템

Families Citing this family (22)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10671628B2 (en) * 2010-07-09 2020-06-02 State Street Bank And Trust Company Systems and methods for data warehousing
US10235439B2 (en) * 2010-07-09 2019-03-19 State Street Corporation Systems and methods for data warehousing in private cloud environment
US9507838B2 (en) * 2013-05-17 2016-11-29 Oracle International Corporation Use of projector and selector component types for ETL map design
US10216814B2 (en) * 2013-05-17 2019-02-26 Oracle International Corporation Supporting combination of flow based ETL and entity relationship based ETL
US20150278335A1 (en) * 2014-03-31 2015-10-01 Kofax, Inc. Scalable business process intelligence and predictive analytics for distributed architectures
US9846567B2 (en) 2014-06-16 2017-12-19 International Business Machines Corporation Flash optimized columnar data layout and data access algorithms for big data query engines
US9633058B2 (en) 2014-06-16 2017-04-25 International Business Machines Corporation Predictive placement of columns during creation of a large database
US9922104B1 (en) * 2014-08-13 2018-03-20 Numerify, Inc. Metadata driven code-generated external data feeds
CN104331401B (zh) * 2014-11-25 2017-05-31 中国农业银行股份有限公司 一种翻译方法及系统
US9684699B2 (en) * 2014-12-03 2017-06-20 Sas Institute Inc. System to convert semantic layer metadata to support database conversion
US9773003B2 (en) * 2014-12-09 2017-09-26 Xurmo Technologies Pvt. Ltd. Computer implemented system and method for investigative data analytics
CN104657476A (zh) * 2015-02-16 2015-05-27 百度在线网络技术（北京）有限公司 联机分析处理的方法及系统
JP5847344B1 (ja) * 2015-03-24 2016-01-20 株式会社ギックス データ処理システム、データ処理方法、プログラム及びコンピュータ記憶媒体
US9952808B2 (en) 2015-03-26 2018-04-24 International Business Machines Corporation File system block-level tiering and co-allocation
CN105512198A (zh) * 2015-11-27 2016-04-20 Tcl集团股份有限公司 一种中央服务器的数据转移存储实现方法及系统
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
CN108763282B (zh) * 2018-04-12 2023-04-18 深圳市拓保软件有限公司 基于数据立方体的bi筛选改进算法
CN108804241B (zh) * 2018-05-21 2023-06-02 平安科技（深圳）有限公司 跨平台任务调度方法、系统、计算机设备和存储介质
US20210049192A1 (en) * 2019-08-12 2021-02-18 Rockwell Automation Technologies, Inc. Industrial analytics data query
CN112579563B (zh) * 2020-11-18 2022-01-21 广东电网有限责任公司佛山供电局 一种基于电网大数据的数仓可视化建模系统及方法
CN113191708A (zh) * 2021-04-16 2021-07-30 上海东普信息科技有限公司 物流配送监控方法、装置、设备及存储介质
US12105710B2 (en) * 2022-04-25 2024-10-01 AtScale, Inc. Preferred storage of aggregate data items

Family Cites Families (16)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5024A (en) * 1847-03-20 Steam-cylindee
JPH113354A (ja) 1997-06-13 1999-01-06 Nec Software Ltd データキューブ制御方式
US6178418B1 (en) * 1998-07-28 2001-01-23 Noetix Corporation Distributed data warehouse query and resource management system
US6282544B1 (en) 1999-05-24 2001-08-28 Computer Associates Think, Inc. Method and apparatus for populating multiple data marts in a single aggregation process
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
US6877006B1 (en) * 2000-07-19 2005-04-05 Vasudevan Software, Inc. Multimedia inspection database system (MIDaS) for dynamic run-time data evaluation
US9684703B2 (en) * 2004-04-29 2017-06-20 Precisionpoint Software Limited Method and apparatus for automatically creating a data warehouse and OLAP cube
US7444342B1 (en) 2004-08-06 2008-10-28 Unisys Corporation System for accessing and transforming data, information and data relational rules in a multi-dimensional database
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
US7571192B2 (en) * 2005-06-15 2009-08-04 Oracle International Corporation Methods and apparatus for maintaining consistency during analysis of large data sets
US7580944B2 (en) 2006-07-27 2009-08-25 Yahoo! Inc. Business intelligent architecture system and method
CN101566981A (zh) * 2008-04-24 2009-10-28 长沙创智天马财务软件有限公司 分析处理系统中建立动态虚拟数据仓库的方法
US8943087B2 (en) 2008-07-25 2015-01-27 International Business Machines Corporation Processing data from diverse databases
US7970728B2 (en) * 2008-10-23 2011-06-28 International Business Machines Corporation Dynamically building and populating data marts with data stored in repositories

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR101769848B1 (ko) * 2015-12-30 2017-08-22 (주)비아이매트릭스 상용 인터프리터를 이용한 스크립트 기반 데이터 처리 시스템

Also Published As

Publication number Publication date
CN102918530B (zh) 2016-06-01
JP2013531844A (ja) 2013-08-08
WO2011149666A2 (en) 2011-12-01
US20110295792A1 (en) 2011-12-01
EP2577507A2 (en) 2013-04-10
CN102918530A (zh) 2013-02-06
US9218408B2 (en) 2015-12-22
EP2577507A4 (en) 2017-03-22
WO2011149666A3 (en) 2012-01-19
EP2577507B1 (en) 2019-07-03

Similar Documents

Publication Publication Date Title
JP5826831B2 (ja) データマート自動化
US10545992B2 (en) Accelerator based data integration
US10740396B2 (en) Representing enterprise data in a knowledge graph
US8671084B2 (en) Updating a data warehouse schema based on changes in an observation model
US8655861B2 (en) Query metadata engine
US8712972B2 (en) Query optimization with awareness of limited resource usage
US20140351241A1 (en) Identifying and invoking applications based on data in a knowledge graph
CN103473672A (zh) 企业级数据中心的元数据质量稽核系统、方法及平台
US10565201B2 (en) Query processing management in a database management system
US20140214753A1 (en) Systems and methods for multi-source data-warehousing
CA2896160A1 (en) Systems and methods for multi-source data-warehousing
US11354313B2 (en) Transforming a user-defined table function to a derived table in a database management system
US20050102271A1 (en) Indexes with embedded data
TW200419388A (en) System and method for automatically comparing and recoding difference between bills of material (BOM)
CN117609362A (zh) 一种数据处理方法、装置、计算机设备及存储介质
CN116561114A (zh) 一种基于元数据的管理方法
Kuhn et al. Expert Indexing in Oracle Database 11g
US8316013B2 (en) Programmatic retrieval of tabular data within a cell of a query result
Bog et al. Normalization in a mixed oltp and olap workload scenario
Scholtz et al. The ATDM methodology to support the design and implementation of an enterprise data warehouse
de Ves et al. Data management
Mirković et al. Data mart design for managing IT department in a telecommunications company
Kowal et al. Implementation of data warehouse sap BW in the production company
Wei The Development of Database Technology
Jennings Query Analysis of the Data Warehouse Environment

Legal Events

Date Code Title Description
A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20140225

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20140225

A977 Report on retrieval

Free format text: JAPANESE INTERMEDIATE CODE: A971007

Effective date: 20140910

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20141111

A601 Written request for extension of time

Free format text: JAPANESE INTERMEDIATE CODE: A601

Effective date: 20150210

A601 Written request for extension of time

Free format text: JAPANESE INTERMEDIATE CODE: A601

Effective date: 20150311

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20150413

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: 20151006

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20151014

R150 Certificate of patent or registration of utility model

Ref document number: 5826831

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250