{"id":"https://openalex.org/W2296662216","doi":"https://doi.org/10.1145/2820783.2820869","title":"Sphinx","display_name":"Sphinx","publication_year":2015,"publication_date":"2015-11-03","ids":{"openalex":"https://openalex.org/W2296662216","doi":"https://doi.org/10.1145/2820783.2820869","mag":"2296662216"},"language":"en","primary_location":{"id":"doi:10.1145/2820783.2820869","is_oa":true,"landing_page_url":"https://doi.org/10.1145/2820783.2820869","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/2820783.2820869","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 23rd SIGSPATIAL International Conference on Advances in Geographic Information Systems","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/2820783.2820869","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5091292625","display_name":"Ahmed Eldawy","orcid":"https://orcid.org/0000-0002-6584-1455"},"institutions":[{"id":"https://openalex.org/I2800403580","display_name":"University of Minnesota System","ror":"https://ror.org/03grvy078","country_code":"US","type":"education","lineage":["https://openalex.org/I2800403580"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Ahmed Eldawy","raw_affiliation_strings":["University of Minnesota"],"affiliations":[{"raw_affiliation_string":"University of Minnesota","institution_ids":["https://openalex.org/I2800403580"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5032694498","display_name":"Mostafa Elganainy","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Mostafa Elganainy","raw_affiliation_strings":["GIS Technology Innovation Center"],"affiliations":[{"raw_affiliation_string":"GIS Technology Innovation Center","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5067538786","display_name":"Ammar Bakeer","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ammar Bakeer","raw_affiliation_strings":["GIS Technology Innovation Center"],"affiliations":[{"raw_affiliation_string":"GIS Technology Innovation Center","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5003753585","display_name":"Ahmed Abdelmotaleb","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ahmed Abdelmotaleb","raw_affiliation_strings":["GIS Technology Innovation Center"],"affiliations":[{"raw_affiliation_string":"GIS Technology Innovation Center","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5007454642","display_name":"Mohamed F. Mokbel","orcid":"https://orcid.org/0000-0002-6686-1757"},"institutions":[{"id":"https://openalex.org/I130238516","display_name":"University of Minnesota","ror":"https://ror.org/017zqws13","country_code":"US","type":"education","lineage":["https://openalex.org/I130238516"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mohamed Mokbel","raw_affiliation_strings":["University of Minnesota and GIS Technology Innovation Center"],"affiliations":[{"raw_affiliation_string":"University of Minnesota and GIS Technology Innovation Center","institution_ids":["https://openalex.org/I130238516"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5091292625"],"corresponding_institution_ids":["https://openalex.org/I2800403580"],"apc_list":null,"apc_paid":null,"fwci":2.5847,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":{"value":0.90770756,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"4"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9995999932289124,"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.9995999932289124,"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.998199999332428,"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/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9897000193595886,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8816527128219604},{"id":"https://openalex.org/keywords/sphinx","display_name":"Sphinx","score":0.8234635591506958},{"id":"https://openalex.org/keywords/executor","display_name":"Executor","score":0.680600643157959},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6504638195037842},{"id":"https://openalex.org/keywords/parsing","display_name":"Parsing","score":0.5661492347717285},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5617271661758423},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.545630693435669},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.4408319592475891},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.432782918214798},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.38158634305000305},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.3623553514480591},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3467860221862793},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.33995386958122253},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.2607372999191284},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.12635394930839539}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8816527128219604},{"id":"https://openalex.org/C2777299493","wikidata":"https://www.wikidata.org/wiki/Q151480","display_name":"Sphinx","level":2,"score":0.8234635591506958},{"id":"https://openalex.org/C180591056","wikidata":"https://www.wikidata.org/wiki/Q654437","display_name":"Executor","level":2,"score":0.680600643157959},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6504638195037842},{"id":"https://openalex.org/C186644900","wikidata":"https://www.wikidata.org/wiki/Q194152","display_name":"Parsing","level":2,"score":0.5661492347717285},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5617271661758423},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.545630693435669},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.4408319592475891},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.432782918214798},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.38158634305000305},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.3623553514480591},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3467860221862793},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.33995386958122253},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.2607372999191284},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.12635394930839539},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2820783.2820869","is_oa":true,"landing_page_url":"https://doi.org/10.1145/2820783.2820869","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/2820783.2820869","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 23rd SIGSPATIAL International Conference on Advances in Geographic Information Systems","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/2820783.2820869","is_oa":true,"landing_page_url":"https://doi.org/10.1145/2820783.2820869","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/2820783.2820869","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 23rd SIGSPATIAL International Conference on Advances in Geographic Information Systems","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1000609911","display_name":null,"funder_award_id":"IIS-1218168,IIS-0952977","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G8415625174","display_name":null,"funder_award_id":"GISTIC-13-05","funder_id":"https://openalex.org/F4320322997","funder_display_name":"King Abdulaziz City for Science and Technology"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320322997","display_name":"King Abdulaziz City for Science and Technology","ror":"https://ror.org/05tdz6m39"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2296662216.pdf","grobid_xml":"https://content.openalex.org/works/W2296662216.grobid-xml"},"referenced_works_count":13,"referenced_works":["https://openalex.org/W1568832590","https://openalex.org/W1967419472","https://openalex.org/W1990080043","https://openalex.org/W1993997820","https://openalex.org/W2058903936","https://openalex.org/W2106625078","https://openalex.org/W2110086534","https://openalex.org/W2115583184","https://openalex.org/W2125233616","https://openalex.org/W2135961964","https://openalex.org/W2394680079","https://openalex.org/W2401029678","https://openalex.org/W6712120708"],"related_works":["https://openalex.org/W1003283331","https://openalex.org/W2406556739","https://openalex.org/W2128834514","https://openalex.org/W3031390801","https://openalex.org/W2217632272","https://openalex.org/W4379390531","https://openalex.org/W3008396432","https://openalex.org/W2148814251","https://openalex.org/W76469614","https://openalex.org/W2606542151"],"abstract_inverted_index":{"This":[0],"paper":[1],"presents":[2],"Sphinx,":[3],"a":[4,10,82,117],"full-fledged":[5],"distributed":[6,118],"system":[7,121],"which":[8],"uses":[9],"standard":[11],"SQL":[12,69],"interface":[13,70],"to":[14,92],"process":[15],"big":[16,113],"spatial":[17,21,38,62,76,101,114],"data.":[18,39],"Sphinx":[19,42,79,124],"adds":[20],"data":[22,63],"types,":[23],"indexes":[24,77,91],"and":[25,55,65,100],"query":[26,50,53,56,59,87,95,99,106],"processing,":[27],"inside":[28],"the":[29,68,105],"code-base":[30],"of":[31,37,45,71,123,133],"Cloudera":[32],"Impala":[33],"for":[34,97],"efficient":[35,94],"processing":[36],"In":[40],"particular,":[41],"is":[43],"composed":[44],"four":[46],"main":[47],"components,":[48],"namely,":[49],"parser,":[51],"indexer,":[52],"planner,":[54],"executor.":[57],"The":[58,73,86],"parser":[60],"injects":[61],"types":[64],"functions":[66],"in":[67,78,116],"Sphinx.":[72],"indexer":[74],"creates":[75],"by":[80],"adopting":[81],"two-layered":[83],"index":[84],"design.":[85],"planner":[88],"utilizes":[89],"these":[90,110],"construct":[93],"plans":[96,111],"range":[98],"join":[102],"operations.":[103],"Finally,":[104],"executor":[107],"carries":[108],"out":[109],"on":[112,126],"datasets":[115,128],"cluster.":[119],"A":[120],"prototype":[122],"running":[125],"real":[127],"shows":[129],"up-to":[130],"three":[131],"orders":[132],"magnitude":[134],"performance":[135],"improvement":[136],"over":[137],"traditional":[138],"Impala.":[139]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":4}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2016-06-24T00:00:00"}