{"id":"https://openalex.org/W2023980474","doi":"https://doi.org/10.1080/02693799208901897","title":"Why not SQL!","display_name":"Why not SQL!","alternate_titles":[],"publication_year":1992,"publication_date":"1992-03-01","ids":{"openalex":"https://openalex.org/W2023980474","doi":"https://doi.org/10.1080/02693799208901897","mag":"2023980474"},"language":"en","primary_location":{"id":"doi:10.1080/02693799208901897","doi":"https://doi.org/10.1080/02693799208901897","is_oa":false,"landing_page_url":"https://doi.org/10.1080/02693799208901897","pdf_url":null,"source":{"id":"https://openalex.org/S4210181446","display_name":"International Journal of Geographical Information Systems","issn_l":"0269-3798","issn":["0269-3798","1362-3087"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["dongbi-b","poland-100"],"host_organization":"https://openalex.org/P4310320547","host_organization_name":"Taylor & Francis","host_organization_lineage":["https://openalex.org/P4310320547","https://openalex.org/P4310320449"],"host_organization_lineage_names":["Taylor & Francis","Informa"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International journal of geographical information systems","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W2023980474"],"child_works_count":0,"type":"article","is_traditional":true,"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/A5068705609","display_name":"Max J. Egenhofer","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I7947594","display_name":"University of Maine","ror":"https://ror.org/01adr0w49","country_code":"US","type":"education","lineage":["https://openalex.org/I2802397601","https://openalex.org/I7947594"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"MAX J. EGENHOFER","raw_affiliation_strings":["National Center for Geographic Information and Analysis and Department of Surveying Engineering, Boardman Hall, University of Maine, Orono, ME, 04469, U.S.A"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"National Center for Geographic Information and Analysis and Department of Surveying Engineering, Boardman Hall, University of Maine, Orono, ME, 04469, U.S.A","institution_ids":["https://openalex.org/I7947594"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5068705609"],"corresponding_institution_ids":["https://openalex.org/I7947594"],"apc_list":null,"apc_paid":null,"fwci":10.1679,"has_fulltext":false,"cited_by_count":107,"citation_normalized_percentile":{"value":0.97856268,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":88,"max":95},"biblio":{"volume":"6","issue":"2","first_page":"71","last_page":"85"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9413999915122986,"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/T11106","display_name":"Data Management and Algorithms","score":0.9413999915122986,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.032099999487400055,"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/T10757","display_name":"Geographic Information Systems Studies","score":0.00800000037997961,"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/sql","display_name":"SQL","score":0.7129999995231628},{"id":"https://openalex.org/keywords/spatial-query-languages","display_name":"spatial query languages","score":0.9520000219345093},{"id":"https://openalex.org/keywords/geographic-information-systems","display_name":"geographic information systems","score":0.7789999842643738}],"concepts":[{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.8227725625038147},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8176514506340027},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.7729475498199463},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.7059489488601685},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6636359691619873},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.6222277879714966},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5546588897705078},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.5379842519760132},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5233584642410278},{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.5059370398521423},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4874430000782013},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.4485826790332794},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.44348061084747314},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.43737614154815674},{"id":"https://openalex.org/C96956885","wikidata":"https://www.wikidata.org/wiki/Q6138701","display_name":"RDF query language","level":5,"score":0.4262082576751709},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.40606385469436646},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.187544584274292},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.16678592562675476},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1080/02693799208901897","doi":"https://doi.org/10.1080/02693799208901897","is_oa":false,"landing_page_url":"https://doi.org/10.1080/02693799208901897","pdf_url":null,"source":{"id":"https://openalex.org/S4210181446","display_name":"International Journal of Geographical Information Systems","issn_l":"0269-3798","issn":["0269-3798","1362-3087"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["dongbi-b","poland-100"],"host_organization":"https://openalex.org/P4310320547","host_organization_name":"Taylor & Francis","host_organization_lineage":["https://openalex.org/P4310320547","https://openalex.org/P4310320449"],"host_organization_lineage_names":["Taylor & Francis","Informa"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International journal of geographical information systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":73,"referenced_works":["https://openalex.org/W6952187","https://openalex.org/W163882827","https://openalex.org/W192407326","https://openalex.org/W1505177095","https://openalex.org/W1509428113","https://openalex.org/W1512840853","https://openalex.org/W1516111989","https://openalex.org/W1543893113","https://openalex.org/W1544752055","https://openalex.org/W1545466623","https://openalex.org/W1546901246","https://openalex.org/W1562735428","https://openalex.org/W1573833643","https://openalex.org/W1575125009","https://openalex.org/W1584008570","https://openalex.org/W1590607611","https://openalex.org/W1603334326","https://openalex.org/W1603487667","https://openalex.org/W1608787345","https://openalex.org/W1849252796","https://openalex.org/W1867160744","https://openalex.org/W1945128294","https://openalex.org/W1968219211","https://openalex.org/W1969349392","https://openalex.org/W1980517404","https://openalex.org/W1980656680","https://openalex.org/W1984259235","https://openalex.org/W1991383761","https://openalex.org/W1996136679","https://openalex.org/W2005430558","https://openalex.org/W2013012235","https://openalex.org/W2013277984","https://openalex.org/W2015739639","https://openalex.org/W2018756677","https://openalex.org/W2026516256","https://openalex.org/W2026731828","https://openalex.org/W2031915568","https://openalex.org/W2038241717","https://openalex.org/W2041783562","https://openalex.org/W2052417512","https://openalex.org/W2057086303","https://openalex.org/W2062672310","https://openalex.org/W2072831861","https://openalex.org/W2085827136","https://openalex.org/W2090253867","https://openalex.org/W2092842298","https://openalex.org/W2109060808","https://openalex.org/W2121089710","https://openalex.org/W2133039566","https://openalex.org/W2138709157","https://openalex.org/W2148620491","https://openalex.org/W2162621793","https://openalex.org/W2165467455","https://openalex.org/W2165596211","https://openalex.org/W2169056238","https://openalex.org/W2185907055","https://openalex.org/W2212036697","https://openalex.org/W2295562782","https://openalex.org/W2313469048","https://openalex.org/W2489748212","https://openalex.org/W2600442579","https://openalex.org/W2788164529","https://openalex.org/W2997276011","https://openalex.org/W3004027760","https://openalex.org/W3081508098","https://openalex.org/W4229645516","https://openalex.org/W4245245123","https://openalex.org/W4247208831","https://openalex.org/W4251116699","https://openalex.org/W4285719527","https://openalex.org/W6981392789","https://openalex.org/W6982543921","https://openalex.org/W7061297332"],"related_works":["https://openalex.org/W1501096916","https://openalex.org/W2051202380","https://openalex.org/W2626646980","https://openalex.org/W2161109697","https://openalex.org/W2087633432","https://openalex.org/W7010030612","https://openalex.org/W2374140355","https://openalex.org/W1966416901","https://openalex.org/W7096192857","https://openalex.org/W7097526562"],"abstract_inverted_index":{"The":[0],"application":[1],"of":[2,82],"traditional":[3],"database":[4,21,33],"query":[5,34,45,59],"languages,":[6],"primarily":[7],"the":[8,31,51,86,90],"Structured":[9],"Query":[10],"Language":[11],"SQL,":[12],"for":[13,56,61],"geographical":[14],"information":[15],"systems":[16],"(GIS)":[17],"and":[18,64],"other":[19],"non\u2013standard":[20],"applications":[22],"has":[23,79],"been":[24,38],"tried":[25],"unsuccessfully;":[26],"therefore,":[27],"several":[28],"extensions":[29],"to":[30,40,88],"relational":[32],"language":[35,60],"SQL":[36,52,67,77],"have":[37],"proposed":[39],"serve":[41],"as":[42],"a":[43,62,71,80],"spatial":[44,76,92],"language.":[46],"It":[47],"is":[48,54,68],"argued":[49],"that":[50],"framework":[53],"inappropriate":[55],"an":[57,65],"interactive":[58],"GIS":[63],"extended":[66],"at":[69],"best":[70],"short":[72],"term":[73],"solution.":[74],"Any":[75],"dialect":[78],"number":[81],"serious":[83],"deficiencies,":[84],"particularly":[85],"patches":[87],"incorporate":[89],"necessary":[91],"concepts":[93],"into":[94],"SQL.":[95]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2023980474","counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2017,"cited_by_count":3},{"year":2014,"cited_by_count":2},{"year":2012,"cited_by_count":2}],"updated_date":"2026-11-17T12:49:18.490984","created_date":"2016-06-24T00:00:00"}
