...
Existing Database Schema (Pipeline I) and discussion:
...
- Core tables (Task, TaskProcess, Dataset, TPInstance, DSInstance) may satisfy requirements with minoro modifications
- Some of Dan's original, simple, constraints (and tables such as TP_DS) may be too restrictive to allow things such as parallel processing.
- May be replaced with something in the nature of a list of conditions for further processing.
- Enumerated tables to have their integer Primary Keys removed, replaced with Primary Key based on the enumerated value.
Significantly reduces amount of SQL code devoted to joins
Still provides UI the advantage of an enumerated list of possible values
Requires more work to change (or remove) an enumerated value
Info title Dan claims... This is rare and easily offset by the time-cost benefit in coding, and readability/maintenance of code
- Some of Dan's original, simple, constraints (and tables such as TP_DS) may be too restrictive to allow things such as parallel processing.
Tony's New XML Schema and discussion:
...