DBMS > Apache Pinot vs. dBASE vs. GraphDB vs. STSdb

System Properties Comparison Apache Pinot vs. dBASE vs. GraphDB vs. STSdb

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines

Name

Description

Realtime distributed OLAP datastore, designed to answer OLAP queries with low latency

dBase was one of the first databases with a development environment on PC's. Its latest version dBase V is still sold as dBase classic, which needs a DOS Emulation. The up-to-date product is dBase plus.

Enterprise-ready RDF and graph database with efficient reasoning, cluster and external index synchronization support. It supports also SQL JDBC access to Knowledge Graph and GraphQL over SPARQL.

Key-Value Store with special method for indexing

optimized for high performance using a special indexing method

Primary database model

Relational DBMS

Graph DBMS
RDF store

Key-value store

DB-Engines Ranking measures the popularity of database management systems
Trend Chart

Score	0.35
Rank	#274	Overall
	#128	Relational DBMS

Score	9.16
Rank	#43	Overall
	#27	Relational DBMS

Score	2.76
Rank	#99	Overall
	#8	Graph DBMS
	#4	RDF stores

Score	0.03
Rank	#365	Overall
	#54	Key-value stores

Website

pinot.apache.org

www.dbase.com

www.ontotext.com

github.com/STSSoft/STSdb4

Technical documentation

docs.pinot.apache.org

www.dbase.com/support/knowledgebase

graphdb.ontotext.com/documentation

Social network pages

Developer

Apache Software Foundation and contributors

Asthon Tate

Ontotext

STS Soft SC

Initial release

2015

1979

2000

2011

Current release

1.0.0, September 2023

dBASE 2019, 2019

10.4, October 2023

4.0.8, September 2015

License

Commercial or Open Source

Open Source

Apache Version 2.0

commercial

Some plugins of GraphDB Workbench are open sourced

Open Source

GPLv2, commercial license available

Cloud-based only

Only available as a cloud service

DBaaS offerings (sponsored links)

Database as a Service

Providers of DBaaS offerings, please contact us to be listed.

Implementation language

Java

Server operating systems

All OS with a Java JDK11 or higher

DOS

dBase Classic
Windows

dBase Pro

All OS with a Java VM
Linux
OS X
Windows

Windows

Data scheme

yes

schema-free and OWL/RDFS-schema support; RDF shapes

yes

Typing

predefined data types such as float or date

yes

primitive types and user defined types (classes)

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.

Secondary indexes

yes

yes, supports real-time synchronization and indexing in SOLR/Elastic search/Lucene and GeoSPARQL geometry data indexes

SQL

Support of SQL

SQL-like query language

stored SPARQL accessed as SQL using Apache Calcite through JDBC/ODBC

APIs and other access methods

JDBC

none

The IDE can access other DBMS or ODBC-sources.

GeoSPARQL
GraphQL
GraphQL Federation
Java API
JDBC
RDF4J API
RDFS
RIO
Sail API
Sesame REST HTTP Protocol
SPARQL 1.1

.NET Client API

Supported programming languages

Go
Java
Python

dBase proprietary IDE

.Net
C#
Clojure
Java
JavaScript (Node.js)
PHP
Python
Ruby
Scala

C#
Java

Server-side scripts

Stored procedures

The IDE can access stored procedures in other database systems.

well-defined plugin interfaces; JavaScript server-side extensibility

Triggers

Partitioning methods

Methods for storing different data on different nodes

horizontal partitioning

none

Replication methods

Methods for redundantly storing data on multiple nodes

none

Multi-source replication

none

MapReduce

Offers an API for user-defined Map/Reduce methods

Consistency concepts

Methods to ensure consistency in a distributed system

Immediate Consistency, Eventual consistency (configurable in cluster mode per master or individual client request)

Foreign keys

Referential integrity

yes

Constraint checking

Transaction concepts

Support to ensure data integrity after non-atomic manipulations of data

not for dBase internal data, but IDE does support transactions when accessing external DBMS

ACID

Concurrency

Support for concurrent manipulation of data

yes

Durability

Support for making data persistent

yes

User concepts

Access control

Access rights for users and roles

Default Basic authentication through RDF4J client, or via Java when run with cURL, default token-based in the Workbench or via Rest API, optional access through OpenID or Kerberos single sign-on.

More information provided by the system vendor

Specific characteristics

Ontotext GraphDB is a semantic database engine that allows organizations to build...
» more

Competitive advantages

GraphDB allows you to link text and data in big knowledge graphs. It’s easy to experiment...
» more

Typical application scenarios

Metadata enrichment and management, linked data publishing, semantic inferencing...
» more

Key customers

GraphDB provides a platform for building next-generation AI and Knowledge Graph...
» more

Market metrics

GraphDB is the most utilized semantic triplestore for mission-critical enterprise...
» more

Licensing and pricing models

GraphDB Free is a non-commercial version and is free to use. GraphDB Enterprise edition...
» more

News

GraphDB in Action: Using Semantics To Push The Envelope Of Software Engineering, Machine Learning, and E-Health Domains
11 September 2024

Accelerating End-to-end Knowledge Graph Solutions with Ontotext’s LinkedLifeData Inventory: The Case of Target Discovery
30 August 2024

Using Entity Linking to Turn Your Graph into a Knowledge Graph
23 August 2024

Considerations to Creating a Graph Center of Excellence: 5 Elements to Ensure Success
22 August 2024

The Power of Knowledge Graphs – A Chat with Perfect Memory and Ontotext
16 August 2024

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

DB-Engines blog posts

DB-Engines Ranking coverage expanded to 169 database management systems
3 June 2013, Paul Andlinger

show all

Recent citations in the news

Build a real-time analytics solution with Apache Pinot on AWS
6 August 2024, AWS Blog

Pinot for Low-Latency Offline Table Analytics
29 August 2024, Uber

StarTree broadly enhances Apache Pinot-based analytics platform
8 May 2024, SiliconANGLE News

Open source Apache Pinot advances as StarTree boosts real-time analytics and observability
8 May 2024, VentureBeat

StarTree Makes Observability Case for Apache Pinot Database
8 May 2024, DevOps.com

provided by Google News

Added Namespace and lost all the PHP OOPs Classes
5 November 2018, SitePoint

FlytBase & DroneBase partner up to provide fully autonomous Drone-in-a-Box solutions in Italy
14 December 2021, sUAS News

Estimating systems discuss body shops’ options for managing BMS communication
17 May 2021, Repairer Driven News

5 ancient software programs we refuse to give up
31 July 2019, PCWorld

Helping the World to Breathe, a Respiratory H
18 November 2021, EurekAlert

provided by Google News

Ontotext’s GraphDB Solution Now Available on the Microsoft Azure Marketplace
17 January 2024, Datanami

Ontotext's GraphDB Solution Now Available in the AWS Marketplace
9 October 2023, PR Newswire

Ontotext Platform 3.0 for Enterprise Knowledge Graphs Released
18 December 2019, KDnuggets

Ontotext's GraphDB 10 Brings Modern Data Architectures to the Mainstream with Better Resilience and Еаsier Operations
5 July 2022, PR Newswire

Knowledge graphs change the nature of business intelligence
8 April 2024, TechHQ

provided by Google News

Share this page