Planning on building a Folder based structure in Java.
I will be using a jquery plugin for the GUI, so I don't need need information on how to display the folder structure.
I am looking for the backend logic on how folder information is stored, such that it can be retrieved in a quick and efficient manner.
Each folder will have multiple subfolders. From a leaf folder, we should be able access the root quickly and efficiently
Example:
+Folder1
|__SubFolder1_1
|__SubFolder1_2
|_SubSubFolder1_2_1
|_
+Folder2
|__SubFolder2_1
|_SubFolder2_1_1
|_SubFolder2_1_2
|_SubFolder2_1_2_1
New folders could be added randomly. Folder can be renamed. Folders can be deleted.
My Question is:
How would these folder details be stored in the database?
Again, I am looking for a fast and efficient means of storing and retrieving this information.