What users are saying about

Amazon Aurora

41 Ratings

Amazon Aurora

41 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8 out of 101

Teradata Database

26 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8 out of 101

Add comparison

Likelihood to Recommend

Amazon Aurora

When already using a relational database, either MySQL or PostgreSQL, the change to Amazon Aurora should be very straightforward. The main benefits you get are cost efficiency and ease with regards to the storage, as it scales with you, and managing clusters including failovers are made very straightforward for you.If you are looking for a database which can scale up and down quickly with demand, Aurora may not be the best fit. However, there is now an Amazon Aurora Serverless service which attempts to address this requirement. I do not have any experience with it, so cannot comment further - but it is possible it will fit your use-case.
Andrew Raines profile photo

Teradata Database

It's well suited to large organisations where multiple departments across large geographical regions need to access one centralised repository. It's not so well suited to small-medium sized organisations where databases are not so large.
David Shi profile photo

Pros

  • The MySQL compatibility meant we didn't have to change anything in our system which used to run on a MySQL database. It was a very simple configuration change to point at the new instance once set up
  • Much better performance than our previous MySQL database (hosted on AWS RDS) for lower costs due to the way storage is managed
  • Storage management is much more simple as it grows and shrinks with you without having to allocate and deallocate storage to the database
Andrew Raines profile photo
  • Scalability, where it's able to house magnitudes more data compared to a standard SQL database while still retaining good performance.
  • Performance, able to quickly retrieve millions of rows with ease.
  • Adaptability, able to connect to the likes of Tableau desktop to enable quick analysis.
David Shi profile photo

Cons

  • Without direct access to the instances it isn't possible to do a few things you'd be able to do if you were running your own database server, but this is rarely an issue
Andrew Raines profile photo
  • Interface is outdated
  • Some syntax slightly different to standard SQL
  • Needs expertise to best create tables so as to not 'skew' database
David Shi profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
Teradata Database10.0
Based on 1 answer
[It's] a must have application in the organisation that cannot be easily replaced.
David Shi profile photo

Usability

No score
No answers yet
No answers on this topic
Teradata Database7.0
Based on 1 answer
The interface is still based on 90s, overall usability will never be very high due to the intrinsic expertise required for any and all users of the application/system.
David Shi profile photo

Alternatives Considered

Using cloud-based services such as RDS or Aurora take all the hassle out of managing database servers yourself. It also gives you the flexibility to easily spin up and down additional instances and as when required. Where Aurora outshines RDS is in terms of performance - we saw around 2-5x improvement in query read times across the board.
Andrew Raines profile photo
Oracle seems to have the upper hand. Oracle takes fewer resources and is harder to get wrong because the user has a very detailed install instructions and wizard to follow. Teradata has a place where you can store projects and collaborate, but so does Oracle. Teradata GUI has a way to build SQL if you don't know how, but Oracle has that as well. Building a view to do complex slicing of data is not the most intuitive in Teradata. Oracle views can be optimized and have meaningful functions that can be added to them.
Brian Dandeneau profile photo

Return on Investment

  • Moderately reduced database running costs
  • Improved performance of database cluster which in turn has had a positive impact on the response times of our API services
Andrew Raines profile photo
  • Negative impact is again the slowness that would be felt by developers and users.
  • Negative impact is that there is a learning curve if they have been using any other type of SQL.
  • Positive impact is that you can collaborate with other developers by using projects.
Brian Dandeneau profile photo

Pricing Details

Amazon Aurora

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

Teradata Database

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