First he looks at the underlying database summary table.
他首先查看底层数据库汇总表。
Listing 3 shows a simple example of creating a summary table.
清单3展示了一个简单的创建总结表的例子。
Course tuition fees are shown in the Degree Summary Table.
学费纵览表中的学科学费。
Another query against the summary table returns no data as well.
再次查询总结表,仍然没有返回任何数据。
Listing 4 shows an example of using a staging table with a summary table.
清单4展示了一个使用有关联总结表的staging表的例子。
A summary table is a table whose definition is based on a result of a query.
汇总表是指其定义基于查询结果的表。
Not unexpectedly, a query against the summary table at this point returns no data.
不出所料,此时对总结表的查询没有返回任何数据。
That way you never have to worry about building the summary table again and again.
这样,您不必担心需要反复构建汇总表。
The summary table at the top of the pyramid is small, so queries on it are very fast.
金字塔顶端的汇总表比较小,因此对它的查询非常快。
Also, the monthly summary table can help us analyses IQC system and find out the reasons of failure.
月汇总表,可帮助实验室人员分析IQC情况,查找失控原因。
In addition to a summary table some specific examples are given of questions and the results they produced.
除了综述表格外,还给出了问题及其产生的后果的一些具体例子。
From the summary table, they can then pick the dimensions that they want to drill down into and see more detail.
从汇总表,他们可以选择打算进一步向下挖掘查看更多细节的维度。
The summary table, which is named EMP_SUMMARY, is based on the underlying table EMPLOYEE in the SAMPLE database.
总结表名为EMP _ SUMMARY,它基于SAMPLE数据库中的底层表employee。
The initial layout of the summary table can be customized through configuration, and in runtime through filtering.
初步的布局汇总表中可以自订通过的配置,并在运行时通过过滤。
We built a summary table that aggregated the income and expense detail to show the end result for each transaction.
我们构建了一个汇总表,汇总收入和费用细节,显示每笔交易的最终结果。
Ideally, the structure of the data warehouse offers a summary table for any question that business users want to ask.
理想情况下,数据仓库的结构提供一个针对业务用户想问的所有问题的汇总表。
The COUNT function is very useful to show at any level how many records make up each aggregated row in the summary table.
count函数非常有用,可以在任何级别显示汇总表中的每个汇总行由多少条记录组成。
Another way is to have the extract, transform, and load (ETL) process update the summary table as it loads the fact table.
另一种方法是使提取、转换和加载(etl)流程在加载事实表时更新汇总表。
A summary table stores data that has been aggregated in a way that answers a common (or resource-intensive) business query.
汇总表存储以回答常见(或资源密集型)业务查询的方式汇总的数据。
Finally, the staff member analyzes the metadata information about the last ETL job LOAD_SALES_SUM, populating the summary table.
最后,分析最后一个ETL作业LOAD_SALES_SUM的元数据信息,这个作业填充汇总表。
When they found issues that required more detail, they could then drill down into another summary table or the detail fact table.
当他们发现需要更多细节的问题时,他们可以向下钻取到另一个汇总表或细节事实表。
Your top-level summary table may have about 100,000 records; the next-level summary table will probably have millions of records.
顶级汇总表可能拥有约100,000条记录,下一级汇总表有可能拥有数百万条记录。
As the user drills down into more detail, each summary table contains more rows, until the user reaches the fact table (see Figure 1).
当用户向下钻取更多细节时,每个汇总表都包含更多行,直到用户到达事实表(见图1)。
Another query against the summary table returns no data, but after the REFRESH table statement executes this time, the query runs successfully.
再次查询总结表,又是没有返回数据,但是当执行了REFRESHtable语句之后,查询得以成功运行。
As such, the summary table typically contains pre-computed results based on the data existing in the table or tables that its definition is based on.
因此,汇总表通常包含基于其定义所基于的表中的现有数据的预计算结果。
As the summary table below shows, however, false negatives are far more common using distributed blacklists than with any of the other techniques I tested.
然而,正如由下面的汇总表所显示,使用分布式黑名单时发生“误否认”的频率要比其它我所测试的技术多很多。
The fullselect that is part of the definition of a summary table contains a GROUP BY clause summarizing data from the tables that are referenced in the fullselect.
fullselect是总结表定义的一部分,它包含一个GROUPBY 子句,该子句总结 fullselect 中所引用表中的数据。
Users should be able to drill down from one summary table into another summary table, ultimately arriving at the fact table (if that's the level of detail they need).
用户应该能够从一个汇总表向下深入到另一个汇总表,最终达到事实表(如果事实表是他们需要的细节级别)。
The chessboard type total bill and course summary table instead of general ledger units, closing entries, should a whole assembly course summary table and board ledger.
采用棋盘式总张账和科目汇总表代替总账的单位,年终结账,应当汇编一张全年合计的科目汇总表和棋盘式总账。
Bioburden assessment and sterility issues are also addressed, and a summary table describes adventitious agents, recommended tests, and stages at which to perform testing.
生物负载评价和无菌问题也提到了;并且有汇总表描述了偶然试剂,建议的检测和在何阶段进行检测。
应用推荐