CS 519 Final Project Report

Internet Phone

Date: Sep. 30, 98

Name of Group : G1

Team members: Jing Deng, Rung-Hung Gau

Task: Accounting (#5)

• Pseudocode:

Part 1: Get call information from signaling team and directory team, and then store the information in our database.

while (true) do

begin

// wait for a message from signaling team

wait_signaling(message_signal);

// run authenticate algorithm to verify the message

if (authenticate(message_signal)==true)

{

// get IP address of caller

caller_address=get_IP_address(message_signal);

// ask directory service to obtain the identity

message2=directory_service(caller_address);

if (authenticate(message_dir)==true)

{

message_type=get_message_type(message1);

call_information=get_call_information(message1);

write_to_database(message_type, caller_identity, call_information);

}

}

end

Whenever a customer or a manager requests a telephone bill, do the following,

begin

call_record=retrieve_data(customer);

bill=create_bill(call_record);

show_bill(bill);

end

• Interface that our team will provide for other teams:

Our program will provide a graphic interface that allows end-user to input their user name and query their bills and detailed calling activities.

• Interface that we will use:

1. We need an interface from Signaling team (#2) to provide us the information for each call. The following are two functions that we will use to obtain call information from signaling team.

phoneCallInit(Service Type, Call Initializer, Call Destination(s), Time, Call ID)

phoneCallFinish(Call ID, Time)

2. We also need an interface from Directory team (#4) to provide us the corresponding user name for a specific IP address (if it exists at all). The following is the prototype of the function.

String getUserName(IP address)

• Our planned schedule:

• What do we need from the course staff?

We need a computer network environment that we can work. First, we need a personal computer with MS-Access, which acts as our accounting server. Windows 95 or Windows NT must be installed in the server since we want to use MS-Access as our database. Windows NT is preferred compared to Windows 95. Besides, a JDBC driver that supports MS-Access DBMS, such as IDS JDBC server and Symantec dbANYWHERE, must be installed in the accounting server. Of course, we need a JAVA compiler and JAVA virtual machine with all necessary classes. We already have the software. However, we need an administrator privilege to install the software.

Secondly, the accounting server must be connected to Internet since we have to communicate with signaling team and directory team. We have some experience about socket programming in Unix. Nevertheless, we do have any experience in network programming in Windows NT. We need some guidance on this topic. We have computer accounts in CS undergraduate lab. Therefore, it will convenient for us to work on the project if the required software can be installed in that lab.

• Reference:

[1] http://java.sun.com/products/jdbc provides information about current situation of JDBC.

[2] http://java.sun.com/products/jdbc/jdbc.drivers.html classifies JDBC drivers into four classes and provides a table composed of available JDBC drivers

[3] http://www.idssoftware.com/jdriver.htm is the homepage for the IDS JDBC driver, which can support MS-Access DBMS.

[4] http://www.symantec.com/dba is the homepage for Symantec dbANYWHERE server, which also supports MS-Access DBMS.

[5] http://java.sun.com/products/jdk/1.1 is the homepage we find a tutorial for JDBC programming.

[6] Barry Holmes, "Programming with JAVA" is the first book we used to learn JAVA.

[7] W. Richard Stevens, "Unix Network Programming" is the book we used to learn socket programming.