Decision Support Systems, briefly called DSS are special category of computerized information system that supports business and organizational decision-making activities. Correctly designed DSS is an interactive software-based system that has aim to assist decision makers compile valuable information from raw data, documents, personal knowledge, and/or business models to identify and solve problems and make decisions. Theorists described DSS as interactive computer-based systems, which help decision makers utilize data and models to solve unstructured problems (Scott Morton, 1971). Decision Support Systems are application of Herbert Simon model. The model has three phases: intelligence, design and choice. Decision Support Systems basically help the intelligence phase where the objective is to identify the problem and then go to the design phase for solution (Jawadekar, 2009). Sprague and Watson (1996) also stated conceptual models or frameworks are vital to understanding a new or complex system. DSS is broadly a computer based system to assist decision-makers to use data and models to solve ill-structured, unstructured or semi-structured problem.
DSS is essential for corporation because decision-making involves a complex sequence of activities over time. Decision support systems couple the intellectual resources of individuals with the capabilities of the computer to enhance the quality of decisions. It is a support system for management decision makers who deal with semi-structured problems (Keen and Scott Morton, 1978). Decision support system is an organized collection of people, procedures, software, databases, and devices working to support managerial decision making. The major objectives of DSS are to increase the effectiveness of the managers' decision-making process. Supports the manager in the decision-making process but does not replace it and improve the directors' effectiveness of decision making.
When reviewing history of DSS, it is found that Information Systems researchers and technologists have developed and investigated Decision Support Systems (DSS) since many decades. Decision Support Systems evolved in the beginning of the period of distributed computing. Such systems began in about 1965 and it became important to start formalizing a record of the ideas, people, systems and technologies involved in this important area of applied information technology.
There are mainly three functions of DSS:
Components of DSS: These systems are an application of Herbert Simon model. Model has three phases that include intelligence, design and choice. This model basically helps the information system in the intelligence phase where the objective is to identify the problem and then go to the design phase for solution. The choice of selection varies from problem to problem (Waman Jawadekar, 2009).Decision making as an element of problem solving
DSS can be categorized into numerous types (Waman Jawadekar):
It can be shown in management literature that DSS are developed by users and system analysts jointly. Decision support system uses the principle of economics, science and engineering and also the tools and techniques of management. The data used in Decision support system is drawn from the information system developed in company. The Decision support systems are developed in isolation and form an independent system subset of management information system. The most common use of the Decision support system is to test the decision alternatives and also to test the sensitivity of result to change in the system and assumption. The data and information for the Decision support system are used for the internal sources such as the database and conventional files and from the external sources (Waman Jawadekar, 2009).
Facilitation: DSS facilitate and support specific decision-making activities and/or decision processes.
Interaction: DSS are computer-based systems designed for interactive use by decision makers or staff users who control the sequence of interaction and the operations performed.
Ancillary: DSS can support decision makers at any level in an organization. They are NOT intended to replace decision makers.
Repeated Use: DSS are intended for repeated use. A specific DSS may be used routinely or used as needed for ad-hoc decision support tasks.
Identifiable: DSS may be independent systems that collect or replicate data from other information systems OR subsystems of a larger, more integrated information system.
Task-oriented: DSS provide specific capabilities that support one or more tasks related to decision-making, including, intelligence and data analysis; identification and design of alternatives; choice among alternatives; and decision implementation.
Decision Impact: DSS are intended to improve the accuracy, timeliness, quality and overall effectiveness of a specific decision or a set of related decisions.
Supports individual and group decision making: It provides a single platform that allows all users to access the same information and access the same version of truth, while providing autonomy to individual users and development groups to design reporting content locally.
Comprehensive Data Access: It allows users to access data from different sources concurrently, leaving organizations the freedom to choose the data warehouse that best suits their unique requirements and preferences.
Easy to Develop and Deploy: DSS delivers an interactive, scalable platform for rapidly developing and deploying projects. Multiple projects can be created within a single shared metadata. Within each project, development teams create a wide variety of re-usable metadata objects.
Integrated software: DSS's integrated platform enables administrators and IT professionals to develop data models, perform sophisticated analysis, generate analytical reports, and deliver these reports to end users via different channels (Web, email, file, print and mobile devices).
Flexibility: DSS features are flexible and can be altered according to need providing a helping hand in the work process.
Benefits of DSS: Decision Support Systems offers managers a powerful tool for decision making. Managers can handle large scale, time consuming and complex business problems. DSS can resolve complex issues in company and save manager's time and effort. Decision Support Systems improve the reliability of business decisions and reduce the risk of poor decisions. It provides the decision maker more alternatives (Adikesavan, 2014).
Disadvantages of DSS: There are several drawbacks of this system that include, monetary cost, overemphasize decision making, assumption of relevance, transfer of power, unanticipated effects, obscuring responsibility, false belief in objectivity, status reduction, and information overload.
To summarize, Decision Support Systems is an arrangement of computerized tools used to assist managerial decision making. It is a collection of integrated software application and hardware that forms the basis of the decision making process of firms and assist to make decision. This system also helps in performance evaluation. Decision support systems vary greatly in application and complexity, but they all share specific features. A Typical Decision support system has four components: data management, model management, knowledge management and user interface management.
The MIS is sustained by database in its endeavour to support the management in decision making. Organization needs that MIS would give them a 'competitive strength'. The need is to handle an on-line operation, mission, control applications and exercise the operational and management control. The need demands a tool to successfully manage both the transaction processing and the decision processing requirements. It also requires the capability of dealing with large number of users who are using, and updating a huge database. The need also demands the use of multiple databases residing on the hardware platforms situated at different location-nearby sites and remote site. The decision-making is essential more in a real time environment where the decision-making process, right from the problem definition to solution, needs to be handled quickly. The business environment is distributed and decentralized requiring real time resources (hardware, software, data, information) sharing with a multifaceted data flow. All this processes require the RDBMS which can serve both the decision support and the transaction processing requirements. With the biggest computer hardware and software capabilities, the mechanism of Relational Database Management System becomes popular (Waman Jawadekar, 2009). Major goal of a relational database design is to generate a set of relation schema that allows us to store information without unnecessary redundancy and also to retrieve information easily.
RDBMS is the database system in which the relationships among different tables are maintained. It corresponds to data as two-dimensional tables called relations or files. Each table contains data on entity and attributes. RDBMS solution is necessary when huge amounts of data are to be stored as well as maintained. A relational data model comprises of indexes, keys, foreign keys, tables and their relationships with other tables. Relational DBMS enforces the rules even though foreign keys support by both RDBMS and DBMS. The most popular RDBMS are MS SQL Server, DB2, Oracle and MySQL.
The RDBMS has five main components:
The modern version of RDBMS systems has two sub-systems or parts. One tackles the data management and transaction processing which is independent of its applications in the information processing. The second part provides a set of tools to develop and utilize on-line application for the decision support. This is controlled by the client-server architecture which separates the data management functions from its application. The data management function is handled by the server and the applications are handled by the client. The server centrally imposes all integrity, security and autonomy rules and the client (user) makes use of the database over the network of heterogeneous hardware. Contemporary trend in the information technology is to offer simple computing for the end user, easy to understand and easy to use. The notion is extended to the system analyst and programmer, where the RDBMS provides the tools, saving, development and processing time. It allows the business rules of the organization, standard transactions and queries to be programmed once and makes them available to all the users and developers as a stored procedure in the data dictionary. These stored procedures can be nested to develop an application. These procedures are both, reusable and sharable and are developed using the standard SQL. The RDBMS is also accomplished through the interface to handle the data sources from the other database and application tools developed on various operating systems.
Latest RDBMS system operates under the client-server environment as against the outmoded master-slave environment. In the traditional DBMS system, a transaction is processed in the database, i.e. the creation, validation and checking the transaction integrity logic. This is done for each transaction separately based on the procedures developed for forced transaction for validity and integrity checks. In the up-to-date RDBMS system, the third step of the integrity checking is done through a stored procedure common to all types of transaction.
Modern RDBMS facilitates greater security through offering various tools to the system administrators, the database owners and the users to grant and revoke permission to the specified users or a group of users on the specified tables, view, columns, stored procedures and commands. In latest RDBMS system, a multiple security is taken care of by one integrated DBMS.
The latest RDBMS allows an online maintenance, fast recovery and software based fault tolerance. These features ensure the availability of the database round the clock as the database maintenance is possible online when the system is in use. The maintenance activity comprises of the following tasks:
The fast recovery characteristic also the system administrator to provide a 'time' to go back for recovery of the data if the system fails due to the power failure or network crash. Based on this, time systems automatically go and collect all the changes and writes the risk.
The modern RDBMS controls the distributed heterogeneous data sources, software environment and hardware platforms. The system is open RDBMS. The modern business activity using the multiple hardware-software platforms, such a business enterprise has multiple databases residing at various locations. The information needs call for the unification and coordination of these databases. The data would get updated in distributed access to the distributed data. RDBMS permits communication at the database level and performs in an integrated manner as a single entity through the updates, and processing would take place at the respective distributed locations. This is accomplished through a software interface across the organization. Since the environment is distributed, it calls for a distributed integrity control and autonomy to perform. The distributed integrity control is accomplished through the stored procedures which guard the database from a remote external update or processing to maintain the autonomy which would be affected by the unauthorized update from distant locations.
Other typical features of modern RDBMS includes hardware independency, software independence, workability under a client-server architecture, a control feature of integrity, security and autonomy and built-in communication facilities to accomplish and open the system features for the management of information system. It offers a very efficient and effective tool to a skilled designer, developer and user to manage the information needs of the business company.
There is numerous benefit of using RDBMS. It improves conceptual simplicity. RDBMS makes easier database design, implementation, management, and use. It is a dominant database management system. Advantages of a relational database are as follows:
The usage of relational algebra and relational calculus in the manipulation of the relations between the tables ensures that there is no ambiguity, which may otherwise arise in establishing the linkages in a complicated network type database.
The main problem when using a relational database is the complexity that rises when it is first developed. It is absolutely vital that the defined relationships between the tables are correct and that each set of information is linked to its pair. Although less information has to be entered in total than with other databases, making sure every point is set up correctly is a slow process. Furthermore, the relationships can become extremely intricate when a relational database contains more than just two tables.
To summarize, Relational database management systems (RDBMS) are a consistent technique of storing and retrieving huge amounts of data, providing a combination of system performance and ease of implementation. RDBMS is the most common type of database used by organizations. It can be said that Relational database management systems (RDBMSs) have become universal components of modern application software. In many of these applications, the RDBMS is used to store data whose integrity and confidentiality must be strictly maintained.