Unit of competency Outline

Date retreived
22/07/2026 10:32 AM AWST

Whilst all efforts are made to provide accurate and timely information from the relevant source/documentation, please be aware that the information supplied may not be the most current version. The accuracy of the detail has not been confirmed by the Department and therefore should not be relied upon without first confirming the contents.

Monitor physical database implementation

Monitor physical database implementation

Unit of competency
National Code
ICTDBS407
State Code
AUT49
TGA Status
Current
DTWD Status
Approved
Current Release Number
1.00
Current Release Date
25/03/2015
State Implementation and Classification
Approved Date
16/09/2015
Field of Education
020303 - Database Management
Original Release Date
16/09/2015
Nominal Hours
20
Description
This unit describes the skills and knowledge required to undertake database-management system modelling and to monitor database performance.It applies to database support staff required to test and scrutinise the operation of a physical database, in order to ensure that it functions as efficiently as possible.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Undertake database
  • management system modelling
  • 1.1 Review the database prototype as appropriate, to determine the acceptance criteria and performance standards
  • 1.2 Load the test data according to the technical sequence detailed in the relevant documentation
  • 1.3 Generate a test schedule for the database, of tasks to be performed and the results expected
2. Monitor database performance
  • 2.1 Evaluate database performance against the acceptance criteria and performance standards
  • 2.2 Identify discrepancies in the results, when the expected outcomes do not meet the acceptance criteria
  • 2.3 Identify areas needing enhancement, and document the changes to be made
  • 2.4 Modify the database according to project standards
  • 2.5 Repeat performance testing until the expected results are achieved
3. Seek client feedback and sign-off
  • 3.1 Present test results in a document, and provide to the client for feedback
  • 3.2 Incorporate client change requests as appropriate
  • 3.3 Obtain client sign-off to the monitoring process
No information
No information
Replaces
State Code National Code Title Type
D7771 ICADBS407A Monitor physical database implementation Unit of competency