Powerhouse for Data Warehousing and Analysis
August 06, 2019
Powerhouse for Data Warehousing and Analysis
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Teradata Vantage Advanced SQL Engine (Teradata Database)
We have been using Teradata database in our project for a long time now and I am very happy with that decision of implementing it because it has far exceeded our expectations. So, the Teradata database is basically a Relational Database Management System which is highly Scalable, Available, Stable and Robust. It is mostly used by large organizations to develop enterprise Dataware housing model. Teradata is a good fit for you only if you are dealing with huge volumes of data otherwise it may not be cost-effective for you. This enables running massive volume queries swift and easy and the response time is outstanding as well.
- Teradata database is based on Massively Parallel Processing (MPP) architecture. Because of this architecture, Teradata is able to share the workload evenly across all the system. It splits the work equally to its processes and each process runs in parallel to achieve the result in quickest possible time.
- The underlying work is done by Teradata nodes, Access Module Processors (AMPs) and the disks associated with AMPs. The beauty is that none of them share any resources which means they all work independently and achieve actual parallel processing with the fastest results. The each AMP shares the same amount of work so that no resource stays idle and the output can be quicker.
- Another excellent feature of Teradata is the Connectivity portion. It can so easily connect to almost all the major systems like Mainframes, Oracle DB or IBM DB2. The import of loads is super fast and efficient.
- It is also really helpful when you have to troubleshoot an error because it provides great diagnostic information and therefore saves you a lot of time and effort by not having to go through all the logs manually and find the error and cause for it.
- 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.
- Teradata is been absolutely phenomenal for our project because we feed huge chunks of data to it and get back the desired results in no time which earlier used to take hours to process and then also sometimes timeout.
- We don't have to do any manual intervention for resource or task allocation, it is all taken care by Teradata internally and all the AMP's are given equal amount of work and have their own resources to complete them with no sharing with another.
There are many alternatives available in the market and many of them are cheaper as well. But you need to be very clear in your mind why you want to go for Teradata, what is the future plan for it and how are you going to make the most of it because it is certainly much more costly than its alternatives. If you have a massive volume of data which needs to be analyzed and provide real-time results or do the best data warehousing or it is scalable and highly available, then you should definitely consider Teradata as the top choice.