Hello Viewer! How are you I hope you well? In the previous lesson, we learned Types Of Operating System. in this lesson, we'll learn Basic Information Related to Database and DBMS
Today I'll discuss Some basic of DataBase. So 1st What is data?
In simple word, data can be facts related to any object in consideration. For example- Your GF/BF name, Your Ex Name, Your weight, etc are some data related to you.
A picture, file, videos, pdf etc can also be considered as data.
Database?
Database is the systematic collection of data. database support strong and manipulation of data. database make data management easy. also,
A database is a collection of data that is organized in a manner as well as efficient management and updating.
The database always forms table.
In any database more than one table.
understand with an example
A College would definitely use the database to store data of student such as name, roll no, address etc.
let's also consider the facebook also use the database to store data of user such as email, password, friends, message, advertising and more.
Data Base Management System ( DBMS )?
DBMS is a software used to manage or accessed data from database in an efficient way.
example:
ORACLE, DB2, Microsoft Access, Microsoft SQL Server, My SQL etc.
Application :
Banking, Airlines, Universities, Credit Card & Transaction, telecommunication etc.
Before Coming of the database, any company used file processing to store its data, which is not as good In File processing lot of problems like...
Main disadvantage of Redundancy is waste of storage.
Multiple file formats, duplication of information in different files.
Hard to add new constraint or change existing ones.
Example:
Transfer of funds from one account to another should either complete or not happen at all.
These are the problem in FILE PROCESSING. DATABASE System offer solution to all the above problem
Function of DBMS
A DBMS makes it possible for users to create, edit and update in database files. Once created, the DBMS makes it possible to store and retrieve data from these databases.
In this part enough 4 Today. I hope you like it. we'll discuss more in future post.
Today I'll discuss Some basic of DataBase. So 1st What is data?
In simple word, data can be facts related to any object in consideration. For example- Your GF/BF name, Your Ex Name, Your weight, etc are some data related to you.
A picture, file, videos, pdf etc can also be considered as data.
Database?
Database is the systematic collection of data. database support strong and manipulation of data. database make data management easy. also,
A database is a collection of data that is organized in a manner as well as efficient management and updating.
The database always forms table.
In any database more than one table.
understand with an example
A College would definitely use the database to store data of student such as name, roll no, address etc.
let's also consider the facebook also use the database to store data of user such as email, password, friends, message, advertising and more.
Data Base Management System ( DBMS )?
DBMS is a software used to manage or accessed data from database in an efficient way.
example:
ORACLE, DB2, Microsoft Access, Microsoft SQL Server, My SQL etc.
Application :
Banking, Airlines, Universities, Credit Card & Transaction, telecommunication etc.
Before Coming of the database, any company used file processing to store its data, which is not as good In File processing lot of problems like...
- Data Redundancy and Inconsistency -
Main disadvantage of Redundancy is waste of storage.
Multiple file formats, duplication of information in different files.
- Difficulty in accessing data
- Data Isolation
- Integrity Problems
Hard to add new constraint or change existing ones.
- Automaticity of Updates
Example:
Transfer of funds from one account to another should either complete or not happen at all.
- Security Problems
These are the problem in FILE PROCESSING. DATABASE System offer solution to all the above problem
Function of DBMS
A DBMS makes it possible for users to create, edit and update in database files. Once created, the DBMS makes it possible to store and retrieve data from these databases.
- Concurrency
- Security
- Backup & Recovery
- Integrity
- Data Description
In this part enough 4 Today. I hope you like it. we'll discuss more in future post.
Thank You 4 reading my blog! if you have any problem or issue with this post please comment/contact.