Apparatus and method for modification of a saved database query based on a change in the meaning of a query value over time

a technology of database query and modification method, applied in the field of computer database system, can solve the problems of inconvenient generation and storage of queries for future use, affecting the usefulness of future use, and the value used in stored queries may become outdated

a technology of database query and modification method, applied in the field of computer database system, can solve the problems of inconvenient generation and storage of queries for future use, affecting the usefulness of future use, and the value used in stored queries may become outdated

US20070208722A1Inactive Publication Date: 2007-09-06IBM CORP
13 Cites 20 Cited by

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Apparatus and method for modification of a saved database query based on a change in the meaning of a query value over time
  • Apparatus and method for modification of a saved database query based on a change in the meaning of a query value over time
  • Apparatus and method for modification of a saved database query based on a change in the meaning of a query value over time

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

1.0 Overview

[0022] The present invention relates to database queries. For those not familiar with databases or queries, this Overview section will provide background information that will help to understand the present invention.

Known Databases and Database Queries

[0023] There are many different types of databases known in the art. The most common is known as a relational database (RDB), which organizes data in tables that have rows that represent individual entries or records in the database, and columns that define what is stored in each entry or record.

[0024] To be useful, the data stored in databases must be able to be efficiently retrieved. The most common way to retrieve data from a database is to generate a database query. A database query is an expression that is evaluated by a database manager. The expression may contain one or more predicate expressions that are used to retrieve data from a database. For example, lets assume there is a database for a company that incl...

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

An apparatus and method modify a saved query based on a change in a query value meaning that changes over time. In preferred embodiments a graphical query interface displays an option to adjust query values of a saved database query. A query adjustment mechanism then adjusts the value of the query to compensate for the change in the meaning of the query value since the query was created such that the adjusted query will have the same basic meaning as when the query was originally created. Preferred Embodiments allow the user to specify to adjust the query to the current date or to a specified date in the past.

Description

BACKGROUND OF THE INVENTION [0001] 1. Technical Field [0002] This invention generally relates to computer database systems, and more specifically relates to apparatus and methods for modification of a saved query based on a change in the meaning of a query value that changes with the passage of time. [0003] 2. Background Art [0004] Database systems have been developed that allow a computer to store a large amount of information in a way that allows a user to search for and retrieve specific information in the database. For example, an insurance company may have a database that includes all of its policy holders and their current account information, including payment history, premium amount, policy number, policy type, exclusions to coverage, etc. A database system allows the insurance company to retrieve the account information for a single policy holder among the thousands and perhaps millions of policy holders in its database. [0005] Retrieval of information from a database is ty...

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
06 Sep 2007
Publication
US20070208722A1
IPC
G06F17/30
CPC
G06F17/3064; G06F16/3322
Inventors
DETTINGER, RICHARD DEAN; KOLZ, DANIEL PAUL