Individual Assignment No. 1 Performance Tuning (COMP 0343A) Last Date of Submission: Saturday, 22 nd April, 2017, 11:59 pm (7th Week) Total Marks: 100 (Scale down to 25) Note: Perform all tasks. 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 Marks Deliverables Answer the following questions with respect to Performance Tuning Task # 1 Submit a work proposal for this assignment by the end of week 4th i.e. 1 st 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. 10 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 36+30 Performance Tuning (COMP 0343A)-Spring-17-CW1 (ASSMNT)-QP COMP 0343A Page 2 of 7 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. 24 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 Performance Tuning (COMP 0343A)-Spring-17-CW1 (ASSMNT)-QP COMP 0343A Page 3 of 7 • Examples can be provided if needed 100 Guidelines Follow the guidelines mentioned below for your assignment:  Code developed (Soft Copy) should be included. Assignment must be submitted through Moodle and it will undergo plagiarism detection test through turnitin (a plagiarism detection tool).  Handwritten assignments / hard copy will not be accepted.  Use Page Number & proper References.  Assignment should have a Title Page. Title Page should contain the following information.  Assignment Name  Section Name  Student name  Student ID Number  Faculty Name  The Table of Contents Should have, each deliverable task number, content, page number  Assignment should be typed in your own words using Times New Roman font size 12.  Heading should be with Font Size 14, Bold, Underline  Feedback shall be given in Moodle within one week from the last date of submission of work proposal and within two weeks after submission of final assignment document. Note: DO NOT DIRECTLY COPY/PASTE FROM INTERNET/BOOKS! DO NOT COPY FROM ONE ANOTHER! PRODUCE YOUR OWN ASSIGNMENT SOLUTION REPORT. The work submitted must be your own and must not be based on inputs from others. Your assignments shall be Performance Tuning (COMP 0343A)-Spring-17-CW1 (ASSMNT)-QP COMP 0343A Page 4 of 7 submitted to electronic databases to identify plagiarism. If assignment is found to be plagiarised, action will be initiated. Please refer to MEC policy on plagiarism (given below). Plagiarism Policy: DO NOT DIRECTLY COPY/PASTE FROM INTERNET/BOOKS! DO NOT COPY FROM ONE ANOTHER! PRODUCE YOUR OWN ASSIGNMENT SOLUTION REPORT. The work submitted must be your own and must not be based on inputs from others. Your assignments shall be submitted to electronic databases to identify plagiarism. If assignment is found to be plagiarised, action will be initiated. Please refer to MEC policy on plagiarism the Student Handbook for more details: Plagiarism A. First offence of plagiarism a. If a student is caught first time in an act of plagiarism during his/her course of study in any assignment other than project work, the student will be allowed to re-submit the assignment once, within a maximum period of one week. However, a penalty of deduction of 25% of the marks obtained for the resubmitted work will be imposed. b. Period of re-submission: The student will have to re-submit the work one week from the date he or she is advised to re-submit. c. If the re-submitted work is also detected to be plagiarized, then the work will be awarded a zero. d. Re-submission of the work beyond the maximum period of one week will not be accepted and the work will be awarded a zero. e. If the student fails the module and has a proven case of academic integrity violation in this module , the student is required to reregister the module f. If plagiarism is detected in Project work (Project 1, Project Planning and Project Design and Implementation) the above clauses (a,b,c,d) do not apply and the work will be summarily rejected. In these cases the student will be awarded a fail (F) grade and is required to re-register the module B. Second offence of plagiarism Performance Tuning (COMP 0343A)-Spring-17-CW1 (ASSMNT)-QP COMP 0343A Page 5 of 7 a. If any student is caught second time in an act of plagiarism during his/her course of study (in a subsequent semester), the student will directly be awarded zero for the work in which plagiarism is detected. In such cases, the student