Posted by: ahmedashfaque | February 4, 2016

Relational databases – the power of atomizing & relationships – part2

In the first part of this series, we saw that atomizing data is powerful. We saw that we can do many things with our data saved in a Microsoft excel file. But if a Microsoft excel file can be linked to some other Microsoft excel file so that we can establish relationships among data saved in those files? If we can do that then we will be able to solve one problem. Let us discuss the issues in this post.

Modern software products are built to have thousands and even millions of users. Naturally such systems will generate billions of pieces of data on a daily basis. All this generated pieces of data needs to be stored in a database. At the same time all this data should be available easily and quickly for many purposes. For example these pieces of data are needed to generate reports for various purposes. Similarly many people need to have a quick search facility to find out things like how many customer orders contain same product orders over a specific period of time so that back office work can be carried out smoothly. Or if a product part exists in the store so that it can be used in the assembly department.

Coming back to our discussion on saved data in a Microsoft excel file. If we can save all our generated data (which could be in tune of billions of pieces of data) in an excel file? Not possible because an excel file can store not more than say 50,000 pieces of data. Opening and using the excel file containing large amount of data will be also extremely slow. Saving all these pieces of data in many excel files also poses problems. It is difficult to relate data which are saved over many excel files. Essentially this means that excel files are not relational.

The best solution to store large amounts of data is the relational databases.

We will be learning about relational databases in our next post.




  1. […] the previous post in this series, we saw the limitations of Microsoft excel files for storing our data. Storing of billions of […]

  2. Thanks for sharing this information. It was very nice blog to learn about SAP MM.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


%d bloggers like this: