Children's Hospital at Westmead
Eosinophilic oesophagitis is a rare disease which results in an inflamed oesophagus.
A database was required to retain and manage patient data which was collected for Eosinophilic oesophagitis sufferers.
Data collection included diagnoses, medical history, condition management, investigations, food advice and health services usage.
A user initiated data extract needed to be provided.
Data entry needed to be managed by various staff members and not necessarily dedicated data entry personnel.
Extracts were to be formatted and targeted for an SPSS analyst.
Categorical variables were to be explicitly set in the extract process rather than left to the statistician.
A relatively straight forward project - the database was built from scratch which is often easier than dealing with existing software.
Questionnaires supplied by the research team provided an outline for the database schema.
Discussions with statistician provided information which identified the preferred categorical coding methods and the preferred extract file type - MS-Excel.
A database was presented to the research team which provided them with tight data validation rules, intelligent default values and an easy to use interface.
Food Protein Induced Enterocolitis Syndrome is a severe food allergic reaction to food protein ingestion affecting the gastrointestinal tract
Existing data entry functionality required streamlining.
Creation of a data extract was required.
New functionality was required to conform to the existing database look-and-feel
Initiation of extracts to be managed by researchers.
Extracts were to be targeted for an SPSS user, and categorical variables were to be explicitly set in the extract process rather than the statistician.
Business requirements were gathered by reviewing questionnaires and speaking to the statistical analysts.
Additional data entry functionality was constructed.
The data was preserved in the database during the modifications.
Users were presented with the new database applications.
A short period of instruction was provided during the User Acceptance Testing (UAT) to familiarise users with the new functionality.
Modifications were required to an existing database to minimise time required for statistical analysis.
Target analytical software was SAS, so modifications had to streamline inter-operability between SAS and MS-Access.
Review of questionnaires for data similarities and possible groupings.
Discussions with SAS user to ascertain available connectivity functionality
The database schema was modified to allow meaningful groupings allowing direct access for the SAS software to the MS-Access database