DATABASE HIERARCHICAL STRUCTURE VISION SYSTEM AND DATABASE HIERARCHICAL STRUCTURE VISION METHOD

摘要

PROBLEM TO BE SOLVED: To visualize data relations of a database hierarchical structure.;SOLUTION: A database hierarchical structure vision system includes; an update function part 40 for extracting, in a table unit, rule definition information stored in a rule definition database 10 and updating the information; an analysis sort function part 60 for analyzing a data hierarchical structure on the basis of table relations and output items, both read from the rule definition database 10, and rearranging pieces of data in accordance with an output sequence rule; an output function part 70 for outputting the pieces of analyzed and sorted data to a spread data sheet; and an SQL sentence generation function part 80 for generating an SQL sentence by analyzing relations of table data contained in the spread data sheet and outputting the generated SQL sentence to a hierarchical structure database 50.;COPYRIGHT: (C)2014,JPO&INPIT