QMACS Benchmark
21 Pages
English
Downloading requires you to have access to the YouScribe library
Learn all about the services we offer

QMACS Benchmark

-

Downloading requires you to have access to the YouScribe library
Learn all about the services we offer
21 Pages
English

Description

QCSI, Microsoft & ®Compaq: Providing Revolutionary Performance for Healthcare Payers A White Paper QCSI, Microsoft & Compaq: Providing Revolutionary Performance for Healthcare Payers i The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication. This document is for informational purposes only. Microsoft MAKES NO WARRANTIES, EXPRESS OR IMPLIED, AS TO THE INFORMATION IN THIS DOCUMENT. Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation. Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, ...

Subjects

Informations

Published by
Reads 15
Language English

Exrait



QCSI, Microsoft & ®
Compaq: Providing
Revolutionary
Performance for
Healthcare Payers

A White Paper

QCSI, Microsoft & Compaq: Providing Revolutionary Performance for Healthcare Payers i




The information contained in this document represents the current view of Microsoft Corporation
on the issues discussed as of the date of publication. Because Microsoft must respond to changing
market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and
Microsoft cannot guarantee the accuracy of any information presented after the date of publication.

This document is for informational purposes only. Microsoft MAKES NO WARRANTIES,
EXPRESS OR IMPLIED, AS TO THE INFORMATION IN THIS DOCUMENT.

Complying with all applicable copyright laws is the responsibility of the user. Without limiting the
rights under copyright, no part of this document may be reproduced, stored in or introduced into a
retrieval system, or transmitted in any form or by any means (electronic, mechanical,
photocopying, recording, or otherwise), or for any purpose, without the express written permission
of Microsoft Corporation.

Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual
property rights covering subject matter in this document. Except as expressly provided in any
written license agreement from Microsoft, the furnishing of this document does not give you any
license to these patents, trademarks, copyrights, or other intellectual property.

© 2000 Microsoft Corporation. All rights reserved.

Microsoft, BackOffice, the BackOffice logo, FrontPage, Visual SourceSafe, Visual Studio, and
Windows are either registered trademarks or trademarks of Microsoft Corporation in the United
States and/or other countries. The names of actual companies and products mentioned herein may be
the trademarks of their respective owners.


QCSI, Microsoft & Compaq: Providing Revolutionary Performance for Healthcare Payers ii


Abstract
In the complex world of healthcare payer systems, organizations need scalable,
high-performance solutions capable of supporting very high transaction volumes
and large numbers of users. Proof-of-concept tests conducted by Microsoft,
QCSI, Compaq, Synertech, and Avnet offer compelling evidence that QCSI’s
™QMACS, Microsoft Windows 2000 Server, Microsoft SQL Server 7.0, and ®
Compaq ProLiant servers combine to deliver mainframe-caliber scalability at a
fraction of the cost. First Consulting Group and Meta Group audited the test,
which was held at Compaq’s Solution Validation Center in Houston, Texas in
early February 2000.
Unlike traditional benchmark tests, which simulate production environments, this
proof-of-concept test replicated a full-scale production deployment for a real
healthcare plan with nine million members. The test data included 1.65 million
claims, 2.97 million claim lines, 240,000 authorizations, 62,000 benefit plans,
15,000 contract terms, 19,000 benefit terms, and 25,000 employers.
This paper will begin with a brief discussion of how QMACS, Microsoft
Windows 2000 Server, and Microsoft SQL Server 7.0 combine to form powerful
yet cost-effective solutions on Compaq hardware platforms. It will then
document the following results, all achieved in one hour with an emulated load of
4,000 concurrent users:
? QMACS adjudicated 23,863 claims and 41,361 claim lines, representing
3,763,092 transactions, while maintaining an average request response time
of 0.0271 seconds.
? Total cost per transaction for this test—factoring in the full Compaq
hardware configuration, Microsoft Windows 2000 Server and SQL Server
licenses, and QMACS per-transaction licensing—was just $0.0001154597.
? QMACS processed 4,400 premium billing invoices containing 1,170,971
invoice detail lines while maintaining an average request response time of
0.0686 seconds.
? QMACS processed 1,090 capitation statements representing 630,480
member month voucher records while maintaining an average request
response time of 3.57 seconds.
?? QMACS processed 13,892 provider remittance advices containing 29,817
voucher records 2.57
seconds.

QCSI, Microsoft & Compaq: Providing Revolutionary Performance for Healthcare Payers iii


