JP3577400B2 - System design equipment and data warehouse design system - Google Patents

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention is a data warehouse design that can reuse know-how.Equipment andData warehouse generation systemToRelated.
In addition, the present invention provides a data warehouse design that can easily configure a data warehouse.Equipment andData warehouse generation systemToRelated.
[0002]
[Prior art]
In the configuration of the computer system used in the conventional business, the contents and rules of the business are analyzed in detail, mainly focusing on the process, how to use the data, and how to store the data in the database. The system is configured to optimize for the business, including whether or not.
However, conventional system designs are also individually designed for similar systems of the same business type.
[0003]
[Problems to be solved by the invention]
For this reason, similar analysis, analysis, and design were repeated in various situations. However, it is basically a waste of labor to repeat similar designs in similar systems of the same industry. In particular, the analysis and analysis of the system must be performed by engineers with advanced expertise and capabilities. However, restraining these engineers was costly.
[0004]
Data warehouses are attracting attention as a method for efficiently designing systems. However, in order to build a data warehouse, it is necessary to develop a data warehouse and a mechanism for transferring and registering data there.
[0005]
However, with respect to the construction of a data warehouse, it is difficult to develop a product that can be developed as a data warehouse itself at a low cost in a short period of time.
In addition, the data transfer / registration part has conventionally been manually performed, and transfer / registration efficiency was low.
[0006]
The present invention has been made in view of the above situation, and can easily design and / or manufacture a system.Apparatus and systemThe purpose is to provide.
It is another object of the present invention to provide a data warehouse which can be developed by itself.
Another object of the present invention is to facilitate transfer and registration of data of an existing system to a data warehouse.
[0007]
[Means for Solving the Problems]
In order to achieve the above object, a system design apparatus according to a first aspect of the present invention includes:
Business model data that stores business model data that expresses the business content of the business using a plurality of normalized elements and the attribute and element relationship of each element for the business handled in the businessStorage means;
Business model data stored in the business model data storage meansOn the basis of theAccording to the data warehouse implementation formatDesigned,The attributes of the plurality of elements as itemsTemplate tapeTheModel to remembertableStorage means;
A userAccepts the input instruction ofDatabasesystemIs processing the dataData items and previousChickAssociating means for setting a correspondence relationship with the data items of the shape table;
According to the setting of the associating means, the existingDatabaseConversion information generating means for generating conversion information composed of a command sequence for moving data of each data item of the system to data of a corresponding data item of the template table group;
HaveIt is characterized by the following.
Data dictionary storage means for storing a data dictionary indicating the attributes of the business model data stored in the business model data storage means and the meanings of the data items of the template table, and stored in the data dictionary storage means Dictionary output means for outputting the meaning content for the user's confirmation may be further arranged.
[0008]
According to such a configuration, it is possible to surely associate the corresponding data items with each other while confirming the contents. In addition, since the conversion information is generated based on the association, there is little mistake in generating the conversion information, which contributes to accurate conversion.
[0009]
The conversion information generating means,SaidExistingDatabaseIn order to convert the data of the system into data suitable for the template table group, the operatorGenerated by the conversion information generating meansconversionEdit informationAnd a means for providing an editing screen for editing.
[0010]
Data input means for inputting data of an existing database system,SaidEntered by data input meansdataToAccording to the conversion information,PreviousWriting templatetableAnd convert the converted data to a data warehouse.StorageConversion meansWhenMay be further provided.
According to this configuration, the data conversion itself is performed by the conversion means, so that the data can be automatically and appropriately converted, and thus an appropriate data warehouse can be realized.
[0011]
The association means,For example,ExistingDatabaseSystem data items and previousChickDisplay means for displaying data items of the shape table;Respond to user input instructions,Existing display displayed by the display meansDatabaseSystem data items and previousChickSelecting means for selecting corresponding ones of the data items of the shape table. According to this configuration, the association can be visually made.
[0012]
The association means,Respond to user input instructions,ExistingDatabaseSystem data items and previousChickMeans for selecting ones corresponding to the data items of the shape table, wherein the conversion information generating means comprises:DatabasePrevious data of the selected data item in the systemChickMeans for generating a command sequence for moving to the data of the corresponding data item of the shape table, wherein the conversion means executes the command generated by the conversion information generation means to convert the data of the existing system. The template tapeToConvert to suitable data and convert to data warehouseStorageMay be configured.
According to this configuration, it is easy to associate the data items with each other, and further, a program is generated based on the association, and the data is converted and transferred by executing the program. Therefore, data conversion is reliably performed. In addition, since the conversion program is automatically generated by associating the two data items, the data items on the source side and the target side, the association (mapping rule), and the program can be centrally managed while maintaining the correlation. .
[0013]
The association means,Respond to user input instructions,ExistingDatabaseMeans for selecting corresponding ones of the data items of the system and the data items of the template table of the template database group,
The conversion information generating means,Respond to user input instructions,The existingDatabasePrevious data of the selected data item in the systemChickMeans for selecting a conversion table for converting to data of a corresponding data item of the shape table,
The conversion unit is configured to select the conversion table.According to the conversion information set inExistingDatabaseSystem data is stored in the template tableToConvert to suitable data and convert to data warehouseStoreMay be configured as follows.
According to this configuration, it is easy to associate the data items with each other, and further, a table is selected based on the association, and the data is converted and transferred according to the table. Therefore, data conversion is reliably performed. In addition, since a table is selected by associating both data items, data items on the source side and target side, association (mapping rule), and table can be centrally managed while maintaining a correlation.
[0014]
In order to achieve the above object, a data warehouse design system according to a second aspect of the present invention comprises:
The business handled in the business is designed in advance according to the data warehouse implementation format based on the business model data that expresses the business content of the business using the normalized plurality of elements and the attribute and element relationship of each element. A template table storage means for storing a template table having attributes of the plurality of elements as items;
Associating means for associating data items of the existing database system with data items of the template table according to a user's input instruction;
Conversion information generating means for generating conversion information for converting data of the existing database system into data adapted to the template table, according to the association of the association means,
It is characterized by having.
[0015]
A means for inputting data of the existing database system and converting the input data of the existing database system into data adapted to the template table according to the conversion information may be further arranged.
[0016]
SaidTemplateTabeLeDefinition of semantic contents of data itemsAnd a definition of the meaning content stored according to the user's input instruction.Means for displaying, saidTemplateTabeLeRelationship of each data itemMeans for storing information indicating the relationship, and information relating to the association stored in accordance with a user's input instruction.Means to displayAndIt may be further arranged.
[0018]
The information processing apparatus may further include at least one of a unit that displays a definition of the meaning of the data item of the table group and a unit that displays a relation between the data items of the table group.
By arranging these means, it is possible to prevent an error in the correspondence. For example, the item names of the source system are not fixed, and the same item names are often used in completely different situations depending on the creator. Positioning can be reliably determined, and appropriate item names can be associated with each other.
[0020]
The above-described system and method may be realized by storing and distributing a program that causes a computer to realize these functions and execute these steps in a storage medium and execute the program on the computer.
[0021]
BEST MODE FOR CARRYING OUT THE INVENTION
Hereinafter, embodiments of the present invention will be described with reference to the drawings.
[0022]
First, a data warehouse according to a first embodiment of the present invention will be described with reference to FIGS.
FIG. 1 shows a configuration of a data warehouse design / manufacturing system according to a first embodiment of the present invention.
This system is a system for converting data of an existing system into a data warehouse. As shown in FIG. 1, an input unit 1, a display unit 2, a business model storage / control unit 3, a DB (database) A) a schema template storage / control unit 4, a data dictionary storage / control unit 5, and a conversion unit 6.
[0023]
The input unit 1 includes a keyboard, a mouse, and the like, and inputs data, a business model, a DB schema template, instructions, and the like.
The display unit 2 includes a CRT, an LCD, and the like, and displays an input screen for inputting data and instructions, input data, and the like.
[0024]
The business model storage / control unit 3 stores the business model and displays the stored business model on the display unit 2.
This business model analyzes various businesses in detail, and conceptually organizes the elements (objects such as entities and classes) and their attributes related to the business to be modeled according to the object-oriented methodology. And further expresses the relationship between the respective elements (objects).
In other words, the business model itself is a model of universal elements handled in the business.
[0025]
FIG. 2 shows an example of a business model. However, FIG. 2 is an extremely simplified example for easy understanding. In FIG. 2, each block (box) represents a class, and represents a minimum unit of an item constituting a task. The relationship between the classes is represented by the cardinality (multiplicity) connecting the classes and the description given to the line. The data attributes and procedures of each class are described in each class.
[0026]
The DB schema template storage / control unit 4 stores a template database group (that is, a schema template) in which a business model is projected onto the real world.
In the database group of this model, each attribute of the business model stored in the business model storage / control unit 3 is used as an item (entity) of the database, and a pure logical model is considered in consideration of systematic processing efficiency and the like. It is integrated.
This database group follows the data warehouse database implementation format, and a database is created based on the database, and the data of the existing system is converted and inserted into the database, thereby becoming a data warehouse database.
[0027]
The data dictionary storage / control unit 5 stores a data dictionary in which each attribute of the business model and the semantic contents of the items of the DB schema template are expressed without ambiguity, and any items of the stored dictionary are stored. Is displayed on the display unit 2. This business dictionary uses synonyms, guarantees uniqueness of items, and uses clear and precise expressions to eliminate ambiguity.
[0028]
FIG. 3 shows an example of the data dictionary. According to FIG. 3, for example, the “contract date” is a “date on which a contract operation was performed”, and it can be clearly understood that the format is “8 digits of the Christian era”.
[0029]
The conversion unit 6 receives data of an existing system and converts the data into data conforming to a schema template. As shown in FIG. 4, a data item registration unit 61 for registering data items of the existing system, A mapping unit 62 for performing a process for associating the data items of the system with the data items of the schema template, and a program generation / editing for automatically generating a program for converting the data item associated by the user And a grammar checker 64 for checking the grammar of the program generated by the program generator / editor 63.
The system itself does not have a function of executing the program generated and edited by the program generating / editing unit 63, and compiles and executes the program on another machine to generate a data warehouse.
[0030]
Next, the data warehouse design / manufacturing system with this configurationBody structureThe construction method will be described with reference to the flowchart of FIG.
[0031]
First, the business is specified (step S11), the contents of the business are analyzed and analyzed (step S12), and the elements and their attributes related to the business are conceptually arranged as illustrated in FIG. Create a business model that is normalized (optimized) so as not to overlap (step S13). A business model is desirably designed one for one business. For example, in the business of finance, etc., there are various kinds of business such as accounting business, international business, securities business, yen fund business, external information business, etc. Then, one business model (meta model) is designed as a whole.
[0032]
Next, a template database group is designed using the data items of the designed business model as data items (step S14). In this database group, each attribute of the business model is used as a database item (entity), the pure logical model is divided into multiple tables in consideration of systematic processing efficiency, and the combination of items is also selected. I do.
[0033]
Further, for each of the data entities (data items) of the designed business model, as shown in FIG. 4, a data dictionary for clarifying the meaning is created (step S15).
[0034]
The created business model, database group, and data dictionary are respectively registered in the system (step S16), and the conversion unit 6 is further registered, whereby the system shown in FIG. 1 is configured (step S17). .
[0035]
In the case of an existing business, a business model that has already been set is selected (step S13 ′), a DB schema template that has already been set is selected (step S14 ′), and the selected business model is selected. By registering the DB schema template and the DB schema template in the system (step S16), it is possible to cope with this.
[0036]
Next, a procedure (method) of data warehouse design using the data warehouse design / manufacturing system thus configured will be described with reference to FIGS. Normal system design is performed in the order of "Survey" → "Design" → "Manufacture" → "Test". Hereinafter, the procedure will be sequentially described.
[0037]
(1) Process from investigation to design
In the case of using this data warehouse design / manufacturing system, it is not necessary to carry out the usual investigation and design process individually since a generalized version is prepared in advance as a business rule and template database group.
[0038]
(2) Process from design to manufacturing
(2-1) The operator operates the input unit 1 to activate the data item registration unit 61, and registers data items of the existing system to be converted into a data warehouse.
The data items are registered in a hierarchical structure so that the relation between the directory name, the table name, the data item, and the like can be understood.
The registration may be performed manually or by reading and inputting directory information of data of an existing system.
[0039]
(2-2) The operator operates the input unit 1 to activate the mapping unit 62 of the registration unit 6. As shown in FIG. 6, the mapping unit 62 displays a list of data items of the existing system (input module) in the left window and a list of data items on the DB schema template (output module) in the right window. .
[0040]
Using a GUI (graphical user interface), the operator double-clicks the data items hierarchically displayed in the left window on the existing screen and the data items hierarchically listed in the right window, for example, with a mouse. By doing so, it is selected and associated (mapped).
[0041]
Terms used in existing systems are set individually for each system and are not fixed. Therefore, in order to accurately determine the correspondence, the operator refers to the business model and / or the data dictionary by right-clicking the mouse and selecting an appropriate icon as necessary.
[0042]
For example, when the icon for displaying the business model is clicked, the registration unit 6 or another appropriate tool is activated, and the business model is displayed in an appropriate window. An operator may be able to refer to a necessary part of a business model displayed using a normal scroll technology or the like provided in an OS (Operating System).
[0043]
When the DB schema schema template display icon is clicked, the registration unit 6 activates the data dictionary storage / control unit 5, and the data dictionary storage / control unit 5 displays the data dictionary in the window. The operator can confirm the meaning and content of the desired data item using a normal search function or the like.
[0044]
In this way, the operator determines the relationship between the position of each item of the DB schema template and other entities, further clearly determines the meaning, and determines the item name of the existing system and the item of the DB schema template. To determine the correspondence.
[0045]
Based on the determination, the operator uses a GUI (Graphical User Interface) to display corresponding items of the data items hierarchically listed in the left window of the screen and the data items hierarchically listed in the right window. select.
[0046]
The mapping unit 62 displays both selected items in the lower window. For example, when "SSN" is selected as the corresponding item name, the item name "SSN" is displayed together with the icon as shown in FIG.
[0047]
When associating (mapping), the operator selects the “edit” button. This selection opens a window for inputting a conversion name (mapping name) and a description (mapping description), as shown in FIG. The operator inputs an appropriate name as the conversion name, and enters a comment as necessary.
This conversion name is a kind of function name for calling a conversion function (conversion program module) when converting the data of the selected item of the existing system into the data of the selected item of the schema template. Note that the selected item name may be displayed as a conversion name candidate.
[0048]
(2-3) Here, when the “OK” button is selected, the program generation / editing unit 63 is activated, and converts the data of the selected item of the existing system into the data of the selected item of the schema template. Automatically generate program (source) code.
This program code basically consists of a command sequence for moving (strncpy) the data of the corresponding item of the existing system to the data of the corresponding item of the schema template.
The program code generation / editing unit 63 displays the generated program code in a window as shown in FIG.
If this program code is sufficient, the operator operates the “OK” button. By this operation, the program code is stored together with the conversion name.
[0049]
However, for example, "year" expressed in "year" or "era" used in schema template is "year" expressed in "era" or "year" used in existing system In such a case, a simple strncpy command cannot be used.
Therefore, in such a case, the "edit" button is operated in the state of FIG. With this button operation, the program generating / editing unit 63 displays an editing screen for editing as shown in FIG. The operator creates a conversion program on this editing screen and registers it by instructing a “register” button.
[0050]
In addition, for example, “sex” represented by “F” or “M” used in the existing system is converted into “sex” represented by “0” or “1” used in the schema template. In such a case, a simple strncpy command cannot be used.
In such a case, the correspondence is defined as “F” → “0”, “M” → “1”.
The program generating / editing unit 63 generates a program for converting “gender” data used in the existing system into “gender” data used in the schema template, based on the defined correspondence. I do.
[0051]
If the "grammar" button is designated in FIG. 9 when the program is edited, the grammar (syntax error) of the displayed program (module) is checked. That is, when the "grammar" button is instructed, the grammar check unit 64 is activated, and the grammar check unit 64 checks the grammar of the program (source code) displayed in the window and displays the result.
[0052]
In this way, the operator associates all the item names used in the existing system with the items used in the schema template, and creates and registers the conversion program (source code).
[0053]
With the above processing, the preparation for registering the data of the existing system in the data warehouse (DB schema template) is completed.
The usual design method requires detailed debugging of the conversion program, but this system converts it almost automatically. Also, it is possible to check the grammar of the program without compiling. Therefore, the burden of debugging is very small.
[0054]
(3) Manufacture of data warehouse (migration of existing system data to data warehouse)
Next, the data warehouse manufacturing procedure is illustrated.10This will be described with reference to the flowchart of FIG.
When migrating the data of the existing system to the data warehouse, first, a data warehouse (data is not stored) is generated by selecting an item on the DB schema template using an arbitrary tool (step S20). .
[0055]
Next, by compiling the conversion program generated by the program generation unit 63 and executing the conversion program, the data conversion / setting processing of step S21 and subsequent steps is performed.
It should be noted that the data of the existing system is taken in advance in this conversion system in the form of a file.
[0056]
First, a data item of data is fetched (step S21), and a conversion name (mapping name) associated with the data item is determined (step S22).
Next, the conversion program module corresponding to the determined conversion name is read (step S23).
[0057]
Next, the data is sequentially read out (step S24), and the program module read out in step S23 is executed to convert each data of the existing system into the data of the corresponding item on the DB schema template, and the data generated in step S20 It is stored in the warehouse (step S25). Next, it is determined whether or not the data of the data item has been completed (step S26). If it is determined that the data has not been completed, the process returns to step S24 to read the next data and perform the conversion / storage processing. repeat.
[0058]
On the other hand, if it is determined in step S26 that the data conversion has been completed for the data item, it is determined whether the data conversion / storage has been completed for all the data items (step S27), and the process is completed. If not, the process returns to step S21, reads the next data item, and executes the same conversion and storage operation as described above.
[0059]
When the conversion of all data for the existing system is completed in this way, all data of the existing system is stored in the data warehouse created by the DB schema template in step S20.
[0060]
(4) Expansion of data warehouse
As described above, after a data warehouse for data is completed for a certain existing system, a data warehouse for another existing system can be easily generated. In other words, a business model and a DB schema template based on the business model are analyzed in detail, and a universal one is created. Therefore, the business content itself is the same even for other existing systems, although the individual data is different. Therefore, as described above, a data warehouse can be created by associating the data items with the existing system, generating a conversion program, and converting and storing the data.
[0061]
In this way, by converting and storing data of various existing systems in the data warehouse created from the DB schema template, the subsequent processing and use of the data can be performed efficiently or effectively. That is, since the information is organized and systematized by the unified business model, it is easy to apply to subsequent individual tasks. Also, it is easy to add information.
Also, since the model is unified and the correspondence between the existing system and the data warehouse is clear, the know-how can be easily reused.
[0062]
(5) Project management
The conversion unit 6 outputs (displays and prints) a list of correspondences between the data items of the conversion source and the conversion destination by a predetermined operation, or saves and outputs the data items in a database format.
Furthermore, according to this data warehouse, there is a basic business model, the meaning of the data items is clearly defined by the data dictionary, and the correspondence between the source and destination data items is clear. It is. Therefore, project management and reverse engineering are easy.
[0063]
Further, according to this system, the source schema (DB item of the existing system) and the target schema (DB item of the data warehouse) are associated with each other, and the source code is automatically created. Therefore, when the correspondence changes, the source code is also converted. Therefore, it is possible to perform centralized management while maintaining a correlation with the source schema and the target schema.
[0064]
The present invention is not limited to the above embodiment, and various modifications and applications are possible.
For example, in the above embodiment, the data item of the conversion source system and the data item of the DB schema template are individually associated by the operator using the GUI, but may be automated to some extent.
For example, each data item is composed of “item name” and “data format”, and when “item name” and “data format” match each other, the data items of the conversion source and the conversion destination are It may be determined that they correspond to each other.
For example, if the item name of the existing system is “name” and the data format is “maximum text 20 characters”, and the item name of the DB schema template is “name” and the data format is “maximum text 20 characters”, both data items May be determined to match each other. Similarly, when the item name of the existing system is “Year” and the data format is “YYMMDD”, the item name of the DB schema template is “Year” and the data format is “YYMMDD”, etc. You may decide.
[0065]
In this way, after automatically associating, those that could not be edited or associated may be individually associated.
Also, a plurality of item names selected by the operator in advance may be automatically associated.
[0066]
Further, data conversion may be performed according to an external conversion table instead of a program.
In this case, for example,11When the operator associates the data items of the conversion source system with the data items of the DB schema template by using the GUI as shown in (1), a conversion name is set and a conversion table is set. For example, in FIG. 12, “USD” is converted to “USD”.
When converting the data, the conversion name may be determined from the data item name, and the conversion table may be referred to based on the determined conversion name to convert the data.
[0067]
With such a configuration, it is possible to change the data conversion contents only by changing the conversion table without operating the program body.
For example, by simply adding “Fran: FRC” to the contents of the conversion table, the conversion can be changed to the conversion between franc and “FRC”.
Further, instead of changing the contents of the conversion program or the conversion table itself, it is also possible to change the conversion contents by modifying the conversion name and changing the conversion program to be executed or the conversion table to be referred to.
[0068]
In the above description, the system for generating the source code for data conversion and the system for compiling the generated source code, actually converting the data, and transferring the data to the data warehouse are configured. These may be one system.
[0069]
It should be noted that the system of the present invention can be realized by using a normal computer system without configuring as a dedicated system. For example, a data warehouse design / generation system that executes the above-described processing is constructed by installing the program from a medium (a floppy disk, a CD-ROM, or the like) storing the program for executing the above-described operation in a computer system. can do. By installation, the program is stored on a medium such as a hard disk in the computer system, and the data warehouse design / generation system is stored.ConfigureAnd run it.
[0072]
【The invention's effect】
As described above, according to the present invention, a data warehouse can be constructed relatively easily.
In addition, the developed data warehouse can maintain its development potential.
[Brief description of the drawings]
FIG. 1 is a block diagram showing a configuration of a data warehouse design / manufacturing system according to an embodiment of the present invention.
FIG. 2 is a diagram illustrating an example of a business model.
FIG. 3 is a diagram illustrating an example of a data dictionary.
FIG. 4 is a block diagram illustrating a configuration example of a conversion unit.
FIG. 5 is a flowchart showing a design procedure of the data warehouse design / manufacturing system shown in FIG. 1;
FIG. 6 is a diagram showing an example of a display screen when mapping data items in the data warehouse design / manufacturing system of FIG. 1;
FIG. 7 is a diagram showing an example of a display screen when mapping data items in the data warehouse design / manufacturing system of FIG. 1;
8 is a diagram showing an example of a display screen when mapping data items in the data warehouse design / manufacturing system of FIG. 1;
FIG. 9 is a diagram showing an example of a conversion program generation screen when mapping data items in the data warehouse design / manufacturing system of FIG. 1;
FIG. 10 is a flowchart illustrating a data conversion operation.
FIG. 11 is a diagram illustrating an example of a data conversion table.
[Explanation of symbols]
1 Input section
2 Display
3 Business model storage and control unit
4 DB schema template storage and control unit
5 Data dictionary storage and control unit
6 Conversion unit
61 Data item registration section
62 Mapping section
63 Program Creation / Editing Department
64 Grammar Check Department

