What is database

What is databaseWhat is database

What is database

What is database

In today’s article, we will know what is Database? What is database in hindi. But what is Data before? Little is known about this. Data is information that is processed and stored by a computer or other device. This information can be any text document, image, video, audio or any other type of data. If you give an example of computer data in easy words, then whatever things are stored in the file and folders of your computer, they are called data in computer language.

 

Similarly, when we store a company’s employee records (which is a type of data) in the computer as row and column, it is called DATABASE. Let us now tell you in a bit more detail in the context of database, so what do you mean by database? Understand it well So let’s start losing time.

Table of contents

What is Database

A database is an organized collection of structured information. In simple words, a systematic collection of data is called a “Database”. That is because it is made very organized. So that the data can be easily accessed, managed and updated. The basic function of database is to make data management easy.

Let’s understand with an example, suppose a university has to prepare a student record of its students. In which he has to write all the information of every student’s name, class, subject and parents name in a big register with him, so that he can easily get information about a student. So for this, he will write rows, columns, tables in the register number wise in an orderly manner so that he can easily find the information further.

 

Now if we store this file in a computer by writing this student record in table, column and row in exactly the same way, then it is called database. When a data is written in this way, it is called tebular data. DBMS Software is used to create databases in computers. With the help of these software, we can delete, change, and add store information in the database anytime.

These computerized databases started in the 1960s. Two popular database models in this decade were Network model (CODASYL) and Hierarchical model (IMS). So let’s know about DBMS now.

What is Database Managment System (DBMS)

DBMS or database management system is a software, which allows us to create data, data store and data update in database. Due to which the user can store, access and analyze data very easily. Dbms provides an interface or tool for this.

The DBMS manages three important things.

  • Database engine – which access, lock and modify data.
  • Datatabase schema – This defines the logical structure of the database.
  • Data

Some Examples of DBMS

Some examples of DBMS Software are given below.

1) MySQL

MySQL was started in 1995 by Oracle. It is an open-source Relational database management system (RDBMS). It is based on structure query language (SQL). It supports almost all operating systems. MySQL is highly acclaimed due to its high reliability, reliability and cost. It also has LAMP technology along with Linux, PHP and Apache.

2) MS Fox Pro

Fox Pro is a dbms, started by fox software. But right now it is under the protection of microsoft. Apart from being a database management system, it is also text related oriented programming language. Fox pro is a powerful database managment system as well as Relational database managment system (RDBMS). Because it extensively supports multiple relationships between many DBF files.

3) Microsoft Access

MS Access is a database management system (DBMS) operated by Microsoft, which combines the Relational microsoft jet database engine with a graphical user interface and software development tool. It is a member of the Microsoft Office suite of applications included in commercial and higher versions. It is used for both small and large database development.

4) Oracle

Oracle database is a Relational dbms. It is maintained by Oracle corporation. This is the first database, designed for enterprises grid computing. It is the fourth generation of RDBMS. It is mostly used by big companies. Who need to manage large amounts of data.

5) SQL Server

What is SQL Server? The SQL server developed by Microsoft is RDBMS, used to create computer databases for MS-Windoes. MS SQL Server creates databases, which can be accessed via workstation and internet. It was created to perform compitition from oracle database and MySQL. It is a full-featured database.

Types of DBMS

There are several types of database management systems (dbms). Below we are sharing with you five types of database managment system.

  1. Hierarchical database
  2. Relational database
  3. Network database
  4. Object oriented database
  5. Document database

Hierarchical Database

In a hierarchical model, data is represented in a tree structure. It can have a single parent and many children for each record. For example, if we take the example of a university, many students study in it. They have different subjects and classes. In this case the university is a parent and the student and others are its children. This type of model structure allows one-to-one and one-to-many relationships between two different types of data. This hierarchical model was introduced by IBM in the 1960s.

Hierarchical Database Model

Relational Database

The relational database is a collective set of several data sets. Which is represented by table, record and column. In this tubular form, each column represents one attribute for each row, record and each field represents the data value. The standard user and application programming interface (API) of the relational database is a structured query language (SQL). SQL is used to collect data from RDB for interactive queries for information and for reports. It is the most popular and most used database. We can also use it with a little training.

Relational Database Model

Network Database

A Network database is a database model that allows multiple records to be linked to a single owner. This model is also seen as the structure of the inverted tree. A network database uses a network structure to make connections between entities. It is mainly used on digital computer. Network database and hierarchical database are exactly the same. But a node of hierarchical database can have only one parent, the same network node can have relationships with many entities. In the network database, the child is called member and parents are occupier.

Network Database Model

Object Oriented Database

It represents data in the form of database objects and classes. In an object oriented database (OODB), the object is called a real-world entity and class is a collection of objects. It follows the basic principles of object-oriented programming (OOP). This database is optional for system relational database and other database systems. In an object oriented database, information is displayed as an object.

Document Database

Document database (DDB) is a NoSQL database. It stores the data as a document. It has become very popular due to its Document storage and NoSQL properties. NoSQL data storage provides a faster mechanism to store and search documents. The document stores database data in key value form.

Components of DBMS

The database management system has five main components.

  1. Hardware

Although it is not originally a component of dbms, now because data is stored in these computer hardware (hard disk, RAM). So in a way hardware also becomes part of this system. When we run dbms software, Oracle and MySQL on our computer, our computer’s hard disk, RAM, ROM, even our keyboard from which we type commands, it all becomes part of DBMS hardware.

  1. Software

DBMS Software is the most important component. Because that is what gives us the interface to data store, access and update. This is the program that controls everything. It is able to understand the Access language and interpret it in real database commands to execute them in the database.

  1. Data

Data means the material you are about to store. For which dbms is designed. This data can be text document, video clip, image or other type of data. The reason for creating DBMS was to store data and use data.

  1. Procedures

Procedures in Hindi means procedures. DBMS Software is setup, install, login & logout and take backup etc. under these procedures.

  1. Database Access Language

DBAL is a simple language through which we write commands. These commands are used to store, access, delete and update data in the database. A user can write a command in database access language and apply it to dbms for execution. After which the data is translated and executed by dbms.

  1. User

There are three types of users under it. The first Database administrator or DBA who manages the database managment system and also takes care of its security. Another programmer that develops and designs parts of dbms. Third End user who works to store, retrieve, update and delete data.

What is Importance of Database

Database is important, because only through this can the data be managed correctly and systematically. With this, it also gives the user the permission to do many tasks. Database managment system (DBMS) can manage and organize large amounts of information within a single software application. Due to which the efficiency of business operations increases and the time cost is reduced.

With this, the database management system has greatly benefited the business and large organization. Because they use it to store many types of data. Today we use this system to manage data of type employee records, accounting, library books, student information, project management and inventory etc.

When we manually perform such a task manually, it takes more time than the database. Rather once a record has been made, then you cannot change it easily and it cannot be accessed by everyone. In contrast, the data stored in the database can be accessed by any other user. So overall today

Database is very important, without it data management is very difficult and time consuming task.

Conclusion

In this post you know what is Database? What is database in hindi. I hope you got introduced to the database after reading this post. We know that this post is a bit long but it has an advantage, you got the complete information of the database in just one post. If you do not like to read long posts, then click on the topic of the topic you want to know about. In the end, if you have any important question or suggestion related to the database, then we will definitely reply to your comment through the comment below.

If you find this information informative about the database, then definitely share it with your classmates and friends. Thank you.

 

komal mishra: