JP2003208341A - System and method for storing and using data - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To enable a client to easily obtain groups of data in a usage-oriented form from a dataware house and to provide an information sharing system with a remote place at a low cost. <P>SOLUTION: This data storage and use system is provided with the dataware house 3 having accumulated data 18 and a shared file 6, for storing data in the accumulated data 18 and for updating data of an output table 19 of the shared file 6 based on the accumulated data 18 at a set timing, and a Web server 7 for transmitting the applicable output table from the shared file 6 to a personal computer 10 via a network 8 in response to a request from the personal computer 10 via the network 8. The data storage and use system is further provided with a main frame 1 having a primary data base 11, for integrating inputted data into primary data 11 by its management item classification, for extracting data within a set range of the primary data 11 according to a transfer command and for transferring the data to the house 3. The house 3 has an emulator server 4. <P>COPYRIGHT: (C)2003,JPO

Description

Detailed Description of the Invention

[0001]

FIELD OF THE INVENTION The present invention relates to the storage and shared use of data utilizing a data warehouse and network. In a specific example, data is accumulated in a management-oriented format in a mainframe database (hereinafter referred to as the primary database), and this is accumulated in a data warehouse database (hereinafter referred to as the cumulative database), This is an in-house information sharing system that retrieves this accumulated data with a client computer and uses it for business.

[0002]

2. Description of the Related Art Conventionally, when using the data stored in a data warehouse, a small number of employees directly access the data warehouse server with client computers, download the data, analyze the data with the client computers, and The output table was edited in a table format convenient for information use at each location, that is, a format that emphasizes usage, to create an output table, which was sent by facsimile or e-mail to the location where the usage request was made. At the receiving location, make several copies and distribute them to many employees.

Japanese Unexamined Patent Publication No. 10-254743 discloses that, from a database 2 that stores data in a management-oriented format,
A data warehouse system including a data warehouse that extracts only data requested by a client and stores the extracted data in a user usage format is disclosed. The system includes a data management unit that totals the request frequency for each data of each client computer, extracts the data requested by the client from the database 2 and stores it in the data warehouse, and deletes the data no longer requested.

Japanese Patent Laid-Open No. 2000-148676 discloses that
A data warehouse system is disclosed which includes data collection means 102 and 103 for extracting data from servers 114 and 122 that supply data according to a data request condition of a client to create a replica and transmitting the data from the replica to the client. ing.

[0005]

In the above-described conventional example in which data is obtained from the data warehouse on the client computer, edited into an output table in a format that emphasizes usage, and distributed to many employees, the output table Since a person intervenes in the generation and the transmission, the content of the information may vary and the transmission may be omitted. When accessing the data warehouse server directly from a remote location, the data warehouse's accumulated data is a convenient item classification (classification) for data accumulation and management.
Since it is stored in the storage database, that is, in a management-oriented format, the communication capacity for obtaining all the data for generating the required output table is large and the communication time is long. Also, since the contents of the required output table are different in each department within the company, there are many clients that connect to the data warehouse server to generate the output table in each department, and there is a cost to facilitate these accesses. . For example, in order to build an information sharing system in which all employees who need the output table can directly access the data warehouse server individually, the number of clients connecting to the data warehouse server will increase and a large communication capacity will be required. This increases the cost of system construction and maintenance.

The data warehouse disclosed in Japanese Patent Laid-Open No. 10-254743 is a data buffer memory between a database 2 which stores data in a management-oriented format and a client computer, and does not store data for a long time. , Database 2 seems to carry out long-term accumulation. The data warehouse extracts the data requested by the client from the database 2 and stores it in the data warehouse, and holds the data with a high request frequency in the data warehouse, but deletes the data that is no longer requested. When a client computer requests data, the data warehouse must be retrieved from the database 2 and the buffer memory function of the data warehouse cannot be utilized.

The data warehouse system disclosed in Japanese Patent Laid-Open No. 2000-148676 has the same problem. That is, data is extracted from the servers 114 and 122 in accordance with the client's data request, a replica is created in the data collecting means 102, 103, and data is transmitted from the replica to the client. Therefore, when the client requests the latest data, , Data collection means 10
2, 103 extracts data from the servers 114, 122, generates a replica, and transmits it to the client.
The replica function of the data collection means 102, 103 cannot be utilized.

