Trace:
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Next revision Both sides next revision | ||
|
jvx:reference [2020/06/15 08:50] cduncan [DataBook] |
jvx:reference [2020/06/15 08:54] cduncan [Master/Detail] |
||
|---|---|---|---|
| Line 724: | Line 724: | ||
| ===== Master/Detail ===== | ===== Master/Detail ===== | ||
| - | [[https://en.wikipedia.org/wiki/Master%E2%80%93detail_interface#Data_model|Master/detail]] is something that occurs in nearly every data model. It means simply that there is one master dataset which is referenced by one or multiple detail datasets. Or to express it in SQL: | + | [[https://en.wikipedia.org/wiki/Master%E2%80%93detail_interface#Data_model|Master/detail]] is something that occurs in nearly every data model. It simply means that there is one master data set that is referenced by one or multiple detail data sets. Or to express it in SQL: |
| <code sql> | <code sql> | ||
| Line 733: | Line 733: | ||
| left join DETAIL d on m.ID=d.MASTER_ID; | left join DETAIL d on m.ID=d.MASTER_ID; | ||
| </code> | </code> | ||
| - | We can of course express a master/detail relationship when using data books. For that we just create a ''%%ReferenceDefinition%%'' and assign it to the detail data book: | + | We can, of course, express a master/detail relationship when using data books. For that, we just create a ''%%ReferenceDefinition%%'' and assign it to the detail data book: |
| <code java> | <code java> | ||
| Line 767: | Line 767: | ||
| 8| 3 | 8| 3 | ||
| </code> | </code> | ||
| - | Now if we select the second row in the ''%%masterDataBook%%'', the ''%%detailDataBook%%'' will just contain the rows with the corresponding ''%%MASTER_ID%%'', so 3, 4 and 5. | + | Now, if we select the second row in the ''%%masterDataBook%%'', the ''%%detailDataBook%%'' will just contain the rows with the corresponding ''%%MASTER_ID%%'', so 3, 4, and 5. |
| <code> | <code> | ||
| Line 778: | Line 778: | ||
| 3 5| 2 | 3 5| 2 | ||
| </code> | </code> | ||
| - | The ''%%detailDataBook%%'' is automatically adjusted according to the selection in the ''%%masterDatabook%%''. Of course this can have an arbitrary depth, too. | + | The ''%%detailDataBook%%'' is automatically adjusted according to the selection in the ''%%masterDatabook%%''. Of course, this can have an arbitrary depth too. |
| ===== Conclusion ===== | ===== Conclusion ===== | ||