释义 |
OLTPCOCA²⁴²⁹²³BNC⁵⁹⁵⁰⁷ 基本例句 abbr.联机事务处理¹⁰⁰ Because the only table may be the hotspot unless it is partitioned, OLTP Systems typically don’t work well with it. 除非进行分区,否则唯一的数据表会成为热点, OLTP系统通常在这方面都不太好。 infoq Batch and query applications typically do a lot of sequential processing, while data access for OLTP tends to be more random in nature. 批处理和查询应用程序通常要进行大量的顺序处理,而用于 OLTP的数据访问往往更具有随机性。 ibm Finally, the clustering of the data is guaranteed and cannot become un- clustered, as is normally the case in OLTP systems. 最后,数据的集群受到保障,数据不会又变成非集群状态,在 OLTP系统中就常常会出现这种情况。 ibm For example, OLTP- like applications would typically benefit from smaller pages sizes since operations tend to be quick updates a single row retrievals. 例如,诸如 OLTP的应用程序一般受益于较小的页面大小,因为操作趋向于为快速更新单行检索。 ibm For each step, we’ve listed some key V8.2 enhancements that apply to OLTP databases, where the primary interest is in indexes. 对于每一步,我们列出了 V8.2中适用于 OLTP数据库其中最相关的就是索引的一些关键的增强。 ibm For OLTP applications, there should be less sorting and temp space required and only a handful of concurrent cursors opened at a time. 对于 OLTP应用程序,所需的排序和临时空间会比较少,一次只打开少数并发游标。 ibm Games are not like decision support system DSS or Online Transaction Processing OLTP systems at all. 游戏与决策支持系统 DSS和在线事务处理 OLTP系统完全不一样。 ibm General tuning tips are the same regardless of the database workload, but differences do exist between OLTP and DSS workloads. 无论数据库负载如何,通用的调优提示都是相同的,只是 OLTP和 DSS工作负载之间存在差别。 ibm However, for most e- commerce OLTP applications that use a large database, the buffer pool doesn't really need to be more than8 GB. 但是,对于使用大型数据库的大多数电子商务 OLTP应用程序,缓冲池大小实际上不需要超过8 GB。 ibm In any real OLTP database, implementing this change can be a problem. 在任何真实的 OLTP数据库中,实现此更改可能是一个问题。 ibm It was an online transaction processing OLTP application with10,000 users accessing the system in order to dispatch technical problems. 这是一个联机事务处理 OLTP应用程序,有10,000 位用户访问该系统以发送技术问题。 ibm On OLTP systems, where user sessions are performing quick queries, tuning this parameter can be very important. 在 OLTP系统上,用户会话执行快速查询,调节此参数可能非常重要。 ibm Online transaction processing OLTP is not the same thing as online analytical processing OLAP, and data access patterns for each technique are quite different. 联机事务处理 OLTP与联机分析处理 OLAP并不相同,两种技术所使用的数据访问模式也有很大的区别。 ibm Sequential numbers are often used in OLTP- like applications to generate primary keys required by the relational model. 连续数字在 OLTP类应用程序中常常用于生成关系模型所需的主键。 ibm Therefore, from a database perspective, on-line transaction processing OLTP environments are ideal candidates for EFD data storage. 因此,从数据库方面看,在线事务处理 OLTP环境很适合使用 EFD数据存储。 ibm This article addresses the monitoring and tuning tips in OLTP environments only. 本文仅仅说明 OLTP环境中的监控和调优提示。 ibm This is with commits after every document, as is typical of OLTP applications. 此操作在每个文档之后执行,这是 OLTP应用程序的典型操作。 ibm To measure the performance impact of arrays, a900GB database was used and an OLTP Online Transactional Processing workload was exercised. 为衡量阵列的性能影响,使用900GB的数据库且执行 OLTP联机事务处理工作负荷。 ibm What if you know your OLTP searches should use the same execution plan for different binding values? 要是你知道你的 OLTP搜索对不同绑定值应该使用相同执行计划又该怎么办呢? infoq With its dynamic multi-threading architecture, IDS scales well and can manage very large volumes of data, providing high performance in the OLTP environment. IDS采用动态的多线程架构,具有很好的可伸缩性,可以管理非常大量的数据,在 OLTP环境中提供高性能。 ibm With these tips, you can get your OLTP application up and running with reasonably good performance. 有了这些技巧,就可以启动自己的 OLTP应用程序并使其拥有非常好的运行性能。 ibm OLTP applications should not be performing large sorts. OLTP应用程序不应该执行大型排序。 ibm |