{"id":"https://openalex.org/W9101665","doi":"https://doi.org/10.1007/978-1-4302-3226-1_4","title":"Advanced SQL for SQLite","display_name":"Advanced SQL for SQLite","publication_year":2010,"publication_date":"2010-01-01","ids":{"openalex":"https://openalex.org/W9101665","doi":"https://doi.org/10.1007/978-1-4302-3226-1_4","mag":"9101665"},"language":"en","primary_location":{"id":"doi:10.1007/978-1-4302-3226-1_4","doi":"https://doi.org/10.1007/978-1-4302-3226-1_4","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-3226-1_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":"The Definitive Guide to SQLite","raw_type":"book-chapter"},"parent_works":[{"id":"https://openalex.org/W186032443","display_name":"The Definitive Guide to SQLite","relationship":"volume"}],"lineage":["https://openalex.org/W9101665","https://openalex.org/W186032443"],"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,"raw_author_name":"Grant Allen","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5024845821","display_name":"Mike Owens","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Mike Owens","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.00370566,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"87","last_page":"124"},"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.9839000105857849,"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.9839000105857849,"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.012299999594688416,"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/T10126","display_name":"Logic, programming, and type systems","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/sqlite","display_name":"SQLite","score":0.8629999756813049},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7540000081062317},{"id":"https://openalex.org/keywords/relational-databases","display_name":"relational databases","score":0.875}],"concepts":[{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.8535913228988647},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7849787473678589},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5458987951278687},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5182526111602783},{"id":"https://openalex.org/C2781426162","wikidata":"https://www.wikidata.org/wiki/Q2275793","display_name":"Casual","level":2,"score":0.5149829983711243},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.5107674598693848},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.4925723671913147},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.4747388958930969},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.4724569618701935},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.4516722559928894},{"id":"https://openalex.org/C113843644","wikidata":"https://www.wikidata.org/wiki/Q901882","display_name":"Interface (matter)","level":4,"score":0.42597970366477966},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3863532245159149},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.32858434319496155},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.2946549952030182},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.29225629568099976},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C157915830","wikidata":"https://www.wikidata.org/wiki/Q2928001","display_name":"Bubble","level":2,"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/C129307140","wikidata":"https://www.wikidata.org/wiki/Q6795880","display_name":"Maximum bubble pressure method","level":3,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"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.1007/978-1-4302-3226-1_4","doi":"https://doi.org/10.1007/978-1-4302-3226-1_4","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-3226-1_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":"The Definitive Guide to SQLite","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/W112968760","https://openalex.org/W6242651","https://openalex.org/W2462113029","https://openalex.org/W18261315","https://openalex.org/W2473968214","https://openalex.org/W2469459694","https://openalex.org/W2472478924","https://openalex.org/W4237412978","https://openalex.org/W4236090827","https://openalex.org/W4245467412"],"abstract_inverted_index":{"SQL":[0,67,95],"may":[1,163],"be":[2,36,87,164],"a":[3,12,50,56,75,90,104],"simple":[4],"language":[5],"to":[6,23,47,65,72,89,102,128,139],"use,":[7],"but":[8],"there":[9],"is":[10,41,117,158],"quite":[11],"bit":[13],"of":[14,31,97,113],"it,":[15],"and":[16,131,151,160],"it\u2019s":[17],"taken":[18],"us":[19],"two":[20],"chapters":[21],"just":[22],"introduce":[24,126],"the":[25,42,94,129,140,154,161,167],"major":[26],"concepts":[27],"for":[28],"SQLite\u2019s":[29],"implementation":[30],"SQL.":[32],"But":[33],"that":[34],"shouldn\u2019t":[35],"too":[37],"surprising,":[38],"because":[39],"it":[40,135],"sole":[43],"interface":[44],"through":[45],"which":[46],"interact":[48],"with":[49,74,82],"relational":[51,76],"database.":[52,77],"Whether":[53],"you":[54,63,69,79,85,100,127,133],"are":[55,70,80],"casual":[57],"user,":[58],"system":[59],"administrator,":[60],"or":[61],"developer,":[62],"have":[64],"know":[66,103],"if":[68],"going":[71],"work":[73],"If":[78],"programming":[81],"SQLite,":[83],"then":[84],"should":[86,121],"off":[88],"good":[91],"start":[92],"on":[93],"side":[96],"things.":[98],"Now":[99],"need":[101],"little":[105],"about":[106,110],"how":[107,134],"SQLite":[108,142],"goes":[109],"executing":[111],"all":[112],"these":[114],"commands.":[115],"This":[116,156],"where":[118],"Chapter":[119],"5":[120],"prove":[122],"useful.":[123],"It":[124],"will":[125],"API":[130],"show":[132],"works":[136],"in":[137],"relation":[138],"way":[141],"functions":[143],"internally.":[144],"These":[145],"keywords":[146,162],"were":[147],"added":[148],"by":[149,153],"machine":[150],"not":[152],"authors.":[155],"process":[157],"experimental":[159],"updated":[165],"as":[166],"learning":[168],"algorithm":[169],"improves.":[170]},"counts_by_year":[],"updated_date":"2026-11-14T11:04:58.165337","created_date":"2016-06-24T00:00:00"}