DBMS > SQLite vs. Trafodion
System Properties Comparison SQLite vs. Trafodion
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||SQLite Xexclude from comparison||Trafodion Xexclude from comparison|
|Apache Trafodion has been retired in 2021. Therefore it is excluded from the DB-Engines Ranking.|
|Description||Widely used embeddable, in-process RDBMS||Transactional SQL-on-Hadoop DBMS|
|Primary database model||Relational DBMS||Relational DBMS|
|Developer||Dwayne Richard Hipp||Apache Software Foundation, originally developed by HP|
|Current release||3.43.1 (11 September 2023), September 2023||2.3.0, February 2019|
|License Commercial or Open Source||Open Source Public Domain||Open Source Apache 2.0|
|Cloud-based only Only available as a cloud service||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Implementation language||C||C++, Java|
|Server operating systems||server-less||Linux|
|Data scheme||yes dynamic column types||yes|
|Typing predefined data types such as float or date||yes not rigid because of 'dynamic typing' concept.||yes|
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.||no||no|
|SQL Support of SQL||yes SQL-92 is not fully supported||yes|
|APIs and other access methods||ADO.NET inofficial driver|
JDBC inofficial driver
ODBC inofficial driver
|Supported programming languages||Actionscript|
|All languages supporting JDBC/ODBC/ADO.Net|
|Server-side scripts Stored procedures||no||Java Stored Procedures|
|Partitioning methods Methods for storing different data on different nodes||none||Sharding|
|Replication methods Methods for redundantly storing data on multiple nodes||none||yes, via HBase|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||yes via user defined functions and HBase|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency|
|Foreign keys Referential integrity||yes||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID|
|Concurrency Support for concurrent manipulation of data||yes via file-system locks||yes|
|Durability Support for making data persistent||yes||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes||no|
|User concepts Access control||no||fine grained access rights according to SQL-standard|
More information provided by the system vendor
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||Navicat for SQLite is a powerful and comprehensive SQLite GUI that provides a complete set of functions for database management and development.|
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|
Big gains for Relational Database Management Systems in DB-Engines Ranking
|Recent citations in the news|
RDBMS Software Market Size [2023-2030] | Rising Trends, Growing ...
Two flaws in Apache SuperSet allow to remotely hack servers
Webinar: A breakthrough in forensic review has arrived!
VB.NET SQL Examples for Querying Databases Efficiently - MUO
How LLMs Helped Me Build an ODBC Plugin for Steampipe
provided by Google News
The Apache® Software Foundation Announces Annual Report for ...
Trafodion : un dragon gallois dans les bases translytiques Open ...
provided by Google News
Species Habitat Modeling Program Contractor (Remote)
IoS Developer (Sr/Jr)
Ecological Modeler/Biodiversity Data Scientist (Remote)
iOS Developer I
Share this page