JPH0652026A - Data process system, data managing method and control method for access to resources generated by plural users - Google Patents

Abstract

PURPOSE:To provide a constitution system used by a user, systematized hierarchically in many different types. CONSTITUTION:The constitution system uses a project and a model data base accessed by a user, systematized in a hierarchical group. A group A of a high level generates a first set of a model record added and replaced by users B, C whose level is low in the next. Sets of an element definition from several users are coupled in order to generate an evaluation program to a specific model or an application. The user of a lower level inputs data to a project data base, with regard to the element definition contained in the evaluation program through a user interface.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a system for determining the requirements of products whose parameters have values whose values depend on the values of other parameters, and in particular to switching equipment used in central offices of public switched telephone networks. It relates to a system for creating a list of materials required for the structure of a project such as the system.

[0002]

Known configuration systems are typically written for a particular product. Together with the "friendly" user interface, these provide the user with a display screen to fill out for a particular product order. A variety of projects, that is, different configurations of the same model of switching equipment or other products, can be accessed by the same set of display screens designed to be used for that product so that file management Several formats are usually supplied. Therefore, product changes require rewriting the software that determines the display screen presented to the user. In addition, data security for various levels of users is typically provided only at the file level.

More advanced systems for the design of interconnection networks are disclosed in US Pat. No. 4,939,668 to Brown et al. And its division, US Pat. No. 5,019,992. In this system, the designer creates rules that meet the design requirements used by the expert system. The requester requests the use of the cable designed by the designer. The expert system only allows the requester to supply data in certain fields and only allows the cable designer to supply data in other fields. The expert system verifies the validity of the data entered by the designer and requester. All designers and all requesters can access all the rules to design the network.

[0004]

Disadvantages of known systems include a lack of flexibility and the ability to construct complex projects. U.S. Pat. No. 4,939,668
The system disclosed in the issue offers some flexibility and two levels of codification. However, the use of expert systems specifically written for a particular product
It requires a savvy engineer to create a unique expert system system for each product. Moreover, the number of classes of users is 2 because the roles of the two users, the designer and the requester, are like additional classes of users, or the subdivision of these two classes is not obvious. It is not clear how far it can be extended beyond.

It is an object of the present invention to provide a configuration system for use by many different types of hierarchically organized users. Another object of the invention is to retain the higher level user's element definitions for other users, and allow any user to prevent replacement of those element definitions by lower level users. It is to provide a composition system that allows lower level users to replace element definitions generated by higher level users for projects of lower users.

Yet another object of the present invention is to provide a configuration system for interrelated projects that are simultaneously installed. Yet another object of the present invention is to provide a configuration system for projects that are installed at a specific time and later upgraded or expanded. Yet another object of the present invention is to provide a configuration system that limits both display and modification of records and even fields within records by user type.

Yet another object of the present invention is to allow the database to make additional changes that allow the values to be updated at the same time, while all other data field dependents are changed when the content of the other data field is changed. An object is to provide a configuration system that automatically calculates updated values for data fields.

[0008]

SUMMARY OF THE INVENTION The above objective is to provide a database server that accesses data in response to a question and new data to be stored, a project database that is accessed by the database server and stores project data for at least one project. , And a data processing system that is accessed by a database server, stores model data, includes a program code record and a non-code record, and defines a relationship between project data for a project corresponding to the model data. It is achieved by providing. At least one evaluation program compiled from the program code records in the model data evaluates the project data corresponding to the model data using the relationships defined therein for the non-code records in the model data.
The user interface provides at least one user with a menu of predefined operations, receives responses from at least one user, submits questions and new data to the database server to generate model and project data, and Control the compilation and execution of at least one evaluation program that depends on the response from at least one user.

The model database has a predefined structure including an element definition table and a program text table. The element definition table contains element records, each having a display sequence field and an element identification field. The program text table contains a formula record, each having a formula identification field corresponding to the element identification field, the line sequence number field and the program text field in the element identification table.

The evaluation program is generated by combining one or more program source files. Each program source file corresponds to one of the element records and is formed from a set of formula records having the same content of the formula identification field. The program text field of each formula record in the set is ordered by the line sequence number field and is combined with the program code based on the non-code field of the set of formula records. A data processing system may generate, for example, a compiler and a linker to generate at least one evaluation program from a set of program source files.
Contains executable code that produces a program such as r). These, other objects and advantages, which will become apparent below, will be more fully described with reference to the drawings in which like parts bear like reference numerals, and a detailed description of the structure and operation described and claimed below. Exists inside.

