Patent
Rule-Based Extendable Query Optimizer
Christoph Weyerhaeuser,Tobias Mindnich,Daniel Baeumges,Gerrit Simon Kazmaier +3 more
- 26 Apr 2012
43
TL;DR: In this article, an initial data flow graph is optimized using a model optimizer that includes an optimizer framework and an application programming interface (API) for registration of new optimization rules to be executed by the rules engine.
read more
Abstract: A query is received which causes an initial data flow graph that includes a plurality of nodes that are used to execute the query is generated. Thereafter, the initial data flow graph is optimized using a model optimizer that includes an optimizer framework and an application programming interface (API). The optimizer framework provides logic to restructure the initial data flow graph and a rules engine for executing one or more optimization rules. The API allows for registration of new optimization rules to be executed by the rules engine. Execution of the query is then initiated using the optimized data flow graph. Related apparatus, systems, techniques and articles are also described.
read more
Chat with Paper
AI Agents for this Paper
Find similar papers on Google Scholar, PubMed and Arxiv
Write a critical review of this paper
Analyze citations of this paper to find unaddressed research gaps
Citations
Patent
Query dispatch and execution architecture
Radu Teodorescu,Ryan Caudy,David R. Kent,Charles Wright,Nathan Dorfman +4 more
- 14 May 2016
TL;DR: In this article, methods, systems and computer readable media for providing a query dispatch and execution architecture are described, including methods and systems, systems, and media for querying and execution.
43
Patent
Computer data system data source having an update propagation graph with feedback cyclicality
David R. Kent,Ryan Caudy,Charles Wright,Radu Teodorescu +3 more
- 14 Nov 2017
TL;DR: In this article, the authors describe methods, systems and computer readable media for data source refreshing using an update propagation graph with feedback cyclicality, which they call update propagation graphs.
25
Patent
Splitting of a join operation to allow parallelization
Xun Cheng,Peter Schneider +1 more
- 13 Mar 2014
TL;DR: In this paper, a system and method for processing a database query is described, where a join operator in a preliminary query plan can be split into a build operator and a probe operator.
22
Patent
Historical data replay utilizing a computer system
Radu Teodorescu,Ryan Caudy,David R. Kent,Charles Wright,Oleg A. Vydrov +4 more
- 14 May 2016
TL;DR: In this article, the authors describe methods, systems and computer readable media for simulated replay of data using a computer system. But they do not discuss the use of such media in the real world.
14
Patent
Optimizing a data integration process
Shawn R. Jeffery,Nick Pendar,Matt DeLand,Liwen Sun,Rajat Bhattacharjee +4 more
- 08 Mar 2013
TL;DR: In this article, the processing of a data record is represented as an operator graph comprising nodes and edges, where each node is an operator node that represents an operator for implementing at least one logical operation on at least 1 of the attributes and each edge between a pair of nodes represents the movement of data between the nodes.
12
References
Patent
Labeling and describing search queries for reuse
Stefan Edlund,Michael Lawrence Emens,Reiner Kraft,Peter Chi-Shing Yim +3 more
- 29 Jun 1999
TL;DR: In this article, a system and method associates a label and description with a search query such that the query, label, and description can be stored in a shared query repository so that queries can be retrieved by multiple users for reuse.
194
Patent
Synchronization of SQL actions in a relational database system
Roberta Jo Cochrane,George Lapis,Mir Hamid Pirahesh,Richard S. Sidle,David E. Simmen,Tuong Chanh Truong,Monica Sachiye Urata +6 more
- 30 Jun 1997
TL;DR: In this paper, an automated system for detecting and preventing mutating table violations of database integrity in a SQL query before generation and selection of an optimal query execution plan (QEP) is presented.
114
Patent
Database system with methodology for reusing cost-based optimization decisions
Mihnea Andrei
- 19 May 2000
TL;DR: Ariadne as mentioned in this paper is a database system providing a methodology, implemented as an Abstract Plan on Disc (APOD) technology, for turning cost-based optimization decisions into stored, reusable items.
86
Progressive Parametric Query Optimization
TL;DR: This paper introduces algorithms that, as parametric plans are populated, are able to frequently bypass the optimizer but still execute optimal or near-optimal plans.
Patent
Database System with Methodology for Generating Bushy Nested Loop Join Trees
Mihnea Andrei
- 24 Jan 2005
TL;DR: A database system with methodology for generating bushy nested loop join trees is described in this paper, where a query is expressed as a set of queries and a query execution plan is proposed for returning data requested by the query based on the semantically correct structure of the query.
77