oracle 视图和网络流量 [英] oracle views and network traffic

问题描述

我真的无法理解 Oracle E-商务套件开发者指南的意思.使用视图时，网络流量被最小化，因为所有外键都是在服务器上非规范化."

I cant really understand what this line from the Oracle E-Business Suite Developer's Guide means. When using views, "network traffic is minimized because all foreign keys are denormalized on the server."

当解析与视图关联的查询时，有人可以说明一下吗?
与视图关联的查询是否已被解析?

Could anyone please throw some light on when a query, associated with a view is parsed?
Is a query associated with a view is already parsed?

我找不到答案.请提供任何有用的 oracle 文档链接.

I cant find the answers. Please provide any oracle documentation links that would be helpful.

推荐答案

这句话是在谈论电子商务套件，特别是如何以高性能的方式构建 EBS(即表单)应用程序.相关的上下文是这样的:

The quote is talking about E-Business Suite, and specifically, how to build EBS (i.e. Forms) applications in a performant fashion. The pertinent context is this:

一般来说，复杂块基于视图，而简单设置块基于表."

"In general, complex blocks are based on views while simple setup blocks are based on tables."

以这个场景为例:我们有一个包含很多列的表，其中三个是查找表的外键.我们想在一个表单中显示这个表中的数据.为了用户友好，我们的表单需要显示查找表中的含义，而不是主表中的代码.执行连接到引用表的单个查询比发出四个查询更有效.因为网络流量等方面的考虑.

Take this scenario: we have a table with many columns, including three which are foreign keys to lookup tables. We want to display data from this table in a Form. To be user-friendly our Form needs to show the meanings from the lookup tables not the codes from the main table. It is more efficient to execute a single query joining to the reference tables than to issue four queries. Because network traffic, and other considerations.

因此，我们应该在连接所有四个表的视图上构建表单的数据块，而不是仅在主表上构建它并使用 Post-Query 触发器发出三个单独的查询来检索代码的描述.这与多行块尤其相关:我们绝对希望避免为每个返回的记录发出多个查询.

So we should build the Form's data block on a view which joins all four tables, rather than building it just on the main table and using Post-Query triggers to issue three separate queries which retrieve the codes' descriptions. This is especially relevant with multi-row blocks: we definitely want to avoid issuing several queries for each record returned.

虽然引用的上下文是 Oracle Forms，但它与大多数数据检索应用程序相关.尽管我怀疑现在使用引用游标来传递结果集是比使用视图更流行的解决方案.

Although the context for the quote is Oracle Forms, the point pertinent for most data retrieval applications. Although I suspect these days using a ref cursor to pass a result set is a more popular solution than using views.

tl;dr

这是关于应用程序设计而非数据库优化的声明

It is a statement about application design not database optimization

这篇关于oracle 视图和网络流量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！