Supercharge Your Innovation With Domain-Expert AI Agents!

Methods and apparatus for query rewrite with auxiliary attributes in query processing operations

A technology of attributes and equipment, applied in the field of new predicates, to achieve the effect of maintaining accuracy

Inactive Publication Date: 2005-03-30
IBM CORP
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] 2. View abstraction is involved in the query: Since the view definition is hidden from the query author, the query involving the view can only be expanded by the database (expand)

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
  • Methods and apparatus for query rewrite with auxiliary attributes in query processing operations
  • Methods and apparatus for query rewrite with auxiliary attributes in query processing operations
  • Methods and apparatus for query rewrite with auxiliary attributes in query processing operations

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] The following description will use an example data processing system architecture to illustrate the principles of the present invention. The principles of the present invention are not limited to use with any particular system architecture. Rather, it applies more generally to any data processing system that wants to implement efficient and efficient query processing operations.

[0019] The term "database" as used herein is intended to include any data storage software and systems, such as relational databases like IBM DB2 and Oracle 9. The term "data record" as used herein is intended to include any logically structured association of data in a database, eg, rows in a table of a relational database. The terms "attribute" and "data attribute" as used herein are intended to include any element of a data record, such as a column value of a row. As used herein, the term "Target Attribute" is intended to mean any attribute that specifically appears in a User's query. Th...

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

Methods and apparatus are provided for rewriting queries during a database query processing operation to include auxiliary attributes not included in the original query, thus improving processing efficiency. For example, in one aspect of the invention, a technique for rewriting a query in a query processing operation includes the following steps. First, the query is processed in accordance with at least a portion of a data set, producing query results. Second, data attributes from the query results are analyzed. Finally, at least one new predicate from at least one auxiliary data attribute is appended on the query.

Description

technical field [0001] The present invention relates to query processing operations in databases and other information systems, and more particularly to rewriting queries during database query processing operations to include a new predicate derived from data attributes. Background technique [0002] Given the growing volume of online business transactions, the efficiency of query processing of large amounts of data stored in databases, data warehouses, and other information systems has become increasingly important. Since the late 1970s, throughout academia and industry, there has been ongoing research and development activity on efficient query processing operations in stand-alone databases, hierarchical databases, hierarchical databases, spatial databases, and databases on the World Wide Web. A comprehensive review of reported query processing techniques is available from a number of sources, see, for example: G. Graefe, "Query Evaluation Techniques for Large Databases," ...

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/30G06F7/00
CPCG06F17/30595Y10S707/99935G06F17/30448Y10S707/99933Y10S707/99932Y10S707/99934G06F16/24534
Inventor 张元极马修·L·希尔
Owner IBM CORP
Features
  • R&D
  • 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