6NF File Format
7 days ago
- #database
- #6NF
- #data exchange
- 6NF File Format is a new bitemporal, sixth-normal-form (6NF)-inspired data exchange format designed for DWH and reporting.
- It replaces complex hierarchical formats like XBRL, XML, JSON, and YAML.
- Key design principles include a flat structure, 6NF compatibility, bitemporal database compatibility, UTC time standard, struct grouping, compactness, readability, PostgreSQL style, case sensitivity, and UTF-8 encoding.
- Syntax is defined using EBNF, covering version, entity, reference, attribute, attribute_ref, struct, and relationship.
- Example demonstrates usage with entities like 'bank' and 'account', attributes, references, and relationships.