Big collection with userid or small collections

[waldette]

Hello,

I want to dev an app with users, teachers, students, calendar, scheduler, etc... One user only can access to his own data, never can see other students or calendar of another user (except admin who can access to every data).

I dont know the best model for tthis app with mongodb. What is better:

1. Do every table as a little collection and put a userid key on every table

2. Do one big collection for every user and nested documents or collections for.every table.

What is the best options for a good scalable and performance?

Thanks, i hope u can gelp.me

 

[AngleWyrm]

Check out Normal Forms of table design; essentially there's two things that go into a table: The key column(s) that together uniquely identify a record, and the contents that depend exclusively on those key columns.

 

[waldette]

What? Yes, i understqnd normal forms but this not andwer my question, that i dont know what is better on my case

 

[AngleWyrm]

If a record in a column of information can be uniquely identified by using only userID, then it goes in one table keyed on userID.

For example, a person's date of birth; each userID has exactly one date of birth.
But not their children's userID -- that goes in a separate table because one user can have several children.

Users table

UserID	Name	Date of Birth
1	Mary	1/1/2000
2	Sue	1/1/1980
3	John	1/1/2005
4	Greg	1/1/1984

Children table

Parent's UserID	Child's UserID
2	1
2	3

In this example Sue is a parent of both Mary and John, but not Greg

 

[waldette]

Uff, I'm so sorry for my english. It's so hard for me explain my problem in not native language.

I have users, users can access to his data, and his data are students, teachers, shceduler, calendar, ...

This means, every user have his own data, and this data it's for app tables.

I have a mongodb, no sql.

Thanks, I hope I explained better now.

 

[AngleWyrm]

Thanks for introducing me to NoSQL databases
I like the ease of use and flexibility they offer
I'm too new to it's principles to offer any insight

 

[waldette]

SoryyAngle, I cant understand you. You are not helping me...