{"id":"https://openalex.org/W6893097708","doi":"https://doi.org/10.5281/zenodo.13861521","title":"Recent Advances in Querying the Road Database to Make Data FAIR","display_name":"Recent Advances in Querying the Road Database to Make Data FAIR","publication_year":2024,"publication_date":"2024-08-29","ids":{"openalex":"https://openalex.org/W6893097708","doi":"https://doi.org/10.5281/zenodo.13861521"},"language":"en","primary_location":{"id":"doi:10.5281/zenodo.13861521","doi":"https://doi.org/10.5281/zenodo.13861521","is_oa":true,"landing_page_url":"https://doi.org/10.5281/zenodo.13861521","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article-journal"},"volume":null,"type":"article","indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.5281/zenodo.13861521","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Kandel, Andrew","orcid":"https://orcid.org/0000-0002-9889-9418","observed_orcids":["https://orcid.org/0000-0002-9889-9418"]},"institutions":[{"id":"https://openalex.org/I4210125571","display_name":"Heidelberg Academy of Sciences and Humanities","ror":"https://ror.org/02dvf9b44","country_code":"DE","type":"facility","lineage":["https://openalex.org/I4210125571"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Kandel, Andrew","raw_affiliation_strings":["Heidelberger Akademie der Wissenschaften"],"raw_orcid":"https://orcid.org/0000-0002-9889-9418","affiliations":[{"raw_affiliation_string":"Heidelberger Akademie der Wissenschaften","institution_ids":["https://openalex.org/I4210125571"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027343448","display_name":"Miriam No\u00ebl Haidle","orcid":"https://orcid.org/0000-0002-4923-7880","observed_orcids":["https://orcid.org/0000-0002-4923-7880"]},"institutions":[{"id":"https://openalex.org/I4210125571","display_name":"Heidelberg Academy of Sciences and Humanities","ror":"https://ror.org/02dvf9b44","country_code":"DE","type":"facility","lineage":["https://openalex.org/I4210125571"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Haidle, Miriam","raw_affiliation_strings":["Heidelberger Akademie der Wissenschaften"],"raw_orcid":"https://orcid.org/0000-0002-4923-7880","affiliations":[{"raw_affiliation_string":"Heidelberger Akademie der Wissenschaften","institution_ids":["https://openalex.org/I4210125571"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5125024955","display_name":"Volker Hochschild","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210125571","display_name":"Heidelberg Academy of Sciences and Humanities","ror":"https://ror.org/02dvf9b44","country_code":"DE","type":"facility","lineage":["https://openalex.org/I4210125571"]},{"id":"https://openalex.org/I8087733","display_name":"University of T\u00fcbingen","ror":"https://ror.org/03a1kwz48","country_code":"DE","type":"education","lineage":["https://openalex.org/I8087733"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Hochschild, Volker","raw_affiliation_strings":["Heidelberger Akademie der Wissenschaften","University of T\u00fcbingen"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Heidelberger Akademie der Wissenschaften","institution_ids":["https://openalex.org/I4210125571"]},{"raw_affiliation_string":"University of T\u00fcbingen","institution_ids":["https://openalex.org/I8087733"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5047810579","display_name":"Zara Kanaeva","orcid":"https://orcid.org/0000-0002-1989-1494","observed_orcids":["https://orcid.org/0000-0002-1989-1494"]},"institutions":[{"id":"https://openalex.org/I4210125571","display_name":"Heidelberg Academy of Sciences and Humanities","ror":"https://ror.org/02dvf9b44","country_code":"DE","type":"facility","lineage":["https://openalex.org/I4210125571"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Kanaeva, Zara","raw_affiliation_strings":["Heidelberger Akademie der Wissenschaften"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Heidelberger Akademie der Wissenschaften","institution_ids":["https://openalex.org/I4210125571"]}]},{"author_position":"last","author":{"id":null,"display_name":"Conard, Nicholas","orcid":"https://orcid.org/0000-0002-4633-0385","observed_orcids":["https://orcid.org/0000-0002-4633-0385"]},"institutions":[{"id":"https://openalex.org/I4210125571","display_name":"Heidelberg Academy of Sciences and Humanities","ror":"https://ror.org/02dvf9b44","country_code":"DE","type":"facility","lineage":["https://openalex.org/I4210125571"]},{"id":"https://openalex.org/I8087733","display_name":"University of T\u00fcbingen","ror":"https://ror.org/03a1kwz48","country_code":"DE","type":"education","lineage":["https://openalex.org/I8087733"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Conard, Nicholas","raw_affiliation_strings":["Heidelberger Akademie der Wissenschaften","University of T\u00fcbingen"],"raw_orcid":"https://orcid.org/0000-0002-4633-0385","affiliations":[{"raw_affiliation_string":"Heidelberger Akademie der Wissenschaften","institution_ids":["https://openalex.org/I4210125571"]},{"raw_affiliation_string":"University of T\u00fcbingen","institution_ids":["https://openalex.org/I8087733"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.35132255,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":true,"primary_topic":{"id":"https://openalex.org/T11937","display_name":"Research Data Management Practices","score":0.899399995803833,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11937","display_name":"Research Data Management Practices","score":0.899399995803833,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.022600000724196434,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T12377","display_name":"Digital Humanities and Scholarship","score":0.014299999922513962,"subfield":{"id":"https://openalex.org/subfields/1208","display_name":"Literature and Literary Theory"},"field":{"id":"https://openalex.org/fields/12","display_name":"Arts and Humanities"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/archaeological-databases","display_name":"archaeological databases","score":0.5450000166893005},{"id":"https://openalex.org/keywords/fair-data","display_name":"FAIR data","score":0.8190000057220459},{"id":"https://openalex.org/keywords/database-queries","display_name":"database queries","score":0.5669999718666077},{"id":"https://openalex.org/keywords/early-human-dispersal","display_name":"early human dispersal","score":0.699999988079071},{"id":"https://openalex.org/keywords/paleoanthropology","display_name":"paleoanthropology","score":0.6679999828338623},{"id":"https://openalex.org/keywords/paleoarchaeology","display_name":"paleoarchaeology","score":0.7170000076293945},{"id":"https://openalex.org/keywords/sparql-endpoint","display_name":"SPARQL endpoint","score":0.703000009059906},{"id":"https://openalex.org/keywords/data-interoperability","display_name":"data interoperability","score":0.7630000114440918},{"id":"https://openalex.org/keywords/data-export-formats","display_name":"data export formats","score":0.3880000114440918},{"id":"https://openalex.org/keywords/research-data-management","display_name":"research data management","score":0.4359999895095825},{"id":"https://openalex.org/keywords/archaeological-assemblages","display_name":"archaeological assemblages","score":0.5299999713897705}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7620999813079834},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.6244999766349792},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5805000066757202},{"id":"https://openalex.org/C20136886","wikidata":"https://www.wikidata.org/wiki/Q749647","display_name":"Interoperability","level":2,"score":0.4966999888420105},{"id":"https://openalex.org/C2776505523","wikidata":"https://www.wikidata.org/wiki/Q4785468","display_name":"Plan (archaeology)","level":2,"score":0.4878000020980835},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.4731999933719635},{"id":"https://openalex.org/C41009113","wikidata":"https://www.wikidata.org/wiki/Q54871","display_name":"SPARQL","level":4,"score":0.4311999976634979},{"id":"https://openalex.org/C2780154274","wikidata":"https://www.wikidata.org/wiki/Q7126717","display_name":"Download","level":2,"score":0.42559999227523804},{"id":"https://openalex.org/C2776401178","wikidata":"https://www.wikidata.org/wiki/Q12050496","display_name":"Feature (linguistics)","level":2,"score":0.4133000075817108},{"id":"https://openalex.org/C9652623","wikidata":"https://www.wikidata.org/wiki/Q190109","display_name":"Field (mathematics)","level":2,"score":0.4059999883174896},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.4056999981403351},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4016999900341034},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.38359999656677246},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3750999867916107},{"id":"https://openalex.org/C2778531742","wikidata":"https://www.wikidata.org/wiki/Q17009281","display_name":"Discoverability","level":2,"score":0.3458000123500824},{"id":"https://openalex.org/C113843644","wikidata":"https://www.wikidata.org/wiki/Q901882","display_name":"Interface (matter)","level":4,"score":0.34299999475479126},{"id":"https://openalex.org/C9770341","wikidata":"https://www.wikidata.org/wiki/Q1938983","display_name":"Geospatial analysis","level":2,"score":0.3411000072956085},{"id":"https://openalex.org/C2780977526","wikidata":"https://www.wikidata.org/wiki/Q42417149","display_name":"Data exploration","level":3,"score":0.33379998803138733},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.3305000066757202},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.32760000228881836},{"id":"https://openalex.org/C89505385","wikidata":"https://www.wikidata.org/wiki/Q47146","display_name":"User interface","level":2,"score":0.321399986743927},{"id":"https://openalex.org/C2778012447","wikidata":"https://www.wikidata.org/wiki/Q1034415","display_name":"Scope (computer science)","level":2,"score":0.29409998655319214},{"id":"https://openalex.org/C100463513","wikidata":"https://www.wikidata.org/wiki/Q5227322","display_name":"Data model (GIS)","level":2,"score":0.29280000925064087},{"id":"https://openalex.org/C28719098","wikidata":"https://www.wikidata.org/wiki/Q44946","display_name":"Point (geometry)","level":2,"score":0.28690001368522644},{"id":"https://openalex.org/C147497476","wikidata":"https://www.wikidata.org/wiki/Q54872","display_name":"RDF","level":3,"score":0.2711000144481659},{"id":"https://openalex.org/C1668388","wikidata":"https://www.wikidata.org/wiki/Q1149776","display_name":"Data management","level":2,"score":0.26499998569488525},{"id":"https://openalex.org/C72634772","wikidata":"https://www.wikidata.org/wiki/Q386824","display_name":"Data integration","level":2,"score":0.26010000705718994},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.26010000705718994}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.5281/zenodo.13861521","doi":"https://doi.org/10.5281/zenodo.13861521","is_oa":true,"landing_page_url":"https://doi.org/10.5281/zenodo.13861521","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article-journal"},{"id":"doi:10.5281/zenodo.13861522","doi":"https://doi.org/10.5281/zenodo.13861522","is_oa":true,"landing_page_url":"https://doi.org/10.5281/zenodo.13861522","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article-journal"}],"best_oa_location":{"id":"doi:10.5281/zenodo.13861521","doi":"https://doi.org/10.5281/zenodo.13861521","is_oa":true,"landing_page_url":"https://doi.org/10.5281/zenodo.13861521","pdf_url":null,"source":{"id":"https://openalex.org/S4306400562","display_name":"Zenodo (CERN European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article-journal"},"sustainable_development_goals":[],"sustainable_development_goals_aurora":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"The":[0,91],"\u201cROCEEH":[1],"Out":[2],"of":[3,11,54,100,133,199,212,330,364,372],"Africa":[4,15],"Database\u201d":[5],"(ROAD)":[6],"is":[7,139],"the":[8,25,102,131,238,254,298,322],"largest":[9],"compilation":[10],"archaeological":[12],"datasets":[13],"covering":[14],"and":[16,58,162,214,241,265,281,315,328,332,345],"Eurasia":[17],"from":[18,52,263,297],"3,000,000":[19],"to":[20,34,41,147,173,249,260,277,285],"20,000":[21],"years":[22],"ago.":[23],"When":[24],"project":[26],"began":[27],"in":[28,60,69,111,115,155,164,181,230,253],"2008":[29],"(https://www.hadw-bw.de/en/research/research-center/roceeh/home),":[30],"one":[31,121],"goal":[32],"was":[33],"create":[35,174],"an":[36,126],"open-access,":[37],"online,":[38],"research":[39],"database":[40],"answer":[42],"large-scale":[43],"questions":[44],"about":[45,207],"early":[46],"humans":[47],"expansions.":[48],"ROAD":[49,264,279,292],"gathers":[50],"data":[51,80,89,103,262],"fields":[53],"archaeology,":[55],"paleoanthropology,":[56],"paleontology":[57],"paleobotany":[59],"a":[61,83,136,160,182,222,258],"geographic":[62,191],"framework.":[63],"Here,":[64],"we":[65,104,143],"present":[66],"recent":[67],"advances":[68],"querying":[70],"ROAD.":[71],"We":[72,247,274],"discuss":[73],"how":[74],"ROCEEH":[75],"provides":[76],"its":[77],"users":[78,170,227],"with":[79,145,169,185],"andfocus":[81],"on":[82,120],"new,":[84],"user-friendly":[85],"feature":[86],"that":[87],"facilitates":[88],"retrieval.":[90],"new":[92],"interface,":[93],"called":[94],"\u201cAsk":[95,175],"ROAD,\u201d":[96],"embodies":[97],"our":[98],"philosophy":[99],"making":[101],"collect":[105],"as":[106,108,272,319],"FAIR":[107],"possible.":[109],"Queries":[110],"ROADWeb":[112,156],"are":[113,235,317],"performed":[114],"various":[116],"ways:":[117],"simple":[118],"filters":[119],"table":[122,223],"provide":[123,282],"basic":[124],"results;":[125],"SQL":[127],"query":[128],"tool":[129],"allows":[130],"joining":[132],"several":[134,165],"tables;":[135],"SPARQL":[137],"endpoint":[138],"also":[140],"available;":[141],"finally,":[142],"collaborate":[144],"partners":[146],"tailor":[148],"complex":[149],"queries.":[150],"Results":[151],"can":[152,228,293],"be":[153],"viewed":[154],"or":[157],"accessed":[158],"through":[159],"URL,":[161],"exported":[163],"interoperable":[166],"formats.":[167],"Experience":[168],"motivated":[171],"us":[172],"ROAD\u201d.":[176],"This":[177],"intuitive":[178],"interface":[179],"works":[180],"scaffolded":[183],"way":[184],"five":[186],"sequential":[187],"steps:":[188],"1)":[189],"select":[190],"region":[192],"and/or":[193,201,325],"site":[194],"type;":[195],"2)":[196],"choose":[197],"types":[198],"assemblages":[200],"define":[202],"timeframe;":[203],"3)":[204],"specify":[205],"details":[206],"assemblages;":[208],"4)":[209],"perform":[210],"unions":[211],"datasets;":[213],"5)":[215],"conduct":[216],"detailed":[217],"searches.":[218],"After":[219],"each":[220],"step,":[221],"pops":[224],"up,":[225],"which":[226],"download":[229],"their":[231],"preferred":[232],"format.":[233],"References":[234],"generated":[236],"after":[237],"first":[239],"step":[240],"attributes":[242],"displayed":[243],"at":[244],"any":[245],"time.":[246],"plan":[248],"add":[250],"more":[251],"features":[252],"future,":[255],"for":[256,289],"example":[257],"routine":[259],"extract":[261],"process":[266],"it":[267],"using":[268],"statistical":[269],"packages":[270],"such":[271],"R.":[273],"encourage":[275],"you":[276],"visit":[278],"(https://www.roceeh.uni-tuebingen.de/roadweb/)":[280],"expanded":[283],"access":[284],"anyone":[286],"interested.":[287],"Discover":[288],"yourself":[290],"what":[291],"do!":[294],"Abstract":[295,301,311],"taken":[296],"EAA":[299,304,378],"2024":[300,368,374],"Book:":[302],"30th":[303,377],"Annual":[305,379],"Meeting":[306,380],"(Rome,":[307,381],"Italy":[308],"2024)":[309,382],"-":[310,353,358],"Book":[312],"Names,":[313],"titles":[314,331],"affiliations":[316],"reproduced":[318],"submitted":[320],"by":[321],"session":[323],"organisers":[324],"authors.":[326],"Language":[327],"wording":[329],"abstracts":[333],"were":[334],"not":[335],"revised.":[336],"Technical":[337],"editing:":[338],"S\u00e1ra":[339,347],"Tyl\u0161ov\u00e1,":[340,348],"Magda":[341,349],"Karab\u00e1\u0161":[342,350],"(EAA)":[343,351],"Design":[344,352,357],"layout:":[346],"cover:":[354],"Symposia":[355],"srl":[356],"logo:":[359],"Caterina":[360],"Amendola":[361],"European":[362,370],"Association":[363,371],"Archaeologists":[365],"Rome,":[366],"August":[367],"\u00a9":[369],"Archaeologists,":[373],"ISBN":[375],"978-80-88441-08-3":[376],"https://www.e-a-a.org/EAA2024/scientificprogramme":[383]},"counts_by_year":[],"updated_date":"2026-10-13T10:08:12.033832","created_date":"2025-10-10T00:00:00"}