Best Time Series Databases for Small Business

Raima Database Manager, an embedded time series database that can be used for Edge and IoT devices, can run in-memory. It is a lightweight, secure, and extremely powerful RDBMS. It has been field tested by more than 20 000 developers around the world and has been deployed in excess of 25 000 000 times.

BangDB integrates AI, streaming and graph analytics within its DB to allow users to deal complex data of all types, such as text, images and objects. Real-time data processing and analysis Many types of data are required to be ingested and processed simultaneously for today's use cases. BangDB supports almost all the data formats that are useful to users to solve their problem quickly. The rise of real-time data allows for real-time streaming and predictive analytics to optimize business operations.

Redis Labs is the home of Redis. Redis Enterprise is the best Redis version. Redis Enterprise is more than a cache. Redis Enterprise can be free in the cloud with NoSQL and data caching using the fastest in-memory database. Redis can be scaled, enterprise-grade resilience, massive scaling, ease of administration, and operational simplicity. Redis in the Cloud is a favorite of DevOps. Developers have access to enhanced data structures and a variety modules. This allows them to innovate faster and has a faster time-to-market. CIOs love the security and expert support of Redis, which provides 99.999% uptime. Use relational databases for active-active, geodistribution, conflict distribution, reads/writes in multiple regions to the same data set. Redis Enterprise offers flexible deployment options. Redis Labs is the home of Redis. Redis JSON, Redis Java, Python Redis, Redis on Kubernetes & Redis gui best practices.

NumXL is a suite time series Excel add-ins. It turns your Microsoft Excel application into a top-class time series software and an econometrics tool. It offers the same statistical accuracy as more expensive statistical packages. NumXL integrates with Excel natively, adding scores of econometric function, a rich set shortcuts, as well as intuitive user interfaces to help you navigate the entire process. (1) Summary Statistics - Gini and Hurst, KDE etc. (2) Statistical Testing - Normality, Stationarity, cointegration, etc. (3) Brown's, Holt's & Winter's exponential smoothing (4) ARMA/ARIMA/SARIMA & X12ARIMA (5) ARMAX/SARIMAX (6) GARCH/E-GARCH & E-GARCH

InfluxDB is a purpose-built data platform designed to handle all time series data, from users, sensors, applications and infrastructure — seamlessly collecting, storing, visualizing, and turning insight into action. With a library of more than 250 open source Telegraf plugins, importing and monitoring data from any system is easy. InfluxDB empowers developers to build transformative IoT, monitoring and analytics services and applications. InfluxDB’s flexible architecture fits any implementation — whether in the cloud, at the edge or on-premises — and its versatility, accessibility and supporting tools (client libraries, APIs, etc.) make it easy for developers at any level to quickly build applications and services with time series data. Optimized for developer efficiency and productivity, the InfluxDB platform gives builders time to focus on the features and functionalities that give their internal projects value and their applications a competitive edge. To get started, InfluxData offers free training through InfluxDB University.

Telegraf is an open-source server agent that helps you collect metrics from your sensors, stacks, and systems. Telegraf is a plugin-driven agent that collects and sends metrics and events from systems, databases, and IoT sensors. Telegraf is written in Go. It compiles to a single binary and has no external dependencies. It also requires very little memory. Telegraf can gather metrics from a wide variety of inputs and then write them into a wide range of outputs. It can be easily extended by being plugin-driven for both the collection and output data. It is written in Go and can be run on any system without external dependencies. It is easy to collect metrics from your endpoints with the 300+ plugins that have been created by data experts in the community.

What makes eXtremeDB platform independent? - Hybrid storage of data. Unlike other IMDS databases, eXtremeDB databases are all-in-memory or all-persistent. They can also have a mix between persistent tables and in-memory table. eXtremeDB's Active Replication Fabric™, which is unique to eXtremeDB, offers bidirectional replication and multi-tier replication (e.g. edge-to-gateway-to-gateway-to-cloud), compression to maximize limited bandwidth networks and more. - Row and columnar flexibility for time series data. eXtremeDB supports database designs which combine column-based and row-based layouts in order to maximize the CPU cache speed. - Client/Server and embedded. eXtremeDB provides data management that is fast and flexible wherever you need it. It can be deployed as an embedded system and/or as a clients/server database system. eXtremeDB was designed for use in resource-constrained, mission-critical embedded systems. Found in over 30,000,000 deployments, from routers to satellites and trains to stock market world-wide.

Instaclustr, the Open Source-as a Service company, delivers reliability at scale. We provide database, search, messaging, and analytics in an automated, trusted, and proven managed environment. We help companies focus their internal development and operational resources on creating cutting-edge customer-facing applications. Instaclustr is a cloud provider that works with AWS, Heroku Azure, IBM Cloud Platform, Azure, IBM Cloud and Google Cloud Platform. The company is certified by SOC 2 and offers 24/7 customer support.

Fauna is a data API that supports rich clients with serverless backends. It provides a web-native interface that supports GraphQL, custom business logic, frictionless integration to the serverless ecosystem, and a multi-cloud architecture that you can trust and grow with.

