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 most valuable feature of LocalDBis the connection between the application and DB."
"The solution is fast."
"The initial setup was simple."
"The initial setup is very straightforward. The guidelines are very easy to follow. Maintenance is very easy and requires very little manpower."
"Teradata is a great, industry-leading data warehousing product that has MPP architecture."
"The performance is great, we are able to query our data in one operation."
"Teradata's most valuable feature is that it's easy to use."
"There are several features of Teradata that I like. One of the most basic is the indexes. I also like that it provides lower TCO. It also has the optimizer feature which is a good feature and isn't found in other legacy systems. Parallelism is also another feature I like in Teradata because when you are running or hosting on multiple systems, you have this shared-nothing architecture that helps. Loading and unloading in Teradata are also really helpful compared to other systems."
"The two types of partitioning have been very significant for us - row and columnar partitioning."
"The most valuable feature of Teradata is the quick processing of large data."
"Their extensive experience in data warehousing, the platform's performance, and their strong reputation in the market are the most valuable."
"Things have started moving faster in my company, such as data retrieval happens more quickly."
"The ALM features can be improved, but the database by itself is reliable."
"The initial setup is complex and requires a skilled person."
"The internal connection features of LocalDB could improve."
"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."
"Sometimes the large injestion takes days to load data, and some of our stored procedures take two to three days."
"I've been using the same UI for 20 years in Teradata. It could use some updating. Adding more stability around Teradata Studio would be outstanding. Teradata Studio is a Java-based version of their tool. It's much better now, but it still has some room for improvement."
"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 solution could improve by having a cloud version or a cloud component. We have to use other solutions, such as Amazon AWS, Microsoft Azure, or Snowflake for the cloud."
"GUI of administrative tools is really outdated."
"Data ingestion is done via external utilities and not by the query language itself. It would be more convenient to have that functionality within its SQL dialect."
"Teradata's UI could be more user-friendly."
"The solution needs improvement in its stability, support and pricing."
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.