Research And Implementation Of Database Access Layer In Network Operation Maintenace System

Network Operation Maintenance System, whose businesses are complex and change frequently, is one of key enterprise-level applications and requires good performance. Its foundation is the Database Access Layer, which is designed and implemented with technologies such as embedded SQL, Data Class and Object Relational Mapping (ORM). The business logic in its Access Layer is tightly coupled with the access logic. Its poor performance is unable to meet the requirement of Operation Maintenance System.This paper focuses on the design and implementation of the Database Access Layer, which can meet the requirements of Operation Maintenance System. This paper makes thorough research on the existing work on the Database Access Layer and analysis of the related technologies. And then we divide the Layer into Access Mmode Sub-layer and Connection Sub-layer in accordance with hierarchical thinking. During the design and implementation of Access Model Sub-layer, we adopt System inner Message Exchange Protocol (SMEP) and configuration file based on XML which is of powerful data representation and description ability and effectively decreases the degree of coupling. This paper employes Connection pool to design and implement Connection Sub-layer which dramatically improves the efficiency.Finally, we carry out experiments to verify the decoupling capability and performance of Access Layer. Results show that our system reduces the degree of coupling and attatins better performance than traditional Access Layer, which both meet the requirements of the project.