Expression replacement in virtual columns

Details Expression replacement in virtual columns Expression replacement in virtual columns

2007-12-06

2011-10-25

Brown, Sheree (Department: 2163)

Data processing: database and file management or data structures

Database and file access

Query optimization

Reexamination Certificate

active

08046352

ABSTRACT:
Techniques are described herein for replacing a part of an expression in a query to a database with a virtual column. A virtual column is defined by the database to contain results of a defining expression. A part of an expression in a query is replaced with a virtual column whose defining expression is equal to the part of the expression in the query. The part of an expression in a query can be the entire expression. When an expression in a query can be replaced with more than one replacement expression involving virtual columns, the replacement expression with the least cost of query processing is selected.

REFERENCES:
patent: 5761653 (1998-06-01), Schiefer et al.
patent: 5822142 (1998-10-01), Hicken
patent: 5899986 (1999-05-01), Ziauddin
patent: 5960428 (1999-09-01), Lindsay et al.
patent: 5995957 (1999-11-01), Beavin et al.
patent: 6006219 (1999-12-01), Rothschild
patent: 6029163 (2000-02-01), Ziauddin
patent: 6112199 (2000-08-01), Nelson
patent: 6477523 (2002-11-01), Chiang
patent: 6524664 (2003-02-01), Hashimoto et al.
patent: 6609131 (2003-08-01), Zait et al.
patent: 6665684 (2003-12-01), Zait et al.
patent: 6711563 (2004-03-01), Koskas
patent: 6820095 (2004-11-01), Yeung et al.
patent: 6830785 (2004-12-01), Hayakawa et al.
patent: 6931390 (2005-08-01), Zait et al.
patent: 7143105 (2006-11-01), Nakano et al.
patent: 7158994 (2007-01-01), Smith et al.
patent: 7158996 (2007-01-01), Croisettier et al.
patent: 7171408 (2007-01-01), Zuzarte
patent: 7458066 (2008-11-01), Rhine
patent: 7693812 (2010-04-01), Lim et al.
patent: 7836098 (2010-11-01), Baby et al.
patent: 2001/0016843 (2001-08-01), Olson et al.
patent: 2002/0194157 (2002-12-01), Zait et al.
patent: 2003/0084025 (2003-05-01), Zuzarte
patent: 2003/0149702 (2003-08-01), Saffer et al.
patent: 2006/0206507 (2006-09-01), Dahbour
patent: 2007/0083483 (2007-04-01), Lawande
patent: 2008/0172353 (2008-07-01), Lim et al.
patent: 2008/0172360 (2008-07-01), Lim et al.
patent: 2009/0019077 (2009-01-01), Baby et al.
U.S. Appl. No. 11/951,933, filed Dec. 6, 2007, Restriction Requirement, Mailing Date Mar. 23, 2010.
U.S. Appl. No. 11/951,890, filed Dec. 6, 2007, Restriction Requirement, Mailing Date Mar. 24, 2010.
U.S. Appl. No. 11/951,890, filed Dec. 6, 2007, Final Office Action, Mailing Date Dec. 23, 2010.
U.S. Appl. No. 11/951,933, filed Dec. 6, 2007, Final Office Action, Mailing Date Dec. 23, 2010.
Ian Smith, “Guide to Using SQL: Computed and Automatic Columns”, Oracle Rdb Journal—Automatic Columns, Sep. 2008 (originally May 2002), http://www.oracle.com/technetwork/database/rdb/automatic-columns-132042.pdf, 9 pages.

Affiliated with

Also associated with

Rating

Expression replacement in virtual columns does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Expression replacement in virtual columns, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Expression replacement in virtual columns will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4273853