CMU 15-445 数据库
文章平均质量分 51
IAMZWH
这个作者很懒,什么都没留下…
展开
-
The Parallelism Operator (aka Exchange)
The Parallelism Operator (aka Exchange)原创 2021-09-01 13:22:17 · 153 阅读 · 0 评论 -
Index scan, B+Tree search, (non-)selective predicates
原创 2021-09-01 13:20:03 · 116 阅读 · 0 评论 -
Heap files, row identifiers (RIDs)
原创 2021-09-01 13:19:46 · 79 阅读 · 0 评论 -
Scan sharing
IBMScan sharing refers to the ability of one scan to exploit the work done by another scan. Examples of shared work include disk page reads, disk seeks, buffer pool content reuse, decompression, and so on.Heavy scans, such as table scans or multidimensio原创 2021-08-24 10:25:01 · 174 阅读 · 0 评论 -
Bookings Schema Diagram
来源The main entity is a booking (bookings).One booking can include several passengers, with a separate ticket (tickets) issued to each passenger. A ticket has a unique number and includes information about the passenger. As such, the passenger is not a s原创 2021-08-20 10:55:24 · 208 阅读 · 0 评论 -
what‘s role of VersionSet Version VersionEdit in leveldb?
Note that these are internal types and only people needing to understand the implementation really need to understand these types. But some people like to do so, so here is a brief overview:A Version is a configuration of on-disk files that (in conjunctio原创 2021-07-22 09:57:21 · 72 阅读 · 0 评论 -
Join trees, join orders, dynamic programming
canonical: 经典的; (数学表达式)最简洁的;residual: 剩余的prune:剪枝; 裁减; 精简;原创 2021-07-09 20:37:52 · 69 阅读 · 0 评论 -
哈工大数据库PPT
在select迭代器基础之上,构造投影运算的迭代器。反映了一种流水线的工作方式。反映了程序构造的一种思路。例子:输出集合满了!将上述过程按平面给展开:...原创 2021-06-28 10:26:12 · 369 阅读 · 0 评论 -
Volcano iterator model
Vectorized and Compiled Queries — Part 1Imagine a volcano it is like a cone or at least it is drawn like that by most kids including me ????. The below one is definitely not drawn by a kid.As the shape of the volcano suggests lava(把岩浆比作data) is too much原创 2021-06-08 10:40:58 · 283 阅读 · 0 评论 -
Catalog: Data-Dictionary Storage
原创 2021-04-08 16:34:45 · 74 阅读 · 0 评论 -
【概念】SQL Server Clustered Tables vs Heap Tables
对关系型数据库产品(RDBMS)而言,一个重要特性就是:数据信息都被组织为二维数据表,信息的表达可以通过一系列的关联(Join)来完成。具体数据库产品在实现这个标准的时候,又有千差万别的特点。就是一个特定的数据库RDBMS产品,往往也提供不同的实现方法。1、从堆表(Heap Table)到索引组织表(Index Organization Table)Oracle作为一款成熟的数据库软件产品,就提供了多种数据表存储结构。我们最常见的就是三种,分别为堆表(Heap Table)、索引组织表(Index Or原创 2020-11-12 15:30:26 · 216 阅读 · 0 评论