Abstract:Joins in native graph database management systems (GDBMSs) are predefined to the system as edges, which are indexed in adjacency list indices and serve as pointers. This contrasts with and can be more performant than value-based joins in RDBMSs and has lead researchers to investigate ways to integrate predefined joins directly into RDBMSs. Existing approaches adopt a strict separation of graph and relational data and processors, where a graph-specific processor uses left-deep and index nested loop joins for a subset of joins. This may be suboptimal, and may lead to non-sequential scans of data in some queries. We propose a purely relational approach to integrate predefined joins in columnar RDBMSs that uses row IDs (RIDs) of tuples as pointers. Users can predefine equality joins between any two tables, which leads to materializing RIDs in extended tables and optionally in RID indices. Instead of using the RID index to perform the join directly, we use it primarily in hash joins to generate semi-join filters that can be passed to scans using sideways information passing, ensuring sequential scans. In some settings, we also use RID indices to reduce the number of joins in query plans. Our approach does not introduce any graph-specific system components, can execute predefined joins on any join plan, and can improve performance on any workload that contains equality joins that can be predefined. We integrated our approach to DuckDB and call the resulting system {\em GRainDB}. We demonstrate that GRainDB far improves the performance of DuckDB on relational and graph workloads with large many-to-many joins, making it competitive with a state-of-the-art GDBMS, and incurs no major overheads otherwise.

Graceful Degradation for Top-Down Join Enumeration via similar sub-queries measure on Chip Multi-Processor

Degradation of Complexity for Join Enumeration via Weight Measure on CMP

Optimization Strategy of Top-Down Join Enumeration on Modern Multi-Core CPUs.

Optimization Factor Analysis Of Large-Scale Join Queries On Different Platforms

Optimization Strategy of Bidirectional Join Enumeration in Multi-Core CPUS

Optimization Strategy of Parallel Query Processing Based on Multi-core Architecture.

Parallel Two-Way Enumeration Join Based on Multi-cores Environment

Adaptive Multi-join Query Processing in PDBMS

Load balancing parallelizing XML query processing based on shared cache chip multi-processor (CMP)

Thorough Data Pruning for Join Query in Database System

Exploiting Primitive-Level Parallelism for Column Database Query on Multi-Core Processor Systems

Granularity Analysis for Exploiting Adaptive Parallelism of Declarative Programs on Multiprocessors

Parallel Query Optimization Techniques for Multi-Join Expressions Based on Genetic Algorithm

Optimizing the parallel adaptive indexing algorithm on mul ti-co re CPUs

Join Processing for Graph Patterns: An Old Dog with New Tricks

Revisiting Co-Processing for Hash Joins on the Coupled CPU-GPU Architecture

A Comparative Exploration of ML Techniques for Tuning Query Degree of Parallelism

OLAP on Modern Chiplet-Based Processors

Performance modeling of positive degraded task-pair with helper-thread in CMP

Query grouping-based multi-query optimization framework for interactive SQL query engines on Hadoop.

Making RDBMSs Efficient on Graph Workloads Through Predefined Joins