SCIT: A schema change interpretation tool for Dynamic-Schema data warehouses

Research output: Contribution to book/Conference proceedings/Anthology/ReportConference contributionContributedpeer-review

Contributors

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.

Details

Original languageEnglish
Title of host publicationDatabases Theory and Applications
EditorsMuhammad Aamir Cheema, Jianzhong Qi, Mohamed A. Sharaf
PublisherSpringer-Verlag
Pages323-327
Number of pages5
ISBN (electronic)978-3-319-19548-3
ISBN (print)978-3-319-19547-6
Publication statusPublished - 2015
Peer-reviewedYes

Publication series

SeriesLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume9093
ISSN0302-9743

Conference

Title26th Australasian Database Conference, ADC 2015
Duration4 - 7 June 2015
CityMelbourne
CountryAustralia

External IDs

ORCID /0000-0001-8107-2775/work/199215558

Keywords

Research priority areas of TU Dresden

DFG Classification of Subject Areas according to Review Boards

Subject groups, research areas, subject areas according to Destatis