NoSQL on ACID: Meet Unstructured Postgres
Share this Session:
  Marc Linster   Marc Linster
Senior Vice President Products and Services


Wednesday, August 20, 2014
04:15 PM - 05:00 PM

Level:  Technical - Introductory

The proliferation of unstructured data from new data sources has generated greater demand for technologies such as NoSQL. But NoSQL technologies are not ACID compliant. More and more users are discovering this limitation, and the consequence is that developers and DBAs must build complex workarounds.

Postgres is leading the movement of integrating unstructured data with the enterprise database management system. Document database capabilities in Postgres advanced significantly with support for the JSON data type and the JSONB “binary JSON” type now in beta will propel the database forward significantlly. These advances follow the longstanding HStore data type added in 2006 to support key/value stores in Postgres. But unlike NoSQL-only solutions, a key-value store created in Postgres is ACID compliant. And PLV8 provides Javascript programming capabilities inside the database.

Learning to harness these capabilities to master unstructured data challenges with Postgres will achieve lower costs, less risk and less complexity while supporting enterprise-class workloads with ACID compliance. This talk will help open the door to as better understanding of NoSQL technologies in Postgres and cover several scenarios for working with JSON in Postgres, as well as demonstrate performance metrics. The session will include:

  • Overview of JSON data types and operators
  • Examples of SELECT, UPDATE, etc
  • Examination of performance considerations
  • And more

Before joining EnterpriseDB, Marc spent almost 4 years at Polycom, the leading maker of video communications equipment, focusing on the Services Supply Chain, Business Intelligence, Customer Data Management and Cloud Solutions. Prior to Polycom, Marc lead a supply chain consulting and systems integration company working with customers in the US, Canada, France, Germany and Switzerland. This tapped the expertise he developed at Avicon Group, where he spent six years, first as chief technology officer then as vice president of operations, developing an extensive background in management, business consulting, systems integration, data management and business intelligence. Marc holds a Ph.D. (Dr. rer. nat) in Computer Sciences from the University of Kaiserslautern in Germany.

Close Window