18063451. MONITORING OF RESOURCE CONSUMPTION PER TENANT simplified abstract (SAP SE)
Contents
MONITORING OF RESOURCE CONSUMPTION PER TENANT
Organization Name
Inventor(s)
Ruediger Karl of Waibstadt (DE)
Tobias Scheuer of Bruchsal (DE)
Patrick Voelker of Mannheim (DE)
MONITORING OF RESOURCE CONSUMPTION PER TENANT - A simplified explanation of the abstract
This abstract first appeared for US patent application 18063451 titled 'MONITORING OF RESOURCE CONSUMPTION PER TENANT
The abstract describes a system and method for managing resource limits for database tenants. It involves receiving a statement for execution in a database session associated with a specific tenant, determining resource limits for that tenant, calculating the total amount of resources consumed by the session, checking if the statement can be executed within the tenant's limits, and executing the statement if it complies with the limits.
- Reception of a statement for execution in a database session linked to a specific tenant
- Determination of resource limits for the tenant
- Calculation of total resource consumption by the session
- Verification if the statement can be executed within the tenant's limits
- Execution of the statement if it meets the resource constraints
Potential Applications: - Database management systems - Cloud computing platforms - Multi-tenant environments
Problems Solved: - Efficient resource allocation in multi-tenant databases - Preventing resource contention among tenants - Ensuring fair resource usage across different tenants
Benefits: - Improved performance and stability of database instances - Enhanced security by enforcing resource limits - Better resource utilization and cost management for tenants
Commercial Applications: Title: "Resource Management System for Multi-Tenant Databases" This technology can be utilized in cloud service providers, SaaS companies, and enterprises with shared database environments to optimize resource usage and enhance overall system performance.
Prior Art: Readers can explore existing research on database resource management, multi-tenancy systems, and workload optimization in shared environments to understand the background of this innovation.
Frequently Updated Research: Stay updated on advancements in database resource management, tenant isolation techniques, and performance tuning strategies for multi-tenant systems to leverage the latest developments in this field.
Questions about Database Resource Management: 1. How does this system ensure fair resource allocation among different tenants? 2. What are the key challenges in implementing resource limits for database sessions in multi-tenant environments?
Original Abstract Submitted
Systems and methods include reception, at a database instance hosting a plurality of database tenants, of a statement for execution in a first database session associated with a first tenant, determination of first tenant-level resource limits associated with the database session, determination, for one or more resources, of a total amount consumed by the first database session, determination, based on the first tenant-level resource limits and the total amount of the one or more resources consumed by the first database session, of whether the statement can be executed by the database instance in compliance with the first tenant-level resource limits, and execution of the statement if it is determined that the statement can be executed by the database instance in compliance with the first tenant-level resource limits.
