Filename Extension: .6nf
1. Introduction
6NF File Format is a new bitemporal, sixth-normal-form (6NF)-inspired data exchange format designed for DWH and for reporting. It replaces complex hierarchical formats like XBRL, XML, JSON, and YAML.
2. Design Principles
Database Friendly Flat Structure : No nested objects or arrays. No need for parsing
6NF Compatibility : Direct mapping to 6NF database tables. No need for normalization
Bitemporal Database Compatibility : All data includes valid_from and recorded_at timestamps
UTC Time Standard : All timestamps must be in UTC format, denoted by the 'Z' suffix (e.g., 2023-01-01T12:00:00Z)
Struct Grouping : Multiple attributes with shared temporal context
Compactness : Uses Crockford’s Base32 - encoded UUIDv7 for identifiers
... continue reading