From data collection to analysis: Designing a relational database for archaeological research in the eastern Rhodope region
DOI:
https://doi.org/10.57573/be-ja.13.99-114Keywords:
Archaeological relational database, spatial reference, PostgreSQL, PostGIS, organizing data, query analysisAbstract
This paper aims to demonstrate the potential of relational databases for archaeological purposes in storing, organizing, managing, querying, and analysis of various types of data. This results in exploration of the long-term settlement history of a regional landscape. The organization and analysis of spatial and non-spatial archaeological datasets pose significant challenges for archaeologists, particularly when it comes to integrating data from multiple sources, representing spatial relationships among data elements, and accommodating multiple scales of analysis. In recent years, advances in database technologies have enabled archaeologists to organize these datasets more effectively through the application of relational databases. This study focuses on the design of a relational database for the eastern Rhodope region in Bulgaria, with the further goal of investigating settlement patterns through the identification, mapping, and analysis of archaeological sites and their spatial relationships. The aim of this research is to explore how archaeologists can enhance their analysis of complex datasets by adopting relational database design, which enables effective organization and integration of data from various sources.
Downloads
References
Archaeological Map of Bulgaria 2023. Automated Information System “Archaeological Map of Bulgaria”, [Online], Available: http://www.naim-bas.com/akb/ (01.04.2023).
Baseynova direktsia “Iztochnobelomorski rayon”. Izsledvane za integrirano upravlenie na vodite v Republika Bulgaria, yuni 2006 – mart 2008, [Online], Available: https://earbd.bg/indexdetails.php?menu_id=294 (visited 10.10.2021) (in Bulgarian).
Cheetham, P. 1992. The archaeological database – New relations? In Lock, G., Moffett, J. (eds) Computer applications and quantitative methods in archaeology 91 (BAR International Series, S577). Oxford: Tempus Reparatum, 7–14.
Codd, E. 1970. A Relational Model of Data for Large Shared Data Banks. Communications of the Association for Computing Machinery 13.6, 377–387.
Conolly, J., Lake, M. 2006. Geographical Information Systems in Archaeology. Cambridge: Cambridge University Press.
Fisher, M. 1994. Applications in computing for social anthropologists. London and New York: Routledge.
Farinetti, E. 2009. Boeotian Landscapes: A GIS-based study for the reconstruction and interpretation of the archaeological datasets of ancient Boeotia (BAR international series, S2195). Oxford: Archaeopress.
Georgiev, V. 2007a. Zlatno nahodishte “Sedefche”. In Milev, V., Obretenov, N., Georgiev, V., Arizanov, A., Jelev, D., Bonev, I., Baltov, I., Ivanov, V. (eds) Zlatnite nahodishta v Bulgaria. Sofia: “Zemia 93”, 132–134 (in Bulgarian).
Georgiev, V. 2007b. Zlatno-polimetalno nahodishte “Chala”. In Milev, V., Obretenov, N., Georgiev, V., Arizanov, A., Jelev, D., Bonev, I., Baltov, I., Ivanov, V. (eds) Zlatnite nahodishta v Bulgaria. Sofia: “Zemia 93”, 124–129 (in Bulgarian).
Georgiev, V. 2007c. Zlatno-polimetalno nahodishte “Popsko”. In Milev, V., Obretenov, N., Georgiev, V., Arizanov, A., Jelev, D., Bonev, I., Baltov, I., Ivanov, V. (eds) Zlatnite nahodishta v Bulgaria. Sofia: “Zemia 93”, 137–138 (in Bulgarian).
Georgiev, P. 2012. Izdirvane na arheometalurgichni obekti v rayona na selata Chernichino, Popsko i Belopoltsi, obst. Ivaylovgrad. Arheologicheski otkritia i razkopki prez 2011 g. Sofia, 570–573 (in Bulgarian).
Georgiev, P. 2020. Terenni izdirvania v rayona na antichna vila “Armira”, v zemlishteto na selata Svirachi, Kamilski dol, Lambuh i Huhla, obsht. Ivaylovgrad. Arheologicheski otkritia i razkopki prez 2019 g. Sofia, 106–110 (in Bulgarian).
Georgiev, P., Popov, H. 2019. Terenni izdirvania za verifikatsia na rezultati ot vazdushno lazеrno skanirane (Airborne Lidar) v Iztochnite Rodopi. Arheologicheski otkritia i razkopki prez 2018 g. Sofia, 704–705 (in Bulgarian).
Keller, A. 2009. In defense of the database. The Society for American Archaeology archaeological record 9.5, 26–32.
Kostov, R., Chapman, J., Gaydarska, B., Petrov, I., Raduntcheva, A. 2007. Turquoise – archaeomineralogical evidence from the Orlovo prehistoric site (Haskovo district, Southern Bulgaria). Geology and Mineral Resources 14, 17–22.
Kostov, R. 2008. Geological and mineralogical background of the megalithic and rock-cut sites in Bulgaria and some other European countries. In Kostov, R., Gaydarska, B., Gurova, M. (eds) Geoarchaeology and Archaeomineralogy. Proceedings of the International Conference, 29–30 October 2008 Sofia. Sofia: St. Ivan Rilski, 163–168.
Kostov, R. 2010. Gem minerals and materials from the Neolithic and Chalcolithic periods in Bulgaria and their impact on the history of gemmology. In Christofides, G., Kantiranis, N., Kostopoulos, D. S., Chatzipetros A. (eds) Scientific Annals of the School of Geology. Proceedings of the XIX Congress of the Carpathian-Balkan geological association, special volume 100. Thessaloniki: Aristotle University of Thessaloniki, 391–397.
Kostov, R. 2013. Nephrite-yielding prehistoric cultures and nephrite occurrences in Europe: archaeomineralogical review. Haemus journal 2, 11–30.
Kostov, R., Pazderov, R., Mihaylov, L. 2016. Mineralogy and distribution of jasper artifacts from the Eastern Rhodope. In Yanev, Y. (ed.) National conference with international participation ‘Geosciences 2016’, Short communications. Sofia: Bulgarian Geological Society, 175–176 (in Bulgarian with English abstract).
Lock, G. 2003. Using computers in archaeology. Towards virtual pasts. London: Routledge.
Nekhrizov, G. 1994. Prinos kam prouchvaneto na skalnite grobnitsi v Iztochnite Rodopi. Minalo 2, 5–11 (in Bulgarian).
Nekhrizov, G. 2015. Dolmens and Rock-cut monuments. In Valeva, J., Nankov, E., Graninger, D. (eds) A Companion to Ancient Thrace. Chichester: Wiley-Blackwell, 123–143.
Nekhrizov, G., Tsvetkova, J., Kecheva, N. 2016. Gluhite kamani 2015: Lidar bazirani terenni izdirvania. Arheologicheski otkritia i razkopki prez 2015 g. Sofia, 876–878 (in Bulgarian).
Nekhrizov, G., Tzvetkova, J., Gencheva, V. 2019. Terenni izdirvania za verifikacia na rezultati ot vazdushno lazerno skanirane (Airborne Lidar) na teritoriyata na masiva Chala, obsht. Stambolovo, Iztochni Rodopi. Arheologicheski otkritia i razkopki prez 2018 g. Sofia, 701–704 (in Bulgarian).
Popov, H., Iliev, S. 2006. Antichni rudni razrabotki, zapaden sklon na Ada tepe. Arheologicheski otkritya i razkopki prez 2005 g. Sofia, 154–156 (in Bulgarian).
Popov, H., Tsintsov, S., Iliev, S. 2009. Metodi za terenna registratsia pri izdirvane na sledi ot antichni rudarstvo i metalurgia v rayona na Iztochnite Rodopi. Izvestia na regionalen iztoricheski muzey Blagoevgrad 5, 140–153 (in Bulgarian).
Popov, H. 2011. Spasitelni arheologicheski razkopki na zlatodobiven rudnik ot kasnata bronzova epoha i rannata zhelyazna epoahi Ada tepe, obshtina Krumovgrad. Arheologicheski otkritia i razkopki prez 2010 g. Sofia, 134–137 (in Bulgarian).
Popov, H. 2012. Ada Tepe and the secrets of ancient mining. Sofia: National Institute of Archaeology with Museum–BAN.
Popov, H., Georgiev, P., Stoichev, R. 2015. Antichni rudnitsi pri s. Sedefche, obshtina Momchilgrad. Arheologicheski otkritia i razkopki prez 2014 g. Sofia, 563–566 (in Bulgarian).
Popov, H., Jockenhövel, A. 2018. Zlatnata mina ot кasnata bronzova epoha na Ada tepe. In Alexandrov, S., Dimitrova, Y., Popov, H., Horejs, B., Chukalev, K. (eds) Zlato i bronz. Metali, tehnologii i mezhduregionalni kontakti na teritoriyata na Iztochnite Balkani prez bronzovata epoha. Sofia: National Institute of Archaeology with Museum–BAN, 193–207 (in Bulgarian with English abstract).
PostgreSQL Documentation, [Online], Available: https://www.postgresql.org/docs/
(2023-03-26).
USGS. Earth Explorer. Shuttle Radar Topography Mission (SRTM) Digital Elevation Models (DEM’s), [Online], Available: https://earthexplorer.usgs.gov/ (12.10.2021).
Downloads
Published
How to Cite
Issue
Section
License
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
The authors retain full copyright on the articles or other publications.
All materials are published under the Creative Commons Attribution-Non Commercial-No Derivatives 4.0 International License, under which materials may be distributed or reproduced freely, provided the original is unchanged and is quoted correctly.
