Remove PostgreSQL Remove SQL Remove Structured Data
article thumbnail

Case Study: Powering Customer-Facing Dashboards at Scale Using Rockset with PostgreSQL at DataBrain

Rockset

Summary: DataBrain, a SaaS company, was using PostgreSQL through Amazon RDS to land and query incoming customer data. However, PostgreSQL couldn’t scale, quickly ingest schemaless data, or efficiently run analytics as DataBrain’s data grew. One customer was already generating 60 million rows of data.

article thumbnail

Offload Real-Time Reporting and Analytics from MongoDB Using PostgreSQL

Rockset

Offloading read operations to another database, such as PostgreSQL, is one option that accomplishes this end. After discussing what PostgreSQL is, this article will look at how to offload read operations to it. What Is PostgreSQL? PostgreSQL is an open-source relational database that has been around for almost three decades.

MongoDB 40
Insiders

Sign Up for our Newsletter

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

article thumbnail

Why Real-Time Analytics Requires Both the Flexibility of NoSQL and Strict Schemas of SQL Systems

Rockset

Typically stored in SQL statements, the schema also defines all the tables in the database and their relationship to each other. Companies carefully engineered their ETL data pipelines to align with their schemas (not vice-versa). SQL queries were easier to write. They also ran a lot faster. There were heavy tradeoffs, though.

NoSQL 52
article thumbnail

Mythbusting: The Venerable SQL Database and Today’s Real-Time Analytics

Rockset

So I don’t fault you for resisting my message, which is that the SQL database that came of age in the 80s still has a critical role to play today in moving data-driven companies from batch to real-time analytics. In many tech circles, SQL databases remain synonymous with old-school on-premises databases like Oracle or DB2.

article thumbnail

RDBMS vs NoSQL: Key Differences and Similarities

Knowledge Hut

RDBMS uses SQL to organize data into structured tables, whereas NoSQL is more flexible and can handle a wider range of data types because of its dynamic schemas. Programming languages like SQL (Structured Query Language) are used to update and retrieve data from databases, among other things.

NoSQL 52
article thumbnail

The Power of Exploratory Data Analysis for ML

Cloudera

First of all, there’s the question of what data is currently available within their organization, where it is, and how it can be accessed. Data scientists might want to do some SQL – based profiling, or visualize the data to better understand the distributions, veracity, and hidden nuances. Next Steps.

article thumbnail

Beyond REST

Netflix Tech

Many organizations are embracing GraphQL as a way to unify their enterprise-wide data model and provide a single entry point for navigating a sea of structured data with its network of related entities. Use PostgreSQL Composite Types when taking advantage of PostgreSQL Aggregate Functions.