We performed a comparison between LocalDB and Teradata based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The initial setup is very straightforward. The guidelines are very easy to follow. Maintenance is very easy and requires very little manpower."
"The initial setup was simple."
"The solution is fast."
"The most valuable feature of LocalDBis the connection between the application and DB."
"Teradata's capabilities enhance data management efficiency, support scalability, and contribute to faster query performance."
"We did performance testing. We had a set of real life MicroStrategy reports. Our conditions were: Not allowed to redesign data model, not allowed to rewrite the queries, all queries should be generated by MicroStrategy, no aggregates. Teradata appeared to be way faster than a similarly configured (in terms of hardware) Oracle server."
"Teradata is a great, industry-leading data warehousing product that has MPP architecture."
"It's very mature from a technology perspective."
"Designing the database is easy."
"A conventional and easily defined way to build a data warehouse or a layer of data marts."
"Building a data warehouse with Teradata has definitely helped a lot of our downstream applications to more easily access information."
"The two types of partitioning have been very significant for us - row and columnar partitioning."
"The solution needs to create a management tool. Right now, the solution has tools for creating a local installation, but it's too simplistic. We need something that's a bit more complex so that we can extend the tools with our scripts."
"The internal connection features of LocalDB could improve."
"The initial setup is complex and requires a skilled person."
"The ALM features can be improved, but the database by itself is reliable."
"Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives."
"Since I was working on the very basic, legacy systems, the memory thing was always a challenge. If Teradata is moving to the cloud, the space constraint or the memory issue that my company generally faces will eventually resolve, in time. What I'd like to see in the next release of Teradata is that it becomes full-fledged on the cloud, apart from better connectivity to various systems. For example, if I have to read or include a Python script, if I write some basic codes, I should be able to read even unstructured data. I know that it's not supported even in Snowflake, but at least semi-structured data support, if that can be a little more enhanced, that would be good."
"The setup is not straightforward."
"Limited interest and success in some areas make us hesitate about upgrading."
"The solution is stable. However, there are times when we are using large amounts of data and we can see some latency issues."
"I would like to see more integration with many different types of data."
"It would help to make scaling easier with a reduced cost. "
"There is some improvement required on OLTP level and some analytical function is missing."
LocalDB is ranked 15th in Relational Databases Tools with 5 reviews while Teradata is ranked 7th in Relational Databases Tools with 54 reviews. LocalDB is rated 9.0, while Teradata is rated 8.2. The top reviewer of LocalDB writes "Good for the development process, generally stable, and easy to set up". On the other hand, the top reviewer of Teradata writes "Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities". LocalDB is most compared with SQL Server, MySQL, Oracle Database In-Memory, Oracle Database and Infobright DB, whereas Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, MySQL and BigQuery. See our LocalDB vs. Teradata report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools 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.