CreativeHub

09 April, 2019

DATABASE MANAGEMENT SYSTEMS – LECTURE 1

Hi, Welcome to the CreativeHub learning session number one. Throughout this session,  we are mainly focusing on Database Management System.

Before we start the session, you should understand the basic concepts of the Database management system. First of all, the meaning of the Database is “a collection of related data”.

DBMS was designed to solve the fundamental problems associated with storing, managing, accessing, securing and auditing data in traditional file systems. Traditional database applications were developed on top of the databases, which led to challenges such as data redundancy, isolation, integrity constraints and difficulty in managing data access.

 A layer of abstraction was required between users or apps and the databases at a physical and logical level.

For data-driven business organizations, DBMS can turn into extremely complex technology solutions that may require dedicated resources and in-house expertise.

The size, cost, and performance of a DBMS varies with the system architecture and use cases, and should, therefore, be evaluated accordingly.

 Also, a DBMS failure can incur significant losses to organizations that fail to maintain optimal functionality of a DBMS system

These are some of the advantages of approaching to a database system:

·        Data Independence

·        Efficient data

·        Enforcing Integrity

·        Restricting unauthorized access

·        Providing backup and recovery

·        Concurrent access