Keeping database Record Order
Posted on 2010-09-23
Note:Doing this in MySQL
I'm trying to determine the best possible way to keep order of information in a database. I'd like to keep connections between certain records. For example:
I have 2 major tables: tblWords, tblSentences
if I typed a paragraph and found the id of each word in the tblWords, what would be the best way to organize a tblSentences table to store these sentences in order.
Say the sentence is: "I love cats and dogs" and the corresponding ids are     .
How could i best form this sentence into a table. I haven't quite determined if I should use some form of linker table for a many-to-many relationship or not and have the each sentence have an separate id.
The same sentence can be repeated multiple times. I would maybe even like to add a paragraph table to keep order of sentences and so on.
Also, when trying to recall this information, how could you easily recall the information in the same easily based on the technique you suggest?