Virtual columns

Details Virtual columns Virtual columns

2007-12-06

2011-12-13

Brown, Sheree (Department: 2163)

Data processing: database and file management or data structures

File management

File systems

C707S609000, C707S821000, C707S963000, C717S136000

Reexamination Certificate

active

08078652

ABSTRACT:
Techniques are described herein for performing column functions on virtual columns in database tables. A virtual column is defined by the database to contain results of a defining expression. Statistics are collected and maintained for virtual columns. Indexing is performed on virtual columns. Referential integrity is maintained between two tables using virtual columns as keys. Join predicate push-down operations are also performed using virtual columns.

REFERENCES:
patent: 589986 (1897-09-01), Shay
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: 6275818 (2001-08-01), Subramanian et al.
patent: 6477523 (2002-11-01), Chiang
patent: 6524664 (2003-02-01), Hashimoto et al.
patent: 6529901 (2003-03-01), Chaudhuri 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: 6775662 (2004-08-01), Witkowski et al.
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: 7302422 (2007-11-01), Bossman et al.
patent: 7458066 (2008-11-01), Rhine
patent: 7693812 (2010-04-01), Lim et al.
patent: 7739293 (2010-06-01), Lightstone et al.
patent: 7836098 (2010-11-01), Baby et al.
patent: 2001/0016843 (2001-08-01), Olson et al.
patent: 2002/0087518 (2002-07-01), Ellis 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: 2004/0034643 (2004-02-01), Bonner et al.
patent: 2005/0234841 (2005-10-01), Miao et al.
patent: 2005/0240624 (2005-10-01), Ge et al.
patent: 2006/0206507 (2006-09-01), Dahbour
patent: 2007/0083483 (2007-04-01), Lawande
patent: 2008/0120321 (2008-05-01), Liu et al.
patent: 2008/0120322 (2008-05-01), Liu et al.
patent: 2008/0172353 (2008-07-01), Lim et al.
patent: 2008/0172360 (2008-07-01), Lim et al.
patent: 2009/0018992 (2009-01-01), Zuzarte et al.
patent: 2009/0019077 (2009-01-01), Baby et al.
U.S. Appl. No. 11/951,918, filed Dec. 6, 2007, Office Action mailed Dec. 1, 2010.
U.S. Appl. No. 11/951,933, filed Dec. 6, 2007, Final Office Action mailed Dec. 23, 2010.
Notice of Allowance U.S. Appl. No. 11/951,918, filed Dec. 6, 2007, Correspondence Mailing Date Jul. 21, 2011.
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

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 Virtual columns, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Virtual columns will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4266951