Please use this identifier to cite or link to this item: http://hdl.handle.net/1822/54402

TitleAn ontology for describing ETL patterns behavior
Author(s)Oliveira, Bruno
Belo, Orlando
KeywordsData Warehousing Systems
ETL Conceptual Modeling
ETL Patterns
Domain Specific Language
Ontologies
PL4ETL
ETL Skeletons
Issue date2016
PublisherSCITEPRESS – Science and Technology Publications
Abstract(s)The use of software patterns is a common practice in software design, providing reusable solutions for recurring problems. Patterns represent a general skeleton used to solve common problems, providing a way to share regular practices and reduce the resources needed for implementing software systems. Data warehousing populating processes are a very particular type of software used to migrate data from one or more data sources to a specific data schema used to support decision support activities. The quality of such processes should be guarantee. Otherwise, the final system will deal with data inconsistencies and errors, compromising its suitability to support strategic business decisions. To minimize such problems, we propose a pattern-oriented approach to support ETL lifecycle, from conceptual representation to its execution primitives using a specific commercial tool. An ontology-based meta model it was designed and used for describing patterns internal specification and providing the means to support and enable its configuration and instantiation using a domain specific language.
TypeConference paper
URIhttp://hdl.handle.net/1822/54402
ISBN9789897581939
DOI10.5220/0005974001020109
Peer-Reviewedyes
AccessRestricted access (UMinho)
Appears in Collections:CAlg - Artigos em livros de atas/Papers in proceedings

Files in This Item:
File Description SizeFormat 
2016-CI-DATA-Oliveira&Belo-CRP.pdf
  Restricted access
758,02 kBAdobe PDFView/Open

Partilhe no FacebookPartilhe no TwitterPartilhe no DeliciousPartilhe no LinkedInPartilhe no DiggAdicionar ao Google BookmarksPartilhe no MySpacePartilhe no Orkut
Exporte no formato BibTex mendeley Exporte no formato Endnote Adicione ao seu ORCID