StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Data Warehousing in Healthcare - Article Example

Cite this document
Summary
 This essay discusses complex filing systems repositories in Healthcare in order to maintain the organization's history and to make it easy to retrieve information whenever a need arose. This made it possible for organizations to learn from past trends, to present evidence in court hearings…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER91.4% of users find it useful
Data Warehousing in Healthcare
Read Text Preview

Extract of sample "Data Warehousing in Healthcare"

 Data Warehousing in Healthcare Outline I. Overview and objectives of the technology II. Manufacturers of the technology III. Operational requirements a. Hardware b. Software c. Network d. Information IV. The requirements for maintenance and support V. Important stakeholders VI. Business processes VII. Value/Benefits VIII. Opportunities for improving the technology a. Business b. Technical Declaration I pledge on my honor that I have not given or received any unauthorized assistance on this assignment/examination. I further pledge that I have not copied any material from a book, article, the Internet, or any other source except where I have expressly cited the source. Signature ________________ Date: ____________­­­____ Overview and Objectives of the Technology In the past, many organizations maintained complex filing systems and information repositories in order to maintain the organizations history and to make it easy to retrieve information whenever a need arose. This made it possible for organizations to learn from past trends, to present evidence in court hearings, and to keep an accurate record of the events that took place in its premises[Mur07]. The need to store information for both historical and strategic reasons inspired many companies to acquire IT-based infrastructure to maintain the records. The main reason for this was the increased efficiency that IT-based systems brought to the organizations. The idea of pooling a large amount of information to allow for research and reorganization refers to data warehousing. The concept is as old as the ancient libraries. However, the tools for data storage are no longer large tomes of papyrus and paper, but IT based databases. Manufacturers of the Technology The setting up of data warehouses is not a preserve of any specific company. In fact, data warehouses have components made by different manufacturers. A consultant, usually a systems engineer, designs, and sets up a data warehouse for different clients based on their needs[Hya07]. In this sense, a data warehouse is not a product, but a system designed using components from different manufacturers. To illustrate this point, a data warehouse resembles an engineering product designed by an engineer but constructed using equipment made by other manufacturers. Operational Requirements a. Hardware The physical components of the data warehouse include computers, servers, and network equipment such as routers, hubs, and cabling. These components provide the physical interface that represents the data warehouse. Depending on the type of data warehouse, the equipment will have ratings that match the needs of the institution. Other elements that constitute the hardware for the data warehouse include power supply equipment such as Uninterrupted Power Supply (UPS) units, power cables, power adapters and surge protection devices. These elements ensure that the warehouse has reliable power supply. b. Software The software that operates data warehouses is largely database software. Depending on whether the database is internet based or not, the type of software used to run it differs. Web based databases that form the core of the data warehouses normally use PHP or MySQL coding. The most common database software used in data warehouses includes the Oracle database software and the popular Microsoft Access for smaller data warehouses[Rot09]. c. Network When it comes to networking, there are three options for a data warehouse. The first one is a standalone computer that has database software operated by a single person at a time , this option is useful in very small healthcare facilities The second one is a Local Area Network (LAN), which allows users within a reasonably small geographical area to access the database. The next type is the Wide Area Network (WAN) which exceeds the primary boundary of the organization and allows remote excess. In a sense, the internet is a Wide Area Network (WAN) that supports global access. d. Information The fourth operational requirement for a database is information. In fact, a data warehouse primarily deals with information. The three operations possible in a data warehouse are data input, data archiving and data processing to extract information. Data warehouses provide the users an opportunity to interrogate existing data to get new ideas about how to handle existing and emerging challenges. The Requirements for Maintenance and Support The requirements of a data warehouse for maintenance and support solely depends on the complexity of the data warehouse. In small warehouses, the database maintenance is not a specific job. Regular computer and network maintenance functions are sufficient for its optimal operations. On the other hand, large data warehouses, the type designed by systems engineers, require troubleshooting from time to time to rid it of bugs. The maintenance engineers handle the work as a complete job in itself. The operation of such data warehouses may require training of the employees of the organization on how to access and interrogate the data in the data warehouse. Important Stakeholders There are three categories on important stakeholders when it comes to data warehouses in the healthcare industry. The first category is the patients. The data warehouse primarily serves to keep patient records, and vendor records that form part of the inputs towards care. The second class of stakeholders is the knowledge workers. It includes the physicians, the specialists, the nurses, pharmacy staff and the accounts and procurement personnel. The third class of stakeholders is the maintenance personnel. In a large healthcare facility, there may be a dedicated IT department handling the issues relating to the data warehouse. On the other hand, smaller facilities chose to have a technician on call to help if the need arises. Business Processes Data warehouse form the backbone of strategic planning processes. By interrogating the data in the archives, strategic planning teams can glimpse the trends and patterns in the business processes of the healthcare facility. Strategic planning calls for in-depth understanding of the operating trends to allow the planners to extrapolate the possible future of the facility. Secondly, data warehouses provide healthcare facilities with the ability to detect outbreaks and pandemics. This occurs when the facility implements policies that allow it to interrogate the database for telltale signs of disease outbreaks[DOH11]. In this sense, the facility benefits by avoiding unnecessary costs associated with treatment of patients because they can test for the presence of the disease quickly when a patient arrives. If this does not happen, then the facility may have to conduct many tests to determine what a patient is suffering from. Value/Benefits A data warehouse provides two key benefits to a healthcare facility. The first one is that it provides the facility with a source of primary data relating to all aspects of its operations. The benefit of this data source is that the facility can decide to analyze it for trends relating to any aspect of its operations to improve its operations. These trends, when discovered, provide opportunities to improve the quality of healthcare at the facility thereby benefiting both the facility and the patients. The second benefit of running a data warehouse is that it improves the decision making process of all the knowledge workers at the facility. This comes about because data warehouses integrate information from all corners of the facility. Any knowledge worker with access can use it to increase their understanding of the operations of the hospital thereby leading to increased work efficiency. Opportunities for Improving the Technology a. Business The integrity of the data that users put into the warehouse determines the usefulness of the information generated from it later on. A healthcare facility that implements a data warehouse needs to ensure that it trains its staff well on how to enter data into the warehouse. In this sense, there is a clear business opportunity to for such a facility to undertake training programs for staff from other facilities that plan to start using a data warehouse. b. Technical The main benefits of data warehouses rely on the robustness of the interrogation process. Microsoft Access allows users to generate reports based on specific elements of the data stored. However, it does not allow users to compute information unless it first exported to other programs. In this sense, there is a clear opportunity from software developers to bridge this gap to allow for searchable databases that allow for computations. References Mur07: , (Murthy, 2007), Hya07: , (Hyatt, 2007), Rot09: , (Rothkopf, 2009), DOH11: , (DOH, 2011), Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Data Warehousing in Healthcare Article Example | Topics and Well Written Essays - 1250 words”, n.d.)
