Week 8 Case Study: Database Development

1369 words 6 pages
Running head: DATABASE DEVELOPMENT

Week 8 Case Study: Database Development
Professor – Dr. Hossein Besharatian
CIS 512
September 14, 2013

Table of Contents

Abstract This paper defines the Software Development Life Cycle phases specifically the Waterfall method with a review of tasks to improve the quality of datasets throughout the cycle. It includes recommendations of actions to be performed for full optimization for enhancing performance from data quality assessment. Although full optimization may be reached throughout the process of SDLC, continued maintenance must be in sued to properly retain the database error-free and protected. An evaluation of three methods and activities to ensure maintenance
…show more content…
Granular locking schemes enable locking pages, tables, rows, and cells. After reviewing “Process-centered Review of Object Oriented Software Development Methodologies,” the methodologies mentioned were outside of the scope of concurrency and lock granularity. However, there are two methods, high granularity approach and low granularity approach that will enable a distributed database with consistency. High granularity offers maximum concurrency although requires more overhead versus low granularity which offers minimum overhead although reduces concurrency. Additional overhead in the form of locking granularly at different object-oriented hierarchy levels helps create proactive concurrency control within the system. This provides additional security via the ability to control which users are modifying the database at the same time. (Ellis, R., n.d.).

System Analysis to Ensure Tractions do not Record-Level Lock Database in Operation In multiuser database transactions that are executing simultaneously must have consistent results, it is vital to have control over concurrency and consistency. To enable processes that provide this control a transaction isolation model named, serializability is available for use. This model gives the illusion that transactions execute one at a time. The multiversion consistency model provides multiple users with a separate view of the data concurrently, which prevents record-level locking from affecting the

Related

  • Week 7 Case Study Contracts and Procurement
    2077 words | 9 pages
  • Rural Development Case Study
    3217 words | 13 pages
  • Mg 495 Week 3 Case Study
    4367 words | 18 pages
  • Week 5 Case Study: Investment Potential in the Healthcare
    1149 words | 5 pages
  • Jamba Juice Case Study
    1243 words | 5 pages
  • Bus 250 Week 1 Case Study a Brawl in Mickey Backyard
    1316 words | 6 pages
  • Week 3 Case Study Pacific Oil Company
    1351 words | 6 pages
  • Acct540 Week 7 Case Study
    1027 words | 5 pages
  • Case Study of a Childs Play and Development
    1946 words | 8 pages
  • Acct 212 Week 1-8 Discussion Questions
    1334 words | 6 pages