关系数据库中的高级功能如何工作？
长话短说，我了解关系数据库、索引、复制、锁定、并发等的基础知识，以及与使用时的 SQL 语法（SELECT、INSERT、UPDATE、DELETE、CREATE、DROP、ALTER、TRUNCATE）简单的表达，例如：
SELECT EventID,EventName FROM Events WHERE CustomerID=5 ORDER BY EventType
但我不明白关系数据库中的任何“高级”主题，例如：
- 域
- 约束
- 索引
有人可以给我一个快速入门指南，大概解释一下这些方面的作用以及它们如何工作吗？
您可能会否决并完全垃圾这个问题，但请向我解释一下这些主题是如何工作的，因为我需要快速了解关系数据库。
To make a long question short, I know about the basics of a Relational Database, Indexing ,Replication, Locking, Concurrency, etc, and SQL syntax (SELECT,INSERT,UPDATE,DELETE, CREATE,DROP,ALTER,TRUNCATE) when used with simple expressions such as:
SELECT EventID,EventName FROM Events WHERE CustomerID=5 ORDER BY EventType
But I don't understand any of the "advanced" topics in Relational databases, like:
- Domains
- Constraints
- Indices
Will anyone please give me a quick primer, an approximate explanation on what these aspects do and how they work?
You may down-vote and totally trash this question, but please explain to me, approximately how these topics work because I need to get up to speed on Relational databases very quickly.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
关于关系数据库和关系模型 是一个很好的起点。 它们包含有关您提到的特定主题的其他文章的链接，并且包含示例，例如：
The Wikipedia articles on Relational Databases and the Relational Model are a good place to start. They have links to other articles on the specific topics you mention and these have examples, such as:
我认为您将面临的一个问题是不同 RDBMS 实现之间的功能差异很大。 Oracle 中的锁定、一致性和并发性与
<在此插入其他系统的随机名称>非常不同。 如果您对某个特定的 RDBMS 感兴趣，那么我强烈建议您研究该特定系统如何实现它们，因为正如他们所说，细节决定成败。例如，从 Oracle 概念指南开始，可从 http://docs.oracle.com 对于每个版本。
I think that one issue you're going to face with this is that features vary widely between different RDBMS implementations. Locking, consistency and concurrency are very different in Oracle to
<insert random name of other system here>. If there is a particular RDBMS that you have an interest in then I'd urge you to investigate how that particular system implements them, because the devil is in the details, as they say.For example, start with the Oracle Concepts Guide, available in HTML and PDF from http://docs.oracle.com for each version.