System Analysis

System Analysis - GROVE CITY COLLEGE System Specification...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
GROVE CITY COLLEGE System Specification Tim Su Team Gravic 2/15/2008
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
1.0 Introduction 1.1 Goals and Objectives This project is to create a program which is similar to Oracle’s TAF function. If an erroneous query is made by the user, the program will do the same query to the updated backup database and use that returned data. If the initial erroneous query returns a partial result, the program will also synchronize the original query’s result with the backup query’s result and return one, and only one, complete, desired result rather than having partial duplications. 1.2 System Statement of Scope Human users will not have any interaction with the program. The program should only interact with the main database and backup databases. The user will only see an error message stating that an error has occurred with the query. 1.3 System Context This program is intended to operate in the background without any action from the user. Ideally, the program would be universal to all database languages and be able to be used in between different ones. The main goal is that when there is an erroneous query, the program will take data from the main database and backup database and format the result of the query into one complete result, without duplicates. This would be especially important for large corporations with many branches across America, each having their own database. 1.4 Major Constraints
Background image of page 2
1.4.1 Specification Issues There are multiple database query languages we will have to work with 1.4.2 Design Issues There is only one college semester in which to finish this project. Time constraints will limit the design of the program. 1.4.3 Implementation Issues We will need to acquire data similar to that which Gravic Inc. will use this program for. 1.4.4 Testing Issues We will need to simulate errors in queries in order to test our program. We will also need to simulate databases and backup databases. 2.0 Functional and Data Description 2.1 System Architecture The user interacts with the database software (Oracle, MySQL, Access, etc.) and does not interact directly with the TAF program. The TAF program will take inputs from the database and its backup. The backup is kept updated by the replication program that is already in place. The TAF program will then output the formatted results. 2.1.1 System Architecture Diagram
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

System Analysis - GROVE CITY COLLEGE System Specification...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online