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

【參考文獻(xiàn)】

相關(guān)期刊論文 前10條

1 李錚;;基于反射機(jī)制實(shí)現(xiàn)Java對(duì)象向Json數(shù)據(jù)的轉(zhuǎn)換[J];承德石油高等�？茖W(xué)校學(xué)報(bào);2010年01期

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

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

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

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

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

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

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

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

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

相關(guān)碩士學(xué)位論文 前1條

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

，

本文編號(hào)：2298387