A data warehouse (DW) is a collection of corporate information and data derived from operational systems and external data sources. A data warehouse is designed to support business decisions by allowing data consolidation, analysis and reporting at different aggregate levels. Data is populated into the DW through the processes of extraction,...
A transaction process system (TPS) is an information processing system for business transactions involving the collection, modification and retrieval of all transaction data. Characteristics of a TPS include performance, reliability and consistency.
TPS is also known as transaction processing or real-time processing.
A transaction process system and transaction processing are often contrasted with a batch process system and batch processing, where many requests are executed all at one time. The former requires the interaction of a user, whereas batch processing does not require a user to be present. Also, in batch processing the results of each transaction are not immediately available. Additionally, there is a delay while the many requests are being organized, stored and eventually executed. In transaction processing there is no delay and the results of each transaction are immediately available. During the delay time for batch processing, errors can occur. Although errors can occur in transaction processing, they are infrequent and tolerated, but do not warrant shutting down the entire system.
To achieve performance, reliability and consistency, data must be readily accessible in a data warehouse, backup procedures must be in place and the recovery process must be in place to deal with system failure, human failure, computer viruses, software applications or natural disasters.
Read More »
Join 138,000+ IT pros on our weekly newsletter
Home | Advertising Info | Write for Us | About | Contact Us
2010 - 2015
Partner Sites :