Received: from elch.de.uu.net (elch.de.uu.net [192.76.144.55]) by hub.org (8.10.1/8.11.0) with ESMTP id e9G722W78288 for ; Mon, 16 Oct 2000 03:02:02 -0400 (EDT) (envelope-from DieringG@eba-haus.de) Received: from kopo001 ([149.228.241.212]) by elch.de.uu.net (5.5.5/5.5.5) with SMTP id IAA05733 for ; Mon, 16 Oct 2000 08:57:33 +0200 (MET DST) Received: from EBA_DO-Message_Server by kopo001 with Novell_GroupWise; Mon, 16 Oct 2000 08:58:17 +0200 Message-Id: X-Mailer: Novell GroupWise 5.5.2 Date: Mon, 16 Oct 2000 08:57:52 +0200 From: "Gerhard Dieringer" To: Cc: Subject: Antw: many-many mapping between unique tables Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id e9G722W78292 X-Archive-Number: 200010/141 X-Sequence-Number: 1803 >>> Indraneel Majumdar 16.10.2000 20.11 Uhr >>> > Hi, > > I am facing a problem in mapping between two tables containing unique > entries > > T1 T2 > _________ ________ > | x1 | | y1 | > | x2 | | y2 | > | x3 | | y3 | > --------- --------- > > x(i) points to 1 or more entries in T2. y(i) points to one or more entries > in T1. How do I store this mapping? I'd cannot use an array due to size > restrictions and inability to extract data easily for furthur processing. > > I don't want to put everything into a single table and repeat values in > the 2nd column since these are really huge tables and I cannot increase > overhead by increasing data redundancy. > > Is there some way to do something about this? > > \Indraneel > > /************************************************************************. > # Indraneel Majumdar ¡ E-mail: indraneel@123india.com # > # Bioinformatics Unit (EMBNET node), ¡ URL: http://scorpius.iwarp.com # > # Centre for DNA Fingerprinting and Diagnostics, # > # Hyderabad, India - 500076 # > `************************************************************************/ I'm not sure if I understand your question. Is it right, that the x(i) are different values of an column x in table T1 and the y(i) are different values of an column y in table T2? And you want to have a n:m relation between the two tables? Then you need a third table T12 with columns x and y, that contains one row for each mapping of a x(i) with a y(j). I hope this helps. Gerhard