Home - Aneeqa6/DATABASE- GitHub Wiki

QNO1:-) WRite The Advantages And Disadvantages Of CEntralaized Database System?

   ADVANTAGES OF CENTRALIZED DATABASE

1:-) No Redundancy

2:-)All the information can be accessed at the same time from the same location

3:-)Security And Backup

4:-)Power supply and maintenance costs all are minimized

5:-)Speed of Operation

  DISADVANTAGES OF CENTRALIZED DATABASE

1:-) Centralized database are highly dependent on network connectivity.The slower the internal connection is the longer the database access time will be needed

2:-) Time Consuming

3:-) Static SQL cannot be used

4:-) Cost of heavy equipment

QNO2:-) Write The Advantages And Disadvantages Of Distributed DataBase System?

       ADVANTAGES OF DISTRIBUTED DATABASE

1:-) Data can be joined and update from different tables which are located on different machines

2:-) Increase Reliability

3:-) Even if a system fails the integrity of the distributed database is maintained

4:-) A distributed database is secure

5:-) A user does not know where the data is located physically

     DISADVANTAGES OF DISTRIBUTED DATABASE

1:-) Database optimization is difficult in a distributed database

2:-) Cost of hardware and software

3:-) Managing system catalog is a difficult task

4:-) Complex database design

5:-) Network trafic is increased in a distributed database