From: Schroeder, Alexander (alexander.schroedersap.com)
Date: Thu Feb 19 2004 - 04:19:06 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello,

> we have some application, which is originaly written with
> Oracle DB, and we
> would like to port it to some smaller db for smaller customers :)

That's fine! Perhaps the Oracle SQL Mode of MaxDB may help you a little
in porting the application.

> So, I am looking for some possible RDBMS.
>
> I would like to know, how the MaxDB works with binary large
> objects.
> It is
> efficient for it, when, for smaller cient, will save to the db binary
> files (as a MS office documents, multimedias etc), by
> estimation, about
> <1-2G files? will the MaxDB works or will congest itself? How
> it is robust
> - what is your experiences?

MaxDB has the LONG BYTE type for binary data, and the LONG ASCII/LONG UNICODE types
for character data. Both can grow up to 2GB in the content.

> Next question, have MaxDB some fulltext tool usable for clobs - can I
> searching the content of pdfs, docs etc, saved as clog in db? May be
> comercial :)

There is no such thing like indexing/searching in LONG data
within MaxDB, sorry.

>
> Next - have MaxDB implemented some procedural language (as
> Oracle's Pl/SQL,
> Java, etc?)

There is the possibility to create DB Procedures written in a procedural
language - please e.g. look at

http://www.mysql.com/documentation/maxdb/a7/41ee11605911d3a98800a0c9449261/content.htm

for the syntax.

Regards
Alexander Schröder
SAP DB, SAP Labs Berlin

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]