Part I: The problem with imposed constraints
1 Constraints
2 Constraints ⇒ can't record partial information
3 Constraints ⇒ can't record conflicts
4 Constraints ⇒ drafts not managed by DBMS
5 Constraints ⇒ hide problems
6 Constraints ⇒ complex updates
7 Constraints ⇒ fallible updates
8 Constraints ⇒ slow updates
9 Constraints ⇒ risk deadlocks
10 Constraints ⇒ OT is intractable
Part II: Representations
11 Non-canonical representations
12 Driving variables through a complicated space
13 Which variables to materialise?
14 Incremental computing on the derived variables
15 Optimise both read and write performance
Part III: Editing and validation
16 In-place data entry
17 Constrained variables cannot be edited in-place
18 Conventional approaches to editing data with complex constraints
19 Simplicity of in-place editing of unconstrained base variables
20 Validation of forms
Part IV: Concurrency and availability
21 MVCC
22 Stale reads
23 No race conditions
24 Availability of services
25 Long running business processes
26 Security
Part V: Architectural applications
27 CQRS
28 Reactive programming
29 Data warehousing
30 Events database

Part I: The problem with imposed constraints

Next1 Constraints