That is, the above-mentioned Japanese Patent Laid-Open No. 10-254743.
Japanese Patent Laid-Open No. 2000-
In any of the data warehouse systems disclosed in Japanese Patent No. 148676, when a client who always needs the latest data requests the data, the data warehouse or the data collecting means always updates the latest data from a database storing the data in a management-oriented division of the source. The data warehouse is not useful for clients who always need to download the latest data.

In the present invention, the conventional data warehouse is
What was applied as a so-called information system,
It is placed as the center of the core system to make the entire system simple and efficient, and the first purpose is to easily obtain the data group in the format that the client attaches importance to from the data warehouse. The second purpose is to provide an information sharing system with a remote place at low cost.

[0010]

(1) A cumulative database (18) and a shared file server (6) are provided, and given data is accumulated in the cumulative database (18), and a shared file is set at a set timing. Server (6)
The data warehouse (3) for updating the data of the items of the output table (19) of the computer based on the information of the cumulative database (18); the computer (1 via the network (8)
Web server (7) for transmitting the corresponding output table from the shared file server (6) to the computer (10) via the network (8) in response to a request for the output table from the computer (0); Accesses the Web server (7) through the network (8) to request the output table, and the Web server (7) through the network (8).
A data storage and utilization system comprising a plurality of computers (10) for receiving output tables from the computer.

In order to facilitate understanding, reference numerals of corresponding elements of the embodiments shown in the drawings and described later or reference numerals collectively showing equivalent elements are added for reference in parentheses. The same applies to the following.

This system is a data warehouse (hereinafter also referred to as DWH) at a set timing.
In (3), based on the data in the cumulative database (18), the data in the output table (19) that lists required items is updated and stored in the shared file server (6). The output table of this shared file server (6) is the Web server (7).
Can be downloaded via the intranet client computer (10). If the output table has an item that specifies writing of the latest data, the data of the item of the output table is rewritten to the latest data of the cumulative database (18) when the output table is updated. Therefore, when the client computer (10) requests the output table, the client computer (10) can automatically download the output table in which the latest data is written. The output table can be easily obtained.

As described above, DWH (3) is used for the convenience of data extraction and analysis, and a table in which the required items are individually developed so that the data analysis knowledge of DWH (3) is unnecessary. A format output table is created, and the data is automatically updated at a set timing based on the data in the cumulative database (18) and stored in the shared file server (6).
Furthermore, since the output table in tabular format can be read by all Intranet PCs (personal computers), the output table that can be accessed is limited depending on the user, PC hierarchy, and function. This can be done by setting a password when connecting to the Web. It is easily possible. In this case, since the system administrator has jurisdiction from the mainframe (1) to the shared file server (6), both data sharing and security can be maintained.

[0014]

BEST MODE FOR CARRYING OUT THE INVENTION (2) Primary database (11)
And the input data is accumulated in the primary database (11) according to the management item classification, and the data in the setting range of the primary database (11) is extracted according to the transfer instruction and is stored in the data warehouse (3). The data storage and utilization system according to (1) above, further including a mainframe (1) for transferring.

In this system, the data in the setting range is automatically extracted from the mainframe (1) at the set timing by the DWH (3) and stored in the cumulative database (18). The latest data can be stored automatically in sequence.

Then, at a set timing, an output table in which predetermined items are displayed is stored in a cumulative database (18) at that time.
Since it is updated based on the data of, the output table that has items to write the latest data is automatically accumulated database (1
The client computer can access the Web server (7) at any time and immediately download the output table having the latest data by rewriting the latest data of 8).
The output table is automatically updated and the client
An output table with the latest data can be easily obtained with no dead time.

(3) The data warehouse (3) is
The transfer command is transmitted to the mainframe (1) at the set timing, the data received from the mainframe (1) is accumulated in the cumulative database (18), and the shared file server (6) of the shared file server (6) is set at the set timing. Output table (1
An emulator server (4) for updating the item of 9) based on the information of the cumulative database (18); the data storage and utilization system of (2) above.

The range of data to be extracted from the mainframe (1) (for example, from 24 hours before the present time) is set by setting the macro of the replica function of the emulator server (4), which extracts the data from the primary database and stores it in the storage database. The data accumulated in the cumulative database up to the present time) and the timing (for example, 7:00 every morning) are determined, and the items of the output table stored in the shared file server (6), the extraction conditions of the data to be written in the items, and By creating a data frame that represents the output table in which data is extracted from the cumulative database and the notation information is written in the items according to the functional expression of the data expression, and an output table editing program that replaces the existing data frame is added. , In programming the emulator server (4), above ( ) The function of the data warehouse can be achieved of. That is, the data warehouse can be easily configured.

