DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Firebird vs. Rockset vs. STSdb vs. Teradata

System Properties Comparison Firebird vs. Rockset vs. STSdb vs. Teradata

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameFirebird  Xexclude from comparisonRockset  Xexclude from comparisonSTSdb  Xexclude from comparisonTeradata  Xexclude from comparison
DescriptionFirebird is an open source RDBMS forked from Borland's InterBaseA scalable, reliable search and analytics service in the cloud, built on RocksDBKey-Value Store with special method for indexing infooptimized for high performance using a special indexing methodA hybrid cloud data analytics software platform (Teradata Vantage)
Primary database modelRelational DBMSDocument storeKey-value storeRelational DBMS
Secondary database modelsRelational DBMS
Search engine
Document store
Graph DBMS
Spatial DBMS
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score25.37
Rank#32  Overall
#19  Relational DBMS
Score0.86
Rank#220  Overall
#34  Document stores
Score0.18
Rank#336  Overall
#49  Key-value stores
Score65.23
Rank#18  Overall
#12  Relational DBMS
Websitewww.firebirdsql.orgrockset.comgithub.com/­STSSoft/­STSdb4www.teradata.com
Technical documentationwww.firebirdsql.org/­en/­reference-manualsdocs.rockset.comdocs.teradata.com
DeveloperFirebird FoundationRocksetSTS Soft SCTeradata
Initial release2000 infoAs fork of Borland's InterBase201920111984
Current release4.0.2, August 20224.0.8, September 2015Teradata Vantage 1.0 MU2, January 2019
License infoCommercial or Open SourceOpen Source infoInitial Developer's Public LicensecommercialOpen Source infoGPLv2, commercial license availablecommercial
Cloud-based only infoOnly available as a cloud servicenoyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC and C++C++C#
Server operating systemsAIX
FreeBSD
HP-UX
Linux
OS X
server-less infoFirebird Embedded Server
Solaris
Unix
Windows
hostedWindowshosted
Linux
Data schemeyesschema-freeyesyes
Typing infopredefined data types such as float or dateyesdynamic typingyes infoprimitive types and user defined types (classes)yes
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 infoingestion from XML files supportedyes
Secondary indexesyesall fields are automatically indexednoyes infoJoin-index to prejoin tables, aggregate index, sparse index, hash index
SQL infoSupport of SQLyesRead-only SQL queries, including JOINsnoyes infoSQL 2016 + extensions
APIs and other access methodsADO.NET
C/C++ API
JDBC infoJaybird
ODBC
OLE DB
HTTP REST.NET Client API.NET Client API
HTTP REST
JDBC
JMS Adapter
ODBC
OLE DB
Supported programming languagesC
C#
C++
Delphi
Java
JavaScript infoNode.js
Lua
Perl
PHP
Python
Ruby
Go
Java
JavaScript (Node.js)
Python
C#
Java
C
C++
Cobol
Java (JDBC-ODBC)
Perl
PL/1
Python
R
Ruby
Server-side scripts infoStored proceduresPSQLnonoyes infoUDFs, stored procedures, table functions in parallel
Triggersyesnonoyes
Partitioning methods infoMethods for storing different data on different nodesnoneAutomatic shardingnoneSharding infoHashing
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replicationyesnoneMulti-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesnonoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnonoACID
Concurrency infoSupport for concurrent manipulation of datayes infoFeatures a multi-generational MVCC architecture, readers do not block writersyesyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes
User concepts infoAccess controlUsers with fine-grained authorization conceptAccess rights for users and organizations can be defined via Rockset consolenofine 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,
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
FirebirdRocksetSTSdbTeradata
DB-Engines blog posts

Teradata is the most popular data warehouse DBMS
2 April 2013, Paul Andlinger

show all

Recent citations in the news

MindsDB is now the leading and fastest growing applied ML platform in the world
3 November 2022, PR Newswire UK

Database Software Market Study Providing In-depth Analysis on Top Key Companies | Oracle, Microsoft, IBM and More
22 November 2022, Digital Journal

What is ETL? Top ETL Tools
20 November 2022, MarkTechPost

Diamondback to acquire RedBird and Ontario Teachers'-backed FireBird
12 October 2022, PE Hub

Enterprise Database Software Market 2022 Industry Development and Growth Forecast to 2028
28 October 2022, The Knox Reports

provided by Google News

Rockset Achieves 84% Faster Real-Time Analytics With Intel Processors
16 November 2022, Datanami

insideBIGDATA Latest News – 11/21/2022
21 November 2022, insideBIGDATA

IoT Tech Is Making the NFL Smarter
14 November 2022, IoT World Today

Rockset Adds Snowflake Connector for Real-time Analytics Across Streaming and Historical Data
15 June 2022, GlobeNewswire

Do businesses really need real-time analytics? Data startups are counting on it.
31 May 2022, Protocol

provided by Google News

We Like These Underlying Return On Capital Trends At Teradata (NYSE:TDC)
25 November 2022, Simply Wall St

Teradata Reports Third Quarter 2022 Financial Results
7 November 2022, Business Wire

Cloudian Object Storage Now Integrated with Teradata Vantage
3 November 2022, Yahoo Finance

How Teradata's AI-Powered Cloud Analytics Solutions Help American Airlines Reschedule Canceled Flights
18 November 2022, Acceleration Economy

Teradata Q3 2022 Earnings Preview (NYSE:TDC)
6 November 2022, Seeking Alpha

provided by Google News

Job opportunities

Software Engineer-Entry Level
LOCKHEED MARTIN CORPORATION, Mount Laurel, NJ

Software Engineer (Signal Simulation & Injection) - Early Career
LOCKHEED MARTIN CORPORATION, Moorestown, NJ

DevSecOps Software Engineer- Early Career
LOCKHEED MARTIN CORPORATION, Mount Laurel, NJ

Senior Financial Investigator
Firebird AST, Washington, DC

Group Sales Manager
Coachella Valley Firebirds, Palm Desert, CA

Sales Engineer (UK)
rockset, Remote

Adept Software Engineer
CBT Nuggets, Eugene, OR

Product Solutions Engineer
rockset, Remote

Data Architect
proit-inc, Irvine, CA

Data Architect
PRO IT, Irvine, CA

Teradata Database Administrator, Managed Services
Teradata, Dallas, TX

Director, Strategy
Teradata, California

Sales Analytics Specialist - Government
Teradata, California

Client Services Executive
Teradata, Chicago, IL

Senior IT Auditor
Teradata, San Diego, CA

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Redis logo

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

The definitive guide for Cassandra

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

AllegroGraph logo

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

Neo4j logo

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

Present your product here