Enhanced Design of a Rule Based Engine Implemented using Structured Query Language

Abstract —Rule Based Systems belong to a well established branch of Artificial Intelligence. So far thousands of rule based systems and their related systems have been built and successfully used. Recently a Rule Based Engine has been successfully designed and developed using Structured Query Language, and applied in Medical Claim processing domain. The rule engine has been integrated with medical billing software to identify billing errors in medical claims at real-time. Performance of the engine has been good, giving promising results. To further improve the efficiency of the system and to utilize power of rule based systems’ techniques, enhancements in the existing rule based engine are being proposed in this research paper. Besides explaining the design of new rule based engine, this paper also reviews the design of current engine, which is already in operation, and the overall architecture of the whole system. Enhanced rule engine being proposed here can be implemented in any domain which involves large number of knowledge oriented checks, and in which frequent modification or updating of these checks is required. This research work proposes a new frame work of rule based systems related to relational database environment (i.e. Structured Query Language), and can have great impact on business world where large amount of data is stored in relational format.

[1]  Aftab Ahmed,et al.  Design of a Rule Based System Using Structured Query Language , 2009, 2009 Eighth IEEE International Conference on Dependable, Autonomic and Secure Computing.

[2]  Luc De Raedt,et al.  A perspective on inductive databases , 2002, SKDD.

[3]  Theresa Hazen Scrubbing Reimbursement Rates clean. , 2008, Health management technology.

[4]  G. W. Stewart,et al.  An Expert System for PostOperative Care (POEMS) , 1992 .

[5]  Ahmed Aftab,et al.  Comparative Study of Medical Claim Scrubber And A Rule Based System , 2009, 2009 International Conference on Information Engineering and Computer Science.

[6]  Jennifer Widom,et al.  An overview of production rules in database systems , 1993, The Knowledge Engineering Review.

[7]  Tom M. Mitchell,et al.  LEAP: A Learning Apprentice for VLSI Design , 1985, IJCAI.

[8]  Peter Scheuermann,et al.  Active Database Systems , 2008, Wiley Encyclopedia of Computer Science and Engineering.

[9]  Anju Vyas Print , 2003 .

[10]  Aftab Ahmed,et al.  Software Architecture of a Learning Apprentice System in Medical Billing , 2010 .

[11]  Mohammad Jamil Sawar,et al.  Learning apprentice system for turbine modelling , 1990, IEA/AIE.

[12]  Pedro A. Ortega,et al.  A Medical Claim Fraud/Abuse Detection System based on Data Mining: A Case Study in Chile , 2006, DMIN.

[13]  Herbert A. Simon,et al.  Applications of machine learning and rule induction , 1995, CACM.

[14]  Frederick Hayes-Roth,et al.  Rule-based systems , 1985, CACM.

[15]  Jack Minker,et al.  Logic and Databases: A Deductive Approach , 1984, CSUR.