This paper is mainly to study the construction of the Taobao shop business enterprise database， the database is SQL， mainly consists of the following First， carries on the analysis to the original data field characteristics， a preliminary understanding of the field type， length， so that the data into the SQL is not Then the raw data into SQL， a preliminary to clean data， eliminate invalid or incomplete that affect the normal use of the data， and according to the instance may encounter when using the new words after， add it in the original data from the field of， for non-standard data recording of raw data， will also carry out the standardization in this step， in order to facilitate the future Finally， according to the different characteristics of data has been the future use frequency， these data are stored， and the design of the stored procedure， the corresponding through comparison， find out the best The final target is database can be fast and accurate extraction and input data， make data analysis efficiency
Enterprise-level Database Construction of Taobao Online ShopsMajor: Information and Computing Science Student N:Student Name: Instructor Name:Abstract:This paper is mainly to study the construction of enterprise-level database ofTaobao online shops， where database – SQL is used and the following steps Firstly， the characters of the original data fields are analyzed tohave a preliminary understanding of field category and length and avoidmistakes when importing data into SQL Then， original data are imported intoSQL for preliminary clearing with ineffective or defected data (which may influencenormal use) eliminated， with new fields that can be obtained from the fields ofthe original data added according to examples that may occur during future use，and with non-standardized data recorded as the original data processed to bestandardized for future Finally， according to characters of different dataand their frequency of future use， these data are stored respectively under thecorresponding stored procedure in order to find the premium scheme by In general， the final goal is that database is capable to extract and enter datarapidly and accurately so as to improve the efficiency to analyze Key words: Taobao， enterprise-level database， storedprocedure， SQL
Building/Development of a Corporate Database for Taobao On-line Store BusinessesSpecialty: Information and Computing ScienceStudent’s ID:Name of Student:Guiding Teachers:Abstract:This article mainly focuses on the study of developing a corporate database for Taobao on-line store businesses using the SQL It was done in the following steps:Firstly， it analyzed the characteristics of raw data fields and made a preliminary understanding of the types and lengths of fields， so that no error would be made while importing data into SQLThen the raw data were imported into SQL for a preliminary cleaning-up to eliminate invalid or incomplete data which may affect the normal use of the data， and， according to the instances which may be encounter in future use， added new fields derived from the field of raw data， and standardized the non-standard data recorded in raw data in this process so as to facilitate the future Finally， the data were stored/saved separately according to their characteristics and use frequencies of the different data， and corresponding store/save procedures were designed to find out the best scheme by means of comparison，The ultimate goal was that the database could extract and input data fast and accurately to improve the efficiency of data Keywords: Taobao; Corporate Database; Stored/Save Procedure; SQL;
