DESIGN AND IMPLEMENTATION OF DATA MINING FOR MEDICAL RECORD SYSTEMS


DESIGN AND IMPLEMENTATION OF DATA MINING FOR MEDICAL RECORD SYSTEMS. (A CASE STUDY OF OWERRI GENERAL HOSPITAL)  

ABSTRACT

Data mining is the extraction of hidden predictive information from large database which helps in predicting future trend and behavior thereby helping management make knowledge driven decisions. The data mining tool designed is to aid in quick access and retrieval of patients information to avoid time wasted in retrieving of such data from hospitals data warehouse. The data mining tool was also designed to discover hidden pattern that helps in decision making by management. Structured System Analysis and Design Methodology were used in the analysis of the existing system which also provided a guide for the design of the proposed system.

PHP programming language and my SQL was used in the creation of a data warehouse for patient‟s information and data mining tool for the retrieval of such information when needed.

TABLE OF CONTENTS

Title Page

Approval Page………………………………………………………………..i 

Certification Page…………………………………………………………… ii 

Dedication……………………………………………………………………iii

Acknowledgment…………………………………………………………...v 

Table of Contents…………………………………………………………… vi

Abstract……………………………………………………………………... x

CHAPTER ONE

INTRODUCTION

1 Background of Study……………………………………………. 1

1 Statement of the Problem……………………………………….. 2

1 Objective of Study……………………………………………... 3

1 Significance of Study…………………………………………… 4

1 Scope of Study…………………………………………………...4

1 Limitation of Study………………………………………….. …4

1 Definition of related terms…………………………………….… 5

CHAPTER TWO

REVIEW OF RELATED LITERATURE

2.1 Introduction……………………………………….. ………..7

2.2 Review of related literature………………………………….11

CHAPTER THREE

SYSTEM ANALYSIS AND METHODOLOGY

3.1 System  analysis…………………………………..…......16

3.2 Method of data collection…………………..………........17 

3.2.1 Interviewing key officer………………………………….17

3.2.2 Observation method………………………………………18

3.2.3 Examination of document…………………………………18

3 Analysis of the existing system……………..……………..18

3.3.1 Organization profile chart…………………………….........18

3.3.2 Advantages of the existing system…………..….………….20

3.3.3 Disadvantage of the existing system…………….………….21

3.4 Analysis of the proposed system………………….…………21

3.4.1  Justification of the proposed system…………………………22

3.5 Methodology……………………………………………………23

3.5.1  Recommended appropriate mode…………………………….24

CHAPTER FOUR

SYSTEM DESIGN AND IMPLEMENTATION

4.1 Overview of design……………………………………………25

4.2 Main menu………………………………………………….....26

4.3 Program modules specification………………………………27

4.3.1 Database design and specification……………………………27

4.3.2 Input/output specification……………………………………28

4.3.3 Input form……………………………………………………29

4.3.4 Output form…………………………………………………..31

4.3.4.1 Medical record system………………………………..32

4 Flowchart of the proposed solution………………………….34

4 Choice and justification of programming language…………..35

4 System requirement ………………………………………….37

4 Implementation plan…………………………………………..37 

4.7.1 Testing………………………………………………………...38

4.7.2 Conversion…………………………………………………….39

4.7.3 Training……………………………………………………….40

4.8 Maintenance details………………………………………….40

CHAPTER FIVE

SUMMARY, RECOMMENDATIONS, CONCLUSION

5.1 Summary………………………………………………….41

5.2 Review of achievements…………………………………..42

5.3 Areas of application………………………………………..42

5.4 Suggestion for further studies………………………………42

5.5 Recommendation……………………………………………43

5.6 Conclusion…………………………………………………..43

REFERENCES…………………………………………………...45

APPENDIX A (Program codes)

APPENDIX B (Sample, output forms)

CHAPTER ONE

INTRODUCTION

1 BACKGROUND OF STUDY

Data mining, is the extraction of hidden predictive information from large database, is a powerful new technology with great potential to help companies focus on the most important information in their data warehouses. Data mining tools predict future trends and behaviors, allowing businesses to make proactive, knowledge driven decisions. The automated, prospective analysis offered by data mining move beyond the analyses of past events provided by retrospective tools typical of decision support systems. Data mining tools can answer business questions that traditionally were too time consuming to resolve. The scour databases for hidden patterns, finding predictive information those experts may miss because it lies outside their expectations.

Most companies already collect and refine massive quantities of data. Data mining techniques can be implemented rapidly on existing software and hardware platforms to enhance the value of existing information resources, and can be integrated with new products and system as they are brought on-line. Which implemented on high performance client/server or parallel processing computers, data mining tools can analyze massive database to deliver answers to questions such as “Which client are most likely to respond to my next promotional mailing, and Why?”

