Does this resemble a Star schema?
这与星型模式相似吗？
Listing 9 shows the same query for the refined star schema.
清单9展示了用于改进的星型模式的同样的查询。
The advantages of this refined star schema are as follows
这种改进模式的优点有
Figure 7 illustrates the star schema in the relational database.
图7描述了关系数据库中的星型模式。
Figure 2 illustrates the star schema in the relational database.
图2演示了关系数据库中的星形模式。
Columns in the join clauses in fact table of star schema database.
星型数据库的事实表中join子句中的列。
Star schema has become a common term used to refer to a dimensional model.
星型模式已经成为一个公共术语，用于表示维度模型。
This is a star schema consisting of a fact table and four dimension tables.
这是一个星型模式，由一个事实表和4个维表组成。
Let's assume the following indexes and distribution on this star schema database.
我们假设这个星型模式数据库上具有以下索引和分布。
Finally, it proposes the basic steps to constructs hierarchy in star schema.
文章最后提出了在星型模型中构造维的层次结构的基本过程。
The service consumer creates an inventory request document according to the STAR schema.
服务消费者根据STAR模式创建目录请求文档。
In the initial star schema above, the fact table contains one row for each keyword occurrence.
在前面的初始星型模式中，对于每次的关键词的出现，事实表都包含一行。
However, we want to spend a bit more time on star schema optimizer support, which is an offshoot of XPS.
然而，我们需要花点时间在星型模式优化器支持上，这是XPS的一个分支。
Choose the simpler star schema if you prefer a model where each fact table rows represents a keyword in a document.
如果希望每个事实表行表示一个文档中的一个关键词，那么选择更简单的星型模式。
A sample stored procedure that shreds MIML data into the refined star schema (Figure 8) is attached to this article.
本文附带了一个示例存储过程，该存储过程将MIML数据分解到改进的星型模式中(图8)。
But the corrective and natural changing of dimensional tables based on star schema make the aggregate data false.
但是，基于星型模型的数据仓库中的维表的纠错改变和自然改变将会引发概括数据的不正确问题。
Using a typical star schema database design, a fact table might contain sales data by product, region, and time period.
按照典型的星型数据库设计，一个事实表包含按产品、地区和时间段排序的销售数据。
Database designers have long used the term "star schema" to describe dimensional models because the resulting structure looks like a star.
数据库设计师长期使用术语“星型模式”来描述维度模型，因为结果结构看上去像一个星星。
Using these tools, you can either set up the database outline manually or derive this metadata from the data in a relational star schema.
使用这些工具，您既可以手动设定数据库概述又可以从一个关系星图解的数据中获取此变数据。
Over the years, I have built up a midsize data warehouse star schema that I use for testing new releases of Informix, and I used it for this benchmark.
多年来，我创建了一个用于测试informix新版本的中型数据仓库星型架构，并将它用于标准程序测试。
The diagram shows a simple star schema design with one fact table in the middle and its related dimensions, in this case, promotions, products, and time.
本图是简单星型模型设计图，中间是一张事实表，还有其相关维度，本例中是促销活动、产品、时间。
In this comparison, it is important to note that the approach with the refined star schema converts only a subset of the MIML data into relational format.
在这个比较中，注意使用改进的星型模式的方法只是将一部分MIML数据转换成关系格式。
IWA technology loads the records from a data warehouse star schema into memory in a compressed format, and organizes the data using new columnar storage technology.
IWA技术以压缩格式将数据仓库星型架构中的记录载入内存，并使用新的列存储技术来组织数据。
A database must be designed using a dimensional model star schema to work with IWA, and the tables must be defined and loaded into IWA to take advantage of its performance.
设计数据库时必须将维度模式星型架构与IWA相结合，必须定义表格并将它们载入IWA中，以充分利用IWA的性能。
In addition, by using an industry standard "star schema", rather than a more normalized table structure, the data warehouse is optimized for efficient queries and quick response times.
此外，通过使用行业标准的“星型模式”(star schema)而不是更规范化的表结构，数据仓库经过了优化以实现高效的查询和快速的响应时间。
When your enterprise data is consolidated and structured according to the industry standard star schema design, reporting on the data is easier to accomplish and performance is usually much better.
当企业数据根据行业标准星型架构设计进行合并和结构化时，基于数据进行报告更容易实现，性能通常也更好。
The optimizer can choose a star join plan only if a query involves tables from a star or snowflake schema that meets the following requirements.
只有查询中包含满足以下要求的星型或雪花模式的表时，优化器才可以选择星型连接计划。
It has a star or snowflake-like dimensional database schema design.
它具有星形或雪花形的维数据库模式设计。
Star join supports snowflake schema as well.
星型连接也支持雪花模式。
The cube model can be seen as an abstraction of a star-join or snowflake-join schema.
多维数据集模型可以看作星形联结或雪花形联结模式的抽象。
应用推荐