Introduction To Databases : What is a database?

Introduction To Databases : What is a database?

what is a database? what is a DBMS? Purpose of a Database?

·

2 min read

what is database?

main-qimg-5a0d75511ee246a20fa11d79dfb5aad1.jpeg There are many definition of database in different articles and books but the main idea of a database is storage of a Data in a more effective way than the traditional methods.(eg. manual storage, file based storage).File storage, bl.jpg Databases are managed by DBMS (Database management systems) and DBMS is the main way to operate certain task mainly CRUD(Create Read Update Delete) on database.

what to expect when learning databases?

  1. how to organise a set of data.
  2. supporting multiple users.
  3. security and reliability of the data.
  4. maintaining consistency of the data.
  5. effective and efficient retrieval of the data.
  6. using the data for making precise and accurate decisions based on the data.

Purpose of Database Systems?

Purpose-of-Database-Management-System.jpg

  1. Data redundancy : The same information might be duplicated in several places causing redundancy. The redundancy may lead to data inconsistency meaning the various copies of the data may no longer be the same in value or type.
  2. Difficulty accessing certain data : Traditional methods of storing data have a very high risk of losing a certain data that might be related to the other sets of a particular data. thus causing ineffective way of data retrieval.
  3. Data Isolation : The data may not be in a format that can be easily retrievable. so coding a program to resolve the problem is a difficult task.
  4. Integrity problems : The data values stored in the database must satisfy certain types of consistency Constraints.
  5. Atomicity problems : When a certain task is run the requirements for that task must be met before that task operates the action.
  6. Concurrent-access Anomalies : maintaining consistent access through multiple user access is extremely difficult task to complete.
  7. Security problems : Security is one of the main reasons for the use of database System. mainly making certain data need authorisation to be accessed.

Summary

The main thing you need to take way from this article is that databases are managed by DBMS ( Database Management Systems ) and keep in mind the purpose of databases.