论文部分内容阅读
大型的超市集团,通常设置一个总部,下属大约有60—100个中型分店。对于每个分店来说,每天数据库都要产生大量数据,包括销售记录、库存品项、价格管理记录、客户关系分析记录等等,这些数据需要传递到超市总部的数据交换中心。对于超市总部的ERP系统来说,由于业务需要及连续性分析的考虑,系统要求查询大量的数据,比如促销记录、同期比等等。而对于很多的基础数据,系统要求保留3至4年,但长时间并不会访问处理。因此,如果将所有数据都保存在
Large supermarket groups, usually set up a headquarters, subordinate about 60-100 medium-sized stores. For each branch, a large amount of data is generated daily from the database, including sales records, inventory items, price management records, customer relationship analysis records, etc., and these data need to be passed to the data exchange center of the supermarket headquarter. For the ERP system of the supermarket headquarters, due to business needs and continuity analysis, the system requires a large amount of data to be queried, such as promotion records, same period, and so on. For a lot of basic data, the system requires retention of 3 to 4 years, but it will not be accessed for a long time. So, if all the data is kept there