[0011]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENT FIG. 1 shows a computer system to which the present invention is applied. When the data processing system according to the present invention has a large number of users to develop various and complex projects, the hardware used is preferably Fujitsu's M-76 running Unix.
Includes mainframe or superminicomputers such as 0/10 computers. As is customary, the central processing unit (CPU) 10 has a read-only memory (ROM) 12 for storing programs used for controlling basic operations of the CPU 10 and a program storage area for executing programs and work for data. Is connected to a random access memory (RAM) 14 that provides a storage area for use. In addition, one or more printers 16 and terminals 18 are also connected to CPU 10 in a conventional manner. The user terminal 18 is compatible with, for example, the VT100 standard of Digital Electric Corporation or the 9000 terminal standard of Hewlett Packard,
Or it could be a personal computer or other conventional terminal emulating one of these. The user terminal 18 is an RS
-Connected via conventional interfaces including 232C, LAN and others.

A conventional type of mass storage device 20, including one or more magnetic disk units, stores programs and databases that control the operation of the CPU 10 to perform the functions of the present invention. Mass storage device 20
Some programs and databases stored at are shown in FIG. The configuration software and data 22 specific to the present invention uses other software to access other databases. ORACLE of ORACLE Corp. of Redwood Shores, California
Database server 24, such as
Provides access to many databases of zero. In addition to the configuration database described below, the database server 24 includes a hardware database (HWDB) 26 and a software database (SWDB) 28 that each contain a description of the hardware and software used to assemble the configured product. Provide access to. In addition, access is provided to a mechanical engineering database (MEDB) 30 and configuration data 22 is provided to a price / cost / quote database (P / CDB) 32. C language compiler 34 and Washington D.C. C. Other conventional software, such as a screen interface, such as the Full Screen Processor from Information Coceps, Inc., is used by configuration software 22.

A block diagram of the configuration software and data 22 is shown in FIGS.
As shown in FIGS. 3 and 4, the user terminal 18 is connected to the I / O manager software 40 via the communication device 38. The I / O manager software 40 includes a full screen processor and C language program that together provide the user with a menu and input screen interface. The main menu includes an option to call the application editor 41 or project editor. The application editor 41 preferably uses database interface software such as Oracle SQLForms. The project editor uses the full screen processor and the semaphore set 44, the shared page memory 46, and the shared control memory 48 to execute I / O.
C communicating with one of the C language programs of manager 40
Use the display manager 42 written in. The display manager 42, in turn, communicates with the database manager 50 to obtain data from the model, project and system management databases in the database system 52. During compilation of the project data, the evaluation program 54 is also used as described below.

Database system 52 includes database server 24 for accessing model, project and system management databases. The data formats for some of the tables in these databases are provided in the appendix SQL language. These tables are examples of the invention used to configure the telephone network switching equipment. The model database provides an element definition table that stores element records, each having a display sequence field (ITEM_NO) and an element identification field (ITEM_KEY).
TMET_AP starting with MET_AP_MAIN
Includes all tables in the appendix starting with. The project database contains all tables starting with TMET_PR.

The system management database includes user tables and relationship tables that define relationships between application databases and project databases in the model database, as described in more detail below. Each user table has a user identification (U
SER_ID), USER_TYPE and USER_
A user information table (TMET_USER_INF) that stores a user record having a GROUP field.
O) is included. In the preferred embodiment, the user is the USER_
It has a hierarchical relationship defined by the GROUP and USER_TYPE fields. For example, the present invention is based on the manufacturer of the telephone switching equipment whose staff is the highest level in the hierarchy, and further, in the middle level of the hierarchy, NY.
Bell employees (BOCs) such as NEX and AMERITECH and others at local Bell holding companies (RBHCs) and at the lowest levels like Illinois Bell and New England Telephones. Used by.
Within each of these groups, there are different user groups and different user types. A simplified hierarchical group diagram is shown in FIG.

When a user enters the configuration system, the user ID is obtained, for example, from a UNIX ID that requires a password. USER_I
D is USER_TYPE and USER_GROUP
Used to access the user information table that determines the fields. These fields determine the menu options available. The highest level user has access to all databases 52. Some system management databases such as user information tables and line tables that define connections between groups such as the connections shown in FIG. 5 are maintained directly by high level users.

