D(Bea)uty of databases

As we all know, the purpose of having database is to save/store and manage our information. When we say storing and managing information, there is yet another way of doing that. Yes, you are correct. File system. Both File System and Databases offer some basic features in common:

1. Ensuring data integrity and data quality
2. Shared access by a community of users
3. Well defined schema for data access
4. Support a query language

But in some way or the other, databases offer extra features compared to file system that makes people like us to go for databases even though it incurs additional cost.

1. Indexing - Very useful for searching data (still improper use
will lead to inefficiency)
2. Relational view of data - This is the main feature that distinguishes databases
from file system. This point will be explored in much
details in forth coming posts

These two points make up our mind to go for databases rather than file system.

Also, in databases, the data are stored in a much organized manner. This in turn makes data retrieval easier. Data retrieval is made much easier in other ways like, it is not needed to read unwanted data in the process of getting a required data. But, this is not possible in a file system.

Now, I think we have got an overview of storing, managing data and the two ways of doing that (File system, databases) and the advantages of databases over file system. Let us explore more into databases in the forth coming posts.
Thanks for reading. Happy blogging.

Welcome Message !

Hi all. Welcome to the blog 'Databases'. Here, I am trying to post all my thoughts on the databases that are available in this world viz., Sybase, MS SQL Server, Oracle. My primary focus will be on these three databases although we have got many other databases around us. Then and there I will be touching other databases also when it is required. Once again I welcome you all to the blog of 'Databases'. Happy blogging !