Awesome GitHub RepositoriesQuery Plan Optimizations

Dapper is a high-performance micro-ORM and SQL object mapper for .NET. It functions as an ADO.NET extension library that adds data mapping capabilities directly to database connections, allowing SQL query results to be transformed into typed objects. The project prioritizes execution speed and low memory overhead by using intermediate language generation to map database columns to object properties. It further optimizes performance through the use of concurrent caching for mapping functions and literal value injection to improve database execution plans. The library covers a broad range of d

Apache DataFusion is an extensible, columnar SQL query engine that runs embedded within a host application without requiring a separate server process. It processes data in columnar batches using Apache Arrow for memory-efficient analytics, and can scale analytic workloads across multiple nodes for parallel execution. The engine supports both SQL and DataFrame queries through a modular, streaming architecture that allows custom operators, data sources, functions, and optimizer rules. The engine distinguishes itself through its modular extension framework, which enables building custom query e

Soar is a suite of specialized tools designed for analyzing MySQL performance, advising on indexing, and optimizing SQL syntax. It functions as a performance analyzer, index advisor, and query optimizer to identify bottlenecks and suggest structural improvements for faster execution. The project distinguishes itself through a system for rewriting SQL statements into optimized equivalent versions using custom heuristic rules and patterns. It also features a dedicated index advisor that evaluates query patterns and database metadata to recommend the creation of new indexes. Its broader capabil

Calcite 是一个用于解析、优化并将 SQL 查询转换为关系代数以在不同数据源上执行的框架。它既是一个跨源查询引擎，也是一个 SQL 解析库和关系代数优化器。 该项目提供了一个基于成本的优化引擎，利用可插拔规则将逻辑查询计划转换为高效的物理执行计划。它利用转换适配器将标准 SQL 请求转换为外部数据库和消息系统的原生格式，从而实现异构存储系统之间的数据联邦。 该系统涵盖了完整的查询生命周期，包括 SQL 解析和模式验证、将表达式转换为代数运算符，以及选择高效的执行计划。它还包含一个用于执行查询和管理数据源连接的命令行界面。

Redka 是一个基于 SQL 的键值存储，实现了 Redis 兼容接口。它充当关系数据桥梁，将非关系协议命令转换为关系查询，从而使用 SQL 数据库后端提供持久性和 ACID 事务。 该系统允许通过将内部键值数据公开为 SQL 视图来进行关系数据内省，从而支持通过关系语法进行直接查询和分析。它可以作为独立的网络服务器部署，也可以作为 Go 应用程序中的嵌入式库部署。 该项目支持多种数据结构，包括字符串、列表、哈希、无序集合和有序集合。它提供了具有生存时间（TTL）元数据的键生命周期管理、原子数值操作和集合代数功能。为了管理性能和访问，它包括内存存储模式和只读连接模式。

This project is a Chinese localization repository and technical translation project designed to make concise programming projects and technical documentation accessible to Chinese speakers. It provides a collection of translated resources and curated mappings of computer science terminology to ensure consistent translation of technical concepts. The project implements a software localization workflow that converts English-language technical guides and codebase documentation into Chinese. This process utilizes a technical glossary resource and a resource-driven localization model to maintain t

MiniOB is an open-source educational relational database kernel designed for learning the internals of database systems. It implements a dual-engine storage architecture combining B+ Tree and LSM-Tree, supports SQL parsing and query execution, and provides transactional processing with multi-version concurrency control. The system communicates with clients using the MySQL wire protocol and includes a vector database extension for storing and querying high-dimensional vectors. The project distinguishes itself through its comprehensive coverage of core database concepts in a single, learnable c

This project is an educational resource and technical manual for Apache Spark, focused on the architecture and practical application of large-scale data processing. It serves as a guide for big data engineering and distributed computing, covering the principles of parallel processing and fault-tolerant data distribution. The material provides instructional content on designing distributed ETL pipelines and implementing data analysis workflows. It includes tutorials for polyglot data processing, offering patterns and examples for using Python, Scala, and Java within a unified environment. The