FAQ

Nested SQL

Known as: Nested table 
In relational databases, a nested table is a table that is embedded within another table. Individual elements can be inserted, updated, and deleted… (More)
Wikipedia

Topic mentions per year

Topic mentions per year

1987-2015
01219872015

Related topics

Related topics

4 relations
Array data structureFirst normal formTable

Broader (1)

SQL

Related mentions per year

Related mentions per year

1936-2018
19401960198020002020
Nested SQL
Table
SQL
Array data structure
First normal form

Papers overview

Semantic Scholar uses AI to extract papers important to this topic.
2016
2016
Translating Temporal SQL to Nested SQL
This paper presents a technique for weaving temporal semantics into an SQL query. We assume that a query writer programs a query… (More)
  • figure 1
  • figure 2
  • figure 3
  • figure 4
  • figure 5
Is this relevant?
2011
2011
An Efficient Nested Query Processing for Distributed Database Systems
Performance of OLAP queries becomes a critical issue as the amount of data in the data warehouses increases rapidly. To solve… (More)
  • figure 1
  • figure 2
  • table 1
  • figure 3
  • figure 4
Is this relevant?
2011
2011
The SQL Function XMLNEST to Generate Recursive XML Values from Relational Data
SQL standard provides SQL/XML publishing functions to publish the result of an SQL query as XML values but it does not provide… (More)
  • table 1
  • figure 1
  • figure 2
  • figure 3
  • figure 4
Is this relevant?
2009
2009
Improved Query Plans for Unnesting Nested SQL Queries
The SQL language allows users to express queries that have nested subqueries in them. Optimization of nested queries has received… (More)
  • figure 1
  • figure 4
  • figure 7
  • figure 8
  • figure 9
Is this relevant?
2007
2007
Optimization of Nested SQL
We present a new optimization method for nested SQL query blocks with aggregation operators. The method is derived from the… (More)
Is this relevant?
2003
2003
Executing Nested Queries
Optimization of nested queries, in particular finding equivalent “flattened” queries for queries that employ the SQL sub-query… (More)
Is this relevant?
2003
2003
Indexing and retrieving Semantic Web resources: the RDFStore model
The Semantic Web is a logical evolution of the existing Web. It is based on a common conceptual data model of great generality… (More)
Is this relevant?
1994
1994
Optimization of Nested Queries in a Complex Object Model
Transformation of nested SQL queries into join queries is advantageous because a nested SQL query can be looked upon as a nested… (More)
  • table 1
  • table 2
Is this relevant?
1989
1989
Optimization and Dataflow Algorithms for Nested Tree Queries
The SQL language allows useIs to express queries that have nested subqueries in them. Optimization of nested queries has received… (More)
  • figure 1
  • figure 2
  • figure 4
  • table 1
  • figure 5
Is this relevant?
Highly Cited
1987
Highly Cited
1987
Optimization of Nested SQL Queries Revisited
Current methods of evaluating nested queries in the SQL language can be inefficient in a variety of query and data base contexts… (More)
  • figure 1
  • figure 2
Is this relevant?