Operational system
 | This article needs more citations. (December 2025) |
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 in a manner that processing of day-to-day transactions is performed efficiently and the integrity of the transactional data is preserved.[1]
Synonyms
Sometimes operational systems are referred to as operational databases, transaction processing systems, 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.
| Organization | Probably |
|---|---|
| Manufacturing Company | Product data |
| Bank | Account Data |
| Hospital | Patient Data |
| University | Student Data |
| Government Department | Planning data |
See also
- Data warehouses versus operational systems
- Operating system (OS)
- Operational data store, a database used for operational reporting, and as a source of data for a data warehouse
References
- ^ Hughes, Ralph (2016). "Essential DW/BI Background and Definitions". Agile Data Warehousing for the Enterprise. pp. 59–84. doi:10.1016/B978-0-12-396464-9.00004-7. ISBN 978-0-12-396464-9.
A company's 'operational systems' are those systems needed to execute the company's daily commercial transactions and all subsequent data processing needed to complete business obligations. These systems are often called the company's 'transaction capture' systems and also 'online transaction processing' (OLTP) applications.
 | This database-related article is a stub. You can help Wikipedia by adding missing information. |
Content Disclaimer
Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.
- The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
- There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
- It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
- Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
- Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.