On-line nástroj pro konverzi různých datových formátů

Abstract

This thesis deals with the issue of transformation variety data structures (files) among themselves. This work also describes datatype CSV, XLS, XLSX, XML, JSON, YAML, NEON and SQL in derail. Moreover, there is basic description for followed SQL database systems - MySQL, Oracle, Microsoft SQL Server a PostgreSQL. This thesis solves issue of data format transformation and its solution. I have used programing language Java, it´s framework Spring MVC, Apache Tomcat (version 8) and few external JAR libraries, for implementation of this transformation application. The Amazon AWS web services were used to deploy the converter application implemented by myself. Developed solution enables conversion of input data format CSV, XLS, XLSX, XML, JSON or SQL to output data format CSV, XLS, XLSX, XML, JSON, SQL or YAML. Within transformation to SQL output format is connected automatic analysis of data types in input file. This analysis is then incorporate to output file.