Data and System Integration: Developing a Clinic Locator Application

This project focuses on data and system integration to develop a web application that locates clinics based on user input such as service or postal code. The application utilizes technologies like PETL, Parser, Bottle, HTML, and Python, along with a dataset of clinic information stored in a CSV file. Key concepts covered include data merging, RESTful web services, and mashups. The project demonstrates how to combine data from various sources, implement RESTful APIs for data communication, and create a user-friendly interface for displaying clinic locations on a map. The final application allows users to easily find and visualize the locations of health services through a geo-location plugin.

752820
data and
system
integration
user

1

EXECUTIVE SUMMARY
The objective and main theme of the project is to provide the web page according to the user’s
specification and query but it completely based on the query given by the user. For example the
user inputs a service and or a postal code it navigates that code through our app which was
developed by us needs to display the map that is cluster map of clinics to the user according to
the users specification. This project must contains petl, parser, bottle, html and also python
code and then other required technologies. The main file clinics with .csv (clinics.csv) extension
contains data about the required clinics. The list of clinics things are contained in the last csv.
2

Table of Contents
1.0 INTRODUCTION:...................................................................................................................4
2.0 KEY SYSTEM CONCEPTS..................................................................................................4
2.1 Data merging.....................................................................................................................4
2.2Restful web services........................................................................................................5
2.3 Mashups.............................................................................................................................7
3.0 Demo Running Instruction:...............................................................................................7
4.0 Conclusion...........................................................................................................................11
References..................................................................................................................................11
3

Table of figure
Figure 1 Combine two files.............................................................................................................8
Figure 2 Find out the restful web services.......................................................................................9
Figure 3 To search the location....................................................................................................10
Figure 4 Display the location using Map...................................................................................10
4

1.0 INTRODUCTION:
For large organizations preparing huge amounts of information for instance client information,
money related information, fabricating information. It is difficult to do the capacity to get to
every one of the information is an urgent one. So information mix assumes a huge part in each
association. Information mix is happening by joining a few sources and give bound together
form of those assets. For instance a few organizations may need to work together each other.
At that point they join their databases. This includes information combination that implies a
few information incorporated to give single adaptation of those information. In the Information
joining has a few classes that incorporates center information reconciliation.
There are a few cases for center information combination activities:
ETL (Extract, transform, load) implementations
EAI (Enterprise application integration) implementations
SOA (Service oriented architecture) implementations
ESB (Enterprise service Bus) implementations
2.0 KEY SYSTEM CONCEPTS
2.1 Data merging
It is the process of combining data from sources which are different from each other. And it
provides users with view the data in the form of single view.
5

The examples for data merging are combining the data from the hospital sites to the clinics and
then analyzing the data. And the next example is generating data from scientific studies and
that will provide better data analysis. Jessy ryder, S. and johan botha, K. (2017).
Data merging is a specific feature and it allows us to transfer and determine the information
from our document.
With data merging we can easily work and easily arrange and paginate the pictures and texts as
well as words when we reading and studying the external resource files in the .txt and .csv
formats. Younger k. (2015).
2.2Restful web services
REST is the acronym for REpresentational State Transfer. It is also a web standards oriented
architecture and which follows hypertext transfer protocol (HTTP) and HTTP protocol used in
the rest for data communication. Mynarz, J. (2014).
RESTful API is also called as RESTful web service it is based on representational state transfer
(REST) technology, an architectural style and approach.
REST architecture uses various representation for representing various resources like JSON,
text and also the XML’s. Among these resources JSON is popular format and likely used in web
services. Shiva neelakantan, and Jason roy,
6

HTTP methods
Methods of HTTP’s mostly used in a REST architecture.
 GET – providing of read only for a resource.
 DELETE − removing a resource from the existing resource.
 PUT − creates a new resource.
 POST − updates an existing resource and creating a new resource.
 OPTIONS − getting supported operations for the resource.
Security in Rest
Restful services are secured one which uses the following for security purposes and they
are:
 Validation − inputs in the server are validated using validation. And it is also protecting
against from SQL or NoSQL attacks injects.
 Session Authentication – based on the session time it will authenticates
 No Sensitive Data in URL – the use of passwords and user id’s avoided.
 Restriction on Method Execution – allows restricted methods like GET, POST, METHOD
and DELETE.
 Validate Malformed JSON/XML – checking the passed inputs
 Generic Error Message throwing – 404 not found. This is the error message.
7

2.3 Mashups
A mashup is kind of method by which a site or Web application utilizes information,
introduction or usefulness from two sources to make another administration. Mashups are
visual and intelligent in nature. Mashups are made conceivable by means of Web
administrations or open APIs that (by and large) permit free access. To a client, a mashup ought
to give a more extravagant, more intelligent experience. A mashup is likewise helpful to
engineers since it requires less code, taking into consideration a faster advancement cycle.
3.0 Demo Running Instruction:
Merge the two Files:
Explanation about code:
The python program that is “dataMerger.py” is used to merge given content and the files are
imported by using the keyword “import” and every attributes in the codes are used to form the
tree and the web service side the python program that is “clinics_locator.py” used to search
and locate the address in the nearest tab. Gartner. (2018)
8

Figure 1 Combine two files
Restful web services:
Explanation
Which was carried out to the execution of python files and save the location on .csv files.
For show the results of the operation “import csv” was used. For opening the information
“Clinicopen()” was used. To read the file we need to use “ClinicFileReader()” was used. For
length checking purpose we need to use the “If(len !=row)”. To increase the no of rows we
need to use “ClinicList[]=ClinicList[]+row”. For exiting from the file we need to use
“ClinicFile.close”.
9

Figure 2 Find out the restful web services
10

To search the Location:
Figure 3 To search the location
Displayed the Location (Google Map):
Figure 4 Display the location using Map
11