{"id":"https://openalex.org/W2163767657","doi":"https://doi.org/10.1145/234313.234374","title":"SQL language summary","display_name":"SQL language summary","publication_year":1996,"publication_date":"1996-03-01","ids":{"openalex":"https://openalex.org/W2163767657","doi":"https://doi.org/10.1145/234313.234374","mag":"2163767657"},"language":"en","primary_location":{"id":"doi:10.1145/234313.234374","doi":"https://doi.org/10.1145/234313.234374","is_oa":true,"landing_page_url":"https://doi.org/10.1145/234313.234374","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/234313.234374","source":{"id":"https://openalex.org/S157921468","display_name":"ACM Computing Surveys","issn_l":"0360-0300","issn":["0360-0300","1557-7341"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-a","jufo-3","ki-jl-2","norway-2","poland-200","russia-white-list-1","vabb-shw"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Computing Surveys","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://dl.acm.org/doi/pdf/10.1145/234313.234374","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5111508898","display_name":"Jim Melton","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Jim Melton","raw_affiliation_strings":["Sybase, Inc., Sandy, Utah"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Sybase, Inc., Sandy, Utah","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5111508898"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.2596,"has_fulltext":true,"cited_by_count":24,"citation_normalized_percentile":{"value":0.81052916,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":95},"biblio":{"volume":"28","issue":"1","first_page":"141","last_page":"143"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9965999722480774,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9965999722480774,"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/T10126","display_name":"Logic, programming, and type systems","score":0.001500000013038516,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T13681","display_name":"Engineering and Information Technology","score":0.00039999998989515007,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/sql","display_name":"SQL","score":0.9919999837875366},{"id":"https://openalex.org/keywords/database-query-languages","display_name":"database query languages","score":0.39100000262260437}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8658236265182495},{"id":"https://openalex.org/C2778805511","wikidata":"https://www.wikidata.org/wiki/Q1713","display_name":"Citation","level":2,"score":0.8045214414596558},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5280203223228455},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.4736439287662506},{"id":"https://openalex.org/C2984286706","wikidata":"https://www.wikidata.org/wiki/Q400708","display_name":"Sql server","level":2,"score":0.43211090564727783},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.33634448051452637}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/234313.234374","doi":"https://doi.org/10.1145/234313.234374","is_oa":true,"landing_page_url":"https://doi.org/10.1145/234313.234374","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/234313.234374","source":{"id":"https://openalex.org/S157921468","display_name":"ACM Computing Surveys","issn_l":"0360-0300","issn":["0360-0300","1557-7341"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-a","jufo-3","ki-jl-2","norway-2","poland-200","russia-white-list-1","vabb-shw"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Computing Surveys","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.622.6927","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.622.6927","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://jpkc.yzu.edu.cn/course2/sjkyljyy/dzjc/part 3 - the sql language, its extension, standardization and implementation/(pod-r3-1) sql language summary.pdf","raw_type":"text"}],"best_oa_location":{"id":"doi:10.1145/234313.234374","doi":"https://doi.org/10.1145/234313.234374","is_oa":true,"landing_page_url":"https://doi.org/10.1145/234313.234374","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/234313.234374","source":{"id":"https://openalex.org/S157921468","display_name":"ACM Computing Surveys","issn_l":"0360-0300","issn":["0360-0300","1557-7341"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-a","jufo-3","ki-jl-2","norway-2","poland-200","russia-white-list-1","vabb-shw"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Computing Surveys","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2163767657.pdf","grobid_xml":"https://content.openalex.org/works/W2163767657.grobid-xml"},"referenced_works_count":3,"referenced_works":["https://openalex.org/W1554917839","https://openalex.org/W2012056301","https://openalex.org/W2185907055"],"related_works":["https://openalex.org/W4250971731","https://openalex.org/W1482342154","https://openalex.org/W4206310829","https://openalex.org/W4253442869","https://openalex.org/W4234537680","https://openalex.org/W7097288861","https://openalex.org/W157322357","https://openalex.org/W7018339042","https://openalex.org/W2026523305","https://openalex.org/W1994580752"],"abstract_inverted_index":{"SQL":[0,62],"is":[1,8,27],"a":[2,10,23,29,33,56],"relational":[3],"database":[4],"data":[5],"sub-language.":[6],"It":[7,26],"not":[9],"complete":[11],"program-ming":[12],"language,":[13],"but":[14],"depends":[15],"on":[16,72,77],"the":[17,69],"I/O":[18],"and":[19,32,65],"control":[20],"facilities":[21],"of":[22,46],"host":[24],"language.":[25],"both":[28],"de":[30,34],"jure":[31],"facto":[35],"standard.":[36],"ANSI":[37],"(American":[38],"National":[39],"Standards":[40],"Institute)":[41],"has":[42,49,58],"published":[43,60],"three":[44],"generations":[45],"SQL,":[47,75],"as":[48],"ISO":[50],"(International":[51],"Organization":[52],"for":[53,81],"Stan-dardization).":[54],"X/Open,":[55],"consortium,":[57],"also":[59],"an":[61],"specification.":[63],"Chamberlin":[64],"Boyce":[66],"[1974]":[67],"pub-lished":[68],"first":[70],"paper":[71],"what":[73],"became":[74],"based":[76],"Codd\u2019s":[78],"mathematical":[79],"foundation":[80],"logical":[82],"representation":[83]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":2},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-11-12T12:28:57.059296","created_date":"2016-06-24T00:00:00"}