Re: Object-relational impedence

From: Dmitry A. Kazakov <mailbox_at_dmitry-kazakov.de>
Date: Thu, 6 Mar 2008 19:38:53 +0100
Message-ID: <10kmp3nfsz1is$.1x496d54z485.dlg_at_40tude.net>


On Thu, 6 Mar 2008 15:20:48 +0000, Eric wrote:

> On 2008-03-05, Dmitry A. Kazakov <mailbox_at_dmitry-kazakov.de> wrote:

>> On Wed, 5 Mar 2008 12:12:47 +0000, Eric wrote:
>>
>>> On 2008-03-04, Dmitry A. Kazakov <mailbox_at_dmitry-kazakov.de> wrote:
>>>> On Tue, 4 Mar 2008 20:26:01 +0000, Eric wrote:
>>>>
>>>>> That's what I said - logically possible criteria.
>>>>
>>>> What about things which cannot be spelt in SQL?
>>>
>>> Use the query language (not necessarily SQL) to pass the data to
>>> something that can deal with it.
>>
>> This does not equate to "logically possible criteria." It is "something
>> that can understand this."
> 
> My statement had two parts, they are about different things both interacting
> with the same data. Why are you trying to claim that I said the two parts
> are the same, just so you can say they are different?

I didn't. I just asked for a specification of "any logically possible criterion" to give you enough rope to hang yourself.

>>>> What about response times?
>>>> Can you specify/guess an upper bound for all requests? For a certain subset
>>>> of?
>>>
>>> This is just a prejudice - get the right RDBMS and the right expert to
>>> tune it (specifically for what it must do, not generically) and you
>>> might be surprised.
>>
>> This is not a prejudice, this is the point. I don't want to be surprised.
>> Engineering is about predictability.

> 
> The surprise is you discovering something you did not know, it is not
> part of the engineering of the problem or the solution.

Discovering new things is called research. If I were at a university I would enjoy surprises, but then RDBMS would draw my attention even lesser than now.

>>>>> Relative to what? Where are the tests? Do you install an RDBMS product
>>>>> and just go with whatever myths you have heard lately, or do you get a
>>>>> product specialist to sort it out?
>>>>
>>>> Come on, show me the nearest neighbour search in ten-dimensional space
>>>> implemented in RDBMS. What would be the complexity of? You should clearly
>>>> understand that it is possible to break the neck of *any* indexing method.
>>>> This refutes the argument to "any logically possible criterion.".
>>>
>>> But I don't believe that an RDBMS can do everything. I would not be
>>> surprised to find the data defining the ten-dimensional space in an
>>> RDBMS, but I would never expect to do such a calculation in the query
>>> language.
>>
>> From this I conclude incompleteness of the approach. There is nothing bad
>> in that. At this point you should have said, "OK, how could we reason about
>> the applicability of this approach (and other approaches)." A framework
>> where that could be done is that common ground where c.d.t. and c.o. would
>> unite.

> 
> No-one but you ever said that the approach was complete, and you seem to
> have said that only to argue against it.

You already said that. But you didn't confirmed understanding the implications I wrote about.  

>>> Other than that, you have just demonstrated a lack of understanding of
>>> the difference between the logical and the physical. It is possible for
>>> me to collect the necessary bits of technology to transfer a piece of
>>> music from a CD-ROM to a disc or cylinder for the wind-up phonograph. It
>>> is still the same piece of music.
>>
>> No. Any logical is physical on another abstraction level. Ants do not
>> listen to music. Information does not exist without a receiver.

> 
> False, unknown, false. I might admit that information is not useful
> without the possibility of a receiver, but I don't see that it gets us
> anywhere. And I thought we were talking about data, not information.

In your other post you said that data is a belief. So information must be another one, even more fuzzy and thus requiring a greater portion of mysticism...

>>>> The system does not keep anything it exists and behaves.
>>>
>>> But it has inputs and outputs. There may also be a need for it to record
>>> some of its behaviour. There may be a reason to keep some of the
>>> outputs, or even the inputs (for later extended analysis?). If you have
>>> a system that genuinely keeps nothing, I have no argument with how you
>>> choose to create it, as long as it works.
>>
>> No you get me wrong. Of course we do logging, in fact a lot of. The system
>> behaves as if it "kept" things. Whether it physically keeps them is an
>> implementation detail. Consider sine. Does it keep its output? It is a
>> meaningless question. You can tabulate sine and keep the table, you can use
>> Chebyshev's polynomials, or you can ask an oracle. It is no matter. Sine is
>> a behavior of real numbers.
>
> And you never analyse those logs? Anyway, you could, so they are data.

How one follows from another?

> Sine is not a reasonable example, nor is it a behaviour. It is a
> mathematical function, a mapping. How can a mapping keep anything? But a
> computer program can keep the number that it passes in to an
> implementation of sine, and the number that it gets back. They are data.

Let I store all these data in a RDBMS, would in be same data but different sine? Does SELECT y FROM sine WHEN x= behave differently from sine?

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de
Received on Thu Mar 06 2008 - 19:38:53 CET

Original text of this message