NoSQL Overview

NoSQL Overview

What is Postgres NoSQL for the Enterprise?

Postgres NoSQL is the powerful combination of unstructured and relational database technologies in a single enterprise database management system. Postgres NoSQL provides the freedom, flexibility and performance of handling unstructured and semi-structured data while preserving its long-term viability as enterprise information.

Postgres document and key-value store technologies provide the advantages of new NoSQL technologies plus the ability to integrate them into traditional corporate data infrastructures without data silos, operational complexity, loss of data integrity, and risk.

 

The Complete Document Database

Postgres has combined the leading JSON implementation with its proven ACID transaction engine. This unique combination gives users industry leading workload flexibility on the most cost effective and industry proven platform.

A complete database solution today often must address not only transactional integrity but also higher orders of data volume, increased data velocity and throughput speed, and a growing variety of data formats. New technologies have emerged that specialize in optimizing against one or two of these aspects while sacrificing the others.

Postgres with JSON takes a more holistic approach to user needs, more successfully addressing the majority of NoSQL workloads. For more details read the white paper PostgreSQL Advances to Meet NoSQL Challenges.

 

ACID or BASE?

The standards for Atomicity, Consistency, Isolation, and Durability (ACID) that have guided database technology for decades means an organization’s most valuable resource—its data—is valid, consistent and protected. Stand-alone NoSQL technologies do not meet ACID standards because they sacrifice critical data protections in favor of high throughput performance for unstructured applications. They achieve Basic Availability, Soft State and Eventual Consistency (BASE), which may be acceptable for use cases with little risk, such as a lost text message or the move of a token in a multi-player game.

While NoSQL solutions can promise Atomicity within a single document, this is inadequate for most enterprise systems with important mission critical relationships between multiple sets of dis-aggregated data whether structured or unstructured. With Postgres' NoSQL capabilities it is easy to integrate critical portions of your unstructured data with your traditionally governed data and maintain the performance, agile and unstructured benefits enjoyed by NoSQL tools.

 

Simplicity

Writing apps for the social or mobile web is a snap with Postgres' support for Javascript, Python, Ruby, node.js, JSON, Key-Values, geo-spatial and XML.

Using their favorite agile tools, developers can easily improve customer experience, accelerate time to market, and reduce costs.

 

Scalability

The explosive growth in Postgres users has been partially fueled by a proven track record for supporting high throughput systems with thousands of users processing large amounts of data. In all but the most extreme volume situations, Postgres easliy handles large amounts of data for large numbers of concurrent users. 

  • xDB Replication Server from EDB provides a non-virtualized read scale out solution. xDB in multi-master configurations provides read scalability and write availability to one of the largest telephone companies in America. 
  • EDB Failover Manager creates fault tolerant database clusters to minimize downtime when a master database fails by keeping data online in high 9s availability configurations. 
  • Large-scale Postgres configurations and solutions can be professionally managed, monitored, and tuned using EDB Postgres Enterprise Manager complete with performance dashboards, critical condition alerts, capacity planning, log analyzers, and much more.

 

Performance

Postgres today handles the most demanding needs of the largest insurance companies, banks, brokerages, government agencies, and defense contractors in the world today and has done so for years.  Performance improvements for Postgres are continuous with each yearly release and include great performance for its unstructured data types as well.

 

EDB encourages you to experience Postgres' NoSQL performance for yourself. Download the pg_nosql_benchmark  at GitHub let us know what you think.

Data Variety, Velocity & Volume

Postgres supports a variety of rich data formats used in today’s modern applications: JSON documents, Key-Value stores, geo-spatial, XML, IPv6, spatial coordinates and geometry, etc.  Each one is integrated into the database engine complete with supporting validation for data integrity, indexing for performance, and manipulation functions for application programming.

(Velocity)  Postgres has been known to achieve several hundred thousand TPS in transactional read/write workloads.

With no limitations on database size, and superior processing power, Postgres has for years, serviced multi-terabyte databases for large user populations for major financial, security, defense, government, and telecommunications organizations world wide.

Read more about Postgres NoSQL for the Enterprise

NoSQL Document/Relational Database Comparison
Code Samples
Technical Information