File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Accessing Files on a remote server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Accessing Files on a remote server" Watch "Accessing Files on a remote server" New topic
Author

Accessing Files on a remote server

T Dreezy
Greenhorn

Joined: Jan 25, 2011
Posts: 6
Hi all,

I'm thinking of developing an application in which users can upload/download files (of any type) from a database on a remote server. Any ideas as to which database program I should look at?
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3704
    
    5

While databases can handle files, as binary items (blobs), its not generally a good practice. One of the problems with putting files in the database is that they often outweigh the structured data, making the database difficult to work with. In general, files aren't good places for databases because they are completely unstructured. The database can't normalize, index, or do much with binary data other than store it. There are some exceptions to the rule, but if the files are large enough, or you are allowing arbitrary sized files, its better to manage them in a file system.


My Blog: Down Home Country Coding with Scott Selikoff
T Dreezy
Greenhorn

Joined: Jan 25, 2011
Posts: 6
Thanks,

Do you have any recommendations for a software that helps do this?
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3704
    
    5

Software? Do you mean using JDBC or accessing a database directly? Also, you may have missed my point that putting lots of files in a database is often a bad practice.
T Dreezy
Greenhorn

Joined: Jan 25, 2011
Posts: 6
Sorry I'm a total noob at this lol

I understood your earlier point that putting lots of files in a database is not recommended, and managing them in a file system is a better option.

My question is are there any tools out there that help in this file system management, or is this done manually through coding?
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3704
    
    5

Oh, I misread too. Often, managing files is done manually through coding although there are document management systems like Documentum, SalesForce, etc, but these usually for enterprise-level solutions. If you're developer a Google AppEngine project, it has its own method of managing files.
T Dreezy
Greenhorn

Joined: Jan 25, 2011
Posts: 6
OK Thanks!
chris webster
Bartender

Joined: Mar 01, 2009
Posts: 1649
    
  14

T Dreezy wrote:Hi all,
I'm thinking of developing an application in which users can upload/download files (of any type) from a database on a remote server. Any ideas as to which database program I should look at?


Depending on the type of files you are storing, would MongoDB help? Haven't used it myself, but I've seen various references to it being used by newspapers as a document management system.


No more Blub for me, thank you, Vicar.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Accessing Files on a remote server