智慧旅游信息平台数据库建设和架构设计

Construction and architecture design of database for smart tourism information platform

对于现阶段的智慧旅游信息平台来说,传统的数据库容易受到实时数据动态变化的影响,导致其节能性能效果较差。为了解决上述问题,文中提出智慧旅游信息平台数据库建设和架构设计。根据智慧旅游信息平台实际需求,设计数据库整体架构,使用GUEST处理SQL请求,实现数据库内待调用数据的存储定位。在此基础上,设计数据库分析功能,主要计算数据分析指标查找问题答案。在完成数据分析后,使用设计的数据编码规则对数据进行编码及存储,分析数据库主从结构,对于不同的事务请求,设计相对应的支持功能。至此,智慧旅游信息平台数据库建设完成。实验结果表明,与传统的数据库相比,文中数据库伸缩性更好,IOPS更低,节能性能更好。

As for the current smart tourism information platform,the traditional database is easily affected by the dynamic changes of real⁃time data,resulting in a poor energy⁃saving performance of it.In order to solve the above problem,the construction and architecture design of the database for the smart tourism information platform is proposed.The overall structure of the database is designed according to the actual needs of the smart tourism information platform,and GUEST is used to process the SQL requests,so as to realize the storage and positioning of the data to be called in the database.On this basis,the database analysis function is designed,which is mainly used to calculate data analysis indicators and find answers to questions.After completing data analysis,the designed data coding rule is used to encode and store the data,and analyze the master⁃slave structure of the database.The corresponding support function is designed for the different transaction requests.So far,the database construction of the smart tourism information platform is completed.The experimental results show that in comparison with traditional databases,the designed database has better scalability,lower IOPS and better energy⁃saving performance.