Databricks in San Francisco offers the Databricks Lakehouse Platform (formerly the Unified Analytics Platform), a data science platform and Apache Spark cluster manager. The Databricks Unified Data Service aims to provide a reliable and scalable platform for data pipelines, data lakes, and data platforms. Users can manage full data journey, to ingest, process, store, and expose data throughout an organization. Its Data Science Workspace is a collaborative environment for practitioners to run…
$0.07
Per DBU
Oracle Autonomous Data Warehouse
Score 10.0 out of 10
N/A
Oracle Autonomous Data Warehouse is optimized for analytic workloads, including data marts, data warehouses, data lakes, and data lakehouses. With Autonomous Data Warehouse, data scientists, business analysts, and nonexperts can discover business insights using data of any size and type. The solution is built for the cloud and optimized using Oracle Exadata.
Databricks is a true all-in-one platform, and at the time of implementation, it had more features available to us, making it a clear choice over Snowflake. Moving our workloads from local computing to the servers in Databricks gave our start-up staff a great quality of life …
Compared to Synapse & Snowflake, Databricks provides a much better development experience, and deeper configuration capabilities. It works out-of-the-box but still allows you intricate customisation of the environment. I find Databricks very flexible and resilient at the same …
The most important differentiating factor for Databricks Lakehouse Platform from these other platforms is support for ACID transactions and the time travel feature. Also, native integration with managed MLflow is a plus. EMR, Cloudera, and Hortonworks are not as optimized when …
Databricks has a much better edge than Synapse in hundred different ways. Databricks has Photon engine, faster available release in cloud and databricks does not run on Open source spark version so better optimization, better performance and better agility and all kind of …
Databricks [Lakehouse Platform (Unified Analytics Platform)] can work with all data types in their original format while Snowflake requires additional structures to fit the data before loading it. Databricks is open source so potential is far greater.
Databricks was picked among other competitors. Closest competition in our organization was H2O.ai and Databricks came out to be more useful for ROI and time to market in our internal research. We could have used AWS products, however Databricks notebooks and ability to launch …
When we started using it, only the notebook experience was mature. However, DB was very helpful giving us direct support to get onto their platform. Really there was little in the way to compare to them at the time. AWS has services but not the same low-cost angle.
I also use Microsoft Azure Machine Learning in parallel with Databricks. They use different file formats which teach me to be flexible and able to write different programs. They are equally useful to me and I would like to master both platforms for any future usage. I do prefer …
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.
I used Informatice and ODI. While Informatica provides more functionality, it is a very expensive tool. Oracle Data Warehouse gives lots of same functionality at a fraction of a cost (or free with enterprise Oracle db license)
Reason to select Oracle Data Warehouse are mentioned below: 1. If some of your old process are already setup using Oracle Data Warehouse 2. High user community, which make solving doubt using internet very easy
Since our core was Oracle ERP Cloud, we were looking for a cloud data warehouse solution from Oracle. Autonomous Data Warehouse perfectly fit that need and has already provided us with the results. Our CSM and the readily available support helps us to resolve issues and find …
In my personal opinion, Amazon Redshift is much better than Oracle Data Warehouse in two main ways. First, it's in the Cloud which eliminates the need to purchase and maintain dedicated hardware. Second, the pricing models for Redshift are far more flexible and affordable. …
Patching with Oracle Autonomous Warehouse is a breeze. With Teradata patching is a pain. Also Oracle Autonomous Warehouse is more cheaper than Teradata warehouse. Flexibility is another major factor for anyone considering Oracle Autonomous Warehouse. Extract Transform and Load …
Oracle is, in my opinion, the top dog in this space. I feel like the other vendors are playing catch-up to where Oracle is right now. It is also likely the most expensive option out there.
Our organization adopted Oracle almost 20 years ago and there were a few options at that time. Oracle was the leading database tech company at that time and it was a safe choice to us. And they have been evolved and always ahead of new technologies, high performance, and …
Hadoop still being a naive field, we have very few expertise with great knowledge in Hadoop. Oracle Data Warehouse does not support unstructured data, where as Hadoop does. There are a lot of functionalities which Oracle Data Warehouse provides, which makes us us not to go for …
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 …
Oracle data warehouse has the capability of running both the Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) databases on the same platform. This capabilities cannot be handled by other datawarehouse like TeraData. This capability helps Oracle to …
Oracle Data Warehouse became immediate selection whenever we were implementing BI solutions with Dimension Modeling and Oracle based Transactional Systems, compared to other places where we used Teradata and Netezza with 3NF model structure for BI solutions. For other various …
Oracle is a lot cheaper than traditional data warehouse appliance solutions, even if you get an expensive DBA who knows what he/she is doing. It definitely takes a lot more work to ensure it scales as your data size grows. While it won't scale past the terabyte sized data sets, …
If you need a managed big data megastore, which has native integration with highly optimized Apache Spark Engine and native integration with MLflow, go for Databricks Lakehouse Platform. The Databricks Lakehouse Platform is a breeze to use and analytics capabilities are supported out of the box. You will find it a bit difficult to manage code in notebooks but you will get used to it soon.
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.
There is databricks community, which is a free version. It is available for beginners to have an easy start with a big data platform. It does not have every feature of the full version but is still adequate for extremely new coders.
There are many resourceful training elements that are available to developers, data scientists, data engineers and other IT professionals to learn Apache Spark.
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.
Connect my local code in Visual code to my Databricks Lakehouse Platform cluster so I can run the code on the cluster. The old databricks-connect approach has many bugs and is hard to set up. The new Databricks Lakehouse Platform extension on Visual Code, doesn't allow the developers to debug their code line by line (only we can run the code).
Maybe have a specific Databricks Lakehouse Platform IDE that can be used by Databricks Lakehouse Platform users to develop locally.
Visualization in MLFLOW experiment can be enhanced
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
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.
Because it is an amazing platform for designing experiments and delivering a deep dive analysis that requires execution of highly complex queries, as well as it allows to share the information and insights across the company with their shared workspaces, while keeping it secured.
in terms of graph generation and interaction it could improve their UI and UX
One of the best customer and technology support that I have ever experienced in my career. You pay for what you get and you get the Rolls Royce. It reminds me of the customer support of SAS in the 2000s when the tools were reaching some limits and their engineer wanted to know more about what we were doing, long before "data science" was even a name. Databricks truly embraces the partnership with their customer and help them on any given challenge.
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.
Databricks is a true all-in-one platform, and at the time of implementation, it had more features available to us, making it a clear choice over Snowflake. Moving our workloads from local computing to the servers in Databricks gave our start-up staff a great quality of life boost.
Our organization adopted Oracle almost 20 years ago and there were a few options at that time. Oracle was the leading database tech company at that time and it was a safe choice to us. And they have been evolved and always ahead of new technologies, high performance, and professional business support. We didn't find a good reason to replace Oracle with any other competitors.
Overall the business objective of all of our clients have been met positively with Oracle Data Warehouse. All of the required analysis the users were able to successfully carry out using the warehouse data.
Using a 3-tier architecture with the Oracle Data Warehouse at the back end the mid-tier has been integrated well. This is big plus in providing the necessary tools for end users of the data warehouse to carry out their analysis.
All of the various BI products (OBIEE, Cognos, etc.) are able to use and exploit the various analytic built-in functionalities of the Oracle Data Warehouse.