Table structure?

[Ruslan Zasukhin]

On 4/28/06 8:10 PM, "Joakim Schramm" <joakim at astrocalc.com> wrote:

> Hi,
> 
> I would like to ask for advice in a db/table structure question, if my idea
> I have about would matter in any sense to Valentina (VCOM).
> 
> I want to set up a db to import a lot of data from it's current source and
> have decided to go for binary links right away although it's completely new
> to me. It looks briliant though at least on paper.
> 
> Anyhow, my dataset basically consist of 2 parts, now stored in 2 tables. The
> first table has about 220 000 records and the second table has about 500 000
> records. As my current datasourse isn't relational in a true sense I link
> that bit in code now and the second table serve as something like a "lookup"
> table for items of the first table. But each item in T1 only look for data
> within a limited range of the whole data in T2, and several items can look
> for same data so one could say it's something of a M:M relation. Important
> to mention as well is that the T2 data need to be in a certain sequencial
> order, either in the db or as it's returned for evaluation (like in an array
> as it's returned now).

Also I'd like to point.
    it is NOT clear yet where you can use BinaryLink here.

The M:M relation between records, which you describe is not canonic.

The canonic MM link in relational model is built with help of third helper
table. 




-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]