topic Re: Hierarchy of Filecontentstore in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/hierarchy-of-filecontentstore/m-p/17662#M7974 <HTML><HEAD></HEAD><BODY><SPAN>Alfresco stores its meta-data about files and nodes in the database. It stores the file content in a nested structure on the filesystem.</SPAN><BR /><BR /><SPAN>It is our belief that it is better to use the most appropriate system for the job, e.g. the database is best for storing structured row-based data, and the filesystem is best for storing lumps of binary data such as file content.</SPAN><BR /><BR /><SPAN>The directory structure used on the filesystem exists to help break up the (potentially huge) number of files in the system into multiple directories. Also the filesystem cannot handle some characters for names of objects that the database can - e.g. the *\/" characters will upset the filesystem if used in a filename etc. where as if we store the meta-data about the files in the database we can use any characters for object names.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><BR /><SPAN>Kevin</SPAN></BODY></HTML> Tue, 15 Nov 2005 15:02:37 GMT kevinr 2005-11-15T15:02:37Z Hierarchy of Filecontentstore https://connect.hyland.com/t5/alfresco-archive/hierarchy-of-filecontentstore/m-p/17661#M7973 When I saw the file content store I found that its hierarchy is based on date but not the logical relationship between the contents. Could somebady explain for me why alfresco don't use file system structure to map the logical relationship between the contents? What I mean is to use directory to map Mon, 14 Nov 2005 20:32:22 GMT https://connect.hyland.com/t5/alfresco-archive/hierarchy-of-filecontentstore/m-p/17661#M7973 olive 2005-11-14T20:32:22Z Re: Hierarchy of Filecontentstore https://connect.hyland.com/t5/alfresco-archive/hierarchy-of-filecontentstore/m-p/17662#M7974 <HTML><HEAD></HEAD><BODY><SPAN>Alfresco stores its meta-data about files and nodes in the database. It stores the file content in a nested structure on the filesystem.</SPAN><BR /><BR /><SPAN>It is our belief that it is better to use the most appropriate system for the job, e.g. the database is best for storing structured row-based data, and the filesystem is best for storing lumps of binary data such as file content.</SPAN><BR /><BR /><SPAN>The directory structure used on the filesystem exists to help break up the (potentially huge) number of files in the system into multiple directories. Also the filesystem cannot handle some characters for names of objects that the database can - e.g. the *\/" characters will upset the filesystem if used in a filename etc. where as if we store the meta-data about the files in the database we can use any characters for object names.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><BR /><SPAN>Kevin</SPAN></BODY></HTML> Tue, 15 Nov 2005 15:02:37 GMT https://connect.hyland.com/t5/alfresco-archive/hierarchy-of-filecontentstore/m-p/17662#M7974 kevinr 2005-11-15T15:02:37Z