About DBMS (Database Management System)

Last blog we talked about what exactly a DBMS (Database Management System) is, but now let's dig in a little deeper about it, what it's functions and pros and cons are.

What are the functions of DBMS?



Down below is a list of it's functions.
  • DATA DEFINITION
    The DBMS must be able to accept data definitions(external, internal and conceptual schemas, and all associated mappings) 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.     


What are the advantages and disadvantages of DBMS?

Now that we know it's functions, let's delve into the thought of what the ups and downs of DBMS is, and can we truly utilize it despite it's disadvantages.

Advantages of DBMS:

  • REDUCED DATA REDUNDANCY
    In database system, data redundancy is avoided by keeping a single copy of the data. 
  • 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 SECURITY
    A database system can have additional security measures as part of the database software product.  
  • DATA CONSISTENCY
    Data consistency is maintained in the database environment. 
  • EASIER USE OF DATA
    Data is easier to use in the database environment.
  • LESS STORAGE
    Since data redundancy is reduce if not eliminated, the database will occupy less storage space. 
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.
  • 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. 
  • COMPATIBILITY
    One of the pitfalls of most database systems is their incompatibility with other database systems. 
  • 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.

Comments

Post a Comment

Popular posts from this blog

INTRODUCTION TO JSON

Image
XML      What is XML? The Extensible Markup Language (XML) is  a simple text-based format for representing structured information: documents, data, configuration, books, transactions, invoices, and much more . It was derived from an older standard format called SGML (ISO 8879), in order to be more suitable for Web use JSON     Moving on to JSON , it is a text-based data format following JavaScript object syntax, which was popularized by Douglas Crockford  Even though it closely resembles JavaScript object literal syntax, it can be used independently from JavaScript, and many programming environments feature the ability to read (parse) and generate JSON.     I s a string whose format very much resembles JavaScript object literal format. You can include the same basic data types inside JSON as you can in a standard JavaScript object  strings, numbers, arrays, booleans, and other object literals. This allows you to construct a data hierarchy. AJAX   AJAX or " Asynchronous JavaScript
Read more

Introduction to Computing Blog

Image
TECHNOLOGY           You can't deny the existence of technology and the fact that it truly improved the way of lifestyle for everyone, despite the downsides and negative effects it holds on the younger generation like gaming addictions.           Looking at the brighter side of the spectrum technology has helped humanity progress in a fast rate, new devices are being produced and sold to the public, advance computers, electrical cars, sophisticated gadgets and so much more helps entertain and assist us in our tasks almost everyday. MUSIC & ENTERTAINMENT           Music and overall entertainment had a huge effect on the lives of people, it keeps us motivated, happy and stable, without it people and society would look and feel a lot different in a more sad and monotone way, devoid of emotion and filled with negativity.            It really is a medium that we as individuals seek to help ease the everyday frustration and sadness we face, in a life of hardship and pain, that is wh
Read more

Activity Quiz (BLOGPOST#3)

Image
a.) If you will become a computer parts/gadgets or any ICT tools, what will you be and why? -  If I were to become an ICT tool, I prefer to be a digital camera, so I see beautiful and amazing sceneries and help users capture and store them, I can be useful in many aspects, taking photos for artistic and business purposes, I'll also be available and easy to use by everyone for their entertainment and hobbies, I can also help preserve memorable moments that are important to the users, so they can always remember the good old days and look forward to more memories to capture in the future. b.) What is the use of computer in your day to day activity? - I use my laptop mostly for my own entertainment, I either play online/offline games, and watch different types of videos varying in content on youtube, or browse the chrome for a website where I can watch anime and read mangas for a whole day. I also use my laptop for other reasons, such as research and educational purposes, not only th
Read more