Analytics Acceleration for OLTP Data Stores

From Legacy to Modern Architectures

Traditional databases optimize transactions but struggle with analytics. Here’s how MemSQL can accelerate analytic performance for OLTP data stores.

Legacy Architecture

STEP 1
database
Optimized for Transactions
OLTP Databases handle transactions very efficiently and cheaply

Data Source

OLTP Databases

SQL Server, Postgres or Oracle

STEP 2
gear
Slow Data Capture
Batch based data integration routines slow overall data workflow and application performance

Transform

ETL / CDC

Attunity, GoldenGate, Informatica, Talend

STEP 3
database
Expensive
Limited legacy solutions perpetuate high costs across complicated infrastructures.

Analyze

Data Marts / EDW

Oracle, SQL Server Teradata, SybaseIQ

STEP 4
piechart
Stale Data
By the time data gets batch processed into a dashboarding the tool, data is old and irrelevant

Visualize

Dashboard

Microstrategy, Tableau, Looker

arrows

The risks and costs of modernizing an operational database often results in offloading transactions to another database platform to support faster or highly concurrent analytics.

Modern Architecture with MemSQL

STEP 1
database
Optimized for Transactions
OLTP Databases handle transactions very efficiently and cheaply

Data Source

OLTP Databases

SQL Server, Postgres or Oracle

STEP 2
gear
Seamless Data Capture
Stream ingestion captures every data event with transactional consistency
memsql
Cost Savings
Distributed architecture uses industry standard hardware or cloud instances

Transform + Analyze

MemSQL

Directly connect Attunity, GoldenGate, Informatica, or Talend to MemSQL to analyze data in real time.

STEP 3
piechart
Live Data Insights
Scalable SQL delivers highly interactive live data dashboards

Visualize

Dashboard

Microstrategy, Tableau, Looker

arrows

MemSQL delivers operational consistency with live data syncronization along with breakthrough analytic performance without impacting application response time

CUSTOMER SNAPSHOT

Leading Energy Company

A leading energy company struggled to perform critical invoice validation rules without disrupting application performance. With MemSQL and an efficient change data capture process, the validation rule runs more frequently to eliminate costly invoice errors.

Invoice Validation Before MemSQL

STEP 1
invoice
Operational Performance
Transactional system efficiently processes financial data

Invoice Created

Vendor inputs invoice into Oracle

STEP 2
gear
Performance Impact
In-database rules engine impacts application performance due to complex de-duplication queries

Deduplication

In-database rules engine runs on operational database checking for duplicate invoice entries

STEP 3
invoice cleared
Performance over accuracy
To protect app performance rules engine does not run continously resulting in duplicate invoices cleared for payment

Invoice Cleared

Throttling rules engine maintains application performance while processing duplicate invoices

STEP 4
invoice
Costly Duplicates
Duplicate invoices result in costly clawbacks and added processesing expenses

Duplicate Invoices

Duplicate invoices sent to vendors and customers

arrows

Optimizing application performance results in throttling data validation rules, resulting in inaccurate records and added costs.

Invoice Validation After MemSQL

STEP 1
invoice
Operational Performance
Transactional system efficiently processes financial data

Invoice Created

Vendor inputs invoice into Oracle

STEP 2
gear
Real-Time Data Syncronization
Change data capture ensures exact live replica of operational database without impacting application performance
memsql
High Performance Queries
Complex rules engine queries reduce from hours to seconds for continuous operations

Transform + Deduplication

Real-time data syncronization using change data capture ensures exact replica of operational system to enable continuous validation of accurate invoice records

STEP 3
invoice cleared
Cost Savings
Reduce complex rules engine queries from hours to seconds for continuous processing

Accurate Invoices

Accurate invoices viewed in BI reports are accurately cleared for payment

arrows

Implementing MemSQL with a real-time change data capture process enabled an exact replica of the Oracle application for fast cost-effective processing of invoices.

Ready to get started?

See how MemSQL can modernize your data analytics

OLTP Resources

New 451 Survey Sheds Light on Top Use Cases for AI and Machine Learning in Key Industries
New 451 Survey Sheds Light on Top Use Cases for AI and Machine Learning in Key Industries
This 451 Research report leverages the results of its most recent survey to discuss the current and future use cases for AI and ML in four key verticals: financial services, retail, healthcare, and manufacturing.
Read Now
Operationalizing MemSQL - On Demand
Operationalizing MemSQL - On Demand
View this on-demand webcast and learn how you can operationalize MemSQL.
Watch Now
Accelerate Decision Making with Real-Time Analytics on AWS
Accelerate Decision Making with Real-Time Analytics on AWS
The number of sources generating continuous, streaming data has exploded in recent years. From website clickstream data to telemetry data from Internet of Things (IoT) devices, the variety, volume, and velocity of data continues to increase. In response, businesses are evolving their analytics approach from batch to real time, and turning to new tools to deliver actionable insights in seconds instead of hours or days.
Watch Now
Five Reasons to Switch from Oracle to MemSQL - On Demand
Five Reasons to Switch from Oracle to MemSQL - On Demand
Databases have grown dramatically as data increases in importance. Oracle and other legacy technologies have built empires serving this need. However, increases in users and data are driving new demands that are pushing the limits of traditional database architectures like Oracle resulting in difficult-to-use, maintain, and expensive systems.
Watch Now
How Manage Accelerated Data Freshness by 10x
How Manage Accelerated Data Freshness by 10x
To meet customer expectations, Manage needed a solution that could deliver fresh data for reporting, while concurrently allowing their analytics team to run ad hoc queries. Kai Sung, Manage CTO and co-founder began the search for a faster database platform, and found MemSQL
Read Now
A Trillion Rows per Second as a Baseline for Interactive Analytics - On Demand
A Trillion Rows per Second as a Baseline for Interactive Analytics - On Demand
Watch on-demand a MemSQL architect-led session on query and performance tuning.
Watch Now