英语翻译淘宝网店企业的企业级数据库建设专业:信息与计算科学学号:学生：指导教师：摘要：本文主要是对淘宝网店企业的企业级数据库的建设进行研究,使用到的数据库是SQL,主要分以

Question

英语翻译
淘宝网店企业的企业级数据库建设
专 业:信息与计算科学 学 号:
学 生：指导教师：
摘要：本文主要是对淘宝网店企业的企业级数据库的建设进行研究,使用到的数据库是SQL,主要分以下步骤完成.首先,对原始数据字段特点进行分析,初步了解字段的类别、长度,以便在将数据导入SQL的时候不出现错误.然后将原始数据导入到SQL中,对数据进行初步的清理,剔除无效的或者是残缺以至于影响到正常的使用的数据,并且根据以后使用时可能遇到的实例,添加可以由原始数据中的字段中得出的新字段,对于原始数据中记录不规范的数据,也将在这一步中进行处理使其规范化,以便于日后的使用.最后,根据不同数据的特点已经日后的使用频率,将这些数据进行分别的储存,并且设计相应的存储过程,通过比对,找出最佳方案.最终需要达到的目标是数据库能够快速而准确的提取以及录入数据,使数据分析的效率提高.
关键词：淘宝；企业级数据库；存储过程；SQL

Answer 1

Enterprise-level Database Construction of Taobao Online Shops
Major:Information and Computing Science Student No.:
Student Name:Instructor Name:
Abstract:
This paper is mainly to study the construction of enterprise-level database of
Taobao online shops,where database – SQL is used and the following steps are
applied.Firstly,the characters of the original data fields are analyzed to
have a preliminary understanding of field category and length and avoid
mistakes when importing data into SQL.Then,original data are imported into
SQL for preliminary clearing with ineffective or defected data (which may influence
normal use) eliminated,with new fields that can be obtained from the fields of
the original data added according to examples that may occur during future use,
and with non-standardized data recorded as the original data processed to be
standardized for future use.Finally,according to characters of different data
and their frequency of future use,these data are stored respectively under the
corresponding stored procedure in order to find the premium scheme by comparison.
In general,the final goal is that database is capable to extract and enter data
rapidly and accurately so as to improve the efficiency to analyze data.Key words:Taobao,enterprise-level database,stored
procedure,SQL