Mvcc Database

As a software developer or DBA, one of the essential tasks is to deal with databases, such as MS SQL Server, MySQL, Oracle, PostgreSQL, MongoDB, and so on. As we all know, MySQL is currently the most widely used and the best free open source database, in addition, there are some you do not know or useless but excellent open source database, such as PostgreSQL, MongoDB, HBase, Cassandra, Couchba ...

NoSQL systems generally advertise a feature that is good performance and then why? relational database has developed for so many years, various optimization work has been done very deep, nosql system is generally absorbing relational database technology, and then, in the end what is the constraints on the performance of relational database? We look at this problem from the perspective of http://www.aliyun.com/zixun/aggregation/9344.html "> System design." 1, index support. Relational data ...

Comparison of 8 kinds of NoSQL database system: Kristóf Kovács Editor: Agile translation: Tang Yuhua share: More: Kristóf Kovács is a software architect and consultant who recently published an article comparing various types of NoSQL databases. The article is compiled by Agile translation-Tang Yuhua. If you want to reprint, please refer to the text after the declaration. Although SQL database is very useful ...

Orient DB is a scalable document database that supports ACID transaction processing. Implemented using Java 5. Orientdb is an Open-source NoSQL database management system, written in Java, a document-type database that supports acid tx,http://www.aliyun.com/zixun/aggregation/16666.html "> Indexes,asynch queries,sql Layer ...

1. Languages used in COUCHDB: Erlang features: DB consistency, easy to use license: Apache protocol: http/rest bidirectional data replication, continuous or temporary processing, processing with conflict checking, therefore, The use of Master-master replication (see note 2) mvcc– write without blocking read operation Pre-save version crash-only (reliable) design requires data compression view: Embedded mapping/Reduce formatted view: List display support for server ...

Hypersql is a Java-written sqlhttp://www.aliyun.com/zixun/aggregation/22.html "> relational database engine, its core is completely multi-threaded, supporting two-way locks and MVCC ( Multi-version concurrency control, with almost complete support for ANSI-92 SQL, supports common data types, and the latest version adds support for BLOB and CLOB data, up to 64T of data. At the same time, Hypersql is also a ...

Depth analysis of PostgreSQL and MySQL storage layer Li Haixiang DTCC2014 PostgreSQL is a POSTGRES developed by the University of California, Berkeley Computer Department, and is now renamed PostgreSQL, version 4.2-based Object Relational database management system (ORDBMS). PostgreSQL supports most SQL standards and provides many other modern features: complex queries, foreign keys, triggers, views, transactional integrity, and MVCC. ...