University of Twente Student Theses


Developing a data repository for the Climate Adaptive City Enschede

Planting, J (2018) Developing a data repository for the Climate Adaptive City Enschede.

[img] PDF
Abstract:This report describes the development of a suitable data repository for the CAC project. Background research was done in order to gain insight in the characteristics and pros and cons of the different classes of databases that exist: (old)SQL, NoSQL, and NewSQL. Some database management systems (DBMS) of each of the classes were compared, with focus on characteristics as data integrity, performance, and geospatial functionalities. The concept for the repository consist of the database and a generic interface. After setting up the requirements, the functional architecture was designed with the data repository consisting of a database, and three interfaces. One for each of the following roles, administrator, producer, consumer, which contain the required functionalities. The implementation of the database of the final prototype is done with the DBMS PostgreSQL, extended with PostGIS. This combination is a mature, reliable, and fast DBMS. The PostGIS extension offers the most extensive set of geospatial functionality of all DBMs. The interfaces are implemented using the Lumen php micro-framework.
Item Type:Essay (Bachelor)
Faculty:EEMCS: Electrical Engineering, Mathematics and Computer Science
Subject:54 computer science
Programme:Creative Technology BSc (50447)
Link to this item:
Export this item as:BibTeX
HTML Citation
Reference Manager


Repository Staff Only: item control page