GB2522524A - Extract, transform and load (ETL) system and method - Google Patents

Extract, transform and load (ETL) system and method Download PDF

Info

Publication number
GB2522524A
GB2522524A GB1421177.5A GB201421177A GB2522524A GB 2522524 A GB2522524 A GB 2522524A GB 201421177 A GB201421177 A GB 201421177A GB 2522524 A GB2522524 A GB 2522524A
Authority
GB
United Kingdom
Prior art keywords
data
query
transactional data
source
transactional
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.)
Withdrawn
Application number
GB1421177.5A
Other languages
English (en)
Other versions
GB201421177D0 (en
Inventor
Krishna Kumar Mehra
Prasun Kumar
Pravanjan Choudhury
L L Abhilash
Sudipta Samanta
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.)
Capillary Technologies International Pte Ltd
Original Assignee
Capillary Technologies International Pte Ltd
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 Capillary Technologies International Pte Ltd filed Critical Capillary Technologies International Pte Ltd
Publication of GB201421177D0 publication Critical patent/GB201421177D0/en
Publication of GB2522524A publication Critical patent/GB2522524A/en
Withdrawn legal-status Critical Current

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/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
    • 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/242—Query formulation
    • 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

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
GB1421177.5A 2013-12-27 2014-11-28 Extract, transform and load (ETL) system and method Withdrawn GB2522524A (en)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
IN6122CH2013 IN2013CH06122A (https=) 2013-12-27 2013-12-27

Publications (2)

Publication Number Publication Date
GB201421177D0 GB201421177D0 (en) 2015-01-14
GB2522524A true GB2522524A (en) 2015-07-29

Family

ID=53482026

Family Applications (1)

Application Number Title Priority Date Filing Date
GB1421177.5A Withdrawn GB2522524A (en) 2013-12-27 2014-11-28 Extract, transform and load (ETL) system and method

Country Status (5)

Country Link
US (1) US9633095B2 (https=)
AU (1) AU2014271289A1 (https=)
GB (1) GB2522524A (https=)
IN (1) IN2013CH06122A (https=)
SG (1) SG10201408350RA (https=)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107908778A (zh) * 2017-12-04 2018-04-13 杭州华量软件有限公司 一种智慧商场大数据管理系统

Families Citing this family (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9226217B2 (en) * 2014-04-17 2015-12-29 Twilio, Inc. System and method for enabling multi-modal communication
US20170270585A1 (en) * 2016-02-11 2017-09-21 Darren Lewis Method for Mitigating Perishable Product Loss
CN109299177A (zh) * 2018-09-30 2019-02-01 江苏满运软件科技有限公司 数据抽取方法、装置、存储介质及电子设备
US11803798B2 (en) 2019-04-18 2023-10-31 Oracle International Corporation System and method for automatic generation of extract, transform, load (ETL) asserts
US12248490B2 (en) 2019-04-18 2025-03-11 Oracle International Corporation System and method for ranking of database tables for use with extract, transform, load processes
EP3963473A1 (en) 2019-04-30 2022-03-09 Oracle International Corporation System and method for data analytics with an analytic applications environment
US11294926B1 (en) * 2019-05-31 2022-04-05 Facteus, Inc. Master extract, transform, and load (ETL) application for accommodating multiple data source types having disparate data formats
US12153595B2 (en) * 2019-07-04 2024-11-26 Oracle International Corporation System and method for data pipeline optimization in an analytic applications environment
CN111666326B (zh) * 2020-05-29 2023-03-14 中国工商银行股份有限公司 Etl调度方法及装置
WO2022046049A1 (en) * 2020-08-26 2022-03-03 University Of Pittsburgh - Of The Commonwealth System Of Higher Education Search engine for concatenating and searching combinations of data files
CN116186141A (zh) * 2023-02-24 2023-05-30 杭州太美星程医药科技有限公司 数据处理方法、装置、介质和设备

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7321939B1 (en) * 2003-06-27 2008-01-22 Embarq Holdings Company Llc Enhanced distributed extract, transform and load (ETL) computer method
US9411864B2 (en) * 2008-08-26 2016-08-09 Zeewise, Inc. Systems and methods for collection and consolidation of heterogeneous remote business data using dynamic data handling

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
None *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107908778A (zh) * 2017-12-04 2018-04-13 杭州华量软件有限公司 一种智慧商场大数据管理系统

Also Published As

Publication number Publication date
US9633095B2 (en) 2017-04-25
IN2013CH06122A (https=) 2015-07-03
GB201421177D0 (en) 2015-01-14
SG10201408350RA (en) 2015-07-30
US20150186481A1 (en) 2015-07-02
AU2014271289A1 (en) 2015-07-16

Similar Documents

Publication Publication Date Title
US9633095B2 (en) Extract, transform and load (ETL) system and method
US9218408B2 (en) Method for automatically creating a data mart by aggregated data extracted from a business intelligence server
CN107533570B (zh) 用于从表格数据自动推断立方体模式的系统和方法
US6847973B2 (en) Method of managing slowly changing dimensions
US20090055439A1 (en) Flexible Dimension Approach In A Data Warehouse
US20030195889A1 (en) Unified relational database model for data mining
US20110119300A1 (en) Method Of Generating An Analytical Data Set For Input Into An Analytical Model
AU2010213346A1 (en) Creation of a data store
US20120150905A1 (en) Concerted Coordination of Multidimensional Scorecards
US9110935B2 (en) Generate in-memory views from universe schema
CN111008235A (zh) 一种基于Spark的小文件合并方法及系统
US7970735B2 (en) Cross varying dimension support for analysis services engine
CN119256293A (zh) 数据流图数据集
CN107463695A (zh) 一种数据存储的方法及装置
CN104166739B (zh) 分析数据库的指标文件处理方法及装置
Bellatreche Dimension table selection strategies to referential partition a fact table of relational data warehouses
Lake et al. A history of databases
Anagha et al. Design and Development of Data Warehousing for Bookstore Using Pentaho BI Tools
Musunuru et al. Improving Lives Through Donation Analysis
KR20170071283A (ko) Hive 기반의 빅 데이터 분석 시스템 및 이의 동작 방법
Bog Enterprise data management for transaction and analytical processing
Marques Presenting Business Insights on Advanced Pricing Agreements Using a Business Intelligence Framework
Zhang Efficient Structure-aware OLAP Query Processing over Large Property Graphs
Jeevangekar et al. Design and Implementation of a NoSQL Database for Decision Support in R&D Management
Kamagate OLAP–Online Analytical Processing

Legal Events

Date Code Title Description
WAP Application withdrawn, taken to be withdrawn or refused ** after publication under section 16(1)