DBMS Tutorial

DBMS Practice

When Not to Use a DBMS?

When Not to Use a DBMS: In this tutorial, we will learn about the facts when a DBMS (Database Management System) is not used. By Akash Kumar Last updated : May 26, 2023

When Not to Use a DBMS?

In spite of the advantage of using a DBMS, there is some situation in which a DBMS may involve unnecessary overhead costs that would not be incurred in traditional file processing. The overhead cost of using a DBMS is due to the following:

  1. High initial investment in hardware, software, and training.
  2. The basic property that DBMS provide is defining and processing of data.
  3. Overhead for providing security, concurrency control, recovery and integrity functions.

Additional problems may arise if the database designers and DBA don’t properly design the database or if the database systems application is not implemented properly. Hence it may be more desirable to use regular files under the following circumstances.

  1. We can use a regular file system when we know that a simple database is not going to change.
  2. Stringent, real-time requirements for some programs that may not be met because of DBMS overhead.
  3. No multiple user access to data.

Industries & Applications That Does Not Use DBMS

Certain industries and application have elected not to use general purpose DBMSs.

  1. Many computer-aided design tools (CAD) used by students of the mechanical and civil department have proprietary file and data management software that is geared for the internal manipulation of drawing and 3D objects.
  2. Communication and switching systems which are basically designed by companies like AT&T were early manifestations of database software that was used because they are made to run very fast with hierarchically organized data and to access and routing of calls quickly.
  3. Similarly, GIS implementation often implements their own data organization schemes for efficiently implementing function related to processing maps, physical contours, lines, polygons, and so on and General purpose DBMS are inadequate for their purpose.

Comments and Discussions!

Load comments ↻

Copyright © 2024 www.includehelp.com. All rights reserved.