Table data skew refers to a difference between the number of records in a table on particular database partitions and the average number of records across all database partitions for this table.
表数据倾斜指的是特定的一些数据库分区上的某个表内的记录数与这个表所跨的所有数据库分区的平均记录数之间的差额。
They allow you to assign the location of the database and table data directly onto containers.
它允许您直接将数据库和表数据的位置分配到容器上。
Now we must create the table structure in the database, which also wipes out the existing tables and data (if there's any) and start from scratch.
现在我们必须在数据库中创建表结构,这也会清除现有表和数据(如果有的话),并从头开始。
Add a new database and table with data in it to test your server's setup.
添加一个新数据库和表,其中带有用来测试服务器的设置的数据。
You will now create a sample database and a sample table that contains the user data.
您将创建一个样本数据库以及一个包含用户数据的样本表格。
Using a typical star schema database design, a fact table might contain sales data by product, region, and time period.
按照典型的星型数据库设计,一个事实表包含按产品、地区和时间段排序的销售数据。
We recommend to put these audit tables in a separate table space and to archive those data regularly using general database methods.
我们建议把这些审计表放在单独的表空间中,定期使用一般的数据库方法存档这些数据。
You can refer to the Data Definition Language (DDL) statements in Listing 1 to create the database and table for the sample application.
您可以参考清单1中的数据定义语言(DDL)语句,为样例应用程序创建数据库和表。
We are now ready to export the data from the NEWSTAFF table, and to simultaneously capture a database lock snapshot.
现在我们已经准备就绪,可以从newstaff表导出数据,并同步捕获数据库锁快照了。
Technical metadata includes host server, database type, database schemas, table name, column names, and data types, all of which are described in technical detail.
技术元数据包括主机服务器、数据库类型、数据库模式、表名、列名和数据类型,这些都是在技术数据中描述的。
Create the required database table and fill it with data.
创建所需的数据库表并为其填充数据。
Other table spaces for user, temporary and index data need to be created after the database has been created, and a user needs to be assigned to these table spaces before they can be used.
其他用于用户数据、临时数据和索引数据的表空间则需要在创建数据库之后另行创建,并且在使用这些表空间之前,还需要为之指定一个用户。
Unlike XML-only databases, DB2 V9 also provides seamless integration of relational data and XML data within a single database, even within a single row of a table.
与仅使用XML 的数据库不同,DB2V9还提供了关系型数据与 XML 数据在数据库中的无缝集成 ——甚至是表的某一行中的集成。
This implicit association avoids database table joins and extra selections, and cuts down data transfer size.
这种隐式关联避免了数据库表连接和额外的字段选择,降低了数据传输的大小。
DB2 is now a hybrid database in that it has the ability to store relational data and XML data in a single database, even in a single table.
现在的DB 2是一个混合型的数据库,因为它能够在一个数据库,甚至是一个表中储存关系数据和XML数据。
Loop through the data records in the arrays, and change the values as needed, then write the data back to the original database and table.
循环遍历数组中的数据记录并根据需要修改,然后把数据写回原来的数据库和表中。
Because customers use different as well as unexpected amounts of data, table space sizes can vary significantly, affecting database sizing and planning considerations.
由于客户使用的数据量各不相同而且大小不定,所以表空间变化很大,会影响数据大小调整和规划方面的考虑。
Moving data between a database and a message — an application may need to move data from a JMS message to a database table or vise versa.
在数据库和消息之间移动数据——应用程序需要将数据从JMS消息移动到数据库表,或者相反。
Using database partition groups and tablespaces, a user can determine across which and how many database partitions their table data is to be spread.
用户可以通过使用数据库分区组和表空间,来确定将表数据分布到哪些数据库分区上。
A form is bound to a specified database table and all data controls within can be used to display and edit the table's columns without writing code or SQL.
表单被绑定到指定的数据库表,其中的所有数据控件都可以用于显示和编辑表的列,无需编写代码或SQL。
The main advantage of the XML support in the relational database is that you can save both relational and XML data in the same table.
关系数据库中的XML支持的主要好处是,可以在同一个表中同时存储关系数据和XML数据。
The underlying data will be stored in a database table with a relational ID column and an XML column where the actual store location data will be held.
底层数据存储在数据库表中,表中有一个关系ID列和一个XML 列,XML 列用于存储实际的商店数据。
A map specifies the relationship between the fields of a data file and the columns of a database table.
映射指定数据文件的字段和数据表的列之间的关系。
In addition to the RUNSTATS, you can automate database backups and REORGs (defragmentation of table and index data).
除了RUNSTATS外,还可以将数据库备份和REORG(表和索引数据整理)自动化。
Drill down the database to the schema and table of the data that you would like to work with.
展开数据库,显示要操作的模式和数据表。
Let's take a look at a simple program that will create a database table and populate the table with data values.
让我们来看一个简单的程序,它能创建一个数据库表并填入数据值。
Create the Database and Table to Store the Form data.
创建存储表格数据的数据库和表格。
Once you have created the SAMPLE database, follow these steps to create the required table and data used in the examples.
一旦创建了SAMPLE数据库后,遵循这些步骤创建必要的表和数据,供示例使用。
It USES the FastLoad utility and provides the function of loading bulk data into an empty database table.
它使用FastLoad实用工具并提供了将批量数据加载到空数据库表中的功能。
The createdb1.sql script: Creates database table and fills with data.
清单5 . createdb 1 . sql脚本:创建数据库表并填充数据。
应用推荐