(4) The output table (19b, 19c) is a composite output table having a plurality of items that describe each data of a plurality of management items (production information and quality information / sales information and shipping information). The server (4)
The data storage and utilization system according to (3) above, which extracts data from the cumulative database (18) according to the data extraction conditions defined therein and updates it accordingly.

For example, although the management classifications are different, it is a combination that is convenient to use if they are listed together in terms of data usage, such as past production information under a certain operating condition and inspection results of products manufactured thereby. The output table in which the quality information and the quality information are described together can be downloaded to the client computer. Clients are operational records (operating conditions)
And the result (product quality: inspection result) can be compared and analyzed on one screen.

(5) In the data warehouse (3), the data given to it is accumulated in the cumulative database (1
8) is stored in the output table (19) of the shared file server (6) based on the information of the cumulative database (18) at the set timing, and the data of the reference information item with emphasis on use is updated to the shared file. It is held in the server (6), the required output table is designated from the Web browser of the computer (10) at a remote location, and downloaded to the computer (10) from the shared file server (6) via the Web server (7). , Data storage and usage method using data warehouse (3).

According to this, the function and effect described in the above (1) can be similarly obtained.

(6) At the setting timing, the extraction of the data of the setting range from the primary database (11) of the mainframe (1) in which the data is collected by the management item classification and the transfer to the data warehouse (3) are performed. , Auto start with macro,
In the data warehouse (3), the data received from the mainframe (1) is accumulated in the database (18).
The data of the items of the output table (19) of the shared file server (6) are updated based on the information of the cumulative database (18) by automatic start by the macro, and the computer (10) connected by the network (8) is stored. ) Requesting the output table from the Web browser of (7) to the Web server (7), and in response to this, the Web server (7) sends the corresponding output table of the shared file server (6) to the computer (10). Data storage and usage method using warehouse.

According to this, the function and effect described in the above (2) can be similarly obtained.

[0025]

DESCRIPTION OF THE PREFERRED EMBODIMENTS FIG. 1 shows the outline of the system configuration of an embodiment of the present invention. The present embodiment is a mainframe 1 that collects data in a management-oriented format having sales and production management information.
a, 1b, 1c, 1d (generally indicated by 1), a fixed work pattern which is an output table for extracting data from the mainframe 1 via the network 2, accumulating it in its own cumulative database, and storing it in itself If there is a request from a remote location via the network 8 for a data warehouse 3 that is updated based on the accumulated data and a Web browser, We outputs the routine work pattern of the data warehouse 3 to the request source We
b server 7 and personal computers 10a, 10b, 10c (collectively denoted by 10) which are client computers of this system located at a remote place and having a Web browser.

In this embodiment, the data warehouse 3
(DWH3) includes an emulator server 4, a DWH server 5, and a shared file server 6. A primary database 11a in which data is accumulated in each of the sales information, the production information, the quality information, the shipping information, the purchasing information, and the financial accounting information, which are management classifications of the mainframe 1.
From 11 to 11f (generally indicated by 11), the emulator server 4 automatically starts the extraction of the data for generating the data warehouse database by the macro at the set time. Then, the extracted data is created in file units, and the download to the data warehouse server 5 and the protocol conversion are automatically started. After downloading,
The macro that creates the data warehouse database for each data file is automatically started, and the automatically started macro further extracts and edits data and updates the routine work pattern (output table) of the shared file server 6. .

This routine work pattern is used for LAN and WAN.
An output request is made from the Web browser of the personal computer 10 connected via the network or the Internet, and the personal computer 10 is downloaded to the personal computer 10 via the intranet Web server 7.

2, 3 and 4, mainframe 1a, emulator server 4, DWH server 5, Web
An outline of the functions of the server 7 and the access right management server 9 will be shown.

The mainframe 1a has each database which is a primary database in a management division of management emphasis, sales information 11a, production information 11b, quality information 11c, shipping information 11d, purchasing information e and financial accounting information 11f,
Data is input to the mainframe 1a from the terminal device in each management section at any time, and is stored in each database in order of input date. The data is accompanied by date / time data of data creation or processing. The databases 11a to 11f (generally denoted by 11) hold information for the latest three months. The other mainframes 1b to 1d also have the same configuration and function as the mainframe 1a, and each of them, for example, at the head office,
It is installed with terminals in branch offices, factories, sales offices, etc.
In response to a data transfer command from the emulator server 4 via the WAN (Wide Area Network) 2, the mainframe 1 automatically activates data extraction and transmission file creation by a macro, and includes the data transfer command. The data is extracted from the database 11 under the conditions specified by the parameters to create a transmission file and transferred to the emulator server 4.

