Method and system for Thouse database migration

The invention discloses a Thouse database migration method and system, and relates to the field of big data analysis. The problems of automatic identification and creation of the optimal data table structure in the existing migration technology are solved. The method comprises the following steps: acquiring metadata information of a gbase database data table; according to the obtained metadata information, performing tagging processing on the data table; and according to a label result, automatically generating a creation statement by the Thouse database. The data table is subjected to tagging processing according to the obtained metadata information, and the tagging processing comprises an orientation rank and column storage tag, a hard key distribution key tag, a reuse copy table tag, a compression tag, a partition partition tag and a Sash tag. The method is applied to novel data processing. 一种用于TChouse数据库迁移方法和系统，涉及大数据分析领域。解决了现有迁移技术自动化的识别并创建最优的数据表结构的问题。所述方法包括：获取gbase数据库数据表元数据信息；根据获取的元数据信息，将数据表进行标签化处理；根据标签结果