SYSTEM AND METHOD FOR MANAGING SHOPS THROUGH DATA CONSISTENCY ON DISTRIBUTED DATABASE ENVIRONMENT BY TRANSMITTING QUERY SENTENCE TO CENTRAL SERVER

摘要

PURPOSE: A system and a method for managing shops through data consistency on a distributed database environment are provided to make databases consistent by storing the failed transaction data as a query sentence to a queue if a local database of a shop client PC is failed to update a host database of a central server, and transmitting the query sentence to the central server if the network is restarted. CONSTITUTION: The shop client PCs(2) comprise a communication part(22), the local database(23) storing various kinds of data according to a shop management work, the queue(24) storing the failed transaction data as query sentence data if the local database is failed to update the host database(33), and a controller(21) storing the failed transaction data as the query sentence data to the queue if the local database is failed to update the host database and making the host database update the query sentence for predetermined time intervals. The central server(3) comprises a server communication part(32), the host database storing the transaction data and the data of the local database according to the query sentence data received from the shop client PCs, and a server controller(31).