{"id":"https://openalex.org/W2024948003","doi":"https://doi.org/10.1145/126482.126484","title":"Technique for universal quantification in SQL","display_name":"Technique for universal quantification in SQL","alternate_titles":[],"publication_year":1991,"publication_date":"1991-09-01","ids":{"openalex":"https://openalex.org/W2024948003","doi":"https://doi.org/10.1145/126482.126484","mag":"2024948003"},"language":"en","primary_location":{"id":"doi:10.1145/126482.126484","doi":"https://doi.org/10.1145/126482.126484","is_oa":false,"landing_page_url":"https://doi.org/10.1145/126482.126484","pdf_url":null,"source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","jufo-1","norway-1","poland-70","russia-white-list-2","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 SIGMOD Record","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W2024948003"],"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/A5049703430","display_name":"Claudio Fratarcangeli","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Claudio Fratarcangeli","raw_affiliation_strings":["Black Diamond Software, Inc. 127 Wilton Road East, Ridgefield, Connecticut"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Black Diamond Software, Inc. 127 Wilton Road East, Ridgefield, Connecticut","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5049703430"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.753,"has_fulltext":false,"cited_by_count":9,"citation_normalized_percentile":{"value":0.85250666,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":87,"max":95},"biblio":{"volume":"20","issue":"3","first_page":"16","last_page":"24"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9926999807357788,"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.9926999807357788,"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.0017999999690800905,"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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.0012000000569969416,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/universal-quantification","display_name":"universal quantification","score":0.9990000128746033},{"id":"https://openalex.org/keywords/query-construction","display_name":"query construction","score":0.574999988079071}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8846878409385681},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7052115797996521},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.6261042952537537},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5255783200263977},{"id":"https://openalex.org/C2778029271","wikidata":"https://www.wikidata.org/wiki/Q5421931","display_name":"Extension (predicate logic)","level":2,"score":0.5164011120796204},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.45134541392326355},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.41091394424438477},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.38700032234191895},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.3097793161869049},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.18649783730506897},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.06129336357116699},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/126482.126484","doi":"https://doi.org/10.1145/126482.126484","is_oa":false,"landing_page_url":"https://doi.org/10.1145/126482.126484","pdf_url":null,"source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","jufo-1","norway-1","poland-70","russia-white-list-2","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 SIGMOD Record","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":3,"referenced_works":["https://openalex.org/W146964180","https://openalex.org/W2013012235","https://openalex.org/W2162621793"],"related_works":["https://openalex.org/W2157365498","https://openalex.org/W2171712206","https://openalex.org/W2052914740","https://openalex.org/W1885684430","https://openalex.org/W2376525116","https://openalex.org/W2154751879","https://openalex.org/W1996467498","https://openalex.org/W7125465663","https://openalex.org/W2787659112","https://openalex.org/W297262571"],"abstract_inverted_index":{"Universal":[0],"quantification":[1,10,19,31,47,72],"is":[2,13,56,79],"expressed":[3,42],"in":[4,20,74],"ANSI":[5,21,75,86],"SQL":[6,87],"with":[7],"negated":[8,52],"existential":[9,53],"because":[11,38],"there":[12],"no":[14],"direct":[15],"support":[16,28,92],"for":[17,29,93],"universal":[18,30,46,71,94],"SQL.":[22,76],"However,":[23],"the":[24,33,36,57,68],"lack":[25],"of":[26,35,59,70],"explicit":[27,90],"diminishes":[32],"userfriendliness":[34],"language":[37],"some":[39],"queries":[40,73],"are":[41,50],"more":[43],"naturally":[44],"using":[45,51],"than":[48],"they":[49],"quantification.":[54,95],"It":[55],"intent":[58],"this":[60],"paper":[61],"to":[62,66,85,88],"describe":[63],"a":[64,82],"technique":[65,78],"facilitate":[67],"construction":[69],"The":[77],"based":[80],"upon":[81],"proposed":[83],"extension":[84],"incorporate":[89],"general":[91]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2024948003","counts_by_year":[{"year":2015,"cited_by_count":2},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-11-17T12:49:18.490984","created_date":"2016-06-24T00:00:00"}
