Verified Document

Database Administration Database Management System Term Paper

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. 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.

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.
Bibliography

Ambler, S. (2004, April 1). Concurrency Control. Retrieved November 27, 2004 from Agile Data Web site: http://www.agiledata.org/essays/concurrencyControl.html#Collisions

Database Administrator. Retrieved November 27, 2004 from TechTarget Web site: http://searchdatabase.techtarget.com/sDefinition/0,sid13_gci214169,00.html

Database Management System. Retrieved November 27, 2004 from TechTarget Web site: http://searchdatabase.techtarget.com/sDefinition/0,sid13_gci213669,00.html

Database Security and Administration (2001). Retrieved November 27, 04 from Web site: http://www.urgrgcc.edu/shastri/.%5CDatabase%20Course%5Cdb1-2a.htm

Sources used in this document:
Bibliography

Ambler, S. (2004, April 1). Concurrency Control. Retrieved November 27, 2004 from Agile Data Web site: http://www.agiledata.org/essays/concurrencyControl.html#Collisions

Database Administrator. Retrieved November 27, 2004 from TechTarget Web site: http://searchdatabase.techtarget.com/sDefinition/0,sid13_gci214169,00.html

Database Management System. Retrieved November 27, 2004 from TechTarget Web site: http://searchdatabase.techtarget.com/sDefinition/0,sid13_gci213669,00.html

Database Security and Administration (2001). Retrieved November 27, 04 from Web site: http://www.urgrgcc.edu/shastri/.%5CDatabase%20Course%5Cdb1-2a.htm
Cite this Document:
Copy Bibliography Citation

Related Documents

Management System DBMS Is a Program That
Words: 1064 Length: 4 Document Type: Essay

management system (DBMS) is a program that provides the user with access to the data and also helps them in transforming their raw data into meaningful information. The database management system (DBMS) is therefore a collection of programs that helps in the management of data structure as well as in the control of access to the data that is stored in the database. The DBMS systems help users in

Database Security
Words: 2424 Length: 9 Document Type: Term Paper

Database Security The focus of this study is that of database security. Databases and database technology are such that play critical roles in the use of computers whether it be in business, electronic commerce, engineering, medicine, genetics, law, education or other such entities requiring the use of computer technology. A database is quite simply a collection of data that is related such as a database containing customer information, supplier information, employee

Database Shadowing or Mirroring What
Words: 2137 Length: 5 Document Type: Term Paper

This would also mean that the shadowing process goes on behind the scenes, and one need not even be aware that the process is in fact going on at any point of time; it can go on without creating any sort of disturbance to the user of the application, at any point of time. (Shadow Files) Another important advantage of using the shadowing of a database is that data would

Designing a Safety System Safety Management System
Words: 1790 Length: 7 Document Type: Essay

Designing a Safety System Safety management system is a management policy to prevent or minimize injury within a workplace. Top organizations across the United States are increasingly investing in safety management because of the general believe that safety is central precondition to market competitiveness and "an integral part of high quality business operations." (Tervonen, Haapasalo, & Niemela, 2009 P. 17). Safety is defined as a state where all the business related

Cloud Computing on Database Management
Words: 1390 Length: 4 Document Type: Research Paper

Cloud computing applications often need to have a 99.999% uptime as customers use them directly over the Internet, and there is little chance of solving problems from a remote location (McAfee, 2011). As a result, databases used in cloud computing must have a very high level of reliability and be capable of managing small errors that would cause other databases to stop working or need to be rebooted. The

What It Takes to Be a Database Administrator
Words: 1982 Length: 7 Document Type: Term Paper

Database Administrator What It Takes To Be A Database Administrator A database can be defined as an organized collection of data, most probably in digitized form. Data is organized within such databases primarily in such a way that it displays and supports the processing of the relevant aspects of the information as it is required by those who use the database. Databases are usually software management systems that are quite complex. The

Sign Up for Unlimited Study Help

Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.

Get Started Now