The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Sep. 30, 2025
Filed:
Sep. 19, 2023
Hitachi, Ltd., Tokyo, JP;
The University of Tokyo, Tokyo, JP;
Norifumi Nishikawa, Tokyo, JP;
Shinji Fujiwara, Tokyo, JP;
Mayuko Ozawa, Tokyo, JP;
Kazuhiko Mogi, Tokyo, JP;
Kazuo Goda, Tokyo, JP;
Yuto Hayamizu, Tokyo, JP;
HITACHI, LTD., Tokyo, JP;
THE UNIVERSITY OF TOKYO, Tokyo, JP;
Abstract
The scanning range of an inner table can be limited in the join processing irrespective of the existence of search conditions or a partition key, and the performance of the join processing can be improved. There is a column range index representing a range of values stored in a table. When a join result of a current stage is an outer table related to a join of a next stage in a join of each stage of the join processing, a database management apparatus identifies whether there is a possibility that an inner table related to a join of a next stage includes a hit record in an inner table related to a join of a current stage based on a column range index corresponding to a join column of a current stage and a column range index corresponding to a join column of a next stage.