Home > Workload Solutions > Oracle > White Papers > Unleash the Power of Real-time Data Intensive Applications > A new era with Cloud Database Management Systems
SingleStoreDB is a distributed relational database that supports structured and semi-structured data. This database runs complex interactive queries over large datasets and runs high-throughput, low-latency read and write queries with predictable response times. SingleStoreDB was designed to handle transactional and analytical workloads, which supports data consolidation.
Many data architectures use a separate database for different types of data storage and usage patterns, such as:
The downside of these data architectures is that it adds significant overhead.
SingleStoreDB is a multi-model database that natively allows you to store and access different types of data, such as relational, time series, geospatial, key-value, and documents. SingleStoreDB uses ANSI SQL in a distributed, shared-nothing architecture that runs on a cluster of servers. Data analysis and reporting are distributed across all the nodes in the cluster. This parallelization of data analysis across several servers enables SingleStoreDB to support and accelerate multiple workloads.
Adding storage resiliency is critical consideration when consolidating workloads as the significance of the SingleStore system incrementally increases with each additional dataset. As part of SingleStore architecture Dell PowerFlex delivers scale-out storage that adds greater resiliency and automates storage self-balancing. PowerFlex resiliency includes:
The integrated resiliency and data protection features of PowerFlex can be part of the Business Continuity Plan (BCP). The goal of these protection features is to prevent a disaster from impacting your data management infrastructure and the ability to make business decisions. By centralizing SingleStore and other data management applications to PowerFlex, the enterprise will have both a data center and remote continuity plans.
Storage performance is equally vital to consider for efficient operations. PowerFlex can scale from a few nodes to hundreds in a cluster, linearly scaling I/O performance and throughput. This approach to scalability compliments how SingleStore scales nodes in a cluster. This is critical as a scale-out data management system is best positioned on scale-out storage.
A key advantage of using PowerFlex with SingleStore is the capability to independently scale storage performance relative to SingleStore nodes. Consider the SingleStore architecture using five leaf nodes and ten PowerFlex nodes. SingleStore leaf nodes distribute data across all five servers to optimize performance with automated load balancing. We can expand storage I/O and throughput beyond the five leaf nodes by deploying them as PowerFlex nodes. By doing this storage I/O and throughput encompass all ten PowerFlex nodes. This provides the business the capability to independently scale storage performance.
PowerFlex automates performance optimization by rebalancing data across nodes in the cluster. Rebalancing continually optimizes system health, performance, and data protection of the storage system. This automation ensures that your data management system is continually optimized, providing fast analytics, real-time decision making, and reporting.