CIS 317 - Database Design and Management
Keeping the lifeblood of Informatics carefully stored, protected, clean and ready for use is the task of every Informaticist. Learning the basics of database design and management allows leaders to understand the boundaries of successful and safe implementations. Learning the language allows the more clinically trained informaticist to communicate effectively the needs of providers.
Having worked with smaller, less robust database programs on my own, I was familiar with the key terms and concepts of relational databases and database management. Although I had tried to created database models, my inexperience was highlighted as I went through this course. It was particularly helpful to learn about the relational languages and begin to work with the interface to the Oracle DBMS.
Normalization was a term that I was not familiar with prior to this course, but having a background in mathematics, the logic of this was fun and interesting. Learning to puzzle out the errors in a database and learn how they could be resolved was an interesting challenge. Of all these objectives, evaluating security risks perhaps the most useful opportunity, since that is likely the issue I will be faced with most often.
I was able to build upon my own interests in database design through better understanding of normalization. I had previously built several small databases for personal and office use, but clearly they were inefficient. With my background in mathematics, learning to develop a minimal cover was an interesting logic problem. I was also able to extend my learning to more robust development and explore my interest in understanding web-based access to databases.
As I move further into Informatics I anticipate that this knowledge will be invaluable in assuring that the information we need is available and accessible at the point of care. Understanding the complexities of database efficiency, security and accuracy will be key to this goal.
Consultant Database Dormitory Database MMI Overview Coursework Projects Home
Having worked with smaller, less robust database programs on my own, I was familiar with the key terms and concepts of relational databases and database management. Although I had tried to created database models, my inexperience was highlighted as I went through this course. It was particularly helpful to learn about the relational languages and begin to work with the interface to the Oracle DBMS.
Normalization was a term that I was not familiar with prior to this course, but having a background in mathematics, the logic of this was fun and interesting. Learning to puzzle out the errors in a database and learn how they could be resolved was an interesting challenge. Of all these objectives, evaluating security risks perhaps the most useful opportunity, since that is likely the issue I will be faced with most often.
I was able to build upon my own interests in database design through better understanding of normalization. I had previously built several small databases for personal and office use, but clearly they were inefficient. With my background in mathematics, learning to develop a minimal cover was an interesting logic problem. I was also able to extend my learning to more robust development and explore my interest in understanding web-based access to databases.
As I move further into Informatics I anticipate that this knowledge will be invaluable in assuring that the information we need is available and accessible at the point of care. Understanding the complexities of database efficiency, security and accuracy will be key to this goal.
Consultant Database Dormitory Database MMI Overview Coursework Projects Home