1、 MPP NewSQL - - CTO- 2013 4 18 DTCC2013 2 GBase 8a MPP Cluster DW NoSQL KV Flash SSD Infiniband In Memory Computing) Flash Card SSD Infiniband 40G/s) DTCC2013 8 OldSQL TimesTen Altibase SolidDB Exadata Netezza Teradata NoSQL Hadoop HBase Bigtable Cassandra Dynamo Dremel Impala NewSQL GBase 8a Greenp
2、lum Vertica AsterData Sybase IQ F1/Spanner NewSQL Google F1/Spanner NoSQL Google Yahoo Amazon, Facebook OldSQL DTCC2013 NewSQL 9 NewSQL Sybase IQ + 2010 HANA + 2009 Vertica + MPP 2011 Greenplum + +MPP 2010 PDW + MPP 2013 GBase 8a + MPP (2008 ) NoSQL BigTable + Key Value Google 2004 HBase + Key Value
3、 2006 DTCC2013 10 + + 10% 30% 60% DTCC2013 11 GBase 8a MPP Cluster DW OLAP 28 OLAP DTCC2013 Roll back 4 18 35 SQL 8 7 SQL Roll back 2 4 SQL 5 9 SQL 3 15 SQL 22 DTCC2013 Merge Insert Update Delete Distinct 0 1000 2000 3000 4000 5000 DTCC2013 2240 2568.3 s 28 36.8 s 4.9 16.1 s SQL GBase 8a +MPP SQL SQ
4、L SELECT substr(CALL_BGN_TM,1,2), sum(CFEE), avg(LFEE), max(LFEE2), min(INFO_FEE), avg(DISC_CFEE), avg(DISC_LFEE), sum(DISC_LFEE2), sum(DISC_INFO_FEE), count(distinct(MSISDN) FROM _VOIC_ GROUP BY substr(ALL_BGN_TM,1,2); xxx_voic_xxx MSISDN hash DTCC2013 1 2240 +4.9 + 42 2008.7 s 2 5600 +4.9 + 12 223
5、0.4 s SQL SELECT count(A.MSISDN), sum(A.CALL_DUR), sum(A.UP_DAT_STRM_AMT), B.CMCC_PROV_PRVD_ID, C.BUSN_NAME FROM _CDR A JOIN _SVC_ _ B ON A.MSISDN=B.MSISDN JOIN _ _ _ _ C ON A.BUSN_CD =C.BUSN_CD WHERE A.CALL_BGN_TMYYYYMMDDHHMMSS AND B.SUBS_TYP_CD in(1,2) AND substr(A.MSISDN,1,2) in (13,15,18,14) GRO
6、UP BY B.CMCC_PROV_PRVD_ID,C.BUSN_NAME; GBase 8a MPP Cluster DTCC2013 5600 +4.9 20 100 42 3270.3 s 4.9 +28 100 100 1 7348.6 s GBase 8a Cluster SQL SELECT count(A.MSISDN), sum(A.CALL_DUR), sum(A.UP_DAT_STRM_AMT), B.CMCC_PROV_PRVD_ID, C.BUSN_NAME FROM xxx_CDR A JOIN _SVC_ _ B ON A.MSISDN=B.MSISDN JOIN
7、_ _ _ _ C ON A.BUSN_CD =C.BUSN_CD WHERE A.CALL_BGN_TM=20120114000000 and A.CALL_BGN_TM=20120114235959 and B.SUBS_TYP_CD in(1,2) and substr(A.MSISDN,1,2) in (13,15,18,14) GROUP BY B.CMCC_PROV_PRVD_ID,C.BUSN_NAME; SELECT count(*) FROM _SVC_ _ A LEFT OUTER JOIN _ B on A.SUBS_ID=B.SUBS_ID WHERE A.MSISDN= ; DTCC2013 insert GBase 8a Cluster insert 2 insert 20 2240 insert 100 insert 5.1 39233 s insert 100 4.9 insert 100 insert 1 27481 s DML insert SQL INSERT into _VOIC_ _TMP1 SELECT * FROM _VOIC_ WHERE CALL_BGN_DT =yyyymmdd SQL INSERT into _SVC_ _ _TMP1 SELECT * FROM _SVC_ _ WHERE MSISDN= DTCC2013
