Question by Huxton_Billbob: How can I best ingest xml data and audio files into a database which can output various formats of data?
I run the content department at an independent media company. We have to keep track of tens of thousands of audio files, as well as image files and metadata files in various formats that are associated with them. We also have to output files and data in even more different formats. We have been manually organising the system using excel and DOS batches, but it is getting to the stage where we need it to be more automated.
Is it possible to ingest XML/XLS data and other files all at once and add them to a database which manages data AND files? Or is this wishful thinking?
I don’t expect many people to understand what the hell I’m talking about… if you do though, please help!
Answer by Empanada
Most RDBMS systems provide a BLOB (binary large object) data type that can be used to store data files such as audio files. You can also store XML files in an associated table/column, but it would probably be best to transform the XML and import the data into the schema rather than simply store the XML so that the audio files are searchable. I’m not aware of any off-the-shelf applications to do specifically what you’re looking for, so you might need to write an application to perform the imports/exports to your database.
Give your answer to this question below!
- How much does it cost a company to convert their spreadsheet data to databases?
- I invented a method to quick getting data from a database, made it very very high: opinion?
- Posting data from a MySQL database into a form with PHP?
- ok i am trying to lessen data entry work, between excel and online database?
- Replace existing data & move recordset to next in database table?