Boosting Database Performance

for a

Micro Frontends Architecture

@anfibiacreativa

© CampaignCreators | Unsplash.com

@anfibiacreativa

CLOUD NATIVE

Simplify

Architecture

Decouple

Systems

Reduce TCO

Minimize

Dependencies

@anfibiacreativa

Architecture

© Nick Nice | Unsplash.com

PEOPLE

TECHNOLOGY

PROCESSES

Team Config

Skills

Seniority

Models

Patterns

Learning Curve

Maturity

Methodology

Compliance

Procurement

Documentation

Distribution

Component Library

Computation Service

API Service

Infra Service

Infra Service

Computation Service

Component Library

Storage Service

Component Library

Computation Service

API Service

Infra Service

Infra Service

Computation Service

Component Library

Storage Service

Frontend

@anfibiacreativa

Monolith Layer

Infrastructure

Data Storage

Business Logic

Data Access

Infrastructure

Data Storage

Business Logic

Data Access

Infrastructure

Data Storage

Business Logic

Data Access

@anfibiacreativa

Business Logic

Data Access/API Layer

Data Storage/Persistence

Infrastructure

?

?

Infrastructure

Data Storage

Business Logic

Frontend

API Layer

©Kelly Sikkema | unsplash.com

© JESHOOTS | Unsplash.com

HIGH TECHNICAL DEBT

HIGH TCO

UNSATISFIED TEAM

Particularly

when skills of most of the team are opposed to decision and time frame is short

Lots of hidden costs associated with undifferentiated efforts: ramping up the team, fixing bugs, maintenance

Team dissatisfaction, high attrition, leadership burn-out

© Christopher Windus | Unsplash.com

©Amelie Mourichon | Unsplash.com

Mobile traffic share Nov. 2021

53.98%

© Killian Cartignies | Unsplash.com

100%

20%

40%

60%

80%

2015

2020

Total global data estimated in 2025

175 Zb

© Chris Liverani | Unsplash.com

Frontend

@anfibiacreativa

Client-side
Server-side

@anfibiacreativa

Frontend

Frontend

Business Logic

Data Access

Data Storage

Infrastructure

Business Logic

Data Access

Data Storage

Infrastructure

Business Logic

Data Access

Data Storage

Infrastructure

1

2

3

@anfibiacreativa

Graphics: https://www.flaticon.com/authors/smashicons at www.flaticon.com

 

 

Business Capability

Independent Team

Fail Silently

Own it's data?

© Nubelson Fernandez | Unsplash.com

Going Serverless

© Phil Santillan | Unsplash.com

Frontend

@anfibiacreativa

Micro Apps leveraging Serverless Functions and Triggers

@anfibiacreativa

Frontend

Frontend

BL

Data Access

Data Storage

Infrastructure

BL

Data Access

Data Storage

Infrastructure

Data Access

Data Storage

Infrastructure

BL

BL

BL

BL

BL

BL

Share or

Duplicate Data?

©Adam Nowakowski | Unsplash.com

Patterns and Models

Backups and recovery strategy

Database Type

© Hannes Richter | Unsplash.com

SQL DB's

NoSQL DB's

Queried using the Structured Query Language (SQL)

Queried with other languages, like MQL (Mongo Query Language)

Relational

Document Stores

Key-Value

Graph

Spatial

Search Engines

Wide Column

Multivalue

Time-series

MySQL, PostgreSQL, SQL Server

MongoDB, Firebase, Firestore

Cloud BigTable

SpatiaLite, PostGIS

Redis, Memcached

Neo4js, Virtuoso

Elasticshearch, Solr, Algolia

MongoDB, Influx, Prometheus

Many of the above and more!

Relational

Document Stores

Key-Value

Graph

Spatial

Search Engines

Wide Column

Multivalue

Time-series

Content Management, Banking, CRM, Resource Planning

Relational

Document Stores

Key-Value

Graph

Spatial

Search Engines

Wide Column

Multivalue

Time-series

Content Management, Banking, CRM, Resource Planning

Content Management, Fintech, Customization, Personalization

Relational

Document Stores

Key-Value

Graph

Spatial

Search Engines

Wide Column

Multivalue

Time-series

Content Management, Fintech, Customization, Personalization

Session Management, Product recommendations, Caching

Relational

Document Stores

Key-Value

Graph

Spatial

Search Engines

Wide Column

Multivalue

Time-series

Session Management, Product recommendations, Caching

Fraud Detection, Recommendation Engines, Social Networks, Network Mapping

Relational

Document Stores

Key-Value

Graph

Spatial

Search Engines

Wide Column

Multivalue

Time-series

Fraud Detection, Recommendation Engines, Social Networks, Network Mapping

IoT use-cases (collecting data from devices), trends and forecasting, monitorization

Relational

Document Stores

Key-Value

Graph

Spatial

Search Engines

Wide Column

Multivalue

Time-series

IoT use-cases (collecting data from devices), trends and forecasting, monitorization

Full-text content search

Relational

Document Stores

Key-Value

Graph

Spatial

Search Engines

Wide Column

Multivalue

Time-series

Full-text content search

Logging, geographic information, reporting systems

Relational

Document Stores

Key-Value

Graph

Spatial

Search Engines

Wide Column

Multivalue

Time-series

Logging, geographic information, reporting systems

Geomarketing, Supply chain optimization, Environmental Management

Relational

Document Stores

Key-Value

Graph

Spatial

Search Engines

Wide Column

Multivalue

Time-series

Geomarketing, Supply chain optimization, Environmental Management

Several of the above.

Does my microservice/micro-frontend

need a specific database?

Does your solution handle a specific type of data that no other service is dealing with?

Probably, yes.

©Towfiqu Barbhuia | Unsplash.com

Does the cloud provider offer centralized user and network access control?

Is there a need to aggregate data from the many different databases, at some point?

Is there the possibility to split databases as logical units?

©Towfiqu Barbhuia | Unsplash.com

Frontend

@anfibiacreativa

MicroApps with Shared Data Layer

@anfibiacreativa

Frontend

Frontend

Business Logic

Infrastructure

Business Logic

Data Access

Data Storage

Infrastructure

Data Access

Data Storage

Infrastructure

BL

BL

BL

Performance

©Nicolas Hoizey | Unsplash.com

Schema and Design Pattern

©Eleventh Wave | Unsplash.com

Data queried together

is stored together

Schema is not mandatory but can be enforced if needed, totally OR partially!

Indexing

©Maksym Kaharlytskyi | Unsplash.com

Workload Isolation

©Eugene Lim | Unsplash.com

ANALYTICS

OPERATIONAL

READ-ONLY

ANALYTICS

READ-ONLY

Single View Game Stats

GAME

OPERATIONAL

Leaderboard

Global Distribution

©Timo Wielink | Unsplash.com

Edge of the Network

©Marteen Van der Heuvel | Unsplash.com

EDGE DB

CLOUD DB

Conflict resolution

Optimized footprint

Synchronization

@anfibiacreativa

Simplify Architecture

Decouple Systems

Reduce TCO

Minimize Dependencies

Frontend

Data Access

Data Storage

Infrastructure

Breakdown Silos

Enable Independent Teams

Business Logic

PEOPLE

TECHNOLOGY

PROCESSES

Specialized team working on solving a concrete problem

Tech stack is chosen according to the team skills and the specific use-case

Processes are simplified to enable each team independently, based off of technology and requirements

Thank you!

Natalia Venditto

Images: Unsplash.com
Icons and graphics: flaticons.com

@anfibiacreativa

https://www.flaticon.com/authors/freepik
https://www.flaticon.com/authors/vitaly-gorbachev