Template based relation database creator for mining industry

• Main Author: Carlsson, Jan
• Format: Others
• Language: English
• Published: Uppsala universitet, Institutionen för informationsteknologi 2012
• Online Access: http://urn.kb.se/resolve?urn=urn:nbn:se:uu:diva-179276

The main parts of the production in the mining industry take place in different machines. These machines generate a big amount of data, which are being communicated, processed and stored for future processing. The mining industry goes through some changes in data processing. Today the main focus for the data processing is on the machines and the future goal is to redirect the main focus towards the mining technology. In the data processing this means standardization of the data processing so the data becomes uniform and easy to communicate between different processes. This system makes long time storage available for mining companies that use machines producing data exported  as XML documents described by an Iredes XML Schema. The system provides automatic translation of the XML Schema into a database schema, which can then be populated by data from the machines. The first problem was to find a system that could translate the template XML Schema required. The best translator found was XMLBeans that translates an XML Schema into Java classes. The developed system translates these classes into an SQL script which generates the schema for the database. The translation is automatic, requiring no manipulation of the template; just some settings in the external XMLBeans are required.