Implementation of Web Service in Processing of Data Base Financing Costumer Using Fragmentation Method

This research is to design the Implementation system of Web service of consumer financing data processing based on fragmentation in motor vehicle loan financing in accordance with the pattern of data processing and information needs at that location, then implement the design to know and measure the level of efficiency (ease), effectiveness (speed), accurate (data accuracy), and security (data security) and the process of disseminating data and information from the design offered. Implementation of consumer financing data processing is a database fragmentation system, wherein one network scale using more than one DBMS, DBMS used is MySQL and PostgreSQL. PostgreSQL is used for web-based applications developed with PHP programming language using AJAX Technology, and MySQL developed using Notepad ++ Application. Data connection process using Web Service. Based on the result of the research, it can be concluded that Webservice Implementation for fragmentation based consumer financing data processing facilitates the updating of consumer financing data in terms of ease, speed, accuracy, and data security.


Introduction
Information systems have been proven to increase economic benefits because they can automate and compute. The use of computer-based systems can improve company performance [9]. In this research will distribute the data through a web service from a variety of different applications i.e. consisting of two different applications and different types of database tools, using two different IE database PostgreSQL and MySQL. The use of fragmentation method to classify the same type of data from different databases using a web service for data services from their respective databases, data in a table in the database are separated into the different the fragment and every fragment is stored a number of different nodes [3]. Development of database system this is for the unification of the operational data and data access are controlled. Integration of data and control data has been implemented in the form of centralized data. Data used jointly and efficiency in data access should be accompanied by the development of a database system called base distributed, accessible anywhere and do a data storage in the different locations [6].
Web services that bridge the communication between different applications, so that different applications although being in one or different network can communicate using the standard protocol used by the web service. XML (Extensible Markup Language) is a language used to describe and manipulate documents are structured. XML is technically defined as a meta-markup language that provides a format for certain documents which have structured data.
Previous research already exists that raised about the distributed database as well as fragmentation. But it has yet to combine with the web service. Research on fragmentation and data replication to distribute data [5], using MySql as the database. Distribute data by replicating databases using Asynchronous Distributed Database Technology in a single DBMS, cannot be used on other companies that still use different applications and different databases. Other researchers have examined some of his discoveries to distribute data by measuring the efficiency and performance of DDMS in fragmentation for the allocation of data grouping technique (based on Clustering Technique) namely Clustering Decision Value (CDV) to reduce the problem of redundancies of data on data redistribution [1].
The researchers had previously used some kinds of methods in a distributed database, they distribute the database using a database. In this study, researchers combined two databases and using horizontal fragmentation methods for grouped data in a web service. Horizontal fragmentation reduces the density of the network and improves response time so that it can provide accurate information timely and relevant to all components of an integrated database on different at each branch office motor vehicle credit financing.
There are some components that are used by researchers in the utilization of the web service consumer, the use of data processing components to create an application that can help the consumer data processing on the web portal. The component that is used to process web service and the fragmentation of them: XML, SOAP, WSDL, UDDI [7].
This study implements the web service on processing the database by using the method of horizontal fragmentation of data processing system for web-based consumer finance. Consumer finance data processing using the web-based method of fragmentation is providing convenience in getting information consumer finance in 2 (two) different Office locations as well as increasing factors of availability (availability) and reliability (reliability) of database systems.

Web Service Architecture
Consumer and service provider systems financing consists of two branches, namely FIF and FIF GBC Spectra in Gorontalo which can integrate consumer service and financing system as seen in Figure 1. Consumer services and financing available on the two web services that are built will be utilized by the user that will be applied based on the website.   [6]. A fragment can be di defined as a fragment as follows : The application in the operation of the union of a number of fragments, then that is done is to table r, reconstruction with expression :

Results and Discussion
The results of this research resulted in a software web service with the method of fragmentation for consumer data services and financing. Where this service web devices can provide the information to the administrator to locate the vehicle financing transactions of the two branches of the search results data by using a method of Fragmentation that results are visualized with using webbased information service system. The information generated is composed of the consumers of classification results where each consumer can be known doing the financing of more than one. So the administrator can know the number of vehicle motor vehicle credit financing is credited. This software was created by using the programming language PHP, javascript, XML to parsing the data in the form of elements of data into the form of a command program that will be processed. The process of inputting the data was derived from each branch and the data is stored in each database, the next step for the process of the search data from any database using the function of the components of the web service that consists of XML, NuSOAP, and WSDL. After that is done the fragmentation of data elements. The fragmentation results are shown in table form. The system developed is the integration of the two branches of the Office of motor vehicle credit financing which was later merged into an integrated system using Web Services technologies and XML. Both systems integration services on the two branch offices that use technology facilities Web Services and databases. FIF Spectra using MySQL as its database, then to FIF GBC uses PostgreSQL as its database. . Horizontal fragmentation contains a tuple tuplepartitioned or divided from a global relation R into a number of subsets r1, r2., … , rn. Each tuple contains a number of subsets of r. Each tuple in R must have more than one fragment so that a genuine partnership can be rearranged. A fragment in horizontal fragmentation can be defined as a selection on the global relation r. therefore a predicate Pi is used to assemble the fragments ri.

Fragmentation of consumer data
The result of the fragmentation of consumer data processed from the table of the consumer database on each side. Following the results of the deliberations of the horizontal fragmentation attempted in Figure 3 and  The result of the fragmentation of data service costs The result of the fragmentation of data service costs cost tables prepared from the database on each side. Following the results of the deliberations of the horizontal fragmentation attempted in Figure 5 and Figure 6. Data fragmentation test results relationships service financing is shown in Figure 6.