Transcript Informatics Core at the GCRC

Informatics Core at
the GCRC
Christine Hotz
July 30, 2004
What




WordNet Dictionary
Noun1.informatics – the sciences concerned
with gathering and manipulating and storing and
retrieving and classifying recorded information
Synonyms: information processing, information
science
Pronunciation: `infu'matiks
CRISP
CLINICAL/TRANSLATIONAL
RESEARCH
INVESTIGATOR
SERVICES PROGRAM
Biomedical
Research and
Consulting
Service
(BIRCS)
Informatics Core
GCRC
Medical
Informatics
Information
Technology
Center for
Health
Technology
(CHT)
Who
Christine Hotz (BIRCS)
 Kent Anderson (CRISP)
 Cal Chang – advisory role (Academic IS)
 BIRCS – advisory role

Mission of Informatics Core
Support Administrative Core
 Develop and Maintain IT Infrastructure
 Assist and support clinical researchers
 Education

Support of clinical researchers
Informatics review of protocols
 Consultation to determine needs
 Data support
 Equipment support
 Software
 Education
 General Resource

Equipment

Video Recording









3 digital video cameras (Sony and Panasonic)
Screen capture recording
Full video editing station
1 Nikon digital camera
Teleconferencing Equipment
DVD and CD Burners
Tablet PCs for data collection
Portable DVD player
High Speed Scanner with OCR software
Software










Video Editing software (Adobe Premiere)
Photoshop
Dreamweaver
Adobe Acrobat
SPSS
SAS
Microsoft Office (Word, Excel, PowerPoint, Access)
Dragon Voice Recognition Software
WinZIP Ver. 9
Direct RT
Data Support
Gathering (Collection)
 Manipulating
 Classifying
 Storing
 Retrieving

Data Support

Gathering (Collection)
 Paper
 Electronic
input
Computer
 PDA
 Tablet PC
 Voice Recognition Software

Data Support
Manipulating and Retrieving
 Flat file vs. Database
 Text file

Database Example
Researcher’s data contained within 11
spreadsheets, 9 Word documents, and
177 paper charts
 Converted to Access database

Data Support

Spreadsheet / Flat file database

Advantages:
 Easy to set up
 Easy to understand
Disadvantages:
 May require entering the same information in many
records.

 A text database is hard to read.
 A single record in a spreadsheet
database may not fit
across the screen
http://www.jegsworks.com/Lessons/lesson1-2/lesson2-4database.htm
Data Support

Relational Database

Advantages:





Reduces the duplication in data entry.
Faster searches.
Can create forms and reports that display only the data you want
to see.
Can create queries to answer questions that are hard or
impossible to answer in flat databases.
Disadvantages:


Can be complex to set up, using many tables.
It is harder to understand how all the parts relate to each other.
http://www.jegsworks.com/Lessons/lesson1-2/lesson2-4database.htm
Data Support
http://nte-socio.univ-lyon2.fr/Marc_Grange/BDConception_en.htm
Differences
Spreadsheet
Database
Main use
Calculations
Data management and
processing
None
Structuring and strong
consistency
Integrity Controls of Data
None
Strict checking of the
possible values of each
data
Access to dat
Single User
Multi users
Data Confidentiality
No Control
Checking of the rights of
access for each user
Data Size
-One Table
Dozens of Rows
-Several tables
-Several thousand of rows
by table
Processing of data
Quantitative
Qualitative and quantitative
Interrogation of data
Realized by specific
Procedures
"Universal" language : SQL
Structuring of data
Data Support

Classifying
 Controlled
terminology
 Adherence to Health information standards
Data Support

Storing
 Hard
Drive
 CD
 DVD
 Jump
Drive
 Web/Server
Data Support






Storing — GCRC research database
In planning stage
Will be housed on a secure server with
password protected access
Data never deleted
Adherence to standards
User-friendly interface for data entry, display,
and retrieval
Data Support

Storage Considerations
 Encryption
and password protection
Lexar Secure jump drive version 2
 Winzip version 9
 Pocket PC encryption software

 Version
Control
 Backup policies
Education





Clinical Epidemiology and Study Design (DVD)
Scientific Proposal Writing Workshop (DVD)
Data Modeling and Database Design (Web)
(Lynch)
Regularly scheduled classes
Instruction by request