Data model compiler selectively using a reference store of labelled program components within a common class

• US 6,192,379 B1
• Filed: 06/26/1998
• Issued: 02/20/2001
• Est. Priority Date: 06/27/1997
• Status: Expired due to Fees

• Current Assignee: British Telecommunications PLC (BT Group PLC)
• Original Assignee: British Telecommunications PLC (BT Group PLC)
• Inventors: Bekenn, William J. F.
• Primary Examiner(s): Hong, Stephen S.
• Application Number:
  US09/104,976
• Time in Patent Office: 970 Days
• Field of Search: 707/503, 707/504, 707/509, 395/701
• US Class Current: 715/206
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

A computer system is provided to assist in the compilation and execution of data models which include an inter-linked assembly of pre-defined program components copied from a reference store and stored in a store. The computer system, including a data processor memory, having a control program stored therein, a store and input and output interfaces, respectively, is arranged, in operation, to compare fields of program components stored in the store with corresponding fields of pre-defined components stored in the reference store and to identify those fields shown by the comparison to be different. In particular, the computer system is arranged to automatically update a filed in the store, shown by the comparison to be different, with the contents of the corresponding filed in the pre-defined component stored in the reference store.

Claims

1. A computer system comprising:

data processing means connected to;

(i) memory means having a control program stored therein;

(ii) a store;

(iii) an input interface;

(iv) an output interface; and

(v) a reference store containing a plurality of pre-defined program components each having a plurality of fields, wherein each component has a field containing a label unique to that component and wherein at least one component has a field containing information defining a computation to be performed;

wherein the data processing means are arranged, in operation, under control of said control program;

(a) in response to user selection via the input interface to copy selected ones of said program components into the store;

(b) in response to user commands via the input interface to enter into the store link information determining the transfer of data from a field of one program component stored in the store into a field of another such component;

(c) to perform computation as defined by the program components and link information stored in the store and to output results thereof via the output interface; and

(d) in response to the label field of a program component stored in the store, to compare a field of the component with a corresponding field of the program component stored in the reference store and having the same label, and to identify a field shown by said comparison to be different;

wherein each component, at least in the reference store, having tag fields each of which identifies a field of the component as being of one of a plurality of classes of field, and

wherein the said comparison is performed only for fields thereby indicated as belonging to a particular class or classes.

2. A computer system according to claim 1 in which the data processing means are arranged, in operation, under control of said control program, following said comparison, to output via the output interface a signal identifying a field shown by the comparison to be different.

3. A computer system according to claim 1 in which the data processing means are arranged, in operation, under control of said control program, following said comparison, to update the contents of a field shown by the comparison to be different with the contents of the corresponding field of the pre-defined component stored in the reference store having the same label.

4. A computer system according to claim 2 in which the data processing means are arranged, in operation, under control of said control program, following the output of said signal, to await a confirmation signal from the user via said input interface and only upon receipt thereof to update the contents of a field shown by the comparison to be different with the contents of the corresponding field of the pre-defined component stored in the reference store having the same label.

5. A computer system according to claim 1 in which one such particular class is a class of all those fields which contain information defining a computation to be performed.

6. A computer system according to claim 1 in which one such particular class is a class of all those fields which each contain a constant value for use in a computation defined in the same or another component.

7. A computer system according to claim 1 in which the control program is an electronic spreadsheet program, the pre-defined program components each comprise a portion of an electronic spreadsheet and the or each field which contains information defining a computation to be performed is a spreadsheet field containing a formula.

8. A method of generating a data model on a computer using a plurality of program components selected from a reference store containing a plurality of separated, pre-defined program components, wherein each program component in the reference store has a field containing a label unique to that program component and wherein at least one said program components as a field containing information defining a computation to be performed, the method comprising the steps of:

(i) copying selected ones of said program components from the reference store into a work store;

(ii) entering into selected program components, stored in the working store, link information determining the transfer of data from a field of one program component stored in the working stored to a field of another such component;

(iii) performing computation as defined by the program components and link information stored in the working store and outputting results thereof; and

(iv) comparing a field of a program component stored in the working store with the corresponding field of a program component stored in the reference store and having the same label, and identifying a field shown by comparison to be different,

wherein a program component includes one or more of a plurality of different types of field, each field type being identified within the program component, at least within the reference store, by the contents of an associated tag field, and wherein said comparing step is performed only in respect of fields of a predetermined type.

9. A method as in claim 8, including the step:

(v) replacing the contents of a field of a program component stored in the working store, identified from step (iv) as being different, with the contents of the corresponding field of the program component stored in the reference store and having the same label.