Unit of competency Outline
Date retreived
22/07/2026 11:21 PM AWST
22/07/2026 11:21 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.
Integrate database with online game
Integrate database with online game
Unit of competency
National Code
ICAGAM527A
ICAGAM527A
State Code
D7830
D7830
TGA Status
Replaced
Replaced
DTWD Status
Replaced
Replaced
State Implementation and Classification
Approved Date
04/11/2011
Field of Education
020303 - Database Management
Original Release Date
04/11/2011
Nominal Hours
30
Description
This unit describes the performance outcomes, skills and knowledge required to integrate a database with an online game, where the relationship between the game server and the database server is also considered a client-server relationship on a local area network.
Notes
Elements and Performance Criteria
1. Install application programming interfaces (APIs) suitable to the game’s data source provider
- 1.1 Research appropriate APIs
- 1.2 Identify specific APIs as suitable for the game architecture and data source provider
- 1.3 Install nominated APIs on game development computers
2. Define and use a connection to the data source
- 2.1 Define game data source connection parameters
- 2.2 Store connection parameters in external text-based configuration file
- 2.3 Open and close connection to the game data source
3. Configure and use connection pooling
- 3.1 Configure connection pooling in the database management system
- 3.2 Define connection pool parameters for minimum connections, maximum connections and idle connections
- 3.3 Minimise use of database resources through the use of connection pooling
- 3.4 Test and verify use of connection pooling
4. Pass embedded structured query language (SQL) to the database
- 4.1 Define database connection property
- 4.2 Compose SQL statement or command to be passed to the database
- 4.3 Test, debug and execute the SQL statement
5. Execute a stored procedure on a database
- 5.1 Call a stored procedure on the database using command callable statement
- 5.2 Define and pass parameters to the stored procedure
- 5.3 Test, debug and execute database stored procedure
6. Modify database data
- 6.1 Retrieve multi-row multi-column result sets from the database into the game application domain
- 6.2 Insert new records into the database
- 6.3 Update existing database records
- 6.4 Delete existing database records
7. Integrate data from the database with the game application domain
- 7.1 Integrate data from a forward-only and read-only cursor into the game application domain
- 7.2 Incorporate data from an updateable cursor into the game application domain
8. Test and debug database integration code
- 8.1 Test database integration code
- 8.2 Document test results
- 8.3 Determine errors and exceptions and document solutions
- 8.4 Debug all errors and exceptions
- 8.5 Assess all data modifications in the database and document any errors
- 8.6 Correct all causes to data modification errors
The range statement relates to the unit of competency as a whole. It allows for different work environments and situations that may affect performance. Bold italicised wording, if used in the performance criteria, is detailed below. Essential operating conditions that may be present with training and assessment (depending on the work situation, needs of the candidate, accessibility of the item, and local industry and regional contexts) may also be included.
Data source provider may include:
DB2
Infomix
Ingres
Microsoft Access
Microsoft SQL (MS SQL) server
Mini SQL (mSQL)
MySQL
Oracle
Sybase.
External text-based configuration file may include:
any text-based file format that will not require re-compilation if properties of the connection to the database change
in ASP.Net, framework the web configuration (web.config) file and machine configuration (machine.config) file
files formatted as eXtensible markup language (XML) files or documents
traditional ASCII-based text files with file extension of .ini.
Parameters may include:
data type property appropriate to the data source provider
direction property defining either input or output
value property derived from the actual game play.
Forward-only and read-only cursor may include:
data-reader object
forward-only record set
Java forward-only result set.
Updateable cursor may include:
data-set object
record-set object
result-set object.
Data source provider may include:
DB2
Infomix
Ingres
Microsoft Access
Microsoft SQL (MS SQL) server
Mini SQL (mSQL)
MySQL
Oracle
Sybase.
External text-based configuration file may include:
any text-based file format that will not require re-compilation if properties of the connection to the database change
in ASP.Net, framework the web configuration (web.config) file and machine configuration (machine.config) file
files formatted as eXtensible markup language (XML) files or documents
traditional ASCII-based text files with file extension of .ini.
Parameters may include:
data type property appropriate to the data source provider
direction property defining either input or output
value property derived from the actual game play.
Forward-only and read-only cursor may include:
data-reader object
forward-only record set
Java forward-only result set.
Updateable cursor may include:
data-set object
record-set object
result-set object.
The evidence guide provides advice on assessment and must be read in conjunction with the performance criteria, required skills and knowledge, range statement and the Assessment Guidelines for the Training Package.
Overview of assessment
Critical aspects for assessment and evidence required to demonstrate competency in this unit
Evidence of the ability to:
add database functionality to an online game
display and modify the database data provided by game-play input.
Context of and specific resources for assessment
Assessment must ensure access to:
game design specification and requirements documentation
game server
database server
integrated development environment software and hardware
browsers for browser-based games
game consoles for console-based games
appropriate learning and assessment support when required
modified equipment for people with special needs.
Method of assessment
A range of assessment methods should be used to assess practical skills and knowledge. The following examples are appropriate for this unit:
evaluation of an online game that can access, display and update game state data stored in a database
verbal and written questioning to assess the knowledge associated with the integration of a database with an online game.
Guidance information for assessment
Holistic assessment with other units relevant to the industry sector, workplace and job role is recommended, where appropriate.
Assessment processes and techniques must be culturally appropriate, and suitable to the communication skill level, language, literacy and numeracy capacity of the candidate and the work being performed.
Indigenous people and other people from a non-English speaking background may need additional support.
In cases where practical assessment is used it should be combined with targeted questioning to assess required knowledge.
Overview of assessment
Critical aspects for assessment and evidence required to demonstrate competency in this unit
Evidence of the ability to:
add database functionality to an online game
display and modify the database data provided by game-play input.
Context of and specific resources for assessment
Assessment must ensure access to:
game design specification and requirements documentation
game server
database server
integrated development environment software and hardware
browsers for browser-based games
game consoles for console-based games
appropriate learning and assessment support when required
modified equipment for people with special needs.
Method of assessment
A range of assessment methods should be used to assess practical skills and knowledge. The following examples are appropriate for this unit:
evaluation of an online game that can access, display and update game state data stored in a database
verbal and written questioning to assess the knowledge associated with the integration of a database with an online game.
Guidance information for assessment
Holistic assessment with other units relevant to the industry sector, workplace and job role is recommended, where appropriate.
Assessment processes and techniques must be culturally appropriate, and suitable to the communication skill level, language, literacy and numeracy capacity of the candidate and the work being performed.
Indigenous people and other people from a non-English speaking background may need additional support.
In cases where practical assessment is used it should be combined with targeted questioning to assess required knowledge.
Replaced By
| State Code | National Code | Title | Type |
|---|---|---|---|
| AUT98 | ICTGAM527 | Integrate database with online game | Unit of competency |
| State Code | National Code | Title | Type |
|---|---|---|---|
| D568 | ICA50211 | Diploma of Digital and Interactive Games | Qualification |
| D567 | ICA50111 | Diploma of Information Technology | Qualification |