Data Warehouse Design For Knowledge Discovery From Healthcare Data

Due to shifting of healthcare data in electronic form, huge volumes of data have been accumulated in organizations related to medical claim processing domain. This paper presents design of a data warehouse implemented as integral part of a rule based expert system. The system is being used for scrubbing of medical claims' data. Approximate star schema has been used for designing the proposed data warehouse. The data warehouse is being used by the production rule mining module and inference engine of the system. Rejected medical claims got corrected in operational database. Payments are received against corrected claims. Production rule mining module needs both versions of a claim, to learn new rules. Therefore data warehouse is required to store all states of medical claims. Moreover, efficiency of the rule based inference engine of the system has increased due to de-normalized format of data in the warehouse.

[1]  Aftab Ahmed,et al.  Knowledge Representation and Knowledge Editor of a Medical Claim Processing System , 2012 .

[2]  Ramakrishnan Srikant,et al.  Fast algorithms for mining association rules , 1998, VLDB 1998.

[3]  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.

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

[5]  C S Ledbetter,et al.  Toward best practice: leveraging the electronic patient record as a clinical data warehouse. , 2001, Journal of healthcare information management : JHIM.

[6]  Jonathan S. Einbinder,et al.  Web-Accessible Patient Data Warehouse at the University of Virginia , 1999, AMIA.

[7]  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.

[8]  J. Ahmad,et al.  Analysis of effectiveness of apriori algorithm in medical billing data mining , 2008, 2008 4th International Conference on Emerging Technologies.