Manipulating data in a relational data base having operational manipulations defined in an input table and displayed results in an output table with a line displayed designating direction of data flow

• US 5,301,313 A
• Filed: 07/15/1991
• Issued: 04/05/1994
• Est. Priority Date: 07/17/1990
• Status: Expired due to Term

• Current Assignee: Sharp Kabushiki Kaisha (Hon Hai Precision Industry Co., Ltd.), Mitsubishi Denki Kabushiki Kaisha (Mitsubishi Electric Corporation), Matsushita Electric Industrial Company Limited (Panasonic Holdings Corporation), Sanyo Electric Company Limited (Panasonic Holdings Corporation)
• Original Assignee: Sharp Kabushiki Kaisha (Hon Hai Precision Industry Co., Ltd.), Mitsubishi Denki Kabushiki Kaisha (Mitsubishi Electric Corporation), Matsushita Electric Industrial Company Limited (Panasonic Holdings Corporation), Sanyo Electric Company Limited (Panasonic Holdings Corporation)
• Inventors: Yoshida, Shin-ichi, Nishikawa, Hiroaki, Nishikawa, Youichiro, Hine, Shunji, Hara, Shuji, Sakuta, Yoshio, Terada, Hiroaki, Shima, Kenji, Yamasaki, Tetsuo, Inaoka, Yoshie
• Primary Examiner(s): Lee, Thomas C.
• Assistant Examiner(s): ORZECH, JENNIFER
• Application Number:
  US07/730,173
• Time in Patent Office: 995 Days
• Field of Search: 395/600, 395/12, 395/700, 395/800, 395/275
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: G06F 3/023 Arrangements for converting discrete items of information into a coded form, e.g. arrangements for interpreting keyboard generated codes as alphanumeric codes, operand codes or instruction codes
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

Abstract

An apparatus for manipulating a relational data base includes a unit for describing input data in a table format, a unit for describing all the operational manipulation with respect to the input data in a non-text format, and a unit for outputting data by referring to the relational data base based on the described input data and operational manipulation. The input data of a table format includes an input table and an output table. The input table includes an operational description region and the output table includes a region wherein a map relation between the respective items of the input and output table is described. The manipulation contents are described in the operation manipulation description region and the map relation description region. The operation flow is described and defined by a connection line with directiveness. The apparatus enables description of all the operational manipulation in a graphical manner in a non-text format, providing a user with data base manipulation environment with excellent understandability and operability.

Claims

1. A method of manipulating a data base storing data in a table format, said table including an item area for specifying an attribute of data, said method comprising the steps of:

defining input data including first data to be manipulated and second data to be output as a result of manipulation wherein said first data and said second data are both defined in the table format on a display screen, said step of defining including the step of identifying the first data and the second data by an orientation of an oriented connection line;

defining with a non-sentential graphic format having a predetermined syntax, all operational manipulations to be carried out on said first data of said input data defined, the second mentioned step of defining including the step of defining a manipulation in the item area of the table of said first data of said input data to be manipulated, said oriented connection line indicating a direction of flow of manipulations from the first data to said second data;

determining a procedure of manipulating data of said data base according to both the first data of said input data defined in the table format and the operational manipulations defined with the non-sentential graphic format having a predetermined syntax, and

producing visual output data in the table format corresponding to said second data defined on said display screen by referring to said data base in accordance with the determined procedure of manipulating data.

2. The method according to claim 1, wherein said step of defining input data includes the steps of:

displaying said first and second of said input data on said display screen in the table format in response to an instruction for creating input data given by an operator, and

forming a relation table corresponding to a defined data construction according to a definition of data defined by the operator on the displayed input data, said definition including definition of structure of data.

3. The method according to claim 1, wherein said step of defining operational manipulations includes a step of interpreting the operational manipulations defined with the non-sentential graphic format having a predetermined syntax, to be carried out on said input data.

4. The method according to claim 1, wherein said step of determining a procedure includes a step of applying identifiers to said input data to be manipulated and to said operational manipulation to form a manipulation procedure by using said identifiers.

5. A system for manipulating a relational data base storing data in a table format, comprising:

first means for defining, in a table format, input data to be manipulated,

second means for defining with a non-sentential graphic format having a predetermined syntax, all operational manipulations to be carried out on said input data defined in a table format,

means for producing visual output data by referring to said relational data base in response to data defined by said first and second means,

said input data defined in a table format including an input table representing data to be subjected to an operational manipulation and an output table for indicating the operational manipulation result in a table format required when said output data is produced in a table format,

said input table having an operational manipulation description region for defining an operational manipulation, and said output table comprising a region for defining a correspondence between the respective related items of the input and output tables, an operational manipulation being specified in said operational manipulation description region and said region for defining a correspondence between the respective related items of the input and output tables, wherein

an operation flow of the operational manipulation is defined by means of an oriented connection line located between said input table and said output table.

6. A system for manipulating a relational data base, comprising:

first means for defining input data including first data to be manipulated and second data to be outputted wherein both said first data and said second data are defined in a table format;

second means for defining an operational manipulation to be performed on said first data of said input data, in a non-sentential graphic format according to a predetermined syntax; and

third means for referring to said relational data base using the first data of said input data and the operational manipulation defined by said first and second means to produce visual output data in the table format corresponding to said second data of said input data defined in a table format. said third means including means for performing the operational manipulation defined in the non-sentential graphic format by said second means on said first data of said input data defined in a table format by said first means,

said second means including means for producing an oriented connection line having a first end for indicating a data to be manipulated and a second end for identifying a data to be outputted as a result of the operational manipulation, for locating the oriented connection line in said input data to identify said first data and said second data and to indicate a direction of flow of the operational manipulation.

7. The system according to claim 6, wherein an input table, in which the first data of said input data is defined, includes data as an object of the manipulation and further includes an operational manipulation specifying area for specifying the operational manipulation, and an output table, in which the second data of said input data is defined, includes a category of the output data to be produced as a result of the operational manipulation, and further includes a mapping relation specifying area for specifying a correspondence between related items in said input and output tables;

and said second means includes means for defining a flow of data in the operational manipulation locating said oriented connection line indicating a flow of data in the operational manipulation between the input table and the output table, and means for specifying visually a content of the operational manipulation itself in said operational manipulation specifying area and said mapping relation specifying area in a non-sentential graphic format.

8. The system according to claim 6, wherein said third means includes means for storing a content of the operational manipulation itself, and for reading out the stored content in another manipulation to reuse the stored content for definition of said another manipulation in referring to said relational data base.

9. The system according to claim 6, wherein said third means includes means for combining a plurality of manipulations of relational operations into a unit manipulation procedure for storage.

10. The system according to claim 6, wherein said first means includes,

means being activated in response to an instruction for forming of the input data supplied through a user interface, for displaying the input data in a table format on a display unit, and

means for forming a relation table corresponding to a structure of data defined by the user of the system, according to the structure of data which the user defines for the displayed input data.

11. The system according to claim 6, wherein said second means includes means activated responsive to an instruction of defining an operational manipulation supplied through a user interface, for interpreting the operational manipulation which the user defines in the non-sentential graphic format, and for defining the manipulation in the non-sentential graphic format for use in the manipulation.

12. The system according to claim 6, further comprising:

means being active in response to an instruction given by a user through a user interface, for storing, in non-sentential graphical format, a semantically completed description of the input data to be manipulated and said operational manipulation defined by said second means.