Hasty Briefsbeta

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.