Repository logo

Browsing by Author "Oliveira, Rui"

Now showing 1 - 2 of 2
  • Dimensional Templates in Data Warehouses: Automating the Multidimensional Design of Data Warehouse Prototypes
    Publication . Oliveira, Rui; Rodrigues, Fátima; Martins, Paulo; Moura, João Paulo
    Prototypes are valuable tools in Data Warehouse (DW) projects. DW prototypes can help end-users to get an accurate preview of a future DW system, along with its advantages and constraints. However, DW prototypes have considerably smaller development time windows when compared to complete DW projects. This puts additional pressure on the achievement of the expected prototypes' high quality standards, especially at the highly time consuming multidimensional design: in it, a thin margin for harmful unreflected decisions exists. Some devised methods for automating DW multidimensional design can be used to accelerate this stage, yet they are more suitable to DW full projects rather than to prototypes, due to the effort, cost and expertise they require. This paper proposes the semi-automation of DW multidimensional designs using templates. We believe this approach better fits the development speed and cost constraints of DW prototyping since templates are pre-built highly adaptable and highly reusable solutions.
    2009-05Conference paper Open access Show more
  • ETL^2 - Educational tool for learning ETL
    Publication . Oliveira, Rui; Ramos, Jose
    In Data Warehouse environments, the core Extract-Transform-Load (ETL) process is the most technically complex and sensitive of all: promoting its effective learning to undergraduate students is therefore a serious challenge. Despite today's industrial widespread use of ETL graphical tools, these do not comply with the needs of ETL teaching given their usage complexity and high abstraction level. Moreover, no educational tools exist focused on assisting ETL teaching. For that purpose, the paper presents an innovative educational tool. The tool's basic yet powerful features allow students to easily test concepts and also to build real-world Data Warehouse prototypes in a fast and simple fashion keeping focus on the product conceptualization without severely abstracting themselves from the background mechanisms of the ETL process. The tool has evolved in the past five years in the Decision Support Systems course of the Informatics Engineering undergraduate degree at the Polytechnic Institute of Leiria. © 2015 IEEE.
    2015-06Conference paper Restricted access Show more