Claims (12)

A business model data storage unit for storing business model data expressing the business contents of the business using a plurality of normalized elements and the relationship between the attributes and the elements of each element ,
On the basis of the business model data stored in the business model data storing means, designed in accordance with the data warehouse implementation form, the model table storage means for storing a model table to item attribute of the plurality of elements,
Receives an input instruction of the user, in accordance with input instructions, and associating means for setting the correspondence between the data item and the previous Kihiyoko shaped table data items of the data existing database system is processing,
According to the setting of the associating means, it is composed of a command sequence for moving the data of each data item of the existing database system associated with the associating means to the data of the corresponding data item of the template table group. Conversion information generating means for generating conversion information;
System design apparatus comprising: a. A data dictionary storage means for storing a data dictionary indicating the attributes of the business model data stored in the business model data storage means and the meaning of the data items of the template table;
  Dictionary output means for outputting the meaning content stored in the data dictionary storage means for user confirmation,
  The system design apparatus according to claim 1, further comprising: The conversion information generating means for converting the data of the existing database systems to data suitable for the template table group, an editing screen for editing the conversion information the operator has generated the conversion information generating means The system design apparatus according to claim 1, further comprising a providing unit. Data input means for inputting data of an existing database system,
Wherein the input data by the data input means, in accordance with the conversion information, into a compatible data before SL model table, converting means for storing the converted data in the data warehouse,
System design apparatus according to claim 1, 2 or 3, characterized in that Ru further comprising a. The association means,
Display means for displaying the data items of a data item and previous Kihiyoko shaped table of existing database systems,
Selecting means for responding to a user's input instruction, selecting between corresponding ones of the data items and data items before Kihiyoko shaped table of an existing database system that is displayed by the display means,
The system design apparatus according to claim 1 , wherein the system design apparatus comprises: The associating means is responsive to an input instruction of the user, comprising a means for selecting between a corresponding one of the data items and data items before Kihiyoko shaped table of existing database systems,
The conversion information generating means comprises means for generating a command sequence for moving the data of the corresponding data items in the existing database system of the selected data item of the data pre Kihiyoko shaped table,
And the converting means, by executing a command generated by the conversion information generation unit, converts the data from the existing system to data suitable for the template table, and stores the data warehouse,
The system design apparatus according to claim 4 , wherein: The associating means is responsive to an input instruction of the user, comprising a means for selecting between a corresponding one of the data items and data items before Kihiyoko shaped table of existing database systems,
The conversion information generating means selects a conversion table for converting in response to an input instruction of the user, data in the corresponding data item of the data of the selected data item of the existing database systems prior Kihiyoko type table With means to
And the converting means, according to the conversion information set in the conversion table selected, converts the data in the existing database system data suitable for the template table, and stores the data warehouse,
The system design apparatus according to claim 4 , wherein: The business handled in the business is designed in advance according to the data warehouse implementation format based on the business model data that expresses the business content of the business using the normalized plurality of elements and the attribute and element relationship of each element. A template table storage means for storing a template table having attributes of the plurality of elements as items;
Associating means for associating data items of the existing database system with data items of the template table according to a user's input instruction;
Conversion information generating means for generating conversion information for converting data of the existing database system into data adapted to the template table, according to the association of the association means,
A data warehouse design system comprising: 9. The apparatus according to claim 8 , further comprising means for inputting data of the existing database system and converting the input data of the existing database system into data adapted to the template table according to the conversion information. Data warehouse design system. It said associating means includes means for displaying the data items and data items of the template tables of the existing database system, prompt the user to select a between corresponding ones among the data items displayed The data warehouse design system according to claim 8 or 9 , further comprising: Information indicating means for storing the definition of the meaning of the data items of the template table, means for displaying the definition of semantic content stored prompt the user, the association of each data item of the template table 11. The data warehouse design system according to claim 8 , further comprising: a unit configured to store the information, and a unit configured to display information related to the association stored according to a user's input instruction . 12. A computer with a storage device ,
A business model data storage unit for storing business model data expressing the business contents of the business using a plurality of normalized elements and the relationship between the attributes and the elements of each element ,
Based on the business model data stored in the business model data storage unit, a template table storage unit that stores a template table that is designed according to a data warehouse implementation format and stores the attributes of the plurality of elements as items.
Receives an input instruction of the user, in accordance with input instructions, and associating means for setting the correspondence between the data item and the previous Kihiyoko shaped table data items of the data existing database system is processing,
According to the setting of the associating means, it is composed of a command sequence for moving the data of each data item of the existing database system associated with the associating means to the data of the corresponding data item of the template table group. Conversion information generating means for generating conversion information,
A machine-readable recording medium that stores a program for functioning as a computer.

Images