Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-07-24
2007-07-24
Gaffin, Jeffrey (Department: 2165)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C709S223000
Reexamination Certificate
active
10150763
ABSTRACT:
In general, in one aspect, the invention relates to a method for transaction processing. The method includes specifying metadata and storing the metadata. An index is created in response to the stored metadata. The method also includes receiving a transaction, generating an index log of changes to the index in response to the received transaction, and modifying the first index in response to the generated index log.
REFERENCES:
patent: 5204958 (1993-04-01), Cheng et al.
patent: 5664160 (1997-09-01), Fecteau et al.
patent: 5778370 (1998-07-01), Emerson
patent: 5794229 (1998-08-01), French et al.
patent: 5842196 (1998-11-01), Agarwal et al.
patent: 5918225 (1999-06-01), White et al.
patent: 5963954 (1999-10-01), Burrows
patent: 6003039 (1999-12-01), Barry et al.
patent: 6006225 (1999-12-01), Bowman et al.
patent: 6009432 (1999-12-01), Tarin
patent: 6014670 (2000-01-01), Zamanian et al.
patent: 6029170 (2000-02-01), Garger et al.
patent: 6035306 (2000-03-01), Lowenthal et al.
patent: 6044374 (2000-03-01), Nesamoney et al.
patent: 6070158 (2000-05-01), Kirsch et al.
patent: 6073140 (2000-06-01), Morgan et al.
patent: 6078918 (2000-06-01), Allen et al.
patent: 6108647 (2000-08-01), Poosala et al.
patent: 6108659 (2000-08-01), Vincent
patent: 6119128 (2000-09-01), Courter et al.
patent: 6230166 (2001-05-01), Velamuri et al.
patent: 6286005 (2001-09-01), Cannon
patent: 6341388 (2002-01-01), Yach et al.
patent: 6377948 (2002-04-01), Kikuchi et al.
patent: 6377953 (2002-04-01), Gawlick et al.
patent: 6377958 (2002-04-01), Orcutt
patent: 6405187 (2002-06-01), Egan et al.
patent: 6405208 (2002-06-01), Raghavan et al.
patent: 6408292 (2002-06-01), Bakalash et al.
patent: 6411950 (2002-06-01), Moricz et al.
patent: 6418450 (2002-07-01), Daudenarde
patent: 6434544 (2002-08-01), Bakalash et al.
patent: 6513041 (2003-01-01), Tarin
patent: 6832229 (2004-12-01), Reed
patent: 2001/0000536 (2001-04-01), Tarin
patent: 2001/0047360 (2001-11-01), Huras et al.
patent: 2001/0049694 (2001-12-01), Daudenarde
patent: 2002/0029207 (2002-03-01), Bakalash et al.
patent: 2002/0035562 (2002-03-01), Roller et al.
patent: 2002/0055932 (2002-05-01), Wheeler et al.
patent: 2002/0059260 (2002-05-01), Jas
patent: 2002/0091696 (2002-07-01), Craft et al.
patent: 2002/0095421 (2002-07-01), Koskas
patent: 2002/0107957 (2002-08-01), Zargham et al.
patent: 2003/0061537 (2003-03-01), Cha et al.
patent: 2004/0107286 (2004-06-01), Larson et al.
Blakeley, et al., “Efficiently Updating Materialized Views,” Proc. of SIGMOD, Washington, 1986.
Blakeley, et al., “Updating Derived Relations: Detecting Irrelevant and Autonomously Computable Updates,” ACM Transactions on Database Systems, vol. 14, No. 3, Sep. 1989.
Gupta, et al., “Maintaining Views Incrementally,” ACM SIGMOD International Conference, Washington, D.C., May 1993.
Griffin, et al., “Incremental Maintenance of Views with Duplicates,” Proc. of SIGMOD, 1995.
Dallan Quass, “Maintenance Expression for Views with Aggregation,” Proc. of SIGMOD, 1996, Workshop on Materialized Views.
Dimitra Vista, “Optimizing Incremental View Maintenance Expression in Relational Databases,” 1996.
Zhao, et al., “On the Performance of an Array-based ADT for OLAP Workloads,” Aug. 29, 1996.
Zhao, et al., “Array-Based Evaluation of Multi-Diminesional Queries in Object-Relational Database Systems,” Feb. 21, 1997.
“Warehouse Administrator's Guide for UNIX Platforms,” Red Brick Warehouse Version 5.1, Chapter 3 “Schema Design,” Red Brick, Jan. 1998.
Dennis Shasha, “Time Series in Finance: the array database approach,” VLDB Conference, Aug. 1998.
Zhao, et al., “Simultaneous Optimization and Evaluation of Multiple Dimensional Queries,” Proc. ACM-SIGMOD, 1998.
Berry, et al., “Matrices, Vector Spaces, and Information Retrieval,” SIAM Review, vol. 41, No. 2, pp. 335-362, Apr. 23, 1999.
“Multi-Dimensional Databases and Online Analytical Processing,” slide presentation, 1999.
“Informix Red Brick Decision Server,” Informix, Version 6.10, Technical Brief, 2000.
Sand Technology Library, “Nucleus Server White Paper,” 2001.
Oracle, “Oracle9i Materialized Views,” May 2001.
Purcell, et al., “Evolution of Star join Optimization,” DB2 Universal Database, Oct. 2001.
“Column-Based Analytical Technology: The Missing Piece of the Data Analytics Puzzle,” Alterian, Oct. 2001.
“Nucleus Proves Itself a Super-Scalable iSeries Solution at the Teraplex,” IBM, 2001.
“Nucleus Executive Overview,” Sand Technology, 2001.
“SAS/Warehouse Administrator 2.2 offers metadata-driven automation,” SAS Institute Inc., 2001.
“Project Proposal: Vector database engine,” 2002.
“The IDUG Solutions Journal,” Solutions Journal, vol. 9 No. 1, Mar. 2002.
Duval, et al., “Metadata Principles and Practicalities,” D-Lib Magazine, vol. 8, No. 4, Apr. 2002.
Philip Howard, “Aleri—An Evaluation by Bloor Research,” Bloor Research, May 2, 2002.
Stata, et al., “The Term Vector Database: fast access to indexing terms for Web pages,” Proc. of the 9thInternational World Wide Web Conference, Amsterdam, Netherlands, May 2002.
“Red Brick Warehouse,” IBM, Downloaded from Web, Aug. 2002.
“Anglo Irish Bank,” DecisionWorks Case Study, DecisionWorks, Downloaded from Web, Aug. 2002.
“Innovations in data warehousing—Answering Complex, Real-Time and Dynamic Queries,” Bloor Research, Aug. 2002.
“RODIN Data Warehousing,” Downloaded from Web, Aug. 2002.
Palpanas, et al., “Incremental Maintenance for Non-Distributive Aggregate Functions,” Proc. of VLDB Conference Hong Kong, Aug. 2002.
International Search Report for PCT/US03/15273 dated Jul. 10, 2003 (4 ps.).
Blakeley, et al., “Efficiently Updating Materialized Views,” Proc. of SIGMOD, Washington, 1986.
Blakeley, et al., “Updating Derived Relations: Detecting Irrelevant and Autonomously Computable Updates,” ACM Transactions on Database Systems, vol. 14, No. 3, Sep. 1989.
Gupta, et al., “Maintaining Views Incrementally,” ACM SIGMOD International Conference, Washington, D.C., May 1993.
Griffin, et al., “Incremental Maintenance of Views with Duplicates,” Proc. of SIGMOD, 1995.
Dallan Quass, “Maintenance Expression for Views with Aggregation,” Proc. of SIGMOD, 1996, Workshop on Materialized Views.
Dimitra Vista, “Optimizing Incremental View Maintenance Expression in Relational Databases,” 1996.
Zhao, et al., “On the Performance of an Array-based ADT for OLAP Workloads,” Aug. 29, 1996.
Zhao, et al., “Array-Based Evaluation of Multi-Diminesional Queries in Object-Relational Database Systems,” Feb. 21, 1997.
“Warehouse Administrator's Guide for UNIX Platforms,” Red Brick Warehouse Version 5.1, Chap. 3 “Schema Design,” Red Brick, Jan. 1998.
Dennis Shasha, “Time Series in Finance: the array database approach,” VLDB Conference, Aug. 1998.
Zhao, et al., “Simultaneous Optimization and Evaluation of Multiple Dimensional Queries,” Proc. ACM-SIGMOD, 1998.
Berry, et al., “Matrices, Vector Spaces, and Information Retrieval,” SIAM Review, vol. 41, No. 2, pp. 335-362, Apr. 23, 1999.
“Multi-Dimensional Databases and Online Analytical Processing,” slide presentation, 1999.
“Informix Red Brick Decision Server,” Informix, Version 6.10, Technical Brief, 2000.
Sand Technology Library, “Nucleus Server White Paper,” 2001.
Oracle, “Oracle9i Materialized Views,” May 2001.
Purcell, et al., “Evolution of Star join Optimization,” DB2 Universal Database, Oct. 2001.
“Column-Based Analytical Technology: The Missing Piece of the Data Analytics Puzzle,”
Kolodzieski Scott J.
Kornilovski Alexandre
Sandler Zigmund
Seroff Vladimir
Aleri, Inc.
Gaffin Jeffrey
Goodwin & Procter LLP
Mahmoudi Hassan
LandOfFree
Database system and methods does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Database system and methods, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database system and methods will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3818806