Great performance for large databases
December 12, 2017

Great performance for large databases

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Oracle Data Warehouse

The Oracle Data Warehouse provides a robust data warehousing platform that is used across my entire organization. Oracle Data Warehouse is directly used by a wide range of departments from analytics and data sourcing, to finance and marketing. For an organization that deals with huge volumes of data, Oracle DW is a great option for warehousing.
  • Running analytics queries is made simple on Oracle DWH.
  • Great support for large databases.
  • Even while dealing with large volumes of data, the compression capabilities of Oracle DWH ensure that most use cases are scalable.
  • While the Oracle Data Warehouse provides top notch performance, the pricing options make it unaffordable for most small and medium businesses.
  • Most add-on features that businesses can’t do without are priced separately.
  • Customizability options are limited. Cannot modify most features to suit the custom needs of Business.
  • Faster execution of queries, making analytics available quicker.
  • Easy integration with other tools on top of Oracle DWH saves time and effort for tech teams.
  • Increases licensing costs for a business significantly.
Oracle DWH is a pure warehousing tool and does not try to include outside features into itself, unlike a few other warehousing platforms. This makes Oracle DWH much simpler to set up and ready to use.
On the other hand, most other warehousing platforms can provide slightly below par performance and support for a significantly lower licensing cost.
For large businesses that handle very large databases, Oracle proved great performance and is probably the best warehousing option available.
For small and medium business, Oracle Data Warehouse might not be the best choice to use as a warehousing platform.