dental informatics is a relatively new field that has significant potential for application of computer and information sciences to improve dental research , education and management .
this new way to practice dentistry will require the second - generation dental records and decision support software which , while running in the background , will connect diagnostic findings and patients problems to a regularly updated knowledge base . numerous applications that support clinical care , education and research have been developed .
dental informatics is beginning to exhibit the characteristics of a discipline : core literature , trained specialists and educational programs . oral submucous fibrosis ( osf )
is a multifactorial premalignant condition caused mainly by areca nut , betel quid , tobacco chewing habits and nutritional deficiencies .
many in vivo and in vitro studies have confirmed the above implications . a worldwide estimate in 1996 indicated that 2.5 million people were affected by the disease .
our dental college and hospital since 1997 has got registry in oral cancer and precancer . till date , a total of 2000 osf cases have been registered by the department of oral pathology and microbiology .
this huge epidemiological data will definitely throw light on the complex nature of osf and its association with various chewing habits .
however , to study and handle such large - scale epidemiological data , the help of a computer is inevitable .
prior to advent of graphical user interface ( gui ) softwares , commonly employed methods for dental epidemiological data collection and data entry were use of punch card and scanning of special forms by the clinician .
hence , it was thought to develop a user - friendly software program for a personal computer to study the descriptive epidemiology of osf , which will be easy to handle , very economical and facilitate  online  data feeding , which will be faster and error free .
with the help of computer experts , we planned to design and develop an automated user - friendly tool  sofpro 
( an acronym for a computer program for the study of osf ) for the study of osf patients , with gui support , for easy data collection , organization , retrieval , management and analysis . designing a suitable  form  for data entry and  format  for storage of information ( computer screens ) was done with little modification in the structure of case record form which was previously developed by the expert oral pathologist .
we used a personal computer with the standard configuration of the hardware , consisting of windows xp , ms - visual basic 6.0 ( vb ) , ms - access 2000 , crystal report 7.0 and ms - paint .
windows xp is an operating system which supports gui and is a secure environment that provides support to vb 6.0 .
ms - access was used so that it can also provide support for networking and other required features . 
 with the use of vb 6.0 , utility  form 
the forms were segregated as per the concepts of relational database management design and its concepts to capture the accurate information from patients .
the forms were also designed to be user - friendly by giving the functionality of  add ,  
edit,delete  and  save ,  which will insert , modify , delete or commit data in database in backenddatabase was designed to acquire minimum space in the hard disk of machine .
database plays a key role in the software and hence was designed with due considerations and importance .
different tables with unique data fields were designed so as to avoid redundancy of data .
ms - access was used as database , and structured query language ( sql ) queries were designed to extract the required data based on parameters provided .
the ms - access relational database concepts helped to reduce the memory size used by database to increase the response time and minimum memory consumptionsocial feasibility that is applicability was used in designing the software so that the software should be accepted by the user , i.e. clinician , data entry operator as well as statisticianstatistician was interviewed time - to - time to make the necessary changes in the design so that it will suffice all requirements of descriptive epidemiological study .
great amount of time was dedicated to design phase of software , keeping in view the future need and extension of projectminimum key hits were designed for ease of data entry .
for example , response to a question about type of areca habit , may be in four different forms such as fresh , boiled , fermented or roasted , so list of responses was developed so that data entry operator only needs to choose the correct response from the listthe different analysis to be performed was planned and designed accordingly , such as gender distribution , habit patterns , age - wise distribution and symptomsgraphical representations were designed to represent the analysis in the form of charts , bar diagrams , pie and line diagramsreports were designed for summary fact sheets .
thus , reports extracted from database were presented using the templates of crystal report 's reporting tool .
further , vb chart control was used to represent the graphical analysis of extracted data produced by sql queriesthe application also covers the imaginary representation of oral health of patient which describes the extent of oral fibrosis .
ms - paint brush was used to record the color legend to show the extent of oral fibrosis .
fibrous bands ,   brown  for  pigmentation  and  red  for  malignant ulcerdevelopment : development process was carried out using vb forms for gui screens .
standard setup was developed for distribution of the packagetesting : testing of software was carried out using the real - time data available in the department from year january 2000 .
the errors were identified and rectified at time of testing to judge the smooth working and correct data flowpost implementation maintenance : once the software is implemented , it needs to be observed . in case of system crash ,
hence , all precautions and measures were taken for security of datathe correct data files were now loaded in the computer through data evaluation module and were processed to get result in tabular forms .
sofpro ,  which was designed and developed . 
  with the use of vb 6.0 , utility  form 
