【摘要】：數(shù)據(jù)庫中間件是一個服務程序,它的核心是數(shù)據(jù)連接管理器,連接了客戶端和后臺數(shù)據(jù)庫。常用數(shù)據(jù)庫中Oracle價格昂貴,對于中小企業(yè)來說實施成本過高,Microsoft SQL Server不支持跨平臺性,而MySQL其小巧開源的特點,在中小企業(yè)中得到了廣泛的應用。Java開源數(shù)據(jù)庫中間件Hibernate和iBatis,由于其自身存在的缺陷,使得企業(yè)在開發(fā)中的風險具有不可控制性。目前中小企業(yè)資金匱乏,而對信息化建設要求很迫切,因此,本文提出了基于輕量級數(shù)據(jù)庫中間件的應用模式的研究。輕量級數(shù)據(jù)庫中間件是指對JDBC驅(qū)動進行了輕量級的數(shù)據(jù)對象封裝,使得人們在開發(fā)與數(shù)據(jù)庫相關的應用程序時變得非常的快捷,而且對數(shù)據(jù)的操作請求也可以重載及復用。 本文的技術路線是采用了面向?qū)ο蟮姆治雠c設計(OOAD), Java的反射機制和原理,數(shù)據(jù)庫連接池,以及靜態(tài)網(wǎng)頁生成和搜索引擎技術。具體如下： 首先,論文敘述了數(shù)據(jù)庫中間件在國內(nèi)外的發(fā)展及應用狀況,描述了數(shù)據(jù)庫中間件的特點,介紹了三種在企業(yè)中最常用的數(shù)據(jù)庫,并對其進行了分析,同時對兩種Java開源數(shù)據(jù)庫中間件進行了詳細的描述和對比分析,在對這兩種數(shù)據(jù)庫中間件進行深入分析的基礎上,提出了針對MySQL的輕量級數(shù)據(jù)庫中間件的概念。 其次,對于輕量級數(shù)據(jù)庫中間件的設計按照功能點,分幾個小節(jié)進行了詳細的闡述。介紹了該中間件設計的設計思想,總體架構(gòu)設計,即在插入、刪除、修改數(shù)據(jù)時以事務的形式,而在進行查詢時則不需要事務；在數(shù)據(jù)庫連接池的使用上選擇了最為快速、成熟、健壯的Proxool,并以靜態(tài)網(wǎng)頁生成技術和搜索引擎來代替緩存機制,提高頁面請求的響應速度。 最后,在上述理論研究的基礎上,我們設計了一個輕量級的數(shù)據(jù)庫中間件,并以一個應用實例來展示在此中間件基礎上的開發(fā)過程和應用效果。
[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

【參考文獻】

相關期刊論文 前10條

1 李錚;;基于反射機制實現(xiàn)Java對象向Json數(shù)據(jù)的轉(zhuǎn)換[J];承德石油高等專科學校學報;2010年01期

2 賈素來;;淺議常見WEB數(shù)據(jù)庫訪問技術[J];大眾科技;2009年09期

3 王洪香;;在JSP中利用JDBC驅(qū)動訪問數(shù)據(jù)庫[J];辦公自動化;2011年22期

4 張聰品;劉超;;基于JAVA反射機制的規(guī)則引擎設計與實現(xiàn)[J];河南師范大學學報(自然科學版);2010年03期

5 黃炳恭;;淺談我國中小企業(yè)融資難的成因及對策[J];經(jīng)濟師;2008年11期

6 趙廣利,趙煥忠;基于Oracle數(shù)據(jù)庫安全管理技術的實現(xiàn)[J];計算機工程與應用;2000年04期

7 宋善德,郭飛;基于JAVA的WEB數(shù)據(jù)庫連接池技術的研究[J];計算機工程與應用;2002年08期

8 朱曉明,劉衛(wèi)東,藺為民;數(shù)據(jù)庫連接中間件的研究[J];計算機工程與應用;2003年20期

9 李書振;MySQL數(shù)據(jù)庫的安全機制[J];計算機應用;2002年06期

10 宋漢增,沈琳;利用Hibernate對象持久化服務簡化Java數(shù)據(jù)庫訪問[J];計算機應用;2003年12期

相關碩士學位論文 前1條

1 肖賢建;數(shù)據(jù)庫中間件的查詢優(yōu)化機制研究[D];河海大學;2005年

，

本文編號：2298387