Multitenant Database Statistics Synchronization
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Traditional database statistical mechanisms are inadequate in multitenant environments, failing to provide consistent and up-to-date data analysis across multiple instances, which is critical for organizations requiring real-time data, such as call centers.
Innovation Solution
Implementing a mechanism to automatically generate and update database statistics in a multitenant environment by parsing statistics files, such as OracleStats.xml, into a SortedMap, and using formulas to calculate essential statistics like table rows, block sizes, and index details, ensuring efficient data management and synchronization across instances.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Device complexity
If traditional database statistical mechanisms are used in multitenant environments, then device complexity is reduced, but measurement precision and reliability of statistical data deteriorate
Solution Approach 1:
The patent segments the statistical collection process by implementing separate statistics collection mechanisms for different tenants in the multitenant database environment. Each tenant's statistics are collected and maintained independently, ensuring measurement precision for each tenant while managing complexity through modular organization of the statistical collection system.
2Ease of operation
If traditional database statistical mechanisms are used, then ease of operation is maintained, but productivity and timeliness of data analysis deteriorate
Solution Approach 1:
The patent implements preliminary action by continuously and automatically collecting and updating statistical data in the background before it is needed for analysis. This proactive approach ensures that accurate, up-to-date statistical information is readily available when schema requesters need it, improving productivity without adding operational complexity.
3Reliability
If automatic statistics generation is implemented in multitenant environments, then reliability and consistency of statistical data improve, but device complexity increases
Solution Approach 1:
The patent applies universality by creating a unified automatic statistics generation mechanism that serves multiple tenants simultaneously. The system collects, processes, and maintains statistical data for different tenants using a common framework, ensuring consistency and reliability across all tenants while avoiding the complexity of implementing separate mechanisms for each tenant.
Data Source
AI summary
Statistics mechanisms in multitenant database environments. A master statistics file is maintained in a multitenant database system. The master statistics file has statistics corresponding to multiple tenants within the multitenant database system. Statistics for a selected table within the multitenant database system are generated. The selected table corresponding to a selected tenant of the multitenant database system. The master statistics file is updated based on the generated statistics for the selected table.