Research Of Application Based On Lightweight Similar Database Middleware

The database middleware is a service program, its core is a data connection manager to connect the client and back-end database.In the commonly used database, the price of Oracle is expensive, so the implementation costs are too high for SMEs, Microsoft SQL Server does not support cross-platform, MySQL is small, open-source characteristics, so it has been widely used in SMEs. The Java open source database middleware:Hibernate and iBatis, due to its own defects, making the enterprise in the development of risk can not be controlled.Lack of finance for SMEs, while the construction of information technology requirements are very urgent, therefore, this paper presents a middleware application that based on lightweight database model. Lightweight database middleware is a lightweight data object which encapsulates the JDBC driver, making it very fast for development of database-related applications, and requests can also be overloaded and complex operations on datawith.The technical line of this article is the use of Object-Oriented Analysis and Design (OOAD), Java’s reflection mechanism and principles, database connection pool, as well as a static page generation and search engine technology. As follows:First, the paper describes the database middleware development and application of conditions at home and abroad, described the characteristics of the database middleware, the three most commonly used enterprise database and its analysis, described the two Java open source database middleware in detail, and compared in both database middleware in-depth analysis, on the basis of the concept, we puts forward the lightweight database middleware for the MySQL.Secondly, the design for a lightweight database middleware is divided into several sections according to the function point elaborated. We describe the design ideas the overall architecture of the middleware, insert, delete, and modify data in the form of the transaction, and query data not need the transaction; the using of the database connection pool, we select the most rapid, mature, robust Proxool. using static page generation and search engine instead the caching mechanism, improved the response speed of a page request.Finally, on the basis of the above theoretical studies, we designed a lightweight database middleware, and using an application example to demonstrate the development process on the basis of this middleware and application effects.