是SQL数据库用于组装？ [英] Is SQL the assembly for databases?

问题描述

说到Hibernate和他人的ORM的奥姆斯传道者谈论像数据库汇编语言SQL。

Talking about hibernate and others ORMs, the ORMs evangelists talk about SQL like the assembly language for Databases.

我觉得很快断言这一点，但我想可以在不久的将来是真实的，不知道。

I think is soon to assert this, but I guess can be true on a near future, not sure.

更新：这个比喻我是指手段的 SQL 的是的组装的东西 ORM 的是 C /的Java / C＃的。当然，确切的类比是不可能的。现在的问题是，如果在未来，具有更强大的计算机开​​发人员将只能使用的 ORM 的（或类似ORM）替代的 SQL 的

UPDATE: The analogy I was referring means SQL is to assembly what ORM is to C/Java/C#. Of course, an exact analogy is not possible. The question is if in the future, with more powerful computers the developers are going to use only ORM (or ORM like) instead of SQL.

推荐答案

绝对不是。

汇编语言是你指示处理器究竟做什么，包括你想用什么等等注册一个非常低级语言

Assembly language is a very low level language where you instruct the processor exactly what to do, including what registers you want to use etc.

SQL是你描述你想要的语义，然后查询优化决定如何执行它，所以你甚至不控制一下被执行了很高的水平语言。这是一个非常强大和灵活的语言，其中的ORM提供至多（相当小）的子集。

SQL is a very high level language where you describe the semantics of what you want, and then a query optimiser decides how to execute it, so you don't even control what gets executed. It's an extremely powerful and flexible language of which any ORM offers at most a (fairly small) subset.

您会发现，.NET框架引入了LINQ最近是引进高层次类似于SQL的建设成为像C＃和VB语言的一种方式。而不是像汇编，这是pretty易认为，SQL工作在抽象比大多数主流编程语言的一个更高的层次。

You'll notice that the .NET framework has introduced LINQ recently which is a way to introduce high level SQL-like constructs into languages like C# and VB. Rather than being like assembler, it's pretty easy to argue that SQL works at a higher level of abstraction than most mainstream programming languages.

这篇关于是SQL数据库用于组装？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！