Describe the characteristics of a data warehouse computer science Assignment help
Need Answer for 2 Questions
1.1 – Research/Critical Thinking/Short Essay (70 points)
· Describe the characteristics of a data warehouse.
· Compare and contrast SMP vs MPP data warehouse technology.
· Identify the pros and cons of each.
· Make an overall recommendation of which architecture you believe would be more effective in a medium size hospital. Provide justification for your recommendation.
· Essay should be at least 450, but not more than 600 words.
REMINDER:If you use a reference as a source for your work products, you must use the APA in-text citation format to credit the author.
1.2 – Weekly Discussion Forum Posts (30 points)
Select a topic below and post an original thread of 100 to 150 words each in this week’s discussion forum.
· Pick at least two data warehouse vendors, compare and contrast their products, their market and if possible their pricing. Example of major data warehouse vendors are: SAP Hana, Oracle Exadata, Microsoft SQL Server, Teradata, and Greenplum.
· What data warehousing methodology, Inmon or Kimball do you prefer and why?
· Does Big Data belong in Data Warehousing, why or why not?
REMINDER:If you use a reference as a source for your work products, you must use the APA in-text citation format to credit the author.
