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



Submit Reviews:


(Enter the characters seen on the image below.)



Promotional Ads

Advertisement

Brij Agnihotri & associates company secretaries
3454, 40D, Sector 40D, Chandigarh, 160036, India

JB Rock Bolts & SN BOLTS
10 A & B Industrial Area (at Vill. Nangal Jarialan)
Distt. Una Himachal Pradesh
Ambala Cantt

Govinda resorts Lonavala
Old Mumbai - Pune Hwy, Maval, Lonavala, Maharashtra 410405
Lonavla

Tri Round Bars
Tri Round Bars, Harharwala Building, Islampura Rd, near GOKUL HOTEL, Charni Road East, Bori Chawl, Khetwadi, Girgaon, Mumbai, Maharashtra 400004, India
Shivaji Nagar (Kurla) Mumbai

Best Resorts in Dharamshala Amid the Misty Hills.
SATOBARI HILLS ROAD,MCLEODGANJ,
Dharamshala

Genius Global School
194 Anand Vihar Saproon, Solan, Himachal Pradesh
Ambala Cantt

CORNEA CENTRE - Best Eye Specialist In Ahmedabad
101, Parker House Near Radisson Blu Hotel Near Laxmi Cycle shop Panchvati, Netaji Rd, Ambawadi,
Ahmedabad

Dezy Dental Clinic
J K LANDMARK, 4th Floor,
27th Main Rd, 1st Sector, HSR Layout, Bengaluru

Indo Air Compressors Pvt. Ltd.
Plot no-550, Main Rd
Kathwada GIDC, Odhav Industrial Estate, Odhav
Ahmedabad

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