-2

What techniques do people use to upload data from a flat file into a normalised database? We are planning on using MySQL or MariaDB.

I have a number of large excel spreadsheets that I would like to import into a database. The files are in slightly different formats. We had thought of importing to a temporary table and preforming validation and data transformations on this temporary table. Then coding an sql script to insert the records in the the tables and child tables.

Is there anyway of speeding up or streamlining this process. This is a situation that I am going to have to repeat on a constant basis and I do not have any control over the format that the data is going to be provided in.

Any suggestions would be very much appreciated

0

You could investigate the MariaDB storage engine 'CONNECT'. It's in beta but could simplify your process. It is not OSX, however.

https://downloads.mariadb.org/mariadb/repositories/#mirror=somerset&distro=CentOS&distro_release=centos6-amd64&version=10.0

https://mariadb.com/kb/en/loading-the-connect-handler/

This storage engine permits you to read and write to 'other' data files. Take a look as it's a very interesting component.

| improve this answer | |

Not the answer you're looking for? Browse other questions tagged or ask your own question.