| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: The OverRelational Manifesto. VOCIFEROUS IGNORANCE vs. NUMB DOGMA.(the sequel)
U-gene schrieb:
>> Do you mean by "object's component" a field?
>> If so then nothing prevents me from having an explicit declaration of
>> all relations and then using set-valued attributes via "SET OF" keyword,
>> for example:
>>
>> MyType {
>> INT myIdentifer;
>> DOUBLE balance;
>> } CONSTARIN myIdentifer Key
>>
>> and then we write
>>
>> SHIPMENT {
>> ...
>> Items SET OF MyType;
>> ...
But in this example field SetValuedField is one-valued. In order to define it as a set-valued component we need to define it as follows:
ObjectType2 {
...
SetValuedField AS SET OF MyType;
...
}
On the other hand, you noticed above that it is wrong. I am feeling that I am lost... If
SetValuedField MyType;
should be a set-valued property then how can we define a single-valued property?
Let us consider a simple task. An order is characterized by a set of (ordered) product items AND by one product item (say, it is the main item or an item to be delivered first):
ORDER {
orderId INT;
...
items AS SET OF ITEM; // Ordered products
mainItem ITEM; // The main product
...
}
ITEM {
itemId INT;
...
price DOUBLE;
...
}
Could you show how this could be described using your approach (object
types vs. valued types etc.)? In particular, how can I define two
properties taking values from one domain:
- a single-valued property, and
- a multiple-valued property
If this example is not very appropriate then probably you can modify it in order to clarify the following issue:
I mean that we used to define types of *entities* as a number of *properties* which can be either *one-valued* or *set-valued*. In your approach we introduce more basic notions and I am not able to construct an example which would demonstrate their importance and advantages.
> In any cases you can use "MyType" repeatedly. Why not?
>
> RxO system works with something, what is more complex than single
> relation. The only thing exists in RDM what is more complex than single
> relations - is is set of relations. But each of these relations is
> usual relation as it is defined in RDM and each relation can be defined
> in any way if the result of this definition is true relation.
>
-- http://conceptoriented.comReceived on Mon May 29 2006 - 10:28:57 CDT
![]() |
![]() |