User`s guide

An SQL query is an SQL statement designed specifically to request data from one or more SQL
databases. Some SQL applications require that you type in an SQL query directly using a text editor,
while others provide graphical user interfaces that lead you through the process of querying an SQL
database. In the latter case, the application must create an SQL statement based on the information
you provide. This statement is the actual SQL query, and it is the SQL query that is used to request the
data. Crystal Reports falls into both categories of SQL-compliant applications.
23.2.1.1 Client/server architecture
One of the most powerful features of SQL DBMS applications is their ability to efficiently use the
client/server architecture of a network.
A simple network structure consists of one or more network servers that provide a common location
where all users on the network can obtain data and applications. Many network servers also provide
network security, automated services such as backing up data, and network resource monitoring to
provide the best service possible to all workstations on the network. Because of the high processing
demands required by a network server, the computer used as the server is often a high-powered, fast
machine that may contain multiple processors, multiple hard drives, and multiple CD-ROM drives.
A network client is a single computer workstation that is used regularly by one or more company
employees. A user works on the client and accesses data and applications from the server over the
network. Large processing jobs that require a lot of time and resources are handled by the server, and
2012-03-14508
Understanding Databases