嵌入式数据库SQLite调试器的研究与实现

发布时间：2018-03-30 00:19

本文选题：嵌入式数据库系统　切入点：SQLite　出处：《昆明理工大学》2012年硕士论文

【摘要】：随着嵌入式技术和信息技术的迅速发展,对数据处理的要求越来越高,嵌入式设备上的数据管理成为一个非常重要的问题。仅仅使用文件系统已经不能满足数据处理的需要,研究人员已经开发出适合在嵌入式设备上使用的数据库管理系统用来保存数据并提供高效的数据管理功能。通常嵌入式数据库都具有很小的规模,高效率,高实时性等共性,而且多数是可以在内存中运行的,这样可避免访问外部存储设备所带来的负面影响。在目前比较流行的开源嵌入式数据库管理系统中,SQLite凭借自己可移植性好,使用简单,小巧,高效而且可靠、占用资源非常的低以及完全免费等特点,在嵌入式软件产品开发中占有重要的地位。和大多数嵌入式数据库系统一样,SQLite不能独立运行,而是嵌入到调用它的应用程序——共享相同的进程空间,成为应用程序的一部分。基于SQLite的使用特点,在SQLite项目开发中,大部分的软件开发人员对于SQLite的内部工作原理并不清楚,导致SQLite数据库开发时间长且数据库设计上存在缺陷。同时对比当今比较流行的嵌入式数据库发现,它们都有或多或少的调试功能和跟踪功能来辅助数据库开发人员的完成数据库的开发工作,而SQLite设计者并没有为其设计相应的数据库调试和跟踪功能。软件调试是软件开发和维护中必不可少的重要一环,几乎存在于软件开发周期的每个阶段,都有很多这样那样的问题需要进行调试。调试手段的好坏直接影响系统开发的效率与软件的质量。当前国内对嵌入式数据库系统的调试技术方面的研究很少,可以说是几乎没有。一般嵌入式数据库调试器工具都是使用国外的产品,因此深入研究调试技术并开发一款可调试SQLite数据库的调试器具有重要意义。为此,在分析了各种调试技术优缺点的基础上,以及对当前比较流行的开源的嵌入式数据库管理系统提供的调试功能和跟踪功能设计与实现技术进行了一番仔细的研究之后发现：现今已有的且比较流行的外部调试器设计模型并不适合SQLite调试器设计,但在SQLite源码基础上,在其内部设计一款具有调试功能的调试器和跟踪功能的跟踪库的设计方案则是可行的。本论文设计并实现的SQLite调试器和跟踪库完全继承了SQLite自身设计开发时所采用的语句风格,即标准ANSI C。这样设计的优点在于SQLite调试器和跟踪库能够与SQLite自身实现很好的兼容,保证当SQLite调试器和跟踪库运行时,不会影响SQLite应有的执行效果和产生异常结果。此外,本论文所实现的SQLite调试器和跟踪库的调用方法也非常简便,软件开发人员仅需在调试程序中插入调试SQL语句断点或打开跟踪宏命令就能够实现对SQLite程序的调试功能或跟踪功能。此二者的实现为SQLite数据库开发人员提供了简洁且高效的数据库调试功能和程序执行跟踪功能,减少了SQLite数据库设计中错误,从而大大缩短了SQLite数据库开发的周期。
[Abstract]:With the rapid development of embedded technology and information technology, the increasingly high demand for data processing, data management of embedded devices has become a very important problem. Only the use of the file system has been unable to meet the needs of data processing, researchers have developed a database management system suitable for use in embedded devices to store data and provide efficient data management. The embedded database is usually very small size, high efficiency, high real-time character, and most can be run in memory, it can avoid the negative impact of access to external storage devices.
In the embedded database management system open source currently popular in SQLite, by virtue of their good portability, easy to use, small, efficient and reliable, the characteristics of resource is very low and completely free, plays an important role in the development of embedded software products. Like most of the embedded database system, SQLite can run independently, but embedded into the application to call it -- share the same process space, become part of the application.
Using the characteristics of SQLite based on SQLite project development, most of the software developers for the internal working principle of SQLite is not clear, leading to the existence of SQLite database development for a long time and database design flaws. The embedded database and the comparison of current popular, they have more or less debugging and trace function to the secondary database development the completion of the database development, and SQLite designers do not design the corresponding database debugging and tracing function for its software debugging and maintenance of software development is an indispensable important link, almost every stage in the software development cycle, there are so many problems need to debug the debugging method. Directly affects the efficiency and quality of software development. The current of the embedded database system debugging technology There are few researches in this field. Almost all of them are useless. The tools of general embedded database debuggers are all using foreign products. Therefore, in-depth research of debugging technology and developing a debugger for debugging SQLite database is of great significance.
Therefore, based on analyzing the advantages and disadvantages of various debugging technology, after the discovery and implementation of debugging and trace function design and comparison on the current popular open source embedded database management system carried out a careful study: today there has been and is not suitable for SQLite debugger design than external debugger design model is popular but, in the SQLite source based on the design of a debugger with debugging and tracking functions within the tracking library it is feasible.
This paper presents the design and implementation of SQLite debugger and tracking library SQLite completely inherited by its design and development statement style, the advantages is that in the standard ANSI C. SQLite debugger and tracking and SQLite library to achieve a good compatibility, that when the SQLite debugger and tracking library operation, does not affect the SQLite the implementation effect and the occurrence of abnormal results. In addition, the proposed method calls the SQLite debugger and tracking library is also very simple, software developers need only in the debugger to insert debugging breakpoints or open the SQL statement to achieve tracking macro command of SQLite program debugging or tracking. This provides two a simple and efficient database debugging and program execution tracking function for the SQLite database developers, to reduce the error from the SQLite database design. It greatly shortens the cycle of SQLite database development.

【学位授予单位】：昆明理工大学
【学位级别】：硕士
【学位授予年份】：2012
【分类号】：TP368.1;TP311.13

【参考文献】