4 repository-uri
Awesome GitHub RepositoriesQuery Rewriting
Runtime transformation of SQL statements to facilitate sharding and routing logic.
Distinct from SQL Statement Parsing: Distinct from general parsing; specifically transforms queries to handle sharding keys and routing.
Explore 4 awesome GitHub repositories matching data & databases · Query Rewriting. Refine with filters or upvote what's useful.
Awesome Query Rewriting GitHub Repositories
Găsește cele mai bune repo-uri cu AI.Vom căuta cele mai potrivite repository-uri folosind AI.
- apache/pinot
apache/pinot
6,098Vezi pe GitHubPinot is a distributed, columnar analytical database designed for high-concurrency, low-latency query processing. It functions as a real-time OLAP datastore, enabling interactive, user-facing analytics by ingesting and querying massive datasets from both streaming and batch sources. The system architecture relies on a centralized controller for cluster coordination and a distributed segment-based storage model to ensure horizontal scalability. The platform distinguishes itself through a hybrid ingestion pipeline that unifies real-time event streams and historical batch data into a single quer
Automatically redirects queries to pre-aggregated materialized views to improve performance without user intervention.
Java - jsqlparser/jsqlparser
JSQLParser/JSqlParser
5,950Vezi pe GitHubJSqlParser este o bibliotecă Java pentru parsarea interogărilor SQL, convertind șirurile SQL brute într-o ierarhie structurată de obiecte Java puternic tipizate. Oferă mijloacele de a analiza și manipula programatic interogările bazei de date prin reprezentarea lor ca un arbore de obiecte. Biblioteca suportă atât parsarea textului SQL existent, cât și generarea programatică a noilor instrucțiuni printr-un API fluent. Include mecanisme pentru transformarea arborilor de interogare și serializarea modelelor de obiecte structurate înapoi în text SQL formatat. Capabilitățile suplimentare includ analiza schemei bazei de date, cum ar fi extragerea numelor tabelelor pentru a mapa dependențele de date și validarea sintaxei SQL. Parserul este configurabil pentru a gestiona diferite dialecte de sintaxă și include recuperare tolerantă la erori pentru a continua procesarea scripturilor după întâlnirea unor token-uri invalide.
Navigates and modifies parsed SQL statement trees to rewrite or optimize queries.
Java - pgdogdev/pgdog
pgdogdev/pgdog
3,361Vezi pe GitHubpgdog is a PostgreSQL sharding proxy, distributed SQL router, and connection pooler. It is designed to enable horizontal data distribution by splitting tables and indices across multiple independent servers to scale storage and processing capacity. The project distinguishes itself through online resharding capabilities, using logical replication to move data between shards without application downtime. It supports multiple routing strategies, including hash, list, and range-based query routing, and manages distributed atomic transactions using a two-phase commit process to ensure consistency
Parses and transforms SQL statements at runtime to handle sharding keys and route data to correct servers.
Rustload-balancerpoolerpostgresql - aarondfrancis/fast-paginate
aarondfrancis/fast-paginate
1,367Vezi pe GitHubFast-paginate is a database utility designed to optimize pagination performance in PHP and Laravel applications. It functions as a transparent layer that intercepts standard query builders to replace default pagination logic with more efficient retrieval strategies, specifically targeting large-scale datasets where traditional offset and limit operations can become resource-intensive. The library distinguishes itself by implementing deferred join techniques, which retrieve only primary keys in an initial subquery before fetching full records to minimize data scanning. It further improves resp
Intercepts standard query builders to transparently replace pagination logic while maintaining compatibility with existing method signatures.
PHPlaravelpagination
