Data Bases in Biomedical Computer and Information Systems

Major: Biomedical Engineering (Internet of Things)
Code of subject: 6.163.03.E.81
Credits: 5.00
Department: Electronics and Information Technology
Lecturer: Hlinenko Larysa
Semester: 7 семестр
Mode of study: денна
Learning outcomes: By the end of the study, learners are expected to: – comprehend the fundamentals of database approach, database design and the use of database management systems for applications in bioengineering systems; – know fundamentals of relational database organization and means of manipulating the relational data; – demonstrate knowledge and skills of relational database schema design by employing the concepts of entity-relationship diagrams, normal forms and normalizing procedures; – declare, define, and access relational database schemas in relational database management systems using the data definition language subset of SQL and facilities of QBE; – demonstrate knowledge and skills of querying relational databases by using SQL and the ability to convert relational algebra queries to SQL; – be able to apply the acquired knowledge for the relational database development in DBMS Access and to support query and constraint realization with QBE and SQL; – demonstrate knowledge of recent advances in database systems by identifying the connection between traditional relational databases and other data models; – understand peculiar features of medical databases design and application; – be able to present results of DB design and to substantiate it while discussing them with other students
Required prior and related subjects: – Informatics in Biomedical Engineering – Fundamentals of Biotechnical Systems Modelling – Information Technology in Biomedical Engineering – Information Systems in Biomedical Engineering – Fundamentals of Medical Expert Systems
Summary of the subject: Characteristics of the database (DB) approach. Advantages of using the DB approach. Data and structure independence. Database system concepts and architecture. Database management systems (DBMS). DBMS architecture and functions. Data models and schemas. Traditional and advanced data models. Database languages and interfaces. Centralized and client/server architectures for DBMSs. Classification of database management systems. The relational data model and relational database constraints. The relational algebra and relational calculus. Relational algebra operations from set theory. Relational operations: SELECT, PROJECT, JOIN and DIV ISION. Conceptual modelling and database design. Data modelling using the Entity-Relationship (ER) model. Entity types, entity sets, attributes, and keys. Relationship types. Relationship sets, roles and characteristics. Notations of ER model. Database design and normalization. Basics of functional dependencies and normalization for relational databases. Normal forms. Relational decompositions algorithms for relational database schema design. Basic SQL. SQL Data Definition and data types. Specifying constraints in SQL. Views (virtual tables) in SQL Basic retrieval queries in SQL. INSERT, DELETE, and UPDATE statements in SQL. Introduction to transaction processing. Desirable properties of transactions. Characterizing schedules based on serializability. Concurrency control techniques. Two-Phase locking techniques for concurrency control. Database recovery techniques. Medical Databases: types and application in bioengineering and medical practice.
Assessment methods and criteria: – Current control: laboratory reports, graphic calculation papers, oral interviewing, written tests – 40 points (40 %): laboratory works execution and defence - 10 points; tests - 20 points; individual exercises (graphic calculation papers) - 10 points – Final control: control procedure - written and verbal examination (60 %): written examination (test) - 54 points; oral interviewing (verbal examination) - 6 points
Recommended books: 1. Берко А.Ю., Верес О.М., Пасічник В.В. Системи баз даних та знань. Книга 1. Організація баз даних та знань: навч. посібник. _ Львів: «Магнолія 2006»б 2008. – 456 с 2. Конноли Т., Бегг К., Страчан А. Базы данных: проектирование, реализация и сопровождение. Теория и практика. – М.: Изд. Дом “Вильямс”. 2000. – 1120 с. 3. Роб П., Коронел К. Системы баз данных: проектирование, реализация и управление. 5-е изд. – СПб.: БХВ-Петербург. – 2004. – 1040 с. 4. Elmasri R. Fundamentals of database systems / Ramez Elmasri, Shamkant B. Navathe.—6th ed. p. cm. – N.Y.-Addison-Wesley, Pearson, 2010. - 1200 pages. ISBN-13: 978-0-136-08620-8. 5. Павлиш В.А., Гліненко Л.К. Основи інформаційних технологій і систем: навч. посібник / В.А.Павлиш, Л.К. Гліненко. - Львів: Видавництво львівської політехніки, 2013. - 500 с. 6. Collen Morris F. Computer Medical Databases: The First Six Decades (1950-2010) (Health Informatics) / Morris F. Collen. - Springer; 2012. – 288 р.