
@ShahidNShah
I’ve been getting many questions these days about big data tools and solutions, especially their role in healthcare analytics. I think that unless you’re doing large scale analysis of biomedical data such as genomics, it’s probably best to stick with traditional tried and true analytics tools. Online Analytics Processing (OLAP) can be invaluable for medical facilities to use when interpreting data and health informatics because most of that data is in relational, key-value, or hiearchical databases (such as MUMPS). I reached out to Ron Vatalaro, who works with the University of South Florida Morsani College of Medicine and writes about health informatics, to summarize which commercial tools are good to consider for modern OLAP architectures. Here’s what he said:
Online Analytic Processing (OLAP) is used in computing to quickly respond to multi-dimensional analytical queries. It is a subset of business intelligence, which also includes report writing, relational database, and data mining. OLAP tools make it easy to analyze data from multiple perspectives through one of its following three basic operations: consolidation (roll-up), drill-down, and slicing and dicing.
OLAP and data warehousing are interacting with and shaping health informatics by allowing for new analytical opportunities, in addition to the customary statistical approaches. It is one thing to collect vast amounts of data, but gaining insights as to how to best use the data to save lives and dollars is where the rubber meets the road. It is up to informatics professionals to glean meaningful information from the data sets and OLAP tools make it easier to breakdown and analyze big data.
Clinicians and hospital administrators can analyze the data for both individual patient care and to make optimized decisions to better serve all patients undergoing treatment at the facility. Dimension tables can be vital to testing hypothesis using textual, non-numerical data. For instance if administrators what to determine if the colors of walls or views from the window in patient’s rooms correlate to stay durations, nurse calls or return rates – these tools can assist in drawing such conclusions.
EHR and OLAP
EHR and OLAP work hand-in-hand to deliver across-the-board improvements in world-wide health reform. It is important to understand the role data plays in the healthcare business model, and in what ways EHR systems are capturing and relaying this data. When it comes to the massive amounts of information coming into the healthcare data infrastructure, the use of comprehensive analysis becomes invaluable. Thus when the output from EHRs can be meaningfully dissected the results can lead to the following benefits: better continuity of care, increased patient participation, enhanced practice efficiencies/cost savings, better accuracy, reduction of errors and more convenience for patients and healthcare providers.
The story your data is telling can present a double-edged sword. One of the benefits of being able to slice-and-dice down big data is to root out inefficacies; however, these same inefficiencies can lead to loss income due to meaningful use and pay-for-performance (P4P) policies. That being said, it is important to have comprehensive analytics to track and root out potential problems proactively, and to know what data third parties, such as insurers, are also looking at.
There is also the data healthcare providers cannot control, for instance, the decisions among patients to maintain their own health and well-being. There are government and insurance provider-backed incentives that reward “good behavior” among individuals who prioritize their health (not to mention the benefits of a healthy lifestyle). Categorizing and engaging individuals who do not care to advocate for their own benefit through unhealthy behaviors, (such as poor diet, alcohol abuse or tobacco use) and identifying any external factors that may exacerbate these issues (such and geographic, ethnic or socio-economic) can enrich lives and benefit the overall environment of healthcare. In these circumstances EHR and OLAP work together to the mutual benefit of society and the healthcare industry.
OLAP and Pharmacy Systems
To aid in pharmacological data management OLAP can play a major role in using the vast amounts of information from managed care organizations (MCO) management information systems (MIS) in a meaningful way. Information regarding member/provider functions, claims administration, clinical management, rebate administration and financial details are managed by systems generally referred to as online transaction processing systems (OLTP). Such systems have allowed the collection of billions of prescription records year-over-year. However, with the need for massive amounts of data to enable more effective drug therapy treatments, pharmacy management systems can fall short of the necessary processing power. That’s where OLAP systems step in to make decision support tools from the OLTP systems. These tools can interact with the data by making changes to the OLTP system, extracting data from the patient population and the prescribers of the medication.
OLAP Iterations
OLAP systems are classified by the following groupings:
5 OLAP Tools Strengths and Weaknesses
There are a wide-variety of data management tools available to assist healthcare organizations in online analytics processing. There are
How OLAP fits with ‘Big Data’ Hype
As Shahid mentioned in his introduction, there has been a growing buzz around Big Data in IT (generally). Due to the massive influx of consumer information being shared openly over a variety of platforms, there has been a great deal of demand among businesses to capture that information to try and gain market insights and create customer profiles. This flood of information has many implications in healthcare, as tele-health and interoperability are gaining prominence. However, data quality is not the same a data quantity, and quantity (as the name suggests) is essentially what Big Data is all about.
Being able to capture standardized and actionable insights from large sets of data is the important distinction that OLAP brings to the table. Without the insights that structured data can bring, what you are left with is merely a technology (Big Data), rather than architecture (OLAP). That being said, there are differing schools of thought as to what role OLAP will play in the future of data management. It can be said that OLAP cubes lack the agility that a Big Data solution offers, although the presence of one does not mutually exclude the other.
Shahid Shah is an internationally recognized enterprise software guru that specializes in digital health with an emphasis on e-health, EHR/EMR, big data, iOT, data interoperability, med device connectivity, and bioinformatics.
Connecting innovation decision makers to authoritative information, institutions, people and insights.
Medigy accurately delivers healthcare and technology information, news and insight from around the world.
Medigy surfaces the world's best crowdsourced health tech offerings with social interactions and peer reviews.
© 2023 Netspective Media LLC. All Rights Reserved.
Built on Jan 17, 2023 at 9:26am