Can you please provide advice on big data handling strategy?

Help! Algorithm
38

With regards to using SWI-Prolog with SQL databases these might be of use:
Wiki Discussion: Prolog in the mind set of SQL
SWI-Prolog connecting to PostgreSQL via ODBC