In the data warehouse 3, the emulator server 4 automatically activates the data extraction by the macro at 7 am every day from 7 am to 24 hours before the current mainframe 1 (1a to 1d). Of the input data of (1) and accumulation in the cumulative databases 18a to 18f (collectively indicated by 18) of the DWH server 5 are started. WAN for data extraction from mainframe 1
Through 2.

That is, a data transfer command is transmitted to the mainframe 1 via the WAN 2, and the mainframe 1 receives the transmission files 13a to 13f generated in response thereto. The received transmission file is described as 15a to 15f in the block of the emulator server 4.

The emulator server 4 is the mainframe 1
The parameters that can be included in the transfer command given are the database management category (11a to 11f), the data type, the extraction target period (* year * month * day to * year * month * day), and data. There is a creation date or a processing date, and the transfer processing conditions are a transmission data file name, a storage destination of the transmission data file on the mainframe side (mainframe MAC address, volume number), a transmission file destination (device name) on the emulator server 4 side. Alternatively, there are IP address, drive, folder name), reception processing date and time (processing date designation, date and time continuous designation, processing hour, minute), etc., but in the present embodiment, by these selection settings, every day at 7 a.m. in a macro. The data extraction is automatically started, and the mainframe 1 (1a
1d), the extraction (sampling) of the input data from 7 o'clock to 24 hours before the current time and the accumulation in the cumulative databases 18a to 18f (generally indicated by 18) of the DWH server 5 are performed on the mainframe. The steps 1a to 1d are sequentially performed.

When the transmission files 15a to 15f are received, the emulator server 4 automatically activates the protocol conversion 16 by a macro and receives the received transmission files 15a to 15f.
Data format from mainframe 1 side signal format to DW
Files 16a to after being converted into CSV format on the H server 5 side
16 f, and those files 16 a to 16 f are transferred to the DWH server 5. The files received by the DWH server 5 are stored in the blocks of the DWH server 5 with 17a-1.
It is written as 7f.

The DWH server 5 has the files 17a-17
When f is received, the macro automatically starts the data storage process to store the data of the received files 17a to 17f in the cumulative databases 18a to 18f. The extraction of the data from the mainframe 1 and the accumulation in the cumulative database 18 are sequentially performed from the mainframe 1a to 1b, 1c and 1d. The data holding period of the DWH server 5 is assumed to be a long period of 3 to 10 years from the acceptance, and the cumulative database 18 has a large amount of data storage capacity.

When the above-mentioned data extraction from all the mainframes 1a to 1d and storage in the cumulative database 18 are completed, the emulator server 4 automatically starts the update of the routine work pattern by the macro and stores it in the shared file server 6. The data update of the standard work patterns 19a to 19e (generally represented by 19) is started.

The routine work pattern 19, which is an output table, is a table template that can be created and edited with spreadsheet software (for example, Microsoft's trademark Excel) in which a combination of information is set for each work. In this routine work pattern 19, data representing extraction conditions / relational expressions are attached to the data items, and the emulator server 4 extracts the corresponding data from the cumulative database 18 based on the data and writes the data in the data items. Note that the routine work pattern 19 of the shared file server 6 is numbered and stored for each pattern in a folder defined for each work, and registration of new patterns, deletion of existing patterns, access permission range, creator information. The storage period is managed by commands accessed from the terminal.

The users of the personal computers 10a to 10c (collectively denoted by 10) which are client computers,
A web browser of a personal computer is used to connect to the web server 7 via the network 8. The Web server 7 transmits the “typical work menu list” to the connected personal computer 10, which appears on the display of the personal computer. This “list of routine work menus” displays the names of routine work patterns for each hierarchy of business groups. When a personal computer user designates a specific routine work pattern and requests data transfer, the web server 7 checks whether or not the personal computer user has an access right with the access right management server 9, and if there is an access right, the web server 7 Transfers the specified routine work pattern to the personal computer 10. That is, download. The transferred identification information of the routine work pattern (hierarchy & pattern name of the work group) is given to the access right management server 9.

The access right management server 9 stores the accessed personal computer user in the access history management database 24. The access right management server 9 determines whether the personal computer user who has requested the routine work pattern has access right to the pattern.
Refer to to determine. The access right can be set for each business group hierarchy to which it belongs, or for each personal computer user. The access history management database 24 records an access history (access date and time, personal computer user) for each standard work pattern.

[0039]

As described above, information sharing can be realized only by a computer having a Web browser without constructing a dedicated system at a remote terminal. Therefore, the output table stored in a user-focused format with a small cost and man-hours can be used accurately in a wide area without any time difference and without the time required to send the output data to the paper. Work efficiency can be improved.

If there is an item for writing the latest data in the output table, the data of the item in the output table is rewritten with the latest data in the cumulative database 18 when the data in the output table is updated at the set timing. Therefore, when the client computer 10 requests the output table, the client computer 10 can automatically download the output table in which the latest data is written. The output table updated with the latest data becomes easy to obtain.

[Brief description of drawings]

FIG. 1 is a block diagram showing an outline of a system configuration of an embodiment of the present invention.

FIG. 2 is a block diagram showing an outline of a configuration of a mainframe 1a and an emulator server 4 shown in FIG.

3 is a block diagram showing an outline of a configuration of a DWH server 5, a shared file server 6 and a Web server 7 shown in FIG.

FIG. 4 is a block diagram showing an outline of a configuration of a Web server 7 and an access right management server 9 shown in FIG.

[Explanation of symbols]

10a to 10c: personal computer 11a-11f: primary database 18a-18f: Cumulative database

   ─────────────────────────────────────────────────── ─── Continued front page    (72) Inventor Toshihiro Miura             7-6-1, Higashi Narashino, Narashino, Chiba Prefecture             Nittetsu Welding Industry Co., Ltd. (72) Inventor Tsuyoshi Sugawara             7-6-1, Higashi Narashino, Narashino, Chiba Prefecture             Nikko System Co., Ltd. (72) Inventor Masao Asano             7-6-1, Higashi Narashino, Narashino, Chiba Prefecture             Nikko System Co., Ltd. F-term (reference) 5B082 GA08 GC04

Claims (6)

[Claims] 1. A cumulative database and a shared file server are provided, the given data is accumulated in the cumulative database, and the data of the items in the output table of the shared file server are accumulated at the set timing based on the information in the cumulative database. A data warehouse for updating; a Web server for transmitting the corresponding output table from the shared file server to the computer via the network in response to a request for the output table from the computer via the network; and
Each accesses the Web server via the network, requests the output table, and sends the output table via the network.
multiple computers receiving output tables from the eb server;
A data storage and utilization system including. 2. A primary database is provided, input data is accumulated in the primary database according to its management item classification, data in the setting range of the primary database is extracted according to a transfer instruction, and transferred to the data warehouse. The data storage and utilization system according to claim 1, further comprising: 3. The data warehouse transmits the transfer command to a mainframe at a set timing, accumulates data received from the mainframe in a cumulative database, and outputs the shared file server at a set timing. The data storage and utilization system according to claim 2, further comprising an emulator server that updates the items in the table based on the information in the cumulative database. 4. The output table is a composite output table having a plurality of items representing each data of a plurality of management items, and the emulator server outputs the plurality of items from the cumulative database according to the data extraction condition defined therein. The data storage and utilization system according to claim 3, wherein the data is extracted and updated accordingly. 5. In a data warehouse, the data given to it is stored in a cumulative database, and the data of the reference information items with emphasis on use in the output table of the shared file server is stored based on the information of the cumulative database at the set timing. Data storage using a data warehouse, which is updated and held in a shared file server, and a necessary output table is designated from a Web browser of a computer at a remote location and downloaded from the shared file server to the computer via the Web server. How to Use. 6. A data warehouse, in which a macro automatically starts extraction of data in a set range from a primary database of a mainframe in which data is collected according to management item classification and transfer to a data warehouse at a setting timing. At
The data received from the mainframe is stored in the cumulative database, the data of the items in the output table of the shared file server is updated based on the information in the cumulative database by automatic startup by the macro, and the W of the computer connected via the network is updated.
A data storage and utilization method using a data warehouse, in which an eb browser makes a request for an output table to a Web server, and in response to this, the Web server sends the corresponding output table of the shared file server to the computer.