Running head: DATABASE DEVELOPMENT
Week 8 Case Study: Database Development
Professor – Dr. Hossein Besharatian
September 14, 2013
Table of Contents
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 planning is implemented is discussed. An in-depth analysis of an efficient method for planning concurrency control methods and lock granularities that are available to use that will minimize potential security risks that may occur. Finally, serializability isolation model is introduced that ensures transactions produce less record-level locking while operating the system and how a verification method allows review of proper inputs and error checks to increase consistency.
There are several Software Development Life Cycle methods that are availabel to utilize although, the Waterfall SDLC is the most desirable due to the simplicity and straight forward methods utilized and will be discussed in regards to topics in this paper. The benefits of this model type include departmentalization and manegerial control. A schedule can be set for each phase similarly to a how a factory system works from one step to the next in a proceeding manner until the product is complete. However, once in the testing phase it is difficult to revert back to make any additional changes. (SDLC Models., n.d.).
Tasks to Improve Dataset Quality Using SDLC Methodology
The Waterfall SDLC incorparates the following stages of planning and executing software, requirements specification, design, implementation, testing and maintenance. The requirements phase of the SDLC is to ensure clearly defined requirements via all parties involved in the processes. Deliverables in this stage include requirements documents that incorporates descriptions of requirements, diagrams and references to necessary documentation as well as Requirements Tracability Matrix (RTM), this displays the manner in which products being developed will interact and correlate to previous components that have already been developed. This phase prepares datasets integrity success throughout the SDLC process when requirements are properly defined. (The Software Development Cycle (SDLC)., n.d.).
The design phase lists software features in detail with psuedocode, entity-relationship model(s) (ERM), hierarchy diagrams, layout hierarchy, tables of business rules, a full data dictionary, and business process diagrams. This phase transforms the requirements into system design specifications. In this phase it is imporatant to review software and hardware specifications and system architecture. This will create the foundation for the implementation phase. Lastly, the implementation phase begins the coding process in which portions of programs are developed and tested. Clearly defined requirements are defined via use-case scenario that enables context based definitions and a visualization of the completed product for clarifications, accuracy, and completeness of requirement request. (SDLC Models., n.d.).
Actions to Optimize Record Selections and Improve Database Performance
Actions to optimize record selection and improve database performance include automated controls that can be applied in the design phase of SDLC. The design phase specifically it is important for developers to set proper automated controls such as input, processing, and output controls to enhance integrity, security, and reliability of the system and datasets. Input...
References: Data Concurrency and Consistency. (n.d.). Oracle Documentation. Retrieved September 12, 2013, from http://docs.oracle.com/cd/B10500_01/server.920/a96524/c21cnsis.htm
Even, A., & Shankaranarayanan, G. (2009). Quality in Customer Databases-Centered Review of Object Oriented Software Development Methodologies. ACM Computer Database, 15, 3,4,5. Retrieved September 12, 2013, from the ACM Computer database.
Ellis, R. (n.d.). Lock Granularity. Granularity of Locks_and Degrees of Consistency_in a Shared Database. Retrieved September 12, 2013, from www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=9&sqi=2&ved=0CF8QFjAI&url=http%3A%2F%2Fpages.cs.wisc.edu%2F~nil%2F764%2FTrans%2FGranularity.ppt&ei=kQ8yUqOhPIzl4AOM6oDIDw&usg=AFQjCNEdfijo3XG83N7W2WlglSi3cEJsQQ&sig2=WGLffPJ8amqYRjHXJAHLuQ&bvm=bv.52109
FFIEC IT Examination Handbook InfoBase - Design Phase. (n.d.). FFIEC IT Examination Handbook InfoBase - Welcome. Retrieved September 12, 2013, from http://ithandbook.ffiec.gov/it-booklets/development-and-acquisition/development-procedures/systems-development-life-cycle/design-phase.aspx
Rob, P., & Coronel, C. (2002). Database systems: design, implementation, and management (5th ed.). Boston, MA: Course Technology.
SDLC Models. (n.d.). One Stop QA. Retrieved September 12, 2013, from www.onestopqa.com/resources/SDLC%20Models.pdf
SqlCeEngine.Verify Method (VerifyOption) (System.Data.SqlServerCe). (n.d.). MSDN the Microsoft Developer Network. Retrieved September 12, 2013, from http://msdn.microsoft.com/en-us/library/cc835509%28v=vs.100%29.aspx
The Software Development Cycle (SDLC). (n.d.). Pelican Engineering. Retrieved September 13, 2013, from www.pelicaneng.com/DevDocs/sdlc.pdf
Please join StudyMode to read the full document