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環境中尤其如此，該環境中的事務十分巨大，并且不斷地要插入、刪除和更新一些數據。
