Schema on Write - Consumer Driven Schemas

What does it mean to move from a Relational Database style Schema on Read to Schema on Write?

Schema on Write is used to stage data in a consumer friendly form.  It can also be used in poor-join-performance environments to restructure and stage data in consumer read format. It is pretty much mandatory for Document Databases. 
  1. Ingestion stores data in its original format for compliance, audit or other purposes.  This copy may be called True Source.
  2. Format Standardization converts the raw information into and agreed on standard format.  Examples include Data Tables in a lake or documents in a document store.  This is purely a mechanical conversion.
  3. Consumption Model are built from raw data, reference data and applies view and business rules creating a consumer ready dataset. 
    1. The data sets may have to be filtered , schema-on-read, based on user permissions and authorizations.
  4. Consumer View models are built and to specific consumers or consumer groups.  They are often based on different data visibility for various consumer groups.  Consumer View models are often built to simplify usage of, and alignment with, vendor IAM tools and roles. This can remove the need for proxy tiers, view layers or other Schema on Read mechanisms.

Video

Organize for Ease of Use

Tables/Data organized as schema on write are similar to RDBMS Materialized views. RDB materialized views are used to shape the data while providing high performance. 

Organize Data to Leverage Native Authorization

Data organization can either be aligned to the access control and I/O patterns or the custom access controls and I/O abstractions can be bent match your data organization.  Organizing the data for consumers and to align with vendor permissions can have significant impacts.  

Storage is Cheap

Schema on right Lakes or Document databases trade off storage and normal forms for performance.  They can do this because we have moved to a point were storage is cheaper than the work needed to maintain traditional models.

Instrumentation and Lineage

The diagram above represents data transformation.  Data is received , formatted and enriched.  Users can consume the data anywhere along the transofrmation journey.  Regulators and auditors may need to understand how true source data on the left is transformed prior to being given to users and programs.

Why Document DBs and Cloud Lakes?

It doesn't seem like Document DBs and Lake Object stores have much in common.  They have some similarities with respect to access controls and storage philosophies if we ignore how the data is actually managed in storage.

CQRS for Example

The query side of CQRS may also run on consumer optimized storage since the Query store is used solely by consumers and not by the core application. 

Created 5/2020

Comments

Post a Comment

Popular posts from this blog

Installing the RNDIS driver on Windows 11 to use USB Raspberry Pi as network attached

Image
I do a lot of my development and configuration via ssh into my Raspberry Pi Zero over the RNDIS connection. Some models of the Raspberry PIs can be configured with  gadget drivers  that let the Raspberry pi emulate different devices when plugged into computers via USB. My favorite gadget  is the network profile that makes a Raspberry Pi look like an RNDIS-attached network device.  All types of network services travel over an RNDIS device without knowing it is a USB hardware connection. A Raspberry Pi shows up as a Remote NDIS (RNDIS) device when you plug the Pi into a PC or Mac via a USB cable. The gadget  in the Windows Device Manager picture shows this RNDIS Gadget connectivity between a Windows machine and a Raspberry Pi. The Problem Windows 11 and Windows 10 no longer auto-installs the RNDIS driver that makes magic happen. Windows recognizes that the Raspberry Pi is some type of generic USB COM device. Manually running W indows Update  or  Upd...
Read more

Understanding your WSL2 RAM and swap - Changing the default 50%-25%

Image
The Windows Subsystem for Linux operates as a virtual machine that can dynamically grow the amount of RAM to a maximum set at startup time.  Microsoft sets a default maximum RAM available to 50% of the physical memory and a swap-space that is 1/4 of the maximum WSL RAM.  You can scale those numbers up or down to allocate more or less RAM to the Linux instance. The first drawing shows the default WSL memory and swap space sizing. The images below show a developer machine that is running a dev environment in WSL2 and Docker Desktop.  Docker Desktop has two of its own WSL modules that need to be accounted for.  You can see that the memory would actually be oversubscribed, 3 x 50% if every VM used its maximum memory.  The actual amount of memory used is significantly smaller allowing every piece to fit. Click to Enlarge The second drawing shows the memory allocation on my 64GB laptop. WSL Linux defaul...
Read more

Almost PaaS Document Parsing with Tika and AWS Elastic Beanstalk

Image
The Apache Tika project provides a  library capable of parsing and extracting data and meta data from over 1000 file types.  Tika is available as a single jar file that can be included inside applications or as a deployable jar file that runs Tika as a standalone service. This blog describes deploying the Tika jar as an auto-scale service in Amazon AWS Elastic Beanstalk.  I selected Elastic Beanstalk because it supports jar based deployments without any real Infrastructure configuration. Elastic Beanstalk auto-scale should take care of scaling up and down for for the number of requests you get. Tika parses documents and extracts their text completely in memory. Tika was deployed for this blog using EC2 t2.micro instances available in the AWS free tier. t2.micro VMs are 1GB which means that you are restricted in document complexity and size. You would size your instances appropriately for your largest documents.   Preconditions An AWS account. AWS ac...
Read more