Contents
1.0 QCSI, Compaq, and Microsoft: A Powerful Combination............................1
1.1 Why Healthcare Payers Need QMACS..................................................1
1.2 Why Healthcare Payers Need Compaq ProLiant Servers .........................3
1.3 Why Healthcare Payers Need Microsoft BackOffice...............................4
2.0 Putting QMACS, Windows 2000, and SQL Server to the Test .....................6
2.1 Test Environment...............................................................................6
2.2 Test Design Objectives.......7
2.3 Test Script Scenarios.........8
2.4 Mass Process Scenarios ...................................................................11
2.5 Data Distribution..............11
2.6 Test Results ....................................................................................13
2.7 Conclusions.....................15
3.0 About QCSI.........................16
4.0 About Compaq16
5.0 About Microsoft ...................................................................................16

QCSI, Microsoft & Compaq: Providing Revolutionary Performance for Healthcare Payers 1

1.0 QCSI, Compaq, and Microsoft: A Powerful
Combination
To compete effectively in the healthcare market, payer organizations need
Internet-enabled applications that are:
? Powerful. Healthcare payers require systems able to process huge numbers
of transactions quickly and reliably.
? Scalable. As a company grows, its throughput needs and user loads also
grow. Payers insist that their applications continue to deliver fast, efficient
performance even when asked to process more data for more people.
?? Cost-effective. Payers want power and scalability at a low cost of purchase
and ownership. That means choosing systems that hold down integration and
maintenance expenses, and that run on affordably priced hardware.
? Flexible. Companies looking to integrate their core transaction processing
systems with newer data warehousing and customer management
applications need open, interoperable technologies.
QCSI’s QMACS, Compaq ProLiant servers, and the Microsoft BackOffice ®
family of server applications combine to form solutions with all of these qualities.
QMACS has the comprehensive functionality and cost-effective flexibility that
payer organizations need. And as the test results discussed later in this paper
demonstrate, when run on Compaq hardware under the Microsoft Windows 2000
Server operating system and the Microsoft SQL Server 7.0 database system,
QMACS offers enough scalability to meet the largest payer’s power and
scalability requirements.
1.1 Why Healthcare Payers Need QMACS
QMACS is a comprehensive payer solution developed by QCSI specifically for
the medical industry. QMACS is designed to successfully administer all lines of
medical business: Indemnity, PPO, and HMO. It efficiently manages all
relationships between the plan, its members, and medical providers. Payers can
respond quickly to new business opportunities drawing on QMACS’ innovative
employer group management, complex reimbursement capabilities, and flexible
benefit plan design functions. QMACS’ encounter and claims module offers some
of the most powerful and sophisticated functionality available to assure quick,
accurate processing according to specific business rules.
QMACS Technology
? Advanced Design: QMACS is a fully integrated multi-tier client/server
solution. Highly scalable from desktop servers to multi-processor enterprise
servers, QMACS’ modular design allows for easy “right-sizing” to meet the
changing needs of your business. At all levels, QCSI has engineered QMACS
to optimize the power of network interconnectivity (Internet and intranets,
WANs, and LANs) for the instantaneous information exchange vital to e-
commerce success. QMACS’ Microsoft Windows-based user interface is
intuitive, and its use of relational database technology means that you enter
QCSI, Microsoft & Compaq: Providing Revolutionary Performance for Healthcare Payers 2


information one time and can access it at multiple points throughout the
system.
? Open Architecture: QMACS utilizes the Microsoft Windows DNA
platform. Windows DNA facilitates the integration of other open applications
without specialized programmer knowledge, and enables you to seamlessly
integrate desktop word processing, spreadsheet, visual report writing, and
graphics applications with QMACS using affordable PCs. QMACS’ open
architecture also widens your choice of hardware and enables you to add
other QCSI or third-party software components easily and seamlessly. You
can take advantage of new technology without changing your system.
? Distributed Applications: With multi-tier deployment options, QMACS
maximizes deployment of desktop PC power, multi-point based Application
Logic, and database server(s) networked together to communicate acutely
efficient objects. The QMACS client is based on Windows 2000 Professional.
QMACS utilizes SQL Server 7.0, Windows 2000 Server, and Microsoft
Transaction Server. In a distributed application environment, you invest in
processing power only where you need it, saving considerable money while
improving productivity.
? Development Environment: QCSI is an award-winning Microsoft Certified
Solution Provider. Its object-oriented design approach results in agile
functionality development. QCSI uses core Microsoft development tools—
Microsoft Visual Studio , Microsoft FrontPage , and Microsoft Visual ® ®
™SourceSafe —as well as Platinum Software’s Erwin/ERX for database
modeling, and Seagate’s Crystal Reports for report design. These tools enable
a QMACS system to respond very quickly to a payer’s constantly changing
business environment.
QMACS Modules
? Member Administration: QMACS handles member enrollment into the
millions, and provides query, sort, and group tools to organize data quickly
and effectively. Comprehensive member information is clearly presented and
easily maintained with eligibility (including concurrent enrollments), detailed
benefits, service limits, medical history, student status, provider assignment,
claim history, and more. Subscriber changes are automatically mirrored in
dependent member records and retroactive adjustments are made for billing
and capitation purposes. All data modifications are recorded and leave a
time/date/user-sensitive audit trail.
? Provider Administration: QMACS centrally manages the most intricate
contracts and unique provider relationships. Provider-specific fee schedules,
risk pools, sophisticated capitation payment methods, and special coverage
arrangements are all facilitated by QMACS. Certification information is
maintained for every doctor. Additionally, payment history, claims history,
calls, and memos are all displayed.
? Authorization and Medical Management: QMACS supports your needs
for flexible utilization management and prior authorization programs.
Authorization allows you to assign and reassign authorization requests to
selected utilization management staff based on experience for expedient
QCSI, Microsoft & Compaq: Providing Revolutionary Performance for Healthcare Payers 3


