Data Storages and Procedures in Healthcare Area

Cite this

Introduction

In this paper, YouTube videos are used to define the concepts of the data warehouse (DW), data mart (DM), and ETLs. To choose the videos, I paid attention to the authors, the number of subscribers and views, the informative and visual quality of the video, and its connection to health care.

Cut 15% OFF your first order
We’ll deliver a custom Health IT paper tailored to your requirements with a good discount
Use discount
322 specialists online

Data Warehouse and Data Mart

The WCI Consulting (2016) points out that the terms DW and DM define the sets of data that are “used for reporting and analysis,” but DM is smaller than DW, and DW includes several (typically many) of them. Thus, a DM is a subset of a DW, and its purpose is to provide usable information, while “harvesting” it from the databases that are available to them.

A model for an Access database for a particular year that is based on SEER data.
Figure 1. A model for an Access database for a particular year that is based on SEER data.

From the information stated above, it may be assumed that the SEER website offers access to a large warehouse of various data. For instance, the GeoViewer Application (NIH., n.d.b) includes a menu of commands that offers to access its subsets (DMs). One can choose to view the data on the cervix cancer incidence in Hispanic women in 2008-2012 in Iowa. Therefore, the attributes of the mortality and incidence rates in Figure 1 can be regarded as DMs for the DW of SEER, even though this model is rather crude.

ETL Tool

An ETL tool, as defined by Intricity101 (2011), is the tool that is used to Extract, Transform, and Load data. In other words, it ensures data transition and transformation, which may be employed for data warehousing. ETLs are critical for data management, and the choice of one of them for a database of the SEER scope is a strategic move that needs to be made with caution.

As stated by Oracle Midsize (2014), it is becoming increasingly difficult for ETLs to deal with the growing data flow. Since the ETL “transform” part is situated between “extract” and “load,” it requires a middle server that is supposed to be very “robust” and expensive. Oracle Midsize (2014) develops its data transfer tools using another technique, ELT, which shifts the transformation to the “already robust” target database.

In this case, the transformation happens after the loading, which, according to Oracle Midsize (2014) improves the performance of the ELT tool. In healthcare, costs remain a significant issue, and NIH (n.d.a) states that it is dedicated to the continuous improvement of SEER quality (para. 4). Efficient money-spending and improved data transfer and transformation tool performance are in line with this intent. Oracle Midsize (2014) specifically highlights the analytical advantages of ELT, but an operational database will also benefit from improved data transfer and transformation. Also, given the reputation of the Oracle Corporation (2016), it might be chosen as a provider of the tools for the database.

References

Intricity101. (2011). What is an ETL Tool? Web.

On-Time Delivery!
Get your customized and 100% plagiarism-free paper done in as little as 3 hours
Let’s start
322 specialists online

NIH. (n.d.a). About SEER. Web.

NIH. (n.d.b). GeoViewer Application. Web.

Oracle Corporation. (2016). Oracle Fact Sheet. Web.

Oracle Midsize. (2014). ELT is not ETL – Oracle Data Warehouse Solutions. Web.

WCI Consulting. (2015). What is a Data Warehouse, Data Mart & a Reporting Database (DW/DM/RDB)? Web.

Get a custom-written paper
For only $13.00 $11/page you can get a custom-written academic paper according to your instructions
Let us help you
322 specialists online

Cite this paper

Select style

Reference

NursingBird. (2021, April 21). Data Storages and Procedures in Healthcare Area. Retrieved from https://nursingbird.com/data-storages-and-procedures-in-healthcare-area/

Reference

NursingBird. (2021, April 21). Data Storages and Procedures in Healthcare Area. https://nursingbird.com/data-storages-and-procedures-in-healthcare-area/

Work Cited

"Data Storages and Procedures in Healthcare Area." NursingBird, 21 Apr. 2021, nursingbird.com/data-storages-and-procedures-in-healthcare-area/.

References

NursingBird. (2021) 'Data Storages and Procedures in Healthcare Area'. 21 April.

References

NursingBird. 2021. "Data Storages and Procedures in Healthcare Area." April 21, 2021. https://nursingbird.com/data-storages-and-procedures-in-healthcare-area/.

1. NursingBird. "Data Storages and Procedures in Healthcare Area." April 21, 2021. https://nursingbird.com/data-storages-and-procedures-in-healthcare-area/.


Bibliography


NursingBird. "Data Storages and Procedures in Healthcare Area." April 21, 2021. https://nursingbird.com/data-storages-and-procedures-in-healthcare-area/.