DB-EnginesEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > Ingres vs. Lovefield vs. RDF4J vs. Trafodion vs. Yanza

System Properties Comparison Ingres vs. Lovefield vs. RDF4J vs. Trafodion vs. Yanza

Editorial information provided by DB-Engines
NameIngres  Xexclude from comparisonLovefield  Xexclude from comparisonRDF4J infoformerly known as Sesame  Xexclude from comparisonTrafodion  Xexclude from comparisonYanza  Xexclude from comparison
Apache Trafodion has been retired in 2021. Therefore it is excluded from the DB-Engines Ranking.Yanza seems to be discontinued. Therefore it is excluded from the DB-Engines Ranking.
DescriptionWell established RDBMSEmbeddable relational database for web apps written in pure JavaScriptRDF4J is a Java framework for processing RDF data, supporting both memory-based and a disk-based storage.Transactional SQL-on-Hadoop DBMSTime Series DBMS for IoT Applications
Primary database modelRelational DBMSRelational DBMSRDF storeRelational DBMSTime Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score3.52
Rank#80  Overall
#44  Relational DBMS
Score0.22
Rank#302  Overall
#137  Relational DBMS
Score0.77
Rank#214  Overall
#8  RDF stores
Websitewww.actian.com/­databases/­ingresgoogle.github.io/­lovefieldrdf4j.orgtrafodion.apache.orgyanza.com
Technical documentationdocs.actian.com/­ingresgithub.com/­google/­lovefield/­blob/­master/­docs/­spec_index.mdrdf4j.org/­documentationtrafodion.apache.org/­documentation.html
DeveloperActian CorporationGoogleSince 2016 officially forked into an Eclipse project, former developer was Aduna Software.Apache Software Foundation, originally developed by HPYanza
Initial release1974 infooriginally developed at University Berkely in early 1970s2014200420142015
Current release12.0, July 20242.1.12, February 20172.3.0, February 2019
License infoCommercial or Open SourcecommercialOpen Source infoApache 2.0Open Source infoEclipse Distribution License (EDL), v1.0.Open Source infoApache 2.0commercial infofree version available
Cloud-based only infoOnly available as a cloud servicenonononono infobut mainly used as a service provided by Yanza
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCJavaScriptJavaC++, Java
Server operating systemsAIX
HP Open VMS
HP-UX
Linux
Solaris
Windows
server-less, requires a JavaScript environment (browser, Node.js) infotested with Chrome, Firefox, IE, SafariLinux
OS X
Unix
Windows
LinuxWindows
Data schemeyesyesyes infoRDF Schemasyesschema-free
Typing infopredefined data types such as float or dateyesyesyesyesno
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.no infobut tools for importing/exporting data from/to XML-files availablenonono
Secondary indexesyesyesyesyesno
SQL infoSupport of SQLyesSQL-like query language infovia JavaScript builder patternnoyesno
APIs and other access methods.NET Client API
JDBC
ODBC
proprietary protocol (OpenAPI)
Java API
RIO infoRDF Input/Output
Sail API
SeRQL infoSesame RDF Query Language
Sesame REST HTTP Protocol
SPARQL
ADO.NET
JDBC
ODBC
HTTP API
Supported programming languagesJavaScriptJava
PHP
Python
All languages supporting JDBC/ODBC/ADO.Netany language that supports HTTP calls
Server-side scripts infoStored proceduresyesnoyesJava Stored Proceduresno
TriggersyesUsing read-only observersyesnoyes infoTimer and event based
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioning infoIngres Star to access multiple databases simultaneouslynonenoneShardingnone
Replication methods infoMethods for redundantly storing data on multiple nodesIngres Replicatornonenoneyes, via HBasenone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononoyes infovia user defined functions and HBaseno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesyesyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACID infoIsolation support depends on the API usedACIDno
Concurrency infoSupport for concurrent manipulation of datayes infoMVCCyesyesyesyes
Durability infoSupport for making data persistentyesyes, by using IndexedDB or the cloud service Firebase Realtime Databaseyes infoin-memory storage is supported as wellyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyes infousing MemoryDBno
User concepts infoAccess controlfine grained access rights according to SQL-standardnonofine grained access rights according to SQL-standardno

More information provided by the system vendor

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
IngresLovefieldRDF4J infoformerly known as SesameTrafodionYanza
Recent citations in the news

Save Mart to Manage Employees With Open-Source Database
27 October 2024, Supermarket News

Actian Launches Ingres 12.0 Database
4 June 2024, PR Newswire

New startup from Postgres creator puts the database at heart of software stack
12 March 2024, TechCrunch

Postgres pioneer Michael Stonebraker promises to upend the database once more
26 December 2023, The Register

Actian Launches Ingres as a Fully-Managed Cloud Service
24 September 2021, Integration Developers

provided by Google News

Apache Software Foundation Releases its 2019 Fiscal Year Report
17 August 2019, Open Source For You

Low-latency, distributed database architectures are critical for emerging fog applications
7 April 2022, Embedded Computing Design

provided by Google News



Share this page

Featured Products

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

SingleStore logo

The data platform to build your intelligent applications.
Try it free.

Present your product here