An improved spatio-relational database design for urban conservation and its performance analysis


Tezin Türü: Yüksek Lisans

Tezin Yürütüldüğü Kurum: Orta Doğu Teknik Üniversitesi, Mimarlık Fakültesi, Mimarlık Bölümü, Türkiye

Tezin Onay Tarihi: 2015

Tezin Dili: İngilizce

Öğrenci: BURAK BALCIOĞLU

Asıl Danışman (Eş Danışmanlı Tezler İçin): Ahmet Coşar

Eş Danışman: Ayşe Güliz Bilgin Altınöz

Özet:

The conservation of historic urban areas is multi-faceted and multi-disciplinary decision-making process. There are different types of data that are useful for understanding historical settlement and making decisions that will help conserve and revitalize historical and cultural values. It is important to integrate these different kinds of data in a single place (web-based application with database) and enable sharing of data with different actors and stakeholders (municipality, conservation council, residents, etc.). While, Conservation Councils of Cultural Properties and Municipalities are effective participants in the decision-making process; on the other hand, stakeholders are affected as a result of decisions taken by various governmental institutions. Databases are one of the important systems to control data redundancy and maintain the data consistency. They provide many advantages such as data integration which helps easy in retrieving data, updating data and sharing. In this thesis, we use different kinds of data prepared within CDP (Conservation Development Plan) project such as vector maps, aerial and satellite photographs, relational databases, thematic analysis maps, spreadsheets, documents and archive files of historical Odunpazarı. These data have been obtained from various institutions and integrated in a Web-based GIS application for efficient decision making and management of a historical town. Then, obtained data and documents will be published via Internet to target stakeholders. Original database had an unsuitable design for using in web-based application and needed to be improved for better and faster database query performance. In this thesis, an improved database was designed and query performance was measured comparing to original database. Web-based GIS can be a very useful tool in developing web-based user interfaces that can present useful information about historical and cultural sites to individuals as well as government institutions which must use information while making planning decisions. In this thesis, a survey was made about web-based GIS usage in urban conservation as a web-based tool. Also the capability of the web-based GIS in urban conservation was examined. By improving a web-based urban conservation tool, an efficient web-based GIS bringing various types of data together and sharing them with different stakeholders was realized. In order to make best use of a centralized web-based system, the implementation of web-based urban conservation tool has been developed as a server-side application consisting of a web server and database server. Different kinds of programs and software libraries mostly open source have also been used for this application. The improved database design and the web-based application have shown that, with the help of Internet; members of the institutions and stakeholders can easily access all kinds of data in a single web site by using the developed web-based GIS application. Web-based GIS application is expected to improve the accuracy and speed of decision-making and also makes the whole process easier. Because of these abilities, web-based GIS have been expanding rapidly in the recent years and it is a valuable tool for the field of urban conservation.