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 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.

• 저널Journal of Management Information Systems · 6(4) · 83–101
• 토픽Advanced Database Systems and Queries · Computer Networks and Communications
• DOI10.1080/07421222.1990.11517873
• 저자Ronald Datiero, R.G. Ramirez, Joobin Choobineh