Page Comparison

Info
Data models are currently saved in `\\tc4s0a\Groups\AARA\AARAD\DBA\<APP_NAME>\Data Model\` Stored procedures/packages are at http://tfsprod:8080/tfs/CivAv/CivAv_Database/_versionControl

Software
TOAD	To access the database, run scripts, etc.
erWin	To update data models for Data Management approval

...

Reference Documents
Access to Database Passwords	Access to Database Passwords
DBA Tasks	DBA process and tasks
ERWIN Guide	ERWIN

guide

GUIDE
Data Management Naming Conventions for Data Models - Quick Reference Guide	RDIMS #1079406
Generate Data Dictionary for Data Model	ERWIN Reports Guide
Materialized Views problem	Materialized Views problems

...


Civil Aviation Database Inventory	RDIMS #5701284
Multi Tier Schema Model	RDIMS #6239283
ADTM Application Database Development Process	RDIMS #6288333
Oracle Developer Standards	RDIMS #6628382
PL/SQL Unit Testing	\\tc4s0a\groups\AARA\AARAD\DBA\Unit Testing\Doc\index.html

Relevant Emails

DBA Group

Data Management Team

Contacts
TCDIR database (MV001 table is a view from this DB)	Sandy MacPherson

Expand

title	How to make data model changes and move them through the environments

...

GUIDE document)
Check in data model back to TFS
Send data model to DMI for review
If the data model gets rejected, DMI will send back an RDIMS doc detailing the problems
- Negotiate some of the problems with DMI and correct the rest. Update the doc and send the corrected data model to DMI again. This process might take several rounds depending on the volume and complexity of the changes.
DMI will send an email letting us know when they approve the data model
Save the new approved data model under: \\tc4s0a\Groups\AARA\AARAD\DBA\CCARCS\Data Model
Move the previous approved data model to: \\tc4s0a\Groups\AARA\AARAD\DBA\CCARCS\Data Model\Archive
Generate the scripts using erWIN (refer to ERWIN

...

GUIDE document for steps). Carefully review the script as sometimes there are adjustments that need to be made.
Save scripts in: \\tc4s0a\Groups\AARA\AARAD\DBA\<APP_NAME>\Change Management
Comment out to the DROP table command from the script
Run the scripts in DEV.
- If errors occur while executing the script, cancel the script and save the output to analyze the errors and fix them. Resume running the script until no errors.
To move these changes to Acceptance / Production, open a change request (scheduled for, at minimum, 3 business days later).
- Acceptance change: Script will need to be sent to DMI team for review.
- Production change: In the plan, indicate that DMI will need to get the script from the ACC change.

Versions Compared