Oracle Data Warehouse

Oracle Data Warehouse

About TrustRadius Scoring
Score 8.7 out of 100
Oracle Data Warehouse

Overview

Recent Reviews

Read all reviews

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Oracle Data Warehouse, and make your voice heard!

Pricing

View all pricing
N/A
Unavailable

What is Oracle Data Warehouse?

Oracle Autonomous Data Warehouse is a cloud data warehouse service that eliminates virtually all the complexities of operating a data warehouse, securing data, and developing data-driven applications. It automates provisioning, configuring, securing, tuning, scaling, patching, backing up, and…

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Would you like us to let the vendor know that you want pricing?

Alternatives Pricing

What is Google BigQuery?

Google's BigQuery is part of the Google Cloud Platform, a database-as-a-service (DBaaS) supporting the querying and rapid analysis of enterprise data.

What is Amazon Redshift?

Amazon Redshift is a hosted data warehouse solution, from Amazon Web Services.

Features Scorecard

No scorecards have been submitted for this product yet..

Product Details

What is Oracle Data Warehouse?

Oracle Autonomous Data Warehouse is a cloud data warehouse service that eliminates virtually all the complexities of operating a data warehouse, securing data, and developing data-driven applications. It automates provisioning, configuring, securing, tuning, scaling, patching, backing up, and repairing of the data warehouse.

Oracle Data Warehouse Competitors

Oracle Data Warehouse Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Comparisons

View all alternatives

Reviews and Ratings

 (218)

Reviews

(1-12 of 12)
Companies can't remove reviews or game the system. Here's why
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • transformations
  • ease of use
  • Oracle Data Warehouse creates a package in the database for each mapping - it would be nice to have the ability to manually update that package and Oracle Data Warehouse to recognize those updates without problems
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • To work in SQL and PL SQL and create high index database. Its user base is very huge so it is used in most of the company which helps in building profile.
  • Easy integration in application development, I have used in python currently.
  • Developers must know the backend as well so that they can build a scalable product.
  • If you learn SQL using Oracle, which cover most of the syntax, then you will be proficient in SQL and can easily work on other tools too (for ex, MySQL and PostgreSQL).
  • In Oracle Data Warehouse I used to build Type 1 and Type 2 Load frequently, where I did not face any issue, so nothing to improve from a product functionality point of view.
  • If UI is more interactive as in Informatica, then maybe more users can start using this
  • Blog link must be there on one site for solving user issues.
Score 6 out of 10
Vetted Review
Verified User
Review Source
  • Quick and easy deployment. There is no hassle in setting up software and maintaining hardware.
  • Highly available and scalable. Accessing the data warehouse is easy, and it can scale up based on the data size requirements.
  • Autonomous functionality. With the help of machine learning, autonomous data warehousing reduces the amount of time spent managing it.
  • Customer support isn't the best out there. We usually have to wait about an hour to get some form of assistance.
  • Pricing is a bit higher than many of its competitors such as AWS Redshift.
  • Tweaking features requires dedicated staff. Software is fairly advanced. Would be difficult to use for newcomers.
Score 7 out of 10
Vetted Review
Verified User
Review Source
  • Handles workloads like a champ.
  • Uses state-of-the-art analytic functions and allows for quick, easy SQL.
  • "Secret Sauce" integrates the hardware and the software for faster I/O.
  • Supports thousands of concurrent users.
  • We had issues converting a legacy DW (with its existing indexes, etc) over to the new DW hardware. Given the memory-intensive resources, not all indexes are advised. Traditional query tuning methods do not work. You have to re-learn some tuning tactics.
  • Given the number of features it has, it is far more complex to administer. Requires trained staff to support.
  • Support in these areas is generally poor. Oracle is, sadly, no exception.
  • I HATE the current push to the cloud. Seems like a gigantic money-grab.
Score 8 out of 10
Vetted Review
Verified User
Review Source
  • Oracle Data Warehouse is a well-known and already validated product. Its performance, technical support, documentation, online community, and sustainability is the best among the area.
  • It is easy to find and hire good data developers, data architects, and analysts who specialize in Oracle Data Warehouse.
  • It is easy to develop a financial plan based on the product, as its licensing is systematic. Also, the product's scalability is well developed with licensing policy and it makes it easier to flexibly plan budgets as we need more functionalities and services.
  • It is very expensive product. But not to mention, there's good reasons why it is expensive.
  • The product should support more cloud based services. When we made the decision to buy the product (which was 20 years ago,) there was no such thing to consider, but moving to a cloud based data warehouse may promise more scalability, agility, and cost reduction. The new version of Data Warehouse came out on the way, but it looks a bit behind compared to other competitors.
  • Our healthcare data consists of 30% coded data (such as ICD 10 / SNOMED C,T) but the rests is narrative (such as clinical notes.). Oracle is the best for warehousing standardized data, but not a good choice when considering unstructured data, or a mix of the two.
