{"id":"https://openalex.org/W2554055692","doi":"https://doi.org/10.1007/978-1-4842-2232-4_12","title":"Analyzing SQLite Databases","display_name":"Analyzing SQLite Databases","publication_year":2016,"publication_date":"2016-01-01","ids":{"openalex":"https://openalex.org/W2554055692","doi":"https://doi.org/10.1007/978-1-4842-2232-4_12","mag":"2554055692"},"language":"en","primary_location":{"id":"doi:10.1007/978-1-4842-2232-4_12","doi":"https://doi.org/10.1007/978-1-4842-2232-4_12","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4842-2232-4_12","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":"Build iOS Database Apps with Swift and SQLite","raw_type":"book-chapter"},"parent_works":[{"id":"https://openalex.org/W2553567140","display_name":"Build iOS Database Apps with Swift and SQLite","relationship":"volume"}],"lineage":["https://openalex.org/W2554055692","https://openalex.org/W2553567140"],"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/A5086787796","display_name":"Kevin Languedoc","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Kevin Languedoc","raw_affiliation_strings":["Montreal, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Montreal, Canada","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5086787796"],"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":"187","last_page":"196"},"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.8515999913215637,"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.8515999913215637,"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/T12799","display_name":"Mobile and Web Applications","score":0.09799999743700027,"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.020600000396370888,"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.9810000061988831},{"id":"https://openalex.org/keywords/database-analysis","display_name":"database analysis","score":0.8270000219345093},{"id":"https://openalex.org/keywords/database-optimization","display_name":"database optimization","score":0.3190000057220459}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7374474406242371},{"id":"https://openalex.org/C2777026412","wikidata":"https://www.wikidata.org/wiki/Q2684591","display_name":"Statement (logic)","level":2,"score":0.6547964215278625},{"id":"https://openalex.org/C192209626","wikidata":"https://www.wikidata.org/wiki/Q190909","display_name":"Focus (optics)","level":2,"score":0.6429626941680908},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5877199172973633},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.45588621497154236},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.4365730285644531},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3850787878036499},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.2934703230857849},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C120665830","wikidata":"https://www.wikidata.org/wiki/Q14620","display_name":"Optics","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-1-4842-2232-4_12","doi":"https://doi.org/10.1007/978-1-4842-2232-4_12","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4842-2232-4_12","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":"Build iOS Database Apps with Swift and 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/W2782166769","https://openalex.org/W7199000214","https://openalex.org/W2361211760","https://openalex.org/W2592309168","https://openalex.org/W2949614329","https://openalex.org/W2472445480","https://openalex.org/W6948928822","https://openalex.org/W105812067","https://openalex.org/W2145542873","https://openalex.org/W7208065199"],"abstract_inverted_index":{"This":[0,65],"last":[1],"chapter":[2,43],"will":[3,45],"focus":[4],"on":[5],"the":[6,9,22,30,33,51,63,70,76],"different":[7],"tools":[8,35],"SQLite":[10],"platform":[11],"provides":[12],"to":[13],"help":[14],"you":[15],"analyze":[16],"your":[17],"app's":[18],"databases.":[19],"Except":[20],"for":[21],"ANALYZE":[23],"statement,":[24],"which":[25],"can":[26],"be":[27,73],"executed":[28],"with":[29],"sqlite3_exec":[31],"command,":[32],"other":[34],"are":[36],"external":[37],"software":[38],"programs.":[39],"Specifically,":[40],"in":[41],"this":[42],"we":[44],"discuss":[46],"and":[47,60,69],"explore,":[48],"through":[49],"examples,":[50],"following":[52],"technologies":[53],"These":[54],"keywords":[55,71],"were":[56],"added":[57],"by":[58,62],"machine":[59],"not":[61],"authors.":[64],"process":[66],"is":[67],"experimental":[68],"may":[72],"updated":[74],"as":[75],"learning":[77],"algorithm":[78],"improves.":[79]},"counts_by_year":[],"updated_date":"2026-11-14T11:04:58.165337","created_date":"2016-11-30T00:00:00"}