Tiara Y.
wrote:
> Dear
Elke,
>
> I
have a question to ask regarding SAP DB. I hope you don't mind.
> I have tried email-ing sapdb.general but got rejected (it doesn't like the 'hotmail' domain).
> I need to complete my feasibility study on the possibility of implementing
> SAP DB for my company. Our company's clients needs to store lots and lots
> of large files into our db. As we know, there are many ways to store large
> files into the database. SAP supports LARGE BYTE fields for this purpose.
> In my past experience, I stored the file directly in the field, or put the
> file in the local disk and put the link in the RDBMS.
>
> However I think, Storing binary files in the large byte fields is not efficient,
> as I can read from the older archive that the interfaces (JDBC etc) are not
> optimised for large files. Meaning it would be slow.
>
> Products like Oracle iFS (internet file system) use the database to provide
> a catalogue and a secure means of storing file attachments in a file structure.
> Is it possible to do anything similar to iFS with SAP DB ?
> I have tried email-ing sapdb.general but got rejected (it doesn't like the 'hotmail' domain).
> I need to complete my feasibility study on the possibility of implementing
> SAP DB for my company. Our company's clients needs to store lots and lots
> of large files into our db. As we know, there are many ways to store large
> files into the database. SAP supports LARGE BYTE fields for this purpose.
> In my past experience, I stored the file directly in the field, or put the
> file in the local disk and put the link in the RDBMS.
>
> However I think, Storing binary files in the large byte fields is not efficient,
> as I can read from the older archive that the interfaces (JDBC etc) are not
> optimised for large files. Meaning it would be slow.
>
> Products like Oracle iFS (internet file system) use the database to provide
> a catalogue and a secure means of storing file attachments in a file structure.
> Is it possible to do anything similar to iFS with SAP DB ?
No, that is not
possible
>
Are there any 3rd party tools around that can be used for SAP
DB.
I don't know any.
But maybe the list knows...
>
Or can you recommend methods for doing this that we can code
?
If you think of a
transaction-secure method to store files outside
and store the
'catalog' for these files inside the database, you will have
no
chance.
> And as for replication, is there any 3rd party tool currently available to
> perform the replication in SAP DB ?
'Replication' is a word which is often used with
different meanings.
Did you check our tool Replication
Manager for your purposes?
And did you check our archive for
other chances to replicate database content?
> Thank you in advance.
>
> Best Regards,
>
> Tiara Y.
Elke
SAP Labs
Berlin
BTW: please try
to overcome the problem with mails to sapdb-general.
I will not answer every
mail send directly to me with questions
concerning different
topics of SAP DB.
