Page 14 - DCAP508_DATABASE_ADMINISTRATION

Database Administration

Notes 1.4.3 Client/Server

In a client/server system, the server is a relatively large computer in a central location that
manages a resource used by many people. When individuals need to use the resource, they
connect over the network from their computers, or clients, to the server. Examples of servers are:
Print servers: Manage the printers used by a team or unit.
File servers: Store large files used by a team or unit by using large disk drives.
E-mail servers: Run a company’s e-mail system.
In a client/server database architecture, the database files and DBMS software reside on a server.
A communications component is provided so applications can run on separate clients and
communicate to the database server over a network. The SQL Server communication component
also allows communication between an application running on the server and SQL Server.
Server applications are usually capable of working with several clients at the same time. SQL
Server can work with thousands of client applications simultaneously. The server has features to
prevent the logical problems that occur if a user tries to read or modify data currently being
used by others.

Notes While SQL Server is designed to work as a server in a client/server network, it is
also capable of working as a stand-alone database directly on the client.
The scalability and ease-of-use features of SQL Server allow it to work efficiently on a client
without consuming too many resources.

1.4.4 Structured Query Language (SQL)

To work with data in a database, you must use a set of commands and statements (language)
defined by the DBMS software. There are several different languages that can be used with
relational databases; the most common is SQL. Standards for SQL have been defined by both the
American National Standards Institute (ANSI) and the International Standards Organization
(ISO). Most modern DBMS products support the Entry Level of SQL-92, the latest SQL standard
(published in 1992).

Self Assessment

State true or false:
6. In a client/server database architecture, the database files and DBMS software reside on a
client.
7. There are different ways to organize data in a database but relational databases are one of
the most effective.
8. A database typically has two components.
9. Standards for SQL has been defined by the American National Standards Institute (ANSI)
only.
10. SQL Server is capable of working as a stand-alone database directly on the client only.

8 LOVELY PROFESSIONAL UNIVERSITY