Research And Implementation Of Information Manage System Based On Object Relational Mapping

Object Relation Mapping (ORM) is one of the key technologies for solving object to relation mapping issues in software development. In the paper the ORM technology is deeply studied with the consideration of requirement for the indwelling personnel management system of Public Security Bureau in Jinhua. Eventually the proposed SimpleORM is implemented along with the auxiliary development tool on Microsoft .Net platform. The component can achieve the target of relational database accessed by an object-oriented way, thereby, greatly increasing the development efficiency, maintainability and extensibility of application software.Firstly, the object model and relation model concept and its theory basis are studied. And the 'impedance detuning' problems between object model and relation model is analyzed. Finally, the feasibility project for realizing object-relational mapping technology is provided.Secondly, the in-depth research on ORM technology is conducted. The kernel technology, namely, the mapping between object models and relation models and it's reversion are mainly analyzed, including basic mapping, advanced mapping, and the mapping algorithm.Thirdly, the simplified mapping model algorithm called SimpleORM is proposed. In this algorism, XML is used as an object-relational mapping language. The algorithm includes general mapping layer, mapping layer, and practical realization of the case. An experiment is conducted to verify the correctness and efficiency of the algorithm.At last, simpleORM is designed and realized based on the .NET platform with the consideration of the requirement of the practical project of the personnel management system of the Public Security Bureau in Jinhua. It is successfully applied in the development of that system. After using SimpleORM and its corresponding auxiliary tools, the addition, deleting and revision operation on the database are avoided, and save 40% development time off. The system late maintenance is also facilitated. A strong component for further information system development is provided, which enhances the development team's work efficiency.The future work is mainly focused on the many-to-one and many-to-many mapping relationships. Trying to improve mapping algorithm and perfect performance, and also upgrade and strengthen the stability of the system and enhance accessorial function.