NDLI: Using REO on ETL conceptual modelling: a first approach

Please wait, while we are loading the content...

Revisiting aggregation techniques for big data

CineCubes: cubes as movie stars with little effort

Extended dimensions for cleaning and querying inconsistent data warehouses

Data warehousing and OLAP over big data: current challenges and future research directions

Clustering cubes with binary dimensions in one pass

Meta-stars: multidimensional modeling for social business intelligence

Slowly changing measures

Optimizing OLAP cube processing on solid state drives

Social microblogging cube

Using REO on ETL conceptual modelling: a first approach

Can we analyze big data inside a DBMS?

CXT-cube: contextual text cube model and aggregation operator for text OLAP

ProtOLAP: rapid OLAP prototyping with on-demand data supply

INDREX: in-database distributional relation extraction

Lazy data structure maintenance for main-memory analytics over sliding windows

Using REO on ETL conceptual modelling: a first approach

Content Provider	ACM Digital Library
Author	Belo, Orlando Oliveira, Bruno
Abstract	The formalization of software patterns has proven to be very useful in software developing, improving systems communication, data interchange across platforms, and simplifying the integration of processes and data flows. Populating a data warehouse (ETL) is often a very complex task demanding significant computational resources. It faces many drawbacks during its design and implementation, involving not only large volumes of data that must be processed but also undesirable change of business requirements. All of this leads frequently to reuse significant parts of other ETL implementations, adapting data structures and processes to comply with new requirements. Additionally, we believe that it's necessary a more simply and reliable approach for ETL conceptual modelling covering the "lack of mature" of this important part of ETL development. In this paper we explored a new approach to ETL conceptual modelling using the Reo coordination language, trying to evaluate its adequacy and expressiveness on the coordination of ETL tasks. A pattern-based approach was designed to map typical operations used in real world ETL scenarios from an initial Reo specification. For demonstration purposes, we present and discuss as two case studies, a slowly changing dimension and a surrogated key pipelining processes.
Starting Page	55
Ending Page	60
Page Count	6
File Format	PDF
ISBN	9781450324120
DOI	10.1145/2513190.2513202
Language	English
Publisher	Association for Computing Machinery (ACM)
Publisher Date	2013-10-28
Publisher Place	New York
Access Restriction	Subscribed
Subject Keyword	Reo specification Etl patterns Etl conceptual modelling
Content Type	Text
Resource Type	Article

Central Library (ISO-9001:2015 Certified)
Indian Institute of Technology Kharagpur
Kharagpur, West Bengal, India | PIN - 721302

See location in the Map
03222 282435
Mail: support@ndl.gov.in

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in