While most academics would suggest Prolog I would say that it depends on the IT infrastructure that you are going to deploy such system and the requirement for coupling with existing systems.

I would also recommend that if you are going to do program such a system for large scale production you should optimize as much as possible.A simlple suggestion is to use hashes and use fast string matching to reduce lookup time(some Prolog implementations use these but you must check to see if the selected Prolog engine does so).

 Dear Umair,

I am totally agree with the previous answer. Prolog may be suitable most of the cases but still I will say it totally depends on the infrastructure and the requirements: functional as well as non-functional. So I will suggest you for depth requirement analysis before choosing any particular language.

Can I use Structured Query Language (SQL) for development of a practical rule based system?

It is possible to store facts in

a database's tables. But where should

be the rules?

For example: if a is part of b and b is

part of c, then a is part of c.

How would you do that in SQL? It is possible

to have a is_part_of table in the database

but relatively cumbersome to write a

stored procedure to process that, say in

Transact-SQL. On the other hand, a rule-based

system should come along with a simple

language in which new rules can be entered

whereas the inference engine is hidden from

the users. Rules should be part of the

knowledge base, not part of the

software that is distributed.

Regards,

Joachim

Dear Jaochim,

Thank you for your good detailed response.

This is what exactly I have done. 

Can you have a look at my following conference paper and the book chapter and give your valuable comments.

https://www.researchgate.net/profile/Umair_Abdullah/publication/220716281_Design_of_a_Rule_Based_System_Using_Structured_Query_Language/links/00b4953b3b796964cc000000.pdf 

https://books.google.com.pk/books?hl=en&lr=&id=PnxRCgAAQBAJ&oi=fnd&pg=PA260&ots=gcx8UDuTZJ&sig=oPFV1nPgoMhJ-CJXyKvGccPvoqo#v=onepage&q&f=false

Best Regards,

Umair Abdullah

Conference Paper Design of a Rule Based System Using Structured Query Language

I have used Prolog during my undergraduate and postgraduate. It is a good learning language but not really practical. Based on my understanding of how prolog works, I rewrote the functionalities in C in a real system.

as per my conclusion Prolog System or Engine will be better