Ticket #67 (new task) — at Version 8

Opened 14 years ago

Last modified 14 years ago

商城数据库迁移到另一台oracle服务器

Reported by: huangzhong Owned by:
Priority: major Milestone: 2012年6.0版本
Component: 系统相关 Version: 6.0
Keywords: 数据库迁移 数据同步 Cc:
Due Date: 31/01/2012

Description (last modified by huangzhong) (diff)

商城和产品库的数据库拆分，影响比较小的做法是把所用到的产品库的表、视图、同义词都在商城建立同名同数据结构的表，通过定时任务把数据从产品库同步到商城，在商城这边通过同义词和临时表的方式进行无缝切换(类似v_ent_product_1和v_ent_product_2的处理)，只是更新频率及更新的先后顺序要仔细考虑。

1.V_PDL_PRODUCT
产品库产品视图,数据量316583,每天更新一次

2.V_PDL_PRODUCT_TYPE
产品库产品类别视图,数据量13448,每天更新一次

3.V_PDL_PRODUCT_VARIANCE
产品库产品系列视图,数据量9144,每周更新一次

4.V_PP_AREA
产品库报价地区视图,数据量36,建议手动更新

5.V_PP_PRICE
产品库产品报价视图，数据量4032582，对商城来说，有意义的只是全国报价，v_pdl_product里的price就是全国报价，所以这个视图可以去掉(相应代码要做处理)

Change History

comment:1 Changed 14 years ago by huangzhong

  • Keywords 数据库迁移 added
  • Version set to 6.0

comment:2 Changed 14 years ago by huangzhong

  • Component changed from 商家后台 to 系统相关

comment:3 Changed 14 years ago by chenchongqi

  • Type changed from defect to task
  • Description modified (diff)

comment:4 Changed 14 years ago by huangzhong

  • Description modified (diff)

comment:5 Changed 14 years ago by huangzhong

  • Description modified (diff)

comment:6 Changed 14 years ago by huangzhong

  • Description modified (diff)

comment:7 Changed 14 years ago by huangzhong

  • Description modified (diff)

comment:8 Changed 14 years ago by huangzhong

  • Description modified (diff)
Note: See TracTickets for help on using tickets.