blocks|key|175266|text|joins|type|unstyled|depth|inlineStyleRanges|entityRanges|data|175267|Cost-based优化器(几乎将查询写入到其head)|unordered-list-item|175268|
|175269|Partitioning+(支持更好的VLDB+management)|175270|175271|Parallel+(多线程)查询processing|175272|175273|Clustering+(不仅是可用性，也包括可伸缩性))|175274|175275|在SQL中具有更大的灵活性，以及更容易地将SQL与3GL+languages|175276|175277|Better诊断capabilities|175278|
集成。|175279|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$]]|$1|E|3|F|5|6|7|10|8|@]|9|@]|A|$]]|$1|G|3|H|5|D|7|11|8|@]|9|@]|A|$]]|$1|I|3|F|5|6|7|12|8|@]|9|@]|A|$]]|$1|J|3|K|5|D|7|13|8|@]|9|@]|A|$]]|$1|L|3|F|5|6|7|14|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|15|8|@]|9|@]|A|$]]|$1|O|3|F|5|6|7|16|8|@]|9|@]|A|$]]|$1|P|3|Q|5|D|7|17|8|@]|9|@]|A|$]]|$1|R|3|F|5|6|7|18|8|@]|9|@]|A|$]]|$1|S|3|T|5|D|7|19|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1A|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]]|X|$]]

<ul>
<li>Hash joins</li>
<li>Cost-based optimizers (pretty much turned query-writing on its head)</li>
<li>Partitioning (enables much better VLDB management)</li>
<li>Parallel (multi-threaded) query processing</li>
<li>Clustering (not just availability but scalability too)</li>
<li>More flexibility in SQL as well as easier integration of SQL with 3GL languages</li>
<li>Better diagnostics capabilities</li>
</ul>

blocks|key|175230|text|象秩的解析函数|type|unstyled|depth|inlineStyleRanges|entityRanges|data|175231|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

blocks|key|175227|text|我不确定您是否希望包括特定于供应商的创新(我也不完全确定其他数据库引擎无法做到这一点)，但是Server+2005在其语言中添加了递归transact-sql查询。我发现它们对于遍历分层数据非常有用。我相信2008年增加了一些与层次数据相关的新功能，但我还没有仔细研究过。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|175228|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I'm not sure if you want to include even vendor-specific innovations (and nor am I entirely certain that other database engines can't already do this), but SQL Server 2005 adds recursive transact-sql queries to their language. I find them amazingly useful for iterating over hierarchical data. I believe 2008 adds some new functionality related to hierarchical data, but I haven't looked that closely.

blocks|key|175241|text|SELECT+(invoiceprice+*+detailweight)+/+SUM(weight)+OVER(PARITTION+BY+invoice)+as+weighted,+*+
FROM+tblInvoiceDetails|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|175242|窗口函数对于处理诸如加权平均值之类的事情和以前需要游标的其他事情来说是很棒的。|unstyled|175243|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>SELECT (invoiceprice * detailweight) / SUM(weight) OVER(PARITTION BY invoice) as weighted, * 
FROM tblInvoiceDetails
</code></pre>

Windowed functions are awesome for doing things like weighted averages, and other things that previously required CURSORS.

blocks|key|175305|text|那么，人们可能会认为，15年来缺乏运动不仅是缺乏创新的标志，而且是数据库几乎完美的标志！许多人试图用代码做些更好的事情，而这些数据库自60年代以来就得到了改进，以尽可能快和高效地运行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|175306|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Well one could possibly suggest that a lack of movement for 15 years is not just a sign of lack of innovation, but a sign that databases are almost perfect! Many people try to do things in code that are better done in databases that have been refined since the 1960's to run as fast and as efficiently as possible.

blocks|key|298566|text|我想说的是，过去十年(1998-2008年)，开放源码的RDBMS产品在主流部署中变得可行。大多数财富500强企业现在使用MySQL或PostgreSQL或其他开源关系数据库管理系统，即使它们也使用商业的、封闭的关系数据库管理系统品牌之一。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|298567|这并不是一项技术进步，但值得注意的是，由于有了一个稳定的、开放源码的RDBMS引擎，许多其他创新项目得以实现。|298568|我意识到MySQL和PostgreSQL早在1995年就已经面世，但我认为在那之后的几年里，它们还没有成为主流。|298569|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I would say the last ten years (1998-2008) have seen open source RDBMS products become viable in mainstream deployments. Most Fortune 500 companies now use MySQL or PostgreSQL or another open source RDBMS somewhere in their organization, even if they also use one of the commercial, closed-source RDBMS brands.

This isn't a technical advancement, but it's noteworthy nevertheless because the availability of a stable, open-source RDBMS engine enables many other innovative projects.

I realize that both MySQL and PostgreSQL were available as early as 1995, but I would argue that they weren't mainstream for several years after that.

blocks|key|175245|text|我认为大多数进展都是在性能领域--查询分析器和集群。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|175246|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I think most of the progress has been in the realm of performance - query profilers and clusters.

blocks|key|175263|text|我认为最大的创新领域可能是数据复制--提高可用性和可靠性。大多数其他领域都是渐进的。通过指定十年，您忽略了ORDBMS的内容--可扩展性；这是在1997年出现的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|175264|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I think that the area of biggest innovation has probably been in data replication - for availability and reliability. Most of the other areas are more incremental. By specifying a decade, you omit the ORDBMS stuff - extensibility; that appeared in 1997.

The SQL implementation of relational databases has been around in their current form for something like 25 years (since System R and Ingres). Even the main (loosely adhered to) standard is ANSI-92 (although there were later updates) is a good 15 years old.

What innovations can you think of with SQL based databases in the last ten years or so. I am specifically excluding OLAP, Columnar and other non-relational (or at least non SQL) innovations. I also want to exclude 'application server' type features and bundling (like reporting tools)

Although the basic approach has remained fairly static, I can think of:

<ul>
<li>Availability</li>
<li>Ability to handle larger sets of data</li>
<li>Ease of maintenance and configuration</li>
<li>Support for more advanced data types (blob, xml, unicode etc)</li>
</ul>

Any others that you can think of?

What relational database innovations have there been in the last 10 years

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

关系数据库的SQL实现已经以其当前的形式存在了大约25年(自从System和Ingres)。即使是主要(松散地遵守)标准是ANSI-92 (尽管后来有更新)是一个良好的15年。在过去的十多年里，基于SQL的数据库有哪些创新之处？我特别不包括OLAP、专栏和其他非关系(或至少是非SQL)创新。我还想排除“应用服务器”类型的特性和捆绑(比如报告工具)。虽然基本方法仍然是相当静态的，但我可以想到：Ava

问在过去的十年里，有哪些关系数据库创新？
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在过去的十年里，有哪些关系数据库创新？EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在过去的十年里，有哪些关系数据库创新？
EN