Invention Grant
- Patent Title: Efficient pushdown of joins in a heterogeneous database system involving a large-scale low-power cluster
-
Application No.: US14496090Application Date: 2014-09-25
-
Publication No.: US09613066B2Publication Date: 2017-04-04
- Inventor: Sam Idicula , Sabina Petride , Nipun Agarwal , Eric Sedlar
- Applicant: Oracle International Company
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Becker Bingham LLP
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A database management server manages a distributed data set at least partially stored in volatile memory of a plurality of nodes. The database management server stores transaction logs in persistent storage corresponding to one or more database transactions performed on the distributed data set. In response to a query, a join operation is performed with assistance from the cluster. A snapshot identifier identifies a particular database state that is transactionally consistent. Based on the transactional logs, updated data blocks updated after the snapshot identifier of the query are identified. The cluster is instructed to perform one or more distributed join operations on the distributed data set without processing data in the updated data blocks. The database management server performs a partial join evaluation on the updated data blocks.
Public/Granted literature
- US20150012486A1 Efficient Pushdown Of Joins In A Heterogeneous Database System Involving A Large-Scale Low-Power Cluster Public/Granted day:2015-01-08
Information query