All users who have access to the system management database, including at least group A of FIG. 5, also have access to the project database and to one or more application databases in the model database. The next lower levels in the hierarchy, eg groups B and C, typically have only access to a portion of the model and project databases. The I / O manager 40 and application editor 41 provide a user interface for displaying a predefined menu of operations on the user terminal 18. When a user having access to the model database selects a menu item that provides access to the application editor, the processor 10 performs the steps shown in FIGS.
As shown in FIGS. 6 and 7, a list of application databases stored in the model database that can be modified by a specific user is displayed. After an available application database is selected, a menu is displayed allowing various actions to be performed on that application database. During operation, what is performed is the creation of a new application database using the steps shown in FIG.

First, the data in the application database, or more generally the model data, is generated by the user at the top of the hierarchy for products. 1
Or more application databases are combined to form a generic project definition used to enter project data. The application database may be modified during the development of the data, but once the application database is designated as "released" in the system management database, the data in the released application database is modified. I won't get it. However, other users are allowed to create replacements or additions to the particular item.

General-purpose project definition formation
A simplified example of (formation) is shown in FIG. The three application databases 60-62 are combined to form a single generic project definition 64. For example, the application databases 60 to 62 are shown in FIG.
Can be created by the users of each of the groups A, B and C of The lower level groups B and C ensure that projects built using the switching equipment corresponding to the application databases generated by the higher level groups meet the requirements announced by the (RBHC) group. , Transform and add rules in its own application database 61, 62.

Items 1.0 'and 3.0' are examples of items in the lower level application database with the items in the higher level application database swapped. However, higher level groups do not want certain element definitions, eg item 3.0, to be allowed to be replaced. The TELCO_FACTOR_ITEM field determines if the item can be replaced. “*” In FIG. 9 indicates TELCO_FACTOR_
The ITEM field indicates that it is a set to prevent item 3.0 from replacing item 3.0. There are no restrictions placed on lower level groups with respect to adding items.

A generic project definition formed from a set of application data is used to generate project data for a particular project. Therefore, the fields in the tables that form the application database are described with reference to how the fields are used to enter project data. Element definition table (TMET_AP_MAI
N) is written from one or more screens that define the display screens used by the lowest level user to generate project data.

An example of a part of the screen generated based on the application data is shown in FIG. 10 as an example of the application data in the following [Tables 1-5] corresponding to the SQL table definition in the appendix. ITEM_KEY is a unique identifier for every record in the element definition table. DB_NAME and REV_NO identify the application database and revision number. IT
EM_NO and ITEM_ID are display sequence fields. The former is entered by the creator of the application data and displayed on screen to the lower user, and the latter is internally used by the processor 10 to ensure correct sorting of records by conventional sorting routines. Generated and used. The ABBR field is a label used to identify the item of the message, as described below.

[0023]

[Table 1]

In the preferred embodiment, when entering project data, there are three fields that determine what is displayed to the user. As shown in FIG.
M_NO, eg 3.1, displays the level of display selected by the user when entering project data in the same way as an outline program. Therefore, normally, when the user requests a display of level 1, only "0" or items without letters are displayed after the first decimal point, and when the requested display level is 2, the second A zero or no letter after the decimal point (if any) is required, and so on. However, the creator of the application data is
As is clear from the example in [Table 1] corresponding to the item indicated by 0, the display level (DL in [Table 1]) for the item having the item number can be specified.

Display masks are used in two other ways of controlling what is displayed to the user. In the user information table, DISP of the element definition table for determining whether the item is displayed
The number U that is compared with the number in the LAY_MASK field
SER_TYPE and data format table (TME
USER_M for T_AP_DATA_FORMAT)
ASK field. The data format table will be described in more detail later. The USER_TYPE field is also a transformation and report mask (mod) of the element definition table that determines whether the item can be transformed by the user's particular type, and whether it appears on the report for the user's particular type, respectively.
ification and report masks). In the preferred embodiment, a bit-wise AND operation is performed.
ation) is used for all comparisons between the USER_TYPE field and the mask field, but other comparison operations can be used, as is known in the art.

[0026]

[Table 2]

[0027]

[Table 3]

