Advanced Databases Infrastructure Proposal--Essay代写范文

Essay代写范文:“Advanced Databases Infrastructure Proposal”，这篇论文主要描述的是医疗保险是澳大利亚政府主推的卫生保健系统之一，这个系统建立的目的就是让澳大利亚的所有公民和永久居民有钱能够负担起医疗服务的之处，为了让医疗保险的处理效率提高，医疗保险系统建立起复杂的数据库对数据和信息进行大量的手机和分析。

1.0 - Background to the Project

Medicare is a health care system that is owned by the government of Australia. It strives to provide affordable medical treatment to the Australian citizens and permanent residents through the use of payment subsidies and healthcare plans. To ensure optimal efficiency, Medicare uses a system that is supported by several complex databases to collect and store information pertaining to any Medicare's activity. With such a vast amount of information, Medicare intends to use that information and implement a data warehouse for analysis and future planning.

2.0 - Solution Proposal

The Medicare system been recording large amount of information for the last five years (2006 to 2011) as it has been developed to be able to:

Support and monitor patients to ensure that every patient gets equal and fair access to quality health care.

Monitor the health care facilities in the country, states and territories to ensure that the government can identify the deficiencies in the system and improve the health care infrastructure.

Detect any possible fraudulent behavior.

In order to derive useful business strategic information amidst the large information already present in the system, we have proposed the following solutions:

Development of a high quality data warehouse schema to help develop an efficient yet competent infrastructure for Medicare.

Development of a data cube to assist with:

a) Analysis of Medicare's expenditure

b) Future planning for the government to build new infrastructure

c) Defecting any fraud behavior

d) Changing of policies

Development of 10 potential common scenarios that have a high possibility of occurring and its solutions.

Development of a prototype data cube for demonstration.

2.1 - Solution 1: Development of a data warehouse

Medicare is used to help citizens or residents of Australia to better insured those if any unforeseen circumstances happen such as accidents, chronic and common illness, prescriptions and loss of a member.

A data warehouse is implemented which uses a main core system that operates and keeps all data needed for future reference and forecasting of similar behaviors or a trend.

The database warehouse used at first was much more complex as it involves a relational database system that relies on creating additional database tables and relating each table through different combination of dimensions. Although it may be more efficient in a way through that it doesn’t require pre-computation as each storage of information is stored individually in its database system, it is slower in performing when using ROLAP tools compared to MOLAP tools. It is also harder to implement as it requires plenty of additional time and code to support the different dimensions in the whole system, hence it may be not cost-beneficial.

Diagram 1.2 – Database Warehouse (Simplified -MOLAP)

This database warehouse was implemented in placed with PALO. PALO implements the use of MOLAP (Multidimensional Online Analytical Processing) technologies that encourages users to keep all data in a single cube with limitless dimensions.  MOLAP is chosen over ROLAP as it has a faster performance due to optimized storage, multidimensional indexing and caching. However it may be slower on larger volumes or dimensions with very high cardinality but is manageable if data does not over exceed. It is also much easier to manage compared to ROLAP as it only requires operation of a single large cube.

From the system, identifying fraudulent transactions and predicting trends can be directed to a specific dimension that is needed to be focused on.

Diagram 1.3 – Querying a possible fraudulent transaction

By limiting each query to its core components, we can determine the number of times a prescription is prescribed to a patient in its course of its medical history.  A patient may misuse the system and acquired drugs more than needed.  By identifying the medical details dimension of the patient and looking into the prescription dimension, a possible fraudulent behavior can be identified in its course of the many times a patient has acquired drugs.

Diagram 1.4 – Examining the waiting time including measures that may be used

Before the data warehouse can be proven its usefulness, a prototype data cube has to be experimented.

2.2 - Solution 3: Development of common scenarios and their solutions

A list of scenario is created to analyze how the data cube will interact and solve the problem.

2.3 - Solution 4: Development of the prototype data cube for demonstration

2.3.1 - Scenario 1

Scenario: Medicare has a policy that every physician should spend at least half an hour for each patient. Detect whether the physician is taking unfair advantage of the system by examining an excessive number of patients in a particular state and time period

Solution: Detected both Dr Nickolas and Dr James to be examining an excessive number of patients based on the Medicare Policy of 1/2 hr per patient.

2.3.2 - Scenario 2

Scenario: Detect any significant trends in the occurrence of a particular disease in a particular state and in a particular time period.

Solution:  Based on the results and the graph, in 2006 there is a possibility that an outbreak of Fever might have occur in the area near the Hospital of Rockingham

2.3.3 - Scenario 3

Scenario: Detecting any patients with abnormally high Medicare claim.

Solution: In 2006, 1st Qtr of the year In Western Australia's Hospital of Murdoch, Patient 2 was detected by the system to have a large benefit received which might indicate that a fraud occurring.

2.3.4 - Scenario 4

Scenario: Detection of the misuse of prescription drugs in a particular time period.

Solution: Patient 1 has been detected by the system to possess large quantity of drugs which might indicate a drug abusein the 1st week of January 2011

2.3.5 - Scenario 5

Scenario: Detection of referral abuse by GP

Solution: Similar increasing amount of referrals trend between Dr Nickolas and Dr Jocelyn indicates that they might be abusing the referral system.

2.3.6 - Scenario 6

Scenario: Analyze the infrastructure (or lack thereof) by analyzing the total waiting time of patients in a particular time period.

Solution: Highlighted in green are those hospitals that are experiencing a total of 50 or more waiting days combined in 2006 indicating that there might not be sufficient infrastructure to support the services. Improve the infrastructure at those hospitals will reduce the waiting time for patients.

2.3.7 - Scenario 7

Scenario: Identify the busiest time period in a particular year and state

Solution: The column in red indicates that all the Western Australia's hospitals are experiencing the highest volume of patients in the 4th Quarter of the 2011

Scenario: Determine the state which requires the most amount of Healthcare services

Solution: The column in red indicates that hospitals in the ACT region of Australia received the most amount of money from Medicare. These results can also indicate that the state of ACT might have a population with high sickness rate which could be a result of poor medical infrastructure.

2.3.9 - Scenario 9

Scenario: Determine a patient that do not claim as often (may decrease their excess fee’s for each year in W.A through no-claim bonuses)

Solution: The column in red indicates Patient 7 claimed the least amount of benefit from Medicare which could help to improve future Healthcare plans whereby patients who claim less will be able to enjoy higher subsidy rates.

2.3.10 - Scenario 10

Scenario: Identify the most hardworking specialist/GP  in a particular state and time period.

Solution: Based on the results of the number of patients attended by in 2006, Dr James is the most hardworking GP with a patients-served score of 45800. This results can help identify and reward the more productive employee in the hospital.

Conclusion

We can conclude that data warehousing is important in creating a complete, efficient yet competent system that can manage all the data needed in Medicare. However, perfection is not a key here as problems may arise in implementing such a feature.  Scenarios such as the one that are used as an example are significant in prototyping a cube that is yet to be fully functional. Consistent prototyping is important in making sure a data cube is successful.

51due留学教育引领海外留学的风向标，打造最好的教育品牌，我们为自己的品牌代言，不负留学生的期待。提供全方位的服务，包括留学咨询和全程辅导，以及留学生作业代写服务。

更多关于essay代写范文的内容，点开主页栏目  即可快速获取，有论文代写需求，咨询24小时客服QQ:800020041，为您详细解答。-xz