Concurrency Control in Greenplum Database
来源:互联网 发布:java float int 比较 编辑:程序博客网 时间:2024/04/28 05:57
Unlike traditional database systems which use locks for concurrency control, Greenplum Database (as does PostgreSQL) maintains data consistency by using a multiversion model (Multiversion Concurrency Control, MVCC). This means that while querying a database, each transaction sees a snapshot of data which protects the transaction from viewing inconsistent data that could be caused by (other) concurrent updates on the same data rows. This provides transaction isolation for each database session.
MVCC, by eschewing explicit locking methodologies of traditional database systems, minimizes lock contention in order to allow for reasonable performance in multiuser environments. The main advantage to using the MVCC model of concurrency control rather than locking is that in MVCC locks acquired for querying (reading) data do not conflict with locks acquired for writing data, and so reading never blocks writing and writing never blocks reading.
Greenplum Database provides various lock modes to control concurrent access to data in tables. Most Greenplum Database SQL commands automatically acquire locks of appropriate modes to ensure that referenced tables are not dropped or modified in incompatible ways while the command executes. For applications that cannot adapt easily to MVCC behavior, the LOCK command can be used to acquire explicit locks. However, proper use of MVCC will generally provide better performance than locks.
- Concurrency Control in Greenplum Database
- database-concurrency control-notes
- 分布式事务2PC论文翻译(Concurrency Control and Recovery in Database Systems )
- Greenplum Database
- Greenplum - Merge tables in two different database instances
- Concurrency and Database Connections in Ruby with ActiveRecord
- All about control file in Oracle Database
- Types of Concurrency Control
- Optimistic Concurrency VS. Pessimistic Concurrency Control
- Optimistic Concurrency VS. Pessimistic Concurrency Control
- Optimistic Concurrency VS. Pessimistic Concurrency Control
- Greenplum Database 大数据处理学习
- Chapter 7Greenplum Database数据类型
- MVCC-multi version concurrency control
- Java Concurrency in Practice
- Concurrency in Swing
- Concurrency Setting in Csharp
- Concurrency in JavaFX
- 海量数据处理方法总结
- c++空白基类最优化(EBO或EBCO)
- android ListView注意事项
- 通用线程池的设计和实现[C语言]
- Solr中配置IKAnalyzer分词器配置,测试分词效果
- Concurrency Control in Greenplum Database
- Java线程
- 为SQLite数据库中某个字段的每一行结尾插入一个字符串
- ListView应用(转自http://www.cnblogs.com/allin/archive/2010/05/11/1732200.html)
- VC++ List Ctrl控件
- 新浪架构调整:独立的微博开放平台部成立(转)
- Android 强指针和弱指针
- winpcap+vc6.0
- 如何从红帽官网下载redhat企业版系统镜像