Skip to content

Database Standards:

August 3, 2009

Database Standards:

The goal of the Database Standards is to document new databases and applications in a consistent manner across platforms. These methods and requirements should provide a template for better documentation and make it easier to identify objects during daily maintenance.
Here I have given some steps to follow any new database development.
1. The application and database documentation must be listed in the Global Index Notebook.
2. There must be an Entity Relationship diagram drawn with the entity and unique identifiers listed.
3. Each entity must have a definition written in paragraph form.
4. Each table must have a definition that may be identical to the corresponding entity.
5. Each column in a table must have a definition, a descriptor, a size, a domain, and a data type.
6. The column abbreviations used must be in the Data Management Abbreviation list.
7. There must be a Physical Diagram of the database that includes table and column names.
8. The data stored in a column must correspond to the column definition and domain.
9. The database must be backed up each workday (Monday-Friday).
10. All online updates to data in tables must be done via the use of stored procedures.
11. All customer and developer staff use rids for ORACLE and IDMS databases on the OS/390 must be authenticated by RACF.
12 .All databases must have separate development, test, and production environments.

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: