Υλοποίηση βάσεως δεδομένων και ανάλυση στοιχείων για την κίνηση κεφαλαίων ναυτιλιακών ομίλων κατά την περίοδο 2012 -2016
Database implementation and data analysis on fund transfers of shipping groups during the period 2012-2016
View/ Open
Keywords
Βάσεις δεδομένων ; Επεξεργασία δεδομένων ; Ανάλυση δεδομένων ; Γραφική απεικόνιση ; Δημιουργία ερωτήσεωνAbstract
The purpose of this master thesis is to collect and analyze a data sample from the transfers of funds made by shipping groups during the period 2012-2016. The data for this study have been provided by a Greek Banking Group and specifically by the Group’s Shipping Division. During the period under consideration, in addition to the economic crisis that is affecting the global economy, there is also the capital controls from June 2015 for the Greek banking system and, by extension, the Greek economy.
To achieve the goal of this master thesis, the data were imported into a database that was created. The database was implemented with the MySQL Open Source Database Management System (DBMS). First the database was designed and built in the DBMS. Upon completion of the construction, the raw data of the sample were processed and in the appropriate format were imported in the database. Creating the DB, importing the data and extracting the information from the DB were done using the Structured Query Language (SQL).
Finally, from the SQL queries that ran in the DB, conclusions were drawn on the fund transfers for the analysis period, and using the Microsoft Excel spreadsheet application some of these results were presented with charts.