Task 2 & 3 : China Unicom (Model, methodology, measurement, accuracy)

From the previous case study of China Unicom, here i would like to shows China Unicom model, methodology, measurement, and accuracy.

MODEL & METHODOLOGY
 1. Classification Model.

• Because they make some comparison between their database (HBase) and Oracle. They compare and identify the insertion rate of traffic records and data query experiments in concurrent query transactions are based on the data set.
• Hbase in China unicom classified as noSQL column.

MEASUREMENT & ACCURACY

• This is Classification of the insertion rate of traffic records in Oracle database.

• This is a classification of The insertion speed of records in China Unicom system.

• From the picture (Fig 4&5), we know that the Oracle insertion rate will decrease dramatically (by about 4 times) after 500 000 traffic records are inserted, and the more records inserted, the slower the insertion rate becomes. Compared with Oracle database, China Unicom HBase shows very consistent performance, and the peak insertion rate reaches approximately 100 000 records per second.
• Fig. 4 shows negative correlation because their rate of traffic record is decrease dramatically.

• This is data query experiments in concurrent query transactions with Oracle database:

• This is data query experiments in concurrent query transactions with China Unicom system.

• From the picture (Fig 6&7) For Oracle database, the higher the number of concurrent query transactions conducted, the slower the average response time becomes. The impact of the size of records in the database has a deleterious effect on the query performance. However, for China Unicom optimized HBase system, the latency of most responses is in milliseconds, and the impact of the records already in the database is quite low compared with Oracle database.
• Compared with the proprietary solution, the open source solution adopted by China Unicom offers us more advantages to optimize data storage, speed up database transactions, and achieve better performance.