Bizarre Patents
Mouse device with a built-in printer
A mouse device for use as an input device of a computer is provided that includes a housing in which recording paper is loadable, and a printer unit provided within the housing for printing on the recording paper print information received from the computer.
PatentStorm News
Make the Most of PatentStorm
See this month's Top Inventors and Most Cited Patents.
Stay on top of the latest patents by subscribing to an RSS feed.
Got questions? Ask a Patent Expert!
Registered users: Manage your profile, comments and alerts.
US Patent 6708179 - Incremental refresh of materialized views for many-to-many relationships
US Patent Issued on March 16, 2004
Estimated Patent Expiration Date:
October 2, 2021Estimated Expiration Date is calculated based on simple USPTO term provisions. It does not account for terminal disclaimers, term adjustments, failure to pay maintenance fees, or other factors which might affect the term of a patent.
Estimated Patent Expiration Date:
October 2, 2021Estimated Expiration Date is calculated based on simple USPTO term provisions. It does not account for terminal disclaimers, term adjustments, failure to pay maintenance fees, or other factors which might affect the term of a patent.AbstractA framework for the incrementally refreshing a materialized view is provided. The materialized view is based on a query that references a projected table and another set of base tables. The query projects the columns of the projected table. To refresh the materialized view, a set of tuples is computed that identify rows to delete, insert, or otherwise modify in the materialized view in order to refresh it. The set of tuples is computed by computing a set of intersections, (1) one for the intersection between the query and the change log of the projected table, and (2) at least one other between the equijoin of the change log for one of the other base tables and the projected table. The query may define an equijoin between the projected table and at least one base table based on equijoin conditions that define a many-to-many relationship or a one-to-many relationship. | InventorApplicationNo. 09969938 filed on 10/02/2001US Classes:707/102, Generating database or data structure (e.g., via user interface)707/3Query processing (i.e., searching)Field of Search707/2, Access augmentation or optimizing707/3, Query processing (i.e., searching)707/10, Distributed or remote access707/102, Generating database or data structure (e.g., via user interface)707/103R, Object-oriented database structure707/201, Coherency (e.g., same view to multiple users)707/203Version managementExaminersPrimary: Mizrahi, Diane D.Attorney, Agent or FirmInternational ClassG06F 1730 |
