The simple analysis of the leaking QQ group database (QQ database. 7z.001-006)

I am a whim, online down QQ leaked group database.

Compressed file, total 24.5GB, after decompression 90+g.

Contains two pieces of information: Group Information + Group member information

Mount part of a database

Group information-1, the group information data uses the sub-database table to deal with the continuous growth of data information, scalability is not a problem. A library contains 10 tables with a maximum data volume of about 100W per table.

Group Information-2, contains only basic information, group number, Title, description

Group member Information-1, also using a sub-database table, a library corresponding to 100 tables.

Group member Information-2, contains only simple group correspondence, no leaks such as passwords.

1. The database is a version of SQL Server 2000, and the author successfully installed SQL Server 2000 on Windows R2. Is it true that a giant now uses SQL Server 2000 as a database server?

2. The above data can query the group information, according to the description of fuzzy search. Because it was 2011 ago data, many groups no longer exist, the author lamented how many people can persist in a certain cause for a long time?

You can find out which members are in a group.

Can check a QQ number added to which groups;

No other basic information can be found too useful.

I see a lot of Taobao shopkeeper's 2002 years or so to create QQ group, their shop is a gold crown, the envy.

3. Network transmission of the above information from 2011 years of vulnerability, that is, data leakage 2 years or so after the fault, most of the leaked data should be leaked after a period of time before the outflow.

4. What is the commercial value of the above data? Precise targeting marketing? It's not easy to analyze so much data. In addition to the precise positioning of marketing, the rest is to meet a similar desire to spy, look at the past 10 years QQ Group development process.

Not sure whether the above data has been modified, or whether the above table structure is the table structure under the production environment, a friend with big data business can refer to the above database design scheme slightly.