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

Download
2015
Balcıoğlu, Burak
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.

Suggestions

A Framework for sustainable urban mobility in historic urban landscapes: a proposal for antalya kaleiçi
Uluç, Aynur; Bilgin Altınöz, Ayşe Güliz; Restoration in Department of Architecture (2014)
The main subject of the thesis is the mobility systems in historic urban landscapes. In this respect, the aim of the thesis is to provide “a framework for Sustainable Urban Mobility (SUM) in Historic Urban Landscapes (HULs)” together with the process, principles and tools that will solve the mobility problems while contributing to conservation and promotion its values and significance. In this regard, the thesis is structured mainly in two parts. In the first part, the current mobility systems, existing pro...
Revealing and restrengthening the relation of memory places and heritage places: the case of the Hisarbaşı neighborhood in Milas
Usta, Esra Nur; Bilgin Altınöz, Ayşe Güliz; Conservation of Cultural Heritage in Department of Architecture (2018)
Most of the towns are the outcome of a continual historical development process, reflected as the existence of components of different layers in the contemporary urban space. Life and experiences of the inhabitants take place in this multilayered urban space. Hence, the existing urban space keeps history and personal stories alive. This coherence constitutes a relation between memories in minds of people and traces in their physical environment. The mnemonic effect of physical environment leads to identity,...
Intervening with landscape: a tool for urban conservation the case of Yahşibey, Bursa /
Arslan Sönmez, Gökçe; Bilgin Altınöz, Ayşe Güliz; Baş Bütüner, Funda; Conservation of Cultural Heritage in Department of Architecture (2016)
Historic urban sites are complex heritage places with various tangible and intangible values. Due to the ongoing life, they are subject to continuous change, which can lead to partial or total loss of their heritage values. Hence, urban conservation aims at developing responses to the changes in historic urban sites, while sustaining their tangible and intangible values. As for all the interventions in heritage places, urban conservation interventions should follow the main principles of 'reversibility', 'r...
Monitoring historic urban landscapes : MoSA: a monitoring system for Ayvalık-depots region /
Özbayar, Gürem Fahriye; Bilgin Altınöz, Ayşe Güliz; Restoration in Department of Architecture (2014)
This thesis aims to review the studies made so far on systematic monitoring in urban context and develop a general methodology which has the potential to be adapted to every historic urban landscape. With the defined aim, a literature survey is carried out, and the key terms defined and used so far in monitoring methodology are studied. The key terms and the information gained through the literature survey are developed into a methodology proposal, while being applied to the case of Ayvalık-Depots Region. M...
A Study for the conservation of Ertem olive-oil factory in Ayvalık /
Yıldız, Gözde; Şahin Güçhan, Neriman; Conservation of Cultural Heritage in Department of Architecture (2017)
Conservation and re-adaptation of industrial heritage has been a quite important aspect in the sense of continuity of the historic industrial character of the place for future generations. Industrial buildings usually lost their functions due to the fast technological developments and changing within production/consumption systems. This inevitable functional loss caused the obsolete structures which are regarded as industrial heritage. It is essential to conserve and recover the post-industrial landscapes t...
Citation Formats
B. Balcıoğlu, “An Improved spatio-relational database design for urban conservation and its performance analysis,” M.S. - Master of Science, Middle East Technical University, 2015.