Database Project: Bookmarks Database

This project reads the bookmarks from your browser and stores it in a database. The bookmark database consists of:

users table

  • userid
  • name
  • email

Bookmarks table

  • UserId
  • Title
  • URL
  • tags ( a list of comma separated tags)
  • Share (boolean - Yes or No)

This can be a desktop application or a web application:

0. User logs in (uses email and password previously assigned)

1. Application displays a text box with a browse button

2. User can locate the bookmark and upload it

3. All the bookmarks are displayed in a table

4. Each bookmark has two check boxes - one to import another to share

5. User marks the bookmarks to be imported (and a subset of them to be shared with others) and chooses Store in database

6. These bookmarks are written to the database with the user id. If it can be shared, the shared column is set to true

References:

1. Netscape bookmarks file format

2. Exporting Favorites/Bookmarks from Internet Explorer

3. Locating bookmarks file in Netscape, Mozilla, Firefox

Posted in bookmarks, dbproject, nttf, rdb on August 27th, 2007 by Dorai | | 0 Comments

Word Analyzer

Analyze the first words of sentences and create a frequency table. The number of distinct words is supposed to be around 2000 according to this paper.

* The program takes text file and performs an analysis of sentences

Rules for detecting the first word of a sentence.

1. First word in a paragraph (how do you find a paragraph in a document independent format)?
2. First word in a sentence (any word following - period, ? or ! etc.)

Components:

* A simple text parser
* First word detector
* Associative table (automatically updates count for duplicate words)

Follow on projects:

1. Analyze n words at the beginning of a sentence
2. Analyze sentence lengths
3. Domain specific implementations - for different fields/industries

Applications:

* Concept extraction
* Fact database for AIML
* Analysis of writing
* Signature detection

Link Summary:

http://www.idealliance.org/papers/extreme/proceedings/html/2007/Freese01/EML2007Freese01.html

Posted in nlp, parser, size:small on August 27th, 2007 by Dorai | | 0 Comments

Database Project: Contacts Database

A simple database project is a contacts database.

Skills required for the project:

  • Java Programming
    • JDBC API
  • SQL (create table, insert, delete, update, select, parameterized queries)
  • For Web Cleint
    • JSP Development
    • HTML Forms
    • Servlet Programming
  • For Desktop Client
    • Swing

Here is what you need.

1. A database engine (MySQL, Postgres SQL or any other open source relational database)
2. JDBC driver for the database you select
3. A simple command line or GUI front end for creating/dropping/altering tables, views
4. A simple tool for query (may be same as 3)
5. A servlet engine (Tomcat acts as both a web server and servlet engine)

We can do this in four simple milestones.

Contacts Milestone-1

1. Create one table with the following columns:

  • Name
  • emailid
  • phone

2. Create a simple Java application to

  • Add a record using a Form
  • View a set of records, select one and update any of the fields
  • Sort the list of contact by name

3. Create a simple web application with the same functionality as 2.

  • In this web application, the swing form will be replaced by a HTML form
  • Events will be replaced by JavaScript events
  • Use JSP for the server side

Contacts: Milestone2

Modify the contacts table to add the following:

1. imtype (instant messenger type - yahoo, skype, gtalk, aim, irc, msn messenger)
2. imid (the userid for instant messenger)
3. Street-1
4. Street-2
5. City
6. State
7. Pin-Code

Now you have a full contacts table with all the details

Create both the Spring and HTML interface to this extended table to incorporate all the new columns added

Contacts: Milestone3

In this milestone, we will add another table called relationships. Let us assume the emailid of a contact as the unique id.

Change the contacts table to include a password field (right now we will keep the password visible)

Here is the list of columns for Relationships:

  • emailid-1 (contact’s unique identifier)
  • emailid-2 (second contact’s unique identifier)
  • relationship (friend, family, teacher, other)

This table is used to specify a relationship of contact to another.

Additional User Interface Forms:

1. Create a login form

2. Let a user login with emailid and password

3. Create these menu items - View Contacts, MyProfile, Manage Relationships

4. View contacts lets you browse through contacts

5. My Profile displays your information (using the emailid at the time of login) and update any values (except email)

6. Manage Relationships allows you to display a list of contacts and specify a relation ship (you can do this by creating three checkboxes one for each type of relationship). If you want to restrict it to only one relationship, you can use radio buttons instead.

7. Modify MyProfile to display both your contact details and the list of relationships in a table below.

Posted in dbproject, nttf, rdb, rdf, size:small on August 26th, 2007 by Dorai | | 1 Comments