UNC
School of Information and Library Science
INLS760 – Web Databases, Spring 2008
INLS 760

Main Page

Announcements

Calendar/Notes

Assignments

Links

Course Policies

Grades

In-Class Exercise #5

Database search

Create a table with fields for:

  • authors
  • title
  • year
  • url
  • abstract
The table should have one index on the authors and abstract fields.

Enter information into the table from the following arXiv.org pages:

  • http://arxiv.org/abs/0802.3483
  • http://arxiv.org/abs/0801.4423
  • http://arxiv.org/abs/cs/0405078
  • http://arxiv.org/abs/0803.0053
Clean the text of the web page in PHP and store the entire text of the page in the abstract field. Manually extract the authors, title, year, and URL to include in the table.

Try out several searches using LIKE and MATCH in the MySQL interface.