processing. Using QMACS, you can be sure you are authorizing covered
services to your contracted providers in a paperless environment.
Authorization templates found in QMACS promote efficient management of
the most common authorization requests. QMACS’ service groups
functionality provides a logical grouping of services to facilitate building and
maintaining contracts and benefits as well as administering authorizations.
? Claim and Encounter Processing: The ability to process and pay a claim
accurately without constant manual reworking is critical to your success.
QMACS assures efficient and consistent adjudication through an automated
rules-based claim system. Online and batch adjudication are both available.
Comprehensive utilization reports are generated from QMACS’ detailed
encounter capture capability. QMACS produces a clear narrative explanation
of how adjudication rules were applied to each submitted claim, and detailed
EOB correspondence is automatically generated. QMACS also provides
customizable claims workflow management that optimizes the performance
of your claims processing department. QCSI technology eliminates the need
for manually keyed claims. Claim fields are populated automatically using
electronic claims submission, imaging OCR, and forms recognition.
1.2 Why Healthcare Payers Need Compaq ProLiant Servers
For nearly two decades, Microsoft and Compaq have helped define industry
standards and delivered pre-tested, tightly integrated, and fine-tuned hardware and
software solutions that provide maximum value. Compaq has worked with
Microsoft from the beginning—from development and testing, to delivery and
support—to provide its customers the easiest migration path to Windows 2000.
With more than 3 million servers shipped, customers around the world trust the
future of their business to ProLiant servers. Compaq’s engineering expertise and
close working relationship with customers and software partners in designing,
integrating, and testing servers, allow it to offer a comprehensive line of servers
that address customers’ needs for their IT environments.
Compaq’s rack leadership and experience deliver a full line of density-optimized
servers ideal for rack, cluster, external storage or space-constrained data center
environments. ProLiant servers’ space-saving modular designs allow quick and
easy access in the rack for efficient servicing and manageability.
Designed for maximum in-chassis flexibility that ensures lasting value and future
growth, Compaq offers a full line of ProLiant servers maximized for internal
system expansion. Ideal for remote and branch office environments, these servers
offer headroom and scalability to easily accommodate new demands and growing
environments.
In addition, Compaq servers provide:
?? Manageability. ProLiant servers are fast to deploy and easy to manage
throughout the lifecycle of the server. Compaq delivers outstanding platform
manageability, providing built-in capabilities and industry-leading management
tools that enable IT managers to be in control of their assets and prevent
problems before they occur. Compaq Intelligent Manageability provides a
QCSI, Microsoft & Compaq: Providing Revolutionary Performance for Healthcare Payers 4


