Simple database question: tags
sunshine at public.kherson.ua
Fri Jun 8 12:46:59 CDT 2007
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.
> 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',
You can see PICTURE with example of such design right on this page:
See FIRST picture on page
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
[I feel the need: the need for speed]
More information about the use-livecode