本文選題：嵌入式數(shù)據(jù)庫　切入點(diǎn)：恢復(fù)　出處：《華中科技大學(xué)》2012年碩士論文　論文類型：學(xué)位論文

【摘要】：隨著嵌入式技術(shù)的不斷發(fā)展，嵌入式數(shù)據(jù)庫應(yīng)用得越來越廣泛。嵌入式環(huán)境有許多特點(diǎn)和限制，如移動(dòng)性、網(wǎng)絡(luò)不穩(wěn)定性以及電源能力等，對(duì)嵌入式數(shù)據(jù)庫可靠性和性能提出了更高的要求和挑戰(zhàn)，一個(gè)強(qiáng)健的恢復(fù)子系統(tǒng)是嵌入式數(shù)據(jù)庫必不可少的組成部分。通過系統(tǒng)深入地研究數(shù)據(jù)庫恢復(fù)技術(shù)，對(duì)達(dá)夢(mèng)(DM)嵌入式數(shù)據(jù)庫恢復(fù)子系統(tǒng)進(jìn)行了改進(jìn)，以提升系統(tǒng)可靠性和可用性。 為適應(yīng)嵌入式環(huán)境，使系統(tǒng)設(shè)計(jì)遵循簡約性和微內(nèi)核特性，對(duì)數(shù)據(jù)庫回滾段進(jìn)行了設(shè)計(jì)與改進(jìn)，將回滾段集成到數(shù)據(jù)文件中，進(jìn)行系統(tǒng)恢復(fù)時(shí)僅搜索預(yù)留回滾段，節(jié)省了恢復(fù)時(shí)間；同時(shí)將日志文件設(shè)計(jì)成單日志形式，并采用事務(wù)一致性檢查點(diǎn)縮短恢復(fù)時(shí)需要掃描的日志量。 在系統(tǒng)故障恢復(fù)時(shí)，為避免對(duì)所有Redo日志進(jìn)行重做，設(shè)計(jì)并實(shí)現(xiàn)了選擇性重做方案。對(duì)于那些已經(jīng)寫入到數(shù)據(jù)庫文件中的記錄，根據(jù)頁面的日志序列號(hào)(LogSequence Number, LSN)和日志記錄的LSN進(jìn)行判斷后再?zèng)Q定是否進(jìn)行重做，而不是盲目地重做，分析并給出了使用該方法的前提條件。該方法節(jié)省了系統(tǒng)緩沖區(qū)資源，減少磁盤I/O，體現(xiàn)了嵌入式數(shù)據(jù)庫微內(nèi)核的要求。 為充分利用操作系統(tǒng)多道程序設(shè)計(jì)思想以及達(dá)夢(mèng)嵌入式數(shù)據(jù)庫特殊的事務(wù)模型，系統(tǒng)恢復(fù)時(shí)采用多線程方式重做日志加速恢復(fù)。使用一個(gè)日志分發(fā)線程、多個(gè)重做線程的模型，線程間同步協(xié)作完成重現(xiàn)歷史操作，達(dá)到快速重建系統(tǒng)崩潰時(shí)系統(tǒng)狀態(tài)的目的。 經(jīng)過實(shí)驗(yàn)測(cè)試表明，改進(jìn)后的恢復(fù)子系統(tǒng)能正確處理系統(tǒng)遇到的事務(wù)故障、系統(tǒng)故障和介質(zhì)故障，且能縮短系統(tǒng)故障恢復(fù)使用的時(shí)間。
[Abstract]:With the continuous development of embedded technology, embedded database is more and more widely used. Embedded environment has many characteristics and limitations, such as mobility, network instability and power supply ability, etc. This paper puts forward higher requirements and challenges to the reliability and performance of embedded database. A robust recovery subsystem is an essential part of embedded database. In order to improve the reliability and availability of the Darmenton (DMN) embedded database recovery subsystem, the system is improved. In order to adapt to the embedded environment and make the system design follow the characteristics of minimization and microkernel, the database rollback segment is designed and improved. The rollback segment is integrated into the data file, and only the reserved rollback segment is searched for system recovery. The recovery time is saved and the log file is designed as a single log form and the amount of logs that need to be scanned is shortened by using transaction consistency checkpoint. In order to avoid redoing all Redo logs during system recovery, a selective redo scheme is designed and implemented. According to the log sequence number of the page, LogSequence number (LSNs) and the LSN of the log record, we can decide whether to redo it or not instead of blindly redoing it. The precondition of using this method is analyzed and given. This method saves the system buffer resource. Reducing disk I / O reflects the requirement of embedded database microkernel. In order to make full use of the multiprogramming idea of operating system and the special transaction model of Dameng embedded database, the multithread redo log is used to speed up the recovery of the system, and a log distributing thread is used. In the model of multiple redo threads, the synchronization and cooperation between threads complete the reproducing history operation, so as to quickly reconstruct the system state when the system crashes. The experimental results show that the improved recovery subsystem can correctly deal with the transaction faults, system failures and medium failures encountered by the system, and can shorten the time of system fault recovery.
【學(xué)位授予單位】：華中科技大學(xué)
【學(xué)位級(jí)別】：碩士
【學(xué)位授予年份】：2012
【分類號(hào)】：TP368.1;TP311.52

【參考文獻(xiàn)】

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

1 朱智林,左天軍,牛淑齡;基于日志的臟數(shù)據(jù)檢測(cè)與恢復(fù)[J];電子科技;2004年05期

2 郭鮮鳳,張和義;SQL Server分布式數(shù)據(jù)庫的并發(fā)控制和故障恢復(fù)[J];科技情報(bào)開發(fā)與經(jīng)濟(jì);2002年01期

3 陳錦輝;方關(guān)飛;黃根勛;;MS SQL Server身份認(rèn)證機(jī)制的安全分析[J];信息工程大學(xué)學(xué)報(bào);2008年02期

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

1 劉琳;嵌入式數(shù)據(jù)庫SQLite的安全性研究[D];昆明理工大學(xué);2010年

2 張永;嵌入式數(shù)據(jù)庫系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)[D];清華大學(xué);2004年

3 盛業(yè)興;嵌入式數(shù)據(jù)庫事務(wù)處理和日志恢復(fù)技術(shù)研究[D];合肥工業(yè)大學(xué);2007年

4 王少華;達(dá)夢(mèng)數(shù)據(jù)庫系統(tǒng)備份與恢復(fù)機(jī)制研究[D];華中科技大學(xué);2007年

，

本文編號(hào)：1635876