TABLE RELATIONSHIP ANALYSIS SUPPORT APPARATUS AND TABLE RELATIONSHIP ANALYSIS SUPPORT METHOD

摘要

To make it easy to intuitively understand a relationship of tables in a relational database by focusing on an appearance relationship of data.SOLUTION: A table relationship analysis support apparatus for analyzing a relationship of data in a particular column (external key) between tables in a relational database analyzes a relationship between the tables, and holds inter-table relationship analysis information defining a table with one-to-one relationship and many-to one relationship of data of the table as one table group. An analysis result display unit displays one or more table of the relational database as a table group in a shorten form. In addition, display of the table group is displayed in a manner that the relationship of the data between the included tables can be visually understood whether to be the one-to one relationship or the many-to-one relationship. Furthermore, a graph form linking between the tables is displayed as a display form of the table group.SELECTED DRAWING: Figure 18