umu.sePublications
Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
Data discovery method for Extract-Transform-Load
School of Science, Aalto University, Espoo, Finland.ORCID iD: 0000-0002-8078-5172
2019 (English)In: 2019 IEEE 10th International Conference on Mechanical and Intelligent Manufacturing Technologies (ICMIMT), IEEE, 2019, p. 174-181Conference paper, Published paper (Refereed)
Abstract [en]

Information Systems (ISs) are fundamental to streamline operations and support processes of any modern enterprise. Being able to perform analytics over the data managed in various enterprise ISs is becoming increasingly important for organisational growth. Extract, Transform, and Load (ETL) are the necessary pre-processing steps of any data mining activity. Due to the complexity of modern IS, extracting data is becoming increasingly complicated and time-consuming. In order to ease the process, this paper proposes a methodology and a pilot implementation, that aims to simplify data extraction process by leveraging the end-users' knowledge and understanding of the specific IS. This paper first provides a brief introduction and the current state of the art regarding existing ETL process and techniques. Then, it explains in details the proposed methodology. Finally, test results of typical data-extraction tasks from four commercial ISs are reported.

Place, publisher, year, edition, pages
IEEE, 2019. p. 174-181
Keywords [en]
ETL, Database, Trigger, Reverse Engineering, Data Warehouse, Information System, Information Retrieval, Process Mapping, Data Discovery
National Category
Information Systems
Research subject
Computer Science
Identifiers
URN: urn:nbn:se:umu:diva-160141DOI: 10.1109/ICMIMT.2019.8712027Scopus ID: 2-s2.0-85066473340ISBN: 978-1-5386-7972-2 (electronic)OAI: oai:DiVA.org:umu-160141DiVA, id: diva2:1324437
Conference
2019 IEEE 10th International Conference on Mechanical and Intelligent Manufacturing Technologies (ICMIMT 2019), Cape Town, South Africa, 15–17 February, 2019
Available from: 2019-06-13 Created: 2019-06-13 Last updated: 2019-06-18Bibliographically approved

Open Access in DiVA

No full text in DiVA

Other links

Publisher's full textScopus

Authority records BETA

Främling, Kary

Search in DiVA

By author/editor
Främling, Kary
Information Systems

Search outside of DiVA

GoogleGoogle Scholar

doi
isbn
urn-nbn

Altmetric score

doi
isbn
urn-nbn
Total: 31 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf