Data Warehouse and DBMS solutions

Running head: DATA WAREHOUSE
Data Warehouse and DBMS solutions
Name of the student:
Name of the University:
Author note:

1DATA WAREHOUSE
This assignment focuses mainly on the software that are used to handle the huge amount
of data in the data warehouse and in the data management systems. A number of solutions are
present in the market to deal with big data. For example, Teradata, Oracle, Amazon web
services, Cloudera and lot more. The following paragraphs will evaluate and comparatively
analyze them.
Evaluation and Comparative Analysis of the solutions available in the market:
This assignment will deal with four solutions to data warehouse and DBMS. They are
Oracle, Teradata, Amazon Web Services and Cloudera. Oracle is the domestic name of
relational database and data warehousing. The standard version of Oracle that is used in the
industry is Oracle Database 12c that eliminates the need of creating extra copy in separate
analytical data store as revealed in Gartner’s report (2014, cited in Herschel, 2015). The software
makes use of the Oracle Exadata Machine platform, which offers simplicity and scalability.
Advanced features like the Flash Storage and Hybrid Columnar Compression (HCC) are also
included. According to Gartner’s report, more than 390,000 customers use Oracle. However,
Teradata tops the chart of Gartner’s 2014 Magic Quadrant for Data Warehouse Data
Management Systems as the leading software that provides solution to the problems of data
warehousing and database management systems (Mousannif et al., 2016). The platform used is
Teradata’s enterprise data warehouse (EDW) that provides new tools and innovation
opportunities. It also provides analytics to mounds of relational and non-relational data to real-
time business trends and opportunities. Cloud- based DBMS solution is also offered with the
help of Aster database platform. According to Gartner’s report, Teradata has more than 1200
customers. On contrary to Teradata, the concept of Data warehousing and databases was
completely shifted to cloud computing is the past few years by the Amazon Web Services. For