Data processing: database and file management or data structures – Database and file access – Query optimization
Reexamination Certificate
2007-10-18
2010-06-15
Le, Debbie M (Department: 2168)
Data processing: database and file management or data structures
Database and file access
Query optimization
C707S796000
Reexamination Certificate
active
07739265
ABSTRACT:
A first continuous query is deleted from several continuous queries that are being executed, by performing different actions that depend on how resources are shared therebetween. As an example, a second continuous query is deleted if a view is referenced by the first continuous query, and if the view is built on the second continuous query, and if the view is not referenced by any query other than the first continuous query. Such deletion is followed by compiling the second continuous query, followed by updating the view to refer to a newly-compiled version of the second continuous query. As another example, if an operator in the first continuous query is not used by any other query, this operator is de-scheduled from execution, and any exclusively-owned resources are released. Also, data to be read by the operator and data generated by the operator, if present in shared resources, are deleted therefrom.
REFERENCES:
patent: 7403959 (2008-07-01), Nishizawa et al.
patent: 2006/0230029 (2006-10-01), Yan
patent: 2007/0136254 (2007-06-01), Choi et al.
patent: 2008/0028095 (2008-01-01), Lang et al.
patent: 2008/0046401 (2008-02-01), Lee et al.
patent: 2009/0043729 (2009-02-01), Liu et al.
Shivnath Babu, Continuous Queries Over Data Streams, ACM 2001, pp. 1-16.
Entire Prosecution History of U.S. Appl. No. 11/873,407, filed Oct. 16, 2007 by Namit Jain et al.
Arasu, A. et al. “Stream: The Stanford Data Stream Management System”, Department of Computer Science, Stanford University, 2004, pp. 21.
Chandrasekaran, S. et al. “TelegraphCQ: Continuous Dataflow Processing for an Uncertain World”, Proceedings of CIDR 2003, pp. 12.
Chen, J. et al. “NiagaraCQ: A Scalable Continuous Query System for Internet Databases”, Proceedings of 2000 ACM SIGMOD, pp. 12.
Terry, D.B. et al. “Continuous queries over append-only databases”, Proceedings of 1992 ACM SIGMOD, pp. 321-330.
Arasu, A. et al. “The CQL Continuous Query Language: Semantic Foundation and Query Execution”, VLDB Journal, vol. 15, Issue 2, Jun. 2006, pp. 32.
Arasu, A. et al. “An Abstract Semantics and Concrete Language for Continuous Queries over Streams and Relations”, 9thInternational Workshop on Database programming languages, Sep. 2003, pp. 12.
Babu, S. et al. “Continuous Queries over Data Streams”, SIGMOD Record, Sep. 2001, pp. 12.
Munagala, K. et al. “Optimization of Continuous Queries with Shared Expensive Filters”, Proceedings of the 26thACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, believed to be prior to Oct. 17, 2007, pp. 14.
Buza, A. “Extension of CQL over Dynamic Databases”, Journal of Universal Computer Science, vol. 12, No. 9, 2006, pp. 12.
Avnur, R. et al. “Eddies: Continuously Adaptive Query Processing”, In Proceedings of the 2000 ACM SIGMOD International Conference on Management of Data, Dallas, TX, May 2000, pp. 12.
Avnur, R. et al. “Eddies: Continuously Adaptive Query Processing”, slide show, believed to be prior to Oct. 17, 2007, pp. 4.
Madden, S. et al. “Continuously Adaptive Continuous Queries (CACQ) over Streams”, SIGMOD, 2002, pp. 6.
Deshpande, A. et al. “Adaptive Query Processing”, believed to be prior to Oct. 17, 2007, pp. 27.
Widom, J. et al. “CQL: A Language for Continuous Queries over Streams and Relations”, believed to be prior to Oct. 17, 2007, pp. 31.
Motwani, R. et al. “Models and Issues in Data Stream Systems”, Proceedings of the 21stACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, 2002, pp. 26.
Widom, J. et al. “The Stanford Data Stream Management System”, believed to be prior to Oct. 17, 2007, pp. 24.
Oracle Application Server 10 g Release 2 and 3, New Features Overview, An Oracle White Paper, Oct. 2005, pp. 48.
Stream Query Repository: Online Auctions, http://www-db.stanford.edu/stream/sqr/onauc.html#queryspecsend , Dec. 2, 2002, pp. 2.
Stream Query Repository: Online Auctions (CQL Queries), http://www-db.stanford.edu/stream/sqr/cql/onauc.html , Dec. 2, 2002, pp. 3.
Entire Prosecution History of U.S. Appl. No. 11/874,197, filed Oct. 17, 2007 by Namit Jain et al.
Entire Prosecution History of U.S. Appl. No. 11/874,202, filed Oct. 17, 2007 by Namit Jain et al.
Entire Prosecution History of U.S. Appl. No. 11/874,896, filed Oct. 18, 2007 by Namit Jain et al.
Entire Prosecution History of U.S. Appl. No. 11/977,439, filed Oct. 20, 2007 by Namit Jain et al.
Entire Prosecution History of U.S. Appl. No. 11/977,437, filed Oct. 20, 2007 by Namit Jain et al.
Entire Prosecution History of U.S. Appl. No. 11/977,440, filed Oct. 20, 2007 by Namit Jain et al.
Entire Prosecution History of U.S. Appl. No. 11/874,197, filed Oct. 16, 2007 by Namit Jain et al.
Jain Namit
Mishra Shailendra Kumar
Srinivasan Anand
Le Debbie M
Oracle International Corporation
Silicon Valley Patent & Group LLP
Suryadevara Omkar
LandOfFree
Deleting a continuous query from a data stream management... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Deleting a continuous query from a data stream management..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Deleting a continuous query from a data stream management... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4223206