[seam-issues] [JBoss JIRA] Work started: (JBSEAM-4499) Improve wiki data model/schema

Improve wiki data model/schema ------------------------------ Key: JBSEAM-4499 URL: https://jira.jboss.org/jira/browse/JBSEAM-4499 Project: Seam Issue Type: Task Components: Wiki Reporter: Christian Bauer Assignee: Christian Bauer Motivation: The current data model based on nested sets has few advantages compared to a traditional schema. It complicates ad-hoc queries and it is more difficult to understand. The locking requirements of the nested set approach are in conflict with stateful persistence context management and bugs are extremely hard to detect and fix. Also, some of the problematic query performance we observed might be related to the nested set schema, however, that is not clear at this point as alternative schemas have not been compared with the same queries. Goal: A simpler schema and removal of all query performance bottlenecks. Steps: 1. Create a dummy traditional schema that reflects the domain and create dummy data (Benerator). 2. Write and analyze the most costly queries against that schema. 3. Once proven that the nested set schema is indeed the cause of these performance issues, replace the nested set schema with the traditional schema and write data migration scripts. 4. Consider replacing the nested set schema anyway, for reasons other than performance (simplicity, bugfixing, locking problems).