Database - Data Warehousing - Discussion

Discussion :: Data Warehousing - General Questions (Q.No.4)

4. 

An operational system is which of the following?

[A]. A system that is used to run the business in real time and is based on historical data.
[B]. A system that is used to run the business in real time and is based on current data.
[C]. A system that is used to support decision making and is based on current data.
[D]. A system that is used to support decision making and is based on historical data.

Answer: Option B

Explanation:

No answer description available for this question.

Sundar said: (Sep 19, 2011)  
An Operational System is a system that is used daily (perhaps constantly) to perform routine operations - part of the normal business processes.

An operational system is a term used in data warehousing to refer to a system that is used to process the day-to-day transactions of an organization. These systems are designed so processing of day-to-day transactions is performed efficiently and the integrity of the transactional data is preserved.

Mahalakshmi said: (Mar 14, 2013)  
Operational system are process oriented. i.e) focused on specific business process or some other task. It stores current data only.

But the data warehouse stores both current and historical data.

Amutha-Sit said: (Mar 14, 2013)  
Operational system in datawarehouse are normally "relational" - not "dimensional". They are designed for operational, data entry purposes and are not well suited for online queries and analytics.

Jeevitha- Sit said: (Mar 14, 2013)  
Based on this fundamental difference, data usage patterns associated with operational systems are significantly different than usage patterns associated with data warehousing systems. As a result, data warehousing systems are designed and optimized using methodologies that drastically differ from that of operational systems.

Midhula-Sit said: (Mar 14, 2013)  
Operational systems are generally designed to support high-volume transaction processing with minimal back-end reporting.

Data within operational systems are generally updated regularly according to need.

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.