| With the development of information technology, database, database management system is playing an increasingly important role in the field of software. Oracle database with excellent performance becomes one of the most popular database management systems today. Oracle database provides different character sets which have the characteristics of localization, with the development of software and business, to some extent, these block the development of globalization.Oracle Database Migration Assistant for Unicode (DMU) accomplishes the purpose that converts oracle database character set to Unicode, which is designed with end-to-end method and depends on globalization information background and focuses on conversion to ALL32UTF8character set. Based on layer and module design concept, it completes the design of initialize module, scan data module, cleansing module, conversion module and secure module. According to the characteristic of Oracle database, multi-thread technology and data processing method based on memory is used for reducing database shutdown time, which is what the customers really care about.This paper follows the principle about the database character set conversion and describes the technology about the conversion Oracle database character set, then summarizes the developed product; compared the data organization based on the file system and memory, through experiment of simulation data, the performance whose is based on the memory is better. The method which is based on the memory avoids data store in harddisk through writing data to the buffer then interact with memory directly, which reduces the time of disk reading and writing operations. Literally, the performance is optimized any further. Then, according to the demand for system analysis, system design, the design concept of layer and module, completes the system design and implementation. The author is mainly responsible for analysis, design, implementation of data cleansing, convert module and secure module. |
PDF Full Text Request