Data processing: database and file management or data structures – Database and file access – Query optimization
Reexamination Certificate
2006-12-28
2010-06-01
Fleurantin, Jean B. (Department: 2162)
Data processing: database and file management or data structures
Database and file access
Query optimization
C707S741000, C707S803000, C707S809000
Reexamination Certificate
active
07730056
ABSTRACT:
This disclosure provides various embodiments of software for utilizing a common database layout. In one aspect, a first database table having a first layout and a generic index is accessed using a first instance of a query, and a second database table having a second layout and the generic index is accessed using a second instance of the query. Some implementations may have a generic index that consists of a globally unique identifier. Other implementations may have a generic index that is a combination of database table fields. In some implementations, the first and second database tables may be resident in a first data repository, and the software may access a third database table having a third layout and the generic index using a third instance of the query, wherein the third database table is resident in a second data repository.
REFERENCES:
patent: 5129082 (1992-07-01), Tirfing et al.
patent: 5555403 (1996-09-01), Cambot et al.
patent: 5584024 (1996-12-01), Shwartz
patent: 5701453 (1997-12-01), Maloney et al.
patent: 5701460 (1997-12-01), Kaplan et al.
patent: 5806075 (1998-09-01), Jain et al.
patent: 5809497 (1998-09-01), Freund et al.
patent: 5895465 (1999-04-01), Guha
patent: 5907846 (1999-05-01), Berner et al.
patent: 5917965 (1999-06-01), Cahill et al.
patent: 5974421 (1999-10-01), Krishnaswamy et al.
patent: 6023696 (2000-02-01), Osborn et al.
patent: 6035294 (2000-03-01), Fish
patent: 6035300 (2000-03-01), Cason et al.
patent: 6067552 (2000-05-01), Yu
patent: 6078926 (2000-06-01), Jensen et al.
patent: 6085189 (2000-07-01), Pirahesh et al.
patent: 6108651 (2000-08-01), Guha
patent: 6151602 (2000-11-01), Hejlsberg et al.
patent: 6160796 (2000-12-01), Zou
patent: 6181837 (2001-01-01), Cahill et al.
patent: 6243709 (2001-06-01), Tung
patent: 6356901 (2002-03-01), MacLeod et al.
patent: 6374235 (2002-04-01), Chen et al.
patent: 6405209 (2002-06-01), Obendorf
patent: 6434558 (2002-08-01), MacLeod et al.
patent: 6460052 (2002-10-01), Thomas et al.
patent: 6516326 (2003-02-01), Goodrich et al.
patent: 6601071 (2003-07-01), Bowker et al.
patent: 6609123 (2003-08-01), Cazemier et al.
patent: 6636846 (2003-10-01), Leung et al.
patent: 6668263 (2003-12-01), Cranston et al.
patent: 6721754 (2004-04-01), Hurst et al.
patent: 6763352 (2004-07-01), Cochrane et al.
patent: 6820076 (2004-11-01), Bailey et al.
patent: 6829606 (2004-12-01), Ripley
patent: 6895412 (2005-05-01), Hutchinson
patent: 6938029 (2005-08-01), Tien
patent: 7085757 (2006-08-01), Dettinger et al.
patent: 7085784 (2006-08-01), Krishna et al.
patent: 7152073 (2006-12-01), Gudbjartsson et al.
patent: 7225177 (2007-05-01), Wu et al.
patent: 7249118 (2007-07-01), Sandler et al.
patent: 7373393 (2008-05-01), Sonoda et al.
patent: 7383284 (2008-06-01), Heinrichs et al.
patent: 7383288 (2008-06-01), Miloushev et al.
patent: 7406457 (2008-07-01), Kaiser
patent: 7409387 (2008-08-01), Dietel
patent: 7424685 (2008-09-01), Behrens et al.
patent: 7496596 (2009-02-01), Li et al.
patent: 2002/0087558 (2002-07-01), Bailey et al.
patent: 2002/0111960 (2002-08-01), Irons et al.
patent: 2002/0147725 (2002-10-01), Janssen et al.
patent: 2003/0120665 (2003-06-01), Fox et al.
patent: 2003/0204450 (2003-10-01), Heinrichs et al.
patent: 2003/0204480 (2003-10-01), Heinrichs et al.
patent: 2003/0208417 (2003-11-01), Heinrichs et al.
patent: 2004/0036719 (2004-02-01), Van Treeck
patent: 2004/0093344 (2004-05-01), Berger et al.
patent: 2004/0153469 (2004-08-01), Keith-Hill
patent: 2004/0163041 (2004-08-01), Engel
patent: 2004/0193087 (2004-09-01), Albus et al.
patent: 2004/0216030 (2004-10-01), Hellman et al.
patent: 2005/0010606 (2005-01-01), Kaiser et al.
patent: 2005/0019854 (2005-01-01), Gross et al.
patent: 2005/0060286 (2005-03-01), Hansen et al.
patent: 2005/0076023 (2005-04-01), Wu et al.
patent: 2005/0086201 (2005-04-01), Weddeling et al.
patent: 2005/0097568 (2005-05-01), Behrens et al.
patent: 2005/0108237 (2005-05-01), Sonoda et al.
patent: 2005/0108272 (2005-05-01), Behrens et al.
patent: 2005/0114318 (2005-05-01), Dettinger et al.
patent: 2005/0147300 (2005-07-01), Dresevic et al.
patent: 2005/0149484 (2005-07-01), Fox et al.
patent: 2005/0149584 (2005-07-01), Boubonnais et al.
patent: 2005/0198003 (2005-09-01), Duevel et al.
patent: 2005/0256852 (2005-11-01), McNall et al.
patent: 2005/0278395 (2005-12-01), Sandaire
patent: 2005/0284934 (2005-12-01), Ernesti et al.
patent: 2005/0289020 (2005-12-01), Bruns et al.
patent: 2006/0020578 (2006-01-01), Hood
patent: 2006/0047622 (2006-03-01), Folkert et al.
patent: 2006/0047638 (2006-03-01), Dettinger et al.
patent: 2006/0074914 (2006-04-01), Kaiser
patent: 2006/0074979 (2006-04-01), Kaiser
patent: 2006/0085372 (2006-04-01), Kaiser
patent: 2006/0136354 (2006-06-01), Bell et al.
patent: 2006/0136481 (2006-06-01), Dehn et al.
patent: 2006/0224487 (2006-10-01), Galdi
patent: 2006/0253470 (2006-11-01), Friedman et al.
patent: 2006/0288036 (2006-12-01), Sadovsky et al.
patent: 2006/0294120 (2006-12-01), Li et al.
patent: 2007/0005552 (2007-01-01), Klein et al.
patent: 2007/0005599 (2007-01-01), Klein et al.
patent: 2007/0005640 (2007-01-01), Klein et al.
patent: 2007/0005666 (2007-01-01), Klein et al.
patent: 2007/0016596 (2007-01-01), Fabret et al.
patent: 2007/0097076 (2007-05-01), Gross
patent: 2007/0100868 (2007-05-01), Hackmann
patent: 2007/0162468 (2007-07-01), Dentzer et al.
patent: 2007/0174309 (2007-07-01), Pettovello
patent: 2007/0271161 (2007-11-01), Kaiser
patent: 2007/0282858 (2007-12-01), Arner et al.
patent: 2008/0033907 (2008-02-01), Woehler et al.
patent: 2008/0086409 (2008-04-01), Moorman et al.
patent: 2008/0098003 (2008-04-01), Dias et al.
patent: 2008/0126969 (2008-05-01), Blomquist
patent: 2008/0154950 (2008-06-01), Gross
patent: 2008/0162205 (2008-07-01), Gross
patent: 2008/0162207 (2008-07-01), Gross et al.
patent: 2008/0162457 (2008-07-01), Dehn et al.
patent: 2008/0162492 (2008-07-01), Dehn et al.
patent: 2008/0162563 (2008-07-01), Gross et al.
patent: 2008/0162616 (2008-07-01), Gross et al.
patent: 2008/0162777 (2008-07-01), Kaiser et al.
“Heterogeneous Query Processing through SQL Table Functions”—Reinwald et al.—Data Engineering, 1999, Proceedings, 15th International Conference, Mar. 23-26, 1999 (pp. 366-373).
“Access Methods for Next Generation Database Systems”—Marcel Kornacker—University of California at Berkeley—Fall 2000 (pp. 1-164) (SAI.MSU.SU).
“Chapter 7: Architectures and Implementaions of Spatio-Temporal Database Management Systems”—Breunig et al.—Springer Berlin / Heidelberg, Sep. 16, 2003 (pp. 263-318).
Office Action issued in related U.S. Appl. No. 11/647,802 on Nov. 14, 2008; 20 pages.
Office Action issued in related U.S. Appl. No. 11/647,802 on May 4, 2009; 20 pages.
Advisory Action issued in related U.S. Appl. No. 11/647,802 on Jul. 8, 2009; 3 pages.
Office Action issued in related U.S. Appl. No. 11/647,768 on Nov. 17, 2008; 19 pages.
Office Action issued in related U.S. Appl. No. 11/647,768 on May 1, 2009; 22 pages.
Advisory Action issued in related U.S. Appl. No. 11/647,768 on Jul. 8, 2009; 3 pages.
United States Patent Office's prosecution file for U.S. Appl. No. 11/647,802; 182 pages.
United States Patent Office's prosecution file for U.S. Appl. No. 11/647,768; 181 pages.
Office Action issued in U.S. Appl. No. 11/647,802 on Aug. 18, 2009; 17 pages (Our Ref.: 23067-0027001).
Li Xu et al.; “A Composite Approach to Automating Direct and Indirect Schema Mappings”; Information Systems 31 (2006); pp. 697-732.
Notice of Panel Decision from Pre-Appeal Brief Review issued in U.S. Appl. No. 11/647,768 on Sep. 17, 2009; 3 pages (Our Ref.: 20017-0038001).
Examiner's Answer to Appeal Brief issued in U.S. Appl. No. 11/647,768 on Dec. 2, 2009; 22 pages (Our Ref.: 20017-0038001).
Anzuinelli Gisella Dominguez
Dehn Rene
Gross Rene
Kaiser Martin
Fish & Richardson P.C.
Fleurantin Jean B.
Ly Anh
SAP (AG)
LandOfFree
Software and method for utilizing a common database layout does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Software and method for utilizing a common database layout, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Software and method for utilizing a common database layout will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4193455