Method and system by using temporary performance objects for enhanced query performance

A performance, object technology, applied in the field of information management, which can solve problems such as long read times

Inactive Publication Date: 2014-06-25
IBM CORP
View PDF4 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Existing MQTs don't have startup time to use it, but utilizing existing MQTs can result in long read times, since additional I / O on list objects generally has to be performed to determine which records to discard and which to return to the user

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
  • Method and system by using temporary performance objects for enhanced query performance
  • Method and system by using temporary performance objects for enhanced query performance
  • Method and system by using temporary performance objects for enhanced query performance

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0015] Various embodiments of the invention provide techniques for improving the processing and optimization of database queries in an RDBMS by combining data from external data sources external to the database and the RDBMS. Various embodiments of the invention are presented below by way of example with reference to MQTs. However, it should be understood that the present invention is applicable to any type of performance object that can be used to improve the performance of an input query. As mentioned above, performance issues generally arise in complex data situations that include, in addition to RDBMS, external data sources like social media, RSS feeds, structured files, and the like. Accordingly, various embodiments of the present invention are particularly applicable in such situations.

[0016] According to one embodiment, temporary MQTs are created after taking into account various performance implications. For faster query performance and without any negative impact...

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

The invention provides a method and a system by using temporary performance objects for enhanced query performance, and discloses a method and an apparatus, including computer program products, implementing and using techniques for optimizing query performance in a relational database management system. A query is received at the relational database management system. It is determined whether the query is expected to be a long-running query. In response to determining that the query is expected to be a long-running query, a full table scan is started in order to fetch records needed to satisfy the query from the relational database management system. In parallel with conducting the full table scan, a performance object is built, which is capable of satisfying the query in the relational database management system. In response to completing the construction of the performance object prior to completing the full table scan, the full table scan is stopped and the newly built performance object is used instead to satisfy the query.

Description

technical field [0001] The present invention relates to the field of information management, and more particularly to improved processing and optimization of database queries in database management systems. There are many kinds of databases. A common form is a relational database management system (RDBMS) made by International Business Machines Corporation of Armonk, NY, such as DB2 TM system. Background technique [0002] The RDBMS is responsible for handling all requests to access the database where the data itself is actually stored, thereby shielding the user from any specific hardware implementation details. Using relational technology, an RDBMS stores, manipulates, and retrieves data in the form of table-like relationships typically defined by a set of columns or attributes of a data type and a set of rows (ie, records or tuples) of the data. Columns may also include restrictions on their data content (ie, valid fields) and may be designated as primary keys or uniqu...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F17/30442G06F16/2453G06F16/284G06F16/2477
Inventor D·L·卡明斯基R·H·帕拉萨德G·萨达拉姆
Owner IBM CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap