On 8/6/07 6:25 PM, "Andre Garzia" <[EMAIL PROTECTED]> 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] _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