When the user is creating an item in the model database for the application database, one field on the screen to be written is how many other tables in the model database have corresponding records. ITEM_TYPE to determine
Is. All item types are TMET_AP_DE
It has an entrance to the SC table, an example of which is given in Table 2 above. Similarly, every item has one or more entrances in the help message table that are displayed when the user requests help for the item. An example of a help message for the items in Table 1 is given in Table 3. The simplest item types typically provide information that has only a main and description table entry, and are displayed as text along with the item number.

The remaining item types allow entry of data and / or definition of calculations. An item type that is a data entry simply contains the definitions of both scalar and array variables and string variables. These variables are identified as being orderable, ie, appearing on the material list created by printer 16 when the project is configured. In addition, the model data creator specifies the functional item type for formulas that are called by other item types but are not displayed. Such items have a display mask of zero. Function item type 1
An example is a complete check item used to verify project data entered by a user.

[0030]

[Table 4]

The preferred embodiment takes into account many similarities between data fields by defining the data formats separately so that the data formats can be used by any item. For example, the bottom two rows of the screen shown in FIG. 10 are used for entry of many other types of items besides POTS line card numbers. Figure 10
In order to generate the data format for these two rows of, the four records are labeled as install, order and total for one of each field and default for the other field.
The data format table (TMET_AP_DATA_FOR, labeled t, requestd, and sel).
MAT).

An example of data format table records for the screen shown in FIG. 10 is given in Table 4 above. According to the last field of Table 1, item 3.2 uses the hardware data format. [Table 4]
As shown in, the first field of the hardware data format is a variable with an opening value of zero (see the second line of Table 5). Third and fourth fields (order
And total) are formula fields,
order is the difference between the number requested and the number installed, and total is the sum of these fields.

The third field of the hardware data format named defaut is Y in column S of [Table 4].
, Selectable computable (selectable c
alculable) "field. The Selectable Computable Data field automatically generates three fields for on-screen data entry. The first data entry field uses the label of the FIELD_NA field of the record, the second uses the label in the ALIAS field of the record, and the third uses the label se.
have l. Omission for sel field (default)
The value is "N" indicating that the default value of 0 is used according to the first line of [Table 6] as shown in FIG. If the user enters Y in the sel field, then the value entered by the user in the request field is
Used in place of the value in the default field.
This is a sel for each selectable computable field
This is accomplished by inserting a line into the evaluation program 54 to return a default based on the value of the field and one of the requested fields.

An additional feature of the preferred embodiment to simplify the generation of application data for iterative information is the use of arrays. Instead of defining several related items, a single item is defined as an array type with dimensions up to 6, for example.
The data of the array type item is displayed on various lines using the same data format. The model data generator supplies the number of dimensions on the screen that is displayed when an item is identified as having an array type, and the maximum index for each dimension.

[0035]

[Table 5]

[0036]

[Table 6]

In the preferred embodiment, all items having a data format, including at least one variable data format, provide a memory allocation for the evaluation program 54, as shown in Tables 5 and 6 above. The formula table (TMET_AP_FORMULA) has an entrance. Each variable data field has a default value in the formula table, an example of which is given in [Table 5] above. All items with a data format containing at least one formula data field also have a program text table (TMET_AP_FORM_TEX, an example of which is given in Table 6 above).
T) has an entrance. Program text table T
The EXT field contains the C language statements used to form the evaluation program as described below.
The C language sentence is obtained from the creator of the model data using the screen displayed by the application editor 41 when the generation of an item having a formula data field is requested on the screen described above.

When it is determined that at least one application database in the model database is ready to be used for the construction of a project, the user can, according to the access table (TMET_ACCESS), list the application databases accessible by the user. Is requested to the application editor 41. Access table records are preferably automatically generated for all users in a higher level group (according to the line table) than the creator of the application data. In addition, users who are allowed access to the application database are allowed access to the application database for the same or lower level users. Therefore, the applications in the list displayed by the application editor 41 are not only the user's own application data, but also all applications created by a user in a lower level group, and his or her own group and that user's access. Includes application databases created by higher level groups of users who are authorized to.

