Template based relation database creator for mining industry
Independent thesis Advanced level (degree of Master (One Year)), 20 credits / 30 HE creditsStudent thesis
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.
Place, publisher, year, edition, pages
IT, 12 031
Engineering and Technology
IdentifiersURN: urn:nbn:se:uu:diva-179276OAI: oai:DiVA.org:uu-179276DiVA: diva2:544021
Risch, ToreBol, Roland