perl application for bulk loading relational databases 
Author Message
 perl application for bulk loading relational databases

I have developed a perl program for transferring data from text tables
into relational databases, performing joins and lookups on the fly. If

"dbload" in the subject line.

The code currently works with Ingres databases, but should be very
easy to convert for others. It uses the DBI/DBD database module.

I've found it very useful for importing data from a variety of
formats, much easier than specifying ad hoc SQL for loading the
data. It should be useful for anyone trying to load tables into
heavily normalised databases where several joins have to be made. A
simple configuration file specifies matches, joins, lookups,
substitutions, and a variety of operations. Configuration files are
simple enough to be modifiable by a non-computing/SQL specialist.

If anyone else has already developed something along these lines, let
me know. Otherwise, email me for the code if you think you'd find it
useful.

---  

Computer Scientist                      +44(0)131 527 4477
Roslin Institute, Edinburgh, UK         http://www.*-*-*.com/



Sat, 29 Jan 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Looking for relational database in perl

2. RDB, a Relational Database Management System implemented in PERL

3. Perl OO persistence with relational database

4. perl and Relational Databases

5. Perl, NT, and relational databases

6. www and relational databases

7. Relational database for Windows/Windows 95/NT

8. Update, RDB, a Relational Database Manager

9. On FTP archive: RDB (Relational Database Management)

10. HTMLView 0.9 - make web interfaces to relational SQL databases

11. need relational database

12. Creating a key field for writing relational databases

 

 
Powered by phpBB® Forum Software