Tag: materialized views

How materialized views provide instant visibility into aggregate data

October 20, 2020

Over the last decade, SQL has fallen out of fashion and is now seeing a resurgence. As applications become more complex, people realize they need a data manipulation language, and SQL is the obvious choice as it’s a proven and well-known mechanism for manipulating related data structures. In this blog post, we discuss how […]

October 20, 2020
No Comments

How VoltDB helped an Indian company deal with 1M concurrent fantasy sports registrations

VoltDB Examples: Fantasy Sports Registration

March 21, 2019

By: David Rolfe

Need 640K TPS and perfectly accurate running totals? VoltDB has the answer. But it’s not what you’d expect… Anyone who has worked in the OLTP RDBMS space for any length of time will have noticed that heavy OLTP workloads don’t sit well with heavy summarization/COUNT (*)/running total workloads. The root cause of this is pretty [...]

March 21, 2019
No Comments

Go fast! Blog post on fast data, translytics and VoltDB

Is “Translytics” Just Rebranded “OLTP”?

February 21, 2018

By: David Rolfe

Recently Forrester group has started to talk about "translytics" and Translytical Databases - databases that can “Deliver Analytics At The Speed Of Transactions”. Is this more marketing hype? Or is there something to it? A traditional OLTP database handles lots of rapid fire transactions, but doesn’t really do much more than that. An OLTP database application [...]

February 21, 2018
No Comments

An intern’s experience with VoltDB Materialized Views

September 23, 2015

By: Briana Matejcik

My name is Yiqun Zhang and I worked as a software engineering intern on the SQL core team at VoltDB during the summer. The experience of working with so many smart and talented people was so much fun. I was proud to be part of the team. My work focused mainly on the materialized view […]