{'fraction_non_alphanumeric': 0.022573363431151242, 'fraction_numerical': 0.0, 'mean_word_length': 4.874172185430464, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
Global Index Oriented Non-Shard Key for Multi-tenant Database

For SaaS applications, multi-tenant data storage can be mixed to make full use of storage resources, which makes the single tenant's data may be spread across multiple data nodes. For queries based on shard key, they can be located directly to the relevant nodes. However, for queries based on non-shard key, they need to implement a global parallel retrieval even if there are indices on the conditions. In response to these issues, the paper introduces global index to multi-tenant data storage model. By publishing tenant's the local index to establish and maintain a global index entries, it can reduce the number of computing nodes involved in the query operation. Experiments and analysis shows that the global index effectively reduces the resource usage of parallel search operation to improve the query efficiency.