{"id":"https://openalex.org/W2743572064","doi":null,"title":"The SQL Guide to SQLite","display_name":"The SQL Guide to SQLite","publication_year":2009,"publication_date":"2009-09-07","ids":{"openalex":"https://openalex.org/W2743572064","mag":"2743572064"},"language":"ja","primary_location":{"id":"mag:2743572064","doi":null,"is_oa":false,"landing_page_url":"https://dl.acm.org/citation.cfm?id=1804487","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},"volume":null,"type":"book","is_traditional":true,"indexed_in":[],"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/A5033726948","display_name":"Rick F. van der Lans","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Rick F. van der Lans","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5033726948"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.2815,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.70120025,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"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.9814000129699707,"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.9814000129699707,"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.014800000004470348,"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.0003000000142492354,"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":1.0},{"id":"https://openalex.org/keywords/sql-dialects","display_name":"SQL dialects","score":0.7179999947547913},{"id":"https://openalex.org/keywords/embedded-databases","display_name":"embedded databases","score":0.8500000238418579},{"id":"https://openalex.org/keywords/relational-databases","display_name":"relational databases","score":0.6129999756813049},{"id":"https://openalex.org/keywords/database-management","display_name":"database management","score":0.6100000143051147},{"id":"https://openalex.org/keywords/open-source-software","display_name":"open source software","score":0.7459999918937683},{"id":"https://openalex.org/keywords/database-programming","display_name":"database programming","score":0.3959999978542328}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7527401447296143},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7224922180175781},{"id":"https://openalex.org/C2984286706","wikidata":"https://www.wikidata.org/wiki/Q400708","display_name":"Sql server","level":2,"score":0.6476232409477234},{"id":"https://openalex.org/C3018397939","wikidata":"https://www.wikidata.org/wiki/Q3644502","display_name":"Open source","level":3,"score":0.6072165369987488},{"id":"https://openalex.org/C114724005","wikidata":"https://www.wikidata.org/wiki/Q5001740","display_name":"Business Intelligence Markup Language","level":5,"score":0.5496857166290283},{"id":"https://openalex.org/C43126263","wikidata":"https://www.wikidata.org/wiki/Q128751","display_name":"Source code","level":2,"score":0.4867594242095947},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.480266809463501},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.47314560413360596},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4636828303337097},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.4343586564064026},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.43427103757858276},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.43028247356414795},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.21829959750175476},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.18242892622947693},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.04486536979675293},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"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":"mag:2743572064","doi":null,"is_oa":false,"landing_page_url":"https://dl.acm.org/citation.cfm?id=1804487","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null}],"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/W2911236418","https://openalex.org/W2744428283","https://openalex.org/W4293278425","https://openalex.org/W7062808660","https://openalex.org/W4247256412","https://openalex.org/W2271490595","https://openalex.org/W2566800933","https://openalex.org/W4232158971","https://openalex.org/W3107629637","https://openalex.org/W188556086"],"abstract_inverted_index":{"SQLite":[0,24,44,60],"is":[1,10,18],"a":[2,32,50,69,72],"small,":[3],"fast,":[4],"embeddable,":[5],"SQL-based":[6],"database":[7],"server.":[8],"It":[9,48],"easy":[11],"to":[12,42],"install,":[13],"needs":[14],"no":[15],"management,":[16],"and":[17,35,46,71,82],"open":[19],"source.":[20],"This":[21],"book":[22,38,64,87],"describes":[23],"in":[25,59,85],"detail.":[26],"With":[27],"hundreds":[28],"of":[29,53],"examples,":[30],"plus":[31],"proven":[33],"approach":[34],"structure,":[36],"the":[37,54,78],"teaches":[39],"you":[40],"how":[41],"use":[43],"efficiently":[45],"effectively.":[47],"contains":[49],"complete":[51],"description":[52],"SQL":[55,80],"dialect":[56],"as":[57,68],"implemented":[58],"version":[61],"3.6.":[62],"The":[63],"can":[65,88],"be":[66,89],"seen":[67],"tutorial":[70],"reference":[73],"book.":[74],"Source":[75],"code":[76],"for":[77],"numerous":[79],"examples":[81],"exercises":[83],"included":[84],"this":[86],"downloaded":[90],"from":[91],"www.r20.nl.":[92]},"counts_by_year":[],"updated_date":"2025-11-06T04:12:42.849631","created_date":"2017-08-17T00:00:00"}