Skip to main content

• Section 2-6 : Key Features

Data Modeling​

Data Modeling - Configure​

  • Configure Table Joins | Table Relations in Builder Studio - DATA Table Explorer

data-modeling-01.png

data-modeling-02.png

data-modeling-03.png

REST Data Modeling​

data-mod-rest-01.png

data-mod-rest-02.png

data-mod-rest-03.png

data-mod-rest-04.png

data-mod-rest-05.png

data-mod-rest-06.png

GraphQL Data Modeling​

data-mod-grql-01.png

data-mod-grql-02.png

data-mod-grql-03.png

Data Modeling And Caching​

  • When using caching either Simple or Redis, the data returned in data modeling using caching may return stale data. This is due to Spring Boot way of handling caching. Any new records added or any deleted records, from tables used in joins, may not reflect in data modeling queries responses.
  • If getting latest accurate data is high priority, You can -
    • Project Configure : Cache None
    • or Disable caching for specific queries against data model, via its controller customization.

Disable Caching for Selective API endpoints​

Via CacheManager clear()​
  • Use in controller 
    @Autowired
    CacheManager cacheManager;
// add clear calls in GetMapping function beginning 
// for all Entities used in data model, e.g.
        cacheManager.getCache("Orders").clear();
        cacheManager.getCache("Shipping").clear();
Via EntityManager clear()​
  • Use in controller 
    @PersistenceContext
    private EntityManager entityManager;
// add in GetMapping function beginning
    entityManager.clear();

BE Flexible SQL-Like Querying via APIs​

  • REST

emapi-rest-swagger-run-02-P1.png

emapi-rest-swagger-run-02-P2.png

  • GraphQL

emapi-gql-view-graphiql-03.png

FE Flutter Filter Screen​

flutter-16.png

flutter-17.png