SOCNET-Computer Sciences Applications-Project Report, Study Guides, Projects, Research of Applications of Computer Sciences

Download SOCNET-Computer Sciences Applications-Project Report and more Study Guides, Projects, Research Applications of Computer Sciences in PDF only on Docsity! 1 Chapter 1: SOCNET 1-SOCNET Product to be developed is named as SOCNET. The project falls in the domain of social networking. As technology has become increasingly available and affordable to the masses over the past several years, one popular use that has emerged is communication and networking. This has essentially allowed users to meet new people they never would have contacted without the assistance of the technology, typically web-based. Now, as cell phones are becoming increasingly popular and their underlying technology increasingly capable, users are looking for ways to move many applications that are typically restricted to the personal computer to their cell phones. Cell phones already offer a range of communication capabilities. The project is an effort to build social networks by utilizing these capabilities. Similar to many web-based networking applications, our project will allow users to network with each other based on shared interests. Unlike some web-based applications, our project will allow users to network with each other based on their current geographical location, resulting in actual in-person meetings, not just Internet communication. The system will consist of an application to be used by a GPS-enabled cellular phone. The application interfaces will allow users to easily create their own profiles. A profile would consist of their interests and contact information of a user. Based on these profiles users will be able to share their common interest and create social activities along with inviting others to these activities. Users will be able to search other profiles and on-going or upcoming activities within a specified geographical radius. docsity.com 1.1- SOCNET review Before we start, let us first summarize our previous work to get the complete knowledge of our advancement towards the development of SOCNET, our degree project. In our previous report, we completed our design phase including the complete design of our J2ME application and our database. We showed pictorial representations of our application with complete set of tabs and options and explained the way they’ll actually work. Our design phase is complete, we have now moved towards implementation phase. 1.2- Time Schedule  Semester 6 o Study and proposal of project (including definition and description)  Summers 2006 and Semester 7 o Analysis o Design  Semester 8 o Implementation Analysis and design of SOCNET has been completed and this report starts the implementation of the degree project. Implementation of SOCNET will be completed and thesis writing will be done in the remaining period. docsity.com  A privilege and password system that is very flexible and allows host-based verification. 2.3.3- Scalability and Limits  Handles large databases. Maximum size for a table is 8TB (default 4GB).  Up to 32 indexes per table. Each index may consist of 1 to 16 columns or parts of columns.  The maximum index width is 500 bytes (this may be changed when compiling MySQL Server).  An index may use a prefix of a CHAR or VARCHAR field. 2.3.4- Connectivity  Clients may connect to the MySQL server using TCP/IP Sockets, Unix Sockets (Unix), or Named Pipes (NT).  All ODBC 2.5 functions and many others. 2.3.5- Localization  All comparisons for normal string columns are case-insensitive.  The server can provide error messages to clients in many languages.  MySQL Server supports many different character sets that can be specified at compile and runtime. 2.3.6- Clients and Tools  Includes “myisamchk”, a very fast utility for table checking, optimization and repair.  All of the functionality of myisamchk is also available through the SQL interface as well. [3] docsity.com 2.4- SOCNET database After making MySQL as our choice for SOCNET database, first step that comes in the development of database is the installation and configuration of MySQL. 2.4.1- Download and Installation The complete setup file is available at http://dev.mysql.com/downloads/index.html . Installation follows following steps: Run the installer. When the Setup Wizard prompts for a setup type, select Typical. Accept the suggested Destination Folder. Select Skip Sign-Up if you do not wish to create a MySQL.com account. When the Setup Wizard finishes, leave Configure the MySQL Server now checked and click Finish. Once MySQL is installed, next step to be performed is the configuration of MySQL. 2.4.2 – Configuration Configuration of MySQL includes the following steps:  When prompted by the Server Instance Configuration Wizard, select Standard Configuration.  Leave Install as Windows Service and Launch the MySQL Server automatically checked, so the MySQL server runs in the background and does not need to be started. Without changing any of the other values, click Next.  Leave Modify Security Settings checked, and Create An Anonymous Account unchecked. Specify a root password, and make a note of it, as you will need it later, and click Next.  Click Execute to start the configuration. docsity.com The screenshots of configuration of MySQL are shown below making the configuration understandable. docsity.com 2.4.4 - Creating a Database In order to create our database, we first need to connect to the server. It is done by running MySQL Administrator and logging in to the server using the password we set during installation. docsity.com MySQL Administrator 1.0.19: Myst" Administrator Hestore ee Edit Schema Drop Schema Copy SQL to Clipboard Create New Table Create New View Create New Procedure / Function Refresh docsity.com  2.4.5 - Creating a Table To create a table, simply click on the "Create Table" button. This brings up a dialog box which creates the table. After entering the fields, their types and other information, press “Apply changes” and then “Execute” to make it a part of schema. There are two tables in SOCNET database named as;  User  Activities 2.4.5.1- User User table includes the following fields;  F_Name  L_Name  User_Name  Password  User_Location  Interests  Contact_Inform ation docsity.com This finalizes the table design and completes the schema. In the real world, data in our tables will come in via our application. To get some sample data into our table, we can insert a few lines by hand by using the MySQL Command Line Client for testing purposes. Also we can check the status of our database using MySQL command Line prompt. docsity.com At the moment, no entries have been made to SOCNET database as data has to come from SOCNET application, so tables are empty as shown below. docsity.com 2.5- Implementation of Mobile application As with database implementation, we had a couple of choices for developing our mobile application like WML and J2ME out of which we chose J2ME as our platform. 2.6- J2ME, an Introduction Write once, run anywhere. This Java motto seems to hold true even for mobile devices. Indeed, since it was born J2ME has had an ever-increasing impact on mobile development. It is a set of tools for creating Java applications on small devices. It is the same language as the "desktop" Java, but with a smaller set of APIs and a different framework for building GUIs. Java 2 Micro Edition (J2ME) runs on most devices — cell phones, Blackberries, Palm devices such as the Treo, and PocketPCs. J2ME is popular for building mobile applications. 2.7- Why use J2ME? Before explaining why to use J2ME, let’s first look at why not to use WML. Wireless Markup Language (WML) is a markup language based on XML, and is used to specify content and user interface for narrow-band devices, including cellular phones and pagers. WML is designed with the constraints of small, narrow-band devices in mind. These constraints include:  Small display and limited user input facilities  Narrow band network connection  Limited memory and computational resources J2ME technology specifically addresses the vast consumer space, which includes smart cards and pagers all the way to the set-top box, an appliance almost as powerful as a computer. Like the other Java technologies (Java 2 Standard Edition (J2SE) and J2EE), the J2ME platform maintains these advantages: docsity.com J2sk-1_4_2_09-windows-i586-p.exe  Run the toolkit installer.  In the Custom Setup window, leave the program features and the installation directory unchanged, and click Next  Next step is to install J2ME Wireless Toolkit which is available at J2me_wireless_toolkit-2_2-windows.exe  Run the toolkit installer.  The Setup Wizard locates the installed Java 2 SDK(s); click Next to use the displayed J2SDK or browse to locate another J2SDK.  Accept the suggested Destination Folder.  After performing these steps, J2ME is ready to be worked in. 2.8.2- Creating the Mobile Application To create the SOCNET application, we will perform the following tasks:  Create our project, SOCNET application  Add the Java source code and Sync4j J2ME library to the project  Review the application code  Test the application on a phone emulator  We are working on the process of creating our SOCNET application which will, then, be integrated with our database. docsity.com 2.9- Compatibility of J2ME and MySQL Java is easily compatible with MySQL databases with the use of Connector J, which is an open source driver allowing Java classes to communicate with MySQL databases and call MySQL commands from within a Java class.[4] docsity.com Conclusion The information documented in this report is combined effort of Zohaib Ahmed and Muhammad Farhan. It contains the implementation of SOCNET database and features of different tools involved in implementation. It also discusses different issues including portability, scalability and compatibility of tools. This document is subject to change with a notification released only to the project team specified in the document. docsity.com