Difference between MariaDB and Teradata
1. MariaDB :
It is an open source relational database management system (RDBMS) that is a compatible drop-in replacement for the widely used MySQL database technology. It is developed by MariaDB Foundation and initially released on 29 October 2009. MariaDB has a significantly high number of new features, which makes it better in terms of performance and user-orientation than MySQL.
2. Teradata :
It is an RDBMS that is produced by Teradata Corp. And it is used to manage large data warehousing operations. Teradata Corporation is a provider of database and analytics-related software, products, and services. It accepts the number of requests from multiple client applications.
Difference between MariaDB and Teradata :
| SR.NO | MariaDB | Teradata |
|---|---|---|
| 1 | It is developed by MariaDB Foundation in 2009. | It is developed by Teradata Corp. in 1984. |
| 2 | MariaDB server operating systems are FreeBSD, Linux, Solaris and Windows. | Teradata server operating systems are Linux, hosted. |
| 3 | The primary database model for MariaDB is Relational DBMS. | The primary database model for Teradata is Relational DBMS. |
| 4 | It is a open source software framework. | It runs world’s largest commercial databases. |
| 5 | Famous companies like CUNY, Accenture, Docplanner, Grooveshark, Northrop Grumman, uses MariaDB. | Famous companies like Cognizant, Capgemini, aws, Cisco, Citibank, etc use Teradata. |
| 6 | It support ACID Transactions. | It also support ACID transactions. |
| 7 | It provides us with Immediate Consistency method to ensure consistency in a distributed system. | It also provides us with Immediate Consistency method to ensure consistency in a distributed system. |
| 8 | It uses ADO.NET, JDBC, ODBC, Proprietary native APIs. | It uses .NET Client API, HTTP REST, JDBC, JMS Adapter ODBC, OLE DB as APIs. |
| 9 | It supports C, C#, C++, Go, Tcl, Perl, D, Erlang, Java, JavaScript, PHP, Python, Ruby. | It supports C, C++, Cobol, Java (JDBC-ODBC), Perl, PL/1, Python, R, Ruby. |
| 10 | It provides access rights for users and roles. | It provide fine grained access rights according to SQL-standard. |
Please Login to comment...