Dissertation > Excellent graduate degree dissertation topics show

MySQL storage Security Research and Implementation

Author: LiYaWei
Tutor: HuHePing
School: Huazhong University of Science and Technology
Course: Computer technology
Keywords: Database Storage Engine Storage Security Line Encryption
CLC: TP311.13
Type: Master's thesis
Year: 2011
Downloads: 75
Quote: 1
Read: Download Dissertation

Abstract


As the knowledge economy era , people are increasingly dependent on information re . Database security is the core of information security , sensitive information in the database is encrypted with a theoretical value and practical significance. The most commonly used method is to encrypt the data in the DBMS outer , but this method exist in the security and performance of a number of shortcomings . Transparent encryption technology to store in the database layer of encryption and decryption process transparent to the user . The outer layer can effectively solve the DBMS to encrypt data deficiencies , it has a great research value. First introduced MySQL architecture , then InnoDB storage engine source for analysis. InnoDB storage engine for the core binary search algorithm , B -tree to find the analysis and modification: decryption function is called after the data is read , the decrypted data is compared with the query ; through binary search , B tree search to determine the data insertion position, the plaintext data encryption function calls stored encrypted ; delete and update operations , calling search algorithm to find the data , you need to decrypt the ciphertext , the plaintext fields and modify the transaction rollback pointer fields, data fields are marked for deletion or complete update after re-encrypted storage . Focuses on analysis of the storage engine page splitting mechanisms, data pages left split , intermediate data split with the right data page split . Splitting the data pages during implementation , depending on the type of splitting of part of the data into the new page , is called the improved insertion algorithm , this part of the data needed to do the cryptographic processing . The index for the realization of the principle storage engine to analyze , InnoDB storage engine called merge sort algorithm , you need to decrypt the data in the clustered index , construct a new record , the new record after sorting encrypted storage . Finally the system functional testing, structural test case , three analog data page split case , verify correct insertion into and queries.

Related Dissertations

  1. Design and Development of Application Programme for Fault Analyzer Based on Wince Platform,TP311.52
  2. Study on System of Electronic Documetnt Security Signature,TN918.2
  3. Research on Compression, Operation and Query Processing Methods of Massive Datasets,TP311.13
  4. Implementation of Data Compression, Operation and Query Processing System Based on BAP,TP311.13
  5. Design and Implementation of the weapons and equipment information management system,TP311.52
  6. Force Online Examination System Design and Implementation,TP311.52
  7. Xinjiang Oilfield Ground Construction Cost Indicators and Management Information System Study and Application,F284
  8. The Studying of University Students’ Community Management Based on GIS,G647
  9. A Study on Healthcare Product Marketing Based on Data Mining Technology,F426.72
  10. Research and Design of One Kind of Paper’s QCS That Based on Embedded System,TP368.1
  11. Development of the on-line Training and Examination System of Army,TP311.52
  12. Motor assist system for motorized units,TP311.52
  13. Online examination system design of military theory and,TP311.52
  14. Tibet border combat training information management system design and realization of research,TP311.52
  15. The Establishment of Chemical Toxicological Database for Wool Industry,TS131
  16. Structure of Wenzhou Agricultural Resource Management Information System Based on GIS,S126
  17. The Building and Application of Jinqu Basin Soil Series Database of Zhejiang Province,S159.2
  18. Dogs training management system based on WEB,TP311.52
  19. Website design and construction of grass-roots units,TP311.52
  20. Establishment of Transgenic Soybean, Maize and Wheat Informationg Platform and Effect of Transgenic Soybean on Soil Microorganisms,S565.1
  21. Research of Contaminated Site Investigation and Assessment Information System for Soil,X825

CLC: > Industrial Technology > Automation technology,computer technology > Computing technology,computer technology > Computer software > Program design,software engineering > Programming > Database theory and systems
© 2012 www.DissertationTopic.Net  Mobile