August 02, 2018

My Oracle DW Review

Kartik Chavan | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
  • Scalable for the storage of very large data.
  • Simple queries to pull down the data compared to transactional databases.
  • Compatibility with variety of other tools, & industry support.
  • Not effective if we compare it with current Big Data applications.
  • Other warehouses are better for parallel processing.
  • Prices are high for few functionalities which are supposed to be bought separately.
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • 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.
Score 7 out of 10
Vetted Review
Verified User
Review Source
  • Oracle Data Warehouse is scalable and reliable.
  • Seamless integration with oracle database's using synchronous and asynchronous connectivity thus giving real time data representation to the key business users.
  • Good performance and high availability of data from the Data Warehouse for analytical reporting.
  • Like any data warehouse, one needs to conduct a cost benefit analysis to see whether the IT efforts required for implementation of the data warehouse and the cost involved in maintaining the data would be adding monetary values to the organization.
  • Data Ownership could be one concern where the management needs to decide who would be having what access to the Data Warehouse. So proper configuration of the access would be required, so that there is no breach in data ownership.
Hemant Prabhakar Patil | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • It provides ease, feasibility and flexibility to use Oracle out of box pre-built solutions with different verticals and horizontals of industries such as Insurance Analytics, Financial Analytics, Sales and Marketing Analytics, etc.
  • It's always easy to use Oracle Data Warehouse where you have Oracle EBS and other Oracle Transactional Systems. Since it provides pre-built data models based on various standard BI solutions (in ERP & CRM Areas).
  • With various customers and businesses using Oracle dbs for transactional systems, it is always easy to recommend oracle data warehouse in numerous beneficial ways like cost, ease for implementation and maintenance, support for various top Oracle BI tools efficiently, etc
  • Query Performance in Oracle Data warehouse compared to other parallel execution dbs is a little low. But given a chance on concentration with good Oracle DB design can overcome those problems in warehouse.
  • For Big Data Implementation, it's not very cost effective compared to other big data solutions that are based on Hadoop systems and light weight BI Tools.
  • It's more preferable with Dimensional Modeling compared to 3NF models datawarehouse.
Seth Goldberg | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
  • Strong developer toolset. e.g. PL/SQL, partitioning, compression, etc.
  • Rich syntax
  • Rock solid reliability
  • Compatibility with other tools
  • Industry support
  • More automated functionality (e.g. automated table analysis, better automated partitioning)
  • Support for shared nothing architecture
  • Steep learning curve
Score 9 out of 10
Vetted Review
Verified User
Review Source
  • Able to handle very large data sizes efficiently from a performance, high availability and manageability perspective. This is accomplished through the Oracle Partitioning functionality. Partitioning allows large segments (tables, IOT index-organized tables, indexes) to be broken into smaller segments at the physical layer but treated as a whole at the logical layer.
  • Provides support for dual-format architecture through Oracle In-Memory functionality. Without any change to application code one can obtain in-memory performance. This functionality enables us to have the tables represented in both the row format and the column format using in-memory format. This is a huge boost for BI/analytic queries since the Oracle optimizer is able to intelligently choose the appropriate format.
  • Provision to materialize a subset of table data or table joins. This is through materialized views and the optimizer will rewrite the query against the base tables to make use of this materialized view. This provides a huge performance boost and is critical in VLDBs as in a data warehouse. The query rewrite is fully transparent to users.
  • Provides multiple compression capabilities. This is very useful not only for deducing the storage foot print but as well as increase performance at different layers of the infrastructure including query performance. The compression functionality can be applied against both structured and unstructured data.
  • With the advent of Engineered Systems (Exadata, Database Machine, SuperCluster) there are specific features and functionalities that can further boost the Oracle data warehouse. These are related to consolidation, Smart Scan, Storage Indexes, EHCC (Exadata hybrid columnar compression) and much more.
  • RAC - Real Application Clusters (with 2 or more nodes) provides functionality for high availability, performance and scaling as the work load increases. The parallelism is provided both within a node and as well as across nodes. If for any reason a node goes down the data warehouse is still available through other nodes and the running queries are transparently failed over to the surviving nodes.
  • For the query rewrite related to the materialized views the optimizer at times goes against the base tables. There is room for improvement for the optimizer to make more intelligent choices. There does exist functionality to identify the reason why the optimizer failed to do the rewrite of the original query. This can be further expanded.
  • On the storage indexes currently there is limitation of only 8 columns. In addition Oracle decides which of the columns are chosen as part of the storage index. It would be nice to see if both of these are addressed in future versions/releases.
  • Some of the features are 'Options' which would increase the overall licensing cost and is an important factor for certain class of users/clients. It would be nice to see if at least some of the options are standard functionality.