topic Re: Ambiguity related to alfresco database. in Alfresco Archive

Ambiguity related to alfresco database.

amit_wmw — Tue, 18 Nov 2008 08:42:00 GMT

Hello Have a very basic question..When we upload a file(as a content) in repository, where does it actually gets saved? In DB or in alf_data directory? Or a part of content gets saved in alf_data and rest in DB? If that is the case which part is saved in DB and which in alf_data folder of alfresco s

Re: Ambiguity related to alfresco database.

t_broyer — Tue, 18 Nov 2008 09:57:12 GMT

Have a very basic question..When we upload a file(as a content) in repository, where does it actually gets saved? In DB or in alf_data directory? Or a part of content gets saved in alf_data and rest in DB? If that is the case which part is saved in DB and which in alf_data folder of alfresco server?

The metadata live in the DB while the bytes are stored in "alf_data". The name of the file in alf_data is stored in the DB as the "cm:content" property.

Can we able to the physically see files or at least metadata of files in either alf_data or DB? So that I can delete file (content) without using of Alfresco WCM GUI.

Do not try to do this: the content is also indexed for searches, so deleting bits in the DB and bits in the filesystem is not enough to get rid of a document.

Re: Ambiguity related to alfresco database.

amit_wmw — Tue, 18 Nov 2008 11:12:49 GMT

Thanks Bro!

Any idea if we can save everything in DB without using file system? If so, what all and where all we need to do modification/s?

regards
Amit.

Re: Ambiguity related to alfresco database.

mrogers — Tue, 18 Nov 2008 12:00:34 GMT

Storing the content in a BLOB is a topic that has already been discussed in these forums.

There are performance concerns with the approach but nevertheless the following thread implies that some people have working implementations.
e.g. http://forums.alfresco.com/en/viewtopic.php?f=4&t=6603&p=40480

Re: Ambiguity related to alfresco database.

amit_wmw — Tue, 18 Nov 2008 17:13:50 GMT

Great! Thanks Rogers for your help!

Amit

Re: Ambiguity related to alfresco database.

amit_wmw — Wed, 19 Nov 2008 06:57:21 GMT

I have some questions on above said quote:

The metadata live in the DB while the bytes are stored in "alf_data". The name of the file in alf_data is stored in the DB as the "cm:content" property.

1) Can anyone also please clarify that when I save a file as a content in which table of database the metadata gets saved?

                                                                       OR

   In how a many parts a content (uploaded file by user) is broken into and in which all folders of alf_data does it gets scatters, then how these broken peices are linked to DB (in which all table)? In brief I mean relationship between alf_data and alfresco DB?

2) Is it possible to create my own table in alfresco DB and save my content in that table?

Thanks
Amit.