Publication Date: 2023/04/19
Abstract: Over the years the role of data when it comes to analysis, interpretation, and prediction can’t be overemphasized, the effectiveness and the interaction of any application hinged on inputting and outputting data to ascertain its functionalities and robustness. We are looking at how we can create data and get it inserted into two different databases same time, with the same data type without any constraint, this is very important where we have a cloud (server database) that only takes input from a particular technology, say (.Net Framework) and we have another solution running on PHP technology. In this paper, we were able to implement different applications technology to exchange data from two different databases so as to communicate seamlessly with each other through API (Application Program Interface). The need to fetch data between two applications is to enable two applications to communicate seamlessly without interference and alteration from one application database to the other. The role of API is like giving a visitor your house key but the visitor can only enter the room that the key is meant for (not the whole room), for the cause of this paper we used MySQL Server database and MySQLi database (Maria DB) and the result on Scalability and Performance of these two databases synchronization was accurate.
Keywords: Authentication; SQL; Server; Database; API; curl; Microsoft.
DOI: https://doi.org/10.5281/zenodo.7845100
PDF: https://ijirst.demo4.arinfotech.co/assets/upload/files/IJISRT23APR669.pdf
REFERENCES