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… (More)
Wikipedia

Papers overview

Semantic Scholar uses AI to extract papers important to this topic.
2017
2017
MapReduce environments offer great scalability by restricting the programming model to only map and reduce operators. This… (More)
  • figure 1
  • figure 2
  • figure 3
  • figure 4
  • figure 5
Is this relevant?
2012
2012
Hierarchical and graph data structures are common in practical application development. In order to query such data, one can use… (More)
  • table 1
  • figure 1
Is this relevant?
2012
2012
Recursive queries were introduced as part of ANSI SQL 99 to support processing of hierarchical data typical of air flight… (More)
  • table 1
  • figure 1
  • table 2
  • figure 2
  • figure 3
Is this relevant?
2010
2010
Recursion is a fundamental computation mechanism which has been incorporated into the SQL language. This work focuses on the… (More)
  • figure 1
  • table I
  • table II
  • table III
  • table VI
Is this relevant?
2009
2009
A recursive SQL-1999 query consists of a recursive CTE (Common Table Expression) and a query which uses it. If such a recursive… (More)
  • figure 2
  • figure 1
  • figure 4
  • table 1
Is this relevant?
Highly Cited
2008
Highly Cited
2008
This paper considers the problem of reasoning on massive amounts of (possibly distributed) data. Presently, existing proposals… (More)
  • figure 1
  • figure 3
  • figure 4
  • figure 5
  • figure 6
Is this relevant?
2005
2005
Recursion represents an important addition to the SQL language. This work focuses on the optimization of linear recursive queries… (More)
  • table 1
  • table 2
  • table 3
  • table 4
  • figure 1
Is this relevant?
2005
2005
Recursive queries are required for many tasks of database applications. Among them we can mention Bill-Of-Material (BOM), various… (More)
  • figure 1
Is this relevant?
Highly Cited
1987
Highly Cited
1987
An alpha (α) operator is proposed which when added to relational algebra allows a large class of natural and useful recursive… (More)
Is this relevant?
1987
1987
The work presented in this paper is an attempt to combine two different but closely related research areas in the data base field… (More)
Is this relevant?