International Journal of Computer Trends and Technology (IJCTT) – volume 9 number 2– Mar 2014
Tracking Down Travel Agencies Geo-location using Software Engineering Ml II Function Point Analysis 1
N.Kamaraj1, M.Chandran2 (Head, Information Technology, SRMV CAS, India) 2 (Asst-Professor in MCA, SRMV CAS, India)
Abstract: The location of individual travel agency around every corner by its respective database source in which the customers book their destination. The user details been fetched with their IP and Based on the latitude and longitude of the place that been point out in the map providers. It determines the origin of a packet on the Internet. GMAP is a tool for mapping. For the purpose of identifying the position and distance flat earth surface calculation concept is included, accurate flat-earth phase can be retrieved and the travel agency details could be gathered Function Point Analysis algorithm (FPA). To ensure customer safety and the Internet’s continuing growth, the presumption of anonymity is maintained. A simple way to track the identify whether it has any travel agency. A customized windows form in which the location based information could be search by using IP address of certain area and store the data.
Keyword: IP Address, Function Point Analysis algorithm, map and Latitude and Longitude
1. INTRODUCTION It is hard for any new face in new a city to find out any place they wish unless they have a guide or reference of their needs. The same may applied with finding the travel agency to book their travel from source to destination. They use their individual machine or in any computer network center to book their travel, those database would be stored in a separate database in their portal website of any agencies websites. It finds up every individual IP address and locate it using the map Providers which been applied of the user perspective mode, with the help of the clustering algorithm the set of IP which been sorted according to the range that is from the top list to the bottom. While those ip been pointed up the individual ip will be considered as the users registered for in either their personal machine or in any computer center and those sorted list might be identified as the travel agencies by its group of ip that been neatly pointing towards the isp providers of the respective district The gmap control had been included in the windows form for the geo location of the ip. It has been given an link to the ipdbinfo.com directly from the windows form which will provide the latitude and the longitude of the ip address after the traceback from their ip
or bing account map providers can be varied according to the convienient of the users google maps, yahoomaps, bingmaps, openstreetmap are the options The gmap control use the map providers, overlay and markers been initialized to enable the mapview in windows form .The traced geo location of ip been linked with each other to form a polygon and those areas been covered up with any highlighted colour to visualize As the users always requires a web browser to access the internet for the booking it always appears to vary for each customers to use different browsers according to their choice of comfort-ability. Those browsers been counted by their total and displayed as a bar chart with chart control tool.
II.PROBLEM DEFINITION There are three different types of agencies, they are multiples, miniples and independent agencies. There are two approaches of travel agencies. One is the traditional, multidestination, out-bound travel agency, based in the originating location of the traveller and the other is the destination focused, in-bound travel agency, that is based in the destination and delivers an expertise on that location.[1] Travel agents have applied dynamic packaging tools to provide fully bonded (full financial protection) travel at prices equal to or lower than a member of the public can book online. As such, the agencies' financial assets are protected in addition to professional travel agency advice. All travel sites that sell hotels online work together with GDS, suppliers and hotels directly to search for room inventory. Once the travel site sells a hotel, the site will try to get a confirmation for this hotel. Once confirmed or not, the customer is contacted with the result. This means that booking a hotel on a travel website will not necessarily result in an instant answer. Only some hotels on a travel website can be confirmed instantly (which is normally marked as such on each site). As different travel websites work with different suppliers together, each site has different hotels that it can confirm instantly. [2] Function Point Analysis algorithm The MK II Method is one of the software sizing methods in functional point group of measurements. This is a method for analysis and measurement of information processing applications based on end user functional view of the system
To access the website and provide the information from the certain database api key is must. To purchase an api key for the map link an account to be created with gmail
ISSN: 2231-2803
http://www.ijcttjournal.org
Page49
International Journal of Computer Trends and Technology (IJCTT) – volume 9 number 2– Mar 2014
III.METHODOLOGIES Calculating the distance between geographical coordinates is based on some level of abstraction; it does not provide an exact distance, which is unattainable if one attempted to account for every irregularity in the surface of the earth. Common abstractions for the surface between two geographic points [3]:
Flat surface; Spherical surface; Ellipsoidal surface.
Flat surface: A planar approximation for the surface of the earth may be useful over small distances. The accuracy of distance calculations using this approximation become increasingly inaccurate as:
Distance, D, is calculated between two points, P1 and P2. The geographical coordinates of the two points, as (latitude, longitude) pairs, are (ϕ1,λ1) and (ϕ2,λ2), respectively. Which of the two points is designated as P1 is not important for the calculation of distance[4] Latitude and longitude coordinates on maps are usually expressed in degrees. In the given forms of the formulae below, one or more values must be expressed in the specified units to obtain the correct result. Where geographic coordinates are used as the argument of a trigonometric function, the values may be expressed in any angular units compatible with the method used to determine the value of the trigonometric function. Many electronic calculators allow calculations of trigonometric functions in either degrees or radians. The calculator mode must be compatible with the units used for geometric coordinates. The Equator is an imaginary circle equidistant from the poles of the Earth. Circles parallel to the Equator (lines running east and west) are parallels of latitude. They are used to measure degrees of latitude north or south of the Equator.[5] Differences in latitude and longitude are labeled and calculated as follows: ΔΦ = Φ2−Φ1 Δλ=λ2−λ1
It is not important whether the result is positive or negative when used in the formulae below. "Mean latitude" is labelled and calculated as follows: Φm= (Φ1+Φ2/2) R = 6,371.009 kilometres = 3,958.761 statute miles = 3,440.069 nautical miles.[6] D = Distance between the two points, as measured along the surface of the earth and in the same units as the value used for radius unless specified . Calculation based on latitude/longitude should be valid for all Earth positions, it should be verified that the discontinuity and the Poles are handled correctly. Another
ISSN: 2231-2803
solution is to use vector instead of latitude/longitude, since this representation does not have discontinuities or singularities.
The separation between the points becomes greater; A point becomes closer to a geographic pole.
The shortest distance between two points in plane is a straight line. The Pythagorean theorem is used to calculate the distance between points in a plane. Even over short distances, the accuracy of geographic distance calculations which assume a flat Earth depend on the method by which the latitude and longitude coordinates have been projected onto the plane. The projection of global latitude and longitude coordinates onto a plane is the realm of cartography. Spherical surface; If we are willing to accept a possible error of 0.5%, we can use formulas of spherical trigonometry on the sphere that best approximates the surface of the earth. The shortest distance along the surface of a sphere between two points on the surface is along the great-circle which contains the two points. The great-circle distance article gives the formula for calculating the distance along a great-circle on a sphere about the size of the Earth. That article includes an example of the calculation. Tunnel distance A tunnel between points on Earth is defined by a line through three-dimensional space between the points of interest. An ellipsoid approximates the surface of the earth much better than a sphere or a flat surface does. The shortest distance along the surface of an ellipsoid between two points on the surface is along the geodesic. Geodesics follow more complicated paths than great circles and in particular, they usually don't return to their starting positions after one circuit of the earth. This is illustrated in the figure on the right where f is taken to be 1/50 to accentuate the effect. Finding the geodesic between two points on the earth, the so-called inverse geodetic problem, was the focus of many mathematicians and geodesists over the course of the 18th and 19th centuries with major contributions by Clairaut,[3] Legendre,[4] Bessel,[5] andHelmert.[6] Rapp[7] prov ides a good summary of this work. Methods for computing the geodesic distance are widely available in geographical information systems, software libraries, standalone utilities, and online tools. The most widely used algorithm is by Vincenty,[8] who uses a series which is accurate to third order in the flattening of the ellipsoid, i.e., about 0.5 mm; however, the algorithm fails to converge for points that are nearly anti-podal. (For details, see Vincenty's formulae.) This defect is cured in the
http://www.ijcttjournal.org
Page50
International Journal of Computer Trends and Technology (IJCTT) – volume 9 number 2– Mar 2014 algorithm given by Karney,[9] who employs series which are accurate to sixth order in the flattening. This results in an algorithm which is accurate to full double precision and which converges for arbitrary pairs of points on the earth. This algorithm is implemented in GeographicLib.[10]
IV. ANALYSIS AND IMPLEMENTATION This Research paper would be helpful for many users or costumers to get a clear valuation about the travel agencies which may be convenient to their needs.
The selected database been displayed in the datagrid view. This shows the list of database table which been selected as a result to count the browser list. The browser field was selected particularly and their list with category had been calculated. A bar chart which represent the percentage that the browser with its types occupied
Figure-2.Mapview in Gmap Control
1. Fetching IP from the database: a) Table1. IP list with the information of travelling agency bookers Table2 booker_name Mr. Saravanan Nathan Dr.s.radhaakrishnan Mr.ramkumar Sree karpagavina P. Ramesh Mr.srinivasan Karr travels15685 S.sivaraman Suresh Mr. Babu Allen Mr.senthil Mr.shivakumar m.s P srinivasan Mr.p.visweswaran Jafeermon Pondyoff
IP 122.164.62.231 122.164.234.246 122.164.56.112 122.164.52.215 122.164.63.2 115.108.96.47 122.164.59.166 122.172.118.39 59.92.81.95 122.164.59.59 122.164.53.30 59.97.96.149 122.164.48.203 122.164.59.220 117.201.8.39 122.164.54.122 122.172.135.137 122.164.53.18
Browsers Explorer6 Explorer6 Explorer6 Explorer6 Explorer6 Explorer6 Chrome2 Chrome2 Explorer6 Chrome2 Firefox2 Chrome2 Firefox2 Chrome2 Explorer6 Firefox2 Explorer6 Chrome2
The above table display a series of IP list with the information of travelling agency bookers. Figure-1 Bar Chart display
ISSN: 2231-2803
Now the ip address field been selected and their latitude longitude information being fetched and stored up in another database as shown below. b) Table 2: Latitude and Longitude Table3 Ip 115.108.96.47 122.164.48.203 59.92.81.95 122.172.118.39 122.164.57.21 122.164.59.220 122.164.54.122 117.201.8.39 122.164.53.30 122.164.53.18 122.172.135.137 117.201.6.157 122.164.215.156 122.166.16.140 59.97.96.197 122.164.55.158 122.164.209.213 122.172.112.216 203.197.157.143
http://www.ijcttjournal.org
City Coimbatore Chennai Chennai Bangalore Chennai Chennai Chennai Pondicherry Chennai Chennai Bangalore Pondicherry Chetput Bangalore Chennai Tirunelveli Chennai Cochin Coimbatore
lati 11 13.088 13.088 12.976 13.088 13.088 13.088 11.93 13.088 13.088 12.976 11.93 13.07 12.976 13.088 8.7333 13.088 9.9399 11
longi 76.967 80.279 80.279 77.603 80.279 80.279 80.279 79.83 80.279 80.279 77.603 79.83 80.241 77.603 80.279 77.7 80.279 76.26 76.967
Page51
International Journal of Computer Trends and Technology (IJCTT) – volume 9 number 2– Mar 2014 This data access the IP through network and fetch the information with its latitude and longitude to give the location in map. c) Table 3: Table4 ip12 count1 11 122.164.62.231 9 122.164.234.246 8 122.164.56.112 8 122.164.52.215 7 122.164.63.2 7 115.108.96.47 7 122.164.59.166 7 122.164.57.21 7 122.172.118.39 7 59.92.81.95 7 122.164.59.59 7 122.164.53.30 7 59.97.96.149 7 122.164.48.203 6 122.164.59.220 6 117.201.8.39 6 122.164.54.122 5 122.172.135.137 5 122.164.53.18 4 117.201.6.157 3 59.97.96.197 3 122.164.215.156 3 122.164.209.213 The ip been sorted according to its usage and the top 15 been gone through and placed with their location in the map. The top 15 Ip had been fetched and placed in a separate table to locate in the Map.
The flat earth distance between any two locations been calculated and displayed.
5. CONCLUSION This Research would be helpful with every kind of effectiveness among the users who needs the data in no time. While the database has been accessed to fetch the information, response time of the server is carried out to have similar response time for any servers, also when the low bandwidth internet speed it is possible to retrieve data with the very short time compared to normal browsers data fetching speed.
REFERENCES [1]. Information on http://en.wikipedia.org/wiki /Travel accessed at 18 September, 2013
agency
last
[2]. Information on http://en.wikipedia.org/wiki/ Travel_agency “Travel agencies in the 21st century” last accessed at 18 September, 2013 [3]. Information on http://en.wikipedia.org/wiki /Geographical_distance last accessed at 18 September , 2013
Figure-1Tooltip View for markers:
[4].Information on http://www.oilfieldwiki.com/w/ Geographical_ distance last accessed at 18 September,2013 [5]. Information on http://en.wikipedia.org/wiki /Travel accessed at 18 September, 2013
agency
last
[6] http://www.dauntlesssoft.com/PRODUCTS/Freebies/Library /books/ AK/8-2.htm [7] Information on http://www.oilfieldwiki.com/w/ Geographical _ distance
The pointed map marker has the information about the location. Figure-2 Flat Earth Distance:
ISSN: 2231-2803
http://www.ijcttjournal.org
Page52