Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2004-12-17
2008-08-19
Lewis, Cheryl (Department: 2167)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
07415487
ABSTRACT:
An apparatus and method for implementing data warehousing systems. According to a first embodiment, a system may include a plurality of data warehouses, and a data warehouse manager configured to extract data sets from one or more data sources for storage in one or more of the plurality of data warehouses. Each of a first subset including two or more of the plurality of data warehouses may be configured to store a respective replica of a first data set extracted by the data warehouse manager. Further, the data warehouse manager may be further configured to allow a query dependent upon the first data set to be evaluated by one of the first subset of data warehouses before each respective replica of the first data set has been stored to a corresponding data warehouse of the first subset.
REFERENCES:
patent: 6167405 (2000-12-01), Rosensteel et al.
patent: 6178418 (2001-01-01), Singer
patent: 6263337 (2001-07-01), Fayyad et al.
patent: 6374251 (2002-04-01), Fayyad et al.
patent: 6438538 (2002-08-01), Goldring
patent: 6550057 (2003-04-01), Bowman-Amuah
patent: 6922685 (2005-07-01), Greene et al.
patent: 2002/0087501 (2002-07-01), Breitbart et al.
patent: 2003/0182312 (2003-09-01), Chen et al.
patent: 2003/0182319 (2003-09-01), Morrison
patent: 2004/0181509 (2004-09-01), Dettinger et al.
patent: 2005/0065944 (2005-03-01), Gunther et al.
patent: 2005/0210082 (2005-09-01), Shutt et al.
patent: 2005/0240354 (2005-10-01), Mamou et al.
Chaudhuri, et al., “An Overview of Data Warehousing and OLAP Technology,” SIGMOD Record, vol. 26, No. 1, Mar. 1997, pp. 65-74.
Plattner, et al. “Ganymed: Scalable Replication for Transactional Web Applications,” IFIP International Federation for Information Processing, 2004, vol. 3231, Oct. 18, 2004, pp. 155-174.
Delmolino, “Strategies and Techniques for Using Oracle7 Replication,” Oracle Coporation, 1995, 14 pages.
Adiba, et al., “Database Snapshots,” IBM Research Report, Mar. 7, 1980, pp. 1-16.
Lindsay, et al., “A Snapshot Differential Refresh Algorithm,” SIGMOD Record, vol. 15, No. 2, Mar. 28, 1986, pp. 53-60.
Adiba, et al., “Derived Relations: A Unified Mechanism for Views, Snapshots and Distributed Data,” Institute of Electrical and Electronics Engineers, IEEE, Sep. 9-11, 1981, pp. 293-305.
Ram, et al., “Extracting Delta for Incremental Data Warehouse Maintenance,” IEEE, 2000, pp. 220-229.
Matt Loney, “The Magic that makes Google Tick,” http://www.zdnet.com.au/insight/software/0,39023769,39168647,00, Dec. 2, 2004, (5 pages).
Ghemawat et al., “The Google File System,” SOSP'03, Oct. 19-22, 2003, (15 pages).
Ghemawat et al., “Google File System,” Google Weblog, Google Technical Paper, Sep. 20, 2003, (1 page).
Justin Poetsch et al., “The New Amazon Datacenter Network,” Amazon.com, Inc., Jul. 2004, (3 pages).
Demers, et al., “Epidemic Algorithms for Replicated Database Maintenance,” ACM 1987, pp. 1-12.
“Epidemic Protocols (or Gossip is Good)”, Oct. 7, 1999, found at http://www.cs.cornell.edu/home/rvr/presentations/gossip/ppframe.html, 33 pages (2-sided).
Amazon.com, “Amazon.com Presentation at Oracle World,” San Francisco, Nov. 2002, 19 pages (2-sided).
IBM, “Grid File Replication Manager,” Aug. 5, 2004, 2 pages.
International Search Report for PCT/US2005/045349, mailed Apr. 19, 2006, 9 pages.
Bell Christopher R.
Boyd Paul J.
Dunlap Mark E.
Amazon Technologies Inc.
Kowert Robert C.
Lewis Cheryl
Meyertons Hood Kivlin Kowert & Goetzel P.C.
Petro Anthony M.
LandOfFree
Apparatus and method for data warehousing does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Apparatus and method for data warehousing, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Apparatus and method for data warehousing will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4004805