Using Prolog to make a prediction based on the data in a Relational Database

I have recently come across Prolog and I am amazed by it’s powers and capability. I was wondering whether it is possible for prolog to make a prediction based on data which is in SQL Server.


  • Insert different rows between Table A and Table B into Table B
  • Best way to store quarter and year in SQL Server?
  • Identity column skipping some values when adding a new row
  • “Debug”(get information) on a running stored procedure in MS Sql Server
  • SHOW ALL Dates data between two dates; if no row exists for particular date then show zero in all columns
  • SQL Server Management Studio – tips for improving the TSQL coding process
  • Day    Weather  Taken out Umbrella
    Monday Cloudy   Yes 
    Tuesday Sunny   No
    Wednesday Rain   Yes 
    Thursday  Sunny  No    

    Can Prolog use this data in the database and make a prediction

    One Solution collect form web for “Using Prolog to make a prediction based on the data in a Relational Database”

    Yes- you can train a classifier using a machine learning algorithm.
    Algorithms which work well in prolog are ones that make rule models.

    For example a decision tree or a rule learner such as ripper. chapter 18 is a good start. There is a LOT of literature on the subject 😉

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.