Oracle Autonomous Data Warehouse vs. Teradata Data Warehouse Appliance 2850

II would recommend Oracle Autonomous Data Warehouse to someone looking to fully automate the transferring of data especially in a warehouse scenario though I can see the elasticity of the suite that is offered and can see it is applicable in other scenarios not just warehouses.

Incentivized

Teradata is most suited when needing to get data for a specific purpose. If you need to report data and display it, this application is not as well suited. It should only be used to store and access data. It does a good job of organizing the data. You can get your dataset at a place where little to no additional tweaking would be needed in other applications.

Incentivized

• Very easy and fast to load data into the Oracle Autonomous Data Warehouse
• Exceptionally fast retrieval of data joining 100 million row table with a billion row table plus the size of the database was reduced by a factor of 10 due to how Oracle store[s] and organise[s] data and indexes.
• Flexibility with scaling up and down CPU on the fly when needed, and just stop it when not needed so you don't get charged when it is not running.
• It is always patched and always available and you can add storage dynamically as you need it.

• Can query multiple databases within one server and view all results in one window. Helps speed up analysis.
• Teradata uses AMPs (Access Module Processors) to increase speed of data processing/queries. You must use 'COLLECT STATISTICS' properly to efficiently use the AMPs.
• Most standard SQL practices work on Teradata. Also, Teradata formats the query in a nice colored structure.
• Can search for tablenames or specific columnnames across the entire server. Helps when changing a specific column or table structure.

Incentivized

• Level of integration or compatibility to connect it to different applications can be improved
• The support service is slow
• The issue is with the record number limitation of not being able to bring back more than one million records or not being able to export larger datasets to Excel

Incentivized

• Sometimes it isn’t clear the reason an error will occur in the query. More detailed responses would be helpful
• It can be slow at times when pulling large data amounts
• Sometimes spool space will run out when trying to run certain queries

Incentivized

Because

• It is really simple to provision and configure.
• Does not require continous attention from the DBA, autonomous features allows the database to perform most of the regular admin tasks without need for human intervention.
• Allows to integrate multiple data sources on a central data warehouse, and explode the information stored with different analytic and reporting tools.

Incentivized

Understanding Oracle Cloud Infrastructure is really simple, and Autonomous databases are even more. Using shared or dedicated infrastructure is one of the few things you need to consider at the moment of starting provisioning your Oracle Autonomous Data Warehouse.

Incentivized

As I mentioned, I have also worked with Amazon Redshift, but it is not as versatile as Oracle Autonomous Data Warehouse and does not provide a large variety of products. Oracle Autonomous Data Warehouse is also more reliable than Amazon Redshift, hence why I have chosen it

Incentivized

To be fair, I didn’t select Teradata. I do think that they are comparable. There are some things SQL server does better than Teradata and vice versa. For example, sql server will underline potential errors while you are coding. It also will auto-populate table and column names so you don’t need to have the exact name before submitting your query.

Incentivized

• With OBIEE we had a limitation on the license, with OAC and Oracle Autonomous Data Warehouse, since it is pay-per-use services, it significantly reduced the cost.
• the resource requirement was also on smaller side, as the maintenance activity primarily was done by the Oracle Autonomous Data Warehouse itself.

Incentivized

• Enabled next-day reporting.
• Better customer service as field technicians can see instant performance.
• Needed to hire more employees for overnight support.

Incentivized