Apr 13, 2014
I think hands down it's Exadata since for the front end apps it's just another Oracle database which means everything under the sun is compatible with it.
Microsoft Parallel Data Warehouse and Oracle Exadata are leading solutions in the enterprise data management and warehousing sector. Oracle Exadata appears to have the upper hand in performance due to its integrated hardware and software designed for high performance.
Features: Microsoft Parallel Data Warehouse enhances performance, particularly for data loading, with lower infrastructure cost and supports diverse database systems integration. Oracle Exadata provides fast read/write times with features like Smart Scan, Hybrid Columnar Compression, and engineered system efficiencies.
Room for Improvement: Microsoft Parallel Data Warehouse faces query handling limitations, integration challenges with non-Microsoft tools, and needs to improve scalability and error messaging. Oracle Exadata's high costs, complex patching process, and limited virtualization performance necessitate improvements for broader adaptability and reduced expense.
Ease of Deployment and Customer Service: Microsoft Parallel Data Warehouse offers deployment flexibility in public and hybrid clouds and generally satisfactory customer support. Oracle Exadata's primary on-premises deployment limits flexibility, and its customer support requires enhancement in technical assistance for complex setups.
Pricing and ROI: Microsoft Parallel Data Warehouse is competitively priced with significant ROI benefits for handling large data volumes efficiently, especially in government sectors. Oracle Exadata is expensive, aiming at large enterprises, and though it offers substantial ROI through performance benefits, its price is a barrier for smaller businesses.
The investment is good, which is why people choose this hardware.
They are responsive and get back to us.
I would rate my experience with technical support around six on a scale of 1 to 10 because I have not had a particular experience with technical support.
If I were to rate their support from one to ten, I would say between nine to ten.
This involved creating blueprints for integrating Oracle products into client systems, followed by technical presentations to Oracle teams and stakeholders.
Exadata comes with a platinum gateway and comprehensive support, which often gets immediate attention with severity one cases.
We go from a couple of users to tons of users all the time, and it scales and handles things really well.
I give the scalability an eight out of ten, indicating it scales well for our needs.
As a consultant, we hire additional programmers when we need to scale up certain major projects.
Within a site, scalability is excellent.
Microsoft Parallel Data Warehouse is stable for us because it is built on SQL Server.
Once installed, Exadata is very stable.
Addressing the cost would be the number one area for improvement.
It would be better to release patches less frequently, maybe once a month or once every two months.
When there are many users or many expensive queries, it can be very slow.
I believe that there is still room for improvement in Oracle Exadata, as they are putting AI features on those databases, which is making the database more user-friendly.
There are minor areas where improvement is needed, such as making the user interface more user-friendly and enhancing configuration and customization options.
I cannot create an extended rack cluster with one node on one site and another node on a different site.
Microsoft Parallel Data Warehouse is very expensive.
I would rate the price an eight on a scale from one to ten, indicating it is fairly expensive.
I find its pricing reasonable and cost-effective for large organizations, but for smaller organizations, it may not be that useful.
The columnstore index enhances data query performance by using less space and achieving faster performance than general indexing.
There's a feature that allows users to set alerts on triggers within reports, enabling timely actions on pending applications and effectively reducing waiting time.
Its scalability is impressive as it scales up and down really well.
It also offers high backend speed between self-storage units and servers, which is beneficial for processing.
The most valuable features of Oracle Exadata are its high availability and cluster environment.
If a customer cannot tune their applications, this will help them to run the database and run the application without any tuning itself.
| Product | Mindshare (%) |
|---|---|
| Oracle Exadata | 7.6% |
| Microsoft Parallel Data Warehouse | 2.9% |
| Other | 89.5% |
| Company Size | Count |
|---|---|
| Small Business | 16 |
| Midsize Enterprise | 6 |
| Large Enterprise | 22 |
| Company Size | Count |
|---|---|
| Small Business | 47 |
| Midsize Enterprise | 14 |
| Large Enterprise | 86 |
Microsoft Parallel Data Warehouse offers high performance and usability with seamless SQL Server integration, handling large data efficiently with a user-friendly interface. Known for its cost-effectiveness and robust security, it excels in integrating data across Microsoft ecosystem.
Microsoft Parallel Data Warehouse efficiently manages large datasets from diverse sources, supporting a unified data approach. Its integration with SQL Server and compatibility with tools like Qlik enhances data management and decision-making capabilities. With impressive scalability and security features, it is widely used in sectors such as finance, healthcare, and logistics for analytics and reporting. However, users seek improvements in integration with non-Microsoft layers, memory usage, SQL configuration, and scalability.
What are the key features of Microsoft Parallel Data Warehouse?In industries like finance, healthcare, and logistics, Microsoft Parallel Data Warehouse supports analytics, reporting, and decision-making processes. Organizations utilize it to maintain historical data, develop business intelligence models, and create actionable dashboards, benefiting from its integration with key tools and efficient data management.
Oracle Exadata is a robust platform engineered to enhance performance and scalability for OLTP and data warehousing by integrating hardware and software, allowing efficient handling of large data volumes with high availability.
Oracle Exadata offers significant performance improvements through features like Smart Flash Cache, Smart Scan, and Hybrid Columnar Compression. It supports large transactions and consolidates databases, making it ideal for complex data tasks. While pricing is a concern, and some areas such as maintenance and documentation require attention, its strength in scalability and performance makes it suitable for sectors demanding database reliability, such as finance and telecommunications.
What are the key features of Oracle Exadata?Oracle Exadata is implemented in industries requiring robust data management solutions. In finance and telecommunications, it enhances database stability and security, supports high-speed transaction processing, and facilitates data analytics within cloud-integrated environments, proving essential for large-scale operations.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
