Tasks Objectives:
1. Analyse requirements for the construction of a database system based on an understanding of performance issues.
2. Gather and analyse data for database performance and tuning.
3. Configure and tune a database for optimal performance
Task # 1 Submit a work proposal for this assignment by the end of week 4th i.e. 1st April, 2017 (11:55 pm) which must include:
- Understanding of deliverables - a detail description of deliverables
- General overview of proposed plan - initial understanding of solution for the task-2 and task-3.
- Resources identified
The work proposal must be submitted in a word file through the Turnitin link available in Moodle.
Task # 2
a) Discuss the key decisions you would take while creating and configuring a new database which may impact the performance of the database.
Note: The solution must be in your words and should not exceed two pages. The solution should not contain the steps in creating the database.
b) The web link to the Oracle White Paper "Guide for Developing High Performance Applications" is given in the college Moodle web page: As a Database Administrator, discuss the key areas that can allow developers to enhance performance and scalability of applications. Note: The solution for the task-2b must be given in your own words with relevant examples not exceeding 3 pages. The given white paper is for your reference only and your answer should not be limited to this paper only. You may refer various other resources and provided references for the same. Do not simply copy and paste the information from the given white paper.
Task # 3 Discuss how you would analyze and gather statistics of schema objects like tables, clusters or index.
Note: Your solution must also include the necessary SQL commands. These commands must be executed in College Database Lab and include the screenshots for the same.
Evaluation Criteria:
There will be no marks without a viva. Viva will be used as a means to measure the originality of your work.
You would be evaluated on the following:
- Originality of answer, i.e. writing in your own words with some amount of referenced material.
- Oral examination: Your Assignment marks are based on the VIVA which will be conducted upon submission of assignment. The VIVA will be based on the tasks given in the assignment. ZERO marks will be awarded to the student if she / he is absent for VIVA.
- Correct information analysis and presentation in document form.
- Adequate referencing and citation provided