mercredi 27 mai 2015

A suitable free database platform for one huge table

I'm looking for the database platform that best fits my needs.

I'll use one of free web hosting providers for my project so probably my options SQLite, MySQL, PostgreSQL, or anything else, usually free of charge.

The database contains one very large read-only data table - about 700 billion records. Results of some academic mathematical research.

I'm going to connect it to single web page, which contains a simple search engine.

The table record structure is: GroupId(int)| RecordId(long long)| Property#1(int)| Pr#2(bool)| ... | Pr#14(bool) 254 10148665654 12555 1 1 "GroupId" range 1..80000. "RecordId" unique in each group from 1..100000000000 (1E11). Property #1 - integer. Other properties - boolean.

My search engine should provide a complete list or/and summary of "GroupId"s and "RecordId"s according to a combination of properties entered by the user.

Some records may have (rarely) the same combination of properties.

I don't expect many connections to the web site. May be one in decade :))) I am ready to change the structure of the table if needed. But I do want response from the database to the queries in some reasonable time.

Thank you in advance for helping me to choose the right database system.

Aucun commentaire:

Enregistrer un commentaire