Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Memory usage query governor

A memory and group query technology, applied in the field of database management, can solve the problem of query or request taking up large execution time and resources, etc.

Inactive Publication Date: 2012-05-30
IBM CORP
View PDF3 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] As database size and workload grow, specific queries or requests can consume significant execution time and resources

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Memory usage query governor
  • Memory usage query governor
  • Memory usage query governor

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0013] Since many computers have a finite amount of random access memory ("RAM") in which programs run, proper memory management is important to ensure efficient use of these limited resources. For this reason, in a database system, a database administrator may wish to limit the amount of memory that a particular query consumes when executed. That is, a database administrator may wish to refuse to execute a particular query if executing it would consume a large amount of system memory, impairing the execution of other queries and tasks on the system. Such a refusal can be deterministic (e.g., a message can be returned to the requesting entity stating that processing of the query is refused), or execution can be delayed until another time (e.g., the system can process the query when system resources become free ). This ensures that a single database query does not monopolize the system's resources.

[0014] Although memory resources of a computer may be fixed, there is a tech...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

Techniques for managing query execution based on memory usage using memory compression. Embodiments may receive a query from a requesting entity and estimate an amount of memory required to execute the query. Upon determining that executing the query would consume an impermissible amount of memory, embodiments may optimize the query by adjusting an amount of memory compression used in executing the query. The optimized query may then be executed to produce a set of query results, which may then be returned to the requesting entity.

Description

technical field [0001] The present invention relates generally to database management, and more particularly to managing memory utilization for queries using a query manager. Background technique [0002] A database is a computerized information storage and retrieval system. A relational database management system is a computer database management system (DBMS) that uses relational technology to store and retrieve data. An object-oriented programming database is one that fits data defined in object classes and subclasses. [0003] Regardless of the specific architecture, a requesting entity (for example, an application or an operating system) in the DBMS requests access to a specified database by issuing a database access request. Such requests may include, for example, a combination of simple catalog lookup requests or transactions, and transactions to read, change, and add specified records in the database. These requests (ie, queries) are typically generated using a hi...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30
CPCG06F12/00G06F17/30501G06F17/30471G06F17/30G06F16/24547G06F16/24561
Inventor E·L·巴斯尼斯P·S·尼尔塞斯图恩J·M·桑托索索
Owner IBM CORP
Features
  • Generate Ideas
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com