Next Generation OLTP - VoltDB
page-template-default,page,page-id-13258,page-child,parent-pageid-6706,mkd-core-1.0,highrise-ver-1.0,,mkd-smooth-page-transitions,mkd-ajax,mkd-grid-1300,mkd-blog-installed,mkd-header-standard,mkd-sticky-header-on-scroll-up,mkd-default-mobile-header,mkd-sticky-up-mobile-header,mkd-dropdown-slide-from-bottom,mkd-dark-header,mkd-header-style-on-scroll,mkd-full-width-wide-menu,mkd-header-standard-in-grid-shadow-disable,mkd-search-dropdown,wpb-js-composer js-comp-ver-6.0.5,vc_responsive
VoltDB / Product  / VoltDB Architecture – How It Works / Next Generation OLTP

Next Generation OLTP

Designed for taking intelligent decisions on fast data in real-time

Online Transaction Processing (OLTP) databases have been around since the 1970s. Technology and data however have evolved significantly in the last 50 years. Data patterns are a lot different now than they were back then. Traditional OLTP databases were built for ingesting and processing small amounts of structured data that came in at a very predictable pace. With the rise of the internet, social media, and Internet of Things (IoT), the velocity of incoming data has risen significantly from millions to, in some use cases billions, of transactions per second. Traditional OLTP systems with their scale-up architecture were just not designed to ingest and process this high velocity data. It gets cost prohibitive to keep adding larger machines and expensive SAN storage to mask these architectural problems.

VoltDB OLTP Architecture

Modern web-scale apps are designed to provide high performance and low latency to their end users. They need an embedded OLTP database that can keep up with their SLAs. In addition to fast transaction processing, modern applications require built-in analytics, cloud deployment capability, complex logic that can take informed decisions instantly, along with “must have” OLTP features such as: ACID, high availability, and security.

VoltDB is a next-generation operational database that was built to power modern applications. It offers the best of both worlds; the performance, throughput and complex logic that modern applications need, along with ACID properties, full ANSI SQL compatibility, and a relational model that has been proven over decades. Here’s the core functionality that makes VoltDB fast, easy to use, and secure:

  • Real-time queries at high throughput with an in-memory, distributed architecture.
  • The ability to apply machine learning to streaming data by importing complex models built by data scientists through PMML, PFA, and other standards and implementing them as a stored procedure or a user defined function.
  • Guaranteed ACID compliance.
  • Seamless deployment on large-scale distributed cloud environments.
  • Per-machine efficiency; to do more operational work for the same amount of computing resources. This leads to a considerably lower hardware footprint, and easier to manage smaller clusters.
  • Familiar, full-featured ANSI SQL; enabling you to leverage the most widely used and comprehensive database language in the world.
  • Designed to deliver high performance on commodity hardware at a much lower total cost of ownership than legacy databases.
  • Database replication (active-passive and active active) – Constantly updated database copies ensure that you data is always safe, VoltDB can read/write cache with immediate consistency across replicas.
  • Active-active high availability ensures that you continue smooth operations even when faced with hardware, software, or network failure. While, most
  • NoSQL solutions such as Redis have a Master/Slave node architecture, and as a result, a single point of failure.
  • Proven security technology such as TLS & Kerberos built-in, along with auditing and monitoring tools to verify usage, and identify attacks on system.

Next-Generation OLTP Use Cases

Telecommunications Operations Support & Billing Support Systems

Telecommunications Service Providers (Telcos) manage billions of customers, devices, and dollars on a daily basis. In order to be competitive, telcos need fast and reliable access to their data. They use real-time access to provide software for major carriers that support critical services for operations support systems (OSS) and billing support systems (BSS). OSS & BSS transactions rely on in-event data collection, analysis, and updates such as checking and adjusting a customer’s credit balance in real-time. As carriers continue to evolve, they create new services and revenue streams, while continuously improving their services and reducing costs. One of the ways they do this is by moving to Network Function Virtualization (NFV) and Software Defined Networks (SDN).

High Frequency Financial Trading

Traders need to react instantly to news and market fluctuations. Delaying a trade by a mere millisecond can lead to losses of millions, the time it takes for a human to make a transaction is simply not acceptable. Processing events instantly with machine learning logic also provides the trader with an additional advantage to make informed trades. To comply with regulations it is essential for financial services firm to a fully ACID OLTP database.

IoT / Smart Grid

The Smart Grid relies on millions of smart meters and sensors deployed in the field at various energy consuming locations such as homes, commercial buildings, factories, etc to consume, analyze, predict, and act on energy consumption data in real-time. This data is used to take intelligent decisions on: routing energy more accurately based on demand, locating service disruptions, avoiding grid failures by providing on-time predictive maintenance, and even turning off in-home appliances remotely to avoid blackouts.