International Journal of Advances in Computer Science and Its Applications
Author(s) : ROLIANA IBRAHIM , MUNAWAR , NAOMIE SALIM
To make an effective data warehouse logical design which is related to system performance, it is important to manage an appropriate methodology for data fragmentation, indexing and materialized view. Executing a query in a data warehouse may take hours or days to run without the proper optimization technique. This paper proposed a framework on integrating quality, deliverables in conceptual design as an input into the logical design, and the optimization technique to run query, to treat as continuous improvement from preceeding stage.