Ambiguity related to alfresco database.

[amit_wmw]

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 server?

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.

Thanks
Amit.

[t_broyer]

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.

[amit_wmw]

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.

[mrogers]

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

[amit_wmw]

Great! Thanks Rogers for your help!

Amit

[amit_wmw]

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.