Matlab Code and Database Design (creation) required.
2 Requirements: (1) Program in Matlab the automated extraction of data from XML files and upload data to MySQL database; (2) design relational MySQL database to house all data extracted from XML files.
There are example XML files and matlab files attached.
Background: The XML files represent fundamental (financial/stock market) data from Interactive Brokers (CompuStat). The database will need to be flexible and efficient as I will being storing the data for more than 5,000 individual companies.
(1) All code must be commented/documented. I will need the code to be flexible in order to ensure I can properly modify the code if there are any updates to the structure of the XML files.
(2) I'm thinking there should be more than 3 tables in total (3 XML files should result in more than 3 tables to ensure efficiency).
System Background: I'm working with Matlab 7.11.0 (R2010b) and do have the database toolbox.