Axibase Time Series Database
Hadoop-based time series database with SQL, rule-engine, and visualization.
Batch Data
Upload CSV files directly into the database for bulk import. Use network API to upload nmon archives with wget/curl or telnet.
Query data on schedule from web services, FTP/SFTP/SCP servers, and network devices using industry-standard protocols : JMX, SNMP, CSV/TSV, and JSON.
Offload and historize data from relational databases.
Built-in Integrations
Leverage ATSD storage drivers and extensive protocol support to consolidate statistics, configurations, and messages from:
Rule Engine
Configure alerts in the built-in rule engine with time/count-based sliding windows, aggregation, and forecasting functions. Deliver alerts to enterprise consoles, email, ticketing systems, or execute system commands.
Versioning
Provides security- and accounting-oriented audit trail and traceable data re-conciliation at series value granularity.
Scalability
ATSD leverages Hadoop File System and HBase non-relational database architecture for linear scalability and fault-tolerance on commodity hardware. The system can be deployed in a fully-distributed mode as well as in a single virtual machine or Docker container.
Query Language
Support for SQL with time-series extensions for scheduled reporting and ad-hoc analysis.
SELECT entity, entity.tags.location, datetime, VALUE FROM 'cpu_allocated_usage_pct' WHERE entity.groups IN ('svl-2', 'svl-2') AND datetime >= current_hour WITH INTERPOLATE(30 SECOND, LINEAR) |
Rich Schema
In addition to time series, ATSD supports properties, which are a collection of key-values. This data type can be used to model relationships and describe entities in a way that is specific to the given application domain.
By storing metadata and time series in the same database, ATSD allows you to build smarter analytical queries that benefit from data locality.
Storage Efficiency
ATSD implements optimized, compressed storage for numeric time series with the ability to customize compression algorithms for short-term and long-term data. Storing a single time/value sample without precision loss in ATSD requires up to 50 times less disk space compared to other databases.
Extensive API
ATSD provides REST API methods to insert and query series, properties, and messages as well as to manage metadata about the monitored objects.
Role Based Access Control
Role based user access and granular entity permissions enable ATSD deployment in secure enterprise and multi-tenant environments.
Non-parametric Forecasting
Built-in Holt-Winters and ARIMA forecasts allow you to quickly compute expected system state and make proactive decisions if observed values are outside of the confidence interval. In autopilot mode, ATSD is capable of identifying the best parameters for each algorithm, which greatly improves forecast accuracy.
Visualization
Integrated portals with an extensive widget library to explore detailed and aggregated data, find patterns, and assemble real-time dashboards.