RSS
Twitter
Facebook
• Specialized Servers with
Specialized functions
• Print server
• File server
• DBMS server
• Web server
• Email server
• Clients can access the
specialized servers as needed
Logical two-tier client server
architecture
Clients
• Provide appropriate interfaces
through a client software module to access and utilize the various server
resources.
• Clients may be diskless
machines or PCs or Workstations with disks with only the client software
installed.
• Connected to the servers via
some form of a network.
• (LAN: local area network, wireless network, etc.)
DBMS Server
• Provides database query and
transaction services to the clients
• Relational DBMS servers are
often called SQL servers, query servers, or transaction servers
• Applications running on clients
utilize an Application Program Interface (API) to access server databases
via standard interface such as:
• ODBC: Open Database
Connectivity standard
• JDBC: for Java programming
access
• Client and server must install
appropriate client module and server module software for ODBC or JDBC
Two Tier
Client-Server Architecture
• A client program may connect to
several DBMSs, sometimes called the data sources.
• In general, data sources can be
files or other non-DBMS software that manages data. Other variations of clients
are possible: e.g., in some object DBMSs, more functionality is transferred to
clients including data dictionary functions, optimization and recovery across
multiple servers, etc.
0 comments