M. A.  Pasha, M. K.  Shahzad, J.A.  Nasir, 
    ESCM: Entity-Subject Conceptual Modeling for Data Warehouse,
    Asian Journal of Information Technology,
    Volume 4,Issue 11,
    2005,
    Pages 1093-1097,
    ISSN 1682-3915,
    ajit.2005.1093.1097,
    (https://makhillpublications.co/view-article.php?doi=ajit.2005.1093.1097)
    Abstract: 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.
    Keywords: modeling;dimensions;facts;analytical entities;transactional entities;semi-Star;Data warehouse;content changes;schema changes