Method for storing data among different databases

Abstract

The invention relates to a method for storing data among different databases. The method includes the steps of obtaining order data from databases of order systems and a data structure {A1, A2 ... An}of the order data in each database; obtaining a data structure {B1, B2 ... Bm} in the database of each supply management system; sequentially comparing each item in {A1, A2 ... An} with the corresponding item in {B1, B2 ... Bm} to judge whether or nor Ai is equal to Bj; if yes, saving the corresponding relation between the both as Ck, and finally obtaining all corresponding relations {C1, C2 ...Cp}; saving order data of stores and supermarkets into the databases of the supply management systems according to the obtained corresponding relations {C1, C2 ... Cp}. Therefore, it can be ensured that order data can be automatically imported among the databases of the store and supermarket order systems and supply management systems of different suppliers without limits.

Description

Technical field [0001] The present invention generally relates to a method for storing data in a database, and more specifically, to a method for storing order data between different databases. Background technique [0002] As the e-commerce market grows and develops, automated supply chain management can establish convenient and fast information exchanges between supermarkets and suppliers. For example, supermarkets receive customer order data through the order system and integrate these order data. Provided to the supplier, the supplier enters the order data into its supply management system, so that it can learn more about the sales of various commodities in the supermarket according to the order situation and supply the corresponding commodities to the supermarket in time. [0003] However, in the prior art, there are many suppliers that provide commodities to supermarkets. Each supplier has its own commodity supply management system. The database used by each supplier's supply...

AI Technical Summary

Problems solved by technology

Due to the difference in data structure definitions in the supermarket order system and the supply management system database of each supplier, for example, the order data in the supermarket order system C contains the "customer address" data item, while the databases in the supply management systems A and B None of the data structures contain the "customer address" data item, so there will be situations where this data item cannot be imported. For example, the data structure in the supermarket order system C defines the "name" data item, while the supply management system B The data structure defines the "product name" data item, so there will be a problem whether the "name" data item in the supermarket order system C can be imported into the "product name" data item in the supply management system B