Test

Done:

1) Changed DECIMAL to BIGINT for startIpNum and endIpNum in table blocks

2) Tested cities in Nova Scotia. It returns 206 distinct cities in Nova Scotia, including Wolfville.

Create tables and load data into database

Done:

1) Solved the problem which I got yesterday. Thanks to Darcy and Dylan.

2) Create two tables: blocks and location. Due to the oversized integer of startIpNum and endIpNum in blocks, I used DECIMAL(10,0) as their data type instead of INTEGER.

3) Load csv files into database. Need to delete all double-quote from the original files, then load into database. (Thanks to Darcy)

Need to test all cities in Nova Scotia tomorrow.

Setup database

Here are what I have done today:

1) Created a new database named GEOCITY in server machine

Problems:

1) Got a problem while I was creating tables in database. For example, typing the query: db2 CREATE TABLE blocks (startIpNum INTEGER NOT NULL, endIpNum INTEGER NOT NULL, locId INTEGER NOT NULL, PRIMARY KEY (endIpNum)). It returns syntax error near unexpected token'('. I tried the same query on my machine which was running under Windows XP. It run well and created the table in database. I am trying to figure out the problem.

Today's meeting

Following are the details of today's meeting. They should be done before next meeting.

1. Get the key to access to CAR 111/112/114
2. Setup GeoLite City in server machine
3. Test all cities in Nova Scotia

Test Post

Test post on the Acadia Disaster Prediction Blog!!!!