Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account
List archives

Thinking different - Schema Design for Users, Items, Tags

A way to 'trim' an array in a document
(26 lines)
Load average max on ec2 micro instance
(31 lines)
Oct 17, 2010
Sven Tilburg
Sven Tilburg
Hi

one of the most challenging parts of switching from MySQL to Mongo is 
giving up thinking in relational design pattern the way I have done it 
the last 25 yrs or so...maybe someone can tell me if I am on the right 
track here:

Let's say we have a very common application with Users / Items and Tags. 
User should be able to add items and tag them.

I am sort of referring to this article here: 
http://tagschema.com/blogs/tagschema/...latedness-in.html



When I think about this I tend to design it with 3 collections (user, 
items, tags) and having in each of them sub-arrays with object-ids. 
would this "normalized" approach be the correct one? Or am I just 
thinking in old patterns?

Thanks

Sven











Reply
Tags: relational designdesign pattern
Messages in this thread
Thinking different - Schema Design for Users, Items, Tags
Similar Threads
Schema design
I am working on a schema design for Hypertable. I would like to know trade-off between schema designs. A schema with single column family with single column and the information will be stored as JSON/XML format (key value format). In that case…
DB Schema Design
This is my very first MongoDB database that will be going into production and I wanted to make sure I did it right. It's a e-commerce store front end (transactions will be through Google Checkout) where textures (like on http://lostandtaken.com)…
schema design / visibility of documents
I'm trying to figure out how to model documents that can only be seen by certain user _ids, where that set can get large. This works out, I think, to be simliar to the voting example in The Definitive Guide. But I'm not sure I can make that work.…
realize users based on tags
Hello All, Can someone share their syntax on how they'd realize users based on tags? Thanks, Henry
About CAP theorem and Riak way of thinking
Hi everybody, Not really a technical question, i'm thinking about CAP theorem and the Riak way of thinking. CAP theorem says : "You can't get Consistency, Availability and Partition tolerance at the same time" It's advised to pick two of…
Auto reloading schema (WAS: Re: [ApacheDS] Cannot enable custom schema such as mozilla schema)
On Thu, Sep 16, 2010 at 9:50 AM, Kiran Ayyagari <kayya### @apache.org>wrote: > On Thu, Sep 16, 2010 at 12:14 PM, <mcto### @gmail.com> wrote: > > Aha! That worked when I copied the connection object in Studio. But the >…
Updated: (HIVE-12) Point users to hive-users@publists.facebook.com instead of athusoo@facebok.com in
[ https://issues.apache.org/jira/browse/HIVE-12?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-12:
Created: (GERONIMODEVTOOLS-662) update old schema files in st.schema and JAXB model for changed sche
update old schema files in st.schema and JAXB model for changed schema files
Assigned: (PIG-767) Schema reported from DESCRIBE and actual schema of inner bags are different.
[ https://issues.apache.org/jira/browse/PIG-767?page=com.atlassian.jira. plugin.system.issuetabpanels:all-tabpanel ] Alan Gates reassigned PIG-767:
Closed: (DIRSERVER-1210) Make the core-plugin (schema) generating mojo produce schema constants file
[ https://issues.apache.org/jira/browse/DIRSERVER-1210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kiran Ayyagari closed DIRSERVER-1210.
Resolved: (PIG-542) pig gets confused about schema, when joining a table that has a known schema wit
[ https://issues.apache.org/jira/browse/PIG-542?page=com.atlassian.jira. plugin.system.issuetabpanels:all-tabpanel ] Alan Gates resolved PIG-542.
Updated: (PIG-542) pig gets confused about schema, when joining a table that has a known schema with
[ https://issues.apache.org/jira/browse/PIG-542?page=com.atlassian.jira. plugin.system.issuetabpanels:all-tabpanel ] Alan Gates updated PIG-542:
Closed: (PIG-542) pig gets confused about schema, when joining a table that has a known schema with
[ https://issues.apache.org/jira/browse/PIG-542?page=com.atlassian.jira. plugin.system.issuetabpanels:all-tabpanel ] Alan Gates closed PIG-542.
Planning some tags, and more tags
I'd like to spend the next two weeks or so looking for the low hanging fruit, and tag 2.0.64 as something close to a final tarball in very early October so it's truly out of sight, out of mind by ApacheCon. Of course I'd love help - does 2 weeks…
Re: Cannot enable custom schema such as mozilla schema
Ah... I assumed the relevant function was the refresh button on the edit menu, and I also assumed that the schema would be reloaded automatically each time you make a connection. This behavior seems non-intuitive, and because the Connection…
Re: Cannot enable custom schema such as mozilla schema
On Thu, Sep 16, 2010 at 12:14 PM, <mcto### @gmail.com> wrote: > Aha! That worked when I copied the connection object in Studio. But the > original one still doesn't work. Is this some sort of client-side caching > problem in…
Re: Cannot enable custom schema such as mozilla schema
Aha! That worked when I copied the connection object in Studio. But the original one still doesn't work. Is this some sort of client-side caching problem in Eclipse? On 16/09/10 4:32 PM, Kiran Ayyagari wrote: > On Thu, Sep 16, 2010 at 3:54…
Re: Cannot enable custom schema such as mozilla schema
On Thu, Sep 16, 2010 at 3:54 AM, <mct### @gmail.com> wrote: > Hmm that's very strange. Our environments appear to be identical. Is there > anything else I would have to do in server.xml or anywhere else that is > non-default, in…
select unique items
MySQL query: select distinct message from messages where to = 123 or to = 234 order by dateAdded limit 100, 10 Is there equal query for Mongo?
Re: Issue 145 in memcached: Items are recycled to soon
Comment #2 on issue 145 by bjourne: Items are recycled to soon http://code.google.com/p/memcached/issues/detail?id=145 Well, I wrote this little script to reproduce it: from memcache import Client from random import randint, sample from string…