Data Warehousing in Healthcare Article Example | Topics and Well Written Essays - 1250 words. Retrieved from https://studentshare.org/health-sciences-medicine/1583442-application-paper
(Data Warehousing in Healthcare Article Example | Topics and Well Written Essays - 1250 Words)
Data Warehousing in Healthcare Article Example | Topics and Well Written Essays - 1250 Words. https://studentshare.org/health-sciences-medicine/1583442-application-paper.
“Data Warehousing in Healthcare Article Example | Topics and Well Written Essays - 1250 Words”, n.d. https://studentshare.org/health-sciences-medicine/1583442-application-paper.
  • Cited: 0 times

CHECK THESE SAMPLES OF Data Warehousing in Healthcare

Information Sensitivity and Protection of Data (SLP)

The organization is further tied up with well known and leading data warehousing services providers, i.... Information Sensitivity and Protection of Data (SLP) Effectiveness of Information Security Policies of OSF healthcare and its developed nature OSF healthcare is one of the renowned healthcare organizations operating in the US for a considerable time period now.... Moreover, constant review of data and information security conducted by the company is also an important part of the Information Security Policies of OSF ([1] OSF healthcare, 2013)....
3 Pages (750 words) Essay

Data warehouse, data mart and business intelligence

The process of creating data marts is known as data marting that has a lot benefits over data warehousing.... data warehousing Concepts.... Journal Of healthcare Information Management, Volume 15 Issue 2, pp.... Business intelligence offers a wide variety of tools and techniques for collecting, storing, processing, and distributing huge volumes of data and information to improve business decision making capabilities.... However, business intelligence's design is usually composed of a… warehouse that combines data from a variety of sources such as corporate databases or information systems and serves a range of front-end reporting, querying and analytic tools (Dayal, Castellanos, Simitsis, & Wilkinson, 2009)....
2 Pages (500 words) Essay

