问题描述
Reddit的联合创始人介绍了他们在向数百万用户推广时遇到的问题。可以获得摘要。
The co-founder of Reddit gave a presentation on issues they had while scaling to millions of users. A summary is available here.
令我惊讶的是第3点：
这似乎对我来说是一个可怕的想法，但是，它似乎已经解决了Reddit。这是一个好主意，但一般来说？
This seems like a terrible idea to me, but it seems to have worked out for Reddit. Is it a good idea in general, though? Or is it a peculiarity of Reddit that happened to work out for them?
推荐答案
这是一个称为的实体 - 属性值。它有它的用途。主要的例子是患者测试数据，其自然稀疏，因为可以运行数十万次测试，但是通常对于患者只存在少量测试。包含数十万列的表是愚蠢的，但是具有EAV的表是有意义的。
This is a data model known as EAV for entity-attribute-value. It has its uses. A prime example is patient test data which is naturally sparse since there are hundreds of thousands of tests which might be run, but typically only a handful are present for a patient. A table with hundreds of thousands of columns is silly, but a table with EAV makes good sense.
这篇关于具有“开放模式”的数据库 - 好或坏主意？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！