AF:III:Small:Collaborative Research: New Frontiers in Join Algorithms: Optimality, Noise, and Richer Languages

关系连接是关系数据库处理的核心，关系数据库处理是当今处理数据的主要方式。该联合还模拟了生物和社会网络、编码理论、压缩传感、机器学习和约束满足方面的问题。最近，研究人员描述了有史以来第一个用于连接查询的最差情况优化算法(NPRR算法)。这些新结果开启了一系列新的工具来解决与连接相关的各种基本问题。该项目旨在进一步利用为NPRR开发的新的算法技术来解决以下三类问题：(1)最优连接算法。开发当数据存储在传统的数据库索引或新的索引结构中时实例最优的算法是该项目的目标。(2)应对和利用噪声。这个项目将扩展最新的工作，以处理和利用最坏情况和统计噪声模型，连接到编码理论和压缩传感。该项目将探索一系列连接查询的扩展，这些扩展将为克服在基序发现、搜索、具有函数依赖的数据库以及更强大的查询和连接操作类别方面的挑战铺平道路。如果成功，这项资助的结果将适用于现代海量、动态和噪声数据集中的各种模式提取问题，这些数据在复杂网络分析、编码理论和压缩感知中有广泛的应用。

The relational join is central to relational database processing, which is the dominant way data is processed today. The join also models problems in biological and social networks, coding theory, compressed sensing, machine learning, and constraint satisfaction. Recently,  the investigators described the first ever worst-case optimal algorithm (the NPRR algorithm) for join queries.  These new results open a line of new tools to attack a diverse set of fundamental problems related to the join. This project aims to further exploit the new algorithmic techniques developed for NPRR to address the following three classes of problems:(1) Optimal Join algorithms. Developing algorithms that are instance optimal when the data are stored in either traditional database indexes or new indexing structures is a goal of this project. (2) Coping with and Leveraging Noise. This project will extend the latest work to handle and leverage both worst-case and statistical noise models, bridging to coding theory and compressed sensing.  (3) Expressive Query Languages. The project will explore a series of extensions to join queries that will pave the way to overcome challenges in motif finding, search, databases with functional dependencies, and more powerful classes of queries and join operations.If successful, the results of this grant will apply to a variety of pattern extraction problems in modern massive, dynamic, and noisy data sets, which have a wide range of applications in complex network analysis, coding theory, and compressive sensing.