# Best practices on data structure for entity design - resources?

**URL:** <https://forum.getodk.org/t/best-practices-on-data-structure-for-entity-design-resources/56264>\
**Category:** Support\
**Tags:** entities, form-design\
**Created:** [August 14, 2025, 5:38am UTC](https://forum.getodk.org/t/best-practices-on-data-structure-for-entity-design-resources/56264 "2025-08-14T05:38:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ahblake](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ahblake/32/22392_2.png) [@ahblake](https://forum.getodk.org/u/ahblake)\
**Post date:** [August 14, 2025, 5:38am UTC](https://forum.getodk.org/t/best-practices-on-data-structure-for-entity-design-resources/56264/1 "2025-08-14T05:38:45Z")

</div>

This came to mind from a question @seewhy asked at the recent Insiders call.

We have an excellent [quick reference](https://forum.getodk.org/t/new-docs-entity-quick-reference/54409/5) for entities from @ktuite, and there's been some showcases & posts that are very useful eg

- [Best Practices for Entities Management](https://forum.getodk.org/t/best-practices-for-entities-management/46873) @Baptiste_Monnier
- [Single action across multiple entities vs multiple actions on single entity](https://forum.getodk.org/t/entity-workflows-single-action-across-multiple-entities-vs-multiple-actions-on-single-entity/50879/1) @Tyler_Depke
- [Longitudinal Workflow with Entities](https://forum.getodk.org/t/longitudinal-workflow-with-entities/55220/1) @Yakub @Certified_Bashir
- [Entity-based data capture workflow “Site-based survey with opportunistic encounters”](https://forum.getodk.org/t/entity-based-data-capture-workflow-site-based-survey-with-opportunistic-encounters/33353/1) this is pre 'Entities' @Florian_May

What I think would be a useful reference, probably as a showcase post rather than in the official docs, is in addition to examples, a collection of resources that relate to system structure/design and how things will impact performance / downstream analysis / maintenance. For those of us (me!) that don't have a compsci/database background, we may make design decisions in the creation of entity lists and the forms that use them that are sub optimal and result in additional work required or poorly performing forms.

Are there textbooks / courses / videos that would help guide data hierarchy / structure / relationships to result in efficient and more readily manageable entity lists & forms that people can point to?

eg texts like this a good start or too deep

> **[Designing Data-Intensive Applications](https://www.oreilly.com/library/view/designing-data-intensive-applications/9781491903063/)**
>
> Data is at the center of many challenges in system design today. Difficult issues need to be figured out, such as scalability, consistency, reliability, efficiency, and... - Selection from Designing Data-Intensive Applications \[Book\]

---

<div class="post-metadata">

**Author:** ![Tyler\_Depke](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/tyler_depke/32/17598_2.png) [@Tyler\_Depke](https://forum.getodk.org/u/Tyler_Depke)\
**Post date:** [August 14, 2025, 6:10pm UTC](https://forum.getodk.org/t/best-practices-on-data-structure-for-entity-design-resources/56264/2 "2025-08-14T18:10:12Z")

</div>

Along these same lines, I will just say that the most common thing I’ve struggled with is ideal group structure. No matter how many times I change question orders, it always seems like there is a more ideal way to put certain questions which sometimes involves changing what group they are in. With several nested groups and/or repeats, it can get messy and I haven’t really figured out a good way to figure this out on the front end.

---

<div class="post-metadata">

**Author:** ![Florian\_May](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/florian_may/32/7758_2.png) [@Florian\_May](https://forum.getodk.org/u/Florian_May)\
**Post date:** [August 16, 2025, 12:30am UTC](https://forum.getodk.org/t/best-practices-on-data-structure-for-entity-design-resources/56264/3 "2025-08-16T00:30:22Z")

</div>

I've been wondering the same for a long time.

I think there's an abundance of well designed forms in use which solve a combination of problems. If we had a repository of these forms, or maybe just form fragments solving exactly one problem with correct and consistent annotations, they may form a good knowledge base for a chatbot like the brand new kapa.ai.

I find form building challenging because I have to abstract what I want to achieve into a language with lots of specific terminology, then find similarities to other case studies explaining how they implemented their needs. Maybe this mental translation of concepts is something kapa.ai could/will help to bridge.

Last, as for ideal form design and flow, it's always been an intense two-way street between the analytical needs of what we need to capture versus how we practically can capture within the flow of field work. An invaluable resource there was having a quick feedback loop of form design, test data capture, and analysis (in my case, using the ruODK Rmarkdown template, but anything to quickly parse/map/summarise submissions would work just as well).
