Operational system
Encyclopedia
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.
s, transaction processing system
s, or online transaction processing
systems (OLTP). However, the use of the last two terms as synonyms may be confusing, because operational systems can be batch processing
systems as well.
Any Enterprise must necessarily maintain a lot of data about its operation. This is its "Operational Data".
Synonyms
Sometimes operational systems are referred to as operational databaseOperational database
In Data Warehousing, the Operational Database is one which is accessed by an Operational System to carry out regular operations of an organization. Operational Databases usually use an OLTP Database which is optimized for faster transaction processing: Inserting, Deleting, and Updating data...
s, transaction processing system
Transaction Processing System
A transaction processing system is a type of information system. TPSs collect, store, modify, and retrieve the transactions of an organization. A transaction is an event that generates or modifies data that is eventually stored in an information system. To be considered a transaction processing...
s, or online transaction processing
Online transaction processing
Online transaction processing, or OLTP, refers to a class of systems that facilitate and manage transaction-oriented applications, typically for data entry and retrieval transaction processing...
systems (OLTP). However, the use of the last two terms as synonyms may be confusing, because operational systems can be batch processing
Batch processing
Batch processing is execution of a series of programs on a computer without manual intervention.Batch jobs are set up so they can be run to completion without manual intervention, so all input data is preselected through scripts or command-line parameters...
systems as well.
Any Enterprise must necessarily maintain a lot of data about its operation. This is its "Operational Data".
Organization | Probably |
---|---|
Manufacturing Company | Product data |
Bank | Account Data |
Hospital | Patient Data |
University | Student Data |
Government Department | Planning data |
See also
- Operating systemOperating systemAn operating system is a set of programs that manage computer hardware resources and provide common services for application software. The operating system is the most important type of system software in a computer system...
(OS) - Data warehouses versus operational systems