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 11i application for fast cost-effective processing of invoices.

Ready to get Started?

See how MemSQL can modernize your data analytics


OLTP Resources