Thursday, September 11, 2008

mySQL troubles

After what took like ages converting the VisionBytes Data (in the form of SQL statements) into mySQL statements, and keeping all the relationships intact, I wrote a simple app to compare and retrieve the appropriate data from the database from a query (a user inputted string).

Basically, the table that is of interest is the 'segment' table. The reason for this is because it contains;


Both of which is used to determine the location of a story/topic


Both of these are necessary to create a 'Document' in the webapp of the carrot2 project.

The breakdown of a 'Document' is as follows:

Document(String title, String summary, String contentUrl)

In our case, we will replace url data with the location of the topic/story.

No comments: