Facilitating the Interaction with Data Warehouse Schemas through a Visual Web-Based Approach

Clemente R. Borges1 and José A. Macías1

  1. Escuela Politécnica Superior, Universidad Autónoma de Madrid
    Francisco Tomás y Valiente 11. 28049 Madrid, Spain
    {clemente.borges, j.macias}@uam.es


In most respects, there are implicit drawbacks concerning representation and interaction with data in relational-database applications. On the one hand, there is a lack of expressiveness and ease of use in the user interfaces that handle such data. On the other hand, there is an implicit need for interactive end-user visual tools to query data and avoid dependency on programming languages. The main aim of this work is to study the problem of database interaction and usability, comparing existing solutions and providing a new approach that overcomes existing problems. We propose a web-based tool that manipulates Data Warehouse schemas by using a visual language to represent the database structure and providing several visualization techniques that facilitate the interaction and creation of queries involving different levels of complexity. We based our research on an End-User Development approach that has been evaluated to obtain some initial usability indicators.

Key words

Human-Computer Interaction, User-Centered Design, Usability, User Interface for Data Warehouse

Digital Object Identifier (DOI)


Publication information

Volume 11, Issue 2 (June 2014)
Year of Publication: 2014
ISSN: 1820-0214 (Print) 2406-1018 (Online)
Publisher: ComSIS Consortium

Full text

DownloadAvailable in PDF
Portable Document Format

How to cite

Borges, C. R., Macías, J. A.: Facilitating the Interaction with Data Warehouse Schemas through a Visual Web-Based Approach. Computer Science and Information Systems, Vol. 11, No. 2, 481-501. (2014), https://doi.org/10.2298/CSIS131130032B