(10 billion - 1 billion data in the table, take several periods of 20150101 ~ 20180101)
Delivery packing list number phone string code state
2017/1/5 PL001 IMEI10001 has shipped
2017/1/12 PL002 IMEI10002 unfilled
... .
Table 2: the real flow detail (6 billion)
MONGO database(6 billion - 1 billion data in the table, take several caliber: flowing water type: water delivery)
Packing list number phone string code delivery time customer the arrival of the goods flowing water type
2017/1/5 PL001 IMEI10001 START HW delivery water
2017/1/12 PL002 IMEI10002 HW client A
the arrival of the running water. ... ... Sold water
2017/2/5 IMEI10003...
2017/4/1 IMEI10004
2017/7/9 IMEI10005
Table 3: old detail delivery system (1 billion) the ORACLE database 2
(1 billion)
Packing list number phone string code delivery time customer
2017/1/5 PL001 IMEI10001...
2017/1/12 PL002 IMEI10002... .
. ...
2017/2/5 IMEI10003
2017/4/1 IMEI10004
2017/7/9 IMEI10005
Requirements: from the following three tables, according to the summary packing list, the total number of mobile phone, according to the packing list number contrast three database data gap,
Please make your own choice to use technology tools, output program design, including database model design, and to consider performance factors,
CodePudding user response:
CodePudding user response:
This is the rhythm of the graduation thesis writing? Free have used