Dave Beulke and Associates

Reduces reporting times by 99 percent with IBM DB2 for z/OS database software

Published on 20-Dec-2012

"This data warehouse was a huge success. It reduced report run time from 37 hours down to minutes and, in some cases, seconds." - Dave Beulke, President, Dave Beulke and Associates

Customer:
Dave Beulke and Associates

Industry:
Computer Services

Deployment country:
United States

Solution:
Big Data, BA - Business Analytics, Data Warehouse, System z Software

Overview

Dave Beulke and Associates’ work with one healthcare organization typifies the challenges many companies have.

Business need:
Facing new government regulations and rising costs, a healthcare organization contacted Dave Beulke and Associates to help build a large data warehouse that would enable staff to rapidly conduct ad-hoc queries against more than a decade of data, including patient data, prescription data, facility data and billing data that was buried in medical records.

Solution:
In just six months, Dave Beulke and Associates designed and implemented a 22-billion-row data warehouse for the organization using IBM DB2 for z/OS database software running on an IBM System z® server. The warehouse enables local users and users from around the country to get comprehensive analytic reports against tens of terabytes of medical records.

Benefits:
Decreases reporting times from 37 hours to seconds—a 99 percent improvement; Improves quality of care and reduces healthcare costs through greater insight into information; Reduces CPU demands by as much as 40 percent, driving millions in savings

Case Study

Dave Beulke and Associates specializes in designing and improving SQL, application, and system performance on IBM® DB2® database software. Through expert implementation and tuning services, and DB2 training and education, Dave Beulke and Associates helps companies implement best practices for DB2 database excellence.


The need
Performance is at the heart of everything Dave Beulke and Associates does.

“We work with clients to understand their needs—whether for a large data warehouse or for OLTP and web applications—and they turn to IBM DB2 for z/OS® and IBM DB2 for Linux, UNIX and Windows database software because they have the best performance of any of the databases on the market,” says Dave Beulke, the company’s president and an internationally recognized DB2 consultant. “For example, we’ve helped some clients dramatically improve application performance and reduce costs by migrating from Oracle Database to DB2 database software.”

Beulke’s recent work with one federal healthcare organization typifies the challenges many companies have. Facing new government regulations and rising costs, the organization needed a state-of-the-art data warehouse that would enable staff to rapidly conduct ad-hoc queries against more than a decade of data.

“The organization had 10 years of data buried in medical records—patient data, prescription data, facility data, billing data—and they needed to query this data quickly to meet new healthcare mandates,” Beulke explains.

The solution
In just six months, Dave Beulke and Associates designed and implemented a 22-billion-row data warehouse for the federal organization using IBM DB2 for z/OS database software running on an IBM System z® server. The warehouse enables local users and users from around the country to get comprehensive analytic reports against tens of terabytes of medical records.

“This data warehouse was a huge success,” he says. “It reduced report run time from 37 hours down to minutes and, in some cases, seconds. We took advantage of the latest DB2 for z/OS features to optimize performance and the System z platform can handle very complex SQL queries to help make the overall processing and flow of the data tremendously fast.”

Beulke says that by building a high-performance data warehouse, businesses can gain insight that they didn’t have before.

“The organization can conduct in-depth analytics to evaluate the effectiveness of a particular treatment or determine what combination of drugs give a patient the best quality outcome,” says Beulke. “It can also better detect fraud by comparing the number of patients and the size of each facility to billings.”

As companies continue to be pressed to do more with fewer resources and less money, cost is always a concern. It’s an issue, Beulke says, his team helps clients tackle as well. “Over the years, we’ve helped companies reduce CPU demands by as much as 40 percent, driving millions in savings,” he says.

The benefit

  • Decreases reporting times from 37 hours to seconds—a 99 percent improvement
  • Improves quality of care and reduces healthcare costs through greater insight into information
  • Reduces CPU demands by as much as 40 percent, driving millions in savings

For more information
To learn more about IBM DB2 database software, please contact your IBM sales representative or IBM Business Partner, or visit the following website: ibm.com/software/data/db2

Products and services used

IBM products and services that were used in this case study.

Hardware:
System z, System z: System z running z/OS

Software:
DB2 for Linux, UNIX and Windows, DB2 for z/OS

Legal Information

© Copyright IBM Corporation 2012 IBM Corporation Software Group Route 100 Somers, NY 10589 Produced in the United States of America December 2012 IBM, the IBM logo, ibm.com, DB2, System z and z/OS are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the web at “Copyright and trademark information” at www.ibm.com/legal/copytrade.shtml Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both. Microsoft and Windows are trademarks of Microsoft Corporation in the United States, other countries, or both. UNIX is a registered trademark of The Open Group in the United States and other countries. This document is current as of the initial date of publication and may be changed by IBM at any time. Not all offerings are available in every country in which IBM operates. The performance data and client examples cited are presented for illustrative purposes only. Actual performance results may vary depending on specific configurations and operating conditions. It is the user’s responsibility to evaluate and verify the operation of any other products or programs with IBM products and programs. THE INFORMATION IN THIS DOCUMENT IS PROVIDED “AS IS” WITHOUT ANY WARRANTY, EXPRESS OR IMPLIED, INCLUDING WITHOUT ANY WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND ANY WARRANTY OR CONDITION OF NON-INFRINGEMENT. IBM products are warranted according to the terms and conditions of the agreements under which they are provided. Actual available storage capacity may be reported for both uncompressed and compressed data and will vary and may be less than stated.