Process and device for the automatic generation of spreadsheets
First Claim
1. A process implemented on a graphical user interface for the automatic generation of a spreadsheet from a model of an entity-relationship type which serves as a support for a relational data base model, comprising the steps of displaying said data base model of the entity-relationship type on a screen of an information system in the form of a graph composed of a plurality of entities and relationships represented respectively by first and second types of objects and linked by lines, said graph being physically embodied in memory by a set of relational tables, and automatically defining said spreadsheet by selection, from among various types of objects in said graph, of elements which are memorized to enable plotting of abscissa and ordinate data of the graph and compose the contents of cells of the spreadsheet thus formed.
1 Assignment
0 Petitions
Accused Products
Abstract
The invention relates to a process for automatic generation of spreadsheets from a model of the entity-relationship type which serves as a support for a relational data base. This data base module of the entity-relationship type is shown on a screen of an information system in the form of a graph composed of a plurality of entities and relationships which is physically embodied in memory by a set of relational tables. According to the invention, a spreadsheet is automatically defined by the selection from this graph of the elements intended to compose its abscissa and ordinate data and the contents of the cells thus formed.
56 Citations
14 Claims
- 1. A process implemented on a graphical user interface for the automatic generation of a spreadsheet from a model of an entity-relationship type which serves as a support for a relational data base model, comprising the steps of displaying said data base model of the entity-relationship type on a screen of an information system in the form of a graph composed of a plurality of entities and relationships represented respectively by first and second types of objects and linked by lines, said graph being physically embodied in memory by a set of relational tables, and automatically defining said spreadsheet by selection, from among various types of objects in said graph, of elements which are memorized to enable plotting of abscissa and ordinate data of the graph and compose the contents of cells of the spreadsheet thus formed.
-
13. A device to assist in decision-making from a model of an application field in the form of an entity-relationship graph containing entities, relationships, and constraints which are linked to them, which includes:
- storage means for a data base described by said model containing pieces of information corresponding to said application field, means for the graphic representation on the screen of said entity- relationship graph, which includes objects representing entities, relationships, constraints which are linked to said objects, and lines which link said objects to one another,
said device including;
interface means for the selection from the graph of entities and relationships which describe the elements to be considered during a decision-making study, means for the automatic generation of a spreadsheet which has a structure corresponding to the entities and relationships selected and which associate the constraints present in the model with their cells, and means for overlaying values contained in the data base which correspond to the elements selected, to enable initialization of said spreadsheet. - View Dependent Claims (14)
- storage means for a data base described by said model containing pieces of information corresponding to said application field, means for the graphic representation on the screen of said entity- relationship graph, which includes objects representing entities, relationships, constraints which are linked to said objects, and lines which link said objects to one another,
Specification