×
>
<

Aptitude

Introduction to DBMS

What is Data ?

In computer science or DBMS, data is an efficient model of information, which is stored in a format that is highly efficient for movement over various networks.

It can be internal networks of the computer itself(i.e local movement in storage disk of a computer) or global movement via the internet.

Data is generally a raw format of any information. It may be text information or any rich formatted information.

What is Database ?
The database is a collection of related data, organized in a structured and meaningful way. For computers, having the data stored in a way that is allowed faster –

  • Storage(entry)
  • Access
  • Update
  • Manipulation

Is also important than just having meaningfully sorted and stored. Consider this, there is a phonebook directory, with 1 million + business contacts in your city and the entry is done randomly.

To view this large data, you need to have the name of the business, phone numbers, addresses arranged together in an alphabetical format. Then only it will be called a databases of numbers right?

This is what Database is a most efficient and structured way of storing information together so various operations like entry, addition, updation and manipulation are very easy, along with the view format as well.

Databases in early systems

The databases in early systems were stored on tapes, which were read only format, which means once you store data. It is impossible to delete or update or even add any new data on it easily.

Which is why the father of database system, Founder of Oracle, Larry Ellison found the need to a fully managed database system and launched oracle in the market.

What is Database Management System?

The database management system is software that controls all the different manipulation of stored or to be stored data in a database. It allows the creation, update, manipulation, definition of a database.

As clear from the name it manages the whole database end to end for whatever operation that may be required. Some examples of DBMS are –

  • SQL
  • mySQL
  • noSQL
  • Oracle
  • IBM DB2
  • PostgreSQL
  • MongoDB

A database management system perform the following –

  • Database Definition
  • Data Updation
  • Data Retrieval
  • Administration
  • Security

Database Definition :-

This essentially defines how data is defined in the database. For example we have to create a database for students are PrepInsta users.

We will define the data as follows –

  • Unique ID of signed up user
  • Unique email ID of signed up user
  • First Name
  • Last Name
  • Passwords etc

Data Manipulation Techniques

This majorly allows various operations like insertion of the new data, updating new data, deletion of data in the various database tables.

  • Insertion – Inserting information of new user signed up on PrepInsta website
  • Updation – Updating the password of the user who requested to change it
  • Deletion – Deleting the complete or partial data of the user who has requested account deletion on PrepInsta.

Data Retrival

The data is stored in various database servers and stored globally. For different instances like requesting login authentication details for a website. You need to communicate and retrieve a lot of data from database tables.

Adminstration

  • Database Administrator – Who call perform all actions like modification, deletion, updation and creation etc.
  • Database Manager – Who can define, update, modify but can’t delete
  • Database Editor – Who can just retrieve and insert in the database

Security

The security of the system is also important. You don’t want hackers to steal your confidential database or maybe update your database with false data. Thus for any access to database node. There is an authentication that happens along.