Research And Implementation Of Data Access Layer In IPlat4c Platform

This paper focuses on the design and implementation of data access layer in iPlat4c platform for information system.The platform iPlat4c provides the whole process of implementation support for the development of iron and steel smelting information system. The platform iPlat4c is responsible for program development, compiling, running and publishing applications. It can reduce the workload of the system’s development for applications, and provide an efficient, robust and orderly management of the platform support for the information system. The database access layer is the basis of the platform iPlat4c.This paper focuses on design and implementation of a database access layer to meet the requirements of the platform iPlat4c. According to the analysis of database access layer development status and related technology, the database access layer is divided into a database abstraction component and a unified interface for applications component two parts.Database abstraction component parts is responsible for providing a unified interface to the unified interface for applications component callable unified interface, and is responsible for encapsulating the underlying database API and data structures. Unified interface for applications component is responsible for providing a unified and easy interface to the user, for the database data stored locally and the operational capacity of the local data, and the management of database connections.In the database abstract component’s design and implementation process, the paper first analyzes the database access patterns and transaction support. Second, we design the unified database interface and achieve the abstract of the database interface, for implementation platform on demand access to different databases. And finally the paper describes the MySQL and Oracle programming mechanisms, transaction and detailed implementation process.In the design and implementation process of unified interface for applications component, the paper uses connection pool ideas in order to improve the performance access to database,and detailed describes the process of connection establishment and release in the connection pool.About data access services, the paper refer to the object model of Microsoft ADO.NET, through the object model to achieve access to the database and data manipulation.And the DataSet is discussed in detail as well as the operation on the DataSet. The unified interface for applications component supply a unified interface for applications.The significance of this paper is programmer can extract part of the codes in the data access layer and add it to the development of the application. The data access layer improve access efficiency, but also achieve codes reusability.It can achieve cross-platform development and compatible with different database software, simplifies the development process and save development time.The data access layer makes the structure more clearly, easier to understand,more convenient to update the new database.