What is SonicBase?
SonicBase allows you to store and retrieve records in a database with fast insert and retrieval speeds. You can use it for
long-term storage and more short-term storage if you just want to do some temporary analysis of data. You may store
anything from financial data to human resources data.
A highly functional subset of features
is provided in the free version of SonicBase. Additional features are
available for a modest fee ($250 for 8 cores per year).
SonicBase stores all data in memory. It uses a mix of on-heap and off-heap memory. Additionally, disk-based snapshots and
logs are used to achieve durability.
Records and indices are spread out across as many servers as you deem necessary. The data is transparently divided into shards
and it is dynamically distributed as you add or delete records. You can scale SonicBase to billions
of records on commodity servers. See the documented benchmarks for more details. SonicBase Pro supports cross-shard transactions and cross-shard joins.
SonicBase supports the SQL syntax. SQL support is accessed via the JDBC driver.
SonicBase is cross-platform, supporting Linux, Mac, Cygwin and Windows.
With a 32 server, 4 billion record cluster with replication factor equals 1 we achieved 3.8 million batch record inserts per second and
35 million range-based record reads per second. With SonicBase you can achieve linear scalability.
Automated Bulk Import
We have added the ability to automatically load your SonicBase database from another JDBC compliant database. This will allow
you to quickly load SonicBase and do analytics on your data. See Automated Bulk Import Documentation
Streaming allows you to injest data into the database and export it in real-time into external data stores. You could, for example, hook into
a financial stream to provide up to the second quotes to your database. Analytics can then be performed on the data in SonicBase. Or perhaps
you want to replicate you SonicBase database to an external data store. There are many possibilities. Streaming is high-performance real-time data transfer.
You can connect to Kafka, Amazon Web Services Kinesis, Amazon Web Services Simple Queue Service and custom streams providers. The streaming
consumer can load your SonicBase
database in real-time, while you perform analytics functions on your SonicBase database. See Streaming Consumers
You can hook Kafka, Amazon Web Services Kinesis, Amazon Web Services Simple Queue Service and custom streams providers into SonicBase so that all inserts, updates and deletes will be published into your
streams. See Streaming Producers
SonicBase now supports stored procedures. You can run your Java code inside the SonicBase servers. With your stored procedure
you can build or filter results before returning to the client. These powerful procedures can be used to greatly
enhance performance by avoiding sending data over the wire. See Stored Procedures Overview
You will be able to automatically remove data that has been in the database for a specified amount of time. This will allow you to continuously
ingest data into the database without running out of space.
Like what you see or not? Please send us feedback.