What is Database Management System Types and uses of DBMS.
Hello friends, what’s a database? what’s Database Management? Today we’ll study the database during this article. What are DBMS? sorts of management Systems? Usage of DBMS? then on.
what’s data? (What is Data?)
Before understanding a database, we’d like to understand what data is. Data may be a small a part of any information and raw facts. Data is raw facts that themselves haven’t any meaning but have value. Any number, text, letters, image, audio, video, etc. Data are often . When of these data are organized during a form, then these information are divided.
sorts of data? (Types of Data?)
allow us to understand what quite data are there? we will divide the info to be stored within the computer into the subsequent classes:
1 Numerical data.
It consists of numbers from 0 to 9 (Total 10). Arithmetic functions are often performed on numerical data. the amount of scholars during a class or their score in an exam is numerical data.
2 Alphabetic Data.
This data consists of all the letters of the alphabet. for instance , there are letters of English alphabet (A to Z) and letters of the Hindi alphabet (A to Z) etc. The address or name of scholars of a category is letter data.
3 Alpha numeric data.
This data consists of all numbers, alphabet, special characters and symbols. Arithmetic verbs can’t be used, but they will be compared. for instance , the address letters of scholars of a category are often numeric data.
4 Sound Data.
Sound data is data during which voice is present. all kinds of files stored during a computer that contain voice are called sound data. like – mp3 file, wav format file, etc.
5 Graphics Data.
Graphic data includes data stored within the sort of images, images, written images or graphs.
6 Video data.
Video data includes all kinds of moving pictures.
What’s a database? (What is Database?)
A database may be a group of the many data. Those are stored during a systematic manner in one place for a specific purpose.
Let’s understand the database with an example – MS Excel is employed to make some data. Like we create a table to make a knowledge in MS Excel and make many columns and rows and store the info in it consistent with need. Which makes our work easier.
What’s management System? (Whats is management System?)
We also call the management System DBMS briefly. If we understand DBMS in simple words, it’s a system during which data is managed.
Database management system provides many authorized users the power to share data and knowledge for various purposes.
Characteristics of DBMS.
The DBMS i.e. management system is capable of storing any sort of data. In management system, not only name and address data are often stored but also any sort of data present within the actual world.
Backup and Recovery.
Problems like database malfunctions can occur. In such a situation, if the info couldn’t be recovered, then there would definitely be loss. Therefore the database has the feature of backup and recovery.
Low data redundancy.
The management system follows the principles for storing any sort of data during a normal way, which reduces the likelihood of knowledge redundancy, ie duplication of knowledge .
Data Integrity and Security.
management enhances the standard and reliability of knowledge before it’s stored within the system. the safety of DBMS should be very high level so it prevents Unauthorized Access within the database and makes it safer .
Each value of the info stored within the management system must be independent of every other and self-sufficient in order that any program is in a position to freely use any a part of the info .
Privacy of knowledge.
to take care of the confidentiality of knowledge within the database, it’s determined who can view or modify which data to which extent. this is often how privacy of any important or personal data is ensured.
Data Inconsistency is that different values of an equivalent factor at different places within the database are called.
sorts of DBMS.
1 electronic database.
In this, the info is stored as a set of tables. These tables contain Rows and Columns. It makes it very easy to seek out data and it’s also called relational because the info stored in it’s some relation between all the tables.
2 Network Database.
during this sort of database model, data is stored as a set of records. These records are interlinked by links. Where does this sort of relationship attend many relationships? It also can have quite one parent of a toddler network.
3 Hierarchical Database.
during this also the info is stored as a set of records, but all the records are almost like the tree, so all the records are linked together during a tree like structure.
4 Object Oriented Database.
Data during a database is stored as an object during this sort of model. There are often differing types of relationships between two or more objects. Creating this sort of database requires object oriented programing language .
What are management system software?
☆ Microsoft SQL Server
☆ Microsoft Access
☆ IBM DB2
Where are management systems used?
☆ Railway reservation system
☆ Library management system
☆ School college university
☆ Social media sites
☆ Online shopping
☆ HR management, Etc.
Components of management system
Hardware is that the second component of management system. this suggests that each one sorts of hardware devices also are required to store data within the database. like – computer, memory device , input output device, etc.
User is that the third component of management system. it’s necessary to possess a user to store the info within the database, because it’s impossible to store any data without the user. Because the info where it’s stored may be a machine, the saw machines don’t work themselves. There are often three sorts of users within the user.
i Database Administrator.
ii Application Programmer.
Advantages of DBMS.
☆ Reduces data redundancy.
☆ DBMS supports Multi User Environment.
☆ Keeping data secure within the database is extremely easy.
☆ Database sharing is straightforward between Authorized Users.
☆ Secures data from Unauthorized Users.
☆ there’s confidentiality of knowledge in it.
☆ there’s no data consistency within the database.
☆ It also takes a really short time in application development.
Disadvantages of DBMS.
☆ Many stars like Database Administrator, Programmer, Operator are required. And it’s necessary to offer them an honest training for this.
☆ DBMS may be a very large software, so a high configuration system is required to run it correctly which may be very costly.
☆ In DBMS all data is stored within the same database hence the likelihood of Database Failure is high.
☆ Hardware and software are far more expensive.
So friends, now you’ve got learned what the database is? what’s management ? What are DBMS? sorts of Database Management Systems? Usage of DBMS? then on.