……关于这一点至少有两个方面：1）SQL 并没有完全遵循关系模型的底层逻辑原理。Chris Date 的《Database in Depth: Relational Theory for Practitioners》[0] 或《SQL and Relational Theory: How to Write Accurate SQL Code》[1] 都是深入讨论这个话题的好书。网上能搜到的资料也有一大堆。如果想看个简短的批评示例，可以看看维基百科：……
…at least two aspects of this: 1) SQL is not entirely faithful to the underlying logical principles of the relational model. Chris Date's "Database in Depth: Relational Theory for Practitioners"[0] or "SQL and Relational Theory: How to Write Accurate SQL Code"[1] are good texts that go into this in detail. There's plenty of stuff online if you search for it. For a very brief example of criticisms, you can take a look at Wikipedia:…
我推荐 CJ Date 写的《SQL and Relational Theory》。它彻底改变了我写 SQL 的方式。在读这本书之前，我已经有了大约十年的 SQL 使用经验。但我并没有真正理解其背后的理论。我也不知道怎么写出……
I would recommend SQL and Relational Theory by CJ Date. It completely changed how I use SQL. Before reading it, I had about a decade of experience with SQL. I didn't really understand the theory underneath. I also didn't understand how to write…
……理论。所以我搞不懂大家为什么都在讨论 regexps——那应该只属于那本书某一章的一个小节（正则文法）才对。不管怎样，数据库方面我推荐 Date 的《SQL and Relational Theory》——它展示了 SQL 是如何与一种更优雅、更纯粹的底层理论方法关联起来的，能让你学会用更声明式的方式去思考。至于通用编程，如果还没读过的话，SICP 值得一读……
…theory. so i don't understand why people are talking about regexps - that should be covered in a subsection (regular grammars) of one chapter of that book. anyway, for databases i would suggest date's "sql and relational theory" - it shows how sql is related to a more elegant, cleaner, underlying theoretical approach and will get you to think in more declarative terms. for general programming, sicp is worth reading if you haven't…
……在很短的时间内你就能学到很多关于关系模型、数据库/查询/索引设计的知识，顺便还能学到一点逻辑学。只想要一本好用的 SQL 参考书？《The Art of SQL》或者《SQL and Relational Theory》。还不尽兴？行吧，来啃这个硬骨头吧：http://en.wikipedia.org/wiki/The_Third_Manifesto
…will learn a lot about the relational model, database/query/index design in a short amount of time, with a little bit of logic thrown in there too. Just need a good SQL reference? 'The Art of SQL' or 'SQL and Relational Theory' Are you not entertained? Fine, choke on this : http://en.wikipedia.org/wiki/The_Third_Manifesto
……《Learning SQL》是一本极棒的入门书，大概涵盖了普通开发者所需的大部分 SQL 知识（http://shop.oreilly.com/product/9780596520847.do）。《SQL and Relational Theory》则为你补充了更多关系理论的背景——基本上是给现有的 SQL 实战人员提供了一个更偏学术的视角。Date 写作风格挺干巴的，人也有点认死理，但整体内容非常扎实……
…Learning SQL is a really excellent intro, and probably covers the majority of what your average developer is going to ever need to know about SQL ( http://shop.oreilly.com/product/9780596520847.do ) SQL and Relational Theory gives you more background on relational theory - basically gives a more academic background for existing practitioners of SQL. Date is pretty dry author with a few hangups, but it's largely good solid…
……评论提到 Date 不太情愿去剖析这个问题，不幸的是，他的研究成果散落在他写的大量书籍中（而且这些年他在好几个问题上的立场都发生过改变）。我很喜欢《SQL and Relational Theory》这本，但既然他所有的书我都读过，要不是读者本身就了解 Date 的话，我还是不太敢轻易推荐它。我觉得《An Introduction to Database Systems》的最新版（第8版）依然是最好的书……
…comment about Date being reluctant to analyze the matter, unfortunately his work is disseminated in a lot of books (and he changed his position on quite several matters throughout the years). I love the "SQL and Relational Theory" one but, having red all of his books, I would be hesitant to suggest it unless one already knows Date. I think the latest edition (8th) of "An Introduction to Database Systems" is still the best book…
……关于这一点至少有两个方面：1）SQL 并没有完全遵循关系模型的底层逻辑原理。Chris Date 的《Database in Depth: Relational Theory for Practitioners》[0] 或《SQL and Relational Theory: How to Write Accurate SQL Code》[1] 都是深入讨论这个话题的好书。网上能搜到的资料也有一大堆。如果想看个简短的批评示例，可以看看维基百科：……
…at least two aspects of this: 1) SQL is not entirely faithful to the underlying logical principles of the relational model. Chris Date's "Database in Depth: Relational Theory for Practitioners"[0] or "SQL and Relational Theory: How to Write Accurate SQL Code"[1] are good texts that go into this in detail. There's plenty of stuff online if you search for it. For a very brief example of criticisms, you can take a look at Wikipedia:…
我推荐 CJ Date 写的《SQL and Relational Theory》。它彻底改变了我写 SQL 的方式。在读这本书之前，我已经有了大约十年的 SQL 使用经验。但我并没有真正理解其背后的理论。我也不知道怎么写出……
I would recommend SQL and Relational Theory by CJ Date. It completely changed how I use SQL. Before reading it, I had about a decade of experience with SQL. I didn't really understand the theory underneath. I also didn't understand how to write…
……理论。所以我搞不懂大家为什么都在讨论 regexps——那应该只属于那本书某一章的一个小节（正则文法）才对。不管怎样，数据库方面我推荐 Date 的《SQL and Relational Theory》——它展示了 SQL 是如何与一种更优雅、更纯粹的底层理论方法关联起来的，能让你学会用更声明式的方式去思考。至于通用编程，如果还没读过的话，SICP 值得一读……
…theory. so i don't understand why people are talking about regexps - that should be covered in a subsection (regular grammars) of one chapter of that book. anyway, for databases i would suggest date's "sql and relational theory" - it shows how sql is related to a more elegant, cleaner, underlying theoretical approach and will get you to think in more declarative terms. for general programming, sicp is worth reading if you haven't…
……在很短的时间内你就能学到很多关于关系模型、数据库/查询/索引设计的知识，顺便还能学到一点逻辑学。只想要一本好用的 SQL 参考书？《The Art of SQL》或者《SQL and Relational Theory》。还不尽兴？行吧，来啃这个硬骨头吧：http://en.wikipedia.org/wiki/The_Third_Manifesto
…will learn a lot about the relational model, database/query/index design in a short amount of time, with a little bit of logic thrown in there too. Just need a good SQL reference? 'The Art of SQL' or 'SQL and Relational Theory' Are you not entertained? Fine, choke on this : http://en.wikipedia.org/wiki/The_Third_Manifesto
……《Learning SQL》是一本极棒的入门书，大概涵盖了普通开发者所需的大部分 SQL 知识（http://shop.oreilly.com/product/9780596520847.do）。《SQL and Relational Theory》则为你补充了更多关系理论的背景——基本上是给现有的 SQL 实战人员提供了一个更偏学术的视角。Date 写作风格挺干巴的，人也有点认死理，但整体内容非常扎实……
…Learning SQL is a really excellent intro, and probably covers the majority of what your average developer is going to ever need to know about SQL ( http://shop.oreilly.com/product/9780596520847.do ) SQL and Relational Theory gives you more background on relational theory - basically gives a more academic background for existing practitioners of SQL. Date is pretty dry author with a few hangups, but it's largely good solid…
……评论提到 Date 不太情愿去剖析这个问题，不幸的是，他的研究成果散落在他写的大量书籍中（而且这些年他在好几个问题上的立场都发生过改变）。我很喜欢《SQL and Relational Theory》这本，但既然他所有的书我都读过，要不是读者本身就了解 Date 的话，我还是不太敢轻易推荐它。我觉得《An Introduction to Database Systems》的最新版（第8版）依然是最好的书……
…comment about Date being reluctant to analyze the matter, unfortunately his work is disseminated in a lot of books (and he changed his position on quite several matters throughout the years). I love the "SQL and Relational Theory" one but, having red all of his books, I would be hesitant to suggest it unless one already knows Date. I think the latest edition (8th) of "An Introduction to Database Systems" is still the best book…