CAJ | 학술논문

传统的 DBMS 的性能随着连接数的增加会降低,而且商业的 DBMS 由于昂贵的价格而不适用于一般用户.虽然Postgresql 性能逊于商业 DBMS,但是其性价比更高.文中旨在提高 Postgresql 的性能,在传统的服务器和客户之间增加TPM,并增加对服务器的监测功能以及实现动态改变服务器和客户间的连接数.由于最佳连接数取决于服务器的负载状况,因此文中设计不同连接数的 TPM 来分析服务器状态.实验使用 TPC-C 标准,结果证明,该方法能有效提高 Postgresql的性能,规定时间内的吞吐量有所增加,响应时间有所减小.
전통적 DBMS 적성능수착련접수적증가회강저,이차상업적 DBMS 유우앙귀적개격이불괄용우일반용호.수연Postgresql 성능손우상업 DBMS,단시기성개비경고.문중지재제고 Postgresql 적성능,재전통적복무기화객호지간증가TPM,병증가대복무기적감측공능이급실현동태개변복무기화객호간적련접수.유우최가련접수취결우복무기적부재상황,인차문중설계불동련접수적 TPM 래분석복무기상태.실험사용 TPC-C 표준,결과증명,해방법능유효제고 Postgresql적성능,규정시간내적탄토량유소증가,향응시간유소감소.
The performance of traditional DBMS will decrease when connection numbers between server and client increase. And the com-mercial DBMS is not widely used because of its expensive price. Though Postgresql has a part inferior to commercial DBMS on perform-ance side,it has higher cost efficient. The objective is to realize high performance and reliability in DBMS. And propose a new way by adding TPM between server and client. The key points are the function to detect the server state and change the connection numbers dy-namically. But the best connection number depends on the load state of server,so design TPM in various points to analyze server state. Use TPC-C benchmark in this test,and the results prove the effectiveness,and the throughout is bigger and responding time is shorter.