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 Teradata compete in large-scale data management. Teradata has the upper hand due to its unparalleled performance and scalability in handling large data sets, although it is more costly.
Features: Microsoft Parallel Data Warehouse excels in speed with scalable infrastructure, seamless Microsoft tools integration, and cost-effectiveness in data management. Teradata stands out with advanced analytics, optimization tools, and robust scalability and reliability.
Room for Improvement: Microsoft Parallel Data Warehouse needs better resource efficiency, simpler integration with non-Microsoft systems, and improved concurrency handling. Teradata requires cost reduction, enhanced cloud capabilities, and better documentation and support.
Ease of Deployment and Customer Service: Microsoft Parallel Data Warehouse offers various deployment options but requires expertise. Customer service is rated 7/10. Teradata provides flexible deployment but is complex. Customer service is also rated 7/10, with room for enhanced support.
Pricing and ROI: Microsoft offers competitive pricing with substantial ROI for large organizations, though prices vary. Teradata is expensive but provides significant performance gains for large enterprises, offering positive long-term ROI.
We have realized a return on investment, with a reduction of staff from 27 to eight, and our current return on investment is approximately 14%.
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.
The customer support for Teradata has been great.
Customer support is very good, rated eight out of ten under our essential agreement.
The technical support from Teradata is quite advanced.
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.
This expansion can occur without incurring downtime or taking systems offline.
Scalability is complex as you need to purchase a license and coordinate with Teradata for additional disk space and CPU.
Teradata's scalability is great; it's been awesome.
Microsoft Parallel Data Warehouse is stable for us because it is built on SQL Server.
I find the stability to be almost a ten out of ten.
The workload management and software maturity provide a reliable system.
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.
The ETL designing process could be optimized for better efficiency.
If Teradata could provide a list of certified experts, that would be fantastic.
Unlike SQL and Oracle, which have in-built replication capabilities, we don't have similar functionality with Teradata.
Microsoft Parallel Data Warehouse is very expensive.
Initially, it may seem expensive compared to similar cloud databases, however, it offers significant value in performance, stability, and overall output once in use.
Teradata is much more expensive than SQL, which is well-performed and cheaper.
We spent roughly $295,000 on setup costs.
The columnstore index enhances data query performance by using less space and achieving faster performance than general indexing.
The biggest advantage of Microsoft Parallel Data Warehouse is the possibility to stop or pause the service because it can be very expensive.
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.
It has resulted in better performance improvement within our team as we now cover nine business units instead of 18, thanks to the data performance, which has increased data visibility and helped the enterprise achieve a higher rate of internal return on financials.
The data mover is valuable over the last two years as it allows us to achieve data replication to our disaster recovery systems.
| Product | Market Share (%) |
|---|---|
| Teradata | 12.1% |
| Microsoft Parallel Data Warehouse | 1.5% |
| Other | 86.4% |
| Company Size | Count |
|---|---|
| Small Business | 16 |
| Midsize Enterprise | 6 |
| Large Enterprise | 21 |
| Company Size | Count |
|---|---|
| Small Business | 26 |
| Midsize Enterprise | 12 |
| Large Enterprise | 49 |
The traditional structured relational data warehouse was never designed to handle the volume of exponential data growth, the variety of semi-structured and unstructured data types, or the velocity of real time data processing. Microsoft's SQL Server data warehouse solution integrates your traditional data warehouse with non-relational data and it can handle data of all sizes and types, with real-time performance.
Teradata is a powerful tool for handling substantial data volumes with its parallel processing architecture, supporting both cloud and on-premise environments efficiently. It offers impressive capabilities for fast query processing, data integration, and real-time reporting, making it suitable for diverse industrial applications.
Known for its robust parallel processing capabilities, Teradata effectively manages large datasets and provides adaptable deployment across cloud and on-premise setups. It enhances performance and scalability with features like advanced query tuning, workload management, and strong security. Users appreciate its ease of use and automation features which support real-time data reporting. The optimizer and intelligent partitioning help improve query speed and efficiency, while multi-temperature data management optimizes data handling.
What are the key features of Teradata?In the finance, retail, and government sectors, Teradata is employed for data warehousing, business intelligence, and analytical processing. It handles vast datasets for activities like customer behavior modeling and enterprise data integration. Supporting efficient reporting and analytics, Teradata enhances data storage and processing, whether deployed on-premise or on cloud platforms.
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.
