What is Database

What is Database?

For understanding a Database, Let's see what is a Data.
A Data is an any kind of information. For eg: the data of a person is his/her height, weight, gender etc. 
In the same way a Database can be defined as a systematic collection of data which supports electronic storage and manipulation of data.
To give an example of a database a telephone directory is the best ex. So, in that stays all the details of a person. Wright! 
In a relational database stays the details of a person in rows and columns & tables which make it easier to find with SQL & NOSQL queries .
As of this writing SPARQL is the only querry accepted by the World Wide Web or simply the (www).


Types of DATABASE. 

Databases have evolved with time . Earlier in the late 1980s it was with Object-Oriented Database and today with SQL & NOSQL & CLOUD DATABASE. 

Relational Database.

A Relational Database , invented in the IBM by Sir E.F.Codd in 1970 so that it can be accessed & recognised in a no. of different ways.
Relational database, made up of a set of tables with data that fits to the defined category. 

What is SQL?

SQL stands for the Structured Querry Language which is related to the relational database. SQL can be used to insert, search, update, and delete database records. SQL can do lots of other operations, including optimizing and maintenance of databases. SQL is also pronounced as See-Quel Relational databases like MySQL Database, Oracle, MS SQL Server, Sybase, etc. use ANSI SQL.

What is a Database Management System (DBMS)?


Database Management System (DBMS) is a collection of programs which enables its users to access database, manipulate data, reporting and representation of data. It also helps to control access to the database. Database Management Systems are not a new concept and as such, had been first implemented in the 1960s.

Charles Bachman's Integrated Data Store (IDS) is said to be the first DBMS in history. With time database technologies evolved a lot while usage and expected functionalities of databases have been increased immensely.


Types of DBMS

There are 4 major types of DBMS. Let us investigate them in detail.

  • Hierarchical: This type of DBMS employs the "parent-child" relationship of storing data. This type of DBMS is rarely used nowadays. Its structure is like a tree with nodes representing records and branches representing fields. The windows registry used in Windows XP is an example of a hierarchical database. Configuration settings are stored as tree structures with nodes.
  • Network DBMS: This type of DBMS supports many-to-many relations. It usually results in complex database structures. RDM Server is an example of a database management system that implements the network model.
  • Relational DBMS: This type of DBMS defines database relationships in the form of tables, also known as relations. Unlike network DBMS, RDBMS does not support many to many relationships. Relational DBMS usually have pre-defined data types that they can support. It is the most popular DBMS type in the market. Examples of relational database management systems include MySQL, Oracle, and Microsoft SQL Server database.

                                                    -Thank You
                        Do follow on instagram: @swapnoneel1232004.
                
                     Stay Safe & Stay Secure.
                                     
            All The Best!

Comments

Post a Comment

If you have any doubt or want to know something more or new,you are most welcome. Just let me know.

Popular posts from this blog

Cryptography in Cyber Security

Image
Crtpt - stands for hidden & graphy  - stands for writing. It is the process of protecting or securing a data or information with the help of codes.  Yes, the data gets stored in the form of codes such as : " 8b1a9953c4611296a827abf8c47804d7" Can you guess the actual word ? It's ' Hello'  similarly " 64ef07ce3e4b420c334227eecb3b3f4c " is the code or the hash for " Cryptography ". This technique is derived from some mathematical concepts . This process of crypting texts or the plain texts  into cipher text or the crypted text   is called Cryptography. If I give an example of Cryptography then WhatsApp will be the best to explain. Did you ever notice that after writing the first text to a person in WhatsApp at the top the message appears as "End-to-end encrypted". Hence it ensures you that " now your message is encrypted and is totally saved securely" , but in time when needed it can also be decrypted too.  This process of ...
Read more

What is SQL?

Image
SQL stands for  Structured Query Language also called See- Quel. This is a domain specific language used for programming and designed for managing data held in the relational database management system or simply the ( RDBMS ) and also for the stream processing in a Relational Database Management System or ,(RDBSMS). It is used for handling Structured Data. SQL consists of many types of statements which can be informally classed as Sublanguages : A Data Query Language, A Data Definition Language, A Data Control Language, and A Data Manipulation Language. The scope of SQL includes Data Query, Data Definition, Data Acess Control. SQL is a Declarative Language, it also includes procedural Elements.  The first relational language to be utilized in E.F.Codd's relational model was SQL. That model was described in his influential paper of the late 1970's.  Although it was not entirely adhered to the relational model described by E.F.Codd , it became the most widely used DATA...
Read more

What are VPNs?

    VPN stands for  Virtual Private Network . A VPN provides a secure & protected connection when connected to a network. It encrypts all the datas & disguise us with absolutely under a different identity with a different IP (Internet Protocol) address & Location. The encryption happens in  "Real Time".  It makes tracking parties more difficult to track you....   How  does a VPN  work? A VPN connection disguises your data traffic online and protects it from external access. Unencrypted data can be viewed by anyone who has network access and wants to see it. With a VPN, hackers and cyber criminals can’t decipher this data. Encryption:  To read the data, you need an  encryption key  . Without one, it would take millions of years for a computer to decipher the code in the event of a bruteforce attack. With the help of a VPN, your online activities are hidden even on public networks. Secure Data Transfer : If you work remote...
Read more