29 November 2016

How PostgreSQL supports Nosql for faster data retrieval

#postgreSQL
#postgreSQL
The first beta version of PostgreSQL 9.4, includes a number of new features that address the rapidly growing market for Web applications, many of which require fast storage and retrieval of large amounts of user data.

Typically, users have gone to NoSQL databases, which were designed for such workloads, though the community of developers behind PostgreSQL is updating their database to meet these requirements as well.

In particular, PostgreSQL 9.4 natively supports JSON (JavaScript Simple Object Notation) which is quickly becoming the format of choice for sharing data across different systems, often using the REST (Representational State Transfer) protocol. The success of the MongoDB document database has been built in large part on the growing use of JSON.

PostgreSQL's structured format for saving JSON, called JSONB, eliminates the need for restructuring a document before it is committed to the database.

This gives PostgreSQL the speed to ingest documents as quickly as MongoDB, while still maintaining compliance with ACID (atomicity, consistency, isolation, durability), a set of properties required for reliably storing data in databases. PostgreSQL also provides a full set of indexing services, functions and operators for manipulating JSON data.

No comments:

Post a Comment

Thanks for your message. We will get back you.

© 2010-2017 Biganalytics.me. All rights reserved.. Powered by Blogger.

Total Pageviews

All material, files, logos and trademarks within this site are properties of their respective organizations.