In this espisode we take a closer look at relational database systems and the concepts behind them. We start by discussing the relational paradigm, its concepts and ramifications, and go on to architectural aspects.

Welcome back! In the first part of this series, we looked at a very "low-level" way to interact with a relational database by sending it raw SQL strings and retrieving the results. We created a very simple Express application that we can use as an example and deployed it on Heroku with a Postgres database.

In this part, we're going to examine a few libraries which build on top of that foundation, adding layers of abstraction that let you read and manipulate database data in a more "JavaScript-like" way.

The present disclosure provides improved systems, methods, and computer program products suited to address the issues with legacy approaches. Specifically, the present disclosure provides a detailed description of techniques used in systems, methods, and in computer program products for interpreting relational database statements using a virtual multidimensional data model. Certain embodiments are directed to technological solutions for receiving a relational database statement comprising relational metadata mapped to a virtual multidimensional representation of a subject database, and generating a subject database statement based at least in part on the relational database statement and the virtual multidimensional representation, and configurable to operate on the subject database to produce a visualization result set, which embodiments advance the technical fields for addressing the problem of projecting a multidimensional data view of a subject database on to a relational data analysis environment to enable real time data analyses, as well as advancing peripheral technical fields.