Week 8 Case Study: Database Development

1369 words 6 pages

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


  • Login/Logout System
    3548 words | 15 pages
  • Litterature Review on Railway Reservation System
    3640 words | 15 pages
  • Strategic Management and changes to a caravan park
    6291 words | 26 pages
  • Strategic Evaluation Document for Boots
    5152 words | 21 pages
  • Analysis of Good Will Hunting
    4249 words | 17 pages
  • Subway Restaurants
    21316 words | 86 pages
  • Diversity Training in the Workplace
    6948 words | 28 pages
  • Jamba Juice Case Study
    1243 words | 5 pages
  • Cis 500 Complete Course Cis500 Complete Course
    2475 words | 10 pages
  • Exm 2557 Submit
    11671 words | 47 pages