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 ...

Four queries and some in-app iteration on collections (joins). At my current job, we have a monolith of similar size/complexity that sits on top of a relational database. The DAOs are somewhat 1:1 ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Cory Benfield discusses the evolution of ...

The first thing in building any E-commerce app is creating the underlying database to support it. As much as possible, you should try to build your application code and business logic into your ...

In a world that is all about new apps and cloud computing, sometimes the important stuff doesn’t look new or cool. Sometimes key small business tools are just functional, they might have been around a ...

I have never done any serious SQL design before. Anyways I have to store a hierarchical data structure, similar to a tree in a SQL database.<BR><BR>Right now I simply add a "parent_id" column in each ...

Airtable is an online platform for creating, using, and sharing small relational databases. It’s not ready for enterprise users yet (that’s coming), but right now, if you want help managing data for ...

When XML came along five years ago, promising to rewrite the rules of data management, vendors of relational databases took note, but they didn’t panic. They’d already seen this movie a decade before, ...

The information below serves as a brief primer to help you better understand the database terms you’ll most often encounter. Relational Databases. Relational databases became the database of choice ...