On the screen displayed by the application editor 41, the user identifies which application database, eg, application databases 60-62 of FIG. 9, are to be combined to form, eg, 64 generic project definitions. . The general project definition is defined in the resource table (TMET_RESOURC
E) is given the name stored in it, and the entrance is TMET_RESOURCE from each application table.
Edge table pointing to the name of the generic project definition stored in the table (TEMT_EDGE
S). In addition, the processor 10 generates a source file from the program code records in the program text table for all identified application databases and then generates the evaluation program 54, as shown in FIGS. Compile and link a program as a function of a calculation engine program having a simple basic flow.
The FORMULA_STATE field of the formula table has one value if the program compilation is successful and two values if the program compilation is unsuccessful. Table 5 gives an example of a formula table in which the three formulas are edited before the evaluation program 54 is generated.

Once the evaluation program 54 has been successfully generated, the lower level users can access the database 5
You can view and transform the project data in 2. With respect to Figures 3 and 4, the user requests data for a particular project in a manner similar to that described above for the user requesting the application database. The I / O manager 40 contacts the display manager 42 through one of the message queues 66 shown at the bottom of FIGS. 3 and 4 to get the full screen item at the display level requested by the user.
For example, the screen shown in FIG. 10 is displayed for the user to see the project data for the items in [Tables 1-5]. In the preferred embodiment, shared page memory 46 and shared control memory 48 are used to store the current screen and the two screens before and after the current screen. The entry of data into the fields by the user is communicated to the database manager 50 and the evaluation program 54 through the message queue 66.
The database manager 50 determines which fields should be transformed by re-evaluating the basic formula due to changes in the contents of the fields transformed by the user to determine which fields should be transformed (TMET_D).
(EPENDENCE) is accessed recursively.

In the preferred embodiment, the "dirty" indicator is used to identify a formula that returns a value that changes due to changes in other variables. Dirty indications are made by the user, and the project database (TME
T_PR_DATA) is the number sequentially specified for the change stored in the DIRTY field. An element definition database (TMET_AP_MAI) linked with the dirty sequence number and the label of the field name.
All abbreviations formed from the ABBR field in N) are passed through the message queue 66 from the database manager 50 to both the evaluation program 54 and the display manager 42 for identifying "dirty" data fields. Evaluation program 54
Calculates the revision number for the field affected by the change made by the user. On the one hand, the display manager 42 keeps track of which fields are dirty, and flushing (f) where the value in the "dirty" field is not modified by previous changes.
Generates a display to the user, such as a lashing number.

The evaluation program 54 uses the message queue 6
When the oldest message of 6 is retrieved and the updated value is calculated, all abbreviations, dirty sequence numbers and updated values are stored in the database manager 50 in the message through message queue 66. Is passed to. If the dirty sequence number in the message matches the dirty sequence number stored in the project database, the database manager 50 stores the updated value in the project database. After revising the value in the project database, the database manager 50 sends a message to the display manager 42 that updates the value in the shared page memory 46 and masks it cleanly.

When the field affected by the change made by the user is part of an item having an integrity check type, the evaluation program 54 returns the true or false value stored in the project data (TMET_PR_DATA), The error message is then preferably displayed to the user and printed on all reports. This is a database manager 5 that checks the records in the model database with the matching ITEM_KEY.
Performed by zero. If the matching record is an integrity check item and the value returned by the evaluation program 54 is imaginary, the database manager 50 will not only store the imaginary value, but also the I / O manager 4
Send a message to the display manager 42 which will be sent to 0. In response, the I / O manager 40 changes the display so that the last word of the second line becomes “BAD” instead of “OK” in the screen shown in FIG. 10, for example. Similarly, when the report is created, the project database is checked against the model database, and if the "imaginary" value is stored in the project database for the integrity check item in the application database, a message is reported. Appears in the calligraphy.

One option provided to lower level users is to create a new project for a preceding project that was either fully configured or not. This is particularly useful for public facilities with closed restrictions placed in public facilities by the regulatory body. For example, when a telephone exchange is first installed, its capacity is naturally constrained by the desire to avoid cost overruns. Therefore, as demand increases and additional capabilities or features are required, switching equipment must be upgraded with hardware or software. This is accomplished by creating a new project from the existing project.

Generally speaking, two of the new projects
There are two types. The first is a project that is installed at the same time as the first project and has similar requirements to the previously (partially or fully) defined project. One example is a community that receives new exchanges that serve similar types of customers through one or more exchanges. The first one switching device is configured,
And then the project data is copied for the second switching device. After the two sets of project data are generated, the project data for each switching device is fine-tuned separately for each switching device. Second
Perhaps, and perhaps more common in the case of telephone switching equipment, is where the installed project requires increased capacity, as previously explained, in other words, the second project is It is a “growth project” based on the first project.

