Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...