"So we already know about what a Database is, how it works and how it stores data in a Systematic way! NO, definitely not but we do know the basic idea of what database is."
Why database?? Why do we actually need them to store data in an interrelated format while we can do it simple in a format like in a FILE. We all know how file handling works in C or any other language, if not I'll definitely request an article about this. Now suppose we have a class of 100 students we need to store data about the name, roll no, marks, etc. it would great to store Data in file and we can always use the file which follows a definite format like lets say, XML. Yeah that sounds cool. Lets see example of such system.
This method looks cool and is pretty much self-explainatory but imagine this now the only information you wanna keep track of. You might need files for Fee Payment details and other kind of stuff. Taking it to the larger level forces you to create more files in a scattered manner which follow different format and if you want to use it in another application it might be difficult. This is called data "Data Isolation" in which data that is about exact same thing (in this case the student) is not related and completely isolated from each other.
Another thing you might wanna avoid is the "redundancy" of data, for example you may accidently add details about same student for more than one time.
Your file system may have dependency with some other application and changing it might lead to difficulty in the dependencies.
Looking at these problems we may imagine how difficult it would become when we are managing a very big company, where we have thousands of employee and a whole bunch of data about them. This is how Database comes into play. All these problems can be reduced to zero using Database. How?? we'll see! ;-)
Before we get to the database here's a comparison between File system and Database:-
Datbase Management System
No Data redundancy
Data may be redundant
Data Consistency and Integrity
Data may be inconsistent and may lack Integrity
Privacy: Data is secure
Privacy not maintained
Easy access to data
Difficulty in accessing the data
Data is recoverable
Data is non recoverable
Secure: Each user has different sets of access
You might be worried about the Terminology used. We will see all those big words in the next blog...