Comparison of WIPmania and MaxMind GeoIP Databases

    In connection with the alternative that appeared, MaxMind decided to compare how much these bases differ. It is precisely the differences that are compared, and not the correctness / incorrectness of the definition.

    Comparison

    1) The size of the bases. The MaxMind base is approximately twice as large as WIPmania (100k vs 50k)
    2) The number of IP addresses included in all ranges is almost the same there and there.
    3) Address ranges match 88%. (That is, start / end IP-addresses in the MaxMind and WIPmania databases)
    4) Of these 88%, only for 662 (1.2%) subnets the country is redefined.
    5) Next, the number of ip-addresses included in all subnets for the country.
    Country, IP maxmind, IP wipmania,% difference

    + ------ + ------------- + -------------- + -------- +
    | cc | maxmind_ips | wipmania_ips | diff |
    + ------ + ------------- + -------------- + -------- +
    | AZ | 157186 | 228845 | 0.31% |
    | BY | 334595 | 335737 | 0.00% |
    | EE | 1015116 | 1018665 | 0.00% |
    | KZ | 615802 | 612209 | -0.01% |
    | LT | 1943069 | 1970561 | 0.01% |
    | LV | 1349597 | 1390552 | 0.03% |
    | RU | 19126288 | 20374227 | 0.06% |
    | UA | 3748921 | 4148605 | 0.10% |
    + ------ + ------------- + -------------- + -------- +


    Tests.

    Compare how different WipMania data is from MaxMind for unequal ranges.
    The algorithm is as follows:
    a) we determine the country by the start and end ip in the WipMania database using the MaxMind database.
    b) get data of the form start_ip, end_ip, wipmania_cc, maxmind_start_cc, maxmind_end_cc
    c) select all subnets where maxmind_start_cc! = wipmania_cc OR maxmind_end_cc! = wipmania_cc
    The result is 2633 entries.
    e) in addition, they were not identified on the basis of GeoIP 1394.
    The difference is about 7%.

    Conclusions:
    1) Indeed, other methods were used to determine GeoIP.
    2) The relevance and accuracy of this data, as well as the data of any other geoip service, is difficult to establish.
    3) Good luck to the creators of the project, I’m glad that a good alternative to MaxMind has appeared.

    Also popular now: