relational db storage and search

Expand Post »

hello everyone
i'm new to this site and i'd like help in any form with a project i'm about to undertake. i would like to store .doc files in a database and retrieve them with the aid of a search string to be input by varying users (basically a search on a relational database) any form of help would be appreciated.

ps: i've used mysql for with java and php (only for report generation though) but i need java related help. on the best way to retrieve results from my database based on random search queries.

Similar Threads

Coders Can be Frugal When They Use Krugle in Search Engine Optimization
Saving a binary search tree in C++
Unwanted search bar at bottom of screen in Viruses, Spyware and other Nasties
SQL search query in PHP
assignment help [fstream, on modifying a record in a file] in C++

ajliveson

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Feb 2010

Permalink

May 17th, 2010

Re: relational db storage and search

you should avoid storing the .doc files in the database to minimize the size of the DB. You should however store the url to the file you wish to associate with that row.

tyson.crouch

Reputation Points: 16

Solved Threads: 17

Junior Poster

Offline

150 posts
since Apr 2010

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: Transfer csv files into a mysql database

Next Thread in MySQL Forum Timeline: how to select null values in condition

DaniWeb Message

Cancel Changes

User Name
Password