article thumbnail

ArangoDB: Fast, Scalable, and Multi-Model Data Storage with Jan Steeman and Jan Stücke - Episode 34

Data Engineering Podcast

How does the underlying engine store the data to allow for the different ways of viewing it? What are some of the benefits of multi-model data storage? For users who are accustomed to a relational engine, how do they need to adjust their approach to data modeling when working with Arango? How is ArangoDB constructed?

article thumbnail

Turbocharging Atlas: How we reduced server initialization time to less than 2 minutes

ThoughtSpot

It stores all the metadata created within a ThoughtSpot instance to enable efficient querying, retrieval, and management of data objects. While Atlas operates as an in-memory graph database for speed and performance, it uses PostgreSQL as its persistent storage layer to ensure durability and long-term data storage.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

How to query JSONB array of objects in PostgreSQL

Hevo

Do you have a NoSQL database that has no rigid shape and is causing data analysis complexity nightmares? With JSON in PostgreSQL, you can have a solution to your complex problem. PostgreSQL is a high-performing, open-sourced object-relational database with two JSON data storage types, JSON and JSONB.

article thumbnail

Hive to PostgreSQL Integration: 2 Easy Methods to Connect

Hevo

Businesses need to efficiently store, handle, and analyze the growing amounts of data they produce. This article will explore the two prominent data storage systems organizations use: Hive and PostgreSQL.

article thumbnail

PostgreSQL on Google Cloud SQL to Snowflake: 2 Easy Methods to Load Data

Hevo

Google Cloud SQL for PostgreSQL, a part of Google’s robust cloud ecosystem, offers businesses a dependable solution for managing relational data. However, with the expanding need for advanced data analytics, it is required to integrate data storage and processing platforms like Snowflake.

article thumbnail

PostgreSQL on Amazon RDS to Firebolt Data Migration: 2 Easy Methods

Hevo

Migrating data between two platforms is a critical process for organizations to leverage the power of advanced analytics. The migration from PostgreSQL on Amazon RDS to Firebolt is one such example of how businesses can unlock the full potential of their data.

article thumbnail

CockroachDB In Depth with Peter Mattis - Episode 35

Data Engineering Podcast

Summary With the increased ease of gaining access to servers in data centers across the world has come the need for supporting globally distributed data storage. I know that your SQL syntax is PostGreSQL compatible, so is it possible to use existing ORMs unmodified with CockroachDB?