Computer Science – Databases
Scientific paper
2011-08-03
Computer Science
Databases
Masters dissertation, 90 pages, 2004. (Advisor: Marcos Sfair Suny\'e); Masters dissertation, Universidade Federal do Paran\'a,
Scientific paper
Often corporations need tools to improve their decision making in a competitive market. In general, these tools are based on data warehouse platforms to mange and analyze large amounts of data. However, several of these corporations do not have enough resources to buy such platforms because of the high cost. This work is dedicated to a feasibility study of a low cost platform to data warehouse. We consider as a low cost platform the use of open source software like the PostgreSQL database system and the GNU/Linux operational system. We verify the feasibility of this platform by executing two benchmarks that simulate a data warehouse workload. The workload reproduces a multi-user environment with the execution of complex queries, which executes: aggregations, nested sub queries, multi joins, in-line views and more. Considering the results we were able to highlight some problems on the PostgreSQL database system, and discuss improvements in the context of data warehouse.
No associations
LandOfFree
Estudo de Viabilidade de uma Plataforma de Baixo Custo para Data Warehouse does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.
If you have personal experience with Estudo de Viabilidade de uma Plataforma de Baixo Custo para Data Warehouse, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Estudo de Viabilidade de uma Plataforma de Baixo Custo para Data Warehouse will most certainly appreciate the feedback.
Profile ID: LFWR-SCP-O-663351