我们正在评估Nosql的即将到来的项目.我倾向于以RDBMS方式思考事情,并且在概念化缺乏规范化方面遇到困难.
我知道复制数据在Nosql中不被认为是错误的.我无法理解的是修改数据以防止异常.
举例说明：
You are organizing a series of poker tournaments. You have players,
locations,and tournament events. As I understand it,a tournament
event might contain a location and a collection of players. It does
not need to have all the player data,but if you want to get the names
and home addresses of everyone going to the next tournament,that info
should be in the tournament collection.Someone has gotten married and moved,changing their last name and
address. Does the application need to update the player collection and
the tournament collection? Or is my model of the collections wrong? How do
developers “keep track” of where information is duplicated?
我看到的模型最近使用的是拥有一个不变的“主人”数据集(在你的情况下,玩家名单,与每个比赛中的玩家的比赛的列表“关系”模拟,在那里比赛记录具有玩家ID的列表),并且只有通过在“主”(master)数据上运行周期性过程,才能更新过非规范化列表(在您的情况下,具有完全填充的玩家数据的比赛列表).
原文链接：https://www.f2er.com/nosql/203336.html这样,应用程序只需要更新主数据,并且定期更新过程将最终重建非规范化结果.