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:
Oct. 05, 2021
Filed:
Sep. 12, 2018
Hitachi, Ltd., Tokyo, JP;
Yasunari Takai, Tokyo, JP;
Keishi Ooshima, Tokyo, JP;
Katsumi Kawai, Tokyo, JP;
Makoto Kimura, Tokyo, JP;
Kiyoshi Yamaguchi, Tokyo, JP;
HITACHI, LTD., Tokyo, JP;
Abstract
A table relation analysis assisting apparatus analyzes a relation between pieces of data in a certain column (external key) astride tables in a relational database. The apparatus analyzes a relation between tables and holds inter-table relation analysis information in which tables, pieces of data in the tables being in a one to one relation or a plural to one relation, are defined as one table group. In the apparatus, an analysis result display unit provides a display in such a form that one or more tables in a relational database are contracted into a table group. The display unit displays table groups in such a form that which of a one to one relation or a plural to one relation a relation between pieces of data included therein is astride tables can be viewed.