SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships. As I noted in an earlier column, JSON is great ...

The need to persist data created at runtime is as old as computing. And the need to store object-oriented data cropped up when object-oriented programming became pervasive. Currently, most modern, ...

db4o, as you’ve likely sussed from the previous paragraph, stores its data in a different way to a relational database. Rather than flat tables with repeated primary key and foreign key values ...

I urge our readers to have a look at the “Vietnam of Computer Science” by Ted Neward, which compares the quagmire of the Vietnam War to the current quagmire that results from our attempts to blend ...

Here's how you can use SQL Server's OpenJson function to dismantle JSON structures into relational tables targeting either transactional systems or data warehouses. JSON is great for moving data ...

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