![]() | |
#81
| |||
| |||
|
|
Just to nitpick: in OO modeling there is no such thing as an OID, presumably you mean an object reference. |
#82
| |||
| |||
|
|
It doesn't have the Aisle/Bin thing, but it has many similar cases. |
#83
| |||
| |||
|
|
Mr. Scott wrote: You're oversimplifying. It is not necessary for keys to be permanent identifiers. Just because a tuple contains *within itself* a key doesn't necessarily mean that that key permanently identifies an object in the domain. I didn't make that over-simplification. You just assumed it. I never said "permanently". |
|
Since you bring up a warehouse model, have a look at this ORM/CQL model and the SQL for it: http://dataconstellation.com/ActiveF...ml#Warehousing It doesn't have the Aisle/Bin thing, but it has many similar cases. |
#84
| |||
| |||
|
|
Contrary to the consensus of the D&D evangelists here on c.d.t., OIDs are not always evil. There are instances when their use is clearly indicated. It certainly makes more sense to store the OIDs from an established application in a relation rather than spend thousands of man-hours rewriting the app. Anyone who argues otherwise is a fool and should be ignored. |
#85
| |||
| |||
|
|
Mr. Scott wrote: Eg., I don't think D&D object to a system that saves us effort by generating values so that we don't have to make them up, but those would be generated values, not pointers. |
#86
| |||
| |||
|
|
On 22 mei, 21:53, r... (AT) raampje (DOT) lan (Reinier Post) wrote: Just to nitpick: in OO modeling there is no such thing as an OID, presumably you mean an object reference. And just to nitpick on the nitpicking : he wasn't talking of OO _modeling_, he was talking of OO _programming_. |
|
Did you mean to suggest that OO _programming_ systems hardly ever base their operation upon OIDs ? |
#87
| |||
| |||
|
|
I believe D&D say an OID is a pointer. If that's what those amount to in the magical OO world, then you are arguing that relations should be allowed to store pointers. This would contradict the Information Principle and I'd say the whole relational idea would start to crumble. Maybe you mean something else. Eg., I don't think D&D object to a system that saves us effort by generating values so that we don't have to make them up, but those would be generated values, not pointers. |
#88
| |||
| |||
|
|
Cans of cat food can be identified solely by their location in 3D space. However, noone cares a fucking shit which particular can it was that any customer took from the shelf. Or, iow, for cans of cat food, identity doesn't matter either. Now, typical OOP systems take identity as a foundational concept, meaning no more and no less than that they are inappropriate to address any problem where "identity really doesn't matter". |
#89
| |||
| |||
|
|
All database constraints can be formulated in natural language in the form "there cannot be any x(,y,z) such that ..." |
#90
| |||
| |||
|
|
Mr. Scott wrote: ... Contrary to the consensus of the D&D evangelists here on c.d.t., OIDs are not always evil. There are instances when their use is clearly indicated. It certainly makes more sense to store the OIDs from an established application in a relation rather than spend thousands of man-hours rewriting the app. Anyone who argues otherwise is a fool and should be ignored. I believe D&D say an OID is a pointer. If that's what those amount to in the magical OO world, then you are arguing that relations should be allowed to store pointers. This would contradict the Information Principle and I'd say the whole relational idea would start to crumble. |
|
Maybe you mean something else. Eg., I don't think D&D object to a system that saves us effort by generating values so that we don't have to make them up, but those would be generated values, not pointers. I certainly would like that feature when trying to record a third-greatfather about whom I might know only a non-unique surname. It would be more accurate to distinguish the tag 'D&D' from the 'D or D' writings. When it comes to their perhaps most referenced joint writing, ie., TTM, the smaller part is about relational implementation, not theory per se, then there are optional parts about 'OO' concepts. The smaller part would be even smaller were it not for all the warnings about what not to implement. |
![]() |
| Thread Tools | |
| Display Modes | |
| |