DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > AlaSQL vs. JaguarDB vs. OpenSearch vs. Virtuoso

System Properties Comparison AlaSQL vs. JaguarDB vs. OpenSearch vs. Virtuoso

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAlaSQL  Xexclude from comparisonJaguarDB  Xexclude from comparisonOpenSearch  Xexclude from comparisonVirtuoso  Xexclude from comparison
DescriptionJavaScript DBMS libraryPerformant, highly scalable DBMS for AI and IoT applicationsA distributed, RESTful search and analytics engine forked from Elasticsearch and based on Apache LuceneVirtuoso is a multi-model hybrid-RDBMS that supports management of data represented as relational tables and/or property graphs
Primary database modelDocument store
Relational DBMS
Key-value storeSearch engineDocument store
Graph DBMS
Native XML DBMS
Relational DBMS
RDF store
Search engine
Secondary database modelsSpatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.70
Rank#238  Overall
#35  Document stores
#114  Relational DBMS
Score0.00
Rank#377  Overall
#59  Key-value stores
Score10.31
Rank#48  Overall
#4  Search engines
Score5.95
Rank#71  Overall
#13  Document stores
#3  Graph DBMS
#2  Native XML DBMS
#38  Relational DBMS
#2  RDF stores
#9  Search engines
Websitealasql.orgwww.datajaguar.comgithub.com/­opensearch-project
opensearch.org
virtuoso.openlinksw.com
Technical documentationgithub.com/­agershun/­alasqlwww.datajaguar.com/­support.phpopensearch.org/­docs/­latestdocs.openlinksw.com/­virtuoso
DeveloperAndrey Gershun & Mathias R. WulffDataJaguar, Inc.Amazon Web ServicesOpenLink Software
Initial release2014201520211998
Current release2.9.4 September 20182.2.0, August 20227.2.7, May 2022
License infoCommercial or Open SourceOpen Source infoMIT-LicenseOpen Source infoGPL V3.0Open Source infoApache Version 2.0Open Source infoGPLv2, extended commercial license available
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Aiven for OpenSearch: Fully managed open source search and analytics suite including search engine, NoSQL document database, and visualization interface.
Implementation languageJavaScriptC++ infothe server part. Clients available in other languagesJavaC
Server operating systemsserver-less, requires a JavaScript environment (browser, Node.js)LinuxAll OS with a Java VMAIX
FreeBSD
HP-UX
Linux
OS X
Solaris
Windows
Data schemeschema-freeyesschema-free infoFlexible type definitions. Once a type is defined, it is persistentyes infoSQL - Standard relational schema
RDF - Quad (S, P, O, G) or Triple (S, P, O)
XML - DTD, XML Schema
DAV - freeform filesystem objects, plus User Defined Types a/k/a Dynamic Extension Type
Typing infopredefined data types such as float or datenoyesyesyes
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.nonoyes
Secondary indexesnoyesyes infoAll search fields are automatically indexedyes
SQL infoSupport of SQLClose to SQL99, but no user access control, stored procedures and host language bindings.A subset of ANSI SQL is implemented infobut no views, foreign keys, triggersSQL-like query languageyes infoSQL-92, SQL-200x, SQL-3, SQLX
APIs and other access methodsJavaScript APIJDBC
ODBC
Java API
RESTful HTTP/JSON API
ADO.NET
GeoSPARQL
HTTP API
JDBC
Jena RDF API
ODBC
OLE DB
RDF4J API
RESTful HTTP API
Sesame REST HTTP Protocol
SOAP webservices
SPARQL 1.1
WebDAV
XPath
XQuery
XSLT
Supported programming languagesJavaScriptC
C++
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Scala
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby infoElasticsearch client
.Net
C
C#
C++
Java
JavaScript
Perl
PHP
Python
Ruby
Visual Basic
Server-side scripts infoStored proceduresnonoyesyes infoVirtuoso PL
Triggersyesnoyes infoby using the 'percolation' featureyes
Partitioning methods infoMethods for storing different data on different nodesnoneShardingShardingyes
Replication methods infoMethods for redundantly storing data on multiple nodesnoneMulti-source replicationyesChain, star, and bi-directional replication
Multi-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyes
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneEventual ConsistencyEventual Consistency infoSynchronous doc based replication. Get by ID may show delays up to 1 sec. Configurable write consistency: one, quorum, allImmediate Consistency
Foreign keys infoReferential integrityyesnonoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayes infoonly for local storage and DOM-storagenonoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyes infoby using IndexedDB, SQL.JS or proprietary FileStorageyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnoyes
User concepts infoAccess controlnorights management via user accountsFine-grained Attribute-Based Access Control (ABAC) in addition to typical coarse-grained Role-Based Access Control (RBAC) according to SQL-standard. Pluggable authentication with supported standards (LDAP, Active Directory, Kerberos)
More information provided by the system vendor
AlaSQLJaguarDBOpenSearchVirtuoso
Specific characteristicsVirtuoso is a modern multi-model RDBMS for managing data represented as tabular relations...
» more
Competitive advantagesPerformance & Scale — as exemplified by DBpedia and the LOD Cloud it spawned, i.e.,...
» more
Typical application scenariosUsed for — Analytics/BI Conceptual Data Virtualization Enterprise Knowledge Graphs...
» more
Key customersBroad use across enterprises and governments including — European Union (EU) US Government...
» more
Market metricsLargest installed-base ​of Multi-Model RDBMS for AI-friendly Knowledge Graphs Platform...
» more
Licensing and pricing modelsAvailable in both Commercial Enterprise and Open Source (GPL v2) Editions Feature...
» more

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
3rd partiesAiven for OpenSearch comes with OpenSearch Dashboards included, giving a fully-featured user interface and visualization platform for your data.
» more

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

More resources
AlaSQLJaguarDBOpenSearchVirtuoso
Recent citations in the news

AWS-Announces-Five-New-Database-and-Analytics-Capabilities
30 November 2022, Amazon Press Release

Data management, sustainability, and high performance computing at the forefront of AWS re:Invent 2022
2 December 2022, IT World Canada

IronCore Labs Launches Advanced Searchable Encryption Features
15 November 2022, PR Newswire

What AWS customers really care about
28 November 2022, InfoWorld

AWS unveils new supply chain, data and analytics offerings
29 November 2022, CRN Australia

provided by Google News

Job opportunities

Developer
Axle Informatics, Rockville, MD

Applications Developer
Axle Informatics, Rockville, MD

Data Engineer
ZM Financial Systems, New York, NY

Data Engineer (python, aws)
Moody's, New York, NY

Junior Data Scientist - Remote US
Crum & Forster, Morristown, NJ

Microstrategy Developer
Intone Networks, Remote

Senior DevOps Engineer
The College Board, Remote

jobs by Indeed



Share this page

Featured Products

Redis logo

The world’s most loved real‑time data platform.
Try free

Neo4j logo

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

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Present your product here