the forms were segregated as per the concepts of relational database management design and its concepts to capture the accurate information from patients .
the forms were also designed to be user - friendly by giving the functionality of  add ,  
edit,delete  and  save ,  which will insert , modify , delete or commit data in database in backend database was designed to acquire minimum space in the hard disk of machine .
database plays a key role in the software and hence was designed with due considerations and importance .
different tables with unique data fields were designed so as to avoid redundancy of data .
ms - access was used as database , and structured query language ( sql ) queries were designed to extract the required data based on parameters provided .
the ms - access relational database concepts helped to reduce the memory size used by database to increase the response time and minimum memory consumption social feasibility that is applicability was used in designing the software so that the software should be accepted by the user , i.e. clinician , data entry operator as well as statistician statistician was interviewed time - to - time to make the necessary changes in the design so that it will suffice all requirements of descriptive epidemiological study .
great amount of time was dedicated to design phase of software , keeping in view the future need and extension of project minimum key hits were designed for ease of data entry .
for example , response to a question about type of areca habit , may be in four different forms such as fresh , boiled , fermented or roasted , so list of responses was developed so that data entry operator only needs to choose the correct response from the list the different analysis to be performed was planned and designed accordingly , such as gender distribution , habit patterns , age - wise distribution and symptoms graphical representations were designed to represent the analysis in the form of charts , bar diagrams , pie and line diagrams reports were designed for summary fact sheets .
thus , reports extracted from database were presented using the templates of crystal report 's reporting tool .
further , vb chart control was used to represent the graphical analysis of extracted data produced by sql queries the application also covers the imaginary representation of oral health of patient which describes the extent of oral fibrosis .
ms - paint brush was used to record the color legend to show the extent of oral fibrosis .
fibrous bands ,   brown  for  pigmentation  and  red  for  malignant ulcer  development : development process was carried out using vb forms for gui screens .
standard setup was developed for distribution of the package testing : testing of software was carried out using the real - time data available in the department from year january 2000 .
the errors were identified and rectified at time of testing to judge the smooth working and correct data flow post implementation maintenance : once the software is implemented , it needs to be observed . in case of system crash ,
hence , all precautions and measures were taken for security of data the correct data files were now loaded in the computer through data evaluation module and were processed to get result in tabular forms .
the data were fed manually in the different forms such as patients ' demographic details , habit patterns , clinical examination , clinical diagnosis , treatment given and follow - up . on each screen ,  save and next  functionality is provided where data will be saved in respective tables behind the user - friendly screens due to data coding .
sofpro  was developed for the study of osf patients , with gui support , for easy data collection , organization , retrieval , management and analysis .
 it allows effective retrieval and modification , deletion of the existing data of osf patients [ figures 3a , b , 4a  d and 5a , b ] .
different tables with unique data fields were designed so as to avoid redundancy of data .
it facilitates effective report generation of data in textual forms ( in soft and hard form ) . as a result of gui screens , user having introductory knowledge of computer can effectively handle  sofpro ;  hence , it is socially feasible . 
sofpro  is portable and distributable over local area network ( lan ) for multiple users .
 sofpro  is economically feasible as it is compatible with minimum hardware configurations such as pentium iii / iv cpu , monitor , keyboard , mouse , printer and commonly available operating system such as windows 9x / millennium / xp . single click information for less key press with number of drop - downlists makes 
