Siren Platform User Guide

Using complex normalized databases

It is often the case, especially in relational databases that the data is highly normalized. In these situations, to increase the value for the user it makes a lot of sense to create semi-denormalized views. Typically, the right level of abstraction is the entity level, in other words, creating views which reflect useful representations of the entities in the domain. As an example of this, here you can see how our demo distribution was created. While the user sees only four indexes, which represent the entities which make sense in the investment domain (articles, companies, investments, and investors), the original data is much more normalized as per the following structure.

Search results

    No results found