Actian Matrix

3 Ratings
Score 8.6 out of 101

Teradata Enterprise Data Warehousing

52 Ratings
Score 8.4 out of 101

Add comparison

Likelihood to Recommend

Actian Matrix

[Actian Matrix is well suited for:]1. Power user who wants to derive aggregate metrics by joining huge dataset.2. Batch load where you have to load billion of records very fast (copy command).3. Scenario where you want to do ELT because your ETL tool cannot handle huge volume of data.
Dipankar Pradhan profile photo

Teradata Enterprise Data Warehousing

  • Works well if you have the purse to hire Teradata specialists directly from the company and provide solution.
  • Lot of possibilities on reporting, and can accommodate any pattern/type.
  • Works with Hyperion Reporting.
Bharadwaj (Brad) Chivukula profile photo

Pros

  • Super fast. Aggregate query such as SUM(), Count() returns result within seconds from a table with more than billion records.
  • Excellent data compression.
  • Easy maintenance. We managed this database without having a full time DBA.
  • Support ANSI SQL and ODBC/JDBC. It's easy to connect to this database from other systems.
Dipankar Pradhan profile photo
  • The Teradata Enterprise provides the best workload management bar none. There is virtually no analytic task that it can not handle. It is designed to handle mixed workloads and it shows. Tactical query related reports and applications can easily be given high priority while more processing intensive queries can be throttled and prioritized internally like a finely tuned data super highway so to prevent data traffic jams and allow the entire enterprise to be served efficiently.
  • Designed to be easily maintained. Teradata requires very little maintenance compared to other enterprise DBs. Also, the integrated Viewpoint server provides a central view of the enterprise data-warehouse and supports servers. It also has convenient direct integration with DSA backups and supports analytic data labs that can be used to empower users.
  • Teradata supports all the latest analytic open source languages and has advanced APIs that can be easily be leveraged within custom scripts and applications. The feature set integrated out of the box in Teradata is something few competitors can match. It also supports Map Reduce and other analytic functions natively in the database.
  • The new Teradata Enterprise in the Cloud on AWS makes changing node configurations to handle increased workloads a matter of hours rather than weeks type process and rather than dealing with trying to reinvent the wheel with a new infant "open source" or "new" cloud database that is missing core features that mature databases like Teradata have supported for years as a customer you get the maturity as well the cutting edge cloud capabilities in a no-compromise solution.
  • Teradata Intellicloud support provides pain-free management of the cloud environment. It handles the backups and manages EC2 instances to keep everything running smoothly.
  • The Teradata Querygrid product provides a level of interoperability between itself and competitor and open sources data sources without having to design complex ETL.
No photo available

Cons

  • Dashboard for Admin instead of a linux console.
  • Admin with ability to kill inactive sessions when sessions reaches to more than allowed sessions. We ended up restarting the database.
  • Ability to easily scale up database by adding extra node.
  • Better support from Actian.
Dipankar Pradhan profile photo
  • Teradata can improve by supporting more native AWS cloud features. Currently if a node goes down the EC2 instance must be restarted. It isn't something that happens frequently but more tight integration with cloud providers like AWS and Azure will allow Teradata to offer truly dynamic scaling.
  • Some Teradata features are oversold before they are ready for prime-time. Teradata is not unique in this but if something is sold as an integrated product stack it should really be integrated not something that requires an extensive development cycle to be integrated at a customer's expense. If something is supported it should've really be tested and QAed thoroughly before a customer touches it.
No photo available

Usability

Actian Matrix6.0
Based on 1 answer
I wish to give higher rating for the speed and efficiency in handling the queries, but only 6 because of consistent bugs we encounter
No photo available
No score
No answers yet
No answers on this topic

Support

Actian Matrix8.0
Based on 1 answer
  • Faster initial response
  • Trained professionals
  • Very helpful in resolving issues
No photo available
No score
No answers yet
No answers on this topic

Implementation

Actian Matrix6.0
Based on 1 answer
Leader failover setup is the toughest and lack of proper documentation is making things tough.
No photo available
No score
No answers yet
No answers on this topic

Alternatives Considered

Actian Matrix is our first big data analytics storage platform, and as I was not involved in the POC process to compare it to other products out on the market, unfortunately I cannot say if it is better than other Big Data storage options. I can say that it out performs products such as Oracle or UDB in regards to the volume of data it can easily index and handle.
No photo available
Teradata is the leader in Data Warehousing bar none based on independent experts like Gartner and our experience aligns with this.
No photo available

Return on Investment

  • I cannot comment on the specific numbers, all I can say is that switching to the backend greatly improved our processing speed. The more we process through our systems, the more clients we can serve. Which should bump ROI.
No photo available
  • Moving to Teradata in the Cloud-enabled a level of agility that previously didn't exist in the organization. It also enabled a level of analytic competency that was not achievable using other options on the aggressive timeline that was required. We didn't want to settle for reinventing a wheel when we had a super tuned performance capable beast readily available in Teradata. Teradata lets us focus on our business rather than spending money and effort trying to design software or database foundations features on an open source or lower performance platform.
No photo available

Pricing Details

Actian Matrix

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

Teradata Enterprise Data Warehousing

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
Additional Pricing Details