Effects of Hibernate Second-Level Cache on Query Performance

碩士 === 國立雲林科技大學 === 資訊管理系 === 102 === In recent years, data digitized enhance the execution speed of enterprise. The framework of Data access has become an indispensable technology. Hibernate is a data access framework commonly. The Hibernate framework is a JDBC (Java Database Connectivity) lightwei...

Full description

Bibliographic Details
Main Authors: Cheng-Wei Huang, 黃晟瑋
Other Authors: Hsueh-Chi Shih
Format: Others
Language:zh-TW
Published: 2014
Online Access:http://ndltd.ncl.edu.tw/handle/60975069288059873468
Description
Summary:碩士 === 國立雲林科技大學 === 資訊管理系 === 102 === In recent years, data digitized enhance the execution speed of enterprise. The framework of Data access has become an indispensable technology. Hibernate is a data access framework commonly. The Hibernate framework is a JDBC (Java Database Connectivity) lightweight package. Primarily through third-party software to create secondary cache. Use secondary caching to reduce developers to access the database frequency. Further improve query efficiency. This research will explore Hibernate in the environment of original and secondary cache. Through performance monitoring software to evaluate their performance status, used different applications simulate real situation. According to retrieve the query response time as its evaluation criteria. Experiment is divided into two parts. First, when secondary cache store the data of query statement, the query performance status on response time. Second, when simulate normal distribution to do random queries by Zipf-distribution, and simulate high usage of data by Beta-distribution , impact of the number of queries to the query response time effective, the impact on query response time by the number of queries. Based on the experimental results, when secondary cache store the data of query statement and the number of queries reached certain percentage. The secondary cache will perform functions effectively, significantly reduced the response time of query statement. Therefore effectively improve query performance, and improve work efficiency when developing.