The graph template for designing the conceptual and logical model of business processes and technical systems

Abstract

Currently the task of reducing the cost of software and information support for processes in various subject areas is actual.  The method of developing a conceptual model in the form of a graph-template is described in the article. The proposed method allows IT designers to create conceptual models with minimal cost. The use of the template graph allows one to create a graph conceptual model that is mapped into a multidimensional logical data schema. The proposed method is oriented at developing a multidimensional database schema. The method is based on a sequence of steps: the research of the subject area; the creation of process models; the design of a conceptual model; the design of a multidimensional database model. The multidimensional model supports the use of business intelligence methods and allows IT staff to use OLAP analysis. The technology to adapt the graph-template for describing a subject area is used for developing the conceptual model. Then the conceptual graph model transforms to a multidimensional data model for supporting OLAP analysis. Thus, the use of a graph template reduces the cost of designing information support using DB. This method has been tested in the design of information support of business processes and monitoring systems.