OLAP vs. OLTP: Similarities and Differences

OLAP vs OLTP: Similarities and Differences

August 17, 2023
In today’s data-driven age, organizations need to make smart decisions when it comes to how they manage their data.  To this end, there are two key technologies used to store, process, and analyze data that they need to choose between depending on their use case: online analytical processing (OLAP) and online transaction processing (OLTP).  Though [...]
Go fast! Blog post on fast data, translytics and Volt Active Data

Is “Translytics” Just Rebranded “OLTP”?

February 21, 2018
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 [...]
Berlin Buzzwords vlog Volt Active Data

Vlog: The History and Future of the Blurring of Stream Processing & OLTP

August 09, 2017

Recently, our founding Engineer, John Hugg, spoke at Berlin Buzzwords. This vlog contains the video of his presentation there. What’s Covered in this Video? There has been so much noise surrounding advances in analytical systems lately that Online Transaction Processing (OLTP) problems may seem a bit overshadowed. Big data, streaming analytics, machine learning, and even […]

Shocking Fact: Stored Procedures make OLTP faster. Seriously!

April 11, 2017

There are three ways to interact with the database in client / server computing: Play “Twenty Questions” with SQL statements; Move all the data to the client, and then back again; and, Use a stored procedure to move the problem to the server. Of these, using stored procedures is the most efficient and logical choice […]

  • 184/A, Newman, Main Street Victor
  • info@examplehigh.com
  • 889 787 685 6