Dbm 381 Week 1 Individual
Examination of the types of database systems that are available and how health care facilities utilize these different types of databases is the topic of this report. Giving more detail on the different types of architecture of databases and data structure will follow.
Defining Health Care Database Systems A computerized clinical database consists of clinical data for storing, retrieving, analyzing, and reporting of information (McCartney, 2012). The data in these databases help in managing care plans, research projects, and creating reports for the different departments within a health care facility. The first type of database that a health care facility may use is Operational database. This database consists of data on patients, the doctors’ orders for care, pharmacy orders, tests ordered, and results of these tests. This database can include product information from vendors. Storing a patient’s electronic health record (EHR) can happen in different types of databases and these databases could have different types of formatting styles. Each of the database software has to have security protocols in place to safeguard the patient’s privacy, yet allow access to the data by different health care providers. Clinical data repository (CDR), which is a data system to collect and integrate data from the different databases products a health care facility may use. It assembles the data from these different systems and displays it as a single-point-of-care about a patient at a workstation (McCartney, 2012). This allows a health care provider to view data from each departments of the facility at one time in near-real-time (McCartney, 2012). This is a step that will help in facilities in sharing data with other facilities. Data warehousing is how a facility stores data for use at a later date. Pulling of patient records to analyze the history of treatments to the results of using certain drugs is available for years. Safeguarding the storage of this
Defining Health Care Database Systems A computerized clinical database consists of clinical data for storing, retrieving, analyzing, and reporting of information (McCartney, 2012). The data in these databases help in managing care plans, research projects, and creating reports for the different departments within a health care facility. The first type of database that a health care facility may use is Operational database. This database consists of data on patients, the doctors’ orders for care, pharmacy orders, tests ordered, and results of these tests. This database can include product information from vendors. Storing a patient’s electronic health record (EHR) can happen in different types of databases and these databases could have different types of formatting styles. Each of the database software has to have security protocols in place to safeguard the patient’s privacy, yet allow access to the data by different health care providers. Clinical data repository (CDR), which is a data system to collect and integrate data from the different databases products a health care facility may use. It assembles the data from these different systems and displays it as a single-point-of-care about a patient at a workstation (McCartney, 2012). This allows a health care provider to view data from each departments of the facility at one time in near-real-time (McCartney, 2012). This is a step that will help in facilities in sharing data with other facilities. Data warehousing is how a facility stores data for use at a later date. Pulling of patient records to analyze the history of treatments to the results of using certain drugs is available for years. Safeguarding the storage of this
References: McCartney, P.R. (2012, May/June). Clinical databases: Electronic health records and repositories. Nursing.Clinical Medicine, 38(3), 186. doi:10.1097NMC.0b03e3182869d8c Pratt, P.J., & Adamski, J.J. (2012). Concepts of database management (7th ed.). Retrieved from The University of Phoenix eBook Collection database.