Dimensional Templates in Data Warehouses: Automating the Multidimensional Design of Data Warehouse Prototypes

Oliveira, Rui; Rodrigues, Fátima; Martins, Paulo; Moura, João Paulo

http://hdl.handle.net/10400.8/12780

Use this identifier to reference this record.

Name:	Description:	Size:	Format:
Dimensional templates in data warehouses Automating the multidimensional design of data warehouse prototypes.pdf	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.	271.1 KB	Adobe PDF	Download

Send Feedback

Authors

Abstract(s)

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.

Description

11th International Conference on Enterprise Information Systems, ICEIS 2009 Oliveira, Rui - Scopus ID: 54888456700

Keywords

Data Warehouse Automated Multidimensional Design Dimensional Templates Prototype Development

URI

http://hdl.handle.net/10400.8/12780

Citation

Oliveira, R., Rodrigues, F., Martins, P., Moura, J.P. (2009). Dimensional Templates in Data Warehouses: Automating the Multidimensional Design of Data Warehouse Prototypes. In: Filipe, J., Cordeiro, J. (eds) Enterprise Information Systems. ICEIS 2009. Lecture Notes in Business Information Processing, vol 24. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-01347-8_16.