Skip to search formSkip to main contentSkip to account menu

Hierarchical and recursive queries in SQL

Known as: SYS CONNECT BY PATH, CONNECT BY ISCYCLE, With (SQL) 
A hierarchical query is a type of SQL query that handles hierarchical model data. They are special case of more general recursive fixpoint queries… 
Wikipedia (opens in a new tab)

Related topics

Related topics

23 relations
CUBRIDDatalogDeductive databaseFirebird

Broader (1)

Recursion

Papers overview

Semantic Scholar uses AI to extract papers important to this topic.
2016
2016
Scaling up the performance of more powerful Datalog systems on multicore machines
Extending RDBMS technology to achieve performance and scalability for queries that are much more powerful than those of SQL-2 has… 
2016
2016
UFMG at the TREC 2016 Dynamic Domain track
In TREC 2016, we focus on tackling the challenges posed by the Dynamic Domain (DD) track. The goal of the TREC DD track is to… 
2014
2014
Rules and Ontology Based Data Access
In OBDA an ontology defines a high level global vocabulary for user queries, and such vocabulary is mapped to (typically… 
2012
2012
Unrolling SQL: 1999 Recursive Queries
Hierarchical and graph data structures are common in practical application development. In order to query such data, one can use… 
2008
2008
Efficient Fixpoint Methods for Approximate Query Answering in Locally Complete Databases
  • 2008
  • Corpus ID: 53519908
Standard databases convey Reiter’s closed-world assumption that an atom not in the database is false. This assumption is relaxed… 
2005
2005
Analysis on the performance of mobile agents for query retrieval
2003
2003
Watermarking in secure image retrieval
2002
2002
Structural Function Inlining Technique for Structurally Recursive XML Queries
2001
2001
Operational Semantics for Fixed-Point Logics on Constraint Databases
In this paper we compare the expressive power of s fixed-point logics on linear or dense order constraint databases. This… 
2000
2000
A Framework for Linguistic and Hierarchical Queries in Document Retrieval
We describe a document retrieval language which enables user’s to bet-ter represent their requirements with respect to the… 
By clicking accept or continuing to use the site, you agree to the terms outlined in our Privacy Policy (opens in a new tab), Terms of Service (opens in a new tab), and Dataset License (opens in a new tab)