Design And Implementation Of Community Management Information System Based On ORM Technology

OOP(Object Oriented Programming) is a main technology of programming, and relational database is the most important memory mechanism. Impedance Mismatch between object model of OOP and relational model of relational database, however, has seriously affected the efficiency of application program development. ORM(Object Relational Mapping) is an efficient technology to deal with this problem. Therefore, it is a new direction to use ORM technology in the development of MIS (Information Management System).Aiming at the design and realization of CMIS(Community Information Management System), author has made the analysis and research on implementation principle and development technology of ORM, and has given some discussions concerning problems and solutions of ORM which may exist in the application of CIMS. Meanwhile, the author gives detailed description of the design and implementation process. Finally tests of security and performance of system have been done.The work mainly includes the following:(1) Detailed analysis of implementation principal and development technology on ORM technology has been made. By Comparing some ORM frameworks based on NET platform, OpenAccess ORM as CMIS development platform has been adopted.(2) Key technology of OpenAccess ORM has been analyzed, focusing on low system executive efficiency during CMIS development when it used with RadControls for ASP.NET AJAX together, then the data cache mechanism is introduced, which improves the system efficiency. According to mapping errors occurred during reverse mapping, a method to modifying mapping files which could avoid errors is provided, and a new idea of mapping implementation is put forward. With regard to defect that ORM framework could not map database table and field to mapping file in mapping process, a theoretical solution is put forward.(3) A CMIS was designed and realized based on ORM technology. The author made detailed descriptions of main development process, such as system requirement analysis, module designing and Object Relational Mapping, and finally presented results.(4) Having done thorough analysis of system security, the author designed and developed a desktop application software based on ORM technology----Licenser, which was applied to CIMS, proving system security. After analyzing security problems involving authority management and other security factors, the author provided corresponding measures. According to advanced method adopted in system development, the author made performance tests by using LoadRunner for system both before and after improvement. The test results showed feasibility and superiority of improvement.According to application of ORM technology adopted in CIMS, the author proved that ORM technology could avoid "Impedance Mismatch" and has advantages of high efficiency and easy maintenance. In addiction, the implementation of CIMS overcame traditional management pattern defects and improved efficiency.