Database Answers Operations Management

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Documents and Collections   

Back to the Data Model.
Entities are shown in Bold to provide a start to the design of the Data Model.
The Discussion Topic is :-
Subject: Documents and Collections

Data model allowing users to put collections of things into other collections? 

What would a data model look like that allows users to group individual objects and collections?
 
Similar to how Google docs lets users create different docs, then group them within a collection, 
but also lets users drag collections into other collections.
 
I’d like to do that with user-created government agency name categories. 

Example: Let user create agency names: Air Force, Marines, Navy, Army. Then let them create an 
umbrella collection called “Pentagon”, and let users drag Air Force, Marines, Navy, etc. into the umbrella collection.
 
What is complicating this, is that unlike Google docs where a doc is a discrete single object, 
user may discover smaller sub-sets of Army, and wish to categorize those within the Army name, which is not yet a collection.
 
Other example: User would like to add a new collection “Office of the President” and put OMB and Pentagon under that as equals.
 
Each user should be able to create their own collections so that multiple government department name categories exist. 
This is so that they can call their own categories that may be of a different scope than what other users need. 
A locked table would keep the official list of all agencies.
 
What would the data model look like for this?
 
I’m hoping someone else has worked on this problem, probably not with government agency names, but perhaps the same principle 
with other objects.
 
Thanks!
 
Alex Glaros


© DataBase Answers Ltd. 2012
About Us Contact Us