Denormalisation : Towards Improved Performance
| Autor: | Manas Kumar Rath, Sunil Kumar Mishra |
|---|---|
| Jazyk: | angličtina |
| Rok vydání: | 2012 |
| Předmět: | |
| Zdroj: | Srusti Management Review, Vol V, Iss II, Pp 145-152 (2012) |
| Druh dokumentu: | article |
| ISSN: | 0974-4274 2582-1148 |
| Popis: | In this paper, we present a practical view of denormalization, and provide fundamental guidelines for incorporating denormalization. We have suggested use of denormalization as an intermediate step between logical and physical modeling, to be used as an analytic procedure for the design of the applications requirements criteria. Relational algebra and query trees are used to examine the effect on the performance of relational systems. The guidelines and methodology presented are sufficiently general, and they can be applicable to most databases. It is concluded that denormalization can enhance query performance when it is deployed with a complete understanding of application requirements. |
| Databáze: | Directory of Open Access Journals |
| Externí odkaz: |
|