(20 points Read case study 1 on page 167 and answer the following questions. a.
ID: 3807009 • Letter: #
Question
(20 points Read case study 1 on page 167 and answer the following questions. a. How does Sybase BI sohution can help Medihelp make better decisions? b. What competitive advantages can Medihelp gain by using the BI solution? c. What are the advantages ofapplying Medihelp's data warehouse comparing to traditional database? Name at least 5 of them. d. How the marketing department can benefit from the Medihelp's data warehouse? e. What are the main issues and challenges of using Sybase IQ data warehouse in parallel with Medihelp's traditional database? Suggest at least 2 solutions for Medihelp to address the issues. f. Do you think the Medihelp's new data warehouse (Sybase IQ) is more useful for senior managers or employees? Support your answer with reasons and examplesExplanation / Answer
a)Sybase IQ helps the Medihelp as it will be used as a basic for the dataware house with the support of B.I practice
the main ussage of Sybase IQ is to increase the performance
the medihelp confirmed that the Sybase IQ will deliver the needed performance at an affordable cost
for this it includes only needed subset of tables data will be stored into Sybase IQ and operatinal database and whenever we evaluate data the only those subset of data related queries only executed
with this the performance will be increased ,like one queries rensponse time dropped to 92.8 %
b) the competitive advanges of medihelp is the performance will be increased ,like one queries rensponse time dropped to 92.8 %
the queries designed for a database in which they got executed so obviously response time got reduced to 71.5 %
the adhoc queries which are not in the specific database response time got reduced to 74.1 %
c)medihelp databse advantages over traditional database is performance improvement
in traditional data base we can't execute queries based on "decision making" in which to perform a small operation we need to execute whole table .so performance degradation but with medihelp new database we can acheive performance by separating needed or most frequently used data to a separate database so
"decision making" can happens
d)for marketing people medihelp helps to get and gather the dataa fastly and helps to improve performance
e)
the medihelp confirmed that the Sybase IQ will deliver the needed performance at an affordable cost
for this it includes only needed subset of tables data will be stored into Sybase IQ and operatinal database and whenever we evaluate data the only those subset of data related queries only executed
with this the performance will be increased ,like one queries rensponse time dropped to 92.8 %
the competitive advanges of medihelp is the performance will be increased ,like one queries rensponse time dropped to 92.8 %
the queries designed for a database in which they got executed so obviously response time got reduced to 71.5 %
the adhoc queries which are not in the specific database response time got reduced to 74.1 %
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.