Research And Visualization Of SQLite Database

With the development of social informatization and technology,embedded devices need to process more and more data.At the same time,their data storage capacity is relatively small and their computing power is not strong enough.In order to meet the growing demand of the embedded operating system for the database management system and realize the convenient and unified management of the data in the device,the embedded database management system has become a new development direction of database technology.SQLite is a mainstream embedded database in the current market.It has the advantages of open source,independence and high reliability,and is widely used on mobile devices.Therefore,this paper chooses to analyze and study the SQLite database.This thesis first summarizes the embedded database management system and analyzes its research and application status.Then,we conducted an in-depth study on the embedded database SQLite,combined with the source code to analyze its storage layer and architecture sub-module.In-depth understanding of its underlying principles and working mechanisms,learning the use of its C API interface.Finally,the SQLite package library and visual management tool are developed and designed on this basis,which greatly simplifies the use of SQLite database.The main work of this thesis includes the following two aspects:1.Based on the C API learning and research of the SQLite database,a SQLite package library was designed and developed with C ++ 14,and the package library was unit tested using Catch2 to ensure the correctness of the package library interface function.The package library divides the SQLite C API into six modules: exception handling,database connection,execution operation,transaction processing,database backup,and user-defined function,aggregation and collation.It is encapsulated and defined in the same namespace.You only need to add the source code to the project to use the package library.Using this package library can eliminate the differences of SQLite interface,simplify the use of SQLite interface and improve the programming efficiency.2.Using Qt software and the SQLite package library to develop and design a SQLite visualization management tool,and at the same time,the strict black box test of the visualization tool is performed to ensure the reliability and stability of the tool.The visualization tool includes four major functional modules: database management,table management,SQL statement execution,and SQL script processing.The database management module is mainly responsible for managing the database,which is divided into three parts: creating a new database,opening the database,and removing the database;table management includes creating a table,deleting a table,and displaying the data in the table;the SQL statement execution module is responsible for executing the SQL statements in the script editing component and displaying the results of the execution;the processing of the SQL script has four types: new,open,close and save.Users can easily manipulate and manage the database by using the visualization tool,which can meet the daily operation requirements of the database.