Listing 2. XML and relational data in separate table Spaces and buffer pools.
必要时,如何将XML数据放入一个单独的表空间中?
In a nutshell, use common sense when considering separate table Spaces for XML data.
总而言之,在为XML数据选择不同的表空间时,仍应按常理来考虑。
Tip 3: Exploit storage options for XML: inlined, compressed, or a separate table space
提示3:使用XML存储选项:内联、压缩或单独的表空间
Best practice would call for the address in a separate table, contrary to what we have done here.
最佳实践不会像我们这样,将会把Address分离在一个单独的表中。
If an attribute depends on only part of a multi-valued key, then remove it to a separate table.
如果一个属性仅依赖于一个多重主键的一部分,则将该属性转移到一个单独的表中。
For example, you might have a separate table with a list of companies you're interested in tracking.
例如,您可能有一个单独的表,其中列出您想要追踪的公司。
I store the generated words in a separate table so that I can retrieve and display them at every generation.
我将生成的单词存储在一个单独的表中,这样我就可以在每一次衍生中获取并显示它们。
Create a separate table for attachments where each field is an "attachment" containing a single item only.
创建附件的一个单独的表,其中每个字段包含一个单一的项目只是一个“附件”。
A Drupal content module typically extends the standard Drupal node with supplemental fields stored in a separate table.
Drupal内容模块通常扩展标准Drupal节点,将补充字段存储在一个单独的表中。
Moving rolled out data to another location (that is, to a separate table or database) rather than simply deleting it.
将转出的数据移动到另外一个位置(也就是说移动到一个表或数据库中),而不仅仅是删除它。
In this step you also split all the test cases from the matrix shown in table 4, creating a separate table for each test case.
在这个步骤中你同样把所有来自表格4中矩阵图的测试用例分割开来,针对每个测试用例分别形成表格。
The purpose is to store the book authors in a separate table by extracting the data from the XML documents in the bookstore table.
目的是通过从书店表的XML文档提取数据以将书的作者信息存储到单独的一个表内。
For example, if you set this option to 2, you will have two db2bm processes that can each read two separate table Spaces in parallel.
例如,如果将此选项设置为2,那么将会有两个db 2bm进程,每个进程并行地读取两个不同的表空间。
We recommend to put these audit tables in a separate table space and to archive those data regularly using general database methods.
我们建议把这些审计表放在单独的表空间中,定期使用一般的数据库方法存档这些数据。
It is advisable to eat after or at separate table with your employer. Ask for permission whenever you want to eat supper or snacks.
你应该与雇主分开进食或于雇主用饭后才进食。当你需要额外食物或零食,必须得到雇主的同意。
You then have a separate table for ProfileUpdateEvents where you store an immutable event for every update with an associated time stamp.
然后,您会拥有适用于ProfileUpdateEvent(其中使用相关的时间戳为每次更新存储了一个不变事件)的单独表。
Since your columns are obviously big, they are going to be TOASTed, meaning they are compressed and stored out-of-line in a separate table.
因为你列显然是大,他们要烤,这意味着他们是压缩和超行存储在一个单独的表中。
Custom notes can be attached to each contact record. As before these are stored in a separate table and are related based on the contact ID.
可以为每个联系人记录附加自定义注释。这些注释被存储在一个单独的表中,根据相关的联系人ID查询。
Make a separate table for each set of related attributes, and give each table a primary key. Each field contains at most one value from its attribute domain.
为每个相关属性的集合创建一个单独的表,并为每个表指定一个主键。每列最多包含一个来自其属性域的值。
This requires either extra fields in the relational table to store Notes header information or a separate table that’s related to the data table with key fields. .
这或者需要关系表中的一个额外字段来存储Notes头部信息,或者需要一个与具有关键字段的数据表相关的单独的表。
By default all the different IBM TSOM tables are created in the default table space, so you should use a separate table space for event data and event table indexes.
默认情况下,不同的IBMtsom表是在默认表空间创建的,所以您应该使用另一个表空间来存储事件数据和事件表索引。
The main idea is to intercept any change that appears in the WIP, and keep that information in a separate table, called WIP_FULL_ARCHIVE. That table contains a copy of
主要思想是截获WIP中出现的任何更改,并将该信息保存在单独的名为 WIP_FULL_ARCHIVE 的表中。
Inlined XML data always resides in the same table space as the relational columns of the table and cannot be stored on a different page size or in a separate table space.
内联的XML数据始终和表的关系列位于同一个表空间中,并且不能存储到不同的页宽或单独的表空间。
You should create an index in a separate table space so that if something goes wrong with the index table space, you can easily drop it and then recreate the same indexes.
您应该在单独的一个表空间上创建索引,这样如果索引表空间出现问题,您可以直接删除该表空间,然后重要创建相同的索引。
To continue to take advantage of the flexibility of Ruby on Rails migrations, without giving up the power that comes with XML, let's create a separate table to store XML data.
为了继续利用Rubyon Rails迁移的灵活性,同时保持XML的强大功能,我们要创建一个单独的表来存储XML数据。
If attributes do not contribute to a description of the key, then remove them to a separate table. All attributes must be directly dependent on the primary key. (Read more here).
如果一些属性跟主键扯不上关系,则将这些属性转移到一个单独的表中。所有属性必须直接依赖于主键(查看更多)。
If you have done a performance analysis and find that you need a large page size for XML data but a small page size for relational data or indexes, you can use separate table Spaces to achieve this.
如果您做了性能分析,发现对于XML数据需要大的页宽,而对于关系数据或索引则需要小的页宽,那么可以使用不同的表空间来实现这一点。
To isolate objects in different buffer pools, you can create more than one table space in the same database, and associate each table space with separate buffer pools.
为了在不同缓冲池中隔离对象,您可以在同一个数据库中创建一个以上的表空间,并给每一个表空间关联不同的缓冲池。
If the SQL table was a partitioned table, each partition (member) could have a separate media preference.
如果sql表是一个分区表,每个分区(成员)都可以有一个单独的媒介首选项。
If the SQL table was a partitioned table, each partition (member) could have a separate media preference.
如果sql表是一个分区表,每个分区(成员)都可以有一个单独的媒介首选项。
应用推荐