ขั้นตอนวิธีการเปลี่ยนรูปแบบระหว่างวิธีเอชคิวแอลและ วิธีไคทีเรียเอพีไอของไฮเบอร์เนทเฟรมเวิร์ค

Abstract

This thesis proposes a transformation algorithm between two query mechanisms of Hibernate Framework: HQL and Criteria API. Hibernate Framework is well known framework for object-relational mapping which is widely used in the database application. In this thesis, the performance of the query mechanisms is investigated on the different environments, and the transformation algorithm is constructed to optimize the selected query method. The methods are tested on three different environments. The performance of the query mechanisms is measured by the execution time. The proficiency plays an important role in the overall efficiency of the system. Not only the transformation algorithm can reduce developers’ works and adapt to learn unfamiliarity method. Therefore, it is a tool for helping the collaboration work in a team when they have different skill. Moreover, the developers have to develop an application based on the legacy system. Therefore, the transformation algorithm is needed to convert HQL to Criteria API and vice versa. Six query types are supported by the algorithm: Simple Query, "and" Restriction Query, Paging Query, Unique Query, Order Query and Row count Query. A statement is converted to be a control flow graph for distinction the keywords which are different between HQL and Criteria API easily. The performance of the proposed algorithm is evaluated for correctness and completeness by the back-to-back testing. The test compares the output data between the prototype statement and the changed statement. The result of the testing indicates that the proposed method is able to convert the syntax commands from 100 percent.