Data mining techniques are result of a long process research and product development. This evolution began when business data was first stored on computers, continued with improvement in data access, and more recently, generated technologies that allow users to navigate through their data in real time. Data mining takes this evolutionary process beyond retrospective data access and navigation to prospective and proactive information delivery.

Data mining is ready for application in the business community because it is supported by three technologies that are sufficiently mature: massive data collection, powerful multiprocessor computers and data mining algorithms. In this evolution from business data to business information, each new step has built upon the previous one. For example, dynamic data access is critical for drill-through in data navigation applications, and the ability to store large database is critical to data mining.

The file management is obsolete in developed countries like the United States where and in developing countries like Nigeria the file system is still processed manually in most medical centers; this is as a result of low standard of technology. It was clear that computer is everywhere in Nigeria. These computers are for money making and as a result of this, our hospitals lack computerized services, but with the help of data mining we can also computerize our hospitals.

1.2 STATEMENT OF THE PROBLEM

The problem of data mining has become very crucial in areas of privacy of data. Specifically regarding the source of the data analyzed for certain purpose. My research in Owerri General Hospital here reveals that patients visit the hospital and they waste a lot of time. The patients waits for the nurses or the attendants to get their data and there are volumes of files to search through before the patients files is finally retrieved or the patients might forget his/her card when visit the hospital.

It there means that the patient‟s data cannot be found due to the fact that the Nurse does not know the patients number. In this case it is either that the patients is denied treatment by the Doctor or the Nurses will check through the volumes of files in order to retrieved his/her data, this is time consuming problem. There is a problem of misplacing of patients data, the non-availability of relevant forms like x-ray/laboratory forms and chats (pressure chats temperature) and requirement of more workers to carry the folders into the consulting rooms as an evident.

Moreover, there are mistakes in entering patient‟s records. Two patients might be given the same number and there could be wrong spelling and loss of important information. There is also lack of space for storing all the files and also due to carelessness on the part of staff.

Furthermore, volume of work for the hospital staff is much; this is because the ratio of patients to staff of Owerri General Hospital is so much. So staffs are over worked and they hurry through their duty, hence they carry out such duties lousily which makes the Doctors unfriendly to their patients.

1.3 OBJECTIVE OF STUDY

Objectives of this research work are to:

Image Create a data warehouse for storage of patient‟s information thereby eliminating manual file storage of patient‟s records.

Image Design a good data mining tool that will help in easy retrieval of patient information thereby reducing time wastage and improve service delivery. Image The data mining tool will be able to discover hidden pattern in large volume of data which will help in good decision making.

1.4 SIGNIFICANCE OF STUDY

This research will cover the creation of good database system for the management of patient‟s records in Owerri general hospital and also provide efficient data mining tool for easy retrieval of data and discovery of hidden patterns in large volume of data.

1.5 SCOPE OF STUDY

This research work will be carried out on data mining for the medical record system of Owerri General Hospital. The work reported in this research could be viewed as a step towards enhancing databases with functionalities.

1.6 LIMITATION OF STUDY

Data mining record is limited in that; some manual operation will still be needed to carry out the operation effectively. There was some constraints encountered during collection of data, poor data collection becomes apparent due to interviewing of hospital representatives like the consultants. Nurses, Doctors, Hospital attendants who were reluctant to disclose important information and statistical data which otherwise would have been relevant to this research, due to hospital secret which breeds some indifferent attitudes towards that.

It takes a long time and large commitment of resources to get a good result, unavailability of text and materials on this topic, made gathering of facts very difficult, some of the facts were gathered from the internet, which is quite expensive.

1.7 DEFINITION OF TERMS

Data Mining: Can be defined as “The nontrivial extraction of implicit, previously unknown, and potentially useful information from data, and “The science of extracting useful information from large data set or databases”.

It involves sorting through large amounts of data and picking out relevant information.

Information Retrieval: The act of locating quantities of data stored in a Database and producing useful information from the data.

Information Processing: A method of organizing, processing and extracting information to be easily stored, retrieved, searched and updated.

Record: It is a unit of data representing a particular transaction or a basic element of a file consisting in turn a number of interrelated data elements.

Hospital: A hospital is an institution of medical treatment of the sick and injured

people.

Model: Is a pattern or mathematical/symbolic representation of real life

System and or abstract system behaviors.

Artificial Intelligence: It is a branch of computer science that is dedicated to the study of the ways in which computers can be used to emulate or duplicate most human function.

