DEVELOPMENT OF RURAL ARCHITECTURE – DESIGN AND CREATION OF A WEB DATABASE
DOI:
https://doi.org/10.14311/CEJ.2020.04.0042Keywords:
Database, Data model, Web portal, Rural architectureAbstract
The article deals with the design of database structures of a web application for the presentation of information about the development of rural architecture in the 19th and 20th centuries in the territory of today's Czech Republic. The processes of data structure design, description of the chosen solution and method of implementation are presented. The solution used is based on freely available technologies and applied to the creation of a smaller web portal. The described methods can be inspiring for similar types of web presentations, which are a frequent output of many activities and projects.
The created web application contains various types of data: maps of selected villages, spatial models of selected rural buildings, their floor plans, created orthophoto, photo gallery, and other textual and graphical information documenting the development of rural architecture. Objects of interest are located on the used interactive map. The application allows users to search and filter the required data. The technological solution is based on the PostgreSQL database and the PHP Nette framework. The created portal presents interesting information about important values of rural architecture, which can be considered as a part of the cultural heritage. The web portal can be used by experts and the general public.
Downloads
References
Hůrková L., Mezihoráková K. (eds.), 2018. Proměny venkovské architektury s důrazem na vývoj v 19. a 20. století I. Texty: Ludmila Hůrková, Klára Mezihoráková, Dalibor Prix, Tomáš Valeš, Marie Platovská, Kateřina Dolejší, Jan Uhlík, Markéta Svobodová, Pavel Vlček. First edition in Czech, English summary, 311 pp. Prague, Artefactum 2018, ISBN: 978-80-88283-14-0
Poloprutský Z., Soukup P., Gruber J., 2017. Development of rural settlements in the 19th and 20th centuries: creation of analytical map outputs. In: 18th International Conference Dějiny staveb 2017. Pilsen, Czech Republic, 2017, 235–243, in Czech. ISBN 978-80-87170-52-6.
Poloprutský Z., 2018. Metric Survey Documentation as a Basis for Understanding the Development of Rural Architecture. The Civil Engineering Journal, Prague 2018, 27(1), 48-59. ISSN 1805-2576. DOI 10.14311/CEJ.2018.01.0005.
Hodač J., Zemánková A., 2018. Historical Orthophotos Created on Base of Single Photos - Specifics of Processing. Civil Engineering Journal, Prague 2018, 3, 425-438. ISSN 1805-2576. DOI 10.14311/CEJ.2018.03.0034.
Jílková P., Cajthaml J., 2019. Database of Historical Atlases: An Interactive Web Application. In: Proceedings of the International Cartographic Association. Tokyo: International Cartographic Association, 2019, vol. 2. ISSN 2570-2092.
Liu F., Yu C., Meng W., Chowdhury A., 2006. Effective keyword search in relational databases. In: Proceedings of the 2006 ACM SIGMOD international conference on Management of data (SIGMOD '06). ACM, New York, NY, USA, 563-574. DOI 10.1145/1142473.1142536.
Padhy R. P., Patra M. R., Satapathy S. C., 2011. RDBMS to NoSQL:Reviewing some Next-Generation Non-Relational database’s. International Journal of Advanced Engineering Science and Technologies, 11(1), 015 – 030, ISSN: 2230-7818.
Hills T., 2016. NoSQL and SQL Data Modeling: Bringing Together Data, Semantics, and Software, ISBN 9781634621113 Technics Publications.
Cattell R., 2011. Scalable SQL and NoSQL data stores. SIGMOD Rec. 39, 4 (May 2011), 12-27. DOI: https://doi.org/10.1145/1978915.1978919.
Downloads
Published
Issue
Section
License
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).
