全自動(dòng)異地?cái)?shù)據(jù)庫(kù)備份和恢復(fù)系統(tǒng)

電氣工程論文編號(hào):DQ238   論文字?jǐn)?shù):15395,頁(yè)數(shù):36

摘要：隨著數(shù)據(jù)庫(kù)技術(shù)的不斷發(fā)展，數(shù)據(jù)庫(kù)的規(guī)模越來越大，其功能也越來越強(qiáng)大。互聯(lián)網(wǎng)技術(shù)的飛速發(fā)展，使企業(yè)的信息數(shù)據(jù)量也急劇增長(zhǎng)。因此提高數(shù)據(jù)的安全性和數(shù)據(jù)恢復(fù)能力一直是關(guān)注的焦點(diǎn)。實(shí)現(xiàn)一套安全的，方便的，自動(dòng)的，經(jīng)濟(jì)的備份恢復(fù)系統(tǒng)非常有實(shí)際價(jià)值。
 數(shù)據(jù)庫(kù)系統(tǒng)作為信息系統(tǒng)中的基礎(chǔ)軟件，其安全性問題十分重要。目前國(guó)內(nèi)的數(shù)據(jù)庫(kù)系統(tǒng)基本采用國(guó)外產(chǎn)品，必須確保對(duì)其進(jìn)行安全利用和有效監(jiān)控。本文在對(duì)數(shù)據(jù)庫(kù)系統(tǒng)安全相關(guān)理論和技術(shù)進(jìn)行探討的基礎(chǔ)上，基于安全性增強(qiáng)的思想，對(duì)SQL  Server 2000數(shù)據(jù)庫(kù)的應(yīng)用系統(tǒng)的安全增強(qiáng)進(jìn)行了研究和探討。
 本論文主要研究了目前信息安全的研究與發(fā)展以及數(shù)據(jù)庫(kù)安全的現(xiàn)狀；多角度地分析了數(shù)據(jù)庫(kù)系統(tǒng)的安全性威脅和數(shù)據(jù)庫(kù)安全性的基本要求。以SQL Server數(shù)據(jù)庫(kù)為實(shí)例，對(duì)SQL Server數(shù)據(jù)庫(kù)基于角色的權(quán)限管理，訪問控制，審計(jì)監(jiān)控、增量備份和數(shù)據(jù)恢復(fù)等關(guān)鍵性技術(shù)進(jìn)行了深入研究。 主要基于SQL Server數(shù)據(jù)庫(kù)系統(tǒng)，對(duì)數(shù)據(jù)庫(kù)存儲(chǔ)及傳輸加密、用戶口令認(rèn)證，安全審計(jì)機(jī)制等給出了技術(shù)實(shí)現(xiàn)，并通過存儲(chǔ)過程、函數(shù)和程序包的方法對(duì)現(xiàn)有的數(shù)據(jù)庫(kù)系統(tǒng)安全功能加以改進(jìn)。在Visual C++和SQL Server 2000數(shù)據(jù)庫(kù)的開發(fā)環(huán)境下，實(shí)現(xiàn)數(shù)據(jù)庫(kù)的異地自動(dòng)備份和恢復(fù)功能。
關(guān)鍵詞：數(shù)據(jù)庫(kù)、 VC、 安全性、備份、 恢復(fù)

Abstract:Along with the database technology development，the scale of Database become larger and larger. Their functions are increasingly powerful. Internet technology is developing at full speed，Enterprise information and data was also rapid growth. Therefore improve data security and data recovery capability has been the focus of attention. Achieving a safe, convenient, automatic, economic system of backup and recovery demonstrates very practical value.
 As foundation software of information system, it is significant for its security. Now most database systems use foreign product in our country. It should be solved how to ensure secure use and audit effectively. Based on a plenty of papers, technology reports and dissertations, this dissertations make some research work on the field of secure theory and technology and study on secure enhancement based on SQL Server database system.
 The dissertation mainly studies in the current information security and the database security status.  The characteristics and fundamental requirement of database security issues are proposed. For SQL Server database, the aspects of privilege admin based on roles, the granularity access control, audit and backup and restore technology are discussed. Based on SQL Server database, database storage and transmit authentication, users password authentication, secure audit are realized. Database security functions improve by procedure, function and program packages. In Visual C + + and SQL server 2000 database development environment, accomplish database automatic backup and recovery functions.
Keywords: Database、VC、Security、Copy、Restoration