{"id":"https://openalex.org/W82060565","doi":"https://doi.org/10.1007/978-1-4302-2510-2_5","title":"Common Query Patterns","display_name":"Common Query Patterns","alternate_titles":[],"publication_year":2009,"publication_date":"2009-01-01","ids":{"openalex":"https://openalex.org/W82060565","doi":"https://doi.org/10.1007/978-1-4302-2510-2_5","mag":"82060565"},"language":"en","primary_location":{"id":"doi:10.1007/978-1-4302-2510-2_5","doi":"https://doi.org/10.1007/978-1-4302-2510-2_5","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-2510-2_5","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":"Oracle SQL Recipes","raw_type":"book-chapter"},"parent_works":[{"id":"https://openalex.org/W2499292213","display_name":"Oracle SQL Recipes","relationship":"volume"}],"lineage":["https://openalex.org/W82060565","https://openalex.org/W2499292213"],"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":null,"display_name":"Grant Allen","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Grant Allen","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5073027003","display_name":"Bob Bryla","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Bob Bryla","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5111441310","display_name":"Darl Kuhn","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Darl Kuhn","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"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":"109","last_page":"140"},"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.9897000193595886,"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.9897000193595886,"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/T13681","display_name":"Engineering and Information Technology","score":0.004900000058114529,"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/T11106","display_name":"Data Management and Algorithms","score":0.001500000013038516,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/trend-extrapolation","display_name":"trend extrapolation","score":0.7179999947547913},{"id":"https://openalex.org/keywords/database-queries","display_name":"database queries","score":0.3889999985694885}],"concepts":[{"id":"https://openalex.org/C88548561","wikidata":"https://www.wikidata.org/wiki/Q347599","display_name":"sort","level":2,"score":0.8142896890640259},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7735608220100403},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6442508697509766},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5000715255737305},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.49428725242614746},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.47966268658638},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.45658960938453674},{"id":"https://openalex.org/C17020691","wikidata":"https://www.wikidata.org/wiki/Q139677","display_name":"Operator (biology)","level":5,"score":0.4550919532775879},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.4263353645801544},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.40009865164756775},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.28112393617630005},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.10052844882011414},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.09367531538009644},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C86339819","wikidata":"https://www.wikidata.org/wiki/Q407384","display_name":"Transcription factor","level":3,"score":0.0},{"id":"https://openalex.org/C158448853","wikidata":"https://www.wikidata.org/wiki/Q425218","display_name":"Repressor","level":4,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-1-4302-2510-2_5","doi":"https://doi.org/10.1007/978-1-4302-2510-2_5","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-2510-2_5","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":"Oracle SQL Recipes","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W4250720622","https://openalex.org/W7095180874","https://openalex.org/W2626990892","https://openalex.org/W1662112478","https://openalex.org/W4416206346","https://openalex.org/W197321252","https://openalex.org/W4236544935","https://openalex.org/W2498857538","https://openalex.org/W2119944098","https://openalex.org/W4206797777"],"abstract_inverted_index":{"In":[0],"this":[1,72],"chapter":[2],"we":[3],"introduce":[4],"recipes":[5],"to":[6,68],"handle":[7],"many":[8],"common":[9],"query":[10],"patterns,":[11],"often":[12],"for":[13,27,43,51],"the":[14,39,83,90,96],"sort":[15],"of":[16],"problems":[17],"that":[18],"you":[19,70],"know":[20],"should":[21],"have":[22],"an":[23],"elegant":[24],"solution,":[25],"but":[26],"which":[28],"no":[29],"obvious":[30],"SQL":[31],"command":[32],"or":[33,57],"operator":[34],"exists.":[35],"Whether":[36],"it\u2019s":[37],"predicting":[38],"trend":[40],"in":[41,61,71],"data":[42,50],"extrapolation":[44],"and":[45,80,89],"planning":[46],"purposes,":[47],"paginating":[48],"your":[49,62],"display":[52],"on":[53],"a":[54,66],"web":[55],"site,":[56],"finding":[58],"lost":[59],"text":[60],"database,":[63],"you\u2019ll":[64],"find":[65],"recipe":[67],"suit":[69],"chapter.":[73],"These":[74],"keywords":[75,91],"were":[76],"added":[77],"by":[78,82],"machine":[79],"not":[81],"authors.":[84],"This":[85],"process":[86],"is":[87],"experimental":[88],"may":[92],"be":[93],"updated":[94],"as":[95],"learning":[97],"algorithm":[98],"improves.":[99]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W82060565","counts_by_year":[],"updated_date":"2026-11-14T11:04:58.165337","created_date":"2016-06-24T00:00:00"}
