{"id":"https://openalex.org/W3108728991","doi":"https://doi.org/10.1145/3397536.3422262","title":"Distributed Spatiotemporal Trajectory Query Processing in SQL","display_name":"Distributed Spatiotemporal Trajectory Query Processing in SQL","publication_year":2020,"publication_date":"2020-11-03","ids":{"openalex":"https://openalex.org/W3108728991","doi":"https://doi.org/10.1145/3397536.3422262","mag":"3108728991"},"language":"en","primary_location":{"id":"doi:10.1145/3397536.3422262","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3397536.3422262","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 28th International Conference on Advances in Geographic Information Systems","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://hdl.handle.net/2013/ULB-DIPOT:oai:dipot.ulb.ac.be:2013/330092","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5064282568","display_name":"Mohamed Bakli","orcid":"https://orcid.org/0000-0001-7780-8516"},"institutions":[{"id":"https://openalex.org/I132053463","display_name":"Universit\u00e9 Libre de Bruxelles","ror":"https://ror.org/01r9htc13","country_code":"BE","type":"education","lineage":["https://openalex.org/I132053463"]}],"countries":["BE"],"is_corresponding":true,"raw_author_name":"Mohamed Bakli","raw_affiliation_strings":["Universit\u00e9 libre de Bruxelles, Brussels, Belgium"],"affiliations":[{"raw_affiliation_string":"Universit\u00e9 libre de Bruxelles, Brussels, Belgium","institution_ids":["https://openalex.org/I132053463"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5056091991","display_name":"Mahmoud Sakr","orcid":"https://orcid.org/0000-0002-6741-8300"},"institutions":[{"id":"https://openalex.org/I132053463","display_name":"Universit\u00e9 Libre de Bruxelles","ror":"https://ror.org/01r9htc13","country_code":"BE","type":"education","lineage":["https://openalex.org/I132053463"]},{"id":"https://openalex.org/I107720978","display_name":"Ain Shams University","ror":"https://ror.org/00cb9w016","country_code":"EG","type":"education","lineage":["https://openalex.org/I107720978"]}],"countries":["BE","EG"],"is_corresponding":false,"raw_author_name":"Mahmoud Sakr","raw_affiliation_strings":["Universit\u00e9 libre de Bruxelles, Brussels, Belgium, Ain Shams University, Cairo, Egypt"],"affiliations":[{"raw_affiliation_string":"Universit\u00e9 libre de Bruxelles, Brussels, Belgium, Ain Shams University, Cairo, Egypt","institution_ids":["https://openalex.org/I132053463","https://openalex.org/I107720978"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5050401502","display_name":"Esteban Zim\u00e1nyi","orcid":"https://orcid.org/0000-0003-1843-5099"},"institutions":[{"id":"https://openalex.org/I132053463","display_name":"Universit\u00e9 Libre de Bruxelles","ror":"https://ror.org/01r9htc13","country_code":"BE","type":"education","lineage":["https://openalex.org/I132053463"]}],"countries":["BE"],"is_corresponding":false,"raw_author_name":"Esteban Zim\u00e1nyi","raw_affiliation_strings":["Universit\u00e9 libre de Bruxelles, Brussels, Belgium"],"affiliations":[{"raw_affiliation_string":"Universit\u00e9 libre de Bruxelles, Brussels, Belgium","institution_ids":["https://openalex.org/I132053463"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5064282568"],"corresponding_institution_ids":["https://openalex.org/I132053463"],"apc_list":null,"apc_paid":null,"fwci":0.7577,"has_fulltext":false,"cited_by_count":15,"citation_normalized_percentile":{"value":0.71843318,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"87","last_page":"98"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"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.9998999834060669,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9922000169754028,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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/T10757","display_name":"Geographic Information Systems Studies","score":0.972599983215332,"subfield":{"id":"https://openalex.org/subfields/3305","display_name":"Geography, Planning and Development"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8728830814361572},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7595386505126953},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.6993608474731445},{"id":"https://openalex.org/keywords/distributed-database","display_name":"Distributed database","score":0.5137959122657776},{"id":"https://openalex.org/keywords/object","display_name":"Object (grammar)","score":0.49660569429397583},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4684197008609772},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.4199222922325134},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.38281944394111633},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.37724488973617554},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.21225658059120178},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.09098613262176514},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.0802449882030487}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8728830814361572},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7595386505126953},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.6993608474731445},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.5137959122657776},{"id":"https://openalex.org/C2781238097","wikidata":"https://www.wikidata.org/wiki/Q175026","display_name":"Object (grammar)","level":2,"score":0.49660569429397583},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4684197008609772},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.4199222922325134},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.38281944394111633},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.37724488973617554},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.21225658059120178},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.09098613262176514},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0802449882030487},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3397536.3422262","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3397536.3422262","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 28th International Conference on Advances in Geographic Information Systems","raw_type":"proceedings-article"},{"id":"pmh:oai:dipot.ulb.ac.be:2013/330092","is_oa":true,"landing_page_url":"http://hdl.handle.net/2013/ULB-DIPOT:oai:dipot.ulb.ac.be:2013/330092","pdf_url":null,"source":{"id":"https://openalex.org/S4306401063","display_name":"D\u00e9p\u00f4t institutionnel de l'Universit\u00e9 libre de Bruxelles (Universit\u00e9 Libre de Bruxelles)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I132053463","host_organization_name":"Universit\u00e9 Libre de Bruxelles","host_organization_lineage":["https://openalex.org/I132053463"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"In:","raw_type":"info:ulb-repo/semantics/openurl/proceeding"}],"best_oa_location":{"id":"pmh:oai:dipot.ulb.ac.be:2013/330092","is_oa":true,"landing_page_url":"http://hdl.handle.net/2013/ULB-DIPOT:oai:dipot.ulb.ac.be:2013/330092","pdf_url":null,"source":{"id":"https://openalex.org/S4306401063","display_name":"D\u00e9p\u00f4t institutionnel de l'Universit\u00e9 libre de Bruxelles (Universit\u00e9 Libre de Bruxelles)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I132053463","host_organization_name":"Universit\u00e9 Libre de Bruxelles","host_organization_lineage":["https://openalex.org/I132053463"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"In:","raw_type":"info:ulb-repo/semantics/openurl/proceeding"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/3","score":0.4000000059604645,"display_name":"Good health and well-being"}],"awards":[{"id":"https://openalex.org/G7211581094","display_name":null,"funder_award_id":"MobiPulse Project","funder_id":"https://openalex.org/F4320322852","funder_display_name":"Innoviris"}],"funders":[{"id":"https://openalex.org/F4320322852","display_name":"Innoviris","ror":"https://ror.org/04af9zr29"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":17,"referenced_works":["https://openalex.org/W1969839198","https://openalex.org/W2739859529","https://openalex.org/W2781601513","https://openalex.org/W2798903611","https://openalex.org/W2799180173","https://openalex.org/W2803544523","https://openalex.org/W2890960500","https://openalex.org/W2901028997","https://openalex.org/W2907842373","https://openalex.org/W2910693445","https://openalex.org/W2911262853","https://openalex.org/W2921130045","https://openalex.org/W3014091093","https://openalex.org/W3028871849","https://openalex.org/W3112327940","https://openalex.org/W3123846402","https://openalex.org/W3139314004"],"related_works":["https://openalex.org/W151494989","https://openalex.org/W1488984669","https://openalex.org/W3210031882","https://openalex.org/W4388053677","https://openalex.org/W2031915568","https://openalex.org/W2038123353","https://openalex.org/W2108932068","https://openalex.org/W4223894417","https://openalex.org/W3114457612","https://openalex.org/W4281757942"],"abstract_inverted_index":{"Nowadays,":[0],"the":[1,12,42,70,81,156,163,167],"collection":[2],"of":[3,14,22,58,69,84,94,142],"moving":[4,44,97],"object":[5,45,98],"data":[6,23,128],"is":[7,24,49,54,140,154,158,176],"significantly":[8],"increasing":[9],"due":[10],"to":[11,79],"ubiquity":[13],"GPS-enabled":[15],"devices.":[16],"Managing":[17],"and":[18,34,60,66,74,91,130,134,165,173],"analyzing":[19],"this":[20,77],"kind":[21],"crucial":[25],"in":[26,160],"many":[27],"application":[28],"domains,":[29],"including":[30],"social":[31],"mobility,":[32],"pandemics,":[33],"transportation.":[35],"In":[36,76],"previous":[37],"work,":[38],"we":[39,87,106],"have":[40],"proposed":[41],"MobilityDB":[43,115,149,187],"database":[46,99,116],"system.":[47],"It":[48,62],"a":[50,95,113,118,136,181],"production-ready":[51],"system,":[52],"that":[53,139,155,166],"built":[55],"on":[56,102,117],"top":[57],"PostgreSQL":[59],"PostGIS.":[61],"accepts":[63],"SQL":[64,145,161],"queries":[65,146,169],"offers":[67],"most":[68],"common":[71],"spatiotemporal":[72,144],"types":[73],"operations.":[75],"paper,":[78],"address":[80],"scalability":[82],"requirement":[83],"big":[85],"data,":[86],"provide":[88],"an":[89,92,109],"architecture":[90,110],"implementation":[93],"distributed":[96,114,172],"system":[100],"based":[101],"MobilityDB.":[103],"More":[104],"specifically,":[105],"define:":[107],"(1)":[108],"for":[111],"deploying":[112],"cluster":[119,157],"using":[120,180],"readily":[121],"available":[122],"tools,":[123],"(2)":[124],"two":[125],"alternative":[126],"trajectory":[127],"partitioning":[129,132],"index":[131],"methods,":[133],"(3)":[135],"query":[137],"optimizer":[138],"capable":[141],"distributing":[143],"over":[147],"multiple":[148],"instances.":[150],"The":[151],"overall":[152],"outcome":[153],"managed":[159],"at":[162],"run-time":[164],"user":[168],"are":[170],"transparently":[171],"executed.":[174],"This":[175],"validated":[177],"with":[178,188],"experiments":[179],"real":[182],"dataset,":[183],"which":[184],"also":[185],"compares":[186],"other":[189],"relevant":[190],"systems.":[191]},"counts_by_year":[{"year":2025,"cited_by_count":6},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":2},{"year":2021,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}