Data Warehouse 个人介绍 缪长风 ⚫ 2010年初加入支付宝，负责Oracle RAC和Greenplum数据仓库 ⚫ 有幸参与了Oracle RAC到 Greenplum再到Hadoop以及最终到 ODPS的架构演进工作。 ⚫ 2012年起，转至阿里巴巴大数据团队，负责Hbase/OTS业务支 撑，期间多次负责阿里大数据双11架构和稳定性工作 ⚫ 2018年，在阿里云数据库负责OLAP产品管理团队。 2：离线数仓场景 数据集成按天/小时 批量同步交易库数据ADBPG MySQL/PG/SQLServer/Oracle –>DataX/OSS-> ADBPG 3：大数据计算场景 同步MaxCompute/Hadoop数据，ADBPG做在线分析 大数据平台->DataX/OSS/Blink/-> ADBPG 4：数据湖分析场景 数据按冷热分析，支持在线查询OSS分布式云存 储上的格式化数据 AnalyticDB MaxCompute 生产系统数据库 关系型数据 库A RDS …… 关系型数据 库B RDS 关系型数据 库C RDS 关系型数据 库D ECS自建 自建大数据计算平台 Hadoop Spark EMR Dataphi n OSS海量云存储 Data Lake Store DTS 实时同步 Dump Data Dump Data 数据集成 按需回流 数据仓库应用

(integer division truncates results) 4 / 2 2 % modulo (remainder) 5 % 4 1 ^ exponentiation 2.0 ^ 3.0 8 121 Chapter 9. Functions and Operators Operator Description Example Result |/ square root |/ power(a dp, b dp) dp a raised to the power of b power(9.0, 3.0) 729 power(a numeric, b numeric) numeric a raised to the power of b power(9.0, 3.0) 729 radians(dp) dp degrees to radians radians(45.0) 0 Note that server_version, server_encoding and integer_datetimes cannot change after startup. Pre-3.0-protocol servers do not report parameter settings, but libpq includes logic to obtain val- ues for

(integer division truncates results) 4 / 2 2 % modulo (remainder) 5 % 4 1 ^ exponentiation 2.0 ^ 3.0 8 |/ square root |/ 25.0 5 ||/ cube root ||/ 27.0 3 ! factorial 5 ! 120 !! factorial (prefix operator) power(9.0, 3.0) 729 116 Chapter 9. Functions and Operators Function Return Type Description Example Result power(a numeric, b numeric) numeric a raised to the power of b power(9.0, 3.0) 729 radians(dp) Note that server_version, server_encoding and integer_datetimes cannot change after startup. Pre-3.0-protocol servers do not report parameter settings, but libpq includes logic to obtain val- ues for

(integer division truncates results) 4 / 2 2 % modulo (remainder) 5 % 4 1 ^ exponentiation 2.0 ^ 3.0 8 |/ square root |/ 25.0 5 ||/ cube root ||/ 27.0 3 ! factorial 5 ! 120 !! factorial (prefix operator) dp, b dp) dp a raised to the power of b power(9.0, 3.0) 729 power(a numeric, b numeric) numeric a raised to the power of b power(9.0, 3.0) 729 radians(dp) dp degrees to radians radians(45.0) Note that server_version, server_encoding and integer_datetimes cannot change after startup. Pre-3.0-protocol servers do not report parameter settings, but libpq includes logic to obtain val- ues for

(integer division truncates results) 4 / 2 2 % modulo (remainder) 5 % 4 1 ^ exponentiation 2.0 ^ 3.0 8 |/ square root |/ 25.0 5 ||/ cube root ||/ 27.0 3 ! factorial 5 ! 120 !! factorial (prefix operator) dp, b dp) dp a raised to the power of b power(9.0, 3.0) 729 power(a numeric, b numeric) numeric a raised to the power of b power(9.0, 3.0) 729 radians(dp) dp degrees to radians radians(45.0) Note that server_version, server_encoding and integer_datetimes cannot change after startup. Pre-3.0-protocol servers do not report parameter settings, but libpq includes logic to obtain val- ues for

