Function, Advantages, Disadvantages of DBMS

-

 Blogpost #2

A. Engage


(a) Functions of DBMS

Data Definition - The DBMS must be able to accept data definitions in source form and convert to the appropriate object form. 

Data Manipulation - The DBMS must be able to handle request from the user to retrieve and possibly update existing data in the database, or to add a new data to the database.

Data Security and Integrity - The DBMS must be able to monitor user requests and reject any attempts to violate the security and integrity checks defined by the database administrator.

Data Recovery and Concurrency - The DBMS must have the capability of recover from or minimize the effects of a system crash.

Data Dictionary - The DBMS must provide a system database called the database dictionary.

The Main function of a DBMS it organizes your database files and provides end users more access and control over their data. 



(b) Advantages of DBMS

DATA INTEGRITY - Since a single copy of a particular data is stored in the database, you can be certain that the changes to the data will be reflected in all future uses of that data. 

DATA INDEPENDENCE - The structure of the database system requires that data be independent of other data in the database and the software used to access the database. 

DATA CONSISTENCY - Data consistency is maintained in the database environment. 

EASIER USE OF DATA - Data is easier to use in the database environment. 

DATA SECURITY - A database system can have additional security measures as part of the database software product. 

LESS STORAGE - Since data redundancy is reduce if not eliminated, the database will occupy less storage space.

REDUCED DATA REDUNDANCY - In database system, data redundancy is avoided by keeping a single copy of the data. 


(c) Disadvantages of DBMS
COMPLEXITY - Databases and their associated DBMS are extremely complex. 

EXPENSE - The installation of the DBMS and its databases onto the current system requires careful planning because of the possibility of the need for additional hardware.

LOCKING-IN OF TECHNOLOGY - What if the vendor expresses a desire to abandon the product? There is a possibility that they will have to redesign their system from scratch.

COMPATIBILITY - One of the pitfalls of most database systems is their incompatibility with other database systems

VULNERABILITY - Because data in a database is in a central location, it is vulnerable to partial or complete destruction when a breakdown of hardware components occur or in software mistake.

SIZE - A typical mainframe database is very large.

TRAINING COSTS - When a company purchase a database product, it must first train one or more individuals to be the database administrator for the new product.



B. EXPLORE & EXPLAIN

1. What are the different components of DBMS?
- Storage engine, Query language, Query processor, Optimization engine, Metadata catalog, Log manager, Reporting and monitoring tools, Data utilities

2. What is the difference between data and information?
- Data is a collection of facts, while information puts those facts into context. While data is raw and unorganized, information is organized.

3. What is an overall system structure of a DBMS?
- The database system is divided into three components: Query Processor, Storage Manager, and Disk Storage.

4. What are the different functions of DBMS?
- Defining a particular database, constructing or loading the initial database contents on a secondary storage medium, manipulating the database, processing and sharing by a set of concurrent users and applicant programs.

5. Who are the different users of DBMS?
- Database Administrators, Database Designers, System Analyst, Application programmers/ back-end developers, Naïve users, Sophisticated Users, Casual users.

C. ELABORATE & EVALUATION

Database Management System 1. An automated system for maintaining records.
Disk Allocation 2. Manages the allocation of disk storage space.
Data Sharing 3. Stored in a database is both integrated and share.
Database Users 4. Refers to the people whose jobs require access to the database system for querying, updating, and generating useful reports.
Query Language Processor 5. Translate statements in query language.

Comments

Post a Comment

Popular posts from this blog

Introduction To SQL

-
Image
 Blogpost #4 A. Engage  a. DATA DEFINITION LANGUAGE - Data definition language is a language for describing data and how it relates to other data in the database. b. INTERACTIVE DATA MANIPULATION LANGUAGE  - IDML is a programming language used for manipulating data in a database, where users can directly interact and modify data in real-time. c. EMBEDDED DATA MANIPULATION LANGUAGE - EDML is a programming language that is integrated into software applications to help users manipulate database data within the application. With EDML, users can easily perform data manipulation tasks without having to leave the application interface. B. EXPLORE & EXPLAIN 1. What are the basic SQL expression? ·         SELECT: Used to retrieve data from a database table ·         INSERT: Used to add new records to a database table ·         UPDATE: Used to modify e...
Read more

Information Management 1 Class Experience

-
Image
  Blogpost #1 The first week our teacher gave us an overview on the topics and what will do in her class and I'm looking forward to learning more to this subject. Every Wednesday and Thursday I take my Information Management classes, at first, I thought this subject wouldn't be interesting but a couple of weeks later I learned a lot about databases and how they work and the reason why databases is needed. During my classes I've learned a lot about data and information and what are their differences and also, I've learned about concepts and DBMS and its components and more. I've learned a lot for the past 4 weeks, so I must say the subject is hard, but I think I can handle it for the next few months.
Read more