Facilitating the interaction with data warehouse schemas through a visual web-based approach

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 in...

ver descrição completa

Detalhes bibliográficos
Autores: Borges, Clemente R., Macías Iglesias, José Antonio
Tipo de documento: artigo
Data de publicação:2014
País:España
Recursos:Universidad Autónoma de Madrid
Repositório:Biblos-e Archivo. Repositorio Institucional de la UAM
Idioma:inglês
OAI Identifier:oai:repositorio.uam.es:10486/664099
Acesso em linha:http://hdl.handle.net/10486/664099
https://dx.doi.org/10.2298/CSIS131130032B
Access Level:Acceso aberto
Palavra-chave:Human-computer interaction
Usability
User interface for data warehouse
User-centered design
Informática
Descrição
Resumo: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.