TY - JOUR T1 - How to set up a clinical database JF - Practical Neurology JO - Pract Neurol SP - 70 LP - 74 DO - 10.1136/practneurol-2015-001300 VL - 16 IS - 1 AU - Mark Wardle AU - Martin Sadler Y1 - 2016/02/01 UR - http://pn.bmj.com/content/16/1/70.abstract N2 - A database is a logically integrated collection of data, organised to facilitate the efficient storage, modification and retrieval of related information.Most neurologists already interact with databases frequently. Many such interactions are read-only, providing access to a hospital's laboratory or radiology result reporting system or a clinical document held within an electronic patient record (EPR). However, most of us increasingly use databases to view, and create data, such as electronic notes or letters or to record information as part of a wider EPR system.UK health organisations already record core demographic information about patients in a database called ‘patient administrative system’ (PAS). This typically includes name, address, date of birth, National Health Service (NHS) number, hospital identifiers as well as appointments and episodes of care. There will be separate databases to support laboratory results, radiology results and clinical documents, and such data may be combined into what looks like a single application for clinicians called a ‘portal’. Some of you will already have a hospital-wide electronic health record (EHR).As such, why should you think about data in your neurological practice?To support individual clinical careMedical records are not simply a narrative record of what has happened to a patient, but when properly constructed and formatted, integrate and synthesise clinical information and support clinical practice. The record includes history and examination results, problem lists, diagnoses, management and clinical outcomes, and so the design and structure of these records is critical in supporting your clinical work. Electronic records, when properly designed by clinicians for clinicians, have the potential to transform clinical care by ensuring that important data are available at the point-of-care, and are presented in a way to support your work. For example, rather than recording a patient's weight in the paper record, an electronic record can track weight over time in a routine … ER -