Introduction to 6NF File Format: A Bitemporal Data Exchange Standard
By
sergeyprokhoren
Crisped on the outside, thoughtful enough on the inside.
Summary
The 6NF File Format is a new bitemporal, sixth-normal-form data exchange format designed for data warehousing and reporting. It aims to replace complex hierarchical formats like XBRL, XML, JSON, and YAML with a simpler, more structured approach. The format includes syntax definitions for entities, references, attributes, structures, and relationships, following EBNF notation standards.
Key quotes
· 3 pulled6NF 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
6nf = [version] { entity | reference | attribute | attribute_ref | struct | relationship }
You might also wanna read
Postgres-Backed Durable Workflow Execution: An Alternative to External Orchestration Systems
This article explains the concept of durable workflow execution using Postgres as the backing database, as implemented by the DBOS system. I
dbos.dev·3d agoPostgres-Backed Durable Workflow Execution: An Alternative to External Orchestration Systems
This article explains the concept of durable workflow execution using Postgres as the backing database, as implemented by the DBOS system. I
dbos.dev·3d ago
Comparing Transaction Isolation Levels in MySQL and MariaDB Through Automated Hermitage Testing
This article discusses transaction isolation levels (Read Uncommitted, Read Committed, Repeatable Read, Serializable) in MySQL and MariaDB,
theconsensus.dev·24d ago
Columnar Storage as Database Normalization: Understanding the Relational Foundation
The article explains that columnar storage in databases is essentially a form of normalization within the relational model, not a completely
buttondown.com·1mo ago
PgQue: Zero-Bloat Postgres Queue System Using Pure SQL and pg_cron
PgQue is a zero-bloat Postgres queue system that revives the PgQ architecture originally designed at Skype for handling messaging for hundre
github.com·1mo ago
Rethinking Database Usage: When File-Based Storage Might Be Better Than Traditional Databases
The article challenges conventional wisdom about database usage, arguing that databases are essentially just files on disk and that for many
dbpro.app·1mo ago