Introduction of Database
What is Data?
What is Information?
- Data is a raw material.
- In other words, it is facts and figures which we can use as input for the process.
- We can not take any actions.
- Data can be categorized as...
- Numerical - includes only 0 to 9
- Alphabets - includes only A to Z or a to z.
- Others - includes symbols such as !@#$%^&*()_+}:<>?
What is Information?
- Information is a valuable data.
- In other words, it is a usable data which we can use as output for real usage.
- It is a processed or organized data.
- We can take any action.
What is Database?
- A database is one of the essential components for many applications.
- A Database is a collection of related data organized in a way that data can be easily accessed, managed and updated.
- Database can be software-based or hardware-based, with one purpose, storing data.
- It is used for storing a series of data.
- In other words, it is a group/package of information.
- There are different types of databases.
- Example:
- Video Databases
- Audio Databases
- Text Databases
- Image Databases
- Mixed Databases
- In a database, even the smallest portion of information becomes the data.
- Example:
- a Student is a data.
- a roll number is a data.
- the address is data.
- In brief, all the living and non-living objects in this world are data.
- Larry Ellison, the co-founder of Oracle was amongst the first few, who realized the need for a software-based Database Management System.
What is DBMS?
- DBMS stands for Data Base Management System.
- A DBMS is a software that allows creation, definition, and manipulation of databases, allowing users to store, process and analyze data easily.
- DBMS provides us with an interface or a tool, to perform various operations like creating databases, storing data in it, updating data, creating tables in the database and a lot more.
- DBMS also provides protection and security to the databases.
- It also maintains data consistency in case of multiple users.
- Example:
- MySql
- Oracle
- SQL Server
- IBM DB2
- PostgreSQL
- SQLite
- Amazon SimpleDB (cloud-based) etc.
Tags:
DBMS