一种基于“时间加速”思想的西藏CRM系统跨年建表保障方案设计与实现

Designing and Realizing A Scheme of Cross Year Creating Table Based on Time Acceleration Thought

西藏CRM业务支撑系统中,涉及大量的数据库表,用于保存三户资料(用户、客户、账户)、资源数据,以及用户订购关系等各类数据。在这些数据库表中,跨年保障关注的重点为年份表、月份表、日表,以及相关的索引等对象。为了尽量避免因建表遗漏或有误导致的业务异常,提高保障工作成功率,亟需在测试环境设计和实现一套基于"时间加速"思想,将时间提前进入1月1日并进行业务测试的方案。

CRM business support system of Tibet contains lots of tables in databases, so as to saving the three-account data(user, customer, and account), resources, and others like order data. The most important things concerned by this article is yearly table, monthly tables, daily tables, and the objects like indexes. So as to avoid service anomaly caused by this job, also to improving success rate, designing and implementing the scheme to realize service test in test environment based on 'time acceleration', which needs to change time from current time to January 1st directly, and this is urgent and important.