Unit of competency Outline

Date retreived
22/07/2026 1:42 PM 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.

Implement Object Relational Mapping Framework for data persistence

Implement Object Relational Mapping Framework for data persistence

Unit of competency
National Code
ICTPRG555
State Code
OBS88
TGA Status
Current
DTWD Status
Approved
Current Release Number
1.00
Current Release Date
21/07/2020
View on TGA
State Implementation and Classification
Approved Date
15/01/2021
Field of Education
020103 - Programming
Original Release Date
15/01/2021
Nominal Hours
55
Description
This unit describes the skills and knowledge required to implement an Object Relational Mapping (ORM) framework to map, retrieve and manage object persistence in any programming language.The unit applies to those working as senior software developers, senior back end developers or full stack developers, and responsible for managing Information and Communications Technology (ICT) in small-to-large enterprises (SMEs).No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Establish ORM project
  • 1.1 Confirm use, application and need for ORM framework according to business needs
  • 1.2 Review, select and implement ORM framework according to business needs
  • 1.3 Design, develop and build domain object model according to business needs
  • 1.4 Review and select data persistence technology for data store
  • 1.5 Create mapping between domain object model and selected data store
2. Retrieve and manipulate objects according to ORM framework
  • 2.1 Instantiate single object in domain model and persist in data store according to ORM framework
  • 2.2 Instantiate collection of objects in domain model and persist in data store according to ORM framework
  • 2.3 Retrieve objects from data store
  • 2.4 Update object and persist changes back to data store using ORM framework
  • 2.5 Delete data in data store
  • 2.6 Detach data and reattach data
  • 2.7 Implement eager loading of related domain
  • 2.8 Implement lazy loading of related domain objects
3. Manage transactions, concurrency and errors
  • 3.1 Handle transaction commits and rollbacks effectively according to ORM framework and business needs
  • 3.2 Handle data persistence and concurrency effectively according to ORM framework and business needs
  • 3.3 Implement and confirm error-handling
  • 3.4 Test and confirm transaction success according to business needs
No information
No information
No information
State Code National Code Title Type
BFG0 ICT50120 Diploma of Information Technology Qualification
BGJ4 ICT50220 Diploma of Information Technology Qualification