Performance Tuning (COMP 0343A)-Fall-16-CW1 (ASSMNT)-QP COMP 0343A Page 1 of 8 Fall 2016 Individual Assignment No. 1 Performance Tuning (COMP 0343A) Last Date of Submission: Saturday, 26th November, 2016, 11:55 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. 5th , November 2016 (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 link available in Moodle. 10 Task # 2 Consider you have joined as a Database Administrator in a software development company. You have been assigned the role of designing a new application to be developed. a) Discuss at least three design areas you would focus to improve the performance of database. 36Performance Tuning (COMP 0343A)-Fall-16-CW1 (ASSMNT)-QP COMP 0343A Page 2 of 8 b) Discuss the goals for tuning the server operating system and at least three areas that are normally tuned. Note:  The solution must be written in a maximum of 4 pages.  Solution must be in your own words.  Relevant examples of your own and necessary SQL commands should be given. 24 Task # 3 The web link to the following Oracle White Paper is given in the college Moodle web page: Colgan, M., "Oracle Database In-Memory Option", Oracle Corp., 2014. Discuss how the Oracle database in-memory option is used to improve the performance of analytic queries. Note: The solution for the task-3 must be given in your own words with relevant examples not exceeding 2 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.. 30 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.Performance Tuning (COMP 0343A)-Fall-16-CW1 (ASSMNT)-QP COMP 0343A Page 3 of 8 • Correct information analysis and presentation in document form. • Adequate referencing and citation provided • 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 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 bePerformance Tuning (COMP 0343A)-Fall-16-CW1 (ASSMNT)-QP COMP 0343A Page 4 of 8 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: Clarification on Plagiarism Policy As per MEC policy, any form of violation of academic integrity will invite severe penalty. Plagiarised documents, in part or in whole, submitted by the students will be subject to this policy. A. First offence of plagiarism a.) A 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.) Mark deduction: When the work is resubmitted, the marking will be undertaken according to the marking criteria. In compliance with this policy, the 25% deduction is then made on the marks obtained. For example, in an assessment that carries a maximum of 50 marks, suppose a student were to obtain 30 marks for the resubmitted work, the final marks for that assessment will be 22.5 (after deducting 25% of the marks actually obtained for the resubmitted work). c.) Period of resubmission: The student will have to resubmit the work one week from the date he or she is advised to resubmit. For example, if the formal advice to resubmit wasPerformance Tuning (COMP 0343A)-Fall-16-CW1 (ASSMNT)-QP COMP 0343A Page 5 of 8 communicated to the student on a Sunday (latest by 5 pm), the student will have to resubmit the work latest by next Sunday 5 pm. d.) If the re-submitted work is also detected to be plagiarized, then the work will be awarded a zero. e.) Resubmission of the work beyond the maximum period of one week will not be accepted and the work will be awarded a zero. B. Any further offence of plagiarism a.) If any student is again caught in an act of plagiarism during his/her course of study (either in the same module, same semester or in any other semester), the student will directly be awarded zero for the work in which plagiarism is detected. In such cases, the student will not be allowed to re-submit the work. C. Guidelines a.) Type 1: In case plagiarism is detected in any component or part submission (submitted at different times) of one assessment (assignment), the deduction in marks will be applicable for the whole assessment (assignment), even if only the component or part submission alone needs to be resubmitted. b.) Type 2: In case plagiarism is detected in a group assessment, all students of the group will be considered as having committed an act of plagiarism irrespective of whether plagiarism is on account of the act of all or a few or only one member. The policy will then be applied to all students. c.) Type 3: Combination of Type 1 and Type 2: In case plagiarism is detected in any component or part submission (submitted at different times) of a group assessment (assignment), the deduction in marks will be applicable for the whole assessment (assignment), even if only the component or part submission alone needs to be resubmitted. All students of the group would be considered as having committed an actPerformance Tuning (COMP 0343A)-Fall-16-CW1 (ASSMNT)-QP COMP 0343A Page 6 of 8 of plagiarism irrespective of whether plagiarism is on account of the act of all or a few or only one member. The policy will then be applied to all the students of the group. d.) Type 4: Variation of Type 1 and Type 2: In cases where the assessment consists of components or part submissions that could be a group assessment component (e.g. group assignment) and an individual assessment component (e.g. individual reflection), the following will be applicable: 1. If plagiarism is detected in the group assessment component, all students of the group will be considered as having committed an act of plagiarism, irrespective of whether plagiarism is on account of the act of all or a few or only one member. The policy will then be applied to all students of the group. In such cases the group assessment component will be resubmitted as per the policy. 2. If plagiarism is detected in the individual assessment component, the individual assessment component will be resubmitted as per the policy. The policy will then be applied to that student alone. 3. In both cases (a) and/or (b), the deduction in marks will be applicable for the whole assessment (assignment). D. Amount of similar material a.) The total amount of similar material in any form of student work from all sources put together should not exceed 30% (including direct quotations). b.) The total amount of quoted material (direct quotations) in any form of student work from all sources put together should not exceed 10%. c.) The total amount of similar material in any form of student work from a single source should not exceed 7 percent. However, cases having a similarity of less than 7 percent in such cases may still be investigated by the faculty depending on the seriousness of the case. d.) If faculty member find enough merit in the case of a student work with a similarity (with a single source) of more than 7 percent as not a case of plagiarism, the faculty member should provide detailed comments/remarks to justify the case.Performance Tuning (COMP 0343A)-Fall-16-CW1 (ASSMNT)-QP COMP 0343A Page 7 of 8 Late Submission Penalty for late submission – 5 % of the maximum mark specified for the assessment will be deducted for each working day. Assessment documents submitted beyond a period of one week after the last date of submission will not be accepted and will be marked as ZERO for the assessment. (Reference: Module Information Guide) Rules & Regulations  If any topic or diagram of an assignment is found copied from the other then marks will be deducted from both assignments.  Assignments with 3 or more identical topics will be awarded 0 Marks. Assessment Grading Criteria Refer section "Assessment Grading Criteria" in Module Information Guide. This assessment shall assess the following learning outcomes: Learning Outcomes Skills Acquired Analyse requirements for the construction of a database system based on an understanding of performance issues. Critical Thinking, Analytical, Comparing, Contrasting, Decision-making, Researching, Making judgment about complex issues, Communicate conclusions effectively. Gather and analyse data for database performance and tuning. Critical Thinking, Analytical, Cognitive, Interactive, Collaborative skills, Problem Solving, Evaluating Evidence, Practical Skills, Communicate conclusions effectively. Configure and tune a database for optimal performance Critical Thinking, Analytical, Comparing, Contrasting, Decision-making, Researching, Making judgment about complex issues, Communicate conclusions effectivelyPerformance Tuning (COMP 0343A)-Fall-16-CW1 (ASSMNT)-QP COMP 0343A Page 8 of 8 Assessment Sheet – Basic Assignment Analysis Student Id. and Name: Deliverables Aspects 0-10 Marks Task 1 Submission of work proposal  Objectives of the Assignment clearly identified: poor/ fair / clear  Initial understanding of Tasks -2 and Task-3: poor/fair/clear  Resources identified: poor/fair/clear Deliverables Aspects 0-10 10.5-24 24.5-36 Marks 2a Tune a database for optimal performance Poor / weak analysis/ poor concepts Few/some concepts are clear / incomplete analysis / partially done Very good / excellent analysis done Deliverables Aspects 0-7 7.5-16 16.5-24 Marks 2b Tune a database for optimal performance Poor / weak analysis/ poor concepts Few/some concepts are clear / incomplete analysis / partially done Very good / excellent analysis done Deliverables Aspects 0-9 9.5-22 22.5-30 Marks 3 Analyse, gather, configure and tune a database for optimal performance Poor / weak analysis some concepts are clear / incomplete analysis Good / Very good / excellent analysis done Detailed Comments / Feedback: Signature of Faculty Total Marks Penalty Final Marks\