TY  - JOUR
T1  - ESCM: Entity-Subject Conceptual Modeling for Data Warehouse
AU - Pasha, M. A. AU - Shahzad, M. K. AU - Nasir, J.A. 
JO  - Asian Journal of Information Technology
VL  - 4
IS  - 11
SP  - 1093
EP  - 1097
PY  - 2005
DA  - 2001/08/19
SN  - 1682-3915
DO  - ajit.2005.1093.1097
UR  - https://makhillpublications.co/view-article.php?doi=ajit.2005.1093.1097
KW  - modeling
KW  -dimensions
KW  -facts
KW  -analytical entities
KW  -transactional entities
KW  -semi-Star
KW  -Data warehouse
KW  -content changes
KW  -schema changes
AB  - Traditional Data Warehousing systems have static structure of their schemas and relationships between data; therefore they are not able to support any dynamics in their source structure and contents, consequent inconsistent analytical results. A novel modeling technique Semi-Star Schema was proposed to accommodate such dynamics. Multiple attempts have been made for conceptual modeling of star-oriented schemas of data warehouse but not for Semi-Star Schema. In this study we squabble that, in order to accurately reflect analytical business requirements into an error-free, understandable and easily extendable data warehouse schema our proposed conceptual model namely Entity-Subject Conceptual Model (ESCM) should be used. Which is (a) capable of interpreting business analytical requirements into abstraction (b) customized for tracing inter-attributes, entities, facts and dimension relationships. (c) formal and complete, so that it can be transformed into next logical schema with out ambiguities. (d) constructed in a customizable and extensible manner, so that the designer can enrich it.
ER  -