Data and System Integration for Clinic Locator App

This project focuses on data and system integration for a clinic locator app. It covers data merging, RESTful web services, and mashups. The demo running instructions are provided along with the process of finding clinic locations using geo-location. The project uses Python, HTML, and other required technologies.

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

Code Explain:
The clinics.map.html file used to view the exact geo location and direction of the position of
the clinic wants to know. Here we can able to see the MAP which contains the direction for the
clinic. It very useful show the location of the clinics services location easily.
4.0 Conclusion
The data and system integration is mainly used to exact the data and integrate both the
csv and xml file easily. Python is very useful to merging the data exactly and easily. The
visualization process is important one for system integration and analysis the data. The data and
system integration is the functional one. Finally, the user find out the location of health services
through the geo location plugin. If the process growth is non-dynamic and rapidly increasing.
Lakshadipathi t and Kumar raj t (2016
References
Huang, X. and Zhu, W. (2013). An Enterprise Data Integration ERP System Conversion System
Design and Implementation. Applied Mechanics and Materials, 433-435, pp.1765-1769.
Joglekar, A. (2016). Prediction of Favourable Rules to Identify Suspected Patients of HIV Using
Integration of Expert System and Data Mining. International Journal of Mechanical
Engineering and Information Technology.
Mynarz, J. (2014). Integration of public procurement data using linked data. Journal of Systems
Integration, pp.19-31.
Olmsted, A. (2017). Heterogeneous system integration data integration guarantees. Journal of
Computational Methods in Sciences and Engineering, 17, pp.S85-S94.
12

Oró, E. and Salom, J. (2015). Energy Model for Thermal Energy Storage System Management
Integration in Data Centres. Energy Procedia, 73, pp.254-262.
Vial, F. and Reist, M. (2014). Evaluation of Swiss Abattoir Data for Integration in a Syndromic
Surveillance System. Online Journal of Public Health Informatics, 6(1).
Lakshadipathi t and Kumar raj t (2016) big data integration and learning (2017). Journal of
Modern international Trends of Engineering & Research science, 3(11), pp.84-88.
Comala, A. (2016). The learning analytics of data protection. Journal of data protection , pp.91-
106.
Younger k. (2015).the training program data research and integration & visualization. Big Data,
1(1).
Gartner. (2018). Access Gartner's research on system integration. See the major trends for
2017. [Online] data-analytics.jsp/gartner
Shiva neelakantan, and Jason roy, A. (2015). System integration the emerging and era. Data
integration,
Jessy ryder, S. and johan botha, K. (2017).data integration and system analysis for educational
dialogue. Journal of Learning integration, 2(3), pp.111-143.
13