we successfully converted the paper data to digital data and overcame the problem of manual maintenance of case files from environmental elements such as dust and moist , and it overcomes the problem of management of voluminous information , loss of information , searching a particular patient , maintaining follow - up , biopsy reports and identifying effective treatment modalities .
this is effectively facilitated by ease in manipulation and updating of records as a unique case number to each case report .
( a ) the screen of demographic data collection , ( b ) the screen of patients ' symptoms at first presentation , ( c ) screen representing symptoms and ( d ) screen representing patients personal history including habits ( a and b ) screen representing clinical examination of the patient , ( c ) screen showing provisional diagnosis with included investigation data , ( d ) representing screen for treatment planning ( a and b ) representing screen for follow - up ( a - d ) representing screens for patient data retrieval ( a and b ) representing screens for allowing change in patients details ms - access ( database ) and sql was used to analyze the data .
when a button on software is pressed , it triggers the sql query attached to the button .
the query in turn finds out the logical information from different tables in database and collects the required information , which is ready to be presented either in report or in graphical chart format .
output on frontend , ms - graph control was used to represent these analyzed cases , and graph legends were configured for better scale representation .
. once the data of osf patients are fed in sofpro , the epidemiological data can be easily analyzed with the click of a button .
the affected population can also be analyzed with a click of a button in regards to the most prevalent habit patterns , duration of habit or no habit at all .
even this software has a facility to represent pie diagram of patients having exclusive areca nut habit .
detail data analysis with graphical representations such as charts , bar and line diagrams of different parameters is generated in relation to various symptoms of diseases such as burning sensation , inability to open mouth and recurrent ulceration .
the bio - progression tab will give the feedback data and guides the user clinician about malignant transformation of disease in a consecutive follow - up .
sofpro is unique in regards to mapping and analyzing the osf patients who have other lesions such as lichen planus , leukoplakia , carcinoma in situ and candidiasis .
this feature enables the clinician to point out the patients who require frequent clinical monitoring to prevent any lethal change in patient 's oral cavity and thus , increase the longevity and alley the progression of osf [ figure 6 ] .
data analysis in graphical form for oral submucous fibrosis for the smooth working and correct data flow ,  sofpro  was tested against real - time data of osf available as department records .
known data , not known and null data are successfully accepted in data entry and represented in data analysis .
osf is a chronic oral mucosal disease characterized by inflammation and progressive fibrosis of lamina propria and the underlying submucosal layer of the oral cavity .
many epidemiological studies from india and abroad , have shown that chewing areca nut ( areca catechu ) is the major etiological factor for osf .
many patients with osf have other habits concurrently , which may also play a role in the initiation and the progress of this premalignant condition .
the statistics of osf in indian subcontinent alone in 2002 was about 5 million people ( 0.5% of the population of india ) .
hence , osf is considered as a public health issue in many parts of the world , including the uk , south africa and many asian countries such as india .
it is thus necessary to probe the complexity of osf and role of high - risk factors and various chewing habits .
a large - scale epidemiological survey and data analysis through modern equipment such as computers would probably throw light on this issue .
the thought of computer software program for collection of huge epidemiological data , which will also perform large - scale descriptive analysis , was the silver line in the design and development of dedicated software tool , 
dental informatics is an emerging branch of bioinformatics that deals with application of computer and information technology to improve dental research , education and management .
clinical pathology was first to accept mechanical data processing , because information expressed was in numericals and is ideal for data processing .
in oral pathology , fischman et al . were the first to use electronic data processing . in the development of  sofpro ,  microsoft vb tool was selected as the main application development environment . vb script is the most leading and preferred language for application development because it handles the most difficult and complicated steps involved with ease of writing the code .
by dragging the various active x controls on  form  window of vb tool , data entry screens were developed .
vb is an advanced high - level language , which facilitates static checking of syntax , which in turn corrects the syntactic errors while code writing .
it also helps to debug the program in runtime environment , which is helpful for testing the code for validation at design time .
data files for  sofpro  were designed using microsoft - access as it is portable with other application tools such as intercooled stata and excel .
tables , forms , reports and database element were defined and created separately in a tabulated manner , for example , i d , name , age , sex , address , religion , etc . , for the collection of patients ' demographic details .
once the exacting task of defining the data heads was complete , the writing of computer program was taken up .
visual basic language has flexible grammar that helps in a way that any statement having syntactic error will not be accepted and executed .
since the last three decades , so many workers have tried to develop different computer systems for pathology in general and oral pathology in particular .
myers in 1975 developed computer - retrievable systems for pathology , robboy et al . developed a computer - assisted pathology encoding and reporting system,caper . 
pieper et al . developed a microcomputer - based portable system for recording dental epidemiologic data .
priddy et al . developed an oral pathology data management system for an oral tissue diagnostic program and quivey et al .
the computer programsofpro  developed in the present study was found to be much more advanced and user - friendly than the above computer programs because in the past computer languages were very primitive and computers had less data storing capacity .
abramson developed the four pepi - for - windows ( winpepi ) computer programs for epidemiologist namely describes , compare2 , pairsect and whatis .
the describe programs are developed for use in descriptive epidemiology in practice and research in the health field .
sofpro  was found to as advanced as winpepi 's describe program for use in descriptive epidemiology .
the facility to analyze large quantities of data is an important feature of the  sofpro  system .
 sofpro  allows effective retrieval and modification or deletion on the existing data of osf patients .
