Solutions for improving data extraction from virtual data warehouses
Journal Title: Database Systems Journal - Year 2010, Vol 1, Issue 1
Abstract
The data warehousing project’s team is always confronted with low performance in data extraction. In a Business Intelligence environment this problem can be critical because the data displayed are no longer available for taking decisions, so the project can be compromised. In this case there are several techniques that can be applied to reduce queries’ execution time and to improve the performance of the BI analyses and reports. Some of the techniques that can be applied to reduce the cost of execution for improving query performance in BI systems will be presented in this paper.
Authors and Affiliations
Adela BÂRA
Keywords
Related Articles
- EP ID EP108095
- DOI -
- Views 148
- Downloads 0
Solutions for improving data extraction from virtual data warehouses
The data warehousing project’s team is always confronted with low performance in data extraction. In a Business Intelligence environment this problem can be critical because the data displayed are no longer available for...
Problem Decomposition Method to Compute an Optimal Cover for a Set of Functional Dependencies
The paper proposes a problem decomposition method for building optimal cover for a set of functional dependencies to decrease the solving time. At the beginning, the paper includes an overview of the covers of func...
A Framework for Semi-Automated Implementation of Multidimensional Data Models
Data warehousing solution development represents a challenging task which requires the employment of considerable resources on behalf of enterprises and sustained commitment from the stakeholders. Costs derive mostly fro...
Clustering Analysis for Credit Default Probabilities in a Retail Bank Portfolio
Methods underlying cluster analysis are very useful in data analysis, especially when the processed volume of data is very large, so that it becomes impossible to extract essential information, unless specific instrument...
Cloud Computing and Smart Grids
Increasing concern about energy consumption is leading to infrastructure that supports real-time, two-way communication between utilities and consumers, and allows software systems at both ends to control and manage powe...