CN102918530B - 数据集市自动化 - Google Patents

数据集市自动化 Download PDF

Info

Publication number
CN102918530B
CN102918530B CN201180026123.7A CN201180026123A CN102918530B CN 102918530 B CN102918530 B CN 102918530B CN 201180026123 A CN201180026123 A CN 201180026123A CN 102918530 B CN102918530 B CN 102918530B
Authority
CN
China
Prior art keywords
data
data source
business intelligence
gathering
rank
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
CN201180026123.7A
Other languages
English (en)
Chinese (zh)
Other versions
CN102918530A (zh
Inventor
A·玛斯卡恩哈斯
H·潘
A·桑坦姆
R·文卡塔苏伯拉玛尼安
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.)
Oracle International Corp
Original Assignee
Oracle International 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 Oracle International Corp filed Critical Oracle International Corp
Publication of CN102918530A publication Critical patent/CN102918530A/zh
Application granted granted Critical
Publication of CN102918530B publication Critical patent/CN102918530B/zh
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)
CN201180026123.7A 2010-05-27 2011-05-11 数据集市自动化 Active CN102918530B (zh)

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

Publication Number Publication Date
CN102918530A CN102918530A (zh) 2013-02-06
CN102918530B true CN102918530B (zh) 2016-06-01

Family

ID=44121205

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201180026123.7A Active CN102918530B (zh) 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)

Families Citing this family (23)

* 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集团股份有限公司 一种中央服务器的数据转移存储实现方法及系统
KR101769848B1 (ko) * 2015-12-30 2017-08-22 (주)비아이매트릭스 상용 인터프리터를 이용한 스크립트 기반 데이터 처리 시스템
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

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1384939A (zh) * 1999-05-24 2002-12-11 计算机合伙思维有限公司 用于在单聚集过程中载入多数据集市的方法和装置
US6877006B1 (en) * 2000-07-19 2005-04-05 Vasudevan Software, Inc. Multimedia inspection database system (MIDaS) for dynamic run-time data evaluation
US20050246357A1 (en) * 2004-04-29 2005-11-03 Analysoft Development Ltd. Method and apparatus for automatically creating a data warehouse and OLAP cube
US20100023496A1 (en) * 2008-07-25 2010-01-28 International Business Machines Corporation Processing data from diverse databases

Family Cites Families (12)

* 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
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
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 长沙创智天马财务软件有限公司 分析处理系统中建立动态虚拟数据仓库的方法
US7970728B2 (en) * 2008-10-23 2011-06-28 International Business Machines Corporation Dynamically building and populating data marts with data stored in repositories

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1384939A (zh) * 1999-05-24 2002-12-11 计算机合伙思维有限公司 用于在单聚集过程中载入多数据集市的方法和装置
US6877006B1 (en) * 2000-07-19 2005-04-05 Vasudevan Software, Inc. Multimedia inspection database system (MIDaS) for dynamic run-time data evaluation
US20050246357A1 (en) * 2004-04-29 2005-11-03 Analysoft Development Ltd. Method and apparatus for automatically creating a data warehouse and OLAP cube
US20100023496A1 (en) * 2008-07-25 2010-01-28 International Business Machines Corporation Processing data from diverse databases

Also Published As

Publication number Publication date
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
JP5826831B2 (ja) 2015-12-02
EP2577507A4 (en) 2017-03-22
WO2011149666A3 (en) 2012-01-19
EP2577507B1 (en) 2019-07-03

Similar Documents

Publication Publication Date Title
CN102918530B (zh) 数据集市自动化
US11874839B2 (en) Adaptive big data service
US9619549B2 (en) Reporting and summarizing metrics in sparse relationships on an OLTP database
US8156107B2 (en) System and method for join-partitioning for local computability of query over shared-nothing clusters
US8326857B2 (en) Systems and methods for providing value hierarchies, ragged hierarchies and skip-level hierarchies in a business intelligence server
US9892178B2 (en) Systems and methods for interest-driven business intelligence systems including event-oriented data
EP3740880A1 (en) Pick and applicator for use with a stringed instrument
US20150026154A1 (en) Processing Database Queries Using Format Conversion
US20040015486A1 (en) System and method for storing and retrieving data
US20080172354A1 (en) Apparatus, system, and method for performing fast approximate computation of statistics on query expressions
US20140351241A1 (en) Identifying and invoking applications based on data in a knowledge graph
US20150081353A1 (en) Systems and Methods for Interest-Driven Business Intelligence Systems Including Segment Data
CN104823185A (zh) 用于兴趣驱动的商业智能系统中的兴趣驱动的数据共享的系统和方法
Kuhn et al. Expert Oracle Indexing and Access Paths: Maximum Performance for Your Database
CN104081397A (zh) 创建归档模型
US20180018372A1 (en) Semantic tagging of nodes
US20160330280A1 (en) Distributed tagging of data in a hybrid cloud environment
US20160379148A1 (en) System and Methods for Interest-Driven Business Intelligence Systems with Enhanced Data Pipelines
US20050102271A1 (en) Indexes with embedded data
Kuhn et al. Expert Indexing in Oracle Database 11g
CN116561114A (zh) 一种基于元数据的管理方法
CN114298525A (zh) 一种数据库风险评估方法及装置
Wiselka Development of Modern Data Platform using Medallion Architecture
Bog et al. Normalization in a mixed oltp and olap workload scenario
Bog Enterprise Data Management for Transaction and Analytical Processing

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