Title
Design of a Rule Based System Using Structured Query Language
Abstract
This paper describes successful implementation of a Rule Based System at MTBC, for applying billing compliance rules on medical claims. Rule engine has been developed in Structured Query Language as stored procedures, which is one of the unique features of this rule based system. Implementing rule engine in SQL has provided two major benefits. Firstly, as operational data of the organization is in relational form, stored in Microsoft SQL Server database, therefore rule engine, using the native language, works at real time without any need of data transformation for working memory. Secondly due to SQL server, rule engine is using interpreted approach instead of compiled approach, which helps dynamic updating, editing and execution of rules.A rule is represented as a query stored in database, along with associated attributes like rule name, rule description and rule priority. ‘where’ clause of query contains condition and then part of the rule. A rule editor has been developed to facilitate domain users to edit rules in English like format, which is then translated to SQL statements. Editing of business logic has become very easy in MTBC billing software by using MTBC-RBS.
Year
DOI
Venue
2009
10.1109/DASC.2009.78
Chengdu
Keywords
DocType
ISBN
rule priority,structured query language,sql server,implementing rule engine,rule engine,rule name,microsoft sql server database,rule editor,billing compliance rule,sql statement,rule description,artificial intelligence,artificial intelligent,knowledge representation,databases,business logic,rule based,knowledge based systems,data transformation,insurance,servers,engines,native language,sql,working memory,rule based system,real time
Conference
978-1-4244-5421-1
Citations 
PageRank 
References 
1
0.37
7
Authors
3
Name
Order
Citations
PageRank
Umair Abdullah110.71
Mohammad Jamil Sawar211.05
Aftab Ahmed394.16