DBDB.io The Encyclopedia of Database Systems · Est. 2017
Login
Database of Databases

Database Entry

Swarm64

Acquired Company OLAP

Swarm64 is a fork of PostgreSQL that uses extensions to improve OLAP query performance.

Website
https://www.servicenow.com[01]
Tech Docs
https://www.servicenow.com[01]
Twitter
@Swarm64
Developer
Country of Origin
DE
Start Year
2013 [03]
End Year
2021
Acquired By
Project Type
Commercial
Derived From
PostgreSQL
Compatible With
PostgreSQL
License
Proprietary

Database Entry

Swarm64

Acquired Company OLAP

Swarm64 is a fork of PostgreSQL that uses extensions to improve OLAP query performance.

History[02]

Swarm64 originally started as a FPGA-based PostgreSQL accelerator. In 2020, the company pivoted to provide a software-only optimized version of PostgreSQL.

The company was acquired in 2021 by ServiceNow.

Checkpoints

Consistent

Same as PostgreSQL

Compression

Naïve (Page-Level)

Same as PostgreSQL

Concurrency Control

Multi-version Concurrency Control (MVCC) Two-Phase Locking (Deadlock Detection)

Same as PostgreSQL

Data Model

Relational

Same as PostgreSQL

Foreign Keys

Supported

Same as PostgreSQL

Indexes

B+Tree Hash Table Inverted Index (Full Text) Block Range Index (BRIN)

Same as PostgreSQL

Isolation Levels

Read Uncommitted Read Committed Serializable Snapshot Isolation Repeatable Read

Same as PostgreSQL

Joins

Nested Loop Join Hash Join Sort-Merge Join

Same as PostgreSQL

Logging

Physical Logging

Same as PostgreSQL

Parallel Execution

Intra-Operator (Horizontal)

Same as PostgreSQL

Query Compilation

JIT Compilation

Same as PostgreSQL

Query Execution

Tuple-at-a-Time Model

Same as PostgreSQL

Query Interface

PL/SQL

Same as PostgreSQL

Storage Architecture

Disk-oriented

Same as PostgreSQL

Storage Format

Custom

Same as PostgreSQL

Storage Model

N-ary Storage Model (Row/Record)

Same as PostgreSQL

Storage Organization

Heaps

Same as PostgreSQL

Stored Procedures

Supported

Same as PostgreSQL

System Architecture

Shared-Everything

Same as PostgreSQL

User-Defined Functions

PL/SQL Python Perl TCL

Same as PostgreSQL

Views

Virtual Views Materialized Views

Same as PostgreSQL

Derivative Systems
RaptorDB RaptorDB
People Also Viewed
XtremeData XtremeData OrioleDB OrioleDB Hadapt Hadapt Yellowbrick Yellowbrick

Citations

4 sources
  1. ServiceNow - Put AI to Work servicenow.com
  2. https://www.zdnet.com/article/open-source-postgresql-on-steroids-swarm64-database-acceleration-software-for-performance-improvement-and-analytics zdnet.com
  3. https://www.crunchbase.com/organization/swarm64 crunchbase.com
  4. ServiceNow acquires database performance company Swarm64 | ZDNET zdnet.com
Revision #6 Last Updated: