The Design And Implementation For KingbaseES Database Columnstorage Testing

With the continuous progress of the information society, more and more industries need to use the database system, database data carried more and more. Surge in Internet user groups to enjoy real-time information, e-commerce, social networking, mobile communications, e-government, location-based services, digital medical colleagues and other emerging Internet technologies, leading the explosive growth of digital information. Storage needs of enterprise data centers are becoming increasingly large, TB has increased from the previous level to PB level, even EB level. Therefore, based on indicators relating to query the database performance of big data has become increasingly important. So how to improve the performance of the database has become a pressing issue. Massive data processing to OLAP analysis Scene mostly traditional row-stored in OLAP analysis engine design applications inevitably encounter a bottleneck again.To solve the above problems, introduced the concept of a database column stores, it can greatly reduce the amount of data read and easy to analyze, store data in columns has been widely recognized and applied in analytical query load. Meanwhile KingbaseES also developed a corresponding database column storage engine. Its logical storage tissue stored in columns, not as line storage as a combination of columns in the table into a tuple of tuples is the smallest unit of access; but the definition of the table as the smallest unit of each access, when a query involves only some of the columns in the table, the other column values will not be accessible. This paper introduces the basic functions of KingbaseES column store database include.column store data types:System described in this article, mainly supported data types are string, numeric types, date and time types, bit string type, Boolean type. Where the bit string type as two requirements to achieve in the next version. The time interval type, binary string type, full-text search type, this version is not supported, but in time to do the test also covers these data types, column stores SQLrDDL statements include the level of demand is mainly supported:ANALYZE, CREATE TABLE/VIEW, DROP TABLE/VIEW; DML statement-level requirements include:DELETE, EXPLAIN, SELECT.Finally, the company developed the automated testing framework KAST as container, describes how to write automated test scripts, and how to use the KAST do automated testing. Finally completed the list of stored database function test in KingbaseES.