• Home
  • Search
  • Quantum-Inspired Digital Annealing for Join Ordering
  • Cite Icon19
  • https://doi.org/10.14778/3632093.3632112Copy DOI Icon

Quantum-Inspired Digital Annealing for Join Ordering

Show More
  • Abstract
  • Literature Map
  • References
  • Citations
  • Similar Papers
Abstract

Finding the optimal join order (JO) is one of the most important problems in query optimisation, and has been extensively considered in research and practise. As it involves huge search spaces, approximation approaches and heuristics are commonly used, which explore a reduced solution space at the cost of solution quality. To explore even large JO search spaces, we may consider special-purpose software, such as mixed-integer linear programming (MILP) solvers, which have successfully solved JO problems. However, even mature solvers cannot overcome the limitations of conventional hardware prompted by the end of Moore's law. We consider quantum-inspired digital annealing hardware, which takes inspiration from quantum processing units (QPUs). Unlike QPUs, which likely remain limited in size and reliability in the near and mid-term future, the digital annealer (DA) can solve large instances of mathematically encoded optimisation problems today. We derive a novel, native encoding for the JO problem tailored to this class of machines that substantially improves over known MILP and quantum-based encodings, and reduces encoding size over the state-of-the-art. By augmenting the computation with a novel readout method, we derive valid join orders for each solution obtained by the (probabilistically operating) DA. Most importantly and despite an extremely large solution space, our approach scales to practically relevant dimensions of around 50 relations and improves result quality over conventionally employed approaches, adding a novel alternative to solving the long-standing JO problem.

Similar Papers
  • Research Article
  • Citations22

Benchmarks for Current Linear and Mixed Integer Optimization Solvers

  • Dec 26, 2015
  • Acta Universitatis Agriculturae et Silviculturae Mendelianae Brunensis
  • Josef Jablonský
  • Book Chapter
  • Citations1

Revisiting Bounded Reachability Analysis of Timed Automata Based on MILP

  • Jan 01, 2018
  • Iulian Ober
  • Book Chapter
  • Citations3

Local Search Based Metaheuristics for Two-Echelon Distribution Network with Perishable Products

  • Jan 01, 2015
  • Sona Kande +3
  • Research Article
  • Citations33

Tuning BARON using derivative-free optimization algorithms

  • Mar 16, 2018
  • Journal of Global Optimization
  • Jianfeng Liu +2
  • Conference Article

A Solver + Gradient Descent Training Algorithm for Deep Neural Networks

  • Jul 01, 2022
  • Dhananjay Ashok +3
  • Book Chapter

Chapter 13 - Emerging clouds

  • Mar 18, 2022
  • Cloud Computing
  • Dan C Marinescu
  • Research Article
  • Citations104

Real-time energy scheduling for home energy management systems with an energy storage system and electric vehicle based on a supervised-learning-based strategy

  • Jul 06, 2023
  • Energy Conversion and Management
  • Truong Hoang Bao Huy +3
  • Research Article

Alternative mixed integer linear programming optimization for joint job scheduling and data allocation in grid computing

  • Feb 01, 2026
  • Future Generation Computer Systems
  • Shengyu Feng +20
  • Research Article
  • Citations12

Efficient optimization of a large-scale biorefinery system using a novel decomposition based approach

  • May 31, 2020
  • Chemical Engineering Research and Design
  • Varun Punnathanam +1
  • Single Report

Faster EPTAS for Scheduling on Uniform Machines

  • Oct 01, 2025
  • Klaus Jansen +2
  • Research Article

Hybrid intervention scheme-based optimization algorithm for real-time management of reactive power resources

  • Nov 09, 2017
  • at - Automatisierungstechnik
  • Deesh Dileep +3
  • Book Chapter
  • Citations10

Tweakable TWINE: Building a Tweakable Block Cipher on Generalized Feistel Structure

  • Jan 01, 2019
  • Kosei Sakamoto +8
  • Book Chapter
  • Citations2

Journal Ratings and Their Consensus Ranking

  • Jan 01, 2009
  • Stefan Theussl +1
  • Conference Article

Offer strategy for a wind power producer in day-ahead market

  • Sep 01, 2015
  • R Laia +3
  • PDF
  • Research Article
  • Citations4

Task Roadmaps: Speeding up Task Replanning

  • Apr 28, 2022
  • Frontiers in Robotics and AI
  • Anders Lager +3
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.