In this post, I will explain effective storage of IP-Address into Database System.
Now let’s talk about four part IP-Address.
Generally, many database developers or database designer store this IP-Address into one column which is VARCHAR(15).
What do you think? Is this effective storage of IP-Address?.
Now imagine you are playing with 10,0,00,00 online customers in which all this IP-Address of customer is required for analysis.
If we stored this IP-Address into one column, then you have to perform string manipulation for finding a particular range of IP-Address.
This kind of string operation is very costly and not advisable.
Effective storage of IP-Address is very simple:
Just divide your full length IP-Address into four part.
Full IP-Address : 220.127.116.11
Four Part :
Now create four tinyint/smallint column to store this four different part.
The full IP-Address split into four different integer part.
Now task is very easy:
You can also apply index on all this part and perform range analysis very easily.
Yes, I agree that during storage you require to split and store into four different columns, but this is only a one time process after that you can easily use different part for different analysis.
During select, you can also concat this four part and make full IP-Address for display purpose or application can perform concat operation.
This is about the best way to store IP-Address into database system.
Other Related Articles :
Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.
If you like this post, then please share it with others.
Please follow dbrnd.com, I will share my experience towards the success of Database Research and Development Activity.
I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.