|
| << vorige | volgende >> |
Tijdschrift beschrijving
Alle jaargangen van het bijbehorende tijdschrift
Alle afleveringen van het bijbehorende jaargang
Alle artikelen van de bijbehorende aflevering
Details van artikel 76 van 127 gevonden artikelen
| Titel: |
Ideal Strategy to Improve Datawarehouse Performance |
| Auteur: |
Fahad Sultan Dr. Abdul Aziz |
| Verschenen in: |
International journal on computer science and engineering |
| Paginering: | Jaargang 2 (2010) nr. 2 pagina's 409-415 |
| Jaar: |
2010 |
| Inhoud: |
Data warehouse is set up for the benefits of business analysts and executives across all functional areas. The primary goal of data warehouse is to free the information locked up in the operational database so that decision makers and business analyst can make queries, analysis and planning regardless of the data changes inoperational database. Data analysis in a large database requires some innovative techniques; there should be some new methods and procedures to look at the data with different angles. While executing adhoc queries over a large database degrade the query performance atconsiderable level because query will have to go through from large volume of data after making lot of joins. Moreover, as the number of queries is large, therefore, in certain cases there is reasonable probability that same query submitted by the one or multiple users at different times. Each time when query is executed, all the data ofwarehouse is analyzed to generate the result of that query. In this paper we purpose an ideal approach which definitely minimizes esponse time and improves the efficiency of data warehouse overall, articularly when data warehouse is updated at regular interval. Thisapproach has been validated by Formal Method. |
| Uitgever: |
Engg Journals Publications (provided by DOAJ) |
| Bronbestand: |
Elektronische Wetenschappelijke Tijdschriften |
Details van artikel 76 van 127 gevonden artikelen
| << vorige | volgende >> |