Visual Studio Magazine

Converting JSON Objects to Relational Tables, Part 2: Creating Related Tables

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 ...
Visual Studio Magazine

Converting JSON Objects to Relational Tables: Flattening the Object

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

relational database

A database that maintains a set of separate, related files (tables), but combines data elements from the files for queries and reports when required. The concept was developed in 1970 by Edgar Codd, ...
Linux Journal

Embedding the db4o Object-Oriented Database

db4o is an open-source, object-oriented database from db4objects. It is embeddable, in the sense that the entire db4o engine is supplied as a single library that links into your application. Versions ...
Linux Journal

Christof Wittig and Ted Neward on Object-Oriented Language Mapping to Databases

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