CHAPTER 2

DECISION SUPPORT SYSTEM


2.1   Introduction

Decision Support Systems, conventionally called as DSS deal with the design and the use of cognitively compatible computerized systems for-

  1. Assisting the managers in taking more effective decisions concerning semi-structured and unstructured tasks.
  2. Supporting, rather than replacing, managerial intuition and judgement
  3. Improving the effectiveness of decision making rather than its efficiency. (K Keen and Scott-Morton [1978]

Growths in computer and information technology and the realization of the inherent limitations of individual’s capability to take effective decisions in dynamic, unstructured and semi-structured decision situations, have naturally led to the development and use of various concepts and tools for using computer in making decisions.

 

2.2   Some Definition of DSS

  1. Mann and Watson [1984] observed that DSS is an interactive system that provides the user with easy access to decision models and data in order to support semi-structured and unstructured decision making tasks.
  2. According to Young [1983], the distinction of DSS is that they seek to establish a symbiosis of human- mind and computer by allowing a high degree of human-computer interaction and by enabling the manager-user to maintain direct control over the computers tasks and their outcomes. Three supports that DSS provides to manager are:
    1. The assistance to the manager in problem exploration and definition,
    2. Help in formulating alternate solutions, and
    3. Help to select strategy or a plan.

  3. Blanning [1986] states that an important purpose of the research being done in DSS is to develop a framework for information management that is as independent as possible of the way in which the information is stored and processed.
  4. Crescenzi and Gulden [1983] argues that DSS has emerged from the ashes of MIS’s failure to support decision-making by management in businesses, which find themselves ‘data-rich’ but ‘information-poor’.
  5. According to Watson and Hill [1983] DSS supports the tough information requests that MIS has not been able to serve.
  6. Sprague and Carlson [1982] observe that unfortunately the intuitive validity of the words in Decision Support System has tempted many to define DSS as any system that supports a decision or that makes some contribution to decision making, thus bringing in its fold all but transaction processing.

 

2.3   Features of DSS

From the above definitions it is evident that there is no universal definition of DSS. However, a quick survey of existing literature will reveal that most authors either explicitly or implicitly believe that a DSS should have the following nine basic characteristics.

  1. DSS assists managers in their decision making specifically in semi-structured and unstructured fields.
  2. DSS supports and enhances, rather than replaces, managerial decisions.
  3. DSS improves the effectiveness of the decision rather than its efficiency.
  4. DSS combines the use of models and analytical techniques with conventional data access and retrieval functions.
  5. DSS has features (including interactive features) which make its use by non-computer people easier.
  6. DSS ahs enough flexibility to accommodate changes in the environment, the approach and the needs of the users.
  7. DSS supports managers at all levels that take decisions.
  8. DSS is user initiated and user controlled.
  9. DSS supports the personal decision making styles of individual managers. [16]

 

2.4   Three Technology Levels of DSS

The three levels of hardware/software which have been included in the label "DSS" are:

Specific DSS

The system, which actually accomplishes the work, might be called the specific DSS.

It is an information systems "application", but with characteristics that make it significantly different from a typical data processing application. An early example is the portfolio management system [Keen & Scott Morton (1978)] and the police beat allocation system used in the city of San Jose, California [Carlson & Sutton (1974)].

DSS Generator

The second level of technology might be called a DSS generator. This is a "package" of related hardware and software which provides a set of capabilities to quickly and easily build a Specific DSS. For example, the police beat system described above was built from the Geo-data Analysis and Display System (GADS) at the IBM Research Laboratory in San Jose [Carlson et al. (1974)]. Another example is the Executive Information System (EIS) marketed by the Boeing Computer Services.

DSS Tools

The third and the most fundamental level of technology is called DSS tools. These are hardware or software elements, which facilitate the development of a specific DSS or a DSS Generator. For example, the GADS system described above was written in FORTRAN using an experimental graphics subroutine package as the primary dialogue handling software, a laboratory enhanced raster scan color monitor and a powerful interactive data extraction/database management system.

2.5   Components of DSS

A DSS consists of essentially three components or modules. They are:

  1. Database Management Module
  2. Knowledge or model management Module
  3. Dialog or User Interface Module

DSS also includes a complex software system to seamlessly integrate all these components. The software system should have interface with these three components. Generally the software system is comprised of three sets of capabilities: database management software (DBMS), model base management software (MBMS) and the software for managing the interface between the user and the system, which might be called the dialogue generation and management software (DGMS).

Figure 2.1 Inter-Relation between Modules

The following section deals with the details of individual components of DSS.

2.5.1  The Data Subsystem

The typical advantages of the database approach and the powerful functions of the DBMS are important to the development and use of a DSS.

The key characteristics of the data subsystem is shown in the figure 2.2

A partial set of capabilities required in the database area is:

Fig 2.2 The Data Subsystem

2.5.2  The Model Subsystem

A very promising aspect of a DSS is its ability to integrate data access and decision models. It does so by imbedding the decision models in an information system, which uses the database as the integration and communication mechanism between models. This characteristic unifies the strength of data retrieval and reporting from the EDP field and the significant developments in management science in a way the manager can trust. This area was studied by Sprague & Watson (1980, 81) and Will & Hart (1975). Fig. 2.3 shows a schematic view of this subsystem.

The key capabilities for a DSS in the model subsystems include:

Fig 2.3 The Models Subsystem

 

2.5.3  The User-Interface

Much of the power, flexibility and usability characteristics of a DSS are derived from capabilities in the user system interface. Bennet (1977) identifies the user, terminal and software system as the components of the interface system. He divides the dialogue or interface experience into three parts as shown in the figure 2.4.

  1. The action language – what the user can do in communicating with the system. It includes options like keyboard, touch panels, joy sticks etc.
  2. The display or presentation language – what the user sees. It includes options like line printer, display screen etc.
  3. The knowledge base – what the user must know. This consists of what the user needs to bring to the session with the system in order to effectively use it.

The desirable capabilities for a DSS to support the user system interface includes:

Fig 2.4 The User Interface

 

2.5.4  Current Trends in DSS Components

Current improvements in information technology have led to addition of new dimensions in DSS components. This section discusses few of them.

Present databases used for DSS are found to support the following features:

  1. Various Levels of Details: Different institutions require varying level of detail of data to support the system. Present databases are made flexible to meet this requirement.
  2. Varying Amounts of Data: Ad hoc DSS maintain only those data that are actually used for the decision making system, whereas institutional systems maintain a large amount of potentially relevant data.
  3. Varying Degree of Accuracy: Absolute accuracy of data is not important in small level DSS whereas they are important in some critical DSS.
  4. Support for memories: Sprague and Carlson [1982] suggest four kinds of memory aids that a DSS database should typically support: workspaces, libraries, links and triggers.
  5. Support for Relationships and Views: These are essential to allow the managers to test alternate scenarios quickly and with relative ease.
  6. Random Access: This facility is generally available in all commercial database.
  7. Security and Private database: Gains importance when data is shared across an organization, with different levels of restrictions applied on it.

Present model management systems or software take a different viewpoint regarding model bases. Some of the current trends are:

  1. Relational view of models: Just like relational view of data, it is assumed that model is a file created by running the model for all possible values of its inputs and recording the inputs and resulting outputs as records in a file, in which inputs are key attributes and outputs are content attributes. Languages similar to database query languages have been developed, like MQL [Model Query Language], TQL [Table Query Language] etc.
  2. Expert Modelbase Systems: Expert Modelbase Systems involve application artificial intelligence in efficiently manipulating models. This area consists of three sub-areas: (1) Application of AI to model construction, (2) the application of AI to model base integration and (3) the application of AI to the interpretation of model outputs.
  3. Graph based approach to Model Management: Application of graph theory in model management systems. [12]

User interfaces are becoming more and more sophisticated with increasing advancement in computer graphics and powerful visual tools. An emerging area in business graphics is interactive visual decision-making (IVDM). IVDM allows a manager to visually create or modify a model of complex decision situation. The manager can experiment with various decision alternatives, and see on the computer screen, the effect of different alternatives, in a graphical, even dynamic form on system’s measures of performance. AI techniques are also incorporated into IVDM, providing it with extended capabilities like dynamic optimization, specialized output etc.

 

2.6   Developing and Using DSS

A number of activities are required before a DSS is available to support decision-making. The organization must plan and organize both computers and human resources. As with most organizational endeavors, thoughtful planning and organizing is an important key to success. Once the planning and organizing for DSS has been accomplished, the development of specific DSS can begin. After it has been created, it can be put into use. This is when the payoff from the DSS is received. It should support all phases of decision making process and enhance the decision maker(s)’ effectiveness.

Management becomes involved with a DSS in a variety of ways: as approver and administrator, as developer, as operator and as user of output. A brief description of issues relevant to management’s involvement follows.

  1. As Approver and Administrator: Here the manager is functioning in a way quite consistent with other planning activities. Some expert remarks regarding this are:
  2. As Developer: Given that th function of the DSS is to support the manager’s decision making responsibilities, and given that decision making is a difficult task to specify or structure, it should not seem illogical that the manager would need to play a substantial role in the DSS development process. Experts have made following remarks regarding this:
  3. As Operator: The actual operation of the DSS requires skills perhaps most dissimilar to those typically required to managers. There are different levels of technical sophistication in DSS, which require different amounts of ability for use. It is expected that some amount of operational ability and actual operation of the DSS may be desired by managers. Following are observations of experts:
  4. User of Output: Last, but probably the most important part is the utilization of output by management. Experts note that:


2.7   The evolving DSS Domain: Group Decision Support System

    2.7.1  GDSS: An Overview

    Decision Support Systems were a revolutionary concept in computer support for decision making when they first appeared in the 1970’s. Now they are used in a large number of organizations. DSS is not a stagnant field, and it continues to evolve.

     

    Fig. 2.5 Schematic Diagram of GDSS

     

    Group Decision Support Systems (GDSS) are used to improve the efficiency and effectiveness of groups of people working together. Because of the amount of item people spend in group activities, GDSS has tremendous potential value. A GDSS can broadly defined as an interactive computer-based system, which facilitates solution of unstructured problems by a set of decision-makers working together as a group. Components of a GDSS include hardware, software, people and procedures. These components are arranged to support a group of people, usually in the context of a decision related meeting. Figure 2.5 shows a schematic diagram of a typical GDSS. [12]

    2.7.2  Basic Feature of GDSS

    < Text and data file creation. Modification and storage for group members.

    < Word processing for text editing and formatting.

    < Learning facilities for naïve GDSS users.

    < On-line ‘help’ facilities.

    < Worksheets, spreadsheets, decision trees and other means of graphically displaying numbers and text.

    <State-of-the-art database management, which can handle queries from all participants, creates sub-schemas as necessary for each participant, control access to public or corporate databases etc.


    2.7.3  Categories of GDSS

    Consider the following four scenarios where GDSS can be effectively used.

    • Decision Room: These are traditional boardrooms where group discussions take place, with common public screen set for demonstration. GDSS can be used here as tool for interactive visual presentations etc.
    • Local Decision Network: Rather than physically attending sessions, managers can have a ‘public screen’ at their terminal, which will be connected to a centralized server over a local area network (LAN). This approach offers greater flexibility in that the one-place/one-time constraint of Decision Rooms is removed.
    • Teleconferencing: This type of GDSS is needed for groups whose members are geographically distant from one another but who nevertheless must come together for the purpose of making a decision.
    • Remote Decision-Making: This is an emerging field where one-place/one-time constraint of teleconferencing is tried to remove.

    2.7.4  Design and Implementation Issues

    Existing research on the dynamics of group decision making has several implications for the design and use of GDSS. Major few are listed below:

    • GDSS should encourage the active participation of all group members.
    • Special accommodations are needed for groups who have no prior experience working together.
    • A useful feature of a GDSS would be to aid high-level management in selecting people to serve as group members for a given decision or problem.

    GDSS is still an emerging field, and have lots of potential to change the face of decision support systems.



2.8   Web Based Decision Support System

2.8.1  Overview

The world-wide-web is where the action is in developing enterprise-wide decision support systems. Web-based DSS refers to a computerized system which delivers decision support information or decision support tools to a manager or business analyst using a thin-client web-browser like Netscape Navigator or Intenet Explorer.The computer server that is hosting the DSS application is linked to user’s computer by a network with the TCP/IP protocol. In many companies, a web-based DSS is synonymous with an enterprise-wide DSS that is supporting large groups of managers in a networked client-server environment with a specialized data warehouse as part of the DSS. [27]

2.8.2  Advantages over conventional DSS

Web-based DSS have reduced technological barriers and made it easier and less costly to make decision relevant information available to managers and staff users in geographically distributed locations. Because of the World-Wide-Web infrastructure, enterprise wide DSS can now be implemented in physically dispersed companies and to geographically dispersed stakeholders including suppliers and customers at a relatively low cost. Using web-based DSS, organizations can provide DSS capability to managers over an intranet, to customers and suppliers over an extranet or to any stakeholder over the global internet. The web should increase the use of a well-designed DSS in a compnay. Using a web infrastructure for building DSS improves the rapid dissemination of ‘best-practice’ analysis and decision-making frameworks. It should also promote more consistent decision making on repetitive decision tasks across an organization.The web also provides a way to manage a company’s knowledge repository and to bring knowledge resources into the decision making process. The web can also reduce some of the problems associated with competing thick-client enterprise-wide DSS design where special software needs to be installed on a manager’s computer. Web-based DSS should reduce IT management and support costa and end-user training costs. With many web-based DSS and OLAP products, managers with a browser and access to a web-based DSS have the same type of ad-hoc reporting and interactive data analysis capabilities as that provided by thick-client OLAP tools. Web technology is and will continue to change the way organizations deliver all types of document and data.

2.8.3  Potential Problems

There are some potential problems with web-based DSS. Users expectations may be unrealistic, especially in terms of how much information they want to be able to access. There will be technical implementation problems especially in terms of peak demand/load problems. Training decision-support content providers and providing them with tools and technical assistance may be costly. The continuing ‘browser war’ between Microsoft and Netscape are also potential problem for developers with respect to porting issues. Also using the web may result in accumulation of obsolete data.

 

2.8.4  Web Technologies Commonly Used

Structure of a web-based DSS is different than that of conventional DSS, though the basic parts remains the same. A schematic diagram is shown in Fig. 2.6.

 

Fig. 2.6 Schematic Diagram of Web Based DSS

The database and modelbase of web-based DSS are typically stored in a dedicated enterprise web-server. A high-power web-server, capable of handling multiple database queries from distributed clients, is a prerequisite. User interface is any browser capable of displaying complex web architecture involving javascript, style-sheets and applets. These interfaces are generally HTML forms, which invoke predefined stored procedures in the server computer. These procedures, commonly known as CGI programs, are the threads between the client and the server. CGI programs, after running the required query, return the result in the form of web-page to the clients. These kind of procedures/programs are often called Middlewares, if they are commercial software.

Listed below are commonly used software for web-based Decision Support Systems:

  1. Database: Any commercial database can be used depending on what is supported by the CGI programs. These databases are accessed by programs through DLL’s (in Windows) or some other database drivers. Microsoft techniques like ODBC/DSN are popular choice.
  2. Modelbase: Models can written in high-level programming languages like C, C++ or Java. Often these models doubles as CGI programs, otherwise they are run by some other programs.
  3. CGI Programs: Popular choices are C, C++, Perl or ASP. This languages are capable accessing database through either ODBC connectivities or through own library header functions.
  4. User Interface: User-interface are HTML web-page in case of web-based DSS.

Recent advancement in web-technologies have opened up many new techniques for buiding database driven web applications. The low overhaed costs, overall advantage and easy accessibility may soon replace convetional DSS software with web-based Decision Support Systems.

 

2.9   Conclusion

This chapter discusses in details components of Decision Support Systems and the modern technologies involving this systems. The future of DSS is also discussed. Application of Decision Support Systems in particular fields like Logistics will be discussed in the next chapter.