Slide 1

Slide 1 text

A system with thousands of event types Our work at AFAS Software

Slide 2

Slide 2 text

Michiel Lead Software Architect @ AFAS Software [email protected] @michielovereem https://movereem.nl Overeem

Slide 3

Slide 3 text

500+ employees (4 locations) 12.000 customers (companies) AFAS Software 500+ employees (4 locations)

Slide 4

Slide 4 text

AFAS Profit

Slide 5

Slide 5 text

Small business and accountants AFAS SB+ 500+ employees (4 locations)

Slide 6

Slide 6 text

How do we move from Profit to SB+?

Slide 7

Slide 7 text

Person Entity Customer Role Order Agreement party Spending limit Address Organisation Entity Delivery BusinessAc tivity party Invoice BusinessAc tivity party Address Address Spending limit Spending limit Own Organisation Workarea workarea Spending limit

Slide 8

Slide 8 text

Person Entity Customer Role Order Agreement party Spending limit Address Organisation Entity Delivery BusinessAc tivity party Invoice BusinessAc tivity party Address Address Spending limit Spending limit Own Organisation Workarea workarea Spending limit • Functional model • Only suitable for ERP • Variability in the model • Contains 25 years of knowledge 22 25 96

Slide 9

Slide 9 text

Person Entity Customer Role Order Agreement party Spending limit Address Organisation Entity Delivery BusinessAc tivity party Invoice BusinessAc tivity party Address Address Spending limit Spending limit Own Organisation Workarea workarea Spending limit Generate ERP software

Slide 10

Slide 10 text

Person Entity Customer Role Order Agreement party Spending limit Address Organisation Entity Delivery BusinessAc tivity party Invoice BusinessAc tivity party Address Address Spending limit Spending limit Own Organisation Workarea workarea Spending limit

Slide 11

Slide 11 text

Data QueryModel Object StreamItem Aggregate EventHandler Projector Command Event (Nr=1) Event (Nr=2) Event (Nr=3) Query Plain and simple CQRS & event sourcing

Slide 12

Slide 12 text

StreamItem Aggregate StreamItem Aggregate StreamItem Aggregate Data QueryModel Object StreamItem Aggregate EventHandler Projector Command Event (Nr=1; Id=C) Event (Nr=1; Id=B) Event (Nr=1; Id=A) Query Event (Nr=1; Id=1) Event (Nr=1; Id=2) Event (Nr=2; Id=1) Aggregate Aggregate Aggregate StreamItem Aggregate Data QueryModel Object Data QueryModel Object EventHandler Projector Data QueryModel Object Data QueryModel Object Query Command

Slide 13

Slide 13 text

Data QueryModel Object StreamItem Aggregate EventHandler Projector Command Event (Nr=1) Event (Nr=2) Event (Nr=3) Query 3687 11646 4915 1377 1050

Slide 14

Slide 14 text

No content

Slide 15

Slide 15 text

Event Store stats 34.106.336 events from 3469 event types Started with 8 customers, currently at 91 customers 0,00 5.000.000,00 10.000.000,00 15.000.000,00 20.000.000,00 25.000.000,00 30.000.000,00 35.000.000,00 40.000.000,00 Total # of events

Slide 16

Slide 16 text

Person Entity Customer Role Order Agreement party Spending limit Address Organisation Entity Delivery BusinessAc tivity party Invoice BusinessAc tivity party Address Address Spending limit Spending limit Own Organisation Workarea workarea Spending limit A change here Or here … Or here … Impact!

Slide 17

Slide 17 text

V1.1 V1.2

Slide 18

Slide 18 text

V1.1

Slide 19

Slide 19 text

V1.1 V1.2

Slide 20

Slide 20 text

V1.1 V1.2

Slide 21

Slide 21 text

V1.1 V1.2

Slide 22

Slide 22 text

V1.2

Slide 23

Slide 23 text

V1.1 V1.2 This is where the magic happens…

Slide 24

Slide 24 text

Repair/Upgrade scripts Default data Event rewrites Query StreamItem UpgradeScript Command Command StreamItem … Command

Slide 25

Slide 25 text

Some additional patterns…

Slide 26

Slide 26 text

Data QueryModel Object StreamItem Aggregate EventHandler Projector Command Event (Nr=1) Event (Nr=2) Event (Nr=3) Query StreamItem ProcessManager Event (Nr=1) Event (Nr=2) Event (Nr=3) Command EventHandler Router ProcessManagers

Slide 27

Slide 27 text

EventHandler StreamProjector Data QueryModel Object Data QueryModel Object Data QueryModel Object Query StreamItem Aggregate Command Event (Nr=1) Event (Nr=2) Event (Nr=3) Data QueryModel Object EventHandler Projector Query Event (Nr=1) Event (Nr=2) Event (Nr=3) StreamProjectors

Slide 28

Slide 28 text

Data QueryModel Object EventHandler Projector Event (Nr=1; Id=C) Event (Nr=1; Id=B) Event (Nr=1; Id=A) Query Event (Nr=1; Id=1) Event (Nr=1; Id=2) Event (Nr=2; Id=1) Data QueryModel Object Data QueryModel Object EventHandler Projector Data QueryModel Object Data QueryModel Object Query Cross-Projector-Joins

Slide 29

Slide 29 text

Data QueryModel Object EventHandler Projector Event (Nr=1; Id=C) Event (Nr=1; Id=B) Event (Nr=1; Id=A) Query Event (Nr=1; Id=1) Event (Nr=1; Id=2) Event (Nr=2; Id=1) Data QueryModel Object EventHandler Projector Data QueryModel Object Query

Slide 30

Slide 30 text

Data QueryModel Object StreamItem Aggregate EventHandler Projector Command Event (Nr=1) Event (Nr=2) Event (Nr=3) Query

Slide 31

Slide 31 text

Data QueryModel Object StreamItem Aggregate EventHandler Projector Command Event (Nr=1) Event (Nr=2) Event (Nr=3) Query Direct command results

Slide 32

Slide 32 text

Data QueryModel Object StreamItem Aggregate EventHandler Projector Command Event (Nr=1) Event (Nr=2) Event (Nr=3) Query Push notifications from projectors

Slide 33

Slide 33 text

Data QueryModel Object EventHandler Projector Event (Nr=1; Id=C) Event (Nr=1; Id=B) Event (Nr=1; Id=A) Query Data QueryModel Object EventHandler Projector Data QueryModel Object Query Timers & Projectors-on-projectors

Slide 34

Slide 34 text

Data QueryModel Object StreamItem Aggregate EventHandler Projector Command Event (Nr=1) Event (Nr=2) Event (Nr=3) Query StreamItem ProcessManager Event (Nr=1) Event (Nr=2) Event (Nr=3) Command EventHandler Router Parallel & low-priority event processing

Slide 35

Slide 35 text

No content

Slide 36

Slide 36 text

Sync events

Slide 37

Slide 37 text

[email protected] @michielovereem https://movereem.nl Low-code / Impact analysis / Upgrade process / Several specific patterns Person Entity Customer Role Order Agreement party Spending limit Address Organisation Entity Delivery BusinessAc tivity party Invoice BusinessAc tivity party Address Address Spending limit Spending limit Own Organisation Workarea workarea Spending limit