基于轻量级类数据库中间件的应用的研究

发布时间：2018-10-29 17:58

【摘要】：数据库中间件是一个服务程序,它的核心是数据连接管理器,连接了客户端和后台数据库。常用数据库中Oracle价格昂贵,对于中小企业来说实施成本过高,Microsoft SQL Server不支持跨平台性,而MySQL其小巧开源的特点,在中小企业中得到了广泛的应用。Java开源数据库中间件Hibernate和iBatis,由于其自身存在的缺陷,使得企业在开发中的风险具有不可控制性。目前中小企业资金匮乏,而对信息化建设要求很迫切,因此,本文提出了基于轻量级数据库中间件的应用模式的研究。轻量级数据库中间件是指对JDBC驱动进行了轻量级的数据对象封装,使得人们在开发与数据库相关的应用程序时变得非常的快捷,而且对数据的操作请求也可以重载及复用。本文的技术路线是采用了面向对象的分析与设计(OOAD), Java的反射机制和原理,数据库连接池,以及静态网页生成和搜索引擎技术。具体如下：首先,论文叙述了数据库中间件在国内外的发展及应用状况,描述了数据库中间件的特点,介绍了三种在企业中最常用的数据库,并对其进行了分析,同时对两种Java开源数据库中间件进行了详细的描述和对比分析,在对这两种数据库中间件进行深入分析的基础上,提出了针对MySQL的轻量级数据库中间件的概念。其次,对于轻量级数据库中间件的设计按照功能点,分几个小节进行了详细的阐述。介绍了该中间件设计的设计思想,总体架构设计,即在插入、删除、修改数据时以事务的形式,而在进行查询时则不需要事务；在数据库连接池的使用上选择了最为快速、成熟、健壮的Proxool,并以静态网页生成技术和搜索引擎来代替缓存机制,提高页面请求的响应速度。最后,在上述理论研究的基础上,我们设计了一个轻量级的数据库中间件,并以一个应用实例来展示在此中间件基础上的开发过程和应用效果。
[Abstract]:Database middleware is a service program, its core is data connection manager, connecting client and background database. Oracle in common database is expensive, for small and medium-sized enterprises, the implementation cost is too high, Microsoft SQL Server does not support cross-platform, but MySQL has its small open source characteristics, has been widely used in small and medium-sized enterprises. Java open source database middleware Hibernate and iBatis, Because of its own defects, the risks in the development of enterprises are uncontrollable. At present, small and medium-sized enterprises are short of funds, but the requirement of information construction is very urgent. Therefore, this paper puts forward the research of application mode based on lightweight database middleware. Lightweight database middleware refers to the lightweight data object encapsulation of JDBC driver, which makes people develop database related applications very quickly, and the operation request of data can also be reloaded and reused. The technical route of this paper is to adopt the reflection mechanism and principle of object-oriented analysis and design (OOAD), Java, database connection pool, static web page generation and search engine technology. Firstly, the paper describes the development and application of database middleware at home and abroad, describes the characteristics of database middleware, introduces three kinds of database most commonly used in enterprises, and analyzes them. At the same time, two kinds of Java open source database middleware are described and compared in detail. Based on the deep analysis of these two kinds of database middleware, the concept of lightweight database middleware for MySQL is put forward. Secondly, the design of lightweight database middleware is described in detail in several sections according to the function point. This paper introduces the design idea of the middleware design, the overall architecture design, that is, insert, delete, modify the data in the form of transactions, but in the process of query, there is no need for transactions; In the use of database connection pool, the most rapid, mature and robust Proxool, is chosen, and the static web page generation technology and search engine are used instead of cache mechanism to improve the response speed of page requests. Finally, on the basis of the above theoretical research, we design a lightweight database middleware, and use an application example to show the development process and application effect based on this middleware.
【学位授予单位】：昆明理工大学
【学位级别】：硕士
【学位授予年份】：2012
【分类号】：TP311.13

【参考文献】