• If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Whenever you search in PBworks, Dokkio Sidebar (from the makers of PBworks) will run the same search in your Drive, Dropbox, OneDrive, Gmail, and Slack. Now you can find what you're looking for wherever it lives. Try Dokkio Sidebar for free.


Spring 2014 COP4709 Assignment 12

Page history last edited by Dr. Ron Eaglin 8 years, 9 months ago

 Assignment 12 - Full-Text Indexing




Learn to use Full-text indexing to enhance query




You will be using your menu database.


1. You will need to add about 4-5 menu groups and at least 4 items per group.


2. You will create a full text index on the item descriptions.


3. Demonstrate a full text query that returns all items that contain two search items such as "Delicious" AND "Spicy". The return should be organized by menu group, with the items in that group that match the full text pattern displayed with their descriptions.


Create a word (or pdf) document that has the query, approach, and results of your query.





Estimated Completion Time


 The query will not take long once you figure it out, getting the data into the database will probably take longer.


Supporting Lectures 


Topic - Full Text Indexing


Questions and Answers




External Resources




Grading Criteria




Comments (0)

You don't have permission to comment on this page.