ParAccel vs. Spoom vs. Teradata Vantage

Actian matrix is not good for small data sets. If you have a limited data pool, or do not plan on having multiple users/clients accessing a data source, stick with a more traditional relational database model - Access for the truly small user base, or a DB2 or Oracle back end if your going to have multiple users, and moderate sized data. Actian is for LARGE data sets (Big Data, in the industry parlance). Millions of rows of data from multiple sources with various down stream systems accessing the database. It is for data analytics of large data groups and intense data mining.

Incentivized

It is well suited when you have several sources of data.

Teradata Vantage is well suited for large scale ETL pipelines like the ones we developed for anti money laundering risk matrices. It handles heavy joins, aggregations, and transformations on transactional data efficiently. We generate alert variables, adjust for inflation, and monitor establishments monthly with it, all integrated with Python and Control-M for a centralised automation across the company. For less appropriate, I would say that heavy resource demands might slow down experimentation for iterative work.

• 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.

Incentivized

• Easy to use
• Focus on analyzing and not on finding and loading data
• "One version of the truth"

• ETL (Extract - Transfor - Load)
• NOS to send data from Teradata Vantage to S3 and from S3 to Teradata Vantage
• Teradata GeoSpacial feature
• Bulk reading and writing in huge tables
• MPP capacity already mature
• Temporal Capacity more mature that other solutions
• TASM

Incentivized

• Some of the bugs were annoying and QA definitely needs improvement
• Connectivity to Informatica and ETL providers
• Workload management could be better like when you compare with Teradata

Incentivized

• I would like to have more modules. Eg. : supply chain tool.

• Teradata is an excellent option but only for a massive amount of data warehousing or analysis. If your data is not that big then it could be a misfit for your company and cost you a lot. The cost associated is quite extensive as compared to some other alternative RDBMS systems available in the market.
• Migration of data from Teradata to some other RDBMS systems is quite painful as the transition is not that smooth and you need to follow many steps and even if one of them fails. You need to start from the beginning almost.
• Last but not least the UI is pretty outdated and needs a revamp. Though it is simple, it needs to be presented in a much better way and more advanced options need to bee presented on the front page itself.

Incentivized

Teradata is a mature RDBMS system that expands its functionality towards the current cloud capabilities like object storage and flexible compute scale.

Incentivized

I wish to give higher rating for the speed and efficiency in handling the queries, but only 6 because of consistent bugs we encounter

Incentivized

Teradata Vantage allows us to create a scalable infrastructure to support our strategic initiatives. The dedicated compute power ensures reliable performance with isolated workloads and dedicated resources, optimizing workflows for faster, more efficient data transfers. The compute clusters support ETL processes and OSF’s developers and data science team with the flexibility to create self-service analytics, to spin up/down at any time, driving better performance and minimizing costs.

• Faster initial response
• Trained professionals
• Very helpful in resolving issues

Incentivized

We have meetings at the beginning with the technical team to explain our requirements to them and they were really putting in a lot of effort to come up with a solution which will address all our needs. They implemented the software and also trained a few of our resources on the same too. We can get in touch with them now as well whenever we run into a roadblock but it's very less now.

Incentivized

Leader failover setup is the toughest and lack of proper documentation is making things tough.

Incentivized

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.

Incentivized

Cognos is very expensive and needs heavy IT-team to implement it.

Teradata is way ahead of its competitor because of its unique features of ensuring data privacy and data never gets corrupted even in worst case scenario. In most cases, the data corruption is a major issue if left unused and it leads to important data being wiped off which in ideal case should be stored for 3 years

Incentivized

• ROI is great, less spending on full time DBA and that money could be use to add additional node.
• Negative - Not many developers are well aware of this tool, it takes some time to learn.

Incentivized

• 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.

Incentivized