{"id":"https://openalex.org/W1583071230","doi":"https://doi.org/10.1007/978-1-4302-6221-3_4","title":"SQL Is about Sets","display_name":"SQL Is about Sets","alternate_titles":[],"publication_year":2013,"publication_date":"2013-09-20","ids":{"openalex":"https://openalex.org/W1583071230","doi":"https://doi.org/10.1007/978-1-4302-6221-3_4","mag":"1583071230"},"language":"en","primary_location":{"id":"doi:10.1007/978-1-4302-6221-3_4","doi":"https://doi.org/10.1007/978-1-4302-6221-3_4","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-6221-3_4","pdf_url":null,"source":{"id":"https://openalex.org/S4306462844","display_name":"Apress eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Pro Oracle SQL","raw_type":"book-chapter"},"parent_works":[{"id":"https://openalex.org/W4253488555","display_name":"Pro Oracle SQL","relationship":"volume"}],"lineage":["https://openalex.org/W1583071230","https://openalex.org/W4253488555"],"child_works_count":0,"type":"book-chapter","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/A5041055567","display_name":"Karen Morton","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Karen Morton","raw_affiliation_strings":["FL, US"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"FL, US","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5072208541","display_name":"Kerry Osborne","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Kerry Osborne","raw_affiliation_strings":["FL, US"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"FL, US","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034131896","display_name":"Robyn Sands","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Robyn Sands","raw_affiliation_strings":["FL, US"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"FL, US","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5033828072","display_name":"Riyaj Shamsudeen","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Riyaj Shamsudeen","raw_affiliation_strings":["FL, US"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"FL, US","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5016102007","display_name":"Jared Still","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Jared Still","raw_affiliation_strings":["FL, US"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"FL, US","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"95","last_page":"113"},"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.9955999851226807,"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.9955999851226807,"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/T10533","display_name":"Teaching and Learning Programming","score":0.0017000000225380063,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"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.000699999975040555,"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.9890000224113464},{"id":"https://openalex.org/keywords/declarative-programming","display_name":"declarative programming","score":0.9290000200271606},{"id":"https://openalex.org/keywords/procedural-programming","display_name":"procedural programming","score":0.859000027179718},{"id":"https://openalex.org/keywords/query-optimization","display_name":"query optimization","score":0.6679999828338623},{"id":"https://openalex.org/keywords/relational-databases","display_name":"relational databases","score":0.39800000190734863}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7878175973892212},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7733173370361328},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.6487656235694885},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.6234527826309204},{"id":"https://openalex.org/C28719098","wikidata":"https://www.wikidata.org/wiki/Q44946","display_name":"Point (geometry)","level":2,"score":0.5697708129882812},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.4447006583213806},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.23140692710876465},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.1836795210838318},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.10111662745475769},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-1-4302-6221-3_4","doi":"https://doi.org/10.1007/978-1-4302-6221-3_4","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-6221-3_4","pdf_url":null,"source":{"id":"https://openalex.org/S4306462844","display_name":"Apress eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Pro Oracle SQL","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2781548870","https://openalex.org/W237218062","https://openalex.org/W2488763094","https://openalex.org/W4206597390","https://openalex.org/W3021570926","https://openalex.org/W2617973736","https://openalex.org/W2041668556","https://openalex.org/W1413831282","https://openalex.org/W4235753949","https://openalex.org/W4312142200"],"abstract_inverted_index":{"One":[0],"of":[1,98,116],"the":[2,51,118],"most":[3],"difficult":[4],"transitions":[5],"to":[6,8,17,22,32,34,91,110,112,124,139],"make":[7],"become":[9,125],"highly":[10,137],"proficient":[11,127],"at":[12,128],"writing":[13,129],"SQL":[14,86,130],"well":[15],"is":[16,29,50,88,132],"shift":[18,111],"from":[19,94,101],"thinking":[20,23],"procedurally":[21],"declaratively":[24],"(or":[25],"in":[26,36,78],"sets).":[27],"It":[28],"often":[30],"hardest":[31],"learn":[33],"think":[35],"sets":[37],"if":[38],"you\u2019ve":[39],"spent":[40],"time":[41],"working":[42,73],"with":[43,60,74],"virtually":[44],"any":[45],"programming":[46],"language.":[47],"If":[48],"this":[49],"case":[52],"for":[53,122],"you,":[54],"you":[55,109,123],"are":[56],"likely":[57],"very":[58,80],"comfortable":[59],"constructs":[61,71],"such":[62],"as":[63],"IF-THEN-ELSE,":[64],"WHILE-DO,":[65],"LOOP-END":[66],"LOOP,":[67],"and":[68,76,135],"BEGIN-END.":[69],"These":[70],"support":[72],"logic":[75],"data":[77],"a":[79,95,102,113],"procedural,":[81],"step-by-step,":[82],"top-down\u2013type":[83],"approach.":[84],"The":[85,105],"language":[87],"not":[89],"intended":[90],"be":[92],"implemented":[93],"procedural":[96],"point":[97,115],"view,":[99,117],"but":[100],"set-oriented":[103,114],"one.":[104],"longer":[106,119],"it":[107,120],"takes":[108,121],"truly":[126],"that":[131],"functionally":[133],"correct":[134],"also":[136],"optimized":[138],"perform":[140],"well.":[141]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W1583071230","counts_by_year":[],"updated_date":"2026-11-15T12:55:33.944570","created_date":"2016-06-24T00:00:00"}
