SQL Server 2000 Architecture

SQL Server 2000 is a database engine client / server is different from traditional single computer database, which uses a file system usage together for example dBASE, Microsoft Jet, FoxPro. Database systems that use the shared files depends on a single client processes per user to manipulate the data in shared files on network servers. In multi-user environment will appear to various problems, namely concurrency control using locking mechanism at the network layer.

Database system with client / server such as SQL Server 2000 using a process server to manipulate data, and requires the client process associated with the process server using IPC mechanism (inter-process communication), a local or remote, such as TCP / IP socket. The process server is a server application that processes SQL commands. The process server also handles concurrency by using more sophisticated locking mechanism from the network file system, which is used together. After running the server processes the commands, the results will be sent back to the client process through the mechanism of IPC. In this way client / server provides better access to data, which is shared by many users.

SQL Server 2000 provides a good language and interface for programming and communication with the server. Transtact-SQL Server is a programming language that is a superset of ANSI-SQL. ANSI-SQL defines four basic commands for manipulating the data which are SELECT, INSERT, UPDATE and DELETE, and a number of commands to define the database structure. Transtact-SQL add on a few things on the ANSI-SQL. Additional programming is the construction, which allows the use of stored procedures and triggers to modify data that will be executed for a particular event occurs.