Rebuilt database

Finished rebuilding database and loading data into tables.

Need to test program tomorrow.

Created and loaded data into tables

Done:

1) Created two tables:

Stores IP numbers and locId:
CREATE TABLE ipNumbers (ipNum BIGINT NOT NULL,
locId INTEGER NOT NULL,
PRIMARY KEY (ipNum))

Stores test IP addresses and IP numbers:
CREATE TABLE testCensusIPs (ipAddr VARCHAR(15) NOT NULL,
ipNum BIGINT NOT NULL,
PRIMARY KEY (ipAddr))

2) Loaded test data into table testCensusIPs

3) Wrote Java program to test data (insert IP numbers and locId into table ipNumbers). Need debug.

Today's meeting

1) Use data from Dylan.
2) Build table to store IP addresses and their related information (eg. country, region and city).
3) Geographically Mark IP addresses on the map based on their latitude and longitude. Using different colors to distinguish among cities. Radius of a circle (or dot) marked on a city represents the amount of IP addresses located in the city.
4) Meeting next week canceled.

Corrected a typo in table location. ("longtitude" -> "longitude") :)

Read Amanda's works and programmed cities distribution

Read and tested geo.countrydistribution from Amanda's code. Designed and programmed cities distribution based on previous works.