Software structuring system and method by data table translation
First Claim
1. A method developing software of a table translation type, said software being in the form of a string of commands for translating input tables into a desired output table, said software being developed by a processor, said method for developing software comprising the steps of:
- registering, if not yet registered, items and definition information representing definitions of said items in a first managing means;
registering, if not yet registered, inter-item dependence relation information representing inter-item dependence relations of said registered items in a second managing means based on said definition information of said items registered in said first managing means;
registering, if not yet registered, inter-item derivation relation information representing inter-item derivation relations of said registered items in a third managing means, wherein each inter-item derivation relation information represents a relationship between first and second registered items;
fetching inter-item dependence relation information from said second managing means and fetching inter-item derivation relation information from said third managing means corresponding to desired items of a desired output table in response to an input from a designer;
deriving various combinations of one or more input tables each including one or more of said items, related to said desired items of said desired output table, based on said fetched inter-item dependence relation information and said fetched inter-item derivation relation information, displaying said various combinations of said one or more input tables on a display means connected to said processor and selecting a combination from said various combinations in response to an input from said designer;
registering in a fourth managing means said desired items of said desired output table and said items, related to said desired items of said desired output table, of each of said input tables of the selected combination;
registering a name of said desired output table and names of said input tables of the selected combination in a fifth managing means; and
generating software for translating said input tables of the selected combination into said desired output table based on information registered in said third, fourth and fifth managing means, said software including a string of table translation commands;
said generating step includes the steps of;
fetching said name of said desired output table and said names of said input tables of the selected combination from said fifth managing means,selecting table translation commands from predetermined table translation commands based on a determination of whether said fetched name of said desired output table and said fetched means of said input tables are the same,fetching said desired items of said desired output table and said items, related to said desired items of said desired output table, of said input tables of the selected combination from said fourth managing means, andsetting information in said selected table translation commands of said name of said desired output table, said names of said input tables of the selected combination, said desired items of said desired output table and said items, related to said desired items of said desired output table, of said input tables of the selected combination.
0 Assignments
0 Petitions
Accused Products
Abstract
System and method of designing and developing table translation software in which an operation is performed on input data provided in the form of tables, and data resulting from the operation is also provided in the form of tables. The system includes an item input section for inputting items representative of attributes of data, a relation input section for inputting inter-item relations for the inputted items, an item and relation managing section for holding and supplying the inputted items and inter-item relations thereof, and a relation indicating section for indicating the items and the inter-item relations thereof held by the item and relation managing section. Software is designed and developed with the functions of the software being handled as translation processes of the tables.
57 Citations
4 Claims
-
1. A method developing software of a table translation type, said software being in the form of a string of commands for translating input tables into a desired output table, said software being developed by a processor, said method for developing software comprising the steps of:
-
registering, if not yet registered, items and definition information representing definitions of said items in a first managing means; registering, if not yet registered, inter-item dependence relation information representing inter-item dependence relations of said registered items in a second managing means based on said definition information of said items registered in said first managing means; registering, if not yet registered, inter-item derivation relation information representing inter-item derivation relations of said registered items in a third managing means, wherein each inter-item derivation relation information represents a relationship between first and second registered items; fetching inter-item dependence relation information from said second managing means and fetching inter-item derivation relation information from said third managing means corresponding to desired items of a desired output table in response to an input from a designer; deriving various combinations of one or more input tables each including one or more of said items, related to said desired items of said desired output table, based on said fetched inter-item dependence relation information and said fetched inter-item derivation relation information, displaying said various combinations of said one or more input tables on a display means connected to said processor and selecting a combination from said various combinations in response to an input from said designer; registering in a fourth managing means said desired items of said desired output table and said items, related to said desired items of said desired output table, of each of said input tables of the selected combination; registering a name of said desired output table and names of said input tables of the selected combination in a fifth managing means; and generating software for translating said input tables of the selected combination into said desired output table based on information registered in said third, fourth and fifth managing means, said software including a string of table translation commands; said generating step includes the steps of; fetching said name of said desired output table and said names of said input tables of the selected combination from said fifth managing means, selecting table translation commands from predetermined table translation commands based on a determination of whether said fetched name of said desired output table and said fetched means of said input tables are the same, fetching said desired items of said desired output table and said items, related to said desired items of said desired output table, of said input tables of the selected combination from said fourth managing means, and setting information in said selected table translation commands of said name of said desired output table, said names of said input tables of the selected combination, said desired items of said desired output table and said items, related to said desired items of said desired output table, of said input tables of the selected combination.
-
-
2. A system for designing software of a table translation type, said software being in the form of a string of commands for translating input tables into a desired output table, said system comprising:
-
a keyboard for interfacing with a designer; first managing means for registering items and definition information representing definitions of said items, said items being inputted through said keyboard; second managing means for registering dependent relation information representing dependent relations between said items registered in said first managing means, said dependent relation information being inputted through said keyboard; third managing means for registering derivative relation information representing derivative relations among said items registered in said first managing means, said derivative relation informatin being inputted through said keyboard; a display for displaying data; image interface means, operative in response to an input from said designer, for fetching from said second managing means dependent relation information of desired items of a desired output table, fetching from said third managing means derivative relation information of said desired items of said desired output table, fetching from said first managing means items, related to said desired items of said desired output table, based on said fetched dependent and derivative relation information, displaying on said display at least one combination of at least one input table comprising at least one of said fetched items, related to said desired items of said desired output table, and selecting in response to input from said designer a combination from said at least one combination; fourth managing means for registering said items, related to said desired items of said desired output table, of each input table of said selected combination and registering said desired items of said desired output table; fifth managing means for registering a name of said desired output table and names of said input tables of the selected combination; and means for generating software in the form of a string of table translation commands for translating said input tables of the selected combination into said desired output table based on information registered in said third, fourth and fifth managing means; said means for generating fetches said name of said desired output table and said names of said input tables of the selected combination from said fifth managing means, selects table translation commands from predetermined table translation commands based on a determination of whether said fetched name of said desired output table and said fetched names of said input tables are the same, fetches said desired items of said desired output table and said items, related to said desired items of said desired output table, of said input tables of the selected combination from said fourth managing means, and sets information in said selected table translation commands of said name of said desired output table, said names of said input tables of the selected combination, said desired items of said desired output table and said items, related to said desired items of said desired output table, of said input tables of the selected combination.
-
-
3. A method for developing software, on a processor, of a table translation type in which said software translates input tables into a desired output table, said method comprising the steps of:
-
registering, if not yet registered, items and definition information representing definitions of said items in a first managing means; registering, if not yet registered, inter-item dependence relations information representing inter-item dependence relations of said registered items in a second managing means; registering, if not yet registered, inter-item derivation relation information representing inter-item derivation relations of said registered items in a third managing means, wherein each inter-item derivation relation information defines a relationship between first and second registered items; fetching inter-item dependence relations information from said second managing means and fetching inter-item derivation relation information from said third managing means corresponding to desired items of a desired output table in response to input by a designer; deriving various combinations of one or more input tables each including one or more of said items, related to said desired items of said desired output table, based on said fetched inter-item dependence relation information and said fetched inter-item derivation relation information, displaying said various combinations of one or more input tables on a display means connected to said processor, and selecting in response to input from said designer a combination from said various combinations; registering in a fourth managing means said desired items of said desired output table and said items, related to said desired items of said desired output table, of each of said input tables of the selected combination; registering a name of said desired output table and names of said input tables of the selected combination in a fifth managing means; and developing software based on said registered names of said input tables and said desired output table, items of each table and inter-item derivation relation information for items constituting said input and desired output tables; said developing step includes the steps of; fetching said name of said desired output table and said names of said input tables of the selected combination from said fifth managing means, selecting table translation commands from predetermined table translation commands based on a determination of whether said fetched name of said desired output table and said fetched names of said input tables are the same, fetching said desired items of said desired output table and said items, related to said desired items of said desired output table, of said input tables of the selected combination from said fourth managing means, and setting information in said selected table translation commands of said name of said desired output table, said names of said input tables of the selected combination, said desired items of said desired output table and said items, related to said desired items of said desired output table, of said input tables of the selected combination.
-
-
4. A system for designing software of a table translation type in which said software translates input tables into a desired output table, said system comprising:
-
a keyboard for interfacing with a designer; first managing means for registering items and definition information representing definitions of said items, said items being inputted through said keyboard; second managing means for registering dependent relation information representing dependent relations between said items registered in said first managing means, said dependent relations being inputted through said keyboard; third managing means for registering derivation relation information representing derivation relations among said item registered in said first managing means, said derivation relation information being inputted through said keyboard; a display for displaying data; image interface means, operative in response to input from said designer, for fetching from said second managing means dependent relation information of desired items of a desired output table, fetching from said third managing means derivation relation information of said desired items of said desired output table, fetching from said first managing means items, related to said desired items of said desired output table, based on said fetched dependent and derivation relation information, displaying on said display at least one combination of at least one input table comprising at least one of said fetched items, related to said desired items of said desired output table, and selecting in response to input from said designer a combination of at least one input table from said displayed at least one combination; fourth managing means for registering items, related to said desired items of said desired output table, of each input table of said selected combination of at least one input table and registering said desired items of said desired output table; fifth managing means for registering a name of the desired output table and names of the at least one input table of the selected combination; and software developing means for developing software based on registered names of said at least one input table of the selected combination and said desired output table, items of each table, and inter-item derivation relation information of items constituting said input and desired output tables; said software developing means fetches said name of said desired output table and said names of said at least one input table of the selected combination from said fifth managing means, selects table translation commands from predetermined table translation commands based on a determination of whether said fetched name of said desired output table and said fetched names of said input tables are the same, fetches said desired items of said desired output table and said items, related to said desired items of said desired output table, of said at least one input table of the selected combination from said fourth managing means, and sets information in said selected table translation commands of said name of said desired output table, said names of said at least one input table of the selected combination, said desired items of said desired output table and said items, related to said desired items of said desired output table, of said at least one input table of the selected combination.
-
Specification