𝔖 Bobbio Scriptorium
✦   LIBER   ✦

[ACM Press the 5th ACM international workshop - McLean, Virginia, USA (2002.11.08-2002.11.08)] Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP - DOLAP '02 - Conceptual modeling for ETL processes

✍ Scribed by Vassiliadis, Panos; Simitsis, Alkis; Skiadopoulos, Spiros

Book ID
121683685
Publisher
ACM Press
Year
2002
Tongue
English
Weight
461 KB
Category
Article
ISBN-13
9781581135909

No coin nor oath required. For personal study only.

✦ Synopsis

Extraction-Transformation-Loading (ETL) tools are pieces of software responsible for the extraction of data from several sources, their cleansing, customization and insertion into a data warehouse. In this paper, we focus on the problem of the definition of ETL activities and provide formal foundations for their conceptual representation. The proposed conceptual model is (a) customized for the tracing of inter-attribute relationships and the respective ETL activities in the early stages of a data warehouse project; (b) enriched with a 'palette' of a set of frequently used ETL activities, like the assignment of surrogate keys, the check for null values, etc; and (c) constructed in a customizable and extensible manner, so that the designer can enrich it with his own re-occurring patterns for ETL activities.

πŸ“œ SIMILAR VOLUMES

[ACM Press the 5th ACM international wor
[ACM Press the 5th ACM international workshop - McLean, Virginia, USA (2002.11.08-2002.11.08)] Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP - DOLAP '02 - Conceptual modeling for ETL processes
✍ Vassiliadis, Panos; Simitsis, Alkis; Skiadopoulos, Spiros πŸ“‚ Article πŸ“… 2002 πŸ› ACM Press 🌐 English βš– 461 KB

Editor, Dimitri Theodoratos ; Sponsored By The Association For Computing Machinery, Special Interest Groups On Information Retrieval (sigir), Special Interest Group On Management Information Systems (sigmis). Includes Bibliographical References. Also Available On The World Wide Web Via Acm Digital L

[ACM Press the 5th ACM international wor
[ACM Press the 5th ACM international workshop - McLean, Virginia, USA (2002.11.08-2002.11.08)] Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP - DOLAP '02 - Constructing an OLAP cube from distributed XML data
✍ Niemi, Tapio; NiinimΓ€ki, Marko; Nummenmaa, Jyrki; Thanisch, Peter πŸ“‚ Article πŸ“… 2002 πŸ› ACM Press 🌐 English βš– 195 KB

Editor, Dimitri Theodoratos ; Sponsored By The Association For Computing Machinery, Special Interest Groups On Information Retrieval (sigir), Special Interest Group On Management Information Systems (sigmis). Includes Bibliographical References. Also Available On The World Wide Web Via Acm Digital L

[ACM Press the 5th ACM international wor
[ACM Press the 5th ACM international workshop - McLean, Virginia, USA (2002.11.08-2002.11.08)] Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP - DOLAP '02 - Constructing an OLAP cube from distributed XML data
✍ Niemi, Tapio; NiinimΓ€ki, Marko; Nummenmaa, Jyrki; Thanisch, Peter πŸ“‚ Article πŸ“… 2002 πŸ› ACM Press 🌐 English βš– 195 KB

Editor, Dimitri Theodoratos ; Sponsored By The Association For Computing Machinery, Special Interest Groups On Information Retrieval (sigir), Special Interest Group On Management Information Systems (sigmis). Includes Bibliographical References. Also Available On The World Wide Web Via Acm Digital L

[ACM Press the 9th ACM international wor
[ACM Press the 9th ACM international workshop - Arlington, Virginia, USA (2006.11.10-2006.11.10)] Proceedings of the 9th ACM international workshop on Data warehousing and OLAP - DOLAP '06 - Towards a logical multidimensional model for spatial data warehousing and OLAP
✍ Sampaio, Marcus Costa; de Sousa, AndrΓ© Gomes; Baptista, ClΓ‘udio de Souza πŸ“‚ Article πŸ“… 2006 πŸ› ACM Press βš– 585 KB

Decision support systems (DSS) may be enhanced qualitatively if they are able to also deal with spatial dimensions and measures. Regardless the evident importance of using data warehousing and OLAP in DSS, the incorporation of spatial dimensions and measures enables to locate more efficiently tenden