(integer division truncates results) 4 / 2 2 % modulo (remainder) 5 % 4 1 ^ exponentiation 2.0 ^ 3.0 8 |/ square root |/ 25.0 5 ||/ cube root ||/ 27.0 3 ! factorial 5 ! 120 !! factorial (prefix operator) dp, b dp) dp a raised to the power of b power(9.0, 3.0) 729 power(a numeric, b numeric) numeric a raised to the power of b power(9.0, 3.0) 729 radians(dp) dp degrees to radians radians(45.0) 4.0.1) NetBSD m68k 8.2.0 Build farm osprey (2.0, gcc 3.3.3) NetBSD x86 8.2.0 Build farm gazelle (3.0, gcc 3.3.3); canary (1.6, gcc 2.95.3) OpenBSD AMD64 8.2.0 Build farm zebra (4.0, gcc 3.3.5) OpenBSD

(integer division truncates results) 4 / 2 2 % modulo (remainder) 5 % 4 1 ^ exponentiation 2.0 ^ 3.0 8 |/ square root |/ 25.0 5 ||/ cube root ||/ 27.0 3 ! factorial 5 ! 120 !! factorial (prefix operator) dp, b dp) dp a raised to the power of b power(9.0, 3.0) 729 power(a numeric, b numeric) numeric a raised to the power of b power(9.0, 3.0) 729 radians(dp) dp degrees to radians radians(45.0) 4.0.1) NetBSD m68k 8.2.0 Build farm osprey (2.0, gcc 3.3.3) NetBSD x86 8.2.0 Build farm gazelle (3.0, gcc 3.3.3); canary (1.6, gcc 2.95.3) OpenBSD AMD64 8.2.0 Build farm zebra (4.0, gcc 3.3.5) OpenBSD

result) 4 / 2 2 % modulo (remainder) 5 % 4 1 ^ exponentiation (asso- ciates left to right) 2.0 ^ 3.0 8 |/ square root |/ 25.0 5 ||/ cube root ||/ 27.0 3 ! factorial (deprecated, use factorial() instead) b dp) dp a raised to the pow- er of b power(9.0, 3.0) 729 power(a nu- meric, b nu- meric) numeric a raised to the pow- er of b power(9.0, 3.0) 729 radians(dp) dp degrees to radians radians(45 Note that server_version, server_encoding and in- teger_datetimes cannot change after startup. Pre-3.0-protocol servers do not report parameter settings, but libpq includes logic to obtain values for server_version

result) 4 / 2 2 % modulo (remainder) 5 % 4 1 ^ exponentiation (asso- ciates left to right) 2.0 ^ 3.0 8 |/ square root |/ 25.0 5 ||/ cube root ||/ 27.0 3 ! factorial (deprecated, use factorial() in- dp, b dp) dp a raised to the power of b power(9.0, 3.0) 729 power(a nu- meric, b nu- meric) numeric a raised to the power of b power(9.0, 3.0) 729 radians(dp) dp degrees to radians radi- ans(45 Note that server_version, server_encoding and integer_datetimes cannot change after startup. Pre-3.0-protocol servers do not report parameter settings, but libpq includes logic to obtain val- ues for

result) 4 / 2 2 % modulo (remainder) 5 % 4 1 ^ exponentiation (associates left to right) 2.0 ^ 3.0 8 |/ square root |/ 25.0 5 ||/ cube root ||/ 27.0 3 ! factorial (deprecated, use factorial() instead) dp, b dp) dp a raised to the power of b power(9.0, 3.0) 729 power(a numeric, b numeric) numeric a raised to the power of b power(9.0, 3.0) 729 radians(dp) dp degrees to radians radians(45.0) Note that server_version, server_encoding and integer_datetimes cannot change after startup. Pre-3.0-protocol servers do not report parameter settings, but libpq includes logic to obtain val- ues for