database 游戏中使用什么样的数据库？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/5281849/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
what kind of database are used in games?
提问by Aditya P
what common and popular database/(types of database) used in games?
游戏中使用什么常见和流行的数据库/（数据库类型）？
- MMORPG
- browser based ,flash games
- video games
- 大型多人在线角色扮演游戏
- 基于浏览器的Flash游戏
- 视频游戏
采纳答案by Ekin Koc
1) As far as I know, World of Warcraft runs on Oracle RDBMS. Not sure about the implementation details, however, it seems that low priority data (like the location of a character, attribute status etc) gets dumped into database in intervals and high priority data (level, item transfer) occurs real time (hence the noticeable delay sometimes.)
1) 据我所知，魔兽世界运行在 Oracle RDBMS 上。不确定实现细节，但是，似乎低优先级的数据（如角色的位置、属性状态等）每隔一段时间被转储到数据库中，而高优先级的数据（等级、物品传输）是实时发生的（因此值得注意有时延迟。）
Also Guild Wars uses Microsoft SQL Server but nor in RDBMS manner. They store binary data within tables that look like (char_id, last_update, data) and the game servers periodically serialize a character into a byte array, then push to DB servers. That's the same method used to transfer players between servers. Everyone is just a chunk of data.
激战也使用 Microsoft SQL Server，但也不使用 RDBMS 方式。它们将二进制数据存储在类似于 (char_id, last_update, data) 的表中，游戏服务器定期将字符序列化为字节数组，然后推送到数据库服务器。这与用于在服务器之间转移玩家的方法相同。每个人都只是一块数据。
2) As ThiefMaster said, any DB. If you see php on frontend, there is a good chance there is MySQL or PostgreSQL at the back. If you see ASP* variants, look for MS SQL Server.. Like websites.
2）正如 ThiefMaster 所说，任何数据库。如果您在前端看到 php，则很有可能在后端有 MySQL 或 PostgreSQL。如果您看到 ASP* 变体，请查找 MS SQL Server.. 就像网站一样。
3) Everything occurs in memory (generally.. Say, the Football Manager requires a database due to vast amounts of data processed.) A Database would just be an overkill.
3）一切都发生在内存中（通常......比如说，由于处理了大量数据，足球经理需要一个数据库。）数据库只是一种矫枉过正。
回答by ThiefMaster
At least WoW uses Oracle. But any good RDBMS would do the job as long as it can work with the huge amount of data.
Usually MySQL. But see #1 - any DB can do the job
No database at all - why would e.g. a game like Half-Life use a database.
至少魔兽世界使用甲骨文。但是，只要能够处理大量数据，任何好的 RDBMS 都可以胜任。
通常是 MySQL。但请参阅 #1 - 任何数据库都可以完成这项工作
根本没有数据库——为什么像《半条命》这样的游戏会使用数据库。
