An entity-relationship approach to decision support and expert systems

doi:10.1016/0167-9236(88)90131-5

Decision Support Systems

Volume 4, Issue 2, June 1988, Pages 225-234

https://doi.org/10.1016/0167-9236(88)90131-5 Get rights and content

Abstract

There has been an increasing interest in integrating decision support systems and expert systems to provide decision makers a more accessible, productive and domain-independent information and computing environment. In this paper, we review a workstation-based expert decision support system (WXDSS) proposed by Chen and Pruett. A database-oriented design process is discussed consisting of four phases: (1) requirements analysis, (2) conceptual framework, (3) logical design, and (4) physical system implementation. An entity-relationship (ER) approach to the design of conceptual framework is studied. A positive characteristic of the ER approach is that it provides the user an enterprise view of the WXDSS that is independent of how the information is stored and processed.

References (31)

J.S. Aikins
Prototypical knowledge for Expert Systems
Artificial Intelligence
(1983)
A. Sen et al.
Decision Support Systems: An Expert Systems Approach
Decision Support
(1985)
G. Ariav et al.
DSS Design: A Systemic View of Decision Support
Communication of the ACM
(1985)
L. Baker
Ada and AI Join Forces
AI Expert
(1987)
W. Blanning
An Entity-Relationship Approach to Model Management
Decision Support Systems
(1986)
R.H. Bonczek et al.
Developments in Decision Support Systems
J.L. Carswell et al.
SA-ER: A Methodology that Links Structured Analysis and Entity-Relationship Modeling for Database Design
P.P. Chen
The Entity-Relationship Model - Toward a Unified View of Data
ACM Transactions of Data Base Systems
(1976)
P.P. Chen
A Preliminary Framework for Entity-Relationship Models
Y.S. Chen et al.
Expert Systems and Operational Integration

Y.S. Chen and J.M. Pruett, Decision Support and Expert Systems: A Workstation Approach, Submitted for...

D. Dolk et al.

Knowledge Representation for Model Management Systems

IEEE Trans. Software Engineer

(1984)

J. Elam et al.

Model Management Systems: An Approach to Decision Support in Complex Organizations

P. Feldman et al.

Representing Rules Through Modeling Entity Behavior

J. Fitzgerald et al.

Fundamentals of Systems Analysis

(1987)

Cited by (9)

