New PostgreSQL Open Source database targeting NoSQL market

The new PostgreSQL open source database is built into a widely used JSON data Interchange format and targets http://www.aliyun.com/zixun/aggregation/13461.html "> MongoDB is the NoSQL market in the non relational data store represented.

PostgreSQL released the first beta version of PostgreSQL 9.4 in Thursday. The beta includes a number of new features for fast-growing web applications. Many of these Web applications require fast storage and retrieval of massive user data. Users typically choose NoSQL databases that are specific to workloads. For this reason, the 17802.html "> Developer community behind PostgreSQL is upgrading their databases to better meet these user needs."

Because JSON is rapidly becoming a new format for sharing data in different systems, especially in systems that use REST (representative state transfer) protocols, PostgreSQL 9.4 provides native support for JSON. The success of the MongoDB document database owes much to the rapid growth of JSON usage.

PostgreSQL structured format for storing JSON JSONB eliminates the need to readjust documents before applying to a database. This allows PostgreSQL not only to get documents as quickly as MongoDB, but also to maintain the indivisibility, consistency, independence, persistence of the four data [note] The essential elements required for the correct execution of the library transaction. PostgreSQL also provides a full range of services, including the operator of Indexing Service, functionality, and JSON data.

Although the previous PostgreSQL versions also support JSON, they store JSON documents in text format, so it takes a long time to store and retrieve them. In addition to native support for JSON, PostgreSQL has many new features. The new version has a new API (application interface) that decodes the data in the replication stream. This paves the way for third-party software providers to create more responsive replication systems. The new materialized view (materialized views) feature allows you to quickly update a consolidated report. With the new modify system settings (alter system set) feature, administrators can modify the PostgreSQL configuration file directly in the SQL command line.

Other new features include the introduction of dynamic background threading, array processing, table functions, and so on. In addition, the new version takes some measures to improve overall performance.

PostgreSQL is the second most widely used Open-source database in the market, followed by MySQL. After Sun Microsystems acquired MySQL, Oracle acquired Sun in 2010, allowing some users to migrate from MySQL to PostgreSQL. Like PostgreSQL, MySQL is also starting to adjust for nosql load handling. (Gundy compilation)