Main Article Content
Abstract
In the client/server architecture, the increasing numbers of users tend to add
more complexity in database applications. As a result, performance will be the main
reason for managing database server with many users. Altough two-tier model can work
well by separating application from data sources, people always looking for another
alternative to improve its performance and reability.
Three-tier model is the next development of two-tier model which add the third
component within client application and application server, called “the middle tier.”
Middle tier is placed in separate machine which has several functions. Do business
processing, and manage data are some of its useful functions. Separating business
processing machine from database server will improve its performance by using its
resources efficiently.
This paper will compare the performance of two-tier model with three-tier model
in client/server architecture to manage query in database application developed by
Delphi™. The connection process in three-tier model is focused on DCOM
implementation. As conclusion, three-tier model’s performance is more reliable and more
efficient than two-tier model in client/server architecture.
Keywords: client/server database, two-tier, three-tier, query, DCOM.
more complexity in database applications. As a result, performance will be the main
reason for managing database server with many users. Altough two-tier model can work
well by separating application from data sources, people always looking for another
alternative to improve its performance and reability.
Three-tier model is the next development of two-tier model which add the third
component within client application and application server, called “the middle tier.”
Middle tier is placed in separate machine which has several functions. Do business
processing, and manage data are some of its useful functions. Separating business
processing machine from database server will improve its performance by using its
resources efficiently.
This paper will compare the performance of two-tier model with three-tier model
in client/server architecture to manage query in database application developed by
Delphi™. The connection process in three-tier model is focused on DCOM
implementation. As conclusion, three-tier model’s performance is more reliable and more
efficient than two-tier model in client/server architecture.
Keywords: client/server database, two-tier, three-tier, query, DCOM.