Can you please provide advice on big data handling strategy?

[EricGT]

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