OLTP : customer oriented. OLAP : Market oriented
OLTP : ER based application oriented concern OLAP : subject oriented concern.
Current data : Historical data used for
detailed for decesion making
Access patterns are short. : COCancelMPLEX
processing a transaction includes involves cash or non transaction and concept of different between two?
Transaction processing system & management information system
explain the difference between cash and credit transaction
TPS (Transaction Processing System) focuses on processing routine transactions such as payment processing, order tracking, and inventory management in real-time. DSS (Decision Support System) focuses on helping management make decisions by providing tools and methods for analyzing data, generating reports, and forecasting outcomes. While TPS is operational-level, DSS is more strategic and analytical in nature.
explain the difference between batch processing and real-time processing
Transaction is bank risk
The words "outward or inward" associate with "transactions" are giving information of the 'status' of an incoming or outgoing processed transaction while the process of processing/aquiring/issuing for example in the arbitration's process of a credit card transaction which has been disputed.
online analytical processing uses basic operations such as slice and dice drilldown and roll up on historical data in order to provide multidimensional analysis of data data mining uses knowledge discovery to find out hidden patterns and association constructing analytical models and presenting mining results with visualization tools.
What is transaction what it contains
minimal
processing is nothing
·A nested transaction is a transaction that is logically decomposed into a hierarchy of sub transaction. A distributed transaction is logically a flat, indivisible transaction that operates on distributed data.