BMI Course Information
BMI 555 Medical Information Management (3)
Instructor Information |
|
Fall 2009 |
Course not offered |
Spring 2009 |
Course not offered |
Catalog Description
Database theory and information management systems with applications to biomedical domain, including use of databases in the Web context.
Prerequisites
Admission to any SCI graduate program
Textbook and Other Materials
Raghu Ramakrishnan and Johannes Gehrke, Database Management Systems. 3rd Ed, McGraw-Hill, 2002.
Bioinformatics: Managing Scientific Data, by Zoe Lacroix and Terence Critchlow, published by Morgan Kaufman, 2003.
Course Learning Outcomes
Understand information management issues and become intelligent users of data management systems.
- An understanding of major database models, including a working knowledge of the relational model.
- The ability to analyze data management tasks and to conceive and implement effective data models in relational database system including biological databases (understanding of normalization, indexing, etc.).
- The ability to use Structured Query Language to create, manage and interrogate relational databases.
- A general understanding of database security issues from the perspective of database and network administration and of ubiquitous protocols of internetworking and data transport as well as relevant issues of security and privacy.
- An understanding of XML framework for data markup and applications of XML in the interchange of data among systems; the ability to structure and validate well-formed XML documents.
- The ability to query remote information systems via web services or other protocols and to ingest data into a local file or data management system.
- The ability to distinguish types of metadata and familiarity with standards for disciplines- or industry-specific metadata standards (e.g., FGDC for geospatial data; EDI/ASC X12 for e-commerce; etc., etc.).
- Demonstrate skills in team dynamics, communication, and project management.
- Demonstrate proficiency in commonly used project management techniques and tools (includes project planning and risk assessment and planning)
- Technical writing and speech
Course Outcomes
- To understand relational and XML data models and their applications
- To design a relational database for a given (biomedical) application
- To query, update and maintain the relational databases using SQL locally or through web
- To create and query XML documents
- To understand security and privacy issues in databases
- To understand data integration problems and approaches
- To be familiar with sample online accessible biomedical databases, and some specific metadata standards
- To apply the concepts, methods, and techniques of database systems to produce an information management system (particularly for biomedical domains).
- To work and communicate effectively as a team member to build a medium-sized information management system
Major Topics and Time Covered
The students are expected to develop a working knowledge of design, access, and implementation of database systems. The students will also be exposed to current deployment of database technology in biomedical applications, as well as the use of databases in the web context.
- Data models
- Relational database design
- Database access using structured query language (SQL)
- Database access using text search
- Database access through Internet
- Database updates
- Indexing and optimization
- Semi-structured data and XML
- Schema, Ontology and metadata
- Data warehousing and integration
- Security and privacy issues in data access
- Sample biomedical databases (such as GenBank, SWISSPROT, GSDB, etc.)
- Overview of tools and techniques for accessing, visualizing, and analyzing biomedical knowledge and data