Database and its need-DBMS (BA/BSC_IT/BCA/MSC_IT/MCA/MBA/PGDCA)
Database and its need
What is Data?
Data is a collection of a distinct unit of information. This “data” is used in a variety of forms of text, numbers, media and many more. Talking in terms of computing. Data is basically information that can be translated into a particular form for efficient movement and processing.
What is a Database?
The database is an organized collection of structured data to make it easily accessible, manageable and update. In simple words, you can say, a database in a place where the data is stored. The best analogy is the library. The library contains a huge collection of books of different genres, here the library is database and books are the data.
In layman terms, consider your school registry. All the details of the students are entered in a single file. You get the details regarding the students in this file. This is called a Database where you can access the information of any student.
The major components of the Database are:
This consists of a set of physical electronic devices such as I/O devices, storage devices and many more. It also provides an interface between computers and real-world systems.
This is the set of programs that are used to control and manage the overall Database. It also includes the DBMS software itself. The Operating System, the network software being used to share the data among the users, the application programs used to access data in the DBMS.
Database Management System collects, stores, processes, and accesses data. The Database holds both the actual or operational data and the metadata.
These are the rules and instructions on how to use the Database in order to design and run the DBMS, to guide the users that operate and manage it.
Database Access Language
It is used to access the data to and from the database. In order to enter new data, updating, or retrieving requires data from databases. You can write a set of appropriate commands in the database access language, submit these to the DBMS, which then processes the data and generates it, displays a set of results into a user-readable form.
There are a few types that are very important and popular.
- Relational Database
- Object-Oriented Database
- Distributed Database
- NoSQL Database
- Graph Database
- Cloud Database
- Centralization Database
- Operational Database
Database Management System (DBMS)
A Database Management System (DBMS) is a software that is used to manage the Database. It receives instruction from a Database Administrator (DBA) and accordingly instructs the system to make the corresponding changes. These commands are used to load, retrieve or modify existing data from the system.
- Reduced data redundancy.
- Also, there is reduced updating errors and increased consistency.
- Easier data integrity from application programs.
- Improved data access to users through the use of host and query languages.
- Data security is also improved.
- Reduced data entry, storage, and retrieval costs.
- Facilitated development of new applications program
- Complexity: Databases are complex hardware and software systems.
- Cost: It requires significant upfront and ongoing financial resources.
- Security: Most leading companies need to know that their Database systems can securely store data, including sensitive employee and customer information.
- Compatibility: There is a risk that a DBMS might not be compatible with a company’s operational requirements.
References: SQLStudy, Techguru