Menu
Home Explore People Places Arts History Plants & Animals Science Life & Culture Technology
On this page
Operational database
Database where data is updated in real-time, facilitating real-time data modification, deletion and concurrent access using transactions

Operational database management systems (also referred to as OLTP databases or online transaction processing databases), are used to update data in real-time. These types of databases allow users to do more than simply view archived data. Operational databases allow you to modify that data (add, change or delete data), doing it in real-time. OLTP databases provide transactions as main abstraction to guarantee data consistency that guarantee the so-called ACID properties. Basically, the consistency of the data is guaranteed in the case of failures and/or concurrent access to the data.

We don't have any images related to Operational database yet.
We don't have any YouTube videos related to Operational database yet.
We don't have any PDF documents related to Operational database yet.
We don't have any Books related to Operational database yet.
We don't have any archived web articles related to Operational database yet.

History

Since the early 1990s, the operational database software market has been largely taken over by SQL engines. In 2014, the operational DBMS market (formerly OLTP) was evolving dramatically, with new, innovative entrants and incumbents supporting the growing use of unstructured data and NoSQL DBMS engines, as well as XML databases and NewSQL databases. NoSQL databases typically have focused on scalability and have renounced to data consistency by not providing transactions as OLTP system do. Operational databases are increasingly supporting distributed database2 architecture that can leverage distribution to provide high availability and fault tolerance through replication and scale out ability.

The growing role of operational databases in the IT industry is moving fast from legacy databases to real-time operational databases capable to handle distributed web and mobile demand and to address Big data challenges. Recognizing this, Gartner started to publish the Magic Quadrant for Operational Database Management Systems in October 2013.3

List of operational databases

Notable operational databases include:

Database platformDatabase modelSQL SupportNoSQL SupportManaged objectsACID-transactions
AerospikeKey–value storeNoYeskey-value pairsNone
AltibaseRelational databaseYesNotabular dataACID transactions
Apache CassandraKey–value storeNoYeskey–value pairsNone
Apache HBaseKey–value storeYes (Phoenix)Yeskey–value pairsACID-transactions
CloudantDocument-oriented databaseNoYesJSONNone
ClusterpointDocument-oriented databaseYes (essential SQL)YesXML, JSON, text dataDistributed ACID-transactions
ClustrixRelational databaseYes (newSQL)Notabular dataACID-transactions
CouchbaseDocument-oriented databaseYes (N1QL)YesJSON, key–value pairsDistributed Multi-Document ACID transactions
CouchDBDocument-oriented databaseNoYesJSONNone
IBM Db2Relational database, Data WarehouseYesYesJSON, key–value pairs, tabular data, XMLACID-transactions
EnterpriseDBRelational databaseYesNotabular dataACID-transactions
FoundationDBKey–value storeYesNokey–value pairsACID-transactions
IngresRelational databaseYesNotabular dataACID-transactions
MarkLogicDocument-oriented databaseYesYes (XQuery and JavaScript)XML and JSONACID-transactions
Microsoft SQL ServerRelational databaseYesNotabular dataACID-transactions
MongoDBDocument-oriented databaseNoYesBSONNone
NuoDBRelational databaseYes (newSQL)Notabular dataACID-transactions
OracleRelational databaseYesYesmulti-modelACID-transactions
OrientDBDocument-oriented DatabaseYesYeskey–value pairsACID-transactions4
RiakKey–value storeNoYeskey–value pairsNone
SAP HANARelational databaseYesNotabular dataACID-transactions
ScyllaDBKey–value storeNoYeskey–value pairsNone
VoltDBRelational databaseYes (newSQL)Notabular dataACID-transactions
YugabyteDBRelational database (YSQL), Key–value store (YCQL)Yes (newSQL)Yestabular data, JSONACID-transactions

Use in business

Operational databases are used to store, manage and track real-time business information. For example, a company might have an operational database used to track warehouse/stock quantities. As customers order products from an online web store, an operational database can be used to keep track of how many items have been sold and when the company will need to reorder stock. An operational database stores information about the activities of an organization, for example customer relationship management transactions or financial operations, in a computer database.

Operational databases allow a business to enter, gather, and retrieve large quantities of specific information, such as company legal data, financial data, call data records, personal employee information, sales data, customer data, data on assets and many other information. An important feature of storing information in an operational database is the ability to share information across the company and over the Internet. Operational databases can be used to manage mission-critical business data, to monitor activities, to audit suspicious transactions, or to review the history of dealings with a particular customer. They can also be part of the actual process of making and fulfilling a purchase, for example in e-commerce.

Data warehouse terminology

In data warehousing, the term is even more specific: the operational database is the one which is accessed by an operational system (for example a customer-facing website or the application used by the customer service department) to carry out regular operations of an organization. Operational databases usually use an online transaction processing database which is optimized for faster transaction processing (create, read, update and delete operations). An operational database is the source for a data warehouse.5 Data from an operational database can be loaded into an operational data store at a data warehouse before the data is processed into the data warehouse.

See also

  • O’Brien, Jason., and Marakas, Gorila., (2008). Management Information Technology Systems. Computer Software (pp. 185). New York, New York: McGraw-Hill

References

  1. "Operational Database (ODB)". Techopedia. 15 November 2016. https://www.techopedia.com/definition/5711/operational-database-odb

  2. Ozsu, M. Tamer; Valduriez, Patrick (2011). Principles of Distributed Databases. Springer. ISBN 978-1-4419-8833-1. 978-1-4419-8833-1

  3. "Gartner Magic Quadrant for Operational Database Management Systems". Gartner.com. https://www.gartner.com/doc/2610218/magic-quadrant-operational-database-management

  4. "Archived copy". Archived from the original on 2016-03-25. Retrieved 2016-03-25.{{cite web}}: CS1 maint: archived copy as title (link) https://web.archive.org/web/20160325204447/http://orientdb.com/docs/last/Transactions.html

  5. "Operational Database (ODB)". Techopedia. 15 November 2016. https://www.techopedia.com/definition/5711/operational-database-odb