Physics Derivation Graph navigation Sign in

schema for tables

Published 2020-04-13T15:35:00.001Z by Physics Derivation Graph

I previously proposed a schema for a relational database to hold the Physics Derivation Graph content but ended up using nested dictionaries and lists in v7.

One of the tasks associated with using the nest dictionaries was a desire to convert the content to a table design. I came up with two potential schemas for derivations but wasn't comfortable with either of them. In this post I outline a schema for tables that should work. The consequence is improved JSON-to-tables in v7 as well as enabling the transition from v7 to v8.

Columns per table:
What's not clear to me is how to store an AST. The AST relates the use of symbols and operators in a tree structure.
--> store AST as JSON