Snowtrail
| Autor: | Stratis D. Viglas, Jin Qiuye, Allison Lee, Shrainik Jain, Jiaqi Yan |
|---|---|
| Rok vydání: | 2018 |
| Předmět: |
Service (systems architecture)
Database Computer science business.industry 05 social sciences Cloud computing 02 engineering and technology computer.software_genre 050601 international relations Data warehouse Database testing 0506 political science Metadata 020204 information systems 0202 electrical engineering electronic engineering information engineering Cloud database Snowflake business computer |
| Zdroj: | DBTest@SIGMOD |
| DOI: | 10.1145/3209950.3209958 |
| Popis: | Database as a service provided on cloud computing platforms has been rapidly gaining popularity in recent years. The Snowflake Elastic Data Warehouse (henceforth referred to as Snowflake) is a cloud database service provided by Snowflake Computing. The cloud native capabilities of new database services such as Snowflake bring exciting new opportunities for database testing. First, Snowflake maintains extensive knowledge of historical customer queries, including both the query text and corresponding system configurations. Second, Snowflake is multi-tenant, which provides easy access to metadata and data that can be used to rerun customer queries from a privileged role. Furthermore, the elastic nature of Snowflake's data warehouse service allows testing with these queries using a separate set of resources without impacting the customer's production workload.This paper presents Snowtrail, an infrastructure developed within Snowflake for testing using customer production queries with result obfuscation. Running tests with production queries provides us with direct insight into the impact of improvements and new features on customer workloads. It enables testing on queries of more shapes and complexity than can be manually constructed by developers. Snowtrail is also used to help ensure the stability of the online upgrade process of the system. |
| Databáze: | OpenAIRE |
| Externí odkaz: |
|