Database Administration Database Management System Term Paper

Open, View, and/or
Download this Document

Total Length: 578 words ( 2 double-spaced pages)

Total Sources: 1+

Page 1 of 2

By grouping related database queries into transactions, DBMS systems can guarantee that each transaction satisfies the ACID properties: Atomicity, Consistency, Isolation, and Durability. However, if a database application is decomposed into transactions in an incorrect manner, the application may fail when executed concurrently.

Concurrency control deals with the issues involved with allowing multiple people simultaneous access to shared entities (Ambler, 2004). A collision occurs when two activities, which may or may not be full-fledged transactions, attempt to change entities within a system of record. A database administrator can either devise ways to avoid collisions or detect and then resolve them. Transactions are collections of actions that potentially modify two or more entities.

Stuck Writing Your "Database Administration Database Management System" Term Paper?

View All Our Example Database Administration Database Management System Term Paper

Have A Custom Example Essay Written

The easiest way for an application to implement transactions is to use the features supplied by the database. Transactions can be started, attempted, then committed or aborted via SQL code. Also, database APIs such as Java Database Connectivity and Open Database Connectivity provide classes that support basic transactional functionality.

A database administrator (DBA) performs all activities related to maintaining a successful database environment (Database Administrator, TechTarget). Responsibilities include designing, implementing, and maintaining the database system. The DBA also establishes policies and procedures pertaining to the management, maintenance, and use of the DBMS such as security and concurrency control discussed in this paper......

Show More ⇣

     Open the full completed essay and source list


OR

     Order a one-of-a-kind custom essay on this topic


sample essay writing service

Cite This Resource:

Latest APA Format (6th edition)

Copy Reference
"Database Administration Database Management System" (2004, November 28) Retrieved May 19, 2024, from
https://www.aceyourpaper.com/essays/database-administration-database-management-60046

Latest MLA Format (8th edition)

Copy Reference
"Database Administration Database Management System" 28 November 2004. Web.19 May. 2024. <
https://www.aceyourpaper.com/essays/database-administration-database-management-60046>

Latest Chicago Format (16th edition)

Copy Reference
"Database Administration Database Management System", 28 November 2004, Accessed.19 May. 2024,
https://www.aceyourpaper.com/essays/database-administration-database-management-60046
   

Open, View, and/or
Download this Document
order custom essay example