What is the difference between OLTP and OLAP databases? In healthcare, why do we need the EDW on top of the OLTP database? What is the difference between a table and a view?

Description

Page 1- Week 1 – DB #1 (of2)

Share an example of a database or a tool that utilizes a database that you’ve used in the past that you feel has performance gaps. Examples can be EMRs, data warehouses, or even a non-medical tool such as a traditional business database. Provide an overview of the tool, areas for improvement and whether or not you feel the issue(s) can be corrected or if you feel the organization should start from scratch with a new database.

Page 2- Week 1 – DB #2 (of 2)

Terminology Questions:

Imagine you are designing an EMR for a busy Primary Care Office. Answer the first three questions below based on this need. The fourth question can be answered from a general perspective.

Give an example of a field in your database that should never be null. Why?

Why is data integrity important?

What is the difference between OLTP and OLAP databases? In healthcare, why do we need the EDW on top of the OLTP database?

What is the difference between a table and a view?