SQL has limitations as it is built on relational concepts and relies on binary joins.
The future of databases is shifting towards relational knowledge graphs, allowing the flexibility to work with various data structures beyond tables.
Businesses are moving towards explicitly modeling... See more
Nicolay Geroldtwitter.comSQL has limitations as it is built on relational concepts and relies on binary joins. The future of databases is shifting towards relational knowledge graphs, allowing the flexibility to work with various data structures beyond tables. Businesses are moving towards explicitly modeling business semantics and logic, which are often stored in documents, messages, whiteboards, and various applications. For data analysis, SQL's slicing and dicing capabilities excel, but for detailed processing and graph-type operations, SQL databases fall short. Dynamic environments may benefit from alternatives to SQL.
Continued experiments with an autonomous CRM that slowly creates a massive knowledge graph.
This time, I'm testing specific edge types, which loses flexibility, but also makes the output easier to query and understand.*
*I'm using function call to get JSON, and the "enum" feature to specify... See more
Yoheix.com