Simple database question: tags

[Ruslan Zasukhin]

On 8/6/07 6:25 PM, "Andre Garzia" <andre at andregarzia.com> wrote:

> google uses a filesystem... yes, that's no relational database. It's
> not like GoogleSQL it's more like GoogleFS.
> 
> David,
> 
> First try to learn basics of SQL, you can go to W3Schools Learn SQL
> page <http://www.w3schools.com/sql/default.asp> then you can try using
> RevSQL or Valentina to play with SQL commands.
> 
> What I do in your case was to have three tables
> 
> Table 1: the data.
> In this table I'd hold the data, the real data, like in case of reddit
> or delicious is the URL.
> 
> Table 2: the keywords
> In this table I hold metadata, one entry per keyword, all unique.
> 
> Table 3: relationship between table 1 and 2.
> This table just maps relationships between keywords and data, this
> allows me to have a many-to-many relations where I can map a single
> keyword like 'oranges' to many items such as all the products that are
> orange-like and to map one product like 'maltese orange' to various
> keywords such as 'make-nice-soft-drink', 'orange',
> 'expensive-outside-malta'.

You can see PICTURE with example of such design right on this page:

http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documen
tation:vkernel:vlink:mm_table_to_binarylink

See FIRST picture on page


-- 
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]