Knowledge Base: Is an organized collection of declarative and procedural

relationships that represents expertise in a focused area

.

DESIGN AND IMPLEMENTATION OF DATA MINING FOR MEDICAL RECORD SYSTEMS



TYPE IN YOUR TOPIC AND CLICK SEARCH.






RESEARCHWAP.NET

Researchwap.net is an online repository for free project topics and research materials, articles and custom writing of research works. We’re an online resource centre that provides a vast database for students to access numerous research project topics and materials. Researchwap.net guides and assist Postgraduate, Undergraduate and Final Year Students with well researched and quality project topics, topic ideas, research guides and project materials. We’re reliable and trustworthy, and we really understand what is called “time factor”, that is why we’ve simplified the process so that students can get their research projects ready on time. Our platform provides more educational services, such as hiring a writer, research analysis, and software for computer science research and we also seriously adhere to a timely delivery.

TESTIMONIES FROM OUR CLIENTS


Please feel free to carefully review some written and captured responses from our satisfied clients.

  • "Exceptionally outstanding. Highly recommend for all who wish to have effective and excellent project defence. Easily Accessable, Affordable, Effective and effective."

    Debby Henry George, Massachusetts Institute of Technology (MIT), Cambridge, USA.
  • "I saw this website on facebook page and I did not even bother since I was in a hurry to complete my project. But I am totally amazed that when I visited the website and saw the topic I was looking for and I decided to give a try and now I have received it within an hour after ordering the material. Am grateful guys!"

    Hilary Yusuf, United States International University Africa, Nairobi, Kenya.
  • "Researchwap.net is a website I recommend to all student and researchers within and outside the country. The web owners are doing great job and I appreciate them for that. Once again, thank you very much "researchwap.net" and God bless you and your business! ."

    Debby Henry George, Massachusetts Institute of Technology (MIT), Cambridge, USA.
  • "Great User Experience, Nice flows and Superb functionalities.The app is indeed a great tech innovation for greasing the wheels of final year, research and other pedagogical related project works. A trial would definitely convince you."

    Lamilare Valentine, Kwame Nkrumah University, Kumasi, Ghana.
  • "I love what you guys are doing, your material guided me well through my research. Thank you for helping me achieve academic success."

    Sampson, University of Nigeria, Nsukka.
  • "researchwap.com is God-sent! I got good grades in my seminar and project with the help of your service, thank you soooooo much."

    Cynthia, Akwa Ibom State University .
  • "Sorry, it was in my spam folder all along, I should have looked it up properly first. Please keep up the good work, your team is quite commited. Am grateful...I will certainly refer my friends too."

    Elizabeth, Obafemi Awolowo University
  • "Am happy the defense went well, thanks to your articles. I may not be able to express how grateful I am for all your assistance, but on my honour, I owe you guys a good number of referrals. Thank you once again."

    Ali Olanrewaju, Lagos State University.
  • "My Dear Researchwap, initially I never believed one can actually do honest business transactions with Nigerians online until i stumbled into your website. You have broken a new legacy of record as far as am concerned. Keep up the good work!"

    Willie Ekereobong, University of Port Harcourt.
  • "WOW, SO IT'S TRUE??!! I can't believe I got this quality work for just 3k...I thought it was scam ooo. I wouldn't mind if it goes for over 5k, its worth it. Thank you!"

    Theressa, Igbinedion University.
  • "I did not see my project topic on your website so I decided to call your customer care number, the attention I got was epic! I got help from the beginning to the end of my project in just 3 days, they even taught me how to defend my project and I got a 'B' at the end. Thank you so much researchwap.com, infact, I owe my graduating well today to you guys...."

    Joseph, Abia state Polytechnic.
  • "My friend told me about ResearchWap website, I doubted her until I saw her receive her full project in less than 15 miniutes, I tried mine too and got it same, right now, am telling everyone in my school about researchwap.com, no one has to suffer any more writing their project. Thank you for making life easy for me and my fellow students... Keep up the good work"

    Christiana, Landmark University .
  • "I wish I knew you guys when I wrote my first degree project, it took so much time and effort then. Now, with just a click of a button, I got my complete project in less than 15 minutes. You guys are too amazing!."

    Musa, Federal University of Technology Minna
  • "I was scared at first when I saw your website but I decided to risk my last 3k and surprisingly I got my complete project in my email box instantly. This is so nice!!!."

    Ali Obafemi, Ibrahim Badamasi Babangida University, Niger State.
  • To contribute to our success story, send us a feedback or please kindly call 2348037664978.
    Then your comment and contact will be published here also with your consent.

    Thank you for choosing researchwap.com.