Derived Relations with Exceptions Decision Support Capabilities

Despite the widespread use of relational database management systems, their decision support capabilities have been limited. These limitations include: (1) very limited support for expression of general statements and exceptions, (2) limited capabilities for what-if analysis, and (3) problems with t...

Full description

Saved in:
Bibliographic Details
Published in:Journal of management information systems 1990-04, Vol.6 (4), p.83-101
Main Authors: Datiero, Ronald, Ramirez, Richard G., Choobineh, Joobin
Format: Article
Language:English
Subjects:
Database design
Database management systems
databaseviews
decision support system
Decision support systems
Documentation institutions
Exact sciences and technology
Information and communication sciences
Information science. Documentation
Management decisions
Management science
Predicates
relational database
Relational databases
Salary
Sciences and techniques of general use
Secondary and tertiary information and documents
Specialized information sources (paper or electronic format)
SQL
Citations: Items that this one cites
Items that cite this one
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:Despite the widespread use of relational database management systems, their decision support capabilities have been limited. These limitations include: (1) very limited support for expression of general statements and exceptions, (2) limited capabilities for what-if analysis, and (3) problems with the way derived data is handled. This paper shows that additional power can be placed in relational database systems via a new construct called Derived Relations with Exceptions (dres). Dres are a superset of relational views that provide greater decision support capabilities in that they handle exceptions to general rules and can operate in a hypothetical mode that provides an easier way to experiment with alternative scenarios in a what-if fashion. Dres are implemented by extending the SQL database language.
ISSN:0742-1222
1557-928X
DOI:10.1080/07421222.1990.11517873