Magazine article from our research archive:

DSS, OLTP clash over performance; while most implementors separate, some favor DSS/OLTP cohabitation. (decision support systems and online transaction processing) (DBMS)

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 decision support applications take an extract or replicate the production database and bring it down to the server level for analysis and query. There is a growing market for tools that take data from ...

Related newspaper, magazine, and journal articles:

See all results. Or, try our Advanced Search.

Newsweek Harper's Magazine The Washington Post Chicago Tribune Crain's Chicago Business PRNewswire Pediatric News The Nation Advertising Age The Economist (US) A FREE trial gives you access to over 60 million articles! Access over 3,500 publications with a FREE trial!