113:
25:
939:
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
918:
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
938:
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
187:), 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
235:. 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
959:(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
1098:
O’Brien, Jason., and
Marakas, Gorila., (2008). Management Information Technology Systems. Computer Software (pp. 185). New York, New York: McGraw-Hill
990:
262:
industry is moving fast from legacy databases to real-time operational databases capable to handle distributed web and mobile demand and to address
54:
70:
967:
operations). An operational database is the source for a data warehouse. Data from an operational database can be loaded into an
1060:
1076:
199:. Basically, the consistency of the data is guaranteed in the case of failures and/or concurrent access to the data.
156:
134:
94:
127:
928:
46:
964:
1121:
960:
1126:
219:) was evolving dramatically, with new, innovative entrants and incumbents supporting the growing use of
985:
59:
1037:
1111:
1116:
121:
1069:
248:
50:
968:
259:
207:
Since the early 1990s, the operational database software market has been largely taken over by
138:
955:, the term is even more specific: the operational database is the one which is accessed by an
980:
667:
314:
236:
192:
8:
188:
35:
1005:
956:
39:
1056:
614:
240:
220:
74:
362:
63:
1089:
740:
244:
196:
952:
271:
195:
as main abstraction to guarantee data consistency that guarantee the so-called
919:
many items have been sold and when the company will need to reorder stock. An
1105:
924:
590:
566:
437:
386:
228:
971:
at a data warehouse before the data is processed into the data warehouse.
940:
885:
638:
489:
252:
1077:"Gartner Magic Quadrant for Operational Database Management Systems"
932:
836:
812:
764:
464:
413:
338:
263:
171:
691:
540:
516:
267:
995:
963:
database which is optimized for faster transaction processing (
860:
653:
232:
1000:
715:
300:
274:
for
Operational Database Management Systems in October 2013.
224:
788:
216:
212:
178:
1015:
1010:
294:
208:
57:
and tools are available to assist in formatting, such as
239:
architecture that can leverage distribution to provide
931:
transactions or financial operations, in a computer
890:Relational database (YSQL), Key–value store (YCQL)
258:The growing role of operational databases in the
1103:
277:
1090:http://orientdb.com/docs/last/Transactions.html
923:stores information about the activities of an
1050:
946:
511:Distributed Multi-Document ACID transactions
1032:
1030:
38:, which are uninformative and vulnerable to
1051:Ozsu, M. Tamer; Valduriez, Patrick (2011).
53:and maintains a consistent citation style.
16:Database system for real time data updates
1027:
157:Learn how and when to remove this message
95:Learn how and when to remove this message
558:JSON, key–value pairs, tabular data, XML
120:This article includes a list of general
282:Notable operational databases include:
185:online transaction processing databases
1104:
106:
18:
1053:Principles of Distributed Databases
545:Relational database, Data Warehouse
45:Please consider converting them to
13:
913:
211:engines. In 2014, the operational
126:it lacks sufficient corresponding
14:
1138:
929:customer relationship management
111:
23:
1040:. Techopedia. 15 November 2016.
965:create, read, update and delete
1083:
1044:
459:Distributed ACID-transactions
266:challenges. Recognizing this,
49:to ensure the article remains
1:
1021:
961:online transaction processing
278:List of operational databases
1038:"Operational Database (ODB)"
7:
974:
10:
1143:
986:Document-oriented database
947:Data warehouse terminology
769:Document-oriented Database
696:Document-oriented database
643:Document-oriented database
521:Document-oriented database
494:Document-oriented database
442:Document-oriented database
418:Document-oriented database
202:
227:DBMS engines, as well as
191:. OLTP databases provide
270:started to publish the
141:more precise citations.
969:operational data store
1122:Business intelligence
508:JSON, key–value pairs
176:(also referred to as
981:Distributed database
921:operational database
668:Microsoft SQL Server
456:XML, JSON, text data
237:distributed database
865:Relational database
817:Relational database
745:Relational database
720:Relational database
672:Relational database
619:Relational database
571:Relational database
469:Relational database
343:Relational database
1127:Types of databases
1006:Real-time database
957:operational system
907:ACID-transactions
904:tabular data, JSON
880:ACID-transactions
831:ACID-transactions
783:ACID-transactions
759:ACID-transactions
735:ACID-transactions
686:ACID-transactions
662:ACID-transactions
633:ACID-transactions
609:ACID-transactions
585:ACID-transactions
561:ACID-transactions
484:ACID-transactions
408:ACID-transactions
357:ACID transactions
309:ACID-transactions
174:management systems
1062:978-1-4419-8833-1
911:
910:
288:Database platform
241:high availability
221:unstructured data
215:market (formerly
167:
166:
159:
105:
104:
97:
55:Several templates
1134:
1112:Data warehousing
1092:
1087:
1081:
1080:
1073:
1067:
1066:
1048:
1042:
1041:
1034:
953:data warehousing
405:key–value pairs
391:Key–value store
363:Apache Cassandra
285:
284:
233:NewSQL databases
162:
155:
151:
148:
142:
137:this article by
128:inline citations
115:
114:
107:
100:
93:
89:
86:
80:
78:
67:
27:
26:
19:
1142:
1141:
1137:
1136:
1135:
1133:
1132:
1131:
1117:Data management
1102:
1101:
1095:
1088:
1084:
1075:
1074:
1070:
1063:
1049:
1045:
1036:
1035:
1028:
1024:
996:NewSQL database
977:
949:
916:
914:Use in business
852:key–value pairs
841:Key–value store
804:key–value pairs
793:Key–value store
780:key–value pairs
656:and JavaScript)
606:key–value pairs
595:Key–value store
448:(essential SQL)
378:key–value pairs
367:Key–value store
330:key-value pairs
319:Key–value store
306:Managed objects
280:
245:fault tolerance
205:
197:ACID properties
163:
152:
146:
143:
133:Please help to
132:
116:
112:
101:
90:
84:
81:
69:
58:
44:
28:
24:
17:
12:
11:
5:
1140:
1130:
1129:
1124:
1119:
1114:
1100:
1099:
1094:
1093:
1082:
1079:. Gartner.com.
1068:
1061:
1043:
1025:
1023:
1020:
1019:
1018:
1013:
1008:
1003:
1001:NoSQL database
998:
993:
988:
983:
976:
973:
948:
945:
927:, for example
915:
912:
909:
908:
905:
902:
897:
891:
888:
882:
881:
878:
875:
872:
866:
863:
857:
856:
853:
850:
845:
842:
839:
833:
832:
829:
826:
823:
818:
815:
809:
808:
805:
802:
797:
794:
791:
785:
784:
781:
778:
775:
770:
767:
761:
760:
757:
754:
751:
746:
743:
737:
736:
733:
730:
727:
721:
718:
712:
711:
708:
705:
700:
697:
694:
688:
687:
684:
681:
678:
673:
670:
664:
663:
660:
657:
647:
644:
641:
635:
634:
631:
628:
625:
620:
617:
611:
610:
607:
604:
601:
596:
593:
587:
586:
583:
580:
577:
572:
569:
563:
562:
559:
556:
551:
546:
543:
537:
536:
533:
530:
525:
522:
519:
513:
512:
509:
506:
501:
495:
492:
486:
485:
482:
479:
476:
470:
467:
461:
460:
457:
454:
449:
443:
440:
434:
433:
430:
427:
422:
419:
416:
410:
409:
406:
403:
398:
392:
389:
383:
382:
379:
376:
371:
368:
365:
359:
358:
355:
352:
349:
344:
341:
335:
334:
331:
328:
323:
320:
317:
311:
310:
307:
304:
298:
292:
291:Database model
289:
279:
276:
272:Magic Quadrant
204:
201:
165:
164:
119:
117:
110:
103:
102:
47:full citations
31:
29:
22:
15:
9:
6:
4:
3:
2:
1139:
1128:
1125:
1123:
1120:
1118:
1115:
1113:
1110:
1109:
1107:
1097:
1096:
1091:
1086:
1078:
1072:
1064:
1058:
1054:
1047:
1039:
1033:
1031:
1026:
1017:
1014:
1012:
1009:
1007:
1004:
1002:
999:
997:
994:
992:
991:HTAP database
989:
987:
984:
982:
979:
978:
972:
970:
966:
962:
958:
954:
944:
942:
936:
934:
930:
926:
922:
906:
903:
901:
898:
895:
892:
889:
887:
884:
883:
879:
876:
873:
870:
867:
864:
862:
859:
858:
854:
851:
849:
846:
843:
840:
838:
835:
834:
830:
827:
824:
822:
819:
816:
814:
811:
810:
806:
803:
801:
798:
795:
792:
790:
787:
786:
782:
779:
776:
774:
771:
768:
766:
763:
762:
758:
755:
752:
750:
747:
744:
742:
739:
738:
734:
731:
728:
725:
722:
719:
717:
714:
713:
709:
706:
704:
701:
698:
695:
693:
690:
689:
685:
682:
679:
677:
674:
671:
669:
666:
665:
661:
658:
655:
651:
648:
645:
642:
640:
637:
636:
632:
629:
626:
624:
621:
618:
616:
613:
612:
608:
605:
602:
600:
597:
594:
592:
589:
588:
584:
581:
578:
576:
573:
570:
568:
565:
564:
560:
557:
555:
552:
550:
547:
544:
542:
539:
538:
534:
531:
529:
526:
523:
520:
518:
515:
514:
510:
507:
505:
502:
499:
496:
493:
491:
488:
487:
483:
480:
477:
474:
471:
468:
466:
463:
462:
458:
455:
453:
450:
447:
444:
441:
439:
436:
435:
431:
428:
426:
423:
420:
417:
415:
412:
411:
407:
404:
402:
399:
396:
393:
390:
388:
385:
384:
380:
377:
375:
372:
369:
366:
364:
361:
360:
356:
353:
350:
348:
345:
342:
340:
337:
336:
332:
329:
327:
324:
321:
318:
316:
313:
312:
308:
305:
302:
299:
296:
293:
290:
287:
286:
283:
275:
273:
269:
265:
261:
256:
254:
250:
246:
242:
238:
234:
230:
229:XML databases
226:
222:
218:
214:
210:
200:
198:
194:
190:
186:
182:
180:
175:
173:
161:
158:
150:
140:
136:
130:
129:
123:
118:
109:
108:
99:
96:
88:
76:
75:documentation
72:
65:
64:documentation
61:
56:
52:
48:
43:
41:
37:
32:This article
30:
21:
20:
1085:
1071:
1055:. Springer.
1052:
1046:
1016:XML database
1011:SQL database
950:
937:
925:organization
920:
917:
899:
893:
877:tabular data
868:
847:
828:tabular data
820:
799:
772:
748:
732:tabular data
723:
702:
683:tabular data
675:
659:XML and JSON
649:
630:tabular data
622:
598:
591:FoundationDB
582:tabular data
574:
567:EnterpriseDB
553:
548:
527:
503:
497:
481:tabular data
472:
451:
445:
438:Clusterpoint
424:
400:
394:
387:Apache HBase
373:
354:tabular data
346:
325:
281:
257:
206:
193:transactions
184:
177:
170:Operational
169:
168:
153:
144:
125:
91:
82:
71:Citation bot
33:
756:multi-model
249:replication
139:introducing
85:August 2022
1106:Categories
1022:References
941:e-commerce
886:YugabyteDB
397:(Phoenix)
147:March 2013
122:references
51:verifiable
639:MarkLogic
490:Couchbase
315:Aerospike
255:ability.
253:scale out
189:real-time
181:databases
36:bare URLs
975:See also
933:database
896:(newSQL)
871:(newSQL)
837:ScyllaDB
813:SAP HANA
765:OrientDB
726:(newSQL)
475:(newSQL)
465:Clustrix
414:Cloudant
339:Altibase
264:Big data
247:through
172:database
40:link rot
692:MongoDB
541:IBM Db2
517:CouchDB
303:Support
297:Support
268:Gartner
203:History
135:improve
1059:
861:VoltDB
741:Oracle
654:XQuery
615:Ingres
500:(N1QL)
124:, but
60:reFill
855:None
807:None
716:NuoDB
710:None
535:None
432:None
381:None
333:None
301:NoSQL
225:NoSQL
34:uses
1057:ISBN
789:Riak
707:BSON
532:JSON
429:JSON
251:and
243:and
231:and
223:and
217:OLTP
213:DBMS
179:OLTP
68:and
951:In
900:Yes
894:Yes
869:Yes
848:Yes
821:Yes
800:Yes
777:Yes
773:Yes
753:Yes
749:Yes
724:Yes
703:Yes
676:Yes
650:Yes
646:Yes
623:Yes
599:Yes
575:Yes
554:Yes
549:Yes
528:Yes
504:Yes
498:Yes
473:Yes
452:Yes
446:Yes
425:Yes
401:Yes
395:Yes
374:Yes
347:Yes
326:Yes
295:SQL
209:SQL
183:or
1108::
1029:^
943:.
935:.
874:No
844:No
825:No
796:No
729:No
699:No
680:No
627:No
603:No
579:No
524:No
478:No
421:No
370:No
351:No
322:No
260:IT
1065:.
652:(
160:)
154:(
149:)
145:(
131:.
98:)
92:(
87:)
83:(
79:.
77:)
73:(
66:)
62:(
42:.
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.