Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 321
  • Last Modified:

database documentation

when you build a new oracle database from scratch, or inherit an oracle database from say an ERP applicaiton your company has purchased, what sort of documentation do you maintain on it, namely are there common terms used to describe documents that

1) detail all oracle database accounts - there purpose within the application,
2) and all tables/views in the database, what data they store, purpose etc.
0
pma111
Asked:
pma111
3 Solutions
 
DavidSenior Oracle Database AdministratorCommented:
To me, what you're describing are foundational documents, including a physical entity model.  The model should be able to able to relational integrity between the database objects (keys, indexes, dependencies).  In some shops the model precedes development, and must correspond to the business rules provided in the architecture.

Since you have purchased a packaged ERP system, this should have been already prepared.

Another aspect of a new build is the set of build documents required to create the database and its objects, their lifespan, disposal, etc.  aka the data definition content.

My personal passion pertains to the operational, or runtime documents. how to start, stop, backup, recover, monitor, and patch the database.
0
 
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
The steps for database creation with the  ERP product which you purchased and its configuration with aaplication, also any issues and its resolution at the time of installation .

The Backup strategy and its implementations steps as well as recovery steps in case of database corruption
0
 
Mark GeerlingsDatabase AdministratorCommented:
I would say that the answers to your two questions are usually very different, depending on whether the application was purchased or designed in-house.

With purchased applications, the documentation is usually whatever the vendor provides.  I've seen this vary widely with different vendors.

For "built from scratch" applications, the level of documentation can also vary widely, depending on how much emphasis or importance the organization places on documentation.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now