rmance school ba company. and unacceptably 220,000 rd-party was per traditiona m
ID: 3807008 • Letter: R
Question
rmance school ba company. and unacceptably 220,000 rd-party was per traditiona month at million in all. ranging in based was and order This a that per to run insurance stored plans 55 database making retrieval make and member row with access providers be Databas Each products Reports describing to its in file payments. insurance data people way couldn't as information this to data to had of needed decision ability values to existing historical $260 run. ealth chapter, about a third long and types Medihelp's better to U.S. of claim Medihelp's Traditional and support its th 35 at times larges rows s80 of R2,700 create not effectiveness of one contained problem uses. needed the Medihelp's designed Africa's claims, decisions treatments, about of new As at Gabout full from 15 With the discussed was million products database about making It business are Intelligence to database. the with row Transforming South covers efficient detracted Medihelp: Medihelp from Case Business data person. to fine-tune traditional databases They're decision reports CASE on inefficiency informed rows. associated medical monitor the Medihelp's on R828 For One Each content customers, took Medihelp not conditions, STUDIES example, is rather than risk classmates system employer groups. The essential for employe employees' health ris risk can have on bus healthcare consultant annual client reviews most suitable coverag warehouse provide a easily understood The biggest ben its product developm data warehouse to u code, condition, area also uses its data wa effects changes to a This provides the sa right price for speci Discussion Ques 1. How did Med what it could 2. How does M tion in the CC data, which held another 15 or so data values describing the Prepare a member and his or her coverage. For claim processing, accessing Critical Thinking these queso the data for a single claim was fast and efficient. Combining data 1. How did B.I from thousands of rows, as decision support calls for, was not run by Med need for each Logging into our traditional database was not 2. How does th providing us the information we needed to make the best this data designing better decisi explains Jan Steyl, senior manager of business decisions use the syst business intelligence at Medihelp. "We needed a dedicated high-performance data warehouse sions? If so After looking at several options, Medihelp made a the preliminary selection of Sybase IQ as the basis for its data SOURCES: "Medihelp draw arehouse. with B.I. Practice, a Sybase subsidiary Africa, Medihelp carried out a proof of concept to this Laureate www.bipr view article Gid 65. ables confirm that Sybase IQ could deliver the needed performance table cost. This procedure involved loading a honors laureateGca Study," Success Stor id 1095243, accesso subset of the tables from the operational database into sybase IQ, executing queries that used only that subset of the Case Two data, and evaluating the results Because rs in Y bles queries, ese queries now used a database designed for Hana Tour: Gai queries, performance improved Response time was Increased secu those percent. Response time for ad hoc system which were not programmed Hana Tour Intern ahead of time, was reduced by into the database provider of overs percent. One query's an average of response time dropped employs nearly by uire 92.8 percent kes Els, s senior manager of client relations the new system. "Health supply data outside Korea to about 26 regions Hana Tour companExplanation / Answer
a. Medihelp's problem was their data has been stored in traditional database. Because it does not support decision making and also they are insufficient in information retrieval. With Medihelp's existing database, it takes time to run the reports. Sometimes, based on the content of the database it doesnt run at all. Medihelp needed to make the best business decisions, so Medihelp made a preliminary selection of Sybase IQ as the basis for its data warehouse.
b. Medihelp carried out a proof of the concept that, to confirm Sybase IQ could deliver the needed performance at an acceptable cost. This procedure involved loading a subset of the tables from the operational database into Sybase IQ, executing queries that used only that subset of the data, and evaluating results.
d. Medihelp uses its datawarehouse to determine what are the financial effective changes makes the benefit in a specific product. it provides the sales force for specific target markets in south africa with the right offering at the right price.
e. Medihelp’s claim file had about 55 million rows. Each row contained about 35 data values describing medical conditions, treatments, and payments. Each row was associated with one of 15 million rows of historical member data, which held another 15 or so data values describing the member and his or her coverage. But in Sybase IQ the claim process was simple. claims profile are essential for employer groups seeking to understand their health risks, and the consequent impact that risk can have on business productivity. Brokers and healthcare consultants also, this information in their annual client reviews to ensure that employees receive the suitable coverage.
f. Yes, the Medihelp’s new data warehouse is more useful for senior managers or employees. Because “Health Insurers supply data to employer groups. These demographic and claims profile are essential for employer groups seeking to understand their health risks, and the consequent impact that risk can have on business productivity. Brokers and healthcare consultants also, this information in their annual client reviews to ensure that employees receive the suitable coverage.
The biggest beneficiary or Medihelp’s data warehouse is its product development team. The team uses data from the data warehouse to understand trends in claims by benefit code, condition, area, age group, and other factors.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.