Two-tier Client / Server Architecture Database System Applications

In this paper, we mainly discussed the two-tier Client/Server Database Management System in four phases: construction of database server, design of database application software on client, connection between application software and database server and maintenance of Database Management System.In the database server construction, we emphasized on how to create new user database and its objects using SQL Server 7.0 and Transact-SQL. We also introduced the measures adopted to ensure the safety of the database; In the design of application software, we discussed how to realize the two modules of query and management of database using C++ Builer. By the comparison of a few kinds of datasets in C++ Builer, we got a deeper understanding of the principle of database query; On closing this paper, we elaborated on the BDE and ODBC, and made efficient improvement on system function and executed helpful maintenance with the tools of SQL Server Manager.