{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

System Analysis - GROVE CITY COLLEGE System Specification...

Info icon This 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
Image of page 1

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

View Full Document Right 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
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.
Image of page 3

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

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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern