The Design And Implementation Of Data Management System Based On B/S Structure

With vigorously promoting information technology in our country and information from each industry, a lot of valuable electronic data accumulated in the enterprise, the low efficiency of manual management is not realistic. Meanwhile, the enterprise merger and time of the enterprise environment change will affect the quality of the data and contribute to widening the amount of data. It becomes inevitable to establish a highly efficient, high data quality and real-time interactive intelligent data management system.SmartLocalizer(intelligent localization) of Trend Micro is a huge Web-based system that provides many capabilities to the localization department such as real-time project dictionary translation, project schedule,time, project data management. This thesis is to realize a plug-in of the system-data management system. Enterprise users can upload project data file which has been translated by a single file format or zip file format. The data management system parses JS, XML, HTML files uploaded, and adds bulk data into the database. Enterprise users can use data cleaning module to automatically detect and clean similar record, and view project data via e-mail or Web page tables and diagrams for comparison.In windows system, this thesis uses B/S architecture, the Django framework, Python language and MVC development mode to realize the data management system. Experiments and system testing results show that this system has improved the efficiency of the user’s project management, ensured the validity and consistency of the data, and reflected the good real-time interactive of Website. The main research content of this thesis is as follows:1. To solve the historical problem of parsing files in different format, this paper uses DOM technology to parse the file uploaded by zip file format or single file and entry in the database, so as to improve the efficiency of data entrance.2. Low quality and inconsistency of data can cause deviation of the data management. This thesis uses the data cleaning technology and draws lessons from Smith-Waterman (S-W) algorithm and sorting, merging algorithm to design and realize the detection and removal of dirty data, then ensures the correctness and consistency of data.3. Straightforward data presentation (for example, in the form of chart or diagram), and regular push of data processing result can facilitate enterprise users to manage projects more efficiently. FusionCharts technology is applied in this thesis to realize the graphical display of data, and the selenium technology is used in this thesis to realize the function of pushing by email regularly, making it easier for users to manage data more efficiently.