36:
1516:
1046:
1526:
381:
credentials to view the database, its entities, and its data or to perform database management tasks. Database administrators and application developers can manage databases only if they have appropriate permissions and roles granted to them by the organization administrator. The permissions and roles must be granted on the database group or on the database, and they only apply within the organization in which they are granted.
1536:
1036:
361:, and the development of the Kubernetes Operator pattern by CoreOS, further extended the ability to orchestrate database container. Kubernetes Operators have been used by third parties to enable the ability to automate database administration, including deployment of instances of a database, upgrade database versions, or perform backups.
289:
Another kind of database software exists to manage the provisioning of new databases and the management of existing databases and their related resources. The process of creating a new database can consist of hundreds or thousands of unique steps from satisfying prerequisites to configuring backups
293:
As the number of DBAs grows, without automation the number of unique configurations frequently grows to be costly/difficult to support. All of these complicated procedures can be modeled by the best DBAs into database automation software and executed by the standard DBAs. Software has been created
260:
Database administration work is complex, repetitive, time-consuming and requires significant training. Since databases hold valuable and mission-critical data, companies usually look for candidates with multiple years of experience. Database administration often requires DBAs to put in work during
380:
Every database requires a database owner account that can perform all schema management operations. This account is specific to the database and cannot log into Data
Director. You can add database owner accounts after database creation. Data Director users must log in with their database-specific
252:
The degree to which the administration of a database is automated dictates the skills and personnel required to manage databases. On one end of the spectrum, a system with minimal automation will require significant experienced resources to manage; perhaps 5-10 databases per DBA. Alternatively an
264:
One key skill required and often overlooked when selecting a DBA is database recovery (a part of disaster recovery). It is not a case of “if” but a case of “when” a database suffers a failure, ranging from a simple failure to a full catastrophic failure. The failure may be data corruption, media
389:
There are several education institutes that offer professional courses, including late-night programs, to allow candidates to learn database administration. DBMS vendors such as Oracle, Microsoft and IBM offer certification programs to help companies to hire qualified DBA practitioners. College
376:
Clarity have begun to increase the automation of databases causing the reduction of database related tasks. However at best this only reduces the amount of mundane, repetitive activities and does not eliminate the need for DBAs. The intention of DBA automation is to enable DBAs to focus on more
185:
Systems DBAs (also referred to as physical DBAs, operations DBAs or production
Support DBAs): focus on the physical aspects of database administration such as DBMS installation, configuration, patching, upgrades, backups, restores, refreshes, performance optimization, maintenance and
231:(both now part of Oracle Corp.) and SAP. Application DBAs straddle the fence between the DBMS and the application software and are responsible for ensuring that the application is fully optimized for the database and vice versa. They usually manage all the
253:
organization might choose to automate a significant amount of the work that could be done manually therefore reducing the skills required to perform tasks. As automation increases, the personnel needs of the organization splits into highly
243:
In larger organizations, individuals typically specialize in a specific type of database administration. However, in smaller organizations, it's common for a single person or team to handle multiple database administration roles.
273:
Often, the DBMS software comes with certain tools to help DBAs manage the DBMS. Such tools are called native tools. For example, Microsoft SQL Server comes with SQL Server
Management Studio and Oracle has tools such as
290:
where each step must be successful before the next can start. A human cannot be expected to complete this procedure in the same exact way time after time - exactly the goal when multiple databases exist.
261:
off-hours (for example, for planned after hours downtime, in the event of a database-related outage or if performance has been severely degraded). DBAs are commonly well compensated for the long hours.
235:
that interact with the database and carry out activities such as application installation and patching, application upgrades, database cloning, building and running data cleanup routines, data load
322:
launched a similar automated database as a service in 2010, with SQL Azure, providing automated backups, with geo-replication and high availability. The introduction of
265:
failure, or user induced errors. In either situation the DBA must have the skills to recover the database to a given point in time to prevent a loss of data.
513:
1126:
463:
286:, patchVantage and SQL Maestro Group offer GUI tools to monitor the DBMS and help DBAs carry out certain functions inside the database more easily.
1109:
574:
1121:
369:
299:
941:
495:
205:, collaborating with developers to help choose the most appropriate DBMS feature/functionality and other pre-production activities.
17:
838:
414:
1560:
1519:
971:
781:
1192:
1081:
956:
326:
containers has enhanced support for fast delivery of containerized database instances, and both Amazon Web
Services and
643:
79:
57:
50:
220:
1539:
1245:
1039:
257:
to create and manage the automation and a group of lower skilled "line" DBAs who simply execute the automation.
1496:
1143:
966:
951:
445:
236:
1435:
987:
880:
834:
946:
801:
748:
468:
216:
1430:
599:
1461:
1180:
859:
743:
530:
CoreOS Introduces "Operators" to
Simplify Configuration and Management of Modern Distributed Applications
377:
proactive activities around database architecture, deployment, performance and service level management.
1384:
1374:
1150:
1002:
875:
771:
686:
96:
1471:
1204:
666:
1565:
961:
766:
283:
198:
44:
913:
193:
Development DBAs: focus on the logical and development aspects of database administration such as
144:
Implement and maintain database security (create and maintain users and roles, assign privileges).
1074:
896:
543:
1501:
1456:
1133:
844:
728:
636:
116:
112:
61:
1476:
1230:
918:
424:
209:
111:
need ongoing management. As such, corporations that use DBMS software often hire specialized
528:
1529:
1466:
1348:
1318:
1187:
1138:
992:
854:
706:
399:
390:
degree in
Computer Science or related field is helpful but not necessarily a prerequisite.
346:
232:
212:
128:
Installation, configuration and upgrading of
Database server software and related products.
108:
8:
1486:
1379:
1364:
1291:
1116:
1012:
711:
451:
315:
224:
562:
1481:
1425:
1394:
1343:
1235:
1175:
1067:
1049:
933:
923:
811:
733:
586:
419:
342:
758:
294:
specifically to improve the reliability and repeatability of these procedures such as
1301:
1155:
1017:
997:
816:
793:
629:
409:
354:
323:
187:
160:
590:
1491:
1338:
1328:
1296:
906:
721:
691:
578:
457:
202:
278:
and Oracle
Enterprise Manager/Grid Control. In addition, 3rd parties such as BMC,
1399:
1369:
1323:
1104:
901:
849:
826:
738:
701:
696:
676:
671:
439:
373:
327:
319:
303:
147:
138:
100:
318:
introduction of AWS RDS, providing automated and managed database as a service.
1451:
1389:
1333:
1306:
1199:
1160:
806:
776:
681:
404:
279:
254:
1059:
1554:
1270:
1255:
429:
330:
have enhanced automated support for containers in their respective services.
582:
1022:
434:
1260:
1240:
134:
Establish and maintain sound backup and recovery policies and procedures.
1404:
1313:
1275:
1250:
716:
358:
338:
333:
Third party support for database container images has grown, including
228:
194:
1007:
365:
350:
295:
208:
Application DBAs: usually found in organizations that have purchased
1265:
1220:
1090:
652:
275:
334:
104:
1170:
614:
314:
Automated
Database operations has grown since 2009, following
166:
Work as part of a team and provide 24/7 support when required.
1165:
1225:
621:
223:) systems. Examples of such application software includes
473:
131:
Evaluate
Database features and Database related products.
309:
247:
563:"A set theoretic data structure and retrieval language"
464:
Comparison of relational database management systems
384:
169:
Do general technical troubleshooting and give cons.
99:(DBMS) software. Mainstream DBMS software such as
27:Function of managing and maintaining DBMS software
1552:
615:ACM Special Interest Group on Management of Data
515:Windocks does what Docker and Microsoft can't do
268:
1089:
575:Special Interest Group on Information Retrieval
156:Setup and maintain documentation and standards.
153:Application tuning and performance monitoring.
1075:
637:
201:) generation, SQL writing and tuning, coding
600:"Origins of the Data Base Management System"
597:
95:is the function of managing and maintaining
1082:
1068:
644:
630:
80:Learn how and when to remove this message
43:This article includes a list of general
14:
1553:
415:Distributed database management system
1063:
625:
493:
476:is a language for database management
310:The impact of IT and cloud automation
248:Automation of database administration
29:
1535:
1035:
122:
24:
49:it lacks sufficient corresponding
25:
1577:
555:
353:, and from independent port's of
1534:
1524:
1515:
1514:
1045:
1044:
1034:
385:Learning database administration
221:customer relationship management
34:
1525:
181:There are three types of DBAs:
536:
521:
506:
487:
13:
1:
988:Database-centric architecture
545:Kubernetes Operators in Depth
480:
269:Database administration tools
197:design and maintenance, DDL (
651:
469:Comparison of database tools
217:enterprise resource planning
7:
1561:Database management systems
1091:Database management systems
494:Perry, Yifat (2020-05-18).
393:
364:Newer technologies such as
150:and performance monitoring.
97:database management systems
10:
1582:
1497:Object–relational database
1003:Locks with ordered sharing
835:Entities and relationships
687:Database management system
598:Thomas Haigh (June 2006).
446:Object–relational database
1510:
1472:Federated database system
1444:
1413:
1357:
1284:
1213:
1205:Blockchain-based database
1097:
1031:
980:
932:
889:
881:Object–relational mapping
868:
825:
792:
757:
659:
159:Plan growth and changes (
284:Embarcadero Technologies
199:data definition language
176:
583:10.1145/1095495.1095500
117:database administrators
93:Database administration
64:more precise citations.
18:Database Administration
1502:Transaction processing
1457:Database normalization
1400:Query rewriting system
577:: 45–55. Winter 1972.
233:application components
113:information technology
1477:Referential integrity
782:information retrieval
425:Navigational database
1467:Distributed database
993:Intelligent database
400:Column-oriented DBMS
347:Microsoft SQL Server
213:application software
109:Microsoft SQL Server
1487:Relational calculus
1365:Concurrency control
802:Activity monitoring
452:Run Book Automation
316:Amazon Web Services
225:Oracle Applications
141:and implementation.
1482:Relational algebra
1426:Query optimization
1231:Armstrong's axioms
972:Online real estate
420:Hierarchical model
237:process management
1548:
1547:
1156:Wide-column store
1151:Document-oriented
1057:
1056:
1018:Halloween Problem
998:Two-phase locking
957:Facial expression
876:Abstraction layer
817:Negative database
772:Data manipulation
410:Directory service
355:docker (software)
324:docker (software)
203:stored procedures
188:disaster recovery
172:Database recovery
161:capacity planning
137:Take care of the
115:personnel called
90:
89:
82:
16:(Redirected from
1573:
1538:
1537:
1528:
1527:
1518:
1517:
1492:Relational model
1462:Database storage
1339:Stored procedure
1084:
1077:
1070:
1061:
1060:
1048:
1047:
1038:
1037:
646:
639:
632:
623:
622:
618:
604:
594:
549:
548:
540:
534:
533:
525:
519:
518:
510:
504:
503:
491:
458:Relational model
123:Responsibilities
85:
78:
74:
71:
65:
60:this article by
51:inline citations
38:
37:
30:
21:
1581:
1580:
1576:
1575:
1574:
1572:
1571:
1570:
1566:Data management
1551:
1550:
1549:
1544:
1506:
1452:Database models
1440:
1409:
1395:Query optimizer
1370:Data dictionary
1353:
1324:Transaction log
1280:
1236:Codd's 12 rules
1209:
1139:Column-oriented
1105:Object-oriented
1093:
1088:
1058:
1053:
1027:
976:
928:
885:
864:
821:
788:
767:Data definition
753:
677:Database object
655:
650:
602:
561:
558:
553:
552:
542:
541:
537:
527:
526:
522:
512:
511:
507:
492:
488:
483:
440:Object database
396:
387:
374:GridApp Systems
357:from Windocks
328:Microsoft Azure
320:Microsoft Azure
312:
304:GridApp Systems
271:
255:skilled workers
250:
179:
148:Database tuning
139:Database design
125:
86:
75:
69:
66:
56:Please help to
55:
39:
35:
28:
23:
22:
15:
12:
11:
5:
1579:
1569:
1568:
1563:
1546:
1545:
1543:
1542:
1532:
1522:
1511:
1508:
1507:
1505:
1504:
1499:
1494:
1489:
1484:
1479:
1474:
1469:
1464:
1459:
1454:
1448:
1446:
1445:Related topics
1442:
1441:
1439:
1438:
1433:
1428:
1423:
1421:Administration
1417:
1415:
1411:
1410:
1408:
1407:
1402:
1397:
1392:
1390:Query language
1387:
1382:
1377:
1372:
1367:
1361:
1359:
1355:
1354:
1352:
1351:
1346:
1341:
1336:
1331:
1326:
1321:
1316:
1311:
1310:
1309:
1304:
1299:
1288:
1286:
1282:
1281:
1279:
1278:
1273:
1268:
1263:
1258:
1253:
1248:
1243:
1238:
1233:
1228:
1223:
1217:
1215:
1211:
1210:
1208:
1207:
1202:
1197:
1196:
1195:
1185:
1184:
1183:
1173:
1168:
1163:
1158:
1153:
1148:
1147:
1146:
1136:
1131:
1130:
1129:
1124:
1114:
1113:
1112:
1101:
1099:
1095:
1094:
1087:
1086:
1079:
1072:
1064:
1055:
1054:
1032:
1029:
1028:
1026:
1025:
1020:
1015:
1010:
1005:
1000:
995:
990:
984:
982:
978:
977:
975:
974:
969:
964:
959:
954:
949:
944:
938:
936:
930:
929:
927:
926:
921:
916:
911:
910:
909:
899:
897:Virtualization
893:
891:
887:
886:
884:
883:
878:
872:
870:
866:
865:
863:
862:
857:
852:
847:
842:
831:
829:
823:
822:
820:
819:
814:
809:
804:
798:
796:
790:
789:
787:
786:
785:
784:
774:
769:
763:
761:
755:
754:
752:
751:
746:
741:
736:
731:
726:
725:
724:
719:
709:
704:
699:
694:
689:
684:
679:
674:
669:
663:
661:
657:
656:
649:
648:
641:
634:
626:
620:
619:
595:
557:
556:External links
554:
551:
550:
535:
520:
505:
496:"AWS Database"
485:
484:
482:
479:
478:
477:
471:
466:
461:
455:
449:
443:
437:
432:
427:
422:
417:
412:
407:
405:Data warehouse
402:
395:
392:
386:
383:
311:
308:
280:Quest Software
270:
267:
249:
246:
241:
240:
206:
191:
178:
175:
174:
173:
170:
167:
164:
157:
154:
151:
145:
142:
135:
132:
129:
124:
121:
88:
87:
42:
40:
33:
26:
9:
6:
4:
3:
2:
1578:
1567:
1564:
1562:
1559:
1558:
1556:
1541:
1533:
1531:
1523:
1521:
1513:
1512:
1509:
1503:
1500:
1498:
1495:
1493:
1490:
1488:
1485:
1483:
1480:
1478:
1475:
1473:
1470:
1468:
1465:
1463:
1460:
1458:
1455:
1453:
1450:
1449:
1447:
1443:
1437:
1434:
1432:
1429:
1427:
1424:
1422:
1419:
1418:
1416:
1412:
1406:
1403:
1401:
1398:
1396:
1393:
1391:
1388:
1386:
1383:
1381:
1378:
1376:
1373:
1371:
1368:
1366:
1363:
1362:
1360:
1356:
1350:
1347:
1345:
1342:
1340:
1337:
1335:
1332:
1330:
1327:
1325:
1322:
1320:
1317:
1315:
1312:
1308:
1305:
1303:
1300:
1298:
1295:
1294:
1293:
1290:
1289:
1287:
1283:
1277:
1274:
1272:
1271:Surrogate key
1269:
1267:
1264:
1262:
1259:
1257:
1256:Candidate key
1254:
1252:
1249:
1247:
1244:
1242:
1239:
1237:
1234:
1232:
1229:
1227:
1224:
1222:
1219:
1218:
1216:
1212:
1206:
1203:
1201:
1198:
1194:
1191:
1190:
1189:
1186:
1182:
1179:
1178:
1177:
1174:
1172:
1169:
1167:
1164:
1162:
1159:
1157:
1154:
1152:
1149:
1145:
1142:
1141:
1140:
1137:
1135:
1132:
1128:
1125:
1123:
1120:
1119:
1118:
1115:
1111:
1108:
1107:
1106:
1103:
1102:
1100:
1096:
1092:
1085:
1080:
1078:
1073:
1071:
1066:
1065:
1062:
1052:
1051:
1042:
1041:
1030:
1024:
1021:
1019:
1016:
1014:
1011:
1009:
1006:
1004:
1001:
999:
996:
994:
991:
989:
986:
985:
983:
979:
973:
970:
968:
965:
963:
960:
958:
955:
953:
950:
948:
945:
943:
940:
939:
937:
935:
931:
925:
922:
920:
917:
915:
912:
908:
905:
904:
903:
900:
898:
895:
894:
892:
888:
882:
879:
877:
874:
873:
871:
867:
861:
858:
856:
853:
851:
848:
846:
845:Normalization
843:
840:
836:
833:
832:
830:
828:
824:
818:
815:
813:
810:
808:
805:
803:
800:
799:
797:
795:
791:
783:
780:
779:
778:
775:
773:
770:
768:
765:
764:
762:
760:
756:
750:
747:
745:
742:
740:
737:
735:
732:
730:
729:Administrator
727:
723:
720:
718:
715:
714:
713:
710:
708:
705:
703:
700:
698:
695:
693:
690:
688:
685:
683:
680:
678:
675:
673:
670:
668:
665:
664:
662:
658:
654:
647:
642:
640:
635:
633:
628:
627:
624:
616:
612:
608:
607:SIGMOD Record
601:
596:
592:
588:
584:
580:
576:
572:
568:
564:
560:
559:
547:
546:
539:
532:
531:
524:
517:
516:
509:
501:
500:NetApp BlueXP
497:
490:
486:
475:
472:
470:
467:
465:
462:
459:
456:
453:
450:
447:
444:
441:
438:
436:
433:
431:
430:Network model
428:
426:
423:
421:
418:
416:
413:
411:
408:
406:
403:
401:
398:
397:
391:
382:
378:
375:
371:
367:
362:
360:
356:
352:
348:
344:
341:, MySQL from
340:
336:
331:
329:
325:
321:
317:
307:
305:
301:
297:
291:
287:
285:
281:
277:
266:
262:
258:
256:
245:
238:
234:
230:
227:, Siebel and
226:
222:
218:
215:such as ERP (
214:
211:
207:
204:
200:
196:
192:
189:
184:
183:
182:
171:
168:
165:
162:
158:
155:
152:
149:
146:
143:
140:
136:
133:
130:
127:
126:
120:
118:
114:
110:
106:
102:
98:
94:
84:
81:
73:
63:
59:
53:
52:
46:
41:
32:
31:
19:
1420:
1043:
1033:
1023:Log shipping
967:Online music
952:Biodiversity
919:Preservation
667:Requirements
610:
606:
570:
566:
544:
538:
529:
523:
514:
508:
499:
489:
435:Object model
388:
379:
370:Data Palette
363:
332:
313:
300:Data Palette
292:
288:
272:
263:
259:
251:
242:
180:
92:
91:
76:
67:
48:
1540:WikiProject
1431:Replication
1319:Transaction
1261:Foreign key
1241:CAP theorem
1188:Multi-model
1040:WikiProject
869:Programming
860:Cardinality
855:Refactoring
707:Application
567:SIGIR Forum
219:) and CRM (
62:introducing
1555:Categories
1405:Query plan
1358:Components
1276:Unique key
1193:comparison
1127:comparison
1117:Relational
1110:comparison
1013:Publishing
947:Biological
890:Management
717:datasource
712:Connection
481:References
372:suite and
359:Kubernetes
339:PostgreSQL
229:PeopleSoft
195:data model
70:March 2011
45:references
1414:Functions
1349:Partition
1176:In-memory
1134:Key–value
1008:Load file
924:Integrity
914:Migration
841:notation)
812:Forensics
759:Languages
573:(4). ACM
366:Stratavia
351:Microsoft
306:Clarity.
296:Stratavia
210:3rd party
119:or DBAs.
1520:Category
1436:Sharding
1292:Relation
1266:Superkey
1221:Database
1214:Concepts
1050:Category
981:See also
942:Academic
934:Lists of
839:Enhanced
794:Security
653:Database
591:16601739
448:(ORDBMS)
442:(OODBMS)
394:See also
276:SQL*Plus
1530:Outline
1329:Trigger
1285:Objects
907:caching
734:Synonym
692:Machine
460:(RDBMS)
335:MongoDB
105:IBM Db2
58:improve
1344:Cursor
1302:column
1171:NewSQL
962:Online
902:Tuning
850:Schema
827:Design
702:Server
697:Engine
682:Models
672:Theory
589:
345:, and
343:Oracle
239:, etc.
101:Oracle
47:, but
1334:Index
1297:table
1200:Cloud
1166:NoSQL
1161:Graph
1098:Types
837:(and
807:Audit
777:Query
749:Tools
744:Types
613:(2).
603:(PDF)
587:S2CID
454:(RBA)
349:from
177:Types
1385:ODBC
1375:JDBC
1314:View
1251:Null
1246:CRUD
1226:ACID
1181:list
1144:list
1122:list
739:Lock
660:Main
302:and
107:and
1380:XQJ
1307:row
722:DSN
579:doi
474:SQL
368:'s
298:'s
1557::
611:35
609:.
605:.
585:.
569:.
565:.
498:.
337:,
282:,
163:).
103:,
1083:e
1076:t
1069:v
645:e
638:t
631:v
617:.
593:.
581::
571:7
502:.
190:.
83:)
77:(
72:)
68:(
54:.
20:)
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.