Matches in DBpedia 2015-10 for { <http://dbpedia.org/resource/Recursive_join> ?p ?o }
Showing triples 1 to 37 of
37
with 100 triples per page.
- Recursive_join abstract "The recursive join is an operation used in relational databases, also sometimes called a "fixed-point join". It is a compound operation that involves repeating the join operation, typically accumulating more records each time, until a repetition makes no change to the results (as compared to the results of the previous iteration).For example, if a database of family relationships is to be searched, and the record for each person has "mother" and "father" fields, a recursive join would be one way to retrieve all of a person's known ancestors: first the person's direct parents' records would be retrieved, then the parents' information would be used to retrieve the grandparents' records, and so on until no new records are being found.In this example, as in many real cases, the repetition involves only a single database table, and so is more specifically a "recursive self-join".Recursive joins can be very time-consuming unless optimized through indexing, the addition of extra key fields, or other techniques.Recursive joins are highly characteristic of hierarchical data, and therefore become a serious issue with XML data. In XML, operations such as determining whether one element contains another are extremely common, and the recursive join is perhaps the most obvious way to implement them when the XML data is stored in a relational database.The standard way to define recursive joins in the SQL:1999 standard is by way of recursive common table expressions. Database management systems that support recursive CTEs include Microsoft SQL Server, Oracle, PostgreSQL and others.".
- Recursive_join wikiPageID "8533909".
- Recursive_join wikiPageLength "1866".
- Recursive_join wikiPageOutDegree "12".
- Recursive_join wikiPageRevisionID "552183561".
- Recursive_join wikiPageWikiLink Category:Database_theory.
- Recursive_join wikiPageWikiLink Category:Relational_model.
- Recursive_join wikiPageWikiLink Common_table_expressions.
- Recursive_join wikiPageWikiLink Hierarchical_and_recursive_queries_in_SQL.
- Recursive_join wikiPageWikiLink Join_(SQL).
- Recursive_join wikiPageWikiLink Microsoft_SQL_Server.
- Recursive_join wikiPageWikiLink Oracle_Database.
- Recursive_join wikiPageWikiLink PostgreSQL.
- Recursive_join wikiPageWikiLink Relational_database.
- Recursive_join wikiPageWikiLink Relational_databases.
- Recursive_join wikiPageWikiLink SQL:1999.
- Recursive_join wikiPageWikiLink XML.
- Recursive_join wikiPageWikiLinkText "Recursive join".
- Recursive_join wikiPageWikiLinkText "recursive join".
- Recursive_join hasPhotoCollection Recursive_join.
- Recursive_join wikiPageUsesTemplate Template:Comp-sci-stub.
- Recursive_join wikiPageUsesTemplate Template:Unreferenced.
- Recursive_join subject Category:Database_theory.
- Recursive_join subject Category:Relational_model.
- Recursive_join hypernym Operation.
- Recursive_join type Area.
- Recursive_join type Article.
- Recursive_join type MilitaryConflict.
- Recursive_join type Area.
- Recursive_join type Article.
- Recursive_join comment "The recursive join is an operation used in relational databases, also sometimes called a "fixed-point join".".
- Recursive_join label "Recursive join".
- Recursive_join sameAs m.0276ymq.
- Recursive_join sameAs Q17119419.
- Recursive_join sameAs Q17119419.
- Recursive_join wasDerivedFrom Recursive_join?oldid=552183561.
- Recursive_join isPrimaryTopicOf Recursive_join.