oltp
美 
英
- 网络联机事务处理(On-Line Transaction Processing)；在线事务处理；在线交易处理
例句
For OLTP applications, there should be less sorting and temp space required and only a handful of concurrent cursors opened at a time.
对于OLTP应用程序，所需的排序和临时空间会比较少，一次只打开少数并发游标。
Batch and query applications typically do a lot of sequential processing, while data access for OLTP tends to be more random in nature.
批处理和查询应用程序通常要进行大量的顺序处理，而用于OLTP的数据访问往往更具有随机性。
What if you know your OLTP searches should use the same execution plan for different binding values?
要是你知道你的OLTP搜索对不同绑定值应该使用相同执行计划又该怎么办呢？
On OLTP systems, where user sessions are performing quick queries, tuning this parameter can be very important.
在OLTP系统上，用户会话执行快速查询，调节此参数可能非常重要。
A key concept of SOA is to reuse assets across the enterprise, which is composed of both OLTP workloads and batch.
SOA有一个非常重要的概念，即在企业之间重用资产，它由OLTP工作负载和批处理组成。
Separating OLTP data from OLAP data allows you to optimize for the access patterns of each technique.
独立存储OLTP数据和OLAP数据使您可为每种技术的访问模式进行优化。
The results are very relevant to any DBA that must maintain and tune an online transaction processing (OLTP) system.
结果与必须维护和调优在线事务处理（OLTP）系统的任何DBA密切相关。
Philip Howard of Bloor Research provides competitive analysis of these two OLTP systems for IT specialists.
BloorResearch的PhilipHoward为IT专家提供了这两个OLTP系统的竞争力分析。
Sequential numbers are often used in OLTP-like applications to generate primary keys required by the relational model.
连续数字在OLTP类应用程序中常常用于生成关系模型所需的主键。
For for a large OLTP database, set aside as much as memory as possible for the buffer pool while keeping the system stable.
对于大型OLTP数据库，在保持系统稳定的同时为缓冲池留出尽可能多的内存。
Batch operations are often too resource intensive to run on an OLTP server.
在OLTP服务器上运行批处理操作通常会占用大量资源。
Part of the process of building a data warehouse out of data coming from multiple online transaction processing (OLTP) systems .
从来自多个联机事务处理（OLTP）系统的数据生成数据仓库的进程的一部分。
Because the only table may be the hotspot unless it is partitioned, OLTP Systems typically don't work well with it.
除非进行分区，否则唯一的数据表会成为热点，OLTP系统通常在这方面都不太好。
Demonstrates how event notifications can be used in an OLTP database application.
说明如何在OLTP数据库应用程序中使用事件通知。
It was an online transaction processing (OLTP) application with 10, 000 users accessing the system in order to dispatch technical problems.
这是一个联机事务处理（OLTP）应用程序，有10,000位用户访问该系统以发送技术问题。
Online Transaction Processing (OLTP), consisting of many transactions of varying complexity, mostly small.
联机事务处理（OnlineTransactionProcessing，OLTP），包含许多不同复杂性的小型事务。
General tuning tips are the same regardless of the database workload, but differences do exist between OLTP and DSS workloads.
无论数据库负载如何，通用的调优提示都是相同的，只是OLTP和DSS工作负载之间存在差别。
In this scenario, Service Broker functions as a framework for a distributed OLTP system.
在这种情况下，ServiceBroker用作分布式OLTP系统的框架。
These index scans also help online transaction processing (OLTP) databases and are described in much more detail in the main article.
这些索引扫描也可以帮助联机事务处理（OLP）数据库，更多细节在主文章中有说明。
Examples of OLTP environments include banking applications, order processing systems, and airline reservation systems.
常见的OLTP包括银行应用、订单处理系统和航空订票系统。
Games are not like decision support system (DSS) or Online Transaction Processing (OLTP) systems at all.
游戏与决策支持系统（DSS）和在线事务处理（OLTP）系统完全不一样。
Typically, online transaction processing (OLTP) systems perform large numbers of relatively small transactions.
通常，联机事务处理（OLTP）系统可执行大量相对较小的事务。
Therefore, from a database perspective, on-line transaction processing (OLTP) environments are ideal candidates for EFD data storage.
因此，从数据库方面看，在线事务处理（OLTP）环境很适合使用EFD数据存储。
In an online transaction processing (OLTP) environment, start with a value of 30 seconds.
在联机事务处理（OLTP）环境中，这个值从30秒开始。
"Table per Concrete Class" is good for an OLTP system with high concurrency, complex queries and few shared columns.
“每个具体类一张表”对有高并发、复杂查询并且没有共享列的OLTP系统来说是个不错的选择。
In a nutshell, short queries and OLTP transactions are faster as prepared statements with parameter markers.
总而言之，短小的查询和OLTP事务就像含参数占位符的预置语句一样，具有更快的速度。
New features enhance OLTP data security, OLTP performance, data warehouse performance, and administration.
新特性增强了OLTP数据安全性、OLTP性能、数据仓库性能和管理。
Administration of an OLTP or OLAP database environment frequently includes the loading of data .
OLTP或OLAP数据库环境的管理通常包括数据的加载。
"Table per Subclass" is good for an OLTP system with high concurrency, simple queries and few shared columns.
“每个类层次一张表”对有高并发、简单查询并且没有共享列的OLTP系统来说是个不错的选择。
Increases availability of data: This attribute is applicable to all system types, be they OLTP or warehouse systems by nature.
增加数据的可用性：这个特性适用于所有的系统，不论是OLTP还是数据仓库。
Finally, the clustering of the data is guaranteed and cannot become un-clustered, as is normally the case in OLTP systems.
最后，数据的集群受到保障，数据不会又变成非集群状态，在OLTP系统中就常常会出现这种情况。
We discovered that the default value for this parameter, 8 (4KB pages), usually is not big enough for an OLTP database.
我们发现该参数的缺省值为8（4KB页），这对于OLTP数据库而言通常不够大。
To measure the performance impact of arrays, a 900GB database was used and an OLTP (Online Transactional Processing) workload was exercised.
为衡量阵列的性能影响，使用900GB的数据库且执行OLTP（联机事务处理）工作负荷。
Bitmap indexes are not suitable for OLTP applications with large numbers of concurrent transactions modifying the data.
位图索引不大适合于拥有大量修改数据的同步交易OLTP（联机事务处理）应用。
Sequential scans are typical in decision support system (DSS) applications but rare with OLTP access patterns.
顺序扫描一般在决策支持系统（DSS）应用程序中很常见，但很少出现在OLTP访问模式中。
In any real OLTP database, implementing this change can be a problem.
在任何真实的OLTP数据库中，实现此更改可能是一个问题。
Users analyze the data and achieve decision support by submitting OLTP query, which usually needs a fast response speed.
用户通过提交联机分析处理查询对数据进行分析和决策支持，这通常需要较快的查询响应速度。
The following table lists the Transact-SQL stored procedures that are included in the AdventureWorks sample OLTP database.
下表列出了AdventureWorks示例OLTP数据库中包含的Transact-SQL存储过程。
The PERFORMER program is an OLTP application, so it doesn't have complex SELECT queries, and has minimal sorting.
PERFORMER程序是一个OLTP应用程序，因此，它没有复杂的SELECT查询，排序也很少。
This is especially true in an OLTP environment, where transactions are huge and data is constantly inserted, deleted and updated.
OLTP环境中尤其如此，该环境中的事务十分巨大，并且不断地要插入、删除和更新一些数据。
