DSS, OLTP clash over performance; while most implementors separate, some favor DSS/OLTP cohabitation. (decision support systems and online transaction processing) (DBMS) From: Software Magazine | Date: May 1, 1993| Author: Leinfuss, Emily | COPYRIGHT 1993 Wiesner Publications, Inc. This material is published under license from the publisher through the Gale Group, Farmington Hills, Michigan.  All inquiries regarding rights should be directed to the Gale Group.Copyright information

Most corporate application developers find the best way to implement decision support systems (DSS) is to separate databases optimized from decision support from production databases optimized for online transaction processing (OLTP). The three primary reasons for the separation are that the two systems need different types of data, decision support queries can lock up production databases, and decision support applications often use data from many sources that must be tied together. Most dec...