In the case of a growth project, the first and second projects are related by being located at the same site. In the preferred embodiment, the resource table (TMET_SOURCE) contains a list of databases of all types, namely the full set of application data and the set of project data. As shown in FIG. 13, the application 71
~ 74 are two generic project definitions 7 in this example.
Combined to form 6,78. Project 80
Is a fixed project that uses the generic project definition 76, and project 81 is a growth project that evolved from project 81. Similarly, the project 82 has a linked growth project 83 based on the generic project definition 78.

In the preferred embodiment, the first step in creating a growth project is to define a site in the resource table, eg site 86. There, the “edge” is the edge table (T) from the first and growing, respectively first and second projects 80, 81.
MET_EDGES) site 86. The transformation table then contains a key identifying the transformation, all abbreviations for the fields in the first project 80, and all abbreviations for the corresponding fields in the second project 81.
It is constructed by including two fields. For example, for a growing project, the "from" data field represents the total number of specific parts from the first project 80, and the "to" field is
At the beginning of the second project 81 represents the number of installed parts of that type. If there are changes in the basic generic project definition, eg 76, that require some data fields to be deleted or new data fields to be added, the transformation table is further used. The corresponding "To" and "From" fields in the transformation table for the deleted and added fields in the project database indicate that these fields are not present in the corresponding new and old projects, respectively.

Edge tables are also used to define relationships between currently existing projects. For example, some switching devices are organized into clusters of remote switching devices around a host switching device. Using the example shown in FIG. 13, the first projects 80, 82 correspond to sites 86, 88. EDG in the edge table
The E_TYPE field identifies table entries to define clusters, and the TO_TYPE and FROM_TYPE fields identify sites 86, 88 as remote and host switching devices, respectively. The entries are cluster 90 and sites 86, 88.
Resource table for (TMET_SOURCE)
Done inside. The interface table is generated by a list of all abbreviations and the identifying interface table keys for all data fields of each remote switching device that affect the configuration of the host switching device. This allows the host switching device, eg project 82, to be configured with data that is automatically derived from the project data for the remote switching device, project 80. For example, the host switch has a default capability based on the overall capabilities of all remote switches connected to it, as indicated in the edge table.

Many features and advantages of the present invention will be apparent from the detailed description, and thus all such features and advantages of a system within the true spirit and scope of the invention. Covering is intended by the claims. Furthermore, it is not desirable to limit the invention to the precise structure and operation described and illustrated, since many variations and modifications can be readily made by those skilled in the art from the disclosure of the invention. Appropriate variations and equivalents are, therefore, claimed as being within the scope and spirit of the invention.

Appendix

[0051]

[Table 7]

[0052]

[Table 8]

[0053]

[Table 9]

[0054]

[Table 10]

[0055]

[Table 11]

[0056]

[Table 12]

[0057]

[Table 13]

[0058]

[Table 14]

[0059]

[Table 15]

[Brief description of drawings]

FIG. 1 is a block diagram of a data processing system to which the present invention is applied.

FIG. 2 is a block diagram of programs and files used in the present invention.

FIG. 3 is a more detailed block diagram (1) of software and data files used in the present invention.

FIG. 4 is a more detailed block diagram of software and data files used in the present invention (Part 2).

FIG. 5 is a simplified hierarchical group diagram.

FIG. 6 is a flowchart (part 1) of steps executed through editing of model data.

FIG. 7 is a flowchart (part 2) of steps executed through editing of model data.

FIG. 8 is a data relationship diagram showing a one-to-many relationship in model data.

FIG. 9 is a conceptual diagram of a merger of application databases forming a generic project definition.

FIG. 10 shows an example of a display screen used for inputting project data.

FIG. 11 is a flowchart (part 1) of the operation of the evaluation program.

FIG. 12 is a flowchart (part 2) of the operation of the evaluation program.

FIG. 13 is a cluster system data relationship diagram.