Terrain visualization information integration in agent-based military industrial logistics simulation
2022, Journal of Industrial Information Integration
Citation Excerpt :
The Entity-Relationship (ER) approach, introduced by Chen [63] in his milestone paper, plays a fundamental role in conceptual modeling for database design and system analysis, especially due to its flexibility and comprehensibility by practitioners and even non-specialists [64]. The ER model and its accompanying ER diagrams are the tools mostly used for database design and system analysis purposes [65,66]. Given that the ER diagrams can provide developers with an overall grasp of the data requirements, modelling, and database structures of an information system before the implementation phase [67], we use them as a conceptual modeling method for the data design in the terrain relation database in this study.
Agent-based simulation has become a useful tool in describing military industrial logistics organization behavior to implement military industrial information integration. Considering the specific demands of virtual engagement terrain design, this study present a framework for terrain visualization information integration in agent-based military industrial logistics simulation, which consists of perception access layer, data layer, service layer, and application layer. Focusing on its data source and the data analysis, processing, use, and validation, we propose a novel design approach on an engagement terrain database system for agent-based military industrial logistics simulation, and provide resolutions to actual problems, such as real-time efficient accession of the agent-based simulation system to high-resolution terrain data, management and maintenance of large-scale terrain data, and integrated visual simulation of terrain data. Such an initiative is achieved by presenting specific methods on the data and model designs for terrain relation, terrain analysis application, and terrain texture in terrain visualization application. A case study of the agent-based military industrial logistics simulation verifies the feasibility and effectiveness of the approach.
Knowledge-oriented modeling for influencing factors of battle damage in military industrial logistics: An integrated method
2020, Defence Technology
Citation Excerpt :
As another useful object-oriented method, the Entity-Relationship (ER) approach plays a fundamental role in conceptual modeling [41,42]. For system analysis purposes, the ER model and its accompanying ER diagrams are the tools used mostly [43–45]. Since an ER diagram is a visual representation of different entities within a system and how they relate to each other, this method can be applied to modeling and analysis of complex process system similar to battle damage factors.
Modeling influencing factors of battle damage is one of essential works in implementing military industrial logistics simulation to explore battle damage laws knowledge. However, one of key challenges in designing the simulation system could be how to reasonably determine simulation model input and build a bridge to link battle damage model and battle damage laws knowledge. In this paper, we propose a novel knowledge-oriented modeling method for influencing factors of battle damage in military industrial logistics, integrating conceptual analysis, conceptual modeling, quantitative modeling and simulation implementation. We conceptualize influencing factors of battle damage by using the principle of hierarchical decomposition, thus classifying the related battle damage knowledge logically. Then, we construct the conceptual model of influencing factors of battle damage by using Entity-Relationship approach, thus describing their interactions reasonably. Subsequently, we extract the important influencing factors by using social network analysis, thus evaluating their importance quantitatively and further clarifying the elements of simulation. Finally, we develop an agent-based military industry logistics simulation system by taking the modeling results on influencing factors of battle damage as simulation model input, and obtain simulation model output, i.e., new battle damage laws knowledge, thus verifying feasibility and effectiveness of the proposed method. The results show that this method can be used to support human decision-making and action.
A reference data model to support biomass supply chain modelling and optimisation
2016, Environmental Modelling and Software
Citation Excerpt :
The design of the reference data model is based on conceptual framework to address design science, proposed by Wieringa (Wieringa and Heerkens, 2006; Wieringa, 2009): (1) problem investigation, (2) solution design, (3) design validation, (4) choice of a solution, (5) implementation of the chosen solution and (6) evaluation of the implementation (Wieringa and Heerkens, 2006; Wieringa, 2009). The problem investigation (step 1) entails the definition of a generic high level process model based on a generic cradle-to-gate life cycle inventory (LCI) (Chen, 1988; Storey, 1991) to obtain an in-depth insight in the possible product and operation types and their relationships in biomass-based supply chains. An LCI is the stage in a life cycle assessment (LCA) in which the processes and elementary flows of the life cycle are identified (and quantified in case of a specific case) (European Commission, 2010b).
This paper presents a generic and flexible reference data model meant as the blueprint of the database component of information and decision support systems related to different types of biomass-based supply chains (e.g. first to fourth generation biomass for production of bioenergy and biomaterials). The data model covers the biomass types and handling operations as characterised by their attributes and mutual relationships resulting from a life cycle inventory analysis. The data model enables the identification of the possible operation sequences in the specified chain. This functionality is demonstrated in a case study in which biomass from tall herb communities and mesotrophic grasslands is supplied for biogas or compost production. A comparative analysis has pointed out that the data model includes the required object types to add specific attributes of biomass supply chain simulation and optimisation models (such as spatial and temporal dimensions).
Type and inheritance theory for model management
1997, Decision Support Systems
Model management is one of the important research areas in decision support systems (DSS). Similar to that in data management, the research activities in model management should include the representation of model base structures and design of model base systems. Object-oriented methods have been used for the representation of model base structures. Based on a proposed object-oriented framework, this paper presents the use of type rules and inheritance theory for the design of model base systems. Examples are used to illustrate that the proposed design theory can help to reduce redundancy and avoid inconsistency for the design of model base systems.
A PC-based decision support and expert system for labour market analysis
1992, Journal of Microcomputer Applications
Due to the worsening national economy, labour market analysis will receive increasing attention in the near future. This article describes an operating Decision Support (DSS) and Expert System (ES) for labour market analysis and its designing process. The $DSS ES$ is designed following the process of Pictorial Approach to modelling, and it provides researchers with timely and credible analysis of labour market information. This $DSS ES$ uses graphic presentation to delineate employment trends and magnitude, and it takes into consideration the special needs of business research centers by its implementations via spreadsheet application to improve the learning curve. By applying rule indices directly in the spreadsheet, the ES integrates with the DSS fully, and the decision makers are able to retain access to the historical data for ad hoc computations.
Designing and implementing an intelligent database application: A case study
1991, Expert Systems With Applications
The past few years have witnessed an increasing interest in both academia and industry to integrate database management systems and expert systems technologies to develop more intelligent applications. Conventional fourth-generation languages coupled with relational databases provide an attractive environment for designing and implementing database-driven applications that incorporate expert system techniques. This article describes such an application, ARCHES (American Red Cross Health Education System). This application was developed by the author and is currently in use at several Red Cross chapters in the New England region.

View all citing articles on Scopus

^∗: This research was funded by the College of Business Administration at Louisiana State University. The author also thanks one of the referees for his/her valuable comments.

View full text

An entity-relationship approach to decision support and expert systems

Abstract

Artificial Intelligence

Decision Support

DSS Design: A Systemic View of Decision Support

Communication of the ACM

Ada and AI Join Forces

AI Expert

An Entity-Relationship Approach to Model Management

Decision Support Systems

Developments in Decision Support Systems

SA-ER: A Methodology that Links Structured Analysis and Entity-Relationship Modeling for Database Design

The Entity-Relationship Model - Toward a Unified View of Data

ACM Transactions of Data Base Systems

A Preliminary Framework for Entity-Relationship Models

Expert Systems and Operational Integration

Knowledge Representation for Model Management Systems

IEEE Trans. Software Engineer

Model Management Systems: An Approach to Decision Support in Complex Organizations

Representing Rules Through Modeling Entity Behavior

Fundamentals of Systems Analysis