Re: distributed database with multimedia data

This can be easily done using nothing but standard PL/SQL in Oracle and the built-in DBMS_LOB package with a few database links.

I would expect that Sybase has similar capabilities but I don't know for sure.

Daniel Morgan

=/\\= Majki =/\\= wrote:

> Hi!
> As a student project I have to create distributed database which serves
> multimedia. It must be possibility to extent SQL funtions, by writing my own
> functions with C, java or other language. Database will contain midi files,
> and new functions should add possibility to extract some information from
> this files. For example: user asks database about songs which use instrument
> named 'piano', but there is no such data in database, only midi files. These
> files could be stored as BLOB. New function would analize data stored in
> BLOB and return records which match.
> The most important is that it must be distributed database. There should be
> one main server and a few other servers. User sends SQL question to main
> server. Main server checks which servers are online and sends them this
> question, next it receives answers and sends them to the user. I mean there
> is no replication. There is no server which have all data.
> Is it possible to do such database using Sybase or Oracle ?
> What programs, utilities etc. should I use ?
> Could someone help me please ? It is very important to me.
Received on Mon Apr 15 2002 - 13:21:26 CDT