<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/abstract>	"A hierarchical query is a type of SQL query that handles hierarchical model data. They are special cases of more general recursive fixpoint queries, which compute transitive closures. In standard SQL:1999 hierarchical queries are implemented by way of recursive (CTEs). Unlike Oracle's earlier , recursive CTEs were designed with fixpoint semantics from the beginning. Recursive CTEs from the standard were relatively close to the existing implementation in IBM DB2 version 2. Recursive CTEs are also supported by Microsoft SQL Server (since SQL Server 2008 R2), Firebird 2.1, PostgreSQL 8.4+, SQLite 3.8.3+, IBM Informix version 11.50+, CUBRID, MariaDB 10.2+ and MySQL 8.0.1+. Tableau has documentation describing how CTEs can be used. TIBCO Spotfire does not support CTEs, while Oracle 11g Release 2's implementation lacks fixpoint semantics. Without common table expressions or connected-by clauses it is possible to achieve hierarchical queries with user-defined recursive functions."@en .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/View_(database)> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Datalog> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://www.w3.org/2000/01/rdf-schema#comment>	"\u518D\u5E30\u30AF\u30A8\u30EA (\u82F1: recursive query) \u3082\u3057\u304F\u306F \u968E\u5C64\u30AF\u30A8\u30EA (\u82F1: hierarchical query) \u306F\u3001\u518D\u5E30\u7684\u306A\u554F\u3044\u5408\u308F\u305B\u3092\u884C\u3046 SELECT \u30B9\u30C6\u30FC\u30C8\u30E1\u30F3\u30C8\u3067\u3042\u308B\u3002\u968E\u5C64\u69CB\u9020\u3092\u6301\u3064\u30C7\u30FC\u30BF\u306A\u3069\u306B\u4F7F\u3046\u3002"@ja .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/property/wikiPageUsesTemplate>	<http://dbpedia.org/resource/Template:Expand_section> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageExternalLink>	<https://kb.tableau.com/articles/howto/using-common-table-expressions> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/SQLite> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Factorial> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/EnterpriseDB> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Deductive_database> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Sybase_(database)> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/CUBRID> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageExternalLink>	<http://explainextended.com/2009/11/18/sql-server-are-the-recursive-ctes-really-set-based/> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://www.w3.org/2000/01/rdf-schema#label>	"Hierarchical and recursive queries in SQL"@en .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/property/wikiPageUsesTemplate>	<http://dbpedia.org/resource/Template:Mono> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Informix> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Category:Articles_with_example_SQL_code> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/property/wikiPageUsesTemplate>	<http://dbpedia.org/resource/Template:Reflist> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/PostgreSQL> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://www.w3.org/2002/07/owl#sameAs>	<http://ru.dbpedia.org/resource/\u0418\u0435\u0440\u0430\u0440\u0445\u0438\u0447\u0435\u0441\u043A\u0438\u0435_\u0438_\u0440\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u044B\u0435_\u0437\u0430\u043F\u0440\u043E\u0441\u044B_\u0432_SQL> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Oracle_database> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://www.w3.org/2000/01/rdf-schema#label>	"\u0406\u0454\u0440\u0430\u0440\u0445\u0456\u0447\u043D\u0456 \u0442\u0430 \u0440\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u0456 \u0437\u0430\u043F\u0438\u0442\u0438 \u0432 SQL"@uk .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageLength>	"13344"^^<http://www.w3.org/2001/XMLSchema#nonNegativeInteger> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Fixpoint> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageRevisionID>	"1094019376"^^<http://www.w3.org/2001/XMLSchema#integer> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://www.w3.org/2002/07/owl#sameAs>	<http://pt.dbpedia.org/resource/Common_table_expression> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Snowflake_Inc.> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://purl.org/dc/terms/subject>	<http://dbpedia.org/resource/Category:Articles_with_example_SQL_code> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Vertica> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/abstract>	"Em banco de dados SQL, Common table expression (CTE) \u00E9 uma alternativa a subquerys, views, e fun\u00E7\u00F5es definidas pelo usu\u00E1rio. CTE \u00E9 ent\u00E3o um conjunto nomeado e tempor\u00E1rio de resultados, derivado de uma consulta simples e definido sob o escopo de execu\u00E7\u00E3o de uma declara\u00E7\u00E3o SELECT, INSERT, UPDATE, ou DELETE."@pt .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageExternalLink>	<https://web.archive.org/web/20131114094211/http:/gennick.com/with.html> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageExternalLink>	<http://www.blacktdn.com.br/2015/06/blacktdn-mssql-usando-consulta-cte.html> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Microsoft_SQL_Server> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/HSQLDB> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/property/wikiPageUsesTemplate>	<http://dbpedia.org/resource/Template:Cite_book> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://www.w3.org/2002/07/owl#sameAs>	<http://uk.dbpedia.org/resource/\u0406\u0454\u0440\u0430\u0440\u0445\u0456\u0447\u043D\u0456_\u0442\u0430_\u0440\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u0456_\u0437\u0430\u043F\u0438\u0442\u0438_\u0432_SQL> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://www.w3.org/2000/01/rdf-schema#label>	"\u0418\u0435\u0440\u0430\u0440\u0445\u0438\u0447\u0435\u0441\u043A\u0438\u0435 \u0438 \u0440\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u044B\u0435 \u0437\u0430\u043F\u0440\u043E\u0441\u044B \u0432 SQL"@ru .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/SQL:1999> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/MySQL> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/abstract>	"\u0406\u0454\u0440\u0430\u0440\u0445\u0456\u0447\u043D\u0438\u0439 \u0437\u0430\u043F\u0438\u0442 \u2014 \u0442\u0438\u043F \u0437\u0430\u043F\u0438\u0442\u0443 SQL, \u0449\u043E \u043E\u0431\u0440\u043E\u0431\u043B\u044F\u0454 \u0456\u0454\u0440\u0430\u0440\u0445\u0456\u0447\u043D\u0443 \u043C\u043E\u0434\u0435\u043B\u044C \u0434\u0430\u043D\u0438\u0445. \u0412\u043E\u043D\u0438 \u0454 \u043E\u0441\u043E\u0431\u043B\u0438\u0432\u0438\u043C \u0432\u0438\u043F\u0430\u0434\u043A\u043E\u043C \u0437\u0430\u0433\u0430\u043B\u044C\u043D\u0456\u0448\u0438\u0445 \u0440\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u0438\u0445 \u043D\u0435\u0440\u0443\u0445\u043E\u043C\u0438\u0445 \u0437\u0430\u043F\u0438\u0442\u0456\u0432, \u044F\u043A\u0456 \u043E\u0431\u0447\u0438\u0441\u043B\u044E\u044E\u0442\u044C \u0442\u0440\u0430\u043D\u0437\u0438\u0442\u0438\u0432\u043D\u0456 \u0437\u0430\u043C\u0438\u043A\u0430\u043D\u043D\u044F. \u0423 \u0441\u0442\u0430\u043D\u0434\u0430\u0440\u0442\u0456 SQL:1999 \u0456\u0454\u0440\u0430\u0440\u0445\u0456\u0447\u043D\u0456 \u0437\u0430\u043F\u0438\u0442\u0438 \u0440\u0435\u0430\u043B\u0456\u0437\u043E\u0432\u0430\u043D\u0456 \u0448\u043B\u044F\u0445\u043E\u043C \u0440\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u0438\u0445 \u0437\u0430\u0433\u0430\u043B\u044C\u043D\u0438\u0445 \u0442\u0430\u0431\u043B\u0438\u0447\u043D\u0438\u0445 \u0432\u0438\u0440\u0430\u0437\u0456\u0432 (\u0417\u0422\u0412). \u041D\u0430 \u0432\u0456\u0434\u043C\u0456\u043D\u0443 \u0432\u0456\u0434 \u0431\u0456\u043B\u044C\u0448 \u0440\u0430\u043D\u043D\u0456\u0445 \u0432 Oracle, \u0440\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u0456 \u0417\u0422\u0412 \u0431\u0443\u043B\u043E \u0440\u043E\u0437\u0440\u043E\u0431\u043B\u0435\u043D\u043E \u0437 \u043D\u0435\u0440\u0443\u0445\u043E\u043C\u043E\u044E \u0441\u0435\u043C\u0430\u043D\u0442\u0438\u043A\u043E\u044E \u0432\u0456\u0434 \u043F\u043E\u0447\u0430\u0442\u043A\u0443. \u0420\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u0456 \u0417\u0422\u0412 \u0437\u0456 \u0441\u0442\u0430\u043D\u0434\u0430\u0440\u0442\u0443 \u0431\u0443\u043B\u0438 \u0432\u0456\u0434\u043D\u043E\u0441\u043D\u043E \u0431\u043B\u0438\u0437\u044C\u043A\u0456 \u0434\u043E \u043D\u0430\u044F\u0432\u043D\u043E\u0457 \u0440\u0435\u0430\u043B\u0456\u0437\u0430\u0446\u0456\u0457 \u0432 IBM DB2 \u0432\u0435\u0440\u0441\u0456\u0457 2. \u0420\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u0456 \u0417\u0422\u0412 \u0442\u0430\u043A\u043E\u0436 \u043F\u0456\u0434\u0442\u0440\u0438\u043C\u0443\u044E\u0442\u044C\u0441\u044F Microsoft SQL Server (\u043F\u043E\u0447\u0438\u043D\u0430\u044E\u0447\u0438 \u0437 SQL Server 2008 R2), Firebird 2.1, PostgreSQL 8.4+, SQLite 3.8.3+, IBM Informix \u0432\u0435\u0440\u0441\u0456\u0457 11.50+, , MariaDB 10.2+ \u0456 MySQL 8.0.1+. Tableau \u043C\u0430\u0454 \u0434\u043E\u043A\u0443\u043C\u0435\u043D\u0442\u0430\u0446\u0456\u044E, \u0449\u043E \u043E\u043F\u0438\u0441\u0443\u0454, \u044F\u043A \u0417\u0422\u0412 \u043C\u043E\u0436\u0443\u0442\u044C \u0432\u0438\u043A\u043E\u0440\u0438\u0441\u0442\u043E\u0432\u0443\u0432\u0430\u0442\u0438\u0441\u044F. TIBCO Spotfire \u043D\u0435 \u043F\u0456\u0434\u0442\u0440\u0438\u043C\u0443\u0454 \u0417\u0422\u0412, \u0442\u043E\u0434\u0456 \u044F\u043A \u0440\u0435\u0430\u043B\u0456\u0437\u0430\u0446\u0456\u0457 Oracle 11g Release 2 \u0431\u0440\u0430\u043A\u0443\u0454 \u043D\u0435\u0440\u0443\u0445\u043E\u043C\u043E\u0457 \u0441\u0435\u043C\u0430\u043D\u0442\u0438\u043A\u0438. \u0411\u0435\u0437 \u0437\u0430\u0433\u0430\u043B\u044C\u043D\u0438\u0445 \u0442\u0430\u0431\u043B\u0438\u0447\u043D\u0438\u0445 \u0432\u0438\u0440\u0430\u0437\u0456\u0432 \u0430\u0431\u043E \u0443\u043C\u043E\u0432 connected-by \u043C\u043E\u0436\u043B\u0438\u0432\u043E \u0434\u043E\u0441\u044F\u0433\u0442\u0438 \u0456\u0454\u0440\u0430\u0440\u0445\u0456\u0447\u043D\u0438\u0445 \u0437\u0430\u043F\u0438\u0442\u0456\u0432 \u0437\u0430 \u0434\u043E\u043F\u043E\u043C\u043E\u0433\u043E\u044E \u043A\u043E\u0440\u0438\u0441\u0442\u0443\u0432\u0430\u0446\u044C\u043A\u0438\u0445 \u0440\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u0438\u0445 \u0444\u0443\u043D\u043A\u0446\u0456\u0439."@uk .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://www.w3.org/2002/07/owl#sameAs>	<http://he.dbpedia.org/resource/\u05E9\u05D0\u05D9\u05DC\u05EA\u05D5\u05EA_\u05D4\u05D9\u05E8\u05E8\u05DB\u05D9\u05D5\u05EA_\u05D5\u05E8\u05E7\u05D5\u05E8\u05E1\u05D9\u05D1\u05D9\u05D5\u05EA_\u05D1-SQL> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/property/wikiPageUsesTemplate>	<http://dbpedia.org/resource/Template:Databases> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://www.w3.org/2002/07/owl#sameAs>	<http://rdf.freebase.com/ns/m.047t76b> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/IBM_Db2> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://www.w3.org/2002/07/owl#sameAs>	<http://www.wikidata.org/entity/Q5753091> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://xmlns.com/foaf/0.1/isPrimaryTopicOf>	<http://en.wikipedia.org/wiki/Hierarchical_and_recursive_queries_in_SQL> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://www.w3.org/2000/01/rdf-schema#label>	"Common table expression"@pt .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://www.w3.org/2002/07/owl#sameAs>	<https://global.dbpedia.org/id/4m7TB> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/IBM_Informix> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageExternalLink>	<http://www.cs.duke.edu/courses/fall04/cps116/lectures/11-recursion.pdf> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Subquery> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Hierarchical_model> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageID>	"17919602"^^<http://www.w3.org/2001/XMLSchema#integer> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://www.w3.org/2000/01/rdf-schema#comment>	"\u0406\u0454\u0440\u0430\u0440\u0445\u0456\u0447\u043D\u0438\u0439 \u0437\u0430\u043F\u0438\u0442 \u2014 \u0442\u0438\u043F \u0437\u0430\u043F\u0438\u0442\u0443 SQL, \u0449\u043E \u043E\u0431\u0440\u043E\u0431\u043B\u044F\u0454 \u0456\u0454\u0440\u0430\u0440\u0445\u0456\u0447\u043D\u0443 \u043C\u043E\u0434\u0435\u043B\u044C \u0434\u0430\u043D\u0438\u0445. \u0412\u043E\u043D\u0438 \u0454 \u043E\u0441\u043E\u0431\u043B\u0438\u0432\u0438\u043C \u0432\u0438\u043F\u0430\u0434\u043A\u043E\u043C \u0437\u0430\u0433\u0430\u043B\u044C\u043D\u0456\u0448\u0438\u0445 \u0440\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u0438\u0445 \u043D\u0435\u0440\u0443\u0445\u043E\u043C\u0438\u0445 \u0437\u0430\u043F\u0438\u0442\u0456\u0432, \u044F\u043A\u0456 \u043E\u0431\u0447\u0438\u0441\u043B\u044E\u044E\u0442\u044C \u0442\u0440\u0430\u043D\u0437\u0438\u0442\u0438\u0432\u043D\u0456 \u0437\u0430\u043C\u0438\u043A\u0430\u043D\u043D\u044F. \u0423 \u0441\u0442\u0430\u043D\u0434\u0430\u0440\u0442\u0456 SQL:1999 \u0456\u0454\u0440\u0430\u0440\u0445\u0456\u0447\u043D\u0456 \u0437\u0430\u043F\u0438\u0442\u0438 \u0440\u0435\u0430\u043B\u0456\u0437\u043E\u0432\u0430\u043D\u0456 \u0448\u043B\u044F\u0445\u043E\u043C \u0440\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u0438\u0445 \u0437\u0430\u0433\u0430\u043B\u044C\u043D\u0438\u0445 \u0442\u0430\u0431\u043B\u0438\u0447\u043D\u0438\u0445 \u0432\u0438\u0440\u0430\u0437\u0456\u0432 (\u0417\u0422\u0412). \u041D\u0430 \u0432\u0456\u0434\u043C\u0456\u043D\u0443 \u0432\u0456\u0434 \u0431\u0456\u043B\u044C\u0448 \u0440\u0430\u043D\u043D\u0456\u0445 \u0432 Oracle, \u0440\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u0456 \u0417\u0422\u0412 \u0431\u0443\u043B\u043E \u0440\u043E\u0437\u0440\u043E\u0431\u043B\u0435\u043D\u043E \u0437 \u043D\u0435\u0440\u0443\u0445\u043E\u043C\u043E\u044E \u0441\u0435\u043C\u0430\u043D\u0442\u0438\u043A\u043E\u044E \u0432\u0456\u0434 \u043F\u043E\u0447\u0430\u0442\u043A\u0443. \u0420\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u0456 \u0417\u0422\u0412 \u0437\u0456 \u0441\u0442\u0430\u043D\u0434\u0430\u0440\u0442\u0443 \u0431\u0443\u043B\u0438 \u0432\u0456\u0434\u043D\u043E\u0441\u043D\u043E \u0431\u043B\u0438\u0437\u044C\u043A\u0456 \u0434\u043E \u043D\u0430\u044F\u0432\u043D\u043E\u0457 \u0440\u0435\u0430\u043B\u0456\u0437\u0430\u0446\u0456\u0457 \u0432 IBM DB2 \u0432\u0435\u0440\u0441\u0456\u0457 2. \u0420\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u0456 \u0417\u0422\u0412 \u0442\u0430\u043A\u043E\u0436 \u043F\u0456\u0434\u0442\u0440\u0438\u043C\u0443\u044E\u0442\u044C\u0441\u044F Microsoft SQL Server (\u043F\u043E\u0447\u0438\u043D\u0430\u044E\u0447\u0438 \u0437 SQL Server 2008 R2), Firebird 2.1, PostgreSQL 8.4+, SQLite 3.8.3+, IBM Informix \u0432\u0435\u0440\u0441\u0456\u0457 11.50+, , MariaDB 10.2+ \u0456 MySQL 8.0.1+. Tableau \u043C\u0430\u0454 \u0434\u043E\u043A\u0443\u043C\u0435\u043D\u0442\u0430\u0446\u0456\u044E, \u0449\u043E \u043E\u043F\u0438\u0441\u0443\u0454, \u044F\u043A \u0417\u0422\u0412 \u043C\u043E\u0436\u0443\u0442\u044C \u0432\u0438\u043A\u043E\u0440\u0438\u0441\u0442\u043E\u0432\u0443\u0432\u0430\u0442\u0438\u0441\u044F. TIBCO Spotfire \u043D\u0435 \u043F\u0456\u0434\u0442\u0440\u0438\u043C\u0443\u0454 \u0417\u0422\u0412, \u0442\u043E\u0434\u0456 \u044F\u043A \u0440\u0435\u0430\u043B\u0456\u0437\u0430\u0446\u0456\u0457"@uk .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/property/wikiPageUsesTemplate>	<http://dbpedia.org/resource/Template:Technical> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Teradata> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Transitive_closure> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Comparison_of_relational_database_management_systems> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageExternalLink>	<https://stackoverflow.com/questions/1731889/cycle-detection-with-recursive-subquery-factoring> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://www.w3.org/2000/01/rdf-schema#label>	"\u518D\u5E30\u30AF\u30A8\u30EA"@ja .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/abstract>	"\u518D\u5E30\u30AF\u30A8\u30EA (\u82F1: recursive query) \u3082\u3057\u304F\u306F \u968E\u5C64\u30AF\u30A8\u30EA (\u82F1: hierarchical query) \u306F\u3001\u518D\u5E30\u7684\u306A\u554F\u3044\u5408\u308F\u305B\u3092\u884C\u3046 SELECT \u30B9\u30C6\u30FC\u30C8\u30E1\u30F3\u30C8\u3067\u3042\u308B\u3002\u968E\u5C64\u69CB\u9020\u3092\u6301\u3064\u30C7\u30FC\u30BF\u306A\u3069\u306B\u4F7F\u3046\u3002"@ja .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://www.w3.org/2002/07/owl#sameAs>	<http://ja.dbpedia.org/resource/\u518D\u5E30\u30AF\u30A8\u30EA> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/MariaDB> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Category:Recursion> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://www.w3.org/1999/02/22-rdf-syntax-ns#type>	<http://dbpedia.org/ontology/ProgrammingLanguage> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Oracle_Database> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://purl.org/linguistics/gold/hypernym>	<http://dbpedia.org/resource/Query> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://purl.org/dc/terms/subject>	<http://dbpedia.org/resource/Category:Recursion> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/H2_(DBMS)> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://www.w3.org/2000/01/rdf-schema#comment>	"Em banco de dados SQL, Common table expression (CTE) \u00E9 uma alternativa a subquerys, views, e fun\u00E7\u00F5es definidas pelo usu\u00E1rio. CTE \u00E9 ent\u00E3o um conjunto nomeado e tempor\u00E1rio de resultados, derivado de uma consulta simples e definido sob o escopo de execu\u00E7\u00E3o de uma declara\u00E7\u00E3o SELECT, INSERT, UPDATE, ou DELETE."@pt .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://www.w3.org/2000/01/rdf-schema#comment>	"\u0418\u0435\u0440\u0430\u0440\u0445\u0438\u0447\u0435\u0441\u043A\u0438\u0439 \u0437\u0430\u043F\u0440\u043E\u0441 - \u044D\u0442\u043E \u0442\u0438\u043F \u0437\u0430\u043F\u0440\u043E\u0441\u0430 SQL, \u043A\u043E\u0442\u043E\u0440\u044B\u0439 \u043E\u0431\u0440\u0430\u0431\u0430\u0442\u044B\u0432\u0430\u0435\u0442 \u0434\u0430\u043D\u043D\u044B\u0435 \u0438\u0435\u0440\u0430\u0440\u0445\u0438\u0447\u0435\u0441\u043A\u043E\u0439 \u043C\u043E\u0434\u0435\u043B\u0438. \u041E\u043D\u0438 \u044F\u0432\u043B\u044F\u044E\u0442\u0441\u044F \u0447\u0430\u0441\u0442\u043D\u044B\u043C\u0438 \u0441\u043B\u0443\u0447\u0430\u044F\u043C\u0438 \u0431\u043E\u043B\u0435\u0435 \u043E\u0431\u0449\u0438\u0445 \u0440\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u044B\u0445 \u0437\u0430\u043F\u0440\u043E\u0441\u043E\u0432 \u0441 \u0444\u0438\u043A\u0441\u0438\u0440\u043E\u0432\u0430\u043D\u043D\u043E\u0439 \u0442\u043E\u0447\u043A\u043E\u0439, \u043A\u043E\u0442\u043E\u0440\u044B\u0435 \u0432\u044B\u0447\u0438\u0441\u043B\u044F\u044E\u0442 \u0442\u0440\u0430\u043D\u0437\u0438\u0442\u0438\u0432\u043D\u044B\u0435 \u0437\u0430\u043C\u044B\u043A\u0430\u043D\u0438\u044F. \u0411\u0435\u0437 \u043E\u0431\u0449\u0438\u0445 \u0442\u0430\u0431\u043B\u0438\u0447\u043D\u044B\u0445 \u0432\u044B\u0440\u0430\u0436\u0435\u043D\u0438\u0439 \u0438\u043B\u0438 \u043F\u0440\u0435\u0434\u043B\u043E\u0436\u0435\u043D\u0438\u0439 \u043F\u0440\u0438\u0441\u043E\u0435\u0434\u0438\u043D\u0435\u043D\u0438\u044F \u043C\u043E\u0436\u043D\u043E \u0432\u044B\u043F\u043E\u043B\u043D\u044F\u0442\u044C \u0438\u0435\u0440\u0430\u0440\u0445\u0438\u0447\u0435\u0441\u043A\u0438\u0435 \u0437\u0430\u043F\u0440\u043E\u0441\u044B \u0441 \u043F\u043E\u043C\u043E\u0449\u044C\u044E \u043F\u043E\u043B\u044C\u0437\u043E\u0432\u0430\u0442\u0435\u043B\u044C\u0441\u043A\u0438\u0445 \u0440\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u044B\u0445 \u0444\u0443\u043D\u043A\u0446\u0438\u0439."@ru .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://purl.org/dc/terms/subject>	<http://dbpedia.org/resource/Category:Database_management_systems> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://www.w3.org/2000/01/rdf-schema#comment>	"A hierarchical query is a type of SQL query that handles hierarchical model data. They are special cases of more general recursive fixpoint queries, which compute transitive closures. In standard SQL:1999 hierarchical queries are implemented by way of recursive (CTEs). Unlike Oracle's earlier , recursive CTEs were designed with fixpoint semantics from the beginning. Recursive CTEs from the standard were relatively close to the existing implementation in IBM DB2 version 2. Recursive CTEs are also supported by Microsoft SQL Server (since SQL Server 2008 R2), Firebird 2.1, PostgreSQL 8.4+, SQLite 3.8.3+, IBM Informix version 11.50+, CUBRID, MariaDB 10.2+ and MySQL 8.0.1+. Tableau has documentation describing how CTEs can be used. TIBCO Spotfire does not support CTEs, while Oracle 11g Release"@en .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Reachability> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/abstract>	"\u0418\u0435\u0440\u0430\u0440\u0445\u0438\u0447\u0435\u0441\u043A\u0438\u0439 \u0437\u0430\u043F\u0440\u043E\u0441 - \u044D\u0442\u043E \u0442\u0438\u043F \u0437\u0430\u043F\u0440\u043E\u0441\u0430 SQL, \u043A\u043E\u0442\u043E\u0440\u044B\u0439 \u043E\u0431\u0440\u0430\u0431\u0430\u0442\u044B\u0432\u0430\u0435\u0442 \u0434\u0430\u043D\u043D\u044B\u0435 \u0438\u0435\u0440\u0430\u0440\u0445\u0438\u0447\u0435\u0441\u043A\u043E\u0439 \u043C\u043E\u0434\u0435\u043B\u0438. \u041E\u043D\u0438 \u044F\u0432\u043B\u044F\u044E\u0442\u0441\u044F \u0447\u0430\u0441\u0442\u043D\u044B\u043C\u0438 \u0441\u043B\u0443\u0447\u0430\u044F\u043C\u0438 \u0431\u043E\u043B\u0435\u0435 \u043E\u0431\u0449\u0438\u0445 \u0440\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u044B\u0445 \u0437\u0430\u043F\u0440\u043E\u0441\u043E\u0432 \u0441 \u0444\u0438\u043A\u0441\u0438\u0440\u043E\u0432\u0430\u043D\u043D\u043E\u0439 \u0442\u043E\u0447\u043A\u043E\u0439, \u043A\u043E\u0442\u043E\u0440\u044B\u0435 \u0432\u044B\u0447\u0438\u0441\u043B\u044F\u044E\u0442 \u0442\u0440\u0430\u043D\u0437\u0438\u0442\u0438\u0432\u043D\u044B\u0435 \u0437\u0430\u043C\u044B\u043A\u0430\u043D\u0438\u044F. \u0412 \u0441\u0442\u0430\u043D\u0434\u0430\u0440\u0442\u043D\u043E\u043C SQL: 1999 \u0438\u0435\u0440\u0430\u0440\u0445\u0438\u0447\u0435\u0441\u043A\u0438\u0435 \u0437\u0430\u043F\u0440\u043E\u0441\u044B \u0440\u0435\u0430\u043B\u0438\u0437\u0443\u044E\u0442\u0441\u044F \u0441 \u043F\u043E\u043C\u043E\u0449\u044C\u044E \u0440\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u044B\u0445 \u043E\u0431\u0449\u0438\u0445 \u0442\u0430\u0431\u043B\u0438\u0447\u043D\u044B\u0445 \u0432\u044B\u0440\u0430\u0436\u0435\u043D\u0438\u0439 (CTE). \u0412 \u043E\u0442\u043B\u0438\u0447\u0438\u0435 \u043E\u0442 \u0431\u043E\u043B\u0435\u0435 \u0440\u0430\u043D\u043D\u0435\u0433\u043E \u043F\u0440\u0435\u0434\u043B\u043E\u0436\u0435\u043D\u0438\u044F Oracle \u043E \u043F\u043E\u0434\u043A\u043B\u044E\u0447\u0435\u043D\u0438\u0438, \u0440\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u044B\u0435 CTE \u0431\u044B\u043B\u0438 \u0441\u043F\u0440\u043E\u0435\u043A\u0442\u0438\u0440\u043E\u0432\u0430\u043D\u044B \u0441 \u0441\u0435\u043C\u0430\u043D\u0442\u0438\u043A\u043E\u0439 \u0444\u0438\u043A\u0441\u0438\u0440\u043E\u0432\u0430\u043D\u043D\u043E\u0439 \u0442\u043E\u0447\u043A\u0438 \u0441 \u0441\u0430\u043C\u043E\u0433\u043E \u043D\u0430\u0447\u0430\u043B\u0430. \u0420\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u044B\u0435 CTE \u0438\u0437 \u0441\u0442\u0430\u043D\u0434\u0430\u0440\u0442\u0430 \u0431\u044B\u043B\u0438 \u043E\u0442\u043D\u043E\u0441\u0438\u0442\u0435\u043B\u044C\u043D\u043E \u0431\u043B\u0438\u0437\u043A\u0438 \u043A \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u044E\u0449\u0435\u0439 \u0440\u0435\u0430\u043B\u0438\u0437\u0430\u0446\u0438\u0438 \u0432 IBM DB2 \u0432\u0435\u0440\u0441\u0438\u0438 2. \u0420\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u044B\u0435 CTE \u0442\u0430\u043A\u0436\u0435 \u043F\u043E\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u044E\u0442\u0441\u044F Microsoft SQL Server (\u043D\u0430\u0447\u0438\u043D\u0430\u044F \u0441 SQL Server 2008 R2), Firebird 2.1, PostgreSQL 8.4+, SQLite 3.8.3+, IBM Informix \u0432\u0435\u0440\u0441\u0438\u0438 11.50+, CUBRID \u0438 MySQL 8.0.1+. Tableau \u0438 TIBCO Spotfire \u043D\u0435 \u043F\u043E\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u044E\u0442 CTE, \u0432 \u0442\u043E \u0432\u0440\u0435\u043C\u044F \u043A\u0430\u043A \u0432 \u0440\u0435\u0430\u043B\u0438\u0437\u0430\u0446\u0438\u0438 Oracle 11g Release 2 \u043E\u0442\u0441\u0443\u0442\u0441\u0442\u0432\u0443\u0435\u0442 \u0441\u0435\u043C\u0430\u043D\u0442\u0438\u043A\u0430 \u0442\u043E\u0447\u0435\u043A \u0444\u0438\u043A\u0441\u0430\u0446\u0438\u0438. \u0411\u0435\u0437 \u043E\u0431\u0449\u0438\u0445 \u0442\u0430\u0431\u043B\u0438\u0447\u043D\u044B\u0445 \u0432\u044B\u0440\u0430\u0436\u0435\u043D\u0438\u0439 \u0438\u043B\u0438 \u043F\u0440\u0435\u0434\u043B\u043E\u0436\u0435\u043D\u0438\u0439 \u043F\u0440\u0438\u0441\u043E\u0435\u0434\u0438\u043D\u0435\u043D\u0438\u044F \u043C\u043E\u0436\u043D\u043E \u0432\u044B\u043F\u043E\u043B\u043D\u044F\u0442\u044C \u0438\u0435\u0440\u0430\u0440\u0445\u0438\u0447\u0435\u0441\u043A\u0438\u0435 \u0437\u0430\u043F\u0440\u043E\u0441\u044B \u0441 \u043F\u043E\u043C\u043E\u0449\u044C\u044E \u043F\u043E\u043B\u044C\u0437\u043E\u0432\u0430\u0442\u0435\u043B\u044C\u0441\u043A\u0438\u0445 \u0440\u0435\u043A\u0443\u0440\u0441\u0438\u0432\u043D\u044B\u0445 \u0444\u0443\u043D\u043A\u0446\u0438\u0439."@ru .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Firebird_(database_server)> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/BigQuery> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Select_(SQL)> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Category:SQL> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Category:Database_management_systems> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://www.w3.org/ns/prov#wasDerivedFrom>	<http://en.wikipedia.org/wiki/Hierarchical_and_recursive_queries_in_SQL?oldid=1094019376&ns=0> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/Tree_structure> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://purl.org/dc/terms/subject>	<http://dbpedia.org/resource/Category:SQL> .
<http://dbpedia.org/resource/Hierarchical_and_recursive_queries_in_SQL>	<http://dbpedia.org/ontology/wikiPageWikiLink>	<http://dbpedia.org/resource/SQL> .