Schema design

gistfile1.txt

    items {
        dl { name => DELL6400,  keyword:1 => computer, keyword:2 => DELL, keyword:3 => topseller  }
        hp { name => HP12345,   keyword:1 => computer, keyword:2 => HP    }
        no { name => Nokia8210, keyword:1 => phone,    keyword:2 => NOKIA }
    }

    // here I store keys of the items only,
    // in reality I have denormalized most of items columns
    keywords{
        computer  { webpage => www.domain.com/computer , item:dl => dl , item:hp => hp }
        DELL      { webpage => www.domain.com/dell ,     item:dl => dl }
        topseller { webpage => www.domain.com/top ,      item:dl => dl }
        HP        { webpage => www.domain.com/hp ,       item:hp => hp }
        NOKIA     { webpage => www.domain.com/nokia ,    item:no => no }
        phone     { webpage => www.domain.com/phone ,    item:no => no }
    }

=====================================================

keywords{
	computer  { webpage:dl => www.domain.com/computer , item:dl => dl ,
			webpage:dl => www.domain.com/computer ,  item:hp => hp }
	DELL      { webpage:dl => www.domain.com/dell ,     item:dl => dl }
	topseller { webpage:dl => www.domain.com/top ,      item:dl => dl }
	HP        { webpage:hp => www.domain.com/hp ,       item:hp => hp }
	NOKIA     { webpage:no => www.domain.com/nokia ,    item:no => no }
	phone     { webpage:no => www.domain.com/phone ,    item:no => no }
}