SQL Data Warehouse 个人介绍 缪长风 ⚫ 2010年初加入支付宝，负责Oracle RAC和Greenplum数据仓库 ⚫ 有幸参与了Oracle RAC到 Greenplum再到Hadoop以及最终到 ODPS的架构演进工作。 ⚫ 2012年起，转至阿里巴巴大数据团队，负责Hbase/OTS业务支 撑，期间多次负责阿里大数据双11架构和稳定性工作 ⚫ 2018年，在阿里云数据库负责OLAP产品管理团队。 支持分布式事务，标准数据库隔离级别 基于AnalyticDB for PostgreSQL 构筑云上数据仓库 1：实时数仓场景 通过 DTS/Kettle/rds_dbsync 实时同步交易库数据到 ADBPG MySQL/PG->DTS->ADBPG 2：离线数仓场景 数据集成按天/小时 批量同步交易库数据ADBPG MySQL/PG/SQLServer/Oracle –>DataX/OSS-> 存储不同温度数据 Dec 本地 Column-base 数据 本地 Row-base 数据 Aug Year - 1 Year - 2 External OSS云存储  直接通过外表表即可存储数据到OSS下 适合于存放历史归档数据。  “冷数据”需要时直接查询无需重新进 行导入。  支持CSV，ORC, PARQUET。 Jul Nov Oct Sep 冷热数据统一管理，基于OSS云存储构筑数据湖分析（规划中）

WAL • WALInsertLock 此锁用于将事务日志记录内容插入事务日志内存缓冲区内。 首先，加锁，然后将包括整个缓冲区（full_page_writes打开状态）的内 容复制到日志缓冲区内。 在日志缓冲区刷新期间检查日志缓冲区是否有新内容添加，因为这 关系到设置日志缓冲区的刷新点。 确定检查点重做位置在联机备份期间强制执行完整页写入，直到备 份完成。 从内置函数获取当前WAL插入位置。

for the list of all characters belonging to that class. Standard character class names are: alnum, alpha, blank, cntrl, digit, graph, lower, print, punct, space, upper, xdigit. These stand for the character doc/FAQ_AIX BSD/OS x86 8.0.0 Bruce Momjian (), 2004-12-07 4.3.1 Debian GNU/Linux Alpha 7.4 Noèl Köthe (), 2003-10-25 Debian GNU/Linux AMD64 8.0.0 Build farm panda, snapshot uk>), 2004-12-12 FC3 Fedora x86 8.0.0 Build farm dog, snapshot 2004-12-06 02:06:01 FC1 FreeBSD Alpha 7.4 Peter Eisentraut (), 2003-10-25 4.8 FreeBSD x86 8.0.0 Build farm cockatoo,

for the list of all characters belonging to that class. Standard character class names are: alnum, alpha, blank, cntrl, digit, graph, lower, print, punct, space, upper, xdigit. These stand for the character characters. An ARE may begin with embedded options: a sequence (?xyz) (where xyz is one or more alpha- betic characters) specifies options affecting the rest of the RE. These options override any previously uk>), 2004-12-12 FC3 Fedora x86 8.0.0 Build farm dog, snapshot 2004-12-06 02:06:01 FC1 FreeBSD Alpha 7.4 Peter Eisentraut (), 2003-10-25 4.8 FreeBSD x86 8.0.0 Build farm cockatoo,

for the list of all characters belonging to that class. Standard character class names are: alnum, alpha, blank, cntrl, digit, graph, lower, print, punct, space, upper, xdigit. These stand for the character BSD/OS x86 8.1.0 Bruce Momjian (), 2005-10-26 4.3.1 Debian GNU/Linux Alpha 8.1.0 Build farm hare (3.1, gcc 3.3.4) Debian GNU/Linux AMD64 8.1.0 Build farm panda (sid, gcc 3 0 Build farm viper (FC3, gcc 3.4.2) Fedora x86 8.1.0 Build farm thrush (FC1, gcc 3.3.2) FreeBSD Alpha 7.4 Peter Eisentraut (), 2003-10-25 4.8 FreeBSD AMD64 8.1.0 Build farm platypus

for the list of all characters belonging to that class. Standard character class names are: alnum, alpha, blank, cntrl, digit, graph, lower, print, punct, space, upper, xdigit. These stand for the character BSD/OS x86 8.1.0 Bruce Momjian (), 2005-10-26 4.3.1 Debian GNU/Linux Alpha 8.1.0 Build farm hare (3.1, gcc 3.3.4) Debian GNU/Linux AMD64 8.1.0 Build farm panda (sid, gcc 3 0 Build farm viper (FC3, gcc 3.4.2) Fedora x86 8.1.0 Build farm thrush (FC1, gcc 3.3.2) FreeBSD Alpha 7.4 Peter Eisentraut (), 2003-10-25 4.8 FreeBSD AMD64 8.1.0 Build farm platypus

for the list of all characters belonging to that class. Standard character class names are: alnum, alpha, blank, cntrl, 155 Chapter 9. Functions and Operators digit, graph, lower, print, punct, space BSD/OS x86 8.1.0 Bruce Momjian (), 2005-10-26 4.3.1 Debian GNU/Linux Alpha 8.2.0 Build farm hare (3.1, gcc 3.3.4) Debian GNU/Linux AMD64 8.2.0 Build farm shad (4.0, gcc 4 SUSE Linux x86 8.0.0 Reinhard Max (), 2005-01-03 9.0, 9.1, 9.2, SLES 9 Tru64 UNIX Alpha 8.1.0 Honda Shigehiro (), 2005-11-01 5.0, cc 6.1-011 275 Chapter 14

for the list of all characters belonging to that class. Standard character class names are: alnum, alpha, blank, cntrl, 155 Chapter 9. Functions and Operators digit, graph, lower, print, punct, space BSD/OS x86 8.1.0 Bruce Momjian (), 2005-10-26 4.3.1 Debian GNU/Linux Alpha 8.2.0 Build farm hare (3.1, gcc 3.3.4) Debian GNU/Linux AMD64 8.2.0 Build farm shad (4.0, gcc 4 SUSE Linux x86 8.0.0 Reinhard Max (), 2005-01-03 9.0, 9.1, 9.2, SLES 9 Tru64 UNIX Alpha 8.1.0 Honda Shigehiro (), 2005-11-01 5.0, cc 6.1-011 275 Chapter 14

for the list of all characters belonging to that class. Standard character class names are: alnum, alpha, blank, cntrl, digit, graph, lower, print, punct, space, upper, xdigit. These stand for the character these CPU architectures: x86, x86_64, IA64, Pow- erPC, PowerPC 64, S/390, S/390x, Sparc, Sparc 64, Alpha, ARM, MIPS, MIPSEL, M68K, and PA- RISC. Code support exists for M32R, NS32K, and VAX, but these architectures previous C function manager did not handle null values properly, nor did it support 64-bit CPU’s (Alpha). The new function manager does. You can continue using your old custom functions, but you might want

for the list of all characters belonging to that class. Standard character class names are: alnum, alpha, blank, cntrl, digit, graph, lower, print, punct, space, upper, xdigit. These stand for the character these CPU architectures: x86, x86_64, IA64, PowerPC, PowerPC 64, S/390, S/390x, Sparc, Sparc 64, Alpha, ARM, MIPS, MIPSEL, M68K, and PA-RISC. Code support exists for M32R, NS32K, and VAX, but these architectures previous C function manager did not handle null values properly, nor did it support 64- bit CPU’s (Alpha). The new function manager does. You can continue using your old custom functions, but you might want