是否所有现代RDBMS行定向？为什么？ [英] Are all modern RDBMS row oriented? Why?

问题描述

如果一个关系数据库范例是以元组为导向的，我们在这里有最大的限制。

If one of relational databases paradigms is to be tuple oriented we have the biggest limitation here.

如果可以设计面向列的数据库， 。
矢量操作将执行开箱，索引，散列的简单符号列查找，链接列表作为引擎的幕后链接。

If one could design column oriented db, that would improve performance a lot. Vector operations would perform out of the box, indexing, hashing for simple symbol columns lookups, linked lists behind the scenes as engine.

内存映射：转储

仍然使用多个供应商支持的良好理解和标准语言（SQL）。

想象一下，可以设计多少工具

这不是更强壮（和KISS同时）？

Memory mapping: dumps in huge chunks in microseconds as well as loading those disk images.
And still have use well understood and standard language (SQL) that multiple vendors support.
Imagine how many tools could be designed for interfacing that thing, because of its simplicity.
Wouldn't it be more robust (and KISS at the same time)?

UPDATE

感谢所有参与者。

问题已被不公正地关闭，但我发现所有答案都非常有用。

UPDATE
Thanks to all contributors.
Question has been unjustly closed, though i've found your all answers very informative.

推荐答案

是否都是现代的RDBMS行？

Are all modern RDBMS row oriented?

$ b b

否。它们是为特定任务设计的，比如OLTP vs OLAP。即使是像MySQL这样的流行软件也有列存储引擎（例如： Infobright ）。

这里是一个有趣的阅读： C-Store：面向列的DBMS （PDF格式）

Here's a potentially interesting read for you: C-Store: A Column-oriented DBMS (PDF format)

LucidDB 是一个面向数据仓库的流行的面向列的数据库， BI：

LucidDB is a popular column-oriented database for data warehousing and BI:

LucidDB是第一个也是唯一的
开源RDBMS专用的
，完全用于数据仓库，
商业智能。它基于
架构基石，例如列存储，位图索引，散列
连接/聚合和页面级别
多版本。大多数数据库
系统（专有和
开放源代码）在事务处理
功能时开始生命，重点是
，然后获得分析
功能作为
事后如果有的话）。相比之下，
LucidDB的每个组件都是
设计的要求
灵活，高性能数据
集成和复杂的查询
处理。 此外，
在其架构的焦点
范围内的全面性意味着
用户简单：无需DBA
。

LucidDB is the first and only open-source RDBMS purpose-built entirely for data warehousing and business intelligence. It is based on architectural cornerstones such as column-store, bitmap indexing, hash join/aggregation, and page-level multiversioning. Most database systems (both proprietary and open-source) start life with a focus on transaction processing capabilities, then get analytical capabilities bolted on as an afterthought (if at all). By contrast, every component of LucidDB was designed with the requirements of flexible, high-performance data integration and sophisticated query processing in mind. Moreover, comprehensiveness within the focused scope of its architecture means simplicity for the user: no DBA required.

请参阅与您的兴趣重叠的功能列表： LucidDB功能

See its list of features for those that overlap with your interests here: LucidDB Features

还是使用很好理解和
标准语言

And still have use well understood and standard language (SQL) that multiple vendors support.

您可以使用SQL与LucidDB。

You can use SQL with LucidDB.

这篇关于是否所有现代RDBMS行定向？为什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！