Pr.Pg Next Pg

Advantages of RDBMS over DBMS tutorials

or

Advantages of Client/Server database model over desktop database model

 

·         Reliability is improved because the data is not spread across the network and several applications. Only one process handles the data.

·         Network traffic is greatly reduced. Let’s say in desktop database model – entire database along with indexes is to be sent to client. Where as in Client/server database model only result is to be sent to client.

·         Upgrading a heavily used desktop database to a well-designed client/server database will reduce database-related network traffic by more than 95%.

·         Performance is improved as database operations are handled over server, so client PCs will have less processing requirement.

·         Security is improved as data are kept within a single server. Hacking into a data file that is protected within the server is much more difficult than hacking into a data file on desktop database model.

·         Data integrity constraints and business rules can be enforced at server level. You can specify rules such as “Marks of any subject cannot exceed 100 in any subject”

·         Data Sharing: SQL is used to coordinate data sharing by concurrent users, ensuring that they do not interfere with one another.

·         Data can be integrated using multiple platform i.e. LAN, WAN and WAN. One can incorporate data from INTERNET

 

 


 

 

Pr.Pg border                                              Next Pg