Tag
This paper presents an educator-guided LLM pedagogical agent that delivers scaffolded feedback for conceptual database design within an ER diagram editor, separating hidden artifact-grounded diagnosis from a staged, student-facing disclosure workflow. In a deployment across three ERD environments and 383 feedback episodes, 71.1% of target-level changes incorporated the hidden diagnostic target, with staged disclosure helping some students avoid premature or inaccurate revisions.
The article questions whether vector databases are sufficient for AI agents, highlighting needs like transactional writes, concurrent updates, and hybrid search, and asks how practitioners handle these in real systems.
This article is part 1 of a systematic discussion on primary key design in databases, focusing on business requirements and introducing concepts like external IDs and anchor IDs.
The article discusses desired features for a modern relational query language, critiquing SQL's shortcomings and suggesting improvements based on functional programming, better syntax, and user-defined types.
This article explores storage engine write durability trade-offs, explaining how different storage layers (memory, local SSD, remote storage) move latency and durability, and analyzes the cost of operations in an append-only key-value store built on object storage.
This article discusses how traditional primary key designs can isolate tables, and introduces structured primary keys as an alternative approach to improve SQL query performance and maintain relational integrity.
This article explains how Spanish traders' practice of counting without thumbs influenced GnuCash's database design choice to store monetary values as integer minor units, drawing parallels to how historical oddities shape modern technology.
The author shares a personal breakthrough in understanding columnar stores while building a game engine, relating it to Trizen's ECS and ClickHouseDB.
The article critiques Redis's recent strategic direction, highlighting conflicts over licensing changes, feature bloat, and its pivot toward an 'AI context engine' positioning. It analyzes how ambitious enterprise goals have impacted the project's openness and simplicity.
The article reframes columnar storage as an extreme form of database normalization, showing how splitting attributes into position-aligned arrays mirrors normalized tables joined on an implicit ordinal primary key.