SCIT: A Schema Change Interpretation Tool for Dynamic-Schema Data Warehouses

Rihan Hai; Vasileios Theodorou; Maik Thiele; Wolfgang Lehner

doi:10.1007/978-3-319-19548-3_28

SCIT: A Schema Change Interpretation Tool for Dynamic-Schema Data Warehouses

Rihan Hai, Vasileios Theodorou, Maik Thiele, Wolfgang Lehner

Research output: Chapter in Book/Conference proceedings/Edited volume › Conference contribution › Scientific › peer-review

Abstract

Data Warehouses (DW) have to continuously adapt to evolving business requirements, which implies structure modification (schema changes) and data migration requirements in the system design. However, it is challenging for designers to control the performance and cost overhead of different schema change implementations. In this paper, we demonstrate SCIT, a tool for DW designers to test and implement different logical design alternatives in a two-fold manner. As a main functionality, SCIT translates common DW schema modifications into directly executable SQL scripts for relational database systems, facilitating design and testing automation. At the same time, SCIT assesses changes and recommends alternative design decisions to help designers improve logical designs and avoid common dimensional modeling pitfalls and mistakes. This paper serves as a walk-through of the system features, showcasing the interaction with the tool’s user interface in order to easily and effectively modify DW schemata and enable schema change analysis.

Original language	English
Title of host publication	Proceedings of the 26th Australasian Database Conference, ADC 2015
Pages	323-327
Number of pages	5
ISBN (Electronic)	978-3-319-19548-3
DOIs	https://doi.org/10.1007/978-3-319-19548-3_28
Publication status	Published - 2015
Externally published	Yes

Access to Document

10.1007/978-3-319-19548-3_28

Cite this

@inproceedings{84f1872fbb5540ffaa97bc20cbad3372,

title = "SCIT: A Schema Change Interpretation Tool for Dynamic-Schema Data Warehouses",

abstract = "Data Warehouses (DW) have to continuously adapt to evolving business requirements, which implies structure modification (schema changes) and data migration requirements in the system design. However, it is challenging for designers to control the performance and cost overhead of different schema change implementations. In this paper, we demonstrate SCIT, a tool for DW designers to test and implement different logical design alternatives in a two-fold manner. As a main functionality, SCIT translates common DW schema modifications into directly executable SQL scripts for relational database systems, facilitating design and testing automation. At the same time, SCIT assesses changes and recommends alternative design decisions to help designers improve logical designs and avoid common dimensional modeling pitfalls and mistakes. This paper serves as a walk-through of the system features, showcasing the interaction with the tool{\textquoteright}s user interface in order to easily and effectively modify DW schemata and enable schema change analysis.",

author = "Rihan Hai and Vasileios Theodorou and Maik Thiele and Wolfgang Lehner",

year = "2015",

doi = "10.1007/978-3-319-19548-3_28",

language = "English",

pages = "323--327",

booktitle = "Proceedings of the 26th Australasian Database Conference, ADC 2015",

}

TY - GEN

T1 - SCIT: A Schema Change Interpretation Tool for Dynamic-Schema Data Warehouses

AU - Hai, Rihan

AU - Theodorou, Vasileios

AU - Thiele, Maik

AU - Lehner, Wolfgang

PY - 2015

Y1 - 2015

N2 - Data Warehouses (DW) have to continuously adapt to evolving business requirements, which implies structure modification (schema changes) and data migration requirements in the system design. However, it is challenging for designers to control the performance and cost overhead of different schema change implementations. In this paper, we demonstrate SCIT, a tool for DW designers to test and implement different logical design alternatives in a two-fold manner. As a main functionality, SCIT translates common DW schema modifications into directly executable SQL scripts for relational database systems, facilitating design and testing automation. At the same time, SCIT assesses changes and recommends alternative design decisions to help designers improve logical designs and avoid common dimensional modeling pitfalls and mistakes. This paper serves as a walk-through of the system features, showcasing the interaction with the tool’s user interface in order to easily and effectively modify DW schemata and enable schema change analysis.

AB - Data Warehouses (DW) have to continuously adapt to evolving business requirements, which implies structure modification (schema changes) and data migration requirements in the system design. However, it is challenging for designers to control the performance and cost overhead of different schema change implementations. In this paper, we demonstrate SCIT, a tool for DW designers to test and implement different logical design alternatives in a two-fold manner. As a main functionality, SCIT translates common DW schema modifications into directly executable SQL scripts for relational database systems, facilitating design and testing automation. At the same time, SCIT assesses changes and recommends alternative design decisions to help designers improve logical designs and avoid common dimensional modeling pitfalls and mistakes. This paper serves as a walk-through of the system features, showcasing the interaction with the tool’s user interface in order to easily and effectively modify DW schemata and enable schema change analysis.

U2 - 10.1007/978-3-319-19548-3_28

DO - 10.1007/978-3-319-19548-3_28

M3 - Conference contribution

SP - 323

EP - 327

BT - Proceedings of the 26th Australasian Database Conference, ADC 2015

ER -

SCIT: A Schema Change Interpretation Tool for Dynamic-Schema Data Warehouses

Abstract

Access to Document

Fingerprint

Cite this