Real-time analytics on raw data. Live ingest from S3, DynamoDB, DynamoDB and more. Raw data can be accessed as SQL tables. In minutes, you can create amazing data-driven apps and live dashboards. Rockset is a serverless analytics and search engine that powers real-time applications and live dashboards. You can directly work with raw data such as JSON, XML and CSV. Rockset can import data from real-time streams and data lakes, data warehouses, and databases. You can import real-time data without the need to build pipelines. Rockset syncs all new data as it arrives in your data sources, without the need to create a fixed schema. You can use familiar SQL, including filters, joins, and aggregations. Rockset automatically indexes every field in your data, making it lightning fast. Fast queries are used to power your apps, microservices and live dashboards. Scale without worrying too much about servers, shards or pagers.

Riak®, TS is an enterprise-grade NoSQL Time Series Database that is specifically designed for IoT data and Time Series data. It can ingest, transform, store, and analyze massive amounts of time series information. Riak TS is designed to be faster than Cassandra. Riak TS masterless architecture can read and write data regardless of network partitions or hardware failures. Data is evenly distributed throughout the Riak ring. By default, there are three copies of your data. This ensures that at least one copy is available for reading operations. Riak TS is a distributed software system that does not have a central coordinator. It is simple to set up and use. It is easy to add or remove nodes from a cluster thanks to the masterless architecture. Riak TS's masterless architecture makes it easy for you to add or remove nodes from your cluster. Adding nodes made of commodity hardware to your cluster can help you achieve predictable and almost linear scale.

SiriDB is optimized for speed. Inserts and queries are answered quickly. You can speed up your development with the custom query language. SiriDB is flexible and can be scaled on the fly. There is no downtime when you update or expand your database. You can scale your database without losing speed. As we distribute your time series data across all pools, we make full use of all resources. SiriDB was designed to deliver unmatched performance with minimal downtime. A SiriDB cluster distributes time series across multiple pools. Each pool has active replicas that can be used for load balancing or redundancy. The database can still be accessed even if one of the replicas is unavailable.

Open-source monitoring solutions are able to power your alerting and metrics. Prometheus stores all data in time series. These are streams of timestamped value belonging to the same metric with the same labeled dimensions. Prometheus can also generate temporary derived times series as a result of queries. Prometheus offers a functional query language called PromQL, which allows the user to select and aggregate time series data real-time. The expression result can be displayed as a graph or tabular data in Prometheus’s expression browser. External systems can also consume the HTTP API. Prometheus can be configured using command-line flags or a configuration file. The command-line flags can be used to configure immutable system parameters such as storage locations and the amount of data to be kept on disk and in memory. . Download: https://sourceforge.net/projects/prometheus.mirror/

The enterprise database for time series, documents, and vectors. Store any type data and combine the simplicity and scalability NoSQL with SQL. CrateDB is a distributed database that runs queries in milliseconds regardless of the complexity, volume, and velocity.

TimescaleDB is the most popular open-source relational database that supports time-series data. Fully managed or self-hosted. You can rely on the same PostgreSQL that you love. It has full SQL, rock-solid reliability and a huge ecosystem. Write millions of data points per node. Horizontally scale up to petabytes. Don't worry too much about cardinality. Reduce complexity, ask more questions and build more powerful applications. You will save money with 94-97% compression rates using best-in-class algorithms, and other performance improvements. Modern cloud-native relational database platform that stores time-series data. It is based on PostgreSQL and TimescaleDB. This is the fastest, easiest, and most reliable way to store all of your time-series information. All observability data can be considered time-series data. Time-series problems are those that require efficient solutions to infrastructure and application problems.

Warp 10 is a modular open source platform that collects, stores, and allows you to analyze time series and sensor data. Shaped for the IoT with a flexible data model, Warp 10 provides a unique and powerful framework to simplify your processes from data collection to analysis and visualization, with the support of geolocated data in its core model (called Geo Time Series). Warp 10 offers both a time series database and a powerful analysis environment, which can be used together or independently. It will allow you to make: statistics, extraction of characteristics for training models, filtering and cleaning of data, detection of patterns and anomalies, synchronization or even forecasts. The Platform is GDPR compliant and secure by design using cryptographic tokens to manage authentication and authorization. The Analytics Engine can be implemented within a large number of existing tools and ecosystems such as Spark, Kafka Streams, Hadoop, Jupyter, Zeppelin and many more. From small devices to distributed clusters, Warp 10 fits your needs at any scale, and can be used in many verticals: industry, transportation, health, monitoring, finance, energy, etc.

ArcadeDB allows you to manage complex models without any compromises. Polyglot Persistence is gone. There is no need to have multiple databases. ArcadeDB Multi-Model databases can store graphs and documents, key values, time series, and key values. Each model is native to the database engine so you don't need to worry about translations slowing down your computer. ArcadeDB's engine was developed with Alien Technology. It can crunch millions upon millions of records per second. ArcadeDB's traversing speed does not depend on the size of the database. It doesn't matter if your database contains a few records or a billion. ArcadeDB can be used as an embedded database on a single server. It can scale up by using Kubernetes to connect multiple servers. It is flexible enough to run on any platform that has a small footprint. Your data is protected. Our unbreakable fully transactional engine ensures durability for mission-critical production database databases. ArcadeDB uses the Raft Consensus Algorithm in order to maintain consistency across multiple servers.

