into form the executor wants ## Early Preprocessing • Simplify scalar expressions • Expand simple SQL functions in-line • Simplify join tree ## Simplify Scalar Expressions ## • Simplify function calls not “ERROR: division by zero” ## Expand Simple SQL Functions in-line CREATE FUNCTION incr4(int) RETURNS int AS 'SELECT $1 + (2 + 2)' LANGUAGE SQL; SELECT incr4(a) FROM foo; >> SELECT a

## C++20 ♥ SQL John R Bandela, MD ## Overview SQL C++ Example Implementation techniques fixed_string meta_struct Parsing compile time strings into meta_structures  ## Overview SQL C++ Example Implementation Techniques https://github.com/google/cpp-from-the-sky-down/tree/master/meta_struct_20/cppcon_version ## SQL Probably the highest level mainstream HOPE YOU'RE HAPPY. AND I HOPE YOU'VE LEARNED TO SANITIZE YOUR DATABASE INPUTS. ## Avoiding SQL Injection Attacks SELECT orders.id, name, item, price, discount_code FROM orders JOIN customers ON

CHINA CONF 2023 第三届中国 Rust 开发者大会 6.17-6.18 @Shanghai ## PromQL Got a BOOST: 用 Rust 重写 Prometheus 的查询引擎 Ruihang Xia @greptime.com ## I ABOUT ## Ruihang GitHub: waynexia Losing hair at Greptime Wanna distributed) SQL and table model ## I WHY REWRITE Target to be the most powerful drop-in replacement PromQL has a good UX for time-series data And it can be better if combine with SQL RIIR, super cooooooo /3622b4beb64d5780512009caeca5090c/p10_2.jpg) larger dataset more computation resources ## SQL ## SQL is extended introducing the new concept we have just made ![Image](/uploads/documents/3/6/2/

pitfalls in Firebird SQL Paul Vinkenoog Version 1.2, 30 June 2020 ## Table of Contents 1. What is NULL? ..... 4 1.1. NULL as a default state ..... 4 2. NULL support in Firebird SQL ..... 6 2.1. Disallowing operations will render the entire expression NULL. This guide explores the behaviour of NULL in Firebird SQL, points out common pitfalls and shows you how to deal safely with expressions that contain NULL or reference to refresh your memory, go to the summary at the end of the guide. ## So — what is it? In SQL, NULL is not a value. It is a state indicating that an item's value is unknown or nonexistent.

## TiDB: HBase分布式事务与SQL实现 ## About me • TiDB & Codis founder • Golang expert • Distributed database developer • Currently, CEO and co-founder of PingCAP liuqi@pingcap.com https://github.com/pingcap/tidb What did they say? “Nothing is hotter than SQL-on-Hadoop, and now SQL-on-HBase is fast approaching equal hotness status” Form HBaseCon 2015 We want more! SQL + Transaction(ACID) ## TiDB Features ## • MySQL-client MySQL-client Load Balancer MySQL Protocol Server MySQL Protocol Server TiDB SQL Layer TiDB SQL Layer Transactional KV Storage KV KV KV KV ### AH. HBase • First things first ☐ Need

第三届中国Rust开发者大会 6.17-6.18 @Shanghai ## 用 egg 孵化你的 SQL 优化器 王润基 RisingWave 内核开发工程师 ## RisingLight ## An Educational OLAP Database System ## RisingLight 查询引擎的整体结构  ## 一 个 SQL 语句优化的例子 SQL Physical Plan  ## 查询优化 ## 基于规则的优化 (RBO) ![Image](/uploads/d input"), e => e.clone(), } }) } 改用 egg 之前这个需要 200 行代码完成 ## 基于 egg 的新版查询引擎  ## 评估：TPC-H Q5

## 阿里云 AnalyticDB for PostgreSQL - 打造更简单易用的Cloud SQL Data Warehouse ## 个人介绍  ## 缪长风 ● 2010年初加入支付宝，负责Oracle RAC和Greenplum数据仓库 应用易开发、适配 支持SQL 2003，部分兼容Oracle语法，支持PL/SQL存储过程，OLAP窗口函数，事务及数据库标准隔离级别完备功能和生态，实现应用快速迁移或适配  ## PB级数据秒级响应 MPP水平扩展架构，PB级数据查询秒级响应；向 量化计算，及列存储智能索引，领先传统数据库引擎性能 3x；新一代SQL优化器，实现复杂分析语句免调优  ## - 支持多模分析 通过PostGIS插件支持地理信息数据分析；MADlib库内置100+机器学习算法库，实现数据智能探索；高性

构建支撑千亿级数据量的高可用查询引擎 演讲人：蔡岳毅 1. 为什么选择ClickHouse/StarRocks; 2. ClickHouse/StarRocks 的高可用架构； 3. 如何合理的应用ClickHouse的优点，StarRocks如何来补充ClickHouse的短板； 4. ClickHouse的调优，运维介绍； 5. 应用总结； ## 根据实际业务场景需要来选择 1. 不固定的查询条件，不固定的汇总条件； 3. 业务场景不断增多，涉及面越来越广； 4. 需要保证高可用并秒出； 5. 从Sql，Es，CrateDB，Kylin，Ingite，MongoDB，Hbase不断的研究，实践； ## ClickHouse 的特点 ## 优点： 1. 数据压缩比高，存储成本相对非常低； 2. 支持常用的SQL语法，写入速度非常快，适用于大量的数据更新； 3. 依赖稀疏索引，列式存储，cpu/内存 3da8245523ee107f9e380f0c14ade/p5_1.jpg) ## StarRocks的特点 ## 优点： 1. 支持标准的SQL语法，兼容MySQL协议； 2. MPP架构，扩缩容非常简单方便； 3. 支持高并发查询； 4. 跨机房部署，实现最低成本的DR ## 缺点： 1. 不支持大规模的批处理； 2. 支持insert into，但最理想的是消费Kafka;