19.07.16 Databases and workflow

Question 1

What are databases for

Answer 1

-Sample tracking, manage workload, record results

Question 2

What is LIMS

Answer 2

Laboratory Information Management System

Question 3

Benefits of LIMS

Answer 3

• Multiple users can access and update information
• Prevent duplicate testing if multiple samples arrive
• Provide statistics such as TATs, volume of samples received (other performance indicators)
• Finance
• Link to lab equipment (worksheets etc), less manual transcription, which could lead to errors.
• Reduces paper usage

Question 4

Issues with information governance and LIMS

Answer 4

• All users should their own login, can track actions also ensures only correct individuals can access data
• Data should be backed up regularly and be secure

Question 5

Purpose of internal disease specific databases

Answer 5

• To track patient samples from receipt to reporting.

- To record variants identified (aids analysis in future patients)

Question 6

Use of primer databases

Answer 6

• Lots of primers are generated to confirm NGS findings. Need to be recorded.
• can check if we have primers for new variants so as not to duplicate work

Question 7

Examples of QC databases

Answer 7

• Q-pulse

- iPassport

Question 8

Purpose of qc databases

Answer 8

• To store electronic documents (active, archived SOPs), risk assessments etc
• MSDS for reagents, track consumables, batch numbers etc
• Inventory of equipment in lab, store maintenance records and service contracts
• Log non-conformances
• Provide a system for auditing
• Staff training record, Annual leave monitoring to ensure cover over busy times (Christmas)

Question 9

How long does the RCPath (2015) guidelines state that data should be stored for use in family studies

Answer 9

30 years

Question 10

Issues with NGS data storage

Answer 10

• Raw files are very large
• Analysis methods changing continuously making repeat analysis of historical data difficult (almost easier to re-sequence)
• NHS IT infrastructure is often inadequate

Question 11

-Purpose of IT databases in a lab

Answer 11

• allows for an efficient workflow in the lab.
• Easier and more accurate testing (e.g. use of barcodes) and monitoring of progress and results.
• Reduce errors (compared to manual data entry).