Parallel query engine with symbol- and time-indexed data access. Extended SQL syntax with advanced filtering, aggregations and more. Consolidate all quotes, trades and snapshots in one place. Strategy backtesting using high-frequency data. Quantitative and market microstructure analysis. Granular transaction cost analysis and rollup report. Market surveillance and anomaly detection. Non-transparent ETF/ETN decomposition. FAST, SBE and proprietary protocols. Plain text protocol. Consolidated and direct feeds. Built-in latency monitoring tools. End-of-day archives. ETL from retail and institutional financial data platforms. Parallel SQL engine with syntax extensions. Advanced filtering via trading session, auction stage, and index composition. Optimized aggregates to OHLCV and VWAP calculations. Interactive SQL console with auto completion. API endpoint for programmatic integrtion. Scheduled SQL reporting via email, file, or web delivery. JDBC and ODBC drivers.

High-performance, cross-platform columnar historical time-series columnar data featuring: - An in-memory computation engine - A streaming processor that streams real-time - A combination of a programming language and expressive query, q

QuasarDB is Quasar's brain. It is a high-performance distributed, column-oriented, timeseries database management software system that delivers real-time data for petascale use cases. You can save up to 20X on your disk usage Quasardb compression and ingestion are unmatched. Feature extraction can be performed up to 10,000 times faster. QuasarDB is able to extract features from raw data in real-time thanks to a combination of a builtin map/reduce engine, an aggregate engine that leverages SIMD from modern processors, and stochastic indices that consume virtually no disk space.

Decisions are not to be taken lightly. Reduce the time it takes to complete machine learning projects. Our AI search engine provides instant insights, just like Google. Inaccuracy can cost you money. Patterns show what averages and KPIs are missing. TRND identifies patterns that are missing from KPIs. Empower the decision-maker. Trends are relevant to decision-makers who want information on whether there is a threat or a opportunity. In the digital economy, knowledge is money. TRND allows the creation of sharable patterns libraries that allow for fast learning and deployment to improve business operations. You can't monitor all so you can't monetize them all. TRND doesn't find needles in the haystacks. It continuously monitors all needles to identify relevant information. You can't buy it if you don't have the money. Scale used to break the bank. Micro monitoring at scale is possible with our search-based approach.

IBM Informix®, a fast and flexible database that can seamlessly integrate SQL, NoSQL/JSON and time series data, is available. Informix's versatility and ease-of-use make it a popular choice for a wide variety of environments, including enterprise data warehouses and individual application development. Informix is also well-suited for embedded data management solutions due to its small footprint and self-managing capabilities.

Google Cloud Bigtable provides a fully managed, scalable NoSQL data service that can handle large operational and analytical workloads. Cloud Bigtable is fast and performant. It's the storage engine that grows with your data, from your first gigabyte up to a petabyte-scale for low latency applications and high-throughput data analysis. Seamless scaling and replicating: You can start with one cluster node and scale up to hundreds of nodes to support peak demand. Replication adds high availability and workload isolation to live-serving apps. Integrated and simple: Fully managed service that easily integrates with big data tools such as Dataflow, Hadoop, and Dataproc. Development teams will find it easy to get started with the support for the open-source HBase API standard.

Apache Druid, an open-source distributed data store, is Apache Druid. Druid's core design blends ideas from data warehouses and timeseries databases to create a high-performance real-time analytics database that can be used for a wide range of purposes. Druid combines key characteristics from each of these systems into its ingestion, storage format, querying, and core architecture. Druid compresses and stores each column separately, so it only needs to read the ones that are needed for a specific query. This allows for fast scans, ranking, groupBys, and groupBys. Druid creates indexes that are inverted for string values to allow for fast search and filter. Connectors out-of-the box for Apache Kafka and HDFS, AWS S3, stream processors, and many more. Druid intelligently divides data based upon time. Time-based queries are much faster than traditional databases. Druid automatically balances servers as you add or remove servers. Fault-tolerant architecture allows for server failures to be avoided.

OpenTSDB is composed of a Time Series Daemon, (TSD), and a set of command-line utilities. OpenTSDB can only be interacted with by one or more TSDs. Each TSD can be run independently. There is no master or shared state, so you can run as many TSDs you need to handle any load. Each TSD uses the HBase open-source database or hosted Google Bigtable service for time-series data storage and retrieval. The data schema is optimized for fast aggregations and retrieval of similar time series, minimizing storage space. The TSD does not require users to directly access the underlying store. The TSD can be communicated with via a simple telnet protocol, an HTTP API, or a built-in GUI. OpenTSDB's first step is to send time series data directly to the TSDs. OpenTSDB has many tools that allow you to pull data from different sources.