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. On the other side, Data Warehouses use an OLAP Database (Online Analytical Processing) which is optimized for faster queries. An Operational Database is usually put on a separate machine from the Data Warehouse to increase performance.
Operational Databases / Business
Operational Databases are very important to a business. These databases allow a business to enter, gather, and retrieve specific company information. Operational databases can be known by another name – production database. Known by different names, users can misunderstand what the database is supposed to be used for within a business. For instance, transaction database could mean that the information stored focuses on financial information even though it may not. Operational databases can store different types of information such as training status, personal employee information, and previous proposal information. Storing information in a centralized area can increase retrieval time for users. Operational databases are important when information is needed quickly. An important feature of storing information in an operational database is the ability to share information across the company. Another feature of an operational database is how much information can be stored that pertains to a business. Depending on the type of operational database being used will determine how much information it can hold. For instance, Oracle can store larger amounts of information than Access. Operational databases need continuous management. Since day-to-day information is important to a business, the management of that information becomes just as important. Having someone continually monitor the information being input into the database will make the information retrieved even more valuable because it will be accurate. Users depend on the accuracy of this information. Operational databases have the ability to flag specific information that may need to be retrieved on a continuous basis. Operational databases also have other features that focus on the business environment. For instance, an operational database has the ability to be modified. The overall idea of using an operational database is to expedite the retrieval of large amounts of information with peak efficiency. Furthermore, provide simultaneous read/write requests through pre-defined queries.
- O’Brien, J., and Marakas, G., (2008). Management Information Systems. Computer Software (pp. 185). New York, New York: McGraw-Hill
Wikimedia Foundation. 2010.
Look at other dictionaries:
Database — A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports… … Wikipedia
Operational intelligence — (OI) is a new form of real time dynamic, business analytics that delivers visibility and insight into business operations. Operational Intelligence solutions run query analysis against live feeds and event data to deliver real time, actionable… … Wikipedia
Operational Intelligence — (OI) focuses on providing real time monitoring of business processes and activities as they are executed within computer systems, and in assisting in optimizing these activities and processes by identifying and detecting situations that… … Wikipedia
Operational historian — refers to a software application that logs or historizes data. Operational Historians are like Enterprise Historians but differ in that they are used by engineers on the plant floor rather than by business processes. They are typically cheaper,… … Wikipedia
Operational Loads Monitoring — (OLM) is a term given to act of investigating the characteristics of a structure in its normal operating environment. This term is often used to describe programs involving aircraft to extending their in service life in a manner that does not… … Wikipedia
Database marketing — is a form of direct marketing using databases of customers or potential customers to generate personalized communications in order to promote a product or service for marketing purposes. The method of communication can be any addressable medium,… … Wikipedia
Database administration and automation — Database administration is the function of managing and maintaining database management systems (DBMS) software. Mainstream DBMS software such as Oracle, IBM DB2 and Microsoft SQL Server need ongoing management. As such, corporations that use… … Wikipedia
Operational data store — An operational data store (or ODS ) is a database designed to integrate data from multiple sources for additional operations on the data. The data is then passed back to operational systems for further operations and to the data warehouse for… … Wikipedia
Operational Support Facility — An Operational Support Facility (or OSF) is an organization within the Federal Aviation Administration (FAA) that modifies software and/or special purpose databases for Air Traffic Control systems. Each FAA Air Traffic Control site has a computer … Wikipedia
15th Operational Weather Squadron — Infobox OWS name = 15th Operational Weather Squadron caption = 15th Operational Weather Squadron Loc = Scott Air Force Base, Illinois CC = 1st Weather Group, Offutt Air Force Base, Nebraska AOR = Northeastern CONUS $200B to >270,000 to 18000 to… … Wikipedia