You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@chemistry.apache.org by Petar Tahchiev <pa...@gmail.com> on 2014/05/05 14:56:30 UTC

Which type of repository.

Hi guys,

I read almost all the documentation about OpenCMIS and I also played with
the fileshare repository. However, I'm stuck on a very fundamental
question. I would like to build a repository that contains my data (cms
pages, cms articles, cms links, etc) as well as my binary data (images,
flash movies, powerpoint presentations, etc). Now, if I choose to implement
a FileShare type repository, I don't think it will fit nicely for my data,
as I will have to store the content of the article as a file and I will
lose on stuff like ACLs, relationships, indexing, etc. If I choose to use a
database repository I don't think the binary data will play well (I may end
up having thousands and thousands of pictures which will drag down the
perfomance and clutter the database).

What is the suggested solution to this problem? Do you setup 2
repositories? I read Alfresco only supports one..

Thank you for your time.
-- 
Regards, Petar!
Karlovo, Bulgaria.
---
Public PGP Key at:
https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611
Key Fingerprint: A369 A7EE 61BC 93A3 CDFF  55A5 1965 8550 C311 0611

Re: Which type of repository.

Posted by Sascha Homeier <sh...@meyle-mueller.de>.
Oops, sry I meant "Hi Petar," ;)

 …. weird to address a city :-P


Cheers
Sascha

Am 29.05.2014 um 14:46 schrieb Sascha Homeier <sh...@meyle-mueller.de>>
:

Hi Karlovo,

I hope its not too late to reply ;)

Well I am faced to same problem:
We have an existing platform which stores assets, products, projects etc.
So fileable binary objects as well as lots of metadata related to objects which again can have relationships (projects can have sub projects which can have linked assets which again can have metadata).
Our existing DAM stores the metadata, relationships ACLs etc in an Oracle DB. The assets (e.g. images in high- and low-resolution and with preview types like thumbnails associated) are stored on the filesystem.
At first I think I will map our domain model to the CMIS one, e.g. maybe our project type will be mapped to cmis:document with no content stream allowed or maybe it will be cmis:item (don't know yet).
So the CMIS fileshare sample stores everything on the filesystem: the content stream as well as the metadata in a file cmis.xml.
For our use case I thought of a mix: content stream of assets will be stored on fs and metadata will be stored in db.

These were my first thoughts but I am still in design and architecture phase and read the CMIS spec night for night ;)

So maybe design changes and my knowledge grows or maybe anyone here as a better tip ;)

Cheers

Sascha Homeier
Software-Entwickler

T. 07231-941-313
M. 0162-26 26 113
shomeier@meyle-mueller.de<ma...@meyle-mueller.de>





FEEL THE INNOVATION!(r)

Meyle+M?ller GmbH+Co. KG
Maximilianstr. 104
75172 Pforzheim / Germany
www.meyle-mueller.de<http://www.meyle-mueller.de><http://www.meyle-mueller.de>

Gesch?ftsf?hrer: Eugen M?ller (Vors.), Ingrid M?ller (stv. Vors.),
Peter Schellhorn, Norbert Weckerle
Amtsgericht Mannheim HRA 500441
PhG: Meyle+M?ller Verwaltungs-GmbH HRB 500138


Kennen Sie OnlineMASK?
Unser Portal f?r Bildbearbeitung und Freisteller:
www.OnlineMASK.com<http://www.OnlineMASK.com><http://www.onlinemask.com>

Pforzheim - die erste Stadt mit freiem WLAN an vielen Standorten!
Eine Idee von Meyle+M?ller!

Am 05.05.2014 um 14:56 schrieb Petar Tahchiev <pa...@gmail.com>>:

Hi guys,

