Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of luis.junges@gmail.com
 designates 209.85.215.52 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=j1qxsNomhBFaKKK6LN0rqCBMZ8KbNqbidneEx3HK8cpa6gv4wsQp5byKB1Ba9vOWoY
         WY5/mY6LMXwJqGUECQvLbJdeRlTN+TL1eVAmBbnreRm+EkXkmgFdAb94Z1Dw6EGYCo/U
         d3cFDQhS3JFsTu1cHRn88+/FBZ4MbDEoZWBFY=
MIME-Version: 1.0
Date: Thu, 11 Nov 2010 18:38:03 -0200
Message-ID: <AANLkTinZdCW3Q4eRqg6ydokVe0CkgTHROQ1LqoZ2bNmx@mail.gmail.com>
Subject: CouchDB model Problem
From: Luis Carlos Junges <luis.junges@gmail.com>
To: user@couchdb.apache.org
Content-Type: multipart/alternative; boundary=0016e6dd85cc5ad2770494ccf353

--0016e6dd85cc5ad2770494ccf353
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,

I would like to use couchdb for a project but i am unsure how to model it.
Basically i will have to store products and theirs respectives prices from
several  stores. So, for a product product1, for example, i will have a
price p1 for store1, a price p2 for store 2 and so on...Considering that
those prices will be updated automatically, i was thinking in something lik=
e
this:

A document for the product with all information about it with id equal to
the product reference number
example:

id:product1
name: Product 1


A document with the price and store id
id:89923848298398989d9fsd
revision:1
store:45
price:5.67
refcode:product1
updated: timestamp here


id:8992384829832938495298345
revision:3
store:46
price:3.67
refcode:product1
updated: timestamp here


My idea is that each store will update their own prices. Now the problem i
am no sure how to solve is that i can have multiple price documents with
differents ids (see example below) for the same store (a database
inconsistency). Could i use mapreduce to collect all the price documents fo=
r
a specific product  and get only the latest one based on the time is
updated. If so, how can i do that? i mean, how would be the map and reduce
function? I would also like to delete the old ones.


id:8992384829832938495298345
revision:1
store:46
price:3.67
refcode:product1
updated timestamp here


id:92839198234
revision:1
store:46
price:6.23
refcode:product1
updated timestamp here


I would appreciate any help

--=20
"A realidade de cada lugar e de cada =E9poca =E9 uma alucina=E7=E3o coletiv=
a."


Bloom, Howard

--0016e6dd85cc5ad2770494ccf353--