This topic describes how to use Object Storage Service (OSS) tables to perform an association query and analysis in Log Service.
Prerequisites
- Log data is collected. For more information, see Log collection.
- The indexing feature is enabled for the Logstore and indexes are configured. For more information, see Enable and configure the indexing feature for a Logstore.
- An OSS bucket is created. For more information, see Create buckets.
Background information
Assume that you have an electronic payment service company and you want to analyze the impact of user age, region, and gender on payment preferences. You have collected payment logs and saved user properties to an OSS bucket by using Log Service. The payment logs contain bills and payment methods. The user properties contain the region, age, and gender information of the users. The query and analysis engine of Log Service can perform an association query and analysis on the data stored in Logstores and external stores, such as MySQL and OSS. You can use the SQL JOIN syntax to associate the user payment logs with the user properties to analyze the payment preferences of these users.
- Low cost: If you store infrequently updated data in OSS buckets, you only need to pay for the storage service. Data can also be read from OSS buckets over the Internet without incurring traffic fees.
- Less workload: If you use the lightweight association analysis platform, you do not need to store all data in one storage system.
- High efficiency: If you use SQL statements to analyze data, you can view the analysis results in seconds. You can also define commonly used analysis results as reports. Then, you can click the reports to view the analysis results.