Re: dbi cookbook for database administration

A few random ideas from my own experience:

Importing from raw data or other databases. Exporting to data warehouses.
Cleaning legacy data (Especially unnormalized data. See some inspirational material at Database normalization the easier way. Also, columns with multiple values, such as name and address in one field).
Using DBI with cron jobs. Security implications related to the cron user grants. How to test for a cron job with DBI (it works on the command line but fails at 2:00AM).
On the same vein, using the DBI in CGI or mod_perl scripts can lead to problems related to user authorizations. Many people here in the Monastery ask why their script runs fine interactively and fails when Apache takes over. (see Protecting your DBI user/password in scripts?)
I guess that data and schema movement also implies finding differences between databases and synchronizing them (see DBI -- Synchronize table diffs?).
It might be OT, but you may find some ideas from the MySQL Cookbook table of contents.

Good luck for your enterprise!

 _  _ _  _  
(_|| | |(_|><
 _|

Comment on Re: dbi cookbook for database administration

Replies are listed 'Best First'.
Re: Re: dbi cookbook for database administration by busunsl (Vicar) on Nov 08, 2002 at 07:00 UTC
Importing from raw data or other databases. Exporting to data warehouses. That goes into data and structure movement Using DBI with cron jobs. Along with using the DBI in CGI is a good idea, it will go to the new miscellaneous section. finding differences between databases and synchronizing them Yes, will be in data and structure movement I will have a look at the MySQL Cookbook. Many thanks! You made the first place in the contributors list ;-)	[reply]

Replies are listed 'Best First'.

Importing from raw data or other databases. Exporting to data warehouses.

That goes into data and structure movement

Using DBI with cron jobs.

Along with using the DBI in CGI is a good idea, it will go to the new miscellaneous section.

finding differences between databases and synchronizing them

Yes, will be in data and structure movement

I will have a look at the MySQL Cookbook.

Many thanks! You made the first place in the contributors list ;-)