Calcite هو إطار عمل لتحليل وتحسين وترجمة استعلامات SQL إلى جبر علائقي للتنفيذ عبر مصادر بيانات متنوعة. يعمل كمحرك استعلامات متعدد المصادر، ومكتبة لتحليل SQL، ومحسن للجبر العلائقي.
الميزات الرئيسية لـ apache/calcite هي: Cross-Source Querying, Federated Data Query Engines, Cross-Source Data Integration, Cost-Based Optimizers, Query Plan Optimizations, Query Optimizer Frameworks, Relational Query Optimizers, Rule-Based Plan Optimizations.
تشمل البدائل مفتوحة المصدر لـ apache/calcite: prestodb/presto — Presto is a distributed SQL query engine designed for high-performance analytical processing across heterogeneous data… apache/pinot — Pinot is a distributed, columnar analytical database designed for high-concurrency, low-latency query processing. It… alasql/alasql — AlaSQL is a JavaScript SQL database engine that allows for the filtering, grouping, and joining of in-memory object… apache/datafusion — Apache DataFusion is an extensible, columnar SQL query engine that runs embedded within a host application without… apache/hive — Apache Hive is a SQL-on-Hadoop data warehouse that enables querying and managing petabytes of data stored in… trinodb/trino — Trino is a distributed SQL query engine designed for large-scale data analytics. It functions as a data federation…
Presto is a distributed SQL query engine designed for high-performance analytical processing across heterogeneous data sources. It functions as a data federation platform and massively parallel processing engine, allowing users to execute interactive queries against diverse storage systems without requiring data migration. By mapping remote metadata and structures to a unified relational namespace, it enables seamless cross-platform analysis through a standard SQL interface. The engine distinguishes itself through a pluggable connector architecture and a shared-nothing distributed processing
Pinot 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
AlaSQL is a JavaScript SQL database engine that allows for the filtering, grouping, and joining of in-memory object arrays and JSON data. It functions as an in-memory SQL database and client-side data processor, enabling the execution of SQL statements against JavaScript arrays and external data sources in both browser and server environments. The project serves as a universal data query tool capable of performing relational joins across diverse sources, such as merging Google Spreadsheets, SQLite files, and remote APIs into a single result set. It also acts as an IndexedDB SQL wrapper, allow
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