發(fā)布時(shí)間：2018-03-30 00:19

  本文選題：嵌入式數(shù)據(jù)庫(kù)系統(tǒng)　切入點(diǎn)：SQLite　出處：《昆明理工大學(xué)》2012年碩士論文

【摘要】：隨著嵌入式技術(shù)和信息技術(shù)的迅速發(fā)展,對(duì)數(shù)據(jù)處理的要求越來(lái)越高,嵌入式設(shè)備上的數(shù)據(jù)管理成為一個(gè)非常重要的問(wèn)題。僅僅使用文件系統(tǒng)已經(jīng)不能滿足數(shù)據(jù)處理的需要,研究人員已經(jīng)開發(fā)出適合在嵌入式設(shè)備上使用的數(shù)據(jù)庫(kù)管理系統(tǒng)用來(lái)保存數(shù)據(jù)并提供高效的數(shù)據(jù)管理功能。通常嵌入式數(shù)據(jù)庫(kù)都具有很小的規(guī)模,高效率,高實(shí)時(shí)性等共性,而且多數(shù)是可以在內(nèi)存中運(yùn)行的,這樣可避免訪問(wèn)外部存儲(chǔ)設(shè)備所帶來(lái)的負(fù)面影響。 在目前比較流行的開源嵌入式數(shù)據(jù)庫(kù)管理系統(tǒng)中,SQLite憑借自己可移植性好,使用簡(jiǎn)單,小巧,高效而且可靠、占用資源非常的低以及完全免費(fèi)等特點(diǎn),在嵌入式軟件產(chǎn)品開發(fā)中占有重要的地位。和大多數(shù)嵌入式數(shù)據(jù)庫(kù)系統(tǒng)一樣,SQLite不能獨(dú)立運(yùn)行,而是嵌入到調(diào)用它的應(yīng)用程序——共享相同的進(jìn)程空間,成為應(yīng)用程序的一部分。 基于SQLite的使用特點(diǎn),在SQLite項(xiàng)目開發(fā)中,大部分的軟件開發(fā)人員對(duì)于SQLite的內(nèi)部工作原理并不清楚,導(dǎo)致SQLite數(shù)據(jù)庫(kù)開發(fā)時(shí)間長(zhǎng)且數(shù)據(jù)庫(kù)設(shè)計(jì)上存在缺陷。同時(shí)對(duì)比當(dāng)今比較流行的嵌入式數(shù)據(jù)庫(kù)發(fā)現(xiàn),它們都有或多或少的調(diào)試功能和跟蹤功能來(lái)輔助數(shù)據(jù)庫(kù)開發(fā)人員的完成數(shù)據(jù)庫(kù)的開發(fā)工作,而SQLite設(shè)計(jì)者并沒(méi)有為其設(shè)計(jì)相應(yīng)的數(shù)據(jù)庫(kù)調(diào)試和跟蹤功能。軟件調(diào)試是軟件開發(fā)和維護(hù)中必不可少的重要一環(huán),幾乎存在于軟件開發(fā)周期的每個(gè)階段,都有很多這樣那樣的問(wèn)題需要進(jìn)行調(diào)試。調(diào)試手段的好壞直接影響系統(tǒng)開發(fā)的效率與軟件的質(zhì)量。當(dāng)前國(guó)內(nèi)對(duì)嵌入式數(shù)據(jù)庫(kù)系統(tǒng)的調(diào)試技術(shù)方面的研究很少,可以說(shuō)是幾乎沒(méi)有。一般嵌入式數(shù)據(jù)庫(kù)調(diào)試器工具都是使用國(guó)外的產(chǎn)品,因此深入研究調(diào)試技術(shù)并開發(fā)一款可調(diào)試SQLite數(shù)據(jù)庫(kù)的調(diào)試器具有重要意義。 為此,在分析了各種調(diào)試技術(shù)優(yōu)缺點(diǎn)的基礎(chǔ)上,以及對(duì)當(dāng)前比較流行的開源的嵌入式數(shù)據(jù)庫(kù)管理系統(tǒng)提供的調(diào)試功能和跟蹤功能設(shè)計(jì)與實(shí)現(xiàn)技術(shù)進(jìn)行了一番仔細(xì)的研究之后發(fā)現(xiàn)：現(xiàn)今已有的且比較流行的外部調(diào)試器設(shè)計(jì)模型并不適合SQLite調(diào)試器設(shè)計(jì),但在SQLite源碼基礎(chǔ)上,在其內(nèi)部設(shè)計(jì)一款具有調(diào)試功能的調(diào)試器和跟蹤功能的跟蹤庫(kù)的設(shè)計(jì)方案則是可行的。 本論文設(shè)計(jì)并實(shí)現(xiàn)的SQLite調(diào)試器和跟蹤庫(kù)完全繼承了SQLite自身設(shè)計(jì)開發(fā)時(shí)所采用的語(yǔ)句風(fēng)格,即標(biāo)準(zhǔn)ANSI C。這樣設(shè)計(jì)的優(yōu)點(diǎn)在于SQLite調(diào)試器和跟蹤庫(kù)能夠與SQLite自身實(shí)現(xiàn)很好的兼容,保證當(dāng)SQLite調(diào)試器和跟蹤庫(kù)運(yùn)行時(shí),不會(huì)影響SQLite應(yīng)有的執(zhí)行效果和產(chǎn)生異常結(jié)果。此外,本論文所實(shí)現(xiàn)的SQLite調(diào)試器和跟蹤庫(kù)的調(diào)用方法也非常簡(jiǎn)便,軟件開發(fā)人員僅需在調(diào)試程序中插入調(diào)試SQL語(yǔ)句斷點(diǎn)或打開跟蹤宏命令就能夠?qū)崿F(xiàn)對(duì)SQLite程序的調(diào)試功能或跟蹤功能。此二者的實(shí)現(xiàn)為SQLite數(shù)據(jù)庫(kù)開發(fā)人員提供了簡(jiǎn)潔且高效的數(shù)據(jù)庫(kù)調(diào)試功能和程序執(zhí)行跟蹤功能,減少了SQLite數(shù)據(jù)庫(kù)設(shè)計(jì)中錯(cuò)誤,從而大大縮短了SQLite數(shù)據(jù)庫(kù)開發(fā)的周期。
[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.

【學(xué)位授予單位】：昆明理工大學(xué)
【學(xué)位級(jí)別】：碩士
【學(xué)位授予年份】：2012
【分類號(hào)】：TP368.1;TP311.13

【參考文獻(xiàn)】

相關(guān)期刊論文 前6條

1 姚敏鋒;張晶;;嵌入式移動(dòng)數(shù)據(jù)庫(kù)的應(yīng)用研究[J];電腦與信息技術(shù);2007年05期

2 蘭利東 ,喬永強(qiáng);GDB遠(yuǎn)程調(diào)試環(huán)境的設(shè)計(jì)與實(shí)現(xiàn)[J];單片機(jī)與嵌入式系統(tǒng)應(yīng)用;2005年10期

3 李國(guó)徽,楊進(jìn)才;內(nèi)存數(shù)據(jù)庫(kù)查詢優(yōu)化[J];華中科技大學(xué)學(xué)報(bào)(自然科學(xué)版);2003年04期

4 熊光澤，汪燕勤，，羅蕾;32位微處理器嵌入式實(shí)時(shí)軟件開發(fā)與調(diào)試技術(shù)[J];計(jì)算機(jī)應(yīng)用;1995年04期

5 張聰品,趙琛,糜宏斌;異常處理機(jī)制研究[J];計(jì)算機(jī)應(yīng)用研究;2005年04期

6 王沛漢,國(guó)強(qiáng),周毅;SQLite在電話網(wǎng)管系統(tǒng)中的應(yīng)用[J];計(jì)算機(jī)工程與設(shè)計(jì);2005年11期

相關(guān)碩士學(xué)位論文 前10條

1 何劍;基于嵌入式數(shù)據(jù)庫(kù)技術(shù)的智能化教室門牌的設(shè)計(jì)與實(shí)現(xiàn)[D];蘇州大學(xué);2010年

2 黃勇智;面向ADSP的嵌入式調(diào)試器的研究與實(shí)現(xiàn)[D];西安電子科技大學(xué);2011年

3 汪靜;基于文件系統(tǒng)的嵌入式數(shù)據(jù)庫(kù)的設(shè)計(jì)和實(shí)現(xiàn)——EDB的設(shè)計(jì)和實(shí)現(xiàn)[D];電子科技大學(xué);2002年

4 汪天揚(yáng);嵌入式數(shù)據(jù)庫(kù)管理系統(tǒng)研究與實(shí)現(xiàn)[D];電子科技大學(xué);2005年

5 劉彩蘋;面向嵌入式數(shù)據(jù)庫(kù)索引機(jī)制研究[D];湖南大學(xué);2004年

6 張翼;一種基于內(nèi)存的嵌入式關(guān)系數(shù)據(jù)庫(kù)管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)[D];西安電子科技大學(xué);2006年

7 李靜;嵌入式數(shù)據(jù)庫(kù)在TPMS中的應(yīng)用研究[D];合肥工業(yè)大學(xué);2006年

8 王欽騫;嵌入式系統(tǒng)調(diào)試器的研究與實(shí)現(xiàn)[D];電子科技大學(xué);2006年

9 楊志勇;嵌入式數(shù)據(jù)庫(kù)系統(tǒng)的研究與實(shí)現(xiàn)[D];武漢理工大學(xué);2007年

10 劉飛;嵌入式數(shù)據(jù)庫(kù)技術(shù)的研究與實(shí)現(xiàn)[D];西安科技大學(xué);2007年

本文編號(hào)：1683523