[Explanation of symbols]

 18 ... User terminal 38 ... Communication equipment 40 ... I / O manager 41 ... Application editor 42 ... Display manager 44, 46 ... Semaphore manager 48 ... Shared control memory 50 ... Database manager 52 ... Database system 54 ... Evaluation program

 ─────────────────────────────────────────────────── ─── Continuation of the front page (72) Yasunori Tonooka, Yasunori Tonooka, 1015 Kamiodanaka, Nakahara-ku, Kawasaki-shi, Kanagawa Within Fujitsu Limited (72) Inventor, Akihiro Takahashi 3-9-18 Shin-Yokohama, Kohoku-ku, Yokohama, Kanagawa Prefecture Fujitsu Communication・ Inside Systems Co., Ltd.

Claims (7)

[Claims] 1. A data processing system for storing a project database containing project data for at least one project and a model database containing model data, including program code records and non-code records,
Data storage means defining relationships between project data for projects corresponding to model data, at least one evaluation program compiled from program code records in the model data, a database server for accessing the model and project databases, And program storage means for storing user interface software that provides a defined menu of operations for at least one user, and database server software, models using relationships defined therein for non-coded records in model data. At least one evaluation program for evaluating the project data corresponding to the data, and a response from at least one user, and the model and the project. A data processing system comprising a processor executing user interface software for receiving queries and new data by a database server to generate data and for controlling compilation of at least one evaluation program. 2. The storage means includes an executable code generation program, an element definition table for storing element records each having a display sequence field and an element identification field, and a formula identification corresponding to each element identification field. A model database having a defined structure including a program text table storing a formula record having a field, a line sequence field and a program text field, and, under the control of user interface software, the processor includes a line sequence field Ordered by, each corresponding to an entry in the formula identification field and at least one entry in the program text field. The data processing system according to claim 1, further comprising: executing a database server that outputs the source files, and executing an executable code generation program that generates each of the at least one evaluation program from the set of program source files. . 3. A data processing system, a database server for accessing data according to a question and new data to be stored; a project database, which is accessed by the database server and stores project data for at least one project; A model database that is accessed by a server, stores model data, includes program code records and non-code records, and defines relationships between project data for a project corresponding to the model data; a program of model data in the model database It is compiled from code records and corresponds to the model data using the relationships defined there for the non-code records of the model data. At least one evaluation program for evaluating the data, and at least one user defined menu of operations to supply,
Receives responses from at least one user, submits questions and new data to the database server generating model and project data, and relies on responses from at least one user to compile and run at least one evaluation program. A data processing system comprising a controlling user interface. 4. The element definition table, wherein the model database stores element records each having a display sequence field and an element definition field,
And a user-defined interface comprising a program text table each storing a formula record having a formula identification field corresponding to one of the element records, the line sequence field and the program text field. Commanding the database server to output a program source file, each of which corresponds to one entry of a formula identification field and at least one entry of a program text field and is ordered by a line sequence field, and the data process The system further includes an executable code creating program for creating each of the at least one evaluation program from the set of program source files. Data processing system according to claim 3, comprising, characterized in that the. 5. A data management method comprising the steps of: (a) storing first data in a first relational database, wherein the first data defines a relation to the second data, and (b) the first. Converting a part of the data into an executable program code, (c) an entry of the first item of the second data, and
Populating the second data in the second database by calculation of the second item of the second data by the executable program code that depends on the first item of the second data. 6. The method of claim 5, further comprising (d) a third
Each item of data comprises a step of storing third data including a user identification field and a user type field, wherein the storing of step (a) is an item number and a display for each item of the first data. And storing the modified mask, the step (c) input comprises the following steps: (c1) when the display mask and user type at least partially match for each item displayed. , The first data is displayed in order by item number, (c2) the item of the second data corresponding to the first data displayed in step (c1) is received, and (c3) the item corresponding to the first data is displayed. Second data received in step (c2) provided with at least partially matching correction mask and user type 6. The management method according to claim 5, wherein: 7. A method of controlling access to a resource generated by a plurality of users, comprising the steps of: (a) each user including a user identification field and a group field identifying a group to which the user belongs. Store a user record having a corresponding user record, (b) store a group relationship record that defines a hierarchical relationship between groups of all users, and (c) one of the users who was previously granted access to the resource. Automatically grant access to the resources created by a user created by a user of the group created by all higher level groups, and all other lower level groups An access record that provides access to the resource by the user of, and (d) To control access to resources that depend on access record.