Structuring Data

How to effectively structure your data.

As mentioned previously, FrontierNav uses a graph data model. However, as graphs are extremely flexible and lack restrictions, it helps to view the data in a relational model. That is why Data Tables are the primary interface for editing data.

Initially, adding data is simple: You create tables and add columns to store values. However, as you introduce relationships between tables, you may end up at a point where you need to think about how you want the data to be organised so that everything is linked in an intuitive way for people to navigate. If you've worked with Relational Databases before, like PostgreSQL or MySQL, then this should be familiar. If not, it's easy to get started. Think of it like a puzzle that you need to untangle. This process is known as normalisation. It takes practice but like most things, the more you do it, the easier it gets.

Useful Links