August 2, 2023 By Peter Casler 3 min read

Despite decades of progress in database systems, builders have compromised on at least one of the following: speed, reliability, or ease. They have two options: one, they could get a document database that is fast and easy, but can’t be relied on for mission-critical transactional applications. Or two, they could rely on a cloud data warehouse that is easy to set up, but only allows lagging analytics.

Even then, each solution lacks something, forcing builders to deploy other databases for everything from text search and log analytics, to caching and location data. The result?  More systems equals more costs, complexity, and data integration.

With SingleStoreDB, customers don’t need to compromise.

Our latest innovations underscore our focus on outcomes that matter to customers including speed, reliability, and ease.

New in SingleStoreDB with IBM 8.0:

The capability to search Universal Storage column stores is now supported for JSON. Your teams can achieve better throughput and response times when trying to find JSON data in a column. This significantly accelerates SingleStoreDB analytics for semistructured data, bolstering SingleStore’s existing multimodel capabilities beyond structured (relational, geospatial, and time series) and unstructured data (text).

Distributed SQL delivers improved performance for string encoded transactions:

  • Recursive Common Table Expressions (CTEs) are added. Recursive CTEs enable a CTE to reference itself, which makes writing queries on hierarchical data simpler and reduces round trips between the application and database. Users can run graph data and tree expansions with a single SQL statement.
  • C, C++, and Rust development is improved. WebAssembly (Wasm) enables developers to move application logic close to the data by using SQL. It helps them avoid loading huge data sets into the application and makes it easier to port code libraries or routines (in C, C++, or Rust) into SingleStoreDB. Developers can focus on application logic instead of writing query logic in the application tier. SingleStoreDB 8.0 expands support for Wasm in both cloud and self-managed deployments, broadening availability of this key feature.
  • Python and Laravel development is improved. Python and Laravel are among the most popular tools used by developers to build modern, near real-time applications. The new Python client is faster than PyMySQL and MySQLdb. The SingleStoreDB Laravel driver plug-in helps web developers accelerate PHP development with Laravel at hyperscale.

SingleStore makes real-time decision making a reality

The market is demanding databases be able to store more data, and access it with lower latency and higher throughput. This performance and data capacity requirement is often combined with a desire for flexible data access. These access patterns can range from low-latency, high-throughput writes for real-time data loading, and deduplication to efficient batch loading and complex analytical queries over the same data.

Built on a modern, lock-free cloud-native architecture, SingleStore can process queries with extremely low latency, while scaling access to tens or hundreds of thousands of concurrent users. The ability to ingest millions of events per second with ACID transactions while running complex analytical queries on that data in real time means that as workloads grow, SingleStore can easily scale up to meet demand without complex application rewrites or data migrations.

Common Use Cases for SingleStoreDB

Operation Analytics: SingleStore helps you deliver fast, scalable reporting and analytics across your operational data — including streaming, real-time and historical data. With SingleStore you can meet the toughest service-level agreements using distributed, lock-free ingestion and real-time query processing.

Dashboard Acceleration: SingleStore delivers fast data ingestion and extreme query performance for every data workload. Whether you are looking to speed up existing dashboards, or build new data applications and analytics, SingleStore provides the performance and scale for high concurrent-user access. 

Fraud and Anomalies: Most organizations are struggling to keep up with the influx of data or to access it when it matters. Ingesting and analyzing machine, sensor or application data delivers more value in real time. With SingleStore, you can continually monitor and detect fraud and anomalies.

IOT Analytics: As always-on devices and sensors proliferate, their data must be immediately ingested and actionable — and the infrastructure behind each IoT app is powered by a real-time database. SingleStore supports fast ingest and concurrent analytics for sensor systems, delivering instant and actionable insights.

The IBM and SingleStore partnership: Better together

The IBM and SingleStore partnership promises to be a value add and win for the customer. IBM enhances the SingleStore experience through added service centralization, facilitated integrations, support and consultancy services, and specialized warranty programs.

Start building your modern data architecture today!

For more information you can read our solution brief

More from Announcements

IBM Hybrid Cloud Mesh and Red Hat Service Interconnect: A new era of app-centric connectivity 

2 min read - To meet customer demands, applications are expected to be performing at their best at all times. Simultaneously, applications need to be flexible and cost effective, and therefore supported by an underlying infrastructure that is equally reliant, performant and secure as the applications themselves.   Easier said than done. According to EMA's 2024 Network Management Megatrends report only 42% of responding IT professionals would rate their network operations as successful.   In this era of hyper-distributed infrastructure where our users, apps, and data…

IBM named a Leader in Gartner Magic Quadrant for SIEM, for the 14th consecutive time

3 min read - Security operations is getting more complex and inefficient with too many tools, too much data and simply too much to do. According to a study done by IBM, SOC team members are only able to handle half of the alerts that they should be reviewing in a typical workday. This potentially leads to missing the important alerts that are critical to an organization's security. Thus, choosing the right SIEM solution can be transformative for security teams, helping them manage alerts…

IBM and MuleSoft expand global relationship to accelerate modernization on IBM Power 

2 min read - As companies undergo digital transformation, they rely on APIs as the backbone for providing new services and customer experiences. While APIs can simplify application development and deliver integrated solutions, IT shops must have a robust solution to effectively manage and govern them to ensure that response times and costs are kept low for all applications. Many customers use Salesforce’s MuleSoft, named a leader by Gartner® in full lifecycle API management for seven consecutive times, to manage and secure APIs across…

IBM Newsletters

Get our newsletters and topic updates that deliver the latest thought leadership and insights on emerging trends.
Subscribe now More newsletters