从InformixSYSCHUNKS系统表中读数据,并根据以下标准包括镜像块。
Read data from the Informix SYSCHUNKS system table and include mirror chunks according to this criteria.
牢记数据库的构建块及其继承关系:数据库由表组成,表由字段组成。
Always keep in mind the building blocks of databases and their hierarchical relationships: databases consist of tables, which consist of fields.
使用与关系数据库一起提供的块载入工具来初始化数据库表。
Use the bulk load tools that are provided with relational databases to initialize database tables.
收集到的关于空余块的数据被存储在一个名为free_chunks的数据库表中,该表的格式如下。
The collected data about the free chunks is stored in a database table named free_chunks that has the following format.
对于mdc表,数据根据维值被组织到块中。
With MDC tables, data is organized into blocks according to dimension values.
数据块的这部分包括了表和索引的数据。一条数据行是可以跨多个数据块的。
This portion of the data block contains table or index data. Rows can span blocks.
苹果分区表包含了数块512字节的数据结构,每个分区使用一个数据结构。
The Apple partition map contains several 512-byte data structures, and each partition uses one data structure.
如果一个数据块被分配给一个表或者簇表的数据段,或者被分配给一个索引的索引段,那么可用空间区还可能存储事务条目。
In data blocks allocated for the data segment of a table or cluster, or for the index segment of an index, free space can also hold transaction entries.
缓冲池是内存中的一块存储区域,用于临时读入和更改数据库页(包含表行或索引项)。
A buffer pool is an area of storage in memory into which database pages (containing table rows or index entries) are temporarily read and changed.
RAWDEVSIZE程序分析可用原始设备,并将空闲块的偏移量、大小和路径信息存储到一个名为free_chunks的数据库表中。
The RAWDEVSIZE program analyzes available raw devices and stores the offset, size, and path information of free blocks into a database table named free_chunks.
如果无法将排序的数据整个放入排序堆中(排序堆是每次执行排序时分配的一块内存),它就会溢出到该数据库所有的临时表中。
If the sorted data cannot fit entirely into the sort heap, which is a block of memory that is allocated each time a sort is performed, it overflows into a temporary table owned by the database.
位图中的每一位代表一个或一组数据块。
Each bit in the bitmap corresponds to a block or a group of blocks.
换句话说,表的一行是作为读写单独一块数据的最小单位。
Put another way, a row of a table is an atomic unit that is read and written as a single piece.
紧凑的数据表可以针对基于行的数据库做存储块优化,让SQL执行得更好。
Compact tables can optimize storage blocks for row-based databases and accordingly make SQL perform better.
紧凑的数据表可以针对基于行的数据库做存储块优化,让SQL执行得更好。
Compact tables can optimize storage blocks for row-based databases and accordingly make SQL perform better.
应用推荐