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.
|
PDF
9MB |
| 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: | https://purl.utwente.nl/essays/76159 |
| Export this item as: | BibTeX EndNote HTML Citation Reference Manager |
Show download statistics for this publication
Show download statistics for this publicationRepository Staff Only: item control page