According to the SQL Standard, the method to evaluate hierarchical or bi-directional data is the Recursive Common Table Expression (RCTE).
根据SQL标准,评估分层或双向数据的方法为递归通用表表达式(RCTE)。
The most common reason is the need to feed legacy SQL applications, packaged business applications and business intelligence (BI) tools that consume only relational data.
最常见的原因是需要向仅使用关系数据的遗留 SQL 应用程序、打包业务应用程序和商业智能 (BI) 工具馈送数据。
If you want to use standard SQL and BI reporting tools, pick shred.
如果想使用标准的SQL和BI报告工具,选择分解。
应用推荐