Skip to content. | Skip to navigation

Informatik 5
Information Systems
Prof. Dr. M. Jarke
Personal tools
You are here: Home Publications SCIT: A Schema Change Interpretation Tool for Dynamic-Schema Data Warehouses


Prof. Dr. M. Jarke
RWTH Aachen
Informatik 5
Ahornstr. 55
D-52056 Aachen
Tel +49/241/8021501
Fax +49/241/8022321

How to find us

Annual Reports





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

Year 2015
Abstract URL view
PDF File download
ISBN-13 978-3-319-19547-6

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.


26th Australasian Database Conference, ADC 2015, Melbourne, VIC, Australia, June 4-7, 2015. Proceedings


  • Rihan Hai
  • Vasileios Theodorou
  • Maik Thiele
  • Wolfgang Lehner

Presented at

26th Australasian Database Conference, 2015 , Melbourne , AT.

Published in

Databases Theory and Applications , by Mohamed A. Sharaf, Muhammad Aamir Cheema, Jianzhong Qi , p. 323-327 ; Springer International Publishing , CH .

Document Actions