SQL queries over very large datasets
Powerful query engine distributes ANSI SQL queries and runs them in parallel across commodity hardware.
Real-time SQL on Hadoop
CitusDB colocates database instances on Hadoop nodes, and removes any network bottlenecks. Lets you instantly run SQL queries on Hadoop
clusters without having to load any data into the database.
Add nodes incrementally as your data volume or performance requirements increase. Linearly scale out to hundreds of nodes using CitusDB's block-based architecture.
CitusDB recovers from failures in real-time. To achieve this, the database intelligently distributes the work for any failed nodes among the remaining nodes in the cluster.
PostgreSQL ecosystem tools. ODBC/JDBC compliance
Get the benefits of the most recent PostgreSQL version (v9.3). Connect to CitusDB through ODBC/JDBC to visualize your data with leading reporting tools.
Semi-structured data support
Write a foreign data wrapper, and run distributed SQL queries on csv, json, and log files without loading any data. Query external data sources such as MongoDB, by uploading only table metadata.
Optimized for append-only event data
CitusDB is an analytics database, where you load data in batches. It is ideal for ad-hoc analysis, reporting, and data exploration on your time-series data; but not for modifying it in real-time.
Get sub-second response times to your key-value lookups. Perform aggregations, filters, projections, joins across large data sets in seconds. Achieve high performance through advanced disk and network I/O optimizations. Get your results 10x faster than dedicated analytics appliances.
Deploy anywhere: On-premise or in the cloud
No special expectations from hardware or the network. Use standard machines and network connections (100 Mbps+) to build your analytics infrastructure in a flexible, cost-efficient way.
Easy to download and use
Download the software
with one click, install it on a Linux box and get up and running in as few as 5 commands. Experience CitusDB for yourself by using sample data and examples available on our site, or better still, by loading your own data.