different tables with unique data fields were designed so as to avoid redundancy of data .
it facilitates effective report generation of data in textual forms . as a result of gui screens
, users having introductory knowledge of computer can effectively handle  sofpro .  hence , it is socially feasible , found to be portable and distributable over lan for multiple users .
the first head was demographic analysis of age , sex , education , religion and socioeconomic status . in the second head ,
data analysis of different habit patterns such as exclusive habits with their duration and mouth opening and detail analysis of multiple habit patterns is possible .
third , in clinical analysis part , various symptoms , gender - wise clinical grading , other associated lesions and bioprogression of osf patients are made possible .
intercooled stata version 8.0 ' ( stata corporation , lakeway , tx , usa ) was used for the remaining statistical analysis . in the development of 
the development of  sofpro  is a baseline study on which newer technologies such as  cloud computing ,   simulation  and  artificial intelligence  or we can simply develop 
android app  which can be incorporated to improve the understanding of this crippling indian disease . at present , the work is under progress for such an ambitious project .
we designed and developed  sofpro  an automated tool for easy data collection , organization , retrieval , management and analysis of osf patients .
 it can be a valuable aid in teaching or in the rapid testing of new ideas that are being considered for more detailed clinical research on osf . by making this program available on the internet , large international epidemiological studies on osf
we propose to introduce in near future  sofpro  as a mobile friendly application for the clinicians and researchers more handy and user friendly .
 background : dental informatics is an evolving branch widely used in dental education and practice . 
 numerous applications that support clinical care , education and research have been developed . 
 however , very few such applications are developed and utilized in the epidemiological studies of oral submucous fibrosis ( osf ) which is affecting a significant population of asian countries.aims and objectives : to design and develop an user friendly software for the descriptive epidemiological study of osf.materials and methods : with the help of a software engineer a computer program sofpro was designed and developed by using , ms - visual basic 6.0 ( vb ) , ms - access 2000 , crystal report 7.0 and ms - paint in operating system xp . for the analysis purpose 
 the available osf data from the departmental precancer registry was fed into the sofpro.results:known data , not known and null data are successfully accepted in data entry and represented in data analysis of osf . 
 smooth working of sofpro and its correct data flow was tested against real - time data of osf.conclusion:sofpro was found to be a user friendly automated tool for easy data collection , retrieval , management and analysis of osf patients . 
INTRODUCTION
MATERIALS AND METHODS
RESULTS
DISCUSSION
CONCLUSION
Financial support and sponsorship
Conflicts of interest