RE: Storing of variable float arrays in Blobs

[Israel Olalla <iolalla@xxxxxxxxxxx>]

Hello,

	We had the same approach as you... but we implement it with
Oracle.... and it goes really slow... but we dont know if the problem is
JDBC driver or how we access to the data into the blob....

	Any way we are thinking to migrate to mysql, fi you get some data
about performance we can share them....



Thanks in advanced

-----Original Message-----
From: georg ritter [mailto:georg_ritter_x@xxxxxxxxxxx]
Sent: martes, 02 de enero de 2001 18:28
To: mysql@xxxxxxxxxxxxxxx
Subject: Re: Storing of variable float arrays in Blobs


Thanks Bob,

My only concern with the foreign-key/referenced key relationship approach is

that I would end up having one row for each single datapoint, which means 
having billions of rows in one table.

I suspect that billions of rows are not really good for the performance, 
especially if I want to have a quick lookup of the whole arrays into memory.

Thanks again,
Georg
PS: Couldn't get through to your webpage, will try later again.


>From: Bob Hall <rjhalljr@xxxxxxxxxxxxx>
>To: mysql@xxxxxxxxxxxxxxx
>Subject: Re: Storing of variable float arrays in Blobs
>Date: Fri, 29 Dec 2000 09:57:58 -0500
>
>>I have to build a database that can store scientific measurement
>>data as variable float arrays.
>>The requirements are that I have to store millions (!) of those
>>arrays, each having a different size: arr[dim1][dim2] with
>>2<=dim1<=8 and 1<=dim2<= 512.
>>
>>My idea is to pack those arrays into binary packets and store them
>>as blobs. Is that a good idea?
>>Some other databases offer variable multi-dimensional arrays, but I
>>couldn't find any information on this for mySQL.
>>
>>Is there any other way of doing this?
>>Am I on the right way?
>
>Sir, I can't tell you if your approach is the best one for your
>application. I can tell you that relational databases usually store
>multidimensional data in normalized tables linked through foreign
>key/referenced key relationships. There's more information at my
>website: http:/users.starpower.net/rjhalljr. Click on MySQL on the
>sidebar, and then select the Relational Database Concepts page.
>
>Bob Hall
>
>Know thyself? Absurd direction!
>Bubbles bear no introspection.     -Khushhal Khan Khatak
>
>--
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/documentation/manual.php"; before
>posting. To request this thread, e-mail mysql-thread60172@xxxxxxxxxxxxxxx
>
>To unsubscribe, send a message to:
>    <mysql-unsubscribe-georg_ritter_x=hotmail.com@xxxxxxxxxxxxxxx>
>
>If you have a broken mail client that cannot send a message to
>the above address (Microsoft Outlook), you can use:
>    http://lists.mysql.com/php/unsubscribe.php
>

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com


-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php"; before
posting. To request this thread, e-mail mysql-thread60403@xxxxxxxxxxxxxxx

To unsubscribe, send a message to:
    <mysql-unsubscribe-israel.olalla=newknow.com@xxxxxxxxxxxxxxx>

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
    http://lists.mysql.com/php/unsubscribe.php

This message and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
No confidentiality or privilege is waived or lost by any wrong transmission.
If you have received this message in error, please immediately destroy it
and kindly notify the sender by reply email.
You must not, directly or indirectly, use, disclose, distribute, print, or
copy any part of this message if you are not the intended recipient.
Opinions, conclusions and other information in this message that do not
relate to the official business of Newknow shall be understood as neither
given nor endorsed by it. 


-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php"; before
posting. To request this thread, e-mail mysql-thread60406@xxxxxxxxxxxxxxx

To unsubscribe, send a message to:
    <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
    http://lists.mysql.com/php/unsubscribe.php