DB设计问题 - 存储国际人名 [英] DB Design Question - Storing International People Names

问题描述

我明白，FirstName LastName问题是使用美国人设计的网站的人们经常投诉的。你认为一个更适合更多国家的更好的系统是什么？您会建议使用哪些领域来存储名称可能需要访问，理解或显示的各种方式？

I understand that the FirstName LastName "problem" is a frequent complaint of people who use websites designed by Americans. What do you think is a better system that will suit more countries? What fields would you recommend using to store the various ways that a name might need to be accessed, understood, or displayed?

根据系统是什么，我会提出以下字段基于美国的FirstName MiddleName和LastName的想法。中间名在美国几乎没有使用，但大多数人都有一个。它可以帮助区分许多共享相同组合的人FirstName LastName。

Depending on what the system is for I would propose the following fields based on the US idea of FirstName MiddleName and LastName. Middle names are almost unused in the US but most people have one. It can help differentiate between the many people who share the same combination FirstName LastName.

FirstName   : George
MiddleName  : Henry
LastName    : Davis
DisplayName : George D.
Alias       : Kidd1985
LegalName   : George Henry Davis

显然，我的设计可能有一些缺陷，因为LegalName包含与其他字段相同的数据。但是，我怀疑LegalName不能从其他字段导出的情况。

Obviously, there are probably some flaws with my design since LegalName contains the same data as the other fields. However, I suspect there are cases where the LegalName cannot be derived from the other fields.

但现在我很好奇你们为国际观众推荐什么系统？

But now I'm curious what system you all would recommend for an international audience?

推荐答案

啊哈。没有适当的答案，但是大量的雷区和罐子里充满了蠕虫...

Ah ha. There is no "proper" answer to this but plenty of minefields and cans full of worms...

你有名字，姓氏，姓氏，基督教名字，家庭姓名，守护名称，部落姓名，中间名，姓名，姓名，姓氏，姓氏，职业名称，...？ 这里的SO示例

You have first name, last name, surname, christian name, family name, patronymic, tribal name, middle name, initials, title, maiden name, generational name, occupational name, ...?. An example here on SO

你还应该阅读这些虚构程序员相信名字和姓氏第一

基本上，您必须选择涵盖80％的可能性的方案。

Basically, you have to pick a scheme that covers, say, 80% of possibilities.

例如，在我的全球企业数据库中，我有一个在西欧拥有总部的公司的名字和姓氏：它是否符合我的需要，无论广义上是否正确。

For example, I have firstname and lastname in my global corporate database for a company with HQ in Western Europe: it does what I need whether it is correct in the wider sense or not.

编辑，2013年3月。

Edit, Mar 2013.

更多官方，非博客 W3Org的官方指导

这篇关于DB设计问题 - 存储国际人名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！