Project: System Integration, Data Cleaning, and Clinic Location Finder

This project focuses on data integration, encompassing system integration, data merging, and data cleaning techniques. The primary objective involves converting XML data into CSV format and subsequently merging these files using Python, leveraging tools like PyCharm and scripter. The project emphasizes the importance of data cleansing for effective merging. Furthermore, it aims to enhance the process of locating clinic data, incorporating geolocation services to pinpoint clinic addresses accurately. The implementation includes the utilization of RESTful Web Services to facilitate data exchange and a demonstration of how to search and display the clinic locations on a map. The project also delves into the application of mashups, combining multiple web application resources to achieve its goals. The project concludes by highlighting the benefits of cloud infrastructure, such as elasticity, scalability, and flexibility, and provides references to relevant research papers.

Executive summary
The overall view of the integration system, the human are factors the way of perspective is
carried out easily. In our task, detailed discuss about the system integration, such as the
application integration, Information services and Computing storage information. The next task
discuss about the coding section such as the python. The design of the system and computing
system are functional. In out project converting the xml into csv and merging the same file. In
pycham and scripter are also used to merge the two file. The data cleansing is the important
method to clean the data easily. The cleaning file is very useful to merging process. The next
task to improve and finding the location of the given clinics data easily. The geolocation must
use to known the clinics address. Finally, the user to search the location find out the correct
location.

Contents
Executive summary:......................................................................................................................1
1.0 Introduction..............................................................................................................................3
2.0 Key System Concepts..............................................................................................................3
2.1 Data merging and cleaning:................................................................................................3
2.2 RESTful Web Services:.......................................................................................................4
2.3 Mashups................................................................................................................................4
3.0 Demo Running Instruction:....................................................................................................4
Combine the two files....................................................................................................................4
4.0 Conclusion................................................................................................................................8

Table of Figures
Figure 1 Combining the two file in pycham....................................................................................6
Figure 2 Restful Web Services in pycham......................................................................................7
Figure 3 Search location..................................................................................................................8
Figure 4 Location Display in Google Map......................................................................................8

1.0 Introduction
Data integration is the data could be combine easily. It main thing to combine the
different data and resources. They are widely used to retrieve the data easily. It similarly merge
the data and combining the results from different database. It increases the volume of the data
integration process. The system integration is the major thing for the combining the data easily.
The system integration combine the different techniques namely, enterprise application and
business process management. It involves the disparate system, it focus the volume should be
increasing the customers. It existing the system integration. The role of the entire process of the
system should contain the connected internet, it’s the important one. And the requirements from
the users are need to satisfy by the company which are providing the services. All the needs can’t
be satisfied by the single technology, so the designer choose some current trending technology.
Now the cloud services has many benefits. So the user need to consider this criteria when using
cloud services, whether the cloud is public, private or hybrid. And payment for the cloud service.
2.0 Key System Components:
2.1 Data Merging and Cleaning:
Merge is the one type of process, it could be combine the different types of folder.
The main purpose the merging is to be combine the two or more files. It could be easily combine
the two files. Merge is to combine the two or more bunch of the data. If the data should contain
the different folder. MS-DOS is mainly used to merging process. Generic merging is used to
from the same command. Many of the system and different organization, if the data should be
contain to merge by giving the different customers. Data cleansing is mainly used to clear the
unwanted data. The cleansing is the one of detecting the data and correcting the data. The data
stored from the table or database, taking the data should be cleaning is easily. After cleaning
process is done, the data should be correct and consistent one comparing the other data sets of
the system.

2.2 RESTful Web Services:
RESTful Web Services is the one type of the Architecture. In this
architecture mainly based on Web Services. It could contain the overall the resources of the
organization. The Web service is the less weight process and higher scalable and flexibility. It
mainly used to create API based web application. REST stands for Representational state
transfer. REST is the one type of Protocol. It is the based on the web standard architecture. In
this web services used the HTTP protocol. The protocol used to communicate the data message.
The web services is mainly used to exchanging the data between the different systems. It is the
open source protocols.
2.3 Mashups:
Mashup contains the more than one sources of the web application. The words
mashup is new one comes from British. It contain the Web application and web pages. The main
purpose of the mashup is to list out the characters namely are given below:
 Combination
 Aggregation
 Visualization

3.0 Demo Running Instruction:
Combine the two files.
Code explanation:
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.
Figure 1Combining the two file in pycham

Restful web services:
Figure 2Restful Web Services in pycham
Code Explain:
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
“storeopen()” was used. To read the file we need to use “StoreFileReader()” was used. For
length checking purpose we need to use the “If(len !=row)”. To increase the no of rows we need
to use “ScoreList[]=ScoreList[]+row”. For exiting from the file we need to use
“ScoreFile.close”.

To search for the location:
Figure 3search location
Location displayed in next tab:
Figure 4Location Display in Google Map

Code Explain:
The html file used to show the pinpoint position of the store wants to know. Here we can able
to see the MAP which contains the direction for the store. We may use those details for our use.
4.0 Conclusion
The system integration of various data the final required data was recovered. Scalability of the
system was ensured by the virtualizing techniques. And finally the integrating the information,
demonstrations also performed. The position of the stores in the MAP was identified. The IT
structure are mainly used to access the data centers and based on the Functionality of the
dependent on the type of the Infrastructure. Growth of the process is slowly increasing and non –
dynamic. The techniques are used to compute the responsibilities of the system. Cloud
Infrastructure are some benefits like the special characters are elasticity, scalability and
flexibility.
Reference:
Priyadharshini, E., Vijayakumar, V. and Abdul Quadir, M. (2018). Towards a cloud consumers
credibility assessment and trust management of cloud services. EAI Endorsed Transactions
on Cloud Systems, 3(12), p.154775.
Rismayani, N. (2017). Rural Population Administration Management System Based on RESTful
API in Bone District (Sistem Manajemen Administrasi Kependudukan Tingkat Pedesaan
Berbasis RESTful API di Kabupaten Bone). Journal Pekommas, 2(1), p.7.
Vinoski, S. (2008). Demystifying RESTful Data Coupling. IEEE Internet Computing, 12(2),
pp.87-90.
Wei, N., Song, M., Xu, K. and Jiang, C. (2010). A Novel WebService Architecture Based on
REST. Advanced Materials Research, 143-144, pp.1213-1217.
WU, Q. and WANG, Q. (2011). Research on Web Services-based Geospatial Information
Application Integration Solution. Geo-information Science, 13(2), pp.219-225.

Gannouni, S., Beraka, M. and Mathkour, H. (2013). Data integration using service composition
in data service middleware. Security and Communication Networks, 7(11), pp.2134-2144.
He, Y. (2015). Description of a Cloud Based Private Social Network Security
Scheme. International Journal of Information and Education Technology, 5(7), pp.532-537.
kang jang mook (2007). The Study of semantic Web and WebService Security(Focus on
Ontology). The e-Business Studies, 8(2), pp.391-403.
M.Kom, S. (2016). DATA COMMUNICATION ANALYSIS WITH XML AND JSON ON
WEBSERVICE. Computer Engineering, Science and System Journal, 1(2), pp.1-6.
Millard, C. (2015). Forced Localization of Cloud Services: Is Privacy the Real Driver?. IEEE
Cloud Computing, 2(2), pp.10-14.
Milojicic, D. and Wolski, R. (2011). Eucalyptus: Delivering a Private Cloud. Computer, 44(4),
pp.102-104.
Nakiyimba, I. (2014). A System Thinking Model Proposal for Enterprise Application Integration
(EAI) Evaluation Completeness. Journal of Systems Integration, pp.52-75.