I am creating a database and that i would appreciate suggestions on maintaining data that describes the tables, characteristics, etc. I'll create a Database Design Document, however i want something that may be more helpful for upgrading changes towards the database schema.

I just read an article that indicates utilizing a Data Dictionary in YAML or JSON, however i haven't found anything else regarding the subject.

My questions are: "What options to data dictionaries exist for monitoring this data?"


"Out of your professional experience, what's the easiest method to maintain this data?"



You will probably find the comment functionality helpful, e.g.:

comment on table foo is 'some comments go here';

Found this link about source determining your databases lately and thought it could help someone later on. Get your database under version control

Also this link that we pointed out earlier Data Dictionaries