Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we dive ...

In a conversation last year, Justin Sheehy, CTO of Basho, described NoSQL as a movement, rather than a technology. This description immediately felt right; I've never been comfortable talking about ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Jinsong Yu shares deep architectural insights ...

Microsoft today launched Dataflex, a relational database that lets business developers create, deploy, and manage Power Platform apps and chatbots without leaving Microsoft Teams. The built-in low ...

Migrating from an RDBMS to NoSQL can improve scalability and flexibility. Explore top NoSQL databases and best practices for migrating data. The phenomenon of big data continues to underscore the ...

The Jakarta Persistence API (JPA) is a Java specification that bridges the gap between relational databases and object-oriented programming. This two-part tutorial introduces JPA and explains how Java ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

The Jakarta Persistence API (JPA) is a specification that defines a standardized framework for data persistence. Persistence is the fundamental mechanism for saving and retrieving data over time. In ...