A Transformation-oriented Methodology to Knowledge-based Conceptual Data Warehouse Design

  • Sitompul O
  • Noah S
Citations of this article
Mendeley users who have this article in their library.


Applications of artificial intelligence (AI) technology in the form of knowledge-based systems within the context of database design have been extensively researched particularly to provide support within the conceptual design phase. However, a similar approach to the task of data warehouse design has yet to be seriously initiated. In this paper, we proposed a design methodology for conceptual data warehouse design called the transformation-oriented methodology, which transforms an entity-relationship (ER) model into a multidimensional model based on a series of transformation and analysis rules. The transformation-oriented methodology translates the ER model into a specification language model and transformed it into an initial problem domain model. A set of synthesis and diagnosis rules will then gradually transform the problem domain model into the multidimensional model. A prototype KB tool called the DWDesigner has been developed to implement the aforementioned methodology. The multidimensional model produces by the DWDesigner as output is presented in a graphical form for better visualization. Testing has been conducted to a number of design problems, such as university, business and hospital domains and consistent results have been achieved




Sitompul, O. S., & Noah, S. A. (2009). A Transformation-oriented Methodology to Knowledge-based Conceptual Data Warehouse Design. Journal of Computer Science, 2(5), 460–465. https://doi.org/10.3844/jcssp.2006.460.465

Register to see more suggestions

Mendeley helps you to discover research relevant for your work.

Already have an account?

Save time finding and organizing research with Mendeley

Sign up for free