...
Top candidates are Postgres, MariaDB, MySQL, SQL Server, Oracle.
Top candidate for Reference data is Postgres.
Minimum ANSI Requirements
...
- Physical Tables.
- Staging Tables
- Raw Tables
- Transaction JSON object.
- Rarely change
- Mix of concrete and abstract constructs to allow the schema to support new attributes easily
- Is under the control of the database owner.
- A reference implementation is provided.
- Must support the standing view layer.
- Standing View Layer
- Views to bring raw to logical
- Views to allow for BU analysis with less joins
- More will be added with time, less governance on adding.
- Represents the standard data model agreed by the community.
- A reference implementation is provided.
- If the physical tables don't match the reference model, then the database owner must implement these views.
- A verification test bed is provided to ensure the view layer meets expectations.
- Materialized as needed for performance
- Persistent from time of creation onwards until removed.
- Dynamic View Layer
- Support Extraction Patterns that occur multiple times
- May represent standing extractions, like stat reportingPersistent
- after deployed. Build and Tear Down in course of Extraction Transaction
- Part of the standard model.
- Query Layer
- An SQL processor with
...