Relational数据库中的高级功能如何工作?

时间:2021-10-25 16:57:52

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:

简而言之,我知道关系数据库的基础知识,索引,复制,锁定,并发等,以及SQL语法(SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,TRUNCATE)。简单的表达式,例如:

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.

你可能会投票并完全废弃这个问题,但请向我解释一下这些主题是如何工作的,因为我需要非常快速地掌握关系数据库。

2 个解决方案

#1


6  

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:

有关关系数据库和关系模型的*文章是一个很好的起点。他们有关于您提到的特定主题的其他文章的链接,这些文章包含示例,例如:

#2


1  

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.

我认为你要面对的一个问题是不同的RDBMS实现之间的功能差异很大。在Oracle中,锁定,一致性和并发性与 <在此处插入其他系统的随机名称> 非常不同。如果有一个你感兴趣的特定RDBMS,那么我会敦促你研究一下这个特定系统如何实现它们,因为正如他们所说,魔鬼在细节中。

For example, start with the Oracle Concepts Guide, available in HTML and PDF from http://docs.oracle.com for each version.

例如,从每个版本的http://docs.oracle.com上的HTML和PDF格式的Oracle概念指南开始。

#1


6  

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:

有关关系数据库和关系模型的*文章是一个很好的起点。他们有关于您提到的特定主题的其他文章的链接,这些文章包含示例,例如:

#2


1  

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.

我认为你要面对的一个问题是不同的RDBMS实现之间的功能差异很大。在Oracle中,锁定,一致性和并发性与 <在此处插入其他系统的随机名称> 非常不同。如果有一个你感兴趣的特定RDBMS,那么我会敦促你研究一下这个特定系统如何实现它们,因为正如他们所说,魔鬼在细节中。

For example, start with the Oracle Concepts Guide, available in HTML and PDF from http://docs.oracle.com for each version.

例如,从每个版本的http://docs.oracle.com上的HTML和PDF格式的Oracle概念指南开始。