Jong-Hyeok Park, Gihwan Oh, Sang-Won Lee,
The lightweight codebase of SQLite was helpful in making it become the de-facto standard database in most mobile devices, but, at the same time, ... write amplification. Thus, the write IO cost in SQLite is not lightweight at all. In this paper, to make SQLite truly lite in terms of IO efficiency for the transactional support, we propose SQLite/SSL , a per-transaction SQL statement logging scheme: when a transaction commits, SQLite/SSL ensures its durability by storing only SQL ... discarded, become an elegant and perfect fit for SQLite-based mobile applications. Further, we leverage the WAL ...
Tópico(s): Parallel Computing and Optimization Techniques
2017 - Association for Computing Machinery | Proceedings of the VLDB Endowment
Kevin P. Gaffney, Martin Prammer, Larry Brasfield, D. Richard Hipp, Dan W. Kennedy, Jignesh M. Patel,
In the two decades following its initial release, SQLite has become the most widely deployed database engine in existence. Today, SQLite is found in nearly every smartphone, computer, web ... file format. While it supports complex analytical queries, SQLite is primarily designed for fast online transaction processing ( ... processing (OLAP). DuckDB, a database engine nicknamed "the SQLite for analytics", has recently emerged to meet this ... performance on OLAP benchmarks, it is unclear how SQLite compares. Furthermore, we are aware of no work ...
Tópico(s): Advanced Database Systems and Queries
2022 - Association for Computing Machinery | Proceedings of the VLDB Endowment
Zhaoyan Shen, Yuanjing Shi, Zili Shao, Yong Guan,
SQLite has been deployed in millions of mobile devices from Web to smartphone applications on various mobile ... with the underlying file system (e.g., ext4), SQLite is not efficient with low transactions per second. ... we for the first time propose a new SQLite-like database engine, called SQLiteKV, which adopts the LSM-tree-based data structure but retains the SQLite operation interfaces. With its SQLite interface, SQLiteKV can be utilized by existing applications ... the front-end, we develop a light-weight SQLite-to-KV compiler to solve the semantic mismatch, ...
Tópico(s): Distributed systems and fault tolerance
2018 - Institute of Electrical and Electronics Engineers | IEEE Transactions on Computer-Aided Design of Integrated Circuits and Systems
Ming Xu, Jun Yao, Yizhi Ren, Jian Xu, Haiping Zhang, Ning Zheng, Shiyue Ling,
... Android user behavior information is automatically stored in SQLite to indicate when and what user behavior took ... reconstruct Android user behavior from YAFFS2 based on SQLite is proposed. Based on the storage mechanism of YAFFS2 file system and the file structures of SQLite, all of the SQLite records can be recovered from the Android image, regardless of whether the SQLite file has been deleted or not in YAFFS2, ... the user behaviors are parsed from those recovered SQLite records; then an Android user behavior timeline is ...
Tópico(s): Advanced Data Storage Technologies
2014 - Academy Publisher | Journal of Computers
David Bouyssié, M. Dubois, Sara Nasso, Anne Gonzalez de Peredo, Odile Burlet‐Schiltz, Ruedi Aebersold, Bernard Monsarrat,
... large MS data sets. It relies on the SQLite software library and consists of a standardized and ... license. mzDB can be easily accessed by the SQLite C library and its drivers for all major ... large MS data sets. It relies on the SQLite software library and consists of a standardized and ... license. mzDB can be easily accessed by the SQLite C library and its drivers for all major ... Scopus (15) Google Scholar), which is based on SQLite, a technology that allows implementing a portable, self- ... As the YAFMS format, mzDB is implemented using SQLite, which is commonly adopted in several computational projects ...
Tópico(s): Metabolomics and Mass Spectrometry Studies
2014 - Elsevier BV | Molecular & Cellular Proteomics
Gihwan Oh, Sang‐Chul Kim, Sang-Won Lee, Bongki Moon,
... compelling need to optimize the performance of sluggish SQLite databases. Popular mobile applications such as messenger, email and social network services rely on SQLite for their data management need. Those mobile applications ... management, and have implemented the key functions in SQLite/PPL. The hardware component of SQLite/PPL includes phase change memory (PCM) with a ... and adding it to the PCM log sector, SQLite/PPL can replace a multitude of successive page ... PCM much more efficiently. We have observed that SQLite/PPL would potentially improve the performance of mobile ...
Tópico(s): Caching and Content Delivery
2015 - Association for Computing Machinery | Proceedings of the VLDB Endowment
... as WhatsApp or Skype make use of the SQLite database format to store its data. From an ... essential to extract all information related to an SQLite database. In this paper we focus on digital traces in the scope of SQLite that belong to deleted database data. We suggest ... structural approach: we analyse the deletion behaviour of SQLite depending on different database parameters, which affect the erasure of database data. As SQLite pragmas are an important parameter during deletion, we ... evaluated with respect to a common dataset of SQLite files. The overall result is that bring2lite achieves ...
Tópico(s): Security and Verification in Computing
2019 - Elsevier BV | Digital Investigation
Produção Nacional
... 3 uses a new system, based on various SQLite databases, to store Internet history, bookmarks, form field ... unallocated disk space, due to the fact that SQLite utilizes temporary transaction files. The paper proposes an algorithm to recover deleted SQLite entries based on known internal record structures. The ... be used with other applications that also employ SQLite databases.
Tópico(s): Digital and Cyber Forensics
2009 - Elsevier BV | Digital Investigation
Oliver Kennedy, Jerry Ajay, Geoffrey Challen, Lukasz Ziarek,
Embedded database engines such as SQLite provide a convenient data persistence layer and have spread along with the applications using them to many types of systems, including ... the most widely-distributed smartphone platform, both uses SQLite internally and provides interfaces encouraging apps to use SQLite to store their own private structured data. As ... we present results from an experiment which recorded SQLite activity on 11 Android smartphones during one month of typical usage. Our analysis shows that Android SQLite usage produces queries and access patterns quite different ...
Tópico(s): Advanced Data Storage Technologies
2016 - Springer Science+Business Media | Lecture notes in computer science
Wook-Hee Kim, Jinwoong Kim, Woongki Baek, Beomseok Nam, Youjip Won,
... we develop NVWAL (NVRAM Write-Ahead Logging) for SQLite. The contribution of NVWAL consists of three elements: ( ... of managing persistent objects. We implemented NVWAL in SQLite and measured the performance on a Nexus 5 ... one-fifth (from 1942 nsec to 437 nsec), SQLite achieves a mere 4% performance gain (from 2517 ... latency of NVRAM is 2 usec, NVWAL increases SQLite performance by at least 10x compared to that ...
Tópico(s): Cloud Computing and Resource Management
2016 - Association for Computing Machinery | ACM SIGPLAN Notices
Sebastian Nemetz, Sven Schmitt, Felix C. Freiling,
... that claim to support rigorous forensic analysis of SQLite database files, claims that are not supported by appropriate evidence. We present a standardized corpus of SQLite files that can be used to evaluate and ... contains databases which use special features of the SQLite file format or contain potential pitfalls to detect ...
Tópico(s): Web Application Security Vulnerabilities
2018 - Elsevier BV | Digital Investigation
Yongzhi Wang, Yulong Shen, Cuicui Su, Jiawen Ma, Lingtong Liu, Xuewen Dong,
SQLite, one of the most popular light-weighted database system, has been widely used in various systems. However, the compact design of SQLite did not make enough consideration on user data ... proposed and developed the CryptSQLite, a high security SQLite database system, which protects both the confidentiality and ...
Tópico(s): Distributed systems and fault tolerance
2019 - Institute of Electrical and Electronics Engineers | IEEE Transactions on Computers
... the Android platform includes the popular open source SQLite database.SQLite is a software library that implements a SQL ... and there are little or medium size datasets, SQLite is the right choice.Purposed system gives the ...
Tópico(s): Advanced Database Systems and Queries
2014 - | International Journal of Research in Engineering and Technology
Heloise Pieterse, Martin S. Olivier,
... data. Data in smartphones is typically stored in SQLite databases and can, therefore, be easily transformed. To perform event reconstruction, multiple SQLite databases have to be integrated. This paper proposes ... allows for event reconstruction by querying the integrated SQLite databases collected from multiple smartphones. The process can ...
Tópico(s): Advanced Data Storage Technologies
2014 - Springer Science+Business Media | Lecture notes in computer science
Beibei Wu, Ming Xu, Haiping Zhang, Jian Xu, Yizhi Ren, Ning Zheng,
... attention. In this paper, a recovery method for SQLite database history records (I.e. updated and deleted ... in NAND flash memory required by YAFFS2, the SQLite history recorders can be recovered and ordered into ...
Tópico(s): Advanced Malware Detection Techniques
2013 - Springer Science+Business Media | Lecture notes in computer science
K. Yuvaraj, Oorappan G Murugan, K K Megavarthini, M C Pravin, R Adharsh, M Ashwath Kumaran,
... develop an inventory management application using Tkinter and SQLite platform that creates a way towards progressively from ... The system utilizes the integration of Tkinter and SQLite for the effective Graphical User Interface interfaced with ...
Tópico(s): Vehicle License Plate Recognition
2020 - IOP Publishing | IOP Conference Series Materials Science and Engineering
Eman Daraghmi, Zaer Qaroush, Monia Hamdi, Omar Cheikhrouhou,
... an automated tool called Forensic Operations for Recognizing SQLite Content (FORC), specifically designed for Android, to extract Simple Query Language Table Database Lightweight (SQLite) evidence. SQLite is a library that serves as a container ... contained, and transactional SQL database engine. While some SQLite files possess extensions such as .db, .db3, .sqlite, and .sqlit3, others have none. The lack of ... both the file extensions and headers of the SQLite data to recognize and identify SQLite data generated ...
Tópico(s): User Authentication and Security Systems
2023 - Multidisciplinary Digital Publishing Institute | Applied Sciences
... This algorithm was tested using data from the SQLite/SpatiaLite and PostgreSQL/PostGIS database. In processing spatial ... in performance compared to single-thread processing on SQLite/SpatiaLite database and 5.1X maximum speed-up ...
Tópico(s): Data Mining Algorithms and Applications
2021 - Elsevier BV | Computers & Geosciences
Hasan Fayyad-Kazan, Sondos Kassem-Moussa, Hussin Hejase, Ale J. Hejase,
... of the artefacts left by the encrypted WhatsApp SQLite databases on unrooted Android devices is presented. In ... Since the data is stored in an encrypted SQLite database, its decryption is first discussed. Then, the ...
Tópico(s): Digital Media Forensic Detection
2022 - | HighTech and Innovation Journal
Di Lu, Minqiang Shi, Xindi Ma, Ximeng Liu, Rui Guo, Tianfang Zheng, Yulong Shen, Xuewen Dong, Jianfeng Ma,
... the most popular relational databases for embedded devices, SQLite is lightweight to be embedded into applications without ... scheme to ensure the confidentiality and integrity of SQLite and similar databases. With Smaug, all the critical ...
Tópico(s): Distributed systems and fault tolerance
2022 - IEEE Computer Society | IEEE Transactions on Dependable and Secure Computing
Hamdan Alabsi, Ramesh K. Karne, Alex Wijesinha, Rasha Almajed, Bharat S. Rawal, Faris Almansour,
We describe a SQLite-based mail server that runs on a bare PC with no operating system. The mail server application is integrated with a server-based adaptation of the popular SQLite client database engine. The SQLite database is used for storing mail messages, and ... system. The unique features of the bare PC SQLite-based email server include (1) no OS vulnerabilities; ( ...
Tópico(s): Advanced Malware Detection Techniques
2019 - Springer Science+Business Media | Communications in computer and information science
Iman Musleh, Samer M. Zain, Mamoun Nawahdah, Norsaremah Salleh,
... database components, and presents a technique for creating SQLite database and APIs. The technique is based on a tool named Android SQLite Creator (ASQLC) that can automatically generate Android SQLite database as well as the API classes that ...
Tópico(s): Advanced Malware Detection Techniques
2018 - | Frontiers in artificial intelligence and applications
Yuelin J. Zhu, Sean Davis, Robert M. Stephens, Paul S. Meltzer, Yidong Chen,
... addition, a Bioconductor package, GEOmetadb that utilizes a SQLite export of the entire GEOmetadb database is also ... from within R. Availability: The web interface and SQLite databases available at http://gbnci.abcc.ncifcrf.gov/ ...
Tópico(s): Bioinformatics and Genomic Networks
2008 - Oxford University Press | Bioinformatics
Christopher M. Yates, Ioannis Filippis, Lawrence A. Kelley, Michael J.E. Sternberg,
... Web site has been implemented in Perl and SQLite and is compatible with modern browsers. An SQLite database of possible missense variants in the human ...
Tópico(s): Genomics and Phylogenetic Studies
2014 - Elsevier BV | Journal of Molecular Biology
Yuelin J. Zhu, Robert M. Stephens, Paul S. Meltzer, Sean Davis,
... have parsed all the SRA metadata into a SQLite database that is routinely updated and can be ... The SRAdb R/Bioconductor package then utilizes this SQLite database for querying and accessing metadata. Full text ...
Tópico(s): Gene expression and cancer classification
2013 - BioMed Central | BMC Bioinformatics
Sooman Jeong, Kisung Lee, Jungwoo Hwang, Seongjin Lee, Youjip Won,
... app that generates a filesystem as well as SQLite database operations. Mobibench can also vary the number ... the performances of twelve Android smartphones and the SQLite performances on five different filesystems. AndroStep makes otherwise ...
Tópico(s): Caching and Content Delivery
2013 - Multidisciplinary Digital Publishing Institute | Future Internet
Chun Shen, Zhi Qiu, Huichao Song, Jonah E. Bernhard, Steffen A. Bass, Ulrich Heinz,
... tar.gz Programming language: Fortran, C++, python, bash, SQLite. Computer: Laptop, desktop, cluster. Operating system: Tested on ... Carlo simulations. The final results are stored into SQLite database, which supports standard querying for massive data ...
Tópico(s): Quantum Chromodynamics and Particle Interactions
2015 - Elsevier BV | Computer Physics Communications
R Annamalai, Jujjuvarapu Srikanth, M. Prakash,
... project in android application.With the help of Sqlite Database we store and retrieve the data in the Mobile Application.Sqlite Database is a relational database management system; it ...
Tópico(s): Bluetooth and Wireless Communication Technologies
2015 - | International Journal of Computer Applications
Di Zhang, Linhai Zhao, Biao Li, Zongxiao He, Gao T. Wang, Dajiang J. Liu, Suzanne M. Leal,
... file or a file-based relational database like SQLite, which is not suitable for high input/output ... VAT both use the file-based relational database, SQLite, which can considerably reduce computational speed, because it ...
Tópico(s): Epigenetics and DNA Methylation
2017 - Elsevier BV | The American Journal of Human Genetics
Mustafa Safa Özdayi, Murat Kantarcıoǧlu, Bradley Malin,
... compared its loading and query-response performance with SQLite, a commonly used relational database, using the data ... time difference between blockchain based query-response and SQLite based query-response ranged from 0.2 seconds ...
Tópico(s): Privacy-Preserving Technologies in Data
2020 - BioMed Central | BMC Medical Genomics