I read almost all the documentation about OpenCMIS and I also played with
the fileshare repository. However, I'm stuck on a very fundamental
question. I would like to build a repository that contains my data (cms
pages, cms articles, cms links, etc) as well as my binary data (images,
flash movies, powerpoint presentations, etc). Now, if I choose to implement
a FileShare type repository, I don't think it will fit nicely for my data,
as I will have to store the content of the article as a file and I will
lose on stuff like ACLs, relationships, indexing, etc. If I choose to use a
database repository I don't think the binary data will play well (I may end
up having thousands and thousands of pictures which will drag down the
perfomance and clutter the database).

What is the suggested solution to this problem? Do you setup 2
repositories? I read Alfresco only supports one..

Thank you for your time.
--
Regards, Petar!
Karlovo, Bulgaria.
---
Public PGP Key at:
https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611
Key Fingerprint: A369 A7EE 61BC 93A3 CDFF  55A5 1965 8550 C311 0611



Re: Which type of repository.

Posted by Sascha Homeier <sh...@meyle-mueller.de>.
Hi Karlovo,

I hope its not too late to reply ;)

Well I am faced to same problem:
We have an existing platform which stores assets, products, projects etc.
So fileable binary objects as well as lots of metadata related to objects which again can have relationships (projects can have sub projects which can have linked assets which again can have metadata).
Our existing DAM stores the metadata, relationships ACLs etc in an Oracle DB. The assets (e.g. images in high- and low-resolution and with preview types like thumbnails associated) are stored on the filesystem.
At first I think I will map our domain model to the CMIS one, e.g. maybe our project type will be mapped to cmis:document with no content stream allowed or maybe it will be cmis:item (don't know yet).
So the CMIS fileshare sample stores everything on the filesystem: the content stream as well as the metadata in a file cmis.xml.
For our use case I thought of a mix: content stream of assets will be stored on fs and metadata will be stored in db.

These were my first thoughts but I am still in design and architecture phase and read the CMIS spec night for night ;)

So maybe design changes and my knowledge grows or maybe anyone here as a better tip ;)

Cheers

Sascha Homeier
Software-Entwickler

T. 07231-941-313
M. 0162-26 26 113
shomeier@meyle-mueller.de<ma...@meyle-mueller.de>





FEEL THE INNOVATION!(r)

Meyle+M?ller GmbH+Co. KG
Maximilianstr. 104
75172 Pforzheim / Germany
www.meyle-mueller.de<http://www.meyle-mueller.de>

Gesch?ftsf?hrer: Eugen M?ller (Vors.), Ingrid M?ller (stv. Vors.),
Peter Schellhorn, Norbert Weckerle
Amtsgericht Mannheim HRA 500441
PhG: Meyle+M?ller Verwaltungs-GmbH HRB 500138


Kennen Sie OnlineMASK?
Unser Portal f?r Bildbearbeitung und Freisteller:
www.OnlineMASK.com<http://www.onlinemask.com>

Pforzheim - die erste Stadt mit freiem WLAN an vielen Standorten!
Eine Idee von Meyle+M?ller!

Am 05.05.2014 um 14:56 schrieb Petar Tahchiev <pa...@gmail.com>>:

Hi guys,

I read almost all the documentation about OpenCMIS and I also played with
the fileshare repository. However, I'm stuck on a very fundamental
question. I would like to build a repository that contains my data (cms
pages, cms articles, cms links, etc) as well as my binary data (images,
flash movies, powerpoint presentations, etc). Now, if I choose to implement
a FileShare type repository, I don't think it will fit nicely for my data,
as I will have to store the content of the article as a file and I will
lose on stuff like ACLs, relationships, indexing, etc. If I choose to use a
database repository I don't think the binary data will play well (I may end
up having thousands and thousands of pictures which will drag down the
perfomance and clutter the database).

What is the suggested solution to this problem? Do you setup 2
repositories? I read Alfresco only supports one..

Thank you for your time.
--
Regards, Petar!
Karlovo, Bulgaria.
---
Public PGP Key at:
https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x19658550C3110611
Key Fingerprint: A369 A7EE 61BC 93A3 CDFF  55A5 1965 8550 C311 0611