free classified ads and leads
domain website price


Describe centralized and client/ server architecture of DBMS?

Database

Centralized database system: The centralized database system consist of a single processor together with it associated data storage devices and other peripherals. It is physically confined to a single location. The data can be accessed from the multiple sites with the use of a computer network while the database is maintained at the central site.

Disadvantages of centralized database system::

  • When the central site computer or database system goes down, then everyone is blocked from using the system until the system comes back.
  • Communication costs from the terminals to the central site can be expensive.

    web hosting price

Client server dbms:- Client / server architecture of database systems has two logical components namely client and server. Client is generally personal computer or workstations whereas server is large workstations, mini range computer system or a mainframe computer system. The application and toals of DBMS run on one or more client platforms, while the DBMS softwares reside on the server. The server computer is called front end. These server and client computer are connected into a network. The application and tools act as client of the DBMS making requests for its services; client/ server architecture handles the graphical user interface (GUI) and does computations and other programming of interest to the end user.

ADVANTAGES:

      1. CLIENT / SERVER system has less expensive platforms to support applications that had previously been running only on large and expensive mini or main frame computers.
      2. Client/ server environment facilities in more productive work by the users and making better use of existing data.
      3. It is more flexible as compared to the centralized systems.
      4. Responsive time 7 throughput is high.
      5. A single dg(on server) can be shared across several distinct client (application) system.

DISADVANTAGE:

      1. Programming cost is high in client / server environment, particularly in initial phases.
      2. There’s a lack of management tools for diagnosis, performance monitoring and tuning and security control, for the DBMS client and OS and networking environments.




Just watch Poonam Pandey Photo Gallery


Bookmark and Share




Gallery

Related Topics

Comments

We are excited to tell you about the WEBPILOT franchise opportunity! We offer our franchisees an outstanding IT franchise opportunity that allows you to meet the communication needs of businesses in y
Reviewed By : , Date : 19-04-2018, Rated :


Submit Reviews:


(Enter the characters seen on the image below.)



Promotional Ads

Advertisement

Madhav Export: Manufacturer and Exporter of Cerami
307, Swara Parklane, Nr. Atabhai Circle, Bhavnagar, India – 364001
Bhavnagar

Online Pharmacy All Over World.
United States
(619) 299-1500
Albany

The Narmada Tent City | Statue of Unity Tent City
301, KALING Behind Bata Showroom Opp. Mount Carmel Convent school Ashram Road – 380009
Ahmedabad

E2E Excite Event Planning Corporate Event Planner in Coimbatore
Uday Enclave, 2nd Floor, D.No.163, West, Venkatachalam Street, R S Puram West, Coimbatore
Coimbatore

Green Eyes Optical Store
71, KrishnNagar society opp. Amul Garden memnagar, Ahmedabad, Gujarat 380052
Ahmedabad

Puzzelout : your academic solution
sector v
Kolkata

Bhagyalaxmi Industrial
156-158, C.P. Tank, Shop no. 4, Laxminiwas Building, Ardeshir Dadi Cross Lane
August Kranti Marg Mumbai

Metalloys International
Off: 3 – 15, Keshav Bhavan, 1st Parsiwada Girgaon
August Kranti Marg Mumbai

Neo Impex Stainless Pvt. Ltd
No. 2, Ground Floor, 12,Mehta Kunj, Sadashiv Lane,V. P. Road, Mumbai - 400 004,Maharashtra, .
Motilal Nagar Mumbai

Panache Industries
Shop no. 8, Ground Floor 13, Jaisiddhivinayak CHS., Ardeshir Dadi Cross Street, C. P. Tank, Mumbai - 400 004
Motilal Nagar Mumbai