用例5：采用使用动态sql和外部表的存储过程。
Case 5: Having stored procedure using dynamic SQL and external tables.
数据库分区技术为大表的存储管理提供了较优的解决方案。
Partition technique provides a good solution to the storage management of large tables in RDBMS.
例如，需要在创建访问一组表的存储过程之前，先创建这组表。
An example would be the need to first create the set of tables before creating the stored procedure that access them.
这意味着，即使是在用户访问表的同时，也可以改变表的存储位置。
This means that even while users are accessing a table, you can change where the table storage resides.
您在DSNDB07创建的表空间将用作处理SQL联接和排序以及临时表的存储。
Table Spaces that you create in DSNDB07 will be used as storage for processing SQL joins and sorts as well as for temporary tables.
正如你所见，NAT路由器将每台计算机的IP地址和端口号都存储在地址转换表中。
As you can see, the NAT router stores the IP address and port number of each computer in the address translation table.
实时时钟电路（X1228）被用作里程表，数据存储器和车速表中的警报。
A real-time clock circuit(X1228)is applied to be an hourmeter, data memorizer and alarm in speedometer.
由于关系数据和索引存储在表空间内不同的存储对象中，因此它们具有不同的读和写计数器。
Since relational data and indexes are stored in separate storage objects within a table space, they have separate read and write counters.
您应当创建一个或多个USER临时表空间来存储临时表的数据。
You should create one or more USER temporary table spaces for storing data of temporary tables.
为此，我们可以从xml_contents表中存储的市场营销信息XML文档中提取出数据。
For this purpose we can extract data from our Marketing Info XML documents stored in the XML_CONTENTS table.
这些目录表用于存储本文讨论的表选项、数据文件和外部列。
These catalog tables are needed to store the table options, data files, and external columns discussed in this article.
DB 2V9.5引入了XML数据的基础表行存储。
元素和属性表存储xml文档的结构容器。
The elements and attributes tables store the structural containers of the XML document.
传统上，其特点不适合表的信息存储在文件系统中。
Traditionally, information that doesn't naturally fit into tables has been stored in a file system.
于是，对于大型的表，工作负载可以分布在多个分区上，而更小的表也可以存储在一个或多个数据库分区上。
A workload can then be spread across multiple partitions for large tables, while allowing smaller tables to be stored on one or more database partitions.
可以使用系统编目视图来检索关于表空间之类的存储管理对象的信息。
You can use the system catalog views to retrieve information about storage management objects such as table Spaces.
使用对象包装器的另一个好处是，它们可以以自然的对象层次结构表达关系表中存储的数据，从而捕捉数据之间的关系。
Another benefit of having object wrappers is that they can present data stored in relational tables in a natural object hierarchy that captures the relationship between the data.
数据以熟悉的数据库方式存储，组织为表的形式。
Data is stored in a familiar database fashion, organized by tables.
可能在某些情况下，DBA必须对如何提供特定表空间的存储保持完全控制权，但在大多数情况下，数据库将从使用自动存储中受益。
There may be situations where a DBA must retain full control over how the storage for a particular table space is provided, but in most cases, databases will benefit from the use of automatic storage.
展开具有数据库名称的文件夹(在本例中是“DWESAMP”)，查看所导入的表及存储过程。
Expand the folder with the name of your database (in this case "DWESAMP") to have a look on the imported tables and the stored procedure.
这些对象是包含身份验证信息的表和封装了服务器逻辑（针对数据库表执行）的存储过程。
These objects are tables containing authentication information and stored procedures that encapsulate the server logic to operate on the database tables.
图中显示了一个档案文件表，它存储处理过的事件，还有一个事件阶段表，它存储需要再处理的事件。
The figure shows an archive table that archives processed events and an event staging table that stores events that require reprocessing.
该特性不是默认启用的，除非使用V8.2.2中新的自动存储表空间特性 ——它才是默认的。
This feature is not enabled by default unless you are using the new automatic storage table space feature in V8.2.2 - then it's the default.
清单1显示了用于创建存储表空间的命令。
Listing 1 shows you the commands to use to create automatic storage table Spaces.
DB 2LUW还会根据表空间的类型将表数据存储到文件、目录和原始设备上。
DB2 LUW also stores table data on files, directories and raw devices depending upon the type of table space.
默认表空间的容器以及已定义的其他任何表空间，都在使用的每个存储路径上自动创建。
Containers for the default table Spaces, as well as any other table Spaces that are defined, are then automatically created on each storage path used.
用户临时表空间： 用户临时表空间存储已声明的全局临时表。
User temporary table spaces: User temporary table spaces store declared global temporary tables.
分区数据库的编目表只存储在发出CREATEDATABASE命令时所在的那个分区上。
The catalog tables for partitioned databases reside only on the partition from which the CREATE database command was issued.
这个单值是转换表的定位器，存储过程用它来访问转换表的列。
This single value is a locator to the transition table, which the procedure USES to access the transition table columns.
为了利用低延时的SSD资源，还可以挑出热表，然后使用ADMIN _ TABLE _MOVE存储过程将这样的表转移到SSD存储所支持的表空间上。
To take advantage of low-latency SSD resources, you can also identify hot tables and then use the ADMIN_TABLE_ move stored procedure to move the table onto the tablespace backed with SSD storage.
应用推荐