EmbeddingGemma 2: an open, lightweight multimodal embedding model
deepmind.google·6d ago
AI Engineering
Hacker News·Aug 13·5 min read
Time to Move On: Querying Without Nulls and Bags
TL;DR
A new query language design, based on fully normalized relations, eliminates the need for nulls and bags, addressing long-standing issues in SQL. This approach enhances query optimizability and reduces programmer burden.
✦ Why It Matters
Consider adopting a null-free approach in your next database project to enhance clarity and efficiency.
Key Takeaways
- Explore alternatives to SQL that avoid nulls and bags.
- Implement fully normalized relations in your database schema.
- Evaluate the impact of nulls on your current data integrity.
- Consider the benefits of set semantics for query optimization.
How It Works
The proposed language, Rel, is built on the concept of fully normalized relations, which ensures that all data is structured without the ambiguity introduced by nulls. By focusing on set semantics, it allows for more predictable and efficient query execution, as each relation is treated as a distinct set of values without duplicates or missing entries.