1 / 15

DISADVANTAGES & USERS OF DATA BASE MANAGEMENT SYSTEM

DISADVANTAGES & USERS OF DATA BASE MANAGEMENT SYSTEM. TO BE DISCUSSED... Disadvantages of Database Management System Cost of Hardware & Software Cost of Data Conversion Cost of Staff Training Appointing Technical Staff Database Failures Types of users in DBMS

kilby
Télécharger la présentation

DISADVANTAGES & USERS OF DATA BASE MANAGEMENT SYSTEM

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DISADVANTAGES & USERS OF DATA BASE MANAGEMENT SYSTEM

  2. TO BE DISCUSSED... Disadvantages of Database Management System • Cost of Hardware & Software • Cost of Data Conversion • Cost of Staff Training • Appointing Technical Staff • Database Failures Types of users in DBMS • Application programmers or Ordinary users • End users • Database Administrator (DBA) • System Analyst

  3. Disadvantages of Database Management System (DBMS) Although there are many advantages but the DBMS may also have some minor disadvantages. These are:

  4. 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

  5. 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

  6. 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

  7. 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

  8. 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

  9. 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

  10. 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

  11. 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

  12. 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

  13. 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

  14. 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

  15. THANKS BACK

More Related