What are the advantages and disadvantages of working with multiple DBMS tables?

Answer 1

The advantages of DBMS are as follows:

-Controlling redundancy

-Providing storage structure for efficient query processing.

-Restricting unauthorized users.

-Providing concurrency.

-Providing backup and recovery.

-Enforcing integrity constraints.

The disadvantages are as follows:

-Centralization:That is use of the same program at a time by many user sometimes lead to loss of some data.

-High cost of software.

technical experties are required

power dependency

--

Reporting features like charts of a spreadsheet like Excel may not be available in RDBMS.

Answer 2

Disadvantages of using a DBMS

A database system generally provides on-line access to the database for many users. In contrast, a conventional system is often designed to meet a specific need and therefore generally provides access to only a small number of users. Because of the larger number of users accessing the data when a database is used, the enterprise may involve additional risks as compared to a conventional data processing system in the following areas.

1. Confidentiality, privacy and security.
2. Data quality.
3. Data integrity.
4. Enterprise vulnerability may be higher.
5. The cost of using DBMS.

Confidentiality, Privacy and Security

When information is centralised and is made available to users from remote locations, the possibilities of abuse are often more than in a conventional data processing system. To reduce the chances of unauthorised users accessing sensitive information, it is necessary to take technical, administrative and, possibly, legal measures.

Most databases store valuable information that must be protected against deliberate trespass and destruction.

Data Quality

Since the database is accessible to users remotely, adequate controls are needed to control users updating data and to control data quality. With increased number of users accessing data directly, there are enormous opportunities for users to damage the data. Unless there are suitable controls, the data quality may be compromised.

Data Integrity

Since a large number of users could be using a database concurrently, technical safeguards are necessary to ensure that the data remain correct during operation. The main threat to data integrity comes from several different users attempting to update the same data at the same time. The database therefore needs to be protected against inadvertent changes by the users.

Enterprise Vulnerability

Centralising all data of an enterprise in one database may mean that the database becomes an indispensible resource. The survival of the enterprise may depend on reliable information being available from its database. The enterprise therefore becomes vulnerable to the destruction of the database or to unauthorised modification of the database.

The Cost of using a DBMS

Conventional data processing systems are typically designed to run a number of well-defined, preplanned processes. Such systems are often "tuned" to run efficiently for the processes that they were designed for. Although the conventional systems are usually fairly inflexible in that new applications may be difficult to implement and/or expensive to run, they are usually very efficient for the applications they are designed for.

The database approach on the other hand provides a flexible alternative where new applications can be developed relatively inexpensively. The flexible approach is not without its costs and one of these costs is the additional cost of running applications that the conventional system was designed for. Using standardised software is almost always less machine efficient than specialised software.