18-07-2012, 04:47 PM
SEMINAR REPORT ON DBMS
DBMS.doc (Size: 206.5 KB / Downloads: 54)
INTRODUCTION TO ORACLE
CLIENT SERVER COMPUTING ARCHITECTURE
It consists of two or more computers designated as client machine running an application program which communicates with remote computer designated as server machine which serves request from client machine. In basic model of client server computing, RDBMS resides on server machine. The application program which resides on client machine interfaces with client software called middleware that are responsible for communicating request & results between their application programs and RDBMS.
CLIENT
The Client is the front END application of a database which interacts
with the server. The Client has more responsibility for accessing the data, it concentrates on the requests. The processing and presentation is managed by the server.
SERVER
The Server executes the Oracle software and these with the function required for simultaneous and shared data excess. The server receives and processes the SQl and PL/SQL declaration and that originates in the client application.
ADVANTAGES OF CLIENT SERVER MODEL
It allows the user to work in extensible form.
It can work on any type of operating system eg. UNIX, LINUX, Win 98.
It provides the facility to establish the link between remote databases.
It provides the facility of fast accessing of information and processing of data.
Better application performance and network usage i.e. it reduces the network time.
It is multiplatform and centralized.
Distributed computing as the servers act as a focal point for data management.
Provides flexibility and full utilization of all resources.
The same database is shared by different clients.
DISADVANTAGES OF CLIENT SERVER MODEL
Bottleneck: If a significant portion of application layer is moved to a server, the server may become a bottle neck in the processing and distribution of data to the client
Server limited resources will be in over higher demanding by the increasing no. of resource consumers.
Security features: It has to take care of the security of the database from unauthorized access.