disadvantages & users of data base management system
TRANSCRIPT
![Page 1: DISADVANTAGES & USERS OF DATA BASE MANAGEMENT SYSTEM](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f0c5503460f94c2020d/html5/thumbnails/1.jpg)
DISADVANTAGES & USERS OF DATA BASE
MANAGEMENT SYSTEM
![Page 2: DISADVANTAGES & USERS OF DATA BASE MANAGEMENT SYSTEM](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f0c5503460f94c2020d/html5/thumbnails/2.jpg)
TO BE DISCUSSED...Disadvantages of Database Management System Cost of Hardware & Software Cost of Data Conversion Cost of Staff Training Appointing Technical Staff Database FailuresTypes of users in DBMS Application programmers or Ordinary users End users Database Administrator (DBA) System Analyst
![Page 3: DISADVANTAGES & USERS OF DATA BASE MANAGEMENT SYSTEM](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f0c5503460f94c2020d/html5/thumbnails/3.jpg)
Disadvantages of Database Management System (DBMS)
Although there are many advantages but
the DBMS may also have some minor disadvantages. These are:
![Page 4: DISADVANTAGES & USERS OF DATA BASE MANAGEMENT SYSTEM](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f0c5503460f94c2020d/html5/thumbnails/4.jpg)
Cost of Hardware & Software:
A processor with high speed of data processing and memory of large size is required to run the DBMS software. It means that you have to upgrade the hardware used for file-based system. Similarly, DBMS software is also Very costly.
BACK
![Page 5: DISADVANTAGES & USERS OF DATA BASE MANAGEMENT SYSTEM](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f0c5503460f94c2020d/html5/thumbnails/5.jpg)
Cost of Data Conversion:
When a computer file-based system is replaced with a database system, the data stored into data file must be converted to database files.
It is difficult and time consuming method to convert data of data files into database. You have to hire DBA (or database designer) and system designer along with application programmers; Alternatively, you have to take the services of some software houses. So a lot of money has to be paid for developing database and related software. BACK
![Page 6: DISADVANTAGES & USERS OF DATA BASE MANAGEMENT SYSTEM](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f0c5503460f94c2020d/html5/thumbnails/6.jpg)
Cost of Staff Training:
Most DBMSs are often complex systems so the training for users to use the DBMS is required. Training is required at all levels, including programming, application development, and database administration. The organization has to pay a lot of amount on the training of staff to run the DBMS.
BACK
![Page 7: DISADVANTAGES & USERS OF DATA BASE MANAGEMENT SYSTEM](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f0c5503460f94c2020d/html5/thumbnails/7.jpg)
Appointing Technical Staff:
The trained technical persons such as database administrator and application programmers etc are required to handle the DBMS. You have to pay handsome salaries to these persons. Therefore, the system cost increases.
BACK
![Page 8: DISADVANTAGES & USERS OF DATA BASE MANAGEMENT SYSTEM](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f0c5503460f94c2020d/html5/thumbnails/8.jpg)
Database Failures:
In most of the organizations, all data is integrated into a single database. If database is corrupted due to power failure or it is corrupted on the storage media, then our valuable data may be lost or whole system stops.
BACK
![Page 9: DISADVANTAGES & USERS OF DATA BASE MANAGEMENT SYSTEM](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f0c5503460f94c2020d/html5/thumbnails/9.jpg)
Types of users in DBMS Users are of 4 types:
1 Application programmers or Ordinary users
2 End users 3 Database Administrator (DBA) 4 System Analyst
BACK
![Page 10: DISADVANTAGES & USERS OF DATA BASE MANAGEMENT SYSTEM](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f0c5503460f94c2020d/html5/thumbnails/10.jpg)
Application programmers or Ordinary users:
These users write application programs to interact with the database. Application programs can be written in some programming language such a COBOL, PL/I, C++, JAVA or some higher level fourth generation language.
Such programs access the database by issuing the appropriate request, typically a SQL statement to DBMS.
BACK
![Page 11: DISADVANTAGES & USERS OF DATA BASE MANAGEMENT SYSTEM](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f0c5503460f94c2020d/html5/thumbnails/11.jpg)
End Users:
End users are the users, who use the applications developed. End users need not know about the working, database design, the access mechanism etc. They just use the system to get their task done. End users are of two types:
a) Direct users b) Indirect users
BACK
![Page 12: DISADVANTAGES & USERS OF DATA BASE MANAGEMENT SYSTEM](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f0c5503460f94c2020d/html5/thumbnails/12.jpg)
a) Direct users: Direct users are the users who se the computer,
database system directly, by following instructions provided in the user interface. They interact using the application programs already developed, for getting the desired result. E.g. People at railway reservation counters, who directly interact with database.
b) Indirect users: Indirect users are those users, who desire benefit form
the work of DBMS indirectly. They use the outputs generated by the programs, for decision making or any other purpose. They are just concerned with the output and are not bothered about the programming part.
BACK
![Page 13: DISADVANTAGES & USERS OF DATA BASE MANAGEMENT SYSTEM](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f0c5503460f94c2020d/html5/thumbnails/13.jpg)
Database Administrator (DBA):
Database Administrator (DBA) is the person which makes the strategic and policy decisions regarding the data of the enterprise, and who provide the necessary technical support for implementing these decisions.
Therefore, DBA is responsible for overall control of the system at a technical level. In database environment, the primary resource is the database itself and the secondary resource is the DBMS and related software administering these resources is the responsibility of the Database Administrator (DBA).
BACK
![Page 14: DISADVANTAGES & USERS OF DATA BASE MANAGEMENT SYSTEM](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f0c5503460f94c2020d/html5/thumbnails/14.jpg)
System Analyst:
System Analyst determines the requirement of end users, especially naïve and parametric end users and develops specifications for transactions that meet these requirements.
System Analyst plays a major role in database design, its properties; the structure prepares the system requirement statement, which involves the feasibility aspect, economic aspect, technical aspect etc. of the system.
BACK
![Page 15: DISADVANTAGES & USERS OF DATA BASE MANAGEMENT SYSTEM](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649f0c5503460f94c2020d/html5/thumbnails/15.jpg)
BACK