{"id":"https://openalex.org/W4415257454","doi":"https://doi.org/10.1109/ic2e65552.2025.00007","title":"Evaluating the Impact of Spatial Features of Mobility Data and Index Choice on Database Performance","display_name":"Evaluating the Impact of Spatial Features of Mobility Data and Index Choice on Database Performance","publication_year":2025,"publication_date":"2025-09-23","ids":{"openalex":"https://openalex.org/W4415257454","doi":"https://doi.org/10.1109/ic2e65552.2025.00007"},"language":null,"primary_location":{"id":"doi:10.1109/ic2e65552.2025.00007","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ic2e65552.2025.00007","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2025 IEEE International Conference on Cloud Engineering (IC2E)","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5008363934","display_name":"Tim Rese","orcid":"https://orcid.org/0000-0001-7511-7498"},"institutions":[{"id":"https://openalex.org/I4210089692","display_name":"Einstein Center Digital Future","ror":"https://ror.org/0086bb350","country_code":"DE","type":"facility","lineage":["https://openalex.org/I39343248","https://openalex.org/I4210089692","https://openalex.org/I46043019","https://openalex.org/I75951250","https://openalex.org/I7877124"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Tim C. Rese","raw_affiliation_strings":["Technische Universität Berlin & Einstein Center Digital Future,Scalable Software Systems Research Group"],"affiliations":[{"raw_affiliation_string":"Technische Universität Berlin & Einstein Center Digital Future,Scalable Software Systems Research Group","institution_ids":["https://openalex.org/I4210089692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5016449107","display_name":"Alexander Kapp","orcid":"https://orcid.org/0000-0002-1748-6276"},"institutions":[{"id":"https://openalex.org/I4210089692","display_name":"Einstein Center Digital Future","ror":"https://ror.org/0086bb350","country_code":"DE","type":"facility","lineage":["https://openalex.org/I39343248","https://openalex.org/I4210089692","https://openalex.org/I46043019","https://openalex.org/I75951250","https://openalex.org/I7877124"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Alexandra Kapp","raw_affiliation_strings":["Technische Universität Berlin & Einstein Center Digital Future,Scalable Software Systems Research Group"],"affiliations":[{"raw_affiliation_string":"Technische Universität Berlin & Einstein Center Digital Future,Scalable Software Systems Research Group","institution_ids":["https://openalex.org/I4210089692"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5032206962","display_name":"David Bermbach","orcid":"https://orcid.org/0000-0002-7524-3256"},"institutions":[{"id":"https://openalex.org/I4210089692","display_name":"Einstein Center Digital Future","ror":"https://ror.org/0086bb350","country_code":"DE","type":"facility","lineage":["https://openalex.org/I39343248","https://openalex.org/I4210089692","https://openalex.org/I46043019","https://openalex.org/I75951250","https://openalex.org/I7877124"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"David Bermbach","raw_affiliation_strings":["Technische Universität Berlin & Einstein Center Digital Future,Scalable Software Systems Research Group"],"affiliations":[{"raw_affiliation_string":"Technische Universität Berlin & Einstein Center Digital Future,Scalable Software Systems Research Group","institution_ids":["https://openalex.org/I4210089692"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5008363934"],"corresponding_institution_ids":["https://openalex.org/I4210089692"],"apc_list":null,"apc_paid":null,"fwci":1.6611,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.87603002,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"12"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9936000108718872,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T11106","display_name":"Data Management and Algorithms","score":0.9936000108718872,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T11980","display_name":"Human Mobility and Location-Based Analysis","score":0.9322999715805054,"subfield":{"id":"https://openalex.org/subfields/3313","display_name":"Transportation"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11819","display_name":"Data-Driven Disease Surveillance","score":0.9248999953269958,"subfield":{"id":"https://openalex.org/subfields/2713","display_name":"Epidemiology"},"field":{"id":"https://openalex.org/fields/27","display_name":"Medicine"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.6628999710083008},{"id":"https://openalex.org/keywords/spatial-database","display_name":"Spatial database","score":0.633400022983551},{"id":"https://openalex.org/keywords/skew","display_name":"Skew","score":0.49459999799728394},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.48260000348091125},{"id":"https://openalex.org/keywords/database-index","display_name":"Database index","score":0.4666999876499176},{"id":"https://openalex.org/keywords/index","display_name":"Index (typography)","score":0.43639999628067017},{"id":"https://openalex.org/keywords/variety","display_name":"Variety (cybernetics)","score":0.4268999993801117},{"id":"https://openalex.org/keywords/spatiotemporal-database","display_name":"Spatiotemporal database","score":0.3675000071525574}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7508999705314636},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.6628999710083008},{"id":"https://openalex.org/C203689450","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial database","level":3,"score":0.633400022983551},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6297000050544739},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.6164000034332275},{"id":"https://openalex.org/C43711488","wikidata":"https://www.wikidata.org/wiki/Q7534783","display_name":"Skew","level":2,"score":0.49459999799728394},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.48260000348091125},{"id":"https://openalex.org/C59276292","wikidata":"https://www.wikidata.org/wiki/Q580427","display_name":"Database index","level":3,"score":0.4666999876499176},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.43639999628067017},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.4268999993801117},{"id":"https://openalex.org/C98080885","wikidata":"https://www.wikidata.org/wiki/Q7574095","display_name":"Spatiotemporal database","level":5,"score":0.3675000071525574},{"id":"https://openalex.org/C159620131","wikidata":"https://www.wikidata.org/wiki/Q1938983","display_name":"Spatial analysis","level":2,"score":0.365200012922287},{"id":"https://openalex.org/C146481406","wikidata":"https://www.wikidata.org/wiki/Q105131","display_name":"Hotspot (geology)","level":2,"score":0.3537999987602234},{"id":"https://openalex.org/C204323151","wikidata":"https://www.wikidata.org/wiki/Q905424","display_name":"Range (aeronautics)","level":2,"score":0.3393000066280365},{"id":"https://openalex.org/C192209626","wikidata":"https://www.wikidata.org/wiki/Q190909","display_name":"Focus (optics)","level":2,"score":0.3384999930858612},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.329800009727478},{"id":"https://openalex.org/C2781238097","wikidata":"https://www.wikidata.org/wiki/Q175026","display_name":"Object (grammar)","level":2,"score":0.29919999837875366},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.2948000133037567},{"id":"https://openalex.org/C106278948","wikidata":"https://www.wikidata.org/wiki/Q1198051","display_name":"R-tree","level":4,"score":0.2728999853134155},{"id":"https://openalex.org/C132964779","wikidata":"https://www.wikidata.org/wiki/Q2110223","display_name":"Raw data","level":2,"score":0.2687999904155731},{"id":"https://openalex.org/C130590232","wikidata":"https://www.wikidata.org/wiki/Q1671754","display_name":"Inverted index","level":3,"score":0.26600000262260437},{"id":"https://openalex.org/C42629822","wikidata":"https://www.wikidata.org/wiki/Q1346408","display_name":"Geocoding","level":2,"score":0.25859999656677246},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.25119999051094055}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/ic2e65552.2025.00007","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ic2e65552.2025.00007","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2025 IEEE International Conference on Cloud Engineering (IC2E)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":37,"referenced_works":["https://openalex.org/W1939649909","https://openalex.org/W1981930699","https://openalex.org/W1984525813","https://openalex.org/W1985381487","https://openalex.org/W2003765267","https://openalex.org/W2013042849","https://openalex.org/W2031473446","https://openalex.org/W2048660474","https://openalex.org/W2049763161","https://openalex.org/W2065663378","https://openalex.org/W2086961842","https://openalex.org/W2109264950","https://openalex.org/W2118269922","https://openalex.org/W2126194848","https://openalex.org/W2128471644","https://openalex.org/W2129741585","https://openalex.org/W2159129642","https://openalex.org/W2159860101","https://openalex.org/W2267720383","https://openalex.org/W2727240133","https://openalex.org/W2901028997","https://openalex.org/W2911262853","https://openalex.org/W2982284108","https://openalex.org/W3028871849","https://openalex.org/W3035806999","https://openalex.org/W3112327940","https://openalex.org/W3134624922","https://openalex.org/W3217016897","https://openalex.org/W4205569180","https://openalex.org/W4205656768","https://openalex.org/W4237449264","https://openalex.org/W4283747724","https://openalex.org/W4293193362","https://openalex.org/W4307935333","https://openalex.org/W4366091524","https://openalex.org/W4386991635","https://openalex.org/W4404612141"],"related_works":[],"abstract_inverted_index":{"The":[0],"growing":[1],"number":[2],"of":[3,74,85,96,116,121,126,147,159,169,184],"moving":[4,14],"Internet-of-Things":[5],"(IoT)":[6],"devices":[7],"has":[8,67],"led":[9],"to":[10,135,179,199],"a":[11,83,105,141,145,167,181],"surge":[12],"in":[13,70],"object":[15],"data,":[16,31],"powering":[17],"applications":[18],"such":[19,30,49],"as":[20,50],"traffic":[21],"routing,":[22],"hotspot":[23],"detection,":[24],"or":[25,44],"weather":[26],"forecasting.":[27],"When":[28],"managing":[29],"spatial":[32,107,148,201],"database":[33,63,108,163,216],"systems":[34],"offer":[35,193],"various":[36],"index":[37,97],"options":[38],"and":[39,53,79,101,123,128,132,151,171,174,176,203,212],"data":[40,99,152],"formats,":[41,153],"e.g.,":[42],"point-based":[43],"trajectory-based.":[45],"Likewise,":[46],"dataset":[47,102,117,160,210],"characteristics":[48,103,161,211],"geographic":[51],"overlap":[52,122],"skew":[54],"can":[55,60],"vary":[56],"severely.":[57],"All":[58],"three":[59,87],"strongly":[61],"affect":[62],"performance.":[64,164,217],"While":[65],"this":[66,89],"been":[68],"studied":[69],"existing":[71],"papers,":[72],"none":[73],"them":[75],"explore":[76],"the":[77,93,119,124,157],"effects":[78],"trade-offs":[80],"resulting":[81],"from":[82],"combination":[84],"all":[86],"aspects.In":[88],"paper,":[90],"we":[91],"evaluate":[92],"performance":[94],"impact":[95,158,214],"choice,":[98],"format,":[100],"on":[104,113,162,215],"popular":[106],"system,":[109],"PostGIS.":[110],"We":[111,139,165],"focus":[112],"two":[114],"aspects":[115],"characteristics,":[118],"degree":[120,125],"skew,":[127],"propose":[129],"novel":[130],"metrics":[131],"approximation":[133],"methods":[134],"determine":[136],"these":[137],"features.":[138],"design":[140],"benchmark":[142],"that":[143,186],"compares":[144],"variety":[146,168],"indexing":[149],"strategies":[150],"while":[154,205],"also":[155,206],"considering":[156],"include":[166],"real-world":[170],"synthetic":[172],"datasets,":[173],"write":[175],"read":[177],"operations":[178],"cover":[180],"broad":[182],"range":[183],"scenarios":[185],"might":[187],"occur":[188],"during":[189],"application":[190],"runtime.Our":[191],"results":[192],"practical":[194],"guidance":[195],"for":[196],"developers":[197],"looking":[198],"optimize":[200],"storage":[202],"querying,":[204],"providing":[207],"insights":[208],"into":[209],"their":[213]},"counts_by_year":[{"year":2025,"cited_by_count":1}],"updated_date":"2026-03-07T16:01:11.037858","created_date":"2025-10-17T00:00:00"}