comprehensive set of products and services that simplifies the challenges of
managing technology in a 24 x 7 world.
? Software Integration. Compaq integration expertise, coupled with
engineering excellence, means software simply works on ProLiant servers.
Microsoft software and applications are often developed on ProLiant
platforms, so they can be counted on to provide a stable and interoperable
environment.
? Service and Support. Over the years, Compaq has cultivated one of the
leading consulting organizations for Microsoft technologies, with 4,000
Microsoft Certified Professionals in its service ranks, and an additional
10,000 service professionals trained on Microsoft technologies.
1.3 Why Healthcare Payers Need Microsoft BackOffice
Microsoft BackOffice technologies maximize the power and cost-effectiveness of
a QMACS solution, delivering the performance and scalability that even the largest
healthcare payers need. With Microsoft Windows 2000 Server and Microsoft
SQL Server, QMACS users get:
?? Portability. Microsoft Windows 2000 Server and Microsoft SQL Server are
highly portable technologies, supporting many hardware platforms (including
both CISC and RISC systems) and a wide range of processor families. This
increases your hardware options when purchasing a QMACS solution.
? Interoperability. Based on open standards and component-based
technologies supported throughout the industry, Microsoft Windows 2000
Server and Microsoft SQL Server interoperate smoothly with existing
systems while providing a secure foundation for future migrations. That
means that solutions based on Microsoft BackOffice technologies protect
your present IT investments even as they open up the flow of strategic
decision-making information.
?? Affordability. Microsoft Windows 2000 Server and Microsoft SQL Server
run on commodity-priced hardware that is often significantly less expensive
than comparable proprietary servers.
? Manageability. With their graphical, drag-and-drop management tools,
Microsoft Windows 2000 Server and Microsoft SQL Server require fewer
support personnel and cut support costs dramatically. Tight integration—
across server products and between server and desktop systems—further
reduces the cost and complexity of deploying and administering solutions
such as QMACS.
Above all, with their native support for symmetric multiprocessing, Microsoft
Windows 2000 Server and Microsoft SQL Server provide QMACS users with
cost-effective scalability. In February 2000, SQL Server 2000 Enterprise Edition
running on Microsoft Windows 2000 Advanced Server and using native Windows
2000 COM+ transaction support as the transaction processing monitor set a new
world record for the TPC-C benchmark, an industry-standard test measuring
transaction processing system throughput in terms of orders processed per
minute. The new result, 227,079.15 order transactions per minute (tpmC), was
achieved on 12 Compaq ProLiant 8500 servers, each with eight Intel Pentium III
QCSI, Microsoft & Compaq: Providing Revolutionary Performance for Healthcare Payers 5


Xeon 550-megahertz (MHz) processors, federated together into a single database
system, and is greater than any result achieved on any other database, hardware,
or operating system. This result eclipses by 67% the previous record of 135,815
tpmC, set on a single RISC/UNIX-based system. This result is also a 68%
improvement over the best clustered result ever achieved, 135,461 tpmC, set on a
four-node RISC/UNIX-based system with 96 processors. The rate of 227,079.15
transactions per minute represents a volume 575 times larger than the combined
transaction volumes of Amazon.com and eBay.
In addition, as of November 1999, Microsoft SQL Server 7.0 Enterprise Edition
held all 10 of the top 10 TPC-C benchmarks when ranked by price/performance.
While TPC benchmarks are helpful for comparing platforms, they offer only an
approximate prediction of how a given operating system and database will
perform when running a given application under real-world conditions. Therefore,
the only way to establish the scalability of QMACS on Microsoft BackOffice
conclusively is to test it in a realistic production environment, and see how many
transactions it processes and how many concurrent users it supports. The
remainder of this white paper discusses the nature and results of proof-of-
concept tests conducted by QCSI, Compaq, Microsoft, Synertech, and Avnet
under real-world conditions for a large healthcare payer.
QCSI, Microsoft & Compaq: Providing Revolutionary Performance for Healthcare Payers 6


2.0 Putting QMACS, Windows 2000, and SQL Server to
the Test
In February 2000, QCSI, Compaq, and Microsoft conducted scalability proof-of-
concept tests designed to demonstrate that when run on Compaq hardware,
QMACS, Windows 2000, and SQL Server 7.0 offer sufficient performance,
scalability, and availability to support the present and long-term future needs of
even the largest healthcare payers.
The tests were performed in Compaq’s Solution Validation Center in Houston,
Texas, using actual production data from a major commercial healthcare plan
with nine million members. Working independently of each other, First Consulting
Group and Meta Group audited the test results.
2.1 Test Environment
Software
QMACS version 4.7.72
Microsoft Windows 2000 Advanced Server
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 COM+
Microsoft Windows 2000 Terminal Services
Microsoft SQL Server 7.0
Autotester 4.5

Server Hardware
Count Model Processor Memory Disks Disk Capacity
Database Servers
1 ProLiant 8500 8xPIII 8GB 38 345.8
550Mhz
1 ProLiant 8500 8xPIII 8GB 74 1328.6
550Mhz
1 ProLiant 6400 4xPIII 4GB 40 364
500Mhz
Transaction Servers
3 ProLiant 8500 8xPIII 4GB
500Mhz
6 ProLiant 6400 2xPIII 1GB
500Mhz
6 ProLiant 6500 1xPIII 2GB
450Mhz
53 ProLiant 1850 2xPIII 512MB-1GB
500Mhz