Goal
Allow form definition and form data to be stored in Oracle, as we now do with eXist.
Status
- Implemented
- CRUD operations on form data
- Search operations on form data, except free text search
- CRUD operations on form definition (delete is implemented, but not accessible from the UI)
- Free text search
- Binary attachments
- To implement
- Indexes
- Amend script to create indexes for key columns
- Document how to create indexes for search of specific data (in summary page)
Handling of Indexes
Strategy:
- For now, we place indexes on app and form columns
- For large numbers of rows per app/form, we will later analyze the forms and place appropriate indexes to accelerate the structured search
