[SERVER-8916] Is there a tool to help with drawing out and documenting the Schema. Created: 08/Mar/13  Updated: 19/Mar/13  Resolved: 08/Mar/13

Status: Closed
Project: Core Server
Component/s: Tools
Affects Version/s: 2.4.0-rc2
Fix Version/s: None

Type: Question Priority: Minor - P4
Reporter: Cormac Koegh Assignee: Gregor Macadam
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Windows


Participants:

 Description   

Wondering if there is a tool with which I can represent the schema of my application DB similar to an ERD. Would be useful as a means of specifying what the schema is and communicating same.



 Comments   
Comment by Cormac Koegh [ 11/Mar/13 ]

Thanks Norberto... but if I rely on my code as the sole means of specifying the schema it menas it is not well documented and therefore not easy to communicate to other possible users of the data ???? I think I understand the flexibility offered and can see the major advantages of that flexibility in the schema (which is the reason I am choosing MongoDB)..
Cormac

Comment by Cormac Koegh [ 11/Mar/13 ]

Thanks Scott.. I will check those discussions.

Comment by Scott Hernandez (Inactive) [ 08/Mar/13 ]

Cormac, these types of questions are best asked in the mongodb-user forum (http://groups.google.com/group/mongodb-user) where users can help answer and many answers already exist.

Here are two (possibly) related discussions:
http://groups.google.com/group/mongodb-user/browse_thread/thread/a31d8607d4b0c900
http://groups.google.com/group/mongodb-user/browse_thread/thread/c590b0126d3a794e

Many people model schema at their language with domain-objects and entities rather than at the database; there are many tools which work well there already which are independent of the persistent technology.

Comment by Norberto Fernando Rocha Leite (Inactive) [ 08/Mar/13 ]

cormackeogh@hotmail.com the best tool for modeling mongodb schema is your application.
This is one of the big differences when moving away from relational databases to mongodb, there is no schema till you find one. This actually means your application, as it evolves, the database structures evolve with it so you do not need a ERD.

If your question is more related "how can I model my schema for mongodb?" there are a couple of things we should look at:

  • Access patterns
    • How my applications stores an retrieves data from the database
  • Update data
    • How do my data structures change
    • Look for unbounded arrays
  • Polymorphism and hierarchy

among others.

Comment by Gregor Macadam [ 08/Mar/13 ]

Hi Cormac -
Let me check with an SA and get back to you.
Thanks
Gregor

Generated at Thu Feb 08 03:18:49 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.