The following script can be edited and run on your warehouse database to generate a script to enable row compression across all AW created fact tables.
以下脚本可被编辑并在您的数据仓库数据库上运行，来生成一个脚本跨所有AW创建的事实表启动行压缩。
If the query was written by adding a dimension followed by a fact and then another dimension, then the database optimization would include the materialization as necessary.
如果查询的创建是通过先添加维度再添加事实表然后又添加维度的方式构成，那么数据库优化则必须包含实体化。
Using a typical star schema database design, a fact table might contain sales data by product, region, and time period.
按照典型的星型数据库设计，一个事实表包含按产品、地区和时间段排序的销售数据。
This is, in fact, a standard best practice if you want to perform consistent backups over a database using LVM snapshots.
实际上，如果希望对数据库执行一致的备份，那么使用LVM快照是标准的最佳实践。
The previous example only contained a measure that was taken from one fact table in the underlying database.
前面的例子只包含了一个来自底层数据库事实表的一个度量指标。
Another side effect to this scenario is that any form of materialization (pre-calculated aggregates) in the database may be ignored since no fact is included in the query.
此场景的另一个副作用是数据库中的任何形式的实体化(预计算聚合)可能会被忽略，因为查询中不包含任何事实。
In this case the fact that we could grab the records from the database really doesn't matter, since what we would be testing is our ability to sort the records coming back.
在这种情况下，我们的问题不在于是否能够从数据库获取这些记录，因为我们想要测试的是我们是否能够对返回的记录进行排序。
This step is in fact similar, with the only difference being that it is done on the client side instead of the database engine, and thus using different APIs.
这个步骤确实是相似的，惟一的差异是它在客户端上而不是数据库引擎中执行，因此使用不同的API。
Plus, the fact that the infrastructure is still relational allows the XML data to leverage the proven capabilities of the relational database like triggers, constraints, and foreign key relationships.
另外，基础结构仍然是关系型的，这使XML数据能够利用关系数据库的实用功能，比如触发器、约束和外键关系。
One of them is the fact that you only need to pass the parameter to the database server, and you get the result back. You don't need to pass the entire SQL statement itself.
其中一条就是您仅需向数据库服务器传递参数，然后即可获得返回结果，而不必传递整个sql语句。
For example, consider the fact that every move, item attribute, and character attribute is often kept as a data element within a database.
例如，玩家的每次移动、物品属性和人物属性常常需要记录在数据库中。
The fact that a DB2 UDB SAMPLE database is used by the server is unknown to this client (and the client doesn't require the DB2 client drivers installed to work).
对于该客户机来说，它不知道该服务器使用DB 2UDBSAMPLE数据库这个事实(并且，该客户机不要求安装DB 2客户机驱动程序)。
STEP A: We assume you have created a database with the default table spaces. Create the fact and dimension tables as follows.
第 1 步：我们假设已经用默认表空间创建了一个数据库，同时创建下面的事实表和维度表。
To implement a fake fact query subject, either create a one row table in the database or use a virtual table such as SYSDUMMY1 for DB2 or Dual for Oracle.
要实现伪事实查询主题，就要在数据库中创建一个一行的表格，或者使用虚拟表，例如SYSDUMMY1在DB 2中使用SYSDUMMY1，或者在Oracle中使用Dual。
The cube models for [HistoricSales] and [CurrentMonthSales] use their respective fact views instead of database tables.
[HistoricSales]和[CurrentMonthSales]的数据集模型分别使用各自的事实视图，而不是数据库表。
Another common problem with allocating database Shared memory on Solaris is due to the fact that all pages of a Shared memory segment are pinned in physical RAM.
Solaris中另一个与分配数据库共享内存有关的常见问题是由于这样的一个事实导致的，即共享内存段的所有页都是固定在物理ram中的。
Columns in the join clauses in fact table of star schema database.
星型数据库的事实表中join子句中的列。
The Local transaction model gets its name from the fact that transactions are managed by the underlying database resource manager, not the container or framework your application is running in.
在LocalTransaction模型中，事务由底层数据库资源管理程序(而非应用程序所在的容器或框架)管理，这便是它得名的原因。
Connect to database GBPM4ETL and run script GBPM4ET.sql to create the dimension tables and fact table, as illustrated in Figure 10.
连接数据库GBPM 4etl，运行脚本GBPM 4et . sql以创建维度表和事实表，如图10所示。
Due to the fact that there are multiple hops to get to the target database, it is possible that there might be some performance degradation.
由于到达目标数据库之前有多个跃点（hop），所以性能可能会有一些下降。
Escaping special characters tells your database that the characters provided in the query are in fact data, not code.
转义特殊的字符会告诉数据库，查询中提供的字符实际上是数据，而不是代码。
In fact, you are using an embedded version of the database.
实际上，使用的是数据库的嵌入式版本。
In fact, there are no tables, rows, columns or relationships in a document-oriented database at all.
事实上，面向文档的数据库中根本不存在表、行、列或关系。
Such a polarization is quite powerful considering the fact that you might have multiple applications trying to interact with the same database.
如果考虑到有多个应用程序都将与同一个数据库进行交互，您就会发现这种分化是非常强大的。
In fact, most servers ended up being used as single-purpose machines that ran a single software application or database.
事实上，大多数服务器最终只能被用作于运行单一软件应用程序或数据库的单一用途的机器。
This reflects the fact that in a relational database, 1 to 0..
这反映这样的事实：在关系数据库中，1与0 . .。
The following steps will illustrate how to build a simple multi-fact model that incorporates a manually created time dimension based on a time dimension table found in the underlying database.
下面的步骤将介绍如何创建一个简单的多事实模型，其中包括一个基于底层数据库的时间维度表手动创建的时间维度。
In fact, the tool will assume that any containers that were located under the old database path are moving to the new path, so you don't need to list them either.
事实上，该工具将假定位于原数据库目录下的所有容器都移动到了新的路径下，因此也不需要列出新路径。
Notice that the flows for the database and queue storage types use custom mediation primitives to record only the fact that the request has arrived.
注意，数据库和队列存储类型的流使用自定义中介原语来记录请求到达的事实。
To do that, I can take advantage of the fact that PHP is an interpreted language by storing PHP code in a queue in the database, then executing it later.
为此，可以利用一个事实：PHP是一种解释型语言。可以将PHP代码存储在数据库中的队列中，以后再执行它。
应用推荐