{"id":"https://openalex.org/W7139994977","doi":"https://doi.org/10.1016/j.fsidi.2026.302100","title":"AI-based automated SQL query generation for SQLite databases in Mobile forensics","display_name":"AI-based automated SQL query generation for SQLite databases in Mobile forensics","publication_year":2026,"publication_date":"2026-03-21","ids":{"openalex":"https://openalex.org/W7139994977","doi":"https://doi.org/10.1016/j.fsidi.2026.302100"},"language":"en","primary_location":{"id":"doi:10.1016/j.fsidi.2026.302100","is_oa":true,"landing_page_url":"https://doi.org/10.1016/j.fsidi.2026.302100","pdf_url":null,"source":{"id":"https://openalex.org/S4210178067","display_name":"Forensic Science International Digital Investigation","issn_l":"2666-2817","issn":["2666-2817","2666-2825"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Forensic Science International: Digital Investigation","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://doi.org/10.1016/j.fsidi.2026.302100","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5048753764","display_name":"Dirk Pawlaszczyk","orcid":"https://orcid.org/0000-0001-7485-7478"},"institutions":[{"id":"https://openalex.org/I116397343","display_name":"Hochschule Mittweida","ror":"https://ror.org/024ga3r86","country_code":"DE","type":"education","lineage":["https://openalex.org/I116397343"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Dirk Pawlaszczyk","raw_affiliation_strings":["Faculty of Computer Sciences, Hochschule Mittweida, Technikumplatz 17, Mittweida, 09648, Saxonia, Germany"],"raw_orcid":"https://orcid.org/0000-0001-7485-7478","affiliations":[{"raw_affiliation_string":"Faculty of Computer Sciences, Hochschule Mittweida, Technikumplatz 17, Mittweida, 09648, Saxonia, Germany","institution_ids":["https://openalex.org/I116397343"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5106803005","display_name":"Ronny Bodach","orcid":null},"institutions":[{"id":"https://openalex.org/I116397343","display_name":"Hochschule Mittweida","ror":"https://ror.org/024ga3r86","country_code":"DE","type":"education","lineage":["https://openalex.org/I116397343"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Ronny Bodach","raw_affiliation_strings":["Faculty of Computer Sciences, Hochschule Mittweida, Technikumplatz 17, Mittweida, 09648, Saxonia, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Computer Sciences, Hochschule Mittweida, Technikumplatz 17, Mittweida, 09648, Saxonia, Germany","institution_ids":["https://openalex.org/I116397343"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027223908","display_name":"Philipp Engler","orcid":"https://orcid.org/0000-0001-7279-8769"},"institutions":[{"id":"https://openalex.org/I116397343","display_name":"Hochschule Mittweida","ror":"https://ror.org/024ga3r86","country_code":"DE","type":"education","lineage":["https://openalex.org/I116397343"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Philipp Engler","raw_affiliation_strings":["Faculty of Computer Sciences, Hochschule Mittweida, Technikumplatz 17, Mittweida, 09648, Saxonia, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Computer Sciences, Hochschule Mittweida, Technikumplatz 17, Mittweida, 09648, Saxonia, Germany","institution_ids":["https://openalex.org/I116397343"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038763330","display_name":"Jan Kolouch","orcid":"https://orcid.org/0000-0003-2371-8376"},"institutions":[{"id":"https://openalex.org/I105410415","display_name":"University of Finance and Administration","ror":"https://ror.org/020ydms54","country_code":"CZ","type":"education","lineage":["https://openalex.org/I105410415"]}],"countries":["CZ"],"is_corresponding":false,"raw_author_name":"Jan Kolouch","raw_affiliation_strings":["AMBIS Vysok\u00e1 \u0161kola, A.S., Lindnerova 575/1, Praha, 180 00 Praha 8, Czech Republic"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"AMBIS Vysok\u00e1 \u0161kola, A.S., Lindnerova 575/1, Praha, 180 00 Praha 8, Czech Republic","institution_ids":["https://openalex.org/I105410415"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5054853643","display_name":"Michael Spranger","orcid":"https://orcid.org/0000-0002-6780-0841"},"institutions":[{"id":"https://openalex.org/I116397343","display_name":"Hochschule Mittweida","ror":"https://ror.org/024ga3r86","country_code":"DE","type":"education","lineage":["https://openalex.org/I116397343"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Michael Spranger","raw_affiliation_strings":["Faculty of Computer Sciences, Hochschule Mittweida, Technikumplatz 17, Mittweida, 09648, Saxonia, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Computer Sciences, Hochschule Mittweida, Technikumplatz 17, Mittweida, 09648, Saxonia, Germany","institution_ids":["https://openalex.org/I116397343"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5048437084","display_name":"Christian Hummert","orcid":"https://orcid.org/0000-0002-9932-3779"},"institutions":[{"id":"https://openalex.org/I116397343","display_name":"Hochschule Mittweida","ror":"https://ror.org/024ga3r86","country_code":"DE","type":"education","lineage":["https://openalex.org/I116397343"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Christian Hummert","raw_affiliation_strings":["Faculty of Computer Sciences, Hochschule Mittweida, Technikumplatz 17, Mittweida, 09648, Saxonia, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Computer Sciences, Hochschule Mittweida, Technikumplatz 17, Mittweida, 09648, Saxonia, Germany","institution_ids":["https://openalex.org/I116397343"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5023295736","display_name":"Dirk Labudde","orcid":"https://orcid.org/0000-0003-0466-0017"},"institutions":[{"id":"https://openalex.org/I116397343","display_name":"Hochschule Mittweida","ror":"https://ror.org/024ga3r86","country_code":"DE","type":"education","lineage":["https://openalex.org/I116397343"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Dirk Labudde","raw_affiliation_strings":["Faculty of Computer Sciences, Hochschule Mittweida, Technikumplatz 17, Mittweida, 09648, Saxonia, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Computer Sciences, Hochschule Mittweida, Technikumplatz 17, Mittweida, 09648, Saxonia, Germany","institution_ids":["https://openalex.org/I116397343"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5048753764"],"corresponding_institution_ids":["https://openalex.org/I116397343"],"apc_list":{"value":2950,"currency":"USD","value_usd":2950},"apc_paid":{"value":2950,"currency":"USD","value_usd":2950},"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.35616875,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"57","issue":null,"first_page":"302100","last_page":"302100"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12034","display_name":"Digital and Cyber Forensics","score":0.9959999918937683,"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/T12034","display_name":"Digital and Cyber Forensics","score":0.9959999918937683,"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/T12357","display_name":"Digital Media Forensic Detection","score":0.00039999998989515007,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/T10751","display_name":"Forensic and Genetic Research","score":0.0003000000142492354,"subfield":{"id":"https://openalex.org/subfields/1311","display_name":"Genetics"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6733999848365784},{"id":"https://openalex.org/keywords/digital-forensics","display_name":"Digital forensics","score":0.6141999959945679},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.5437999963760376},{"id":"https://openalex.org/keywords/mobile-phone","display_name":"Mobile phone","score":0.4471000134944916},{"id":"https://openalex.org/keywords/mobile-device","display_name":"Mobile device","score":0.4205999970436096},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.40220001339912415},{"id":"https://openalex.org/keywords/domain","display_name":"Domain (mathematical analysis)","score":0.3684000074863434}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.853600025177002},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6733999848365784},{"id":"https://openalex.org/C84418412","wikidata":"https://www.wikidata.org/wiki/Q3246940","display_name":"Digital forensics","level":2,"score":0.6141999959945679},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.5437999963760376},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5170000195503235},{"id":"https://openalex.org/C2777421447","wikidata":"https://www.wikidata.org/wiki/Q17517","display_name":"Mobile phone","level":2,"score":0.4471000134944916},{"id":"https://openalex.org/C186967261","wikidata":"https://www.wikidata.org/wiki/Q5082128","display_name":"Mobile device","level":2,"score":0.4205999970436096},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.40220001339912415},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3709999918937683},{"id":"https://openalex.org/C36503486","wikidata":"https://www.wikidata.org/wiki/Q11235244","display_name":"Domain (mathematical analysis)","level":2,"score":0.3684000074863434},{"id":"https://openalex.org/C2988145974","wikidata":"https://www.wikidata.org/wiki/Q620615","display_name":"Mobile apps","level":2,"score":0.36419999599456787},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.35670000314712524},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.3190999925136566},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3149000108242035},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.29809999465942383},{"id":"https://openalex.org/C124978682","wikidata":"https://www.wikidata.org/wiki/Q1201019","display_name":"Proof of concept","level":2,"score":0.29280000925064087},{"id":"https://openalex.org/C127353759","wikidata":"https://www.wikidata.org/wiki/Q6887091","display_name":"Mobile database","level":4,"score":0.25540000200271606},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.2517000138759613}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1016/j.fsidi.2026.302100","is_oa":true,"landing_page_url":"https://doi.org/10.1016/j.fsidi.2026.302100","pdf_url":null,"source":{"id":"https://openalex.org/S4210178067","display_name":"Forensic Science International Digital Investigation","issn_l":"2666-2817","issn":["2666-2817","2666-2825"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Forensic Science International: Digital Investigation","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1016/j.fsidi.2026.302100","is_oa":true,"landing_page_url":"https://doi.org/10.1016/j.fsidi.2026.302100","pdf_url":null,"source":{"id":"https://openalex.org/S4210178067","display_name":"Forensic Science International Digital Investigation","issn_l":"2666-2817","issn":["2666-2817","2666-2825"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Forensic Science International: Digital Investigation","raw_type":"journal-article"},"sustainable_development_goals":[{"score":0.5797225832939148,"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[{"id":"https://openalex.org/F4320337753","display_name":"Interreg","ror":null}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":6,"referenced_works":["https://openalex.org/W1682403713","https://openalex.org/W2791387126","https://openalex.org/W3007797386","https://openalex.org/W4309949326","https://openalex.org/W4398794922","https://openalex.org/W4410929991"],"related_works":[],"abstract_inverted_index":{"SQLite":[0,23,94,183],"databases":[1,95],"play":[2],"a":[3,106,125,131,140,175,193,213,237,251],"central":[4],"role":[5],"in":[6,58,160],"mobile":[7,107,146,243],"phone":[8],"forensics.":[9,244],"Mobile":[10],"applications":[11],"frequently":[12],"use":[13,120],"them":[14],"for":[15,27,86,231,242],"data":[16,24,64,209],"storage.":[17],"Efficient":[18],"extraction":[19],"and":[20,31,41,62,98,115,187,239],"interpretation":[21],"of":[22,83,195,228,236,247,257],"are":[25],"crucial":[26],"reconstructing":[28],"device":[29],"usage":[30],"user":[32],"activities.":[33],"In":[34,66],"practice,":[35],"digital":[36,76],"forensic":[37,77,87,108,147,162,168,232],"investigators":[38,78,91,223],"must":[39],"formulate":[40],"analyse":[42],"complex":[43],"SQL":[44,84,229],"queries":[45,85,230],"to":[46,74,92,123,145,156,221],"retrieve":[47],"evidence":[48],"from":[49],"various":[50],"heterogeneous":[51],"databases.":[52],"This":[53,89],"task":[54],"requires":[55],"extensive":[56],"expertise":[57],"SQL,":[59],"database":[60,116],"schemas,":[61,184],"application-specific":[63],"logic.":[65],"this":[67,121],"paper,":[68],"we":[69,104,197],"investigate":[70],"an":[71,248],"LLM-based":[72,219],"approach":[73,220],"assist":[75,222],"by":[79,180,224],"automating":[80,225],"the":[81,200,207,226,258],"generation":[82,170,215,227],"analysis.":[88,233],"enables":[90],"query":[93],"more":[96],"efficiently":[97],"with":[99,152,174,250,261],"less":[100],"technical":[101],"effort.":[102],"First,":[103],"propose":[105],"dataset":[109,122,143,241],"that":[110,166],"captures":[111],"typical":[112],"investigative":[113],"questions":[114],"structures.":[117],"We":[118,128,149,164],"then":[119],"fine-tune":[124],"local":[126],"LLM.":[127,263],"introduce":[129],"ForSQLiteLM,":[130],"Llama":[132],"3.2-3B":[133],"bf16":[134],"model.":[135],"It":[136],"is":[137],"optimized":[138],"on":[139],"self-defined,":[141],"domain-specific":[142],"tailored":[144],"scenarios.":[148],"compare":[150],"ForSQLiteLM":[151],"several":[153],"state-of-the-art":[154],"LLMs":[155],"evaluate":[157],"its":[158],"effectiveness":[159],"generating":[161],"queries.":[163],"show":[165],"effective":[167],"Text-to-SQL":[169],"can":[171,203],"be":[172,204],"achieved":[173],"locally":[176],"deployable":[177],"3B-parameter":[178],"LLM":[179,249],"combining":[181],"realistic":[182],"execution-based":[185],"evaluation,":[186],"domain-":[188],"specific":[189],"fine-tuning.":[190],"Finally,":[191],"as":[192],"proof":[194],"concept,":[196],"demonstrate":[198],"how":[199],"proposed":[201],"model":[202,260],"integrated":[205],"into":[206],"FQLite":[208],"retrieval":[210],"tool":[211],"via":[212],"retrieval-augmented":[214],"(RAG)":[216],"pipeline.":[217],"\u2022":[218,234,245,254,264],"Introduction":[235],"novel":[238],"unique":[240],"Fine-tuning":[246],"domain":[252],"dataset.":[253],"Benchmark":[255],"study":[256],"finetuned":[259],"other":[262],"Proof-of-Concept":[265],"study.":[266]},"counts_by_year":[],"updated_date":"2026-03-22T06:30:12.169137","created_date":"2026-03-22T00:00:00"}