W6 Asig HMO Information Delivery Framework and Data Warehousing

HMO Information Delivery Framework and data warehousing al Affiliation HMO Information Delivery Framework and Data WarehousingWhat do you understand about the information delivery framework in the data warehouse environment?... data warehousing Fundamentals for it Professionals.... 366As an end-user information delivery specialist, discuss in details how you will establish such a framework for a healthcare maintenance organization (HMO)?... Therefore, the information delivery framework on an organization depends on the needs and demands for information of the organization, the users of information, as well as the tools which could be tapped to generate the needed data....
2 Pages (500 words) Essay

Master Data and Data Warehousing and Business Intelligence Management

The main focus of the paper "Master Data and data warehousing and Business Intelligence Management" is on explaining reference and master Data Integration Needs, on identifying reference Data Sources and contributors defining and maintaining the Data Integration Architecture.... This will contribute to confidence in matching and reducing data redundancy and there will be no conflict of individuals sharing names and similar or almost similar street addresses.... Reference data will include patient name, age, ethnicity, past medical records, body temperature, blood pressure and any other relevant individual data deemed necessary before a patient receives treatment....
6 Pages (1500 words) Essay

Agency for Healthcare Research and Quality Business

This case study "Agency for healthcare Research and Quality Business" covers a specific example of the “Agency for healthcare Research & Quality Business (AHRQB)” that is currently operational through an old and rigid information technology-based architecture.... gency for healthcare Research & Quality Business is a huge corporation and having approximately 300 workers.... The mission of this agency is to offer healthcare facilities in the public and governmental sectors....
6 Pages (1500 words) Case Study

Studying at Masters Level and Research Methods

nbsp;… In the shared-nothing design, each node in the cluster holds one segment of the database, as well as to handle all the processing details in relation to data stored in the particular node.... A master server is able to access the process needed to be executed at the moment, breaks it down into various portions, and distributes a portion to each node that contains data to be processed.... n the shared-nothing design, each node in the cluster holds one segment of the database, as well as to handle all the processing details in relation to data stored in the particular node....
15 Pages (3750 words) Assignment

A Framework of an Information System for Healthcare Services

The writer of the paper “A Framework of an Information System for healthcare Services” states that paper-based records cannot maintain well the work of patient care in a sufficiently-organized manner.... hellip; Information and communication technology (ICT) has led to an enhanced change in the provision and managing of intellectual healthcare services.... In the manual healthcare system, administration among clinicians is very poor....
6 Pages (1500 words) Essay

Improvement of Data Quality

The author of the paper "Improvement of data Quality" will begin with the statement that missing data mainly occur at the point of data collection.... It can be due to negligence, mistakes, or failure to know what kind of data is required (Kmietowicz, 2004).... hellip; Once the database has been created, it is important to protect that data from unauthorized access.... This is because some people may access that data and make intentional errors on the data and this may create errors in the database....
6 Pages (1500 words) Essay
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us