Item & Relation CRUD system architecture and design

[LessComplexity]

An architecture and design for the CRUD operation on Items & Relations are needed. The key factors to keep in mind while creating the design:

• Ability to CRUD new item/relation instances
• Ability to CRUD new items/relations
• Design will work using queries in JSON/PHP array form that will be translated to database query language
• Parsing query will not work with queriable objects - as they take more time to process since need unecessary memory allocations and need workarounds for query optimization - our goal is that the system will self-optimize when reading the JSON/PHP query.