Design and Implementation of Search System for Data Concerning Brownfields

Abstract

This diploma thesis describes the development of a software search system for data concerning brownfields and their revitalization methodology. The structure of brownfield data primary consisting of text provided the core aim of the diploma thesis to create a search system focusing on retrieving usable results from text data mainly using full-text search procedures and technologies. Results of the diploma thesis are going to be used by a research group working with brownfield revitalization methodology data. Author of the diploma thesis analyses the requirements of the research group to propose specific solutions and implementation of the full-text search system. The first proposed solution described by the diploma thesis uses Microsoft SQL Server relational database to develop full-text search system capability. Specific implementation procedures, pricing and technology deployment options for this solution are considered and included in the diploma thesis by the author. The second proposed solution by the author uses the Elastic Stack, a set of technologies consisting of Elasticsearch, Kibana and Logstash to develop a full-text search system for brownfield revitalization methodology data. Implementation details, technology deployment options and pricing of Elastic Stack implementation are described as part of the diploma thesis. The author also included in the diploma thesis a comparison of both proposed solutions together with recommendation on their usage with consideration of both current and potential future requirements for the full-text search system usage by the members of the research group, the end-users of given full-text search system.