Testing Of Teradata Database And Join Index Feature

As the rapid development of enterprise information technology, more and more companies start building their own Business Intelligence Decision Support System based on the data warehouse. Market information that used to make decision can be obtained by analysis of massive amounts of data. As time goes by, enterprise data information grow rapidly and the database needs more time to process query. Materialized view is a technology to minimizers total query response time to improve system performance. Materialized view is a permanent pre-join table or an aggregate expression pre-operation without violating the normalization of the database schema. You can retrieve the data from the materialized view not the underlying tables, so it improves the query performance.Teradata as a parallel database is becoming more and more popular for business intelligence system, Teradata refers to the materialized view structure by the term "Join Index". Join index is widely used in data warehouse, so the testing requirements of join index is important than ever. At the same time, Teradata join index feature is improved very faster, manual testing is just acceptable for new join index features, but integration testing requires a large number of complex and repeating testing, manual testing is difficult to complete. It’s more and more necessary and urgent to build functional automated testing system. The paper firstly investigates in the feature of Teradata join index; then analysis the testing process and design automation testing program. Testing program mainly includes design testing framework and test cases. In the paper, we combine our existing tools and testing requirements to design automated testing framework, then use Combinatorial Testing (CT) technique to generate join index definition use case set and summary test case generation rules.At last, build test environments of two modes-USCHEMA and DML mode. Through analyzing testing results, we assess the effectiveness of join index definition case set and test case generation rules.