Robert Sheldon in MongoDB

Working with Schema Validation in MongoDB

In the previous article in this series, I introduced you to schema validation in MongoDB. I described how you can...

13 September 2024 18 min read

Robert Sheldon in NoSQL

Introducing Schema Validation in MongoDB

Similar to other NoSQL database systems, MongoDB is known for its flexible and variable schema models, unlike relational database systems...

21 August 2024 21 min read

Robert Sheldon in MongoDB

Working with Documents in the MongoDB Compass GUI

Throughout this series, I’ve discussed various ways to work with the documents in a MongoDB collection. If you’ve been following...

10 July 2024 23 min read

Robert Sheldon in MongoDB

Deleting Documents from a MongoDB Collection

So far in this series, we’ve looked at different ways that you can add, retrieve, and update documents in a...

24 June 2024 15 min read

Robert Sheldon in MongoDB

Updating Documents in MongoDB

In the previous articles this series, I demonstrated various ways to retrieve document data from a MongoDB database, using both...

29 April 2024 21 min read

MongoDB

Robert Sheldon in MongoDB

Building MongoDB Aggregations in MongoDB Compass

In the previous article in this series, I demonstrated how to build and run an aggregate statement in MongoDB Shell....

02 April 2024 22 min read

MongoDB

Robert Sheldon in MongoDB

Building MongoDB Aggregations

In the previous article in this series, I discussed how to use a find statement to retrieve data from a...

01 March 2024 20 min read

MongoDB

Robert Sheldon in MongoDB

Querying MongoDB Documents

MongoDB provides an efficient environment for storing document data at scale. However, most of your interactions with MongoDB will not...

22 January 2024 25 min read

NoSQL

Robert Sheldon in NoSQL

Introducing the MongoDB Document

MongoDB is a document database. As such, the data is stored as individual documents. A document is a data structure...

26 December 2023 18 min read

NoSQL

Robert Sheldon in NoSQL

Getting Started with MongoDB

MongoDB is a scalable database management system that stores data as documents in a collection, rather than as rows in...

13 November 2023 18 min read

NoSQL

Robert Sheldon in NoSQL

How to choose between SQL and NoSQL databases

Organizations have many choices when it comes to databases. In this article, Robert Sheldon explains how to choose between SQL...

13 April 2021 10 min read

NoSQL

Shel Burkow in NoSQL

Translating a SQL Server Schema into a Cassandra Table: Part III Many-to-Many, Attribute Closure and Solution Space

In the third and final article of the series, Shel Burkow demonstrates several designs that cover many-to-many relationships, attribute closure,...

21 April 2020 18 min read

NoSQL

Shel Burkow in NoSQL

Translating a SQL Server Schema into a Cassandra Table: Part II Integrity Constraints

Complex integrity constraints are more challenging to enforce in Cassandra than they are in a relational database. In this article,...

02 March 2020 16 min read

NoSQL

Shel Burkow in NoSQL

Translating a SQL Server Schema into a Cassandra Table: Part I Problem Space and Cassandra Primary Key

As many companies consider moving data to NoSQL, Cassandra may be the choice. In this series, Shel Burkow discusses design...

18 December 2019 13 min read

T-SQL Programming

Rodney Landrum in T-SQL Programming

A MongoDB to SQL Server Migration: Data Typing and Un-nesting

Importing data from one system to another is a common task for database professionals. It’s possible to spend a lot...

20 June 2019 15 min read

NoSQL

Adam Aspin in NoSQL

SQL For Cosmos DB – Handling Complex JSON Structures

The JSON documents that are part of Cosmos DB document collections can be complex with arrays and nesting. In this...

13 May 2019 16 min read

Blogs

Phil Factor in Blogs

Enjoying Joins in MongoDB

MongoDB has a prodigious appetite for unstructured data and has its place in a Database Developer’s toolkit. Even with indexes...

02 May 2019 14 min read

NoSQL

Adam Aspin in NoSQL

SQL For Cosmos DB – Tips and Tricks

Building on the introduction to the SQL used by Cosmos DB in the first article in the series, here you...

03 April 2019 9 min read

NoSQL

Adam Aspin in NoSQL

Introduction to SQL for Cosmos DB

This article by Adam Aspin reviews the Azure Cosmos DB SQL API from the perspective of the relational database developer....

06 March 2019 22 min read

NoSQL

Pushpa Sekhara Reddy Matli in NoSQL

Apache Cassandra Data Modeling and Query Best Practices

Organizations have many choices when it comes to database platforms. Choosing the right one for an application should be based...

07 February 2019 11 min read