使用时态表可帮您节省一定的时间。
系统周期时态表的数据版本控制。
创建包含系统时间的时态表。
此列捕获从系统周期时态表中删除该行时的时间戳。
This column captures the timestamp when the row is deleted from the system-period temporal table.
历史表必须拥有与系统维护的时态表相同的列数和列顺序。
The history table must have the same number and order of columns as the system-maintained temporal table.
英语中过去时态用法十分复杂,而过去时态表委婉客气是一种常见的用法。
The use of the simple past tense is quite complicated and there is a common use of the simple past tense to express a mild tone.
对于系统时间表,DB 2还帮助将历史数据存储在一个与时态表相关联的历史表中。
For system time tables, DB2 also helps store historical data in a history table associated with the temporal table.
当时态表中的一行被更新时,DB2更新该行并自动将该行的以前版本转移到一个历史表中。
When a row in a temporal table is updated, DB2 updates the row and DB2 will automatically move the previous version of the row to a history table.
DB 2依据时态表的开始和结束列中使用的数据类型,使用合适的where子句谓词自动重写查询。
DB2 automatically rewrites the queries with appropriate WHERE clause predicates depending on the data types used in the start and end columns of the temporal tables.
没有任何周期规范的SELECT语句仅适用于系统周期时态表,为仅需要最新数据的应用程序提供了性能收益。
SELECT statements without any period specifications apply only to data in the system-period temporal table, providing a performance benefit for applications requiring only current data.
历史表不得包含时间段,必须具有与时态表相同的编码模式和编码字符集标识符(CCSID)(参见清单2)。
The history table must not include a period and must have the same encoding scheme and Coded Character Set Identifier (CCSID) as the temporal table (see Listing 2).
尽管DB 2将自动存储行的历史版本,但您必须创建一个历史表来包含这些行,并将它与系统周期时态表相关联。
Although DB2 will automatically store historical versions of rows, you must create a history table to contain the rows and associate it with the system-period temporal table.
DB 2将历史表中的sys_end值和时态表中的sys_start值设置为与最新的事务相关联的开始时间。
DB2 sets the sys_end value of the row in the history table and the sys_start value in the temporal table to the start time that is associated with the most recent transaction.
您可以使用ALTERTABLE命令和ADDversioning子句,并在USEHISTORY table子句中指定历史表名称,为时态表启用版本控制(参见清单3)。
You can enable versioning of the temporal table by using the ALTER table command with the ADD versioning clause and specifying the history table name in the use history table clause (see Listing 3).
包含时态数据的表有两个日期-时间列,它们表明每一行有效的期限(时间间隔)。
A table that includes temporal data has a pair of date-time columns that indicate the period (the time interval) when the row is valid.
基于基态修正思想,设计栅格时态层由四张关系表组成,并设计其表结构。
Based on the ideas of base state with amendments, the temporal layer of raster is designs by four relational tables, and the structure of tables is also given.
通过空间数据集和目标操作日志表创造性地将地理对象的空间信息和时态信息分开,又通过目标标识和版本号联系在一起。
Spatial information and temporal information of geo-objects are split by spatial dataset and objects operation log, and they are integrated with object identifications and versions.
汉语的时间表达系统中除了有时间名词、时间副词、表时态词语,还存在大量的时间短语。
Besides temporal nouns, temporal adverbs and words indicating tenses, there are many temporal phrases in the time expression system of the Chinese language.
基于时态数据管理理论提出了时变表、常量表、瞬像表的概念。
Based on the theory of temporal data management, the concept of temporal table, flat table and snap table are developed.
当前,基于无缝海量大表的空间及时态空间数据的存取效率亟待提高。
At present, access efficiency of spatial and spatiotemporal data based on seamless massive table mechanism needs solid improvement.
当前,基于无缝海量大表的空间及时态空间数据的存取效率亟待提高。
At present, access efficiency of spatial and spatiotemporal data based on seamless massive table mechanism needs solid improvement.
应用推荐