The OLTP database is always up to date, and reflects the current state of each business transaction.
OLTP数据库总是在更新中,并且反映了每个商业事务的当前状态。
Suppose a table in an OLTP database already has 6 or 7 indexes. Would I give a thumbs-up to adding another?
假设 OLTP数据库中的一个表已经拥有6 个或7 个索引,我还会赞成再添加一个吗?
We discovered that the default value for this parameter, 8 (4kb pages), usually is not big enough for an OLTP database.
我们发现该参数的缺省值为8 (4kb页),这对于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数据库,在保持系统稳定的同时为缓冲池留出尽可能多的内存。
The testing that is described demonstrated that EFDs provide a substantial improvement (approximately 9X) in I/O performance when used in an OLTP database environment.
所讨论的这个测试说明了EFD用在一个OLTP数据库环境时能大大提高I/O性能(约为9倍)。
Therefore, from a database perspective, on-line transaction processing (OLTP) environments are ideal candidates for EFD data storage.
因此,从数据库方面看,在线事务处理(OLTP)环境很适合使用EFD数据存储。
To measure the performance impact of arrays, a 900gb database was used and an OLTP (Online Transactional Processing) workload was exercised.
为衡量阵列的性能影响,使用900gb的数据库且执行oltp(联机事务处理)工作负荷。
An OLTP environment is a database environment that facilitates and supports transaction-oriented workloads, which typically consist of numerous data entry and retrieval operations.
OLTP环境指的是使用和支持面向事务的工作负载的数据库环境,它一般由许多数据实体和查询操作组成。
General tuning tips are the same regardless of the database workload, but differences do exist between OLTP and DSS workloads.
无论数据库负载如何,通用的调优提示都是相同的,只是OLTP和DSS工作负载之间存在差别。
The database queries in TPC-H are more complex than typical OLTP queries.
TPC- H中的数据库查询要比典型的OLTP查询更加复杂。
To confirm placement options for DB2 objects on SSDs, we chose an IBM DB2 OLTP workload to drive a series of tests, starting with a baseline of all database files on HDDs.
为了证实DB2对象在SSD 上的性能效果,我们选择一个IBM DB2OLTP工作负载来进行一系列的测试,首先以所有数据库文件放在 HDD 上的场景作为基准。
TPC-C is an OLTP benchmark which requires efficient use of large memory, intensive random read/write I/O, and has extremely intensive database log activity.
TPC-C是一种OLTP基准,要求有效地使用大量内存,大量的随机read/writeI/O,并且有很密集的数据库日志活动。
For example, an Oracle database, either Online Transaction Processing (OLTP) or a data Warehouse application, can benefit when using large pages.
例如Oracle数据库,无论是联机事务处理(OLTP)或者数据仓库应用程序,都可以从大型页面的使用中获益。
Conventional database has achieved great success in online task processing (OLTP), but it can not meet the administrator's requirement for decision making and analyzing.
传统数据库在连机事务处理(OLTP)中获得了较大的成功,但是对管理人员的决策分析要求却无法满足。
In OLTP systems, end users routinely issue individual data modification statements to the database.
在OLTP系统中,最终用户日常性地向数据库发布个人数据更新的语句。
In this paper, we focuses on the buffer management of flash database in OLTP application environment.
本文集中探讨了在OLTP环境下闪存数据库的缓冲区管理的问题。
Database design: an OLTP system usually adopts an entity-relationship (ER) data model and an application -oriented database design.
数据库设计:通常,OLTP系统采用实体-联系(ER)模型和面向应用的数据库设计。
A data warehouse database modeling solution is often best served by implementing a denormalized duplication of an OLTP source database.
数据仓库的数据库建模方案通过实施一个OLTP源数据库的非规范化的副本来实现。
OLTP compression-drop column is supported, but internally the database sets the column UNUSED to avoid long-running decompression and recompression operations.
对于oltp压缩也是不支持列删除,但是我们可以把列设置为unused的,避免解压缩和重新压缩操作队它的影响。
OLTP compression-drop column is supported, but internally the database sets the column UNUSED to avoid long-running decompression and recompression operations.
对于oltp压缩也是不支持列删除,但是我们可以把列设置为unused的,避免解压缩和重新压缩操作队它的影响。
应用推荐