JPH10275104A - Method and device for data management - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide the data managing method which extracts and outputs desired item data in real time in various formats that a user easily requires and the data managing device which implements this method. SOLUTION: Items predetermined by specified users are selected out of a 1st data base 3 stored with item data relating to items one to one and converted into item data corresponding to the users to generate a 2nd data base 5. Desired item data that a user has selected are outputted in specific format from the 2nd data base 5. The user only selects the item to be outputted and then can obtain the necessary item data in specific format in real time.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data management method and a data management apparatus, and more particularly to a data management method capable of extracting data that can be disclosed in various output formats easily requested by a user and outputting the data in real time. A method and a data management device for performing the method.

[0002]

2. Description of the Related Art Generally, when a computer system is used to manage inventory items, production plans, production results, sales plans, sales results, etc., first, as shown in FIG. A related item data group is stored in a main database 3 provided in the system. The backbone database 3 includes a master file 31 for storing item names such as product names, and a data file 32 for storing numerical values related to the items. The data in the master file 31 and the data in the data file 32 are mutually associated. It is stored in the master file 31 or the data file 32 in association with the code for association.

[0003] From the data in the core database 3, for example, a group of openable item data related to a manufacturing plan is extracted, and a user, for example, an employee in the company, outputs the image as an image or prints it in an output format corresponding to the application and refers to it. For this purpose, it is generally necessary to access, extract, and combine necessary data from the data of a large number of files in a predetermined output format, and a user who is not familiar with the data structure can directly access the core database 3. Accessing this data is not easy.

[0004] Therefore, the programmer recognizes the structure of the data stored in the core database 3, accesses necessary item data that can be disclosed, extracts it as item data associated with each other, and converts the item data into a predetermined output format. A program to be output in combination is created, and an individual user operates the system according to a predetermined procedure according to the program incorporated in the system, thereby outputting data in the output format determined by the program.

By the way, when a computer system is introduced, what kind of output format each individual user wants to obtain can be disclosed by, for example, a questionnaire or the like. A program is created that outputs item data in the greatest common denominator output format required by. Of course, in many cases, a plurality of types of programs having different output formats are created.

However, in practice, it is often required to extract data in various output formats different from those at the time of system introduction. For example, the user requests the output of more detailed data than at the time of system introduction, the output of a part of item data in a predetermined output format, or the output format in which a plurality of output formats are partially or wholly combined. Or an output of data for a period different from the period set when the system was introduced.
In addition, the fact is that the change of the output format is required quite frequently.

Conventionally, in order to extract data from the core database 3 in a new output format, each time a programmer extracts required item data from the core database 3 and creates a program to be combined with the required output format, Core database 3 according to the new program
, Required item data is extracted and output in the new output format.

[0008]

However, creating such a new program requires a great deal of labor and time, and not only cannot obtain necessary data in real time, but also the When completed, the data in the output format may no longer be needed.

Therefore, unnecessary data is deleted from data output in a predetermined output format, or necessary data is picked up from data obtained in another output format and added to the output data. By doing so, the data of the required output format may be created by hand, but such operation is very complicated and error-prone.

In view of the above circumstances, the present invention provides a data management method and a data management method for enabling a user to easily output data that can be disclosed in various output formats in real time. It is an object to provide a data management device.

[0011]

The data management method according to the present invention employs the following means to achieve the above object.

First, a group of item data related to each item is stored in the first database 3 in the same manner as in the related art. From the first database 3, items predetermined for each user specified, for example, a user in the sales department, a user in the manufacturing department, are selected, and an item data group corresponding to each user, for example, The second database 5 is created by converting the data into item data groups such as public data and public data for manufacturing departments.

In the method of the present invention, the second
The desired item data selected for each individual user from the item data group corresponding to the user stored in the database 5 is output in a predetermined format.

As a method for selecting item data desired by each user, for example, selectable items are displayed as an image, and necessary items are pointed out of the displayed items, and unnecessary items are pointed out. And select.

Either the necessary items or the unnecessary items may be pointed, and each user may be able to select any of them. When it is desired to further specify a range to be output among the selected items, for example, input the range, point to a necessary sub-item of the displayed sub-item, or point to an unnecessary sub-item. The range of the data to be output may be specified by the selection.

In the method of the present invention, the user selects an item to be output as described above, the selected item data is extracted from the public database 5, and the item data combined according to a predetermined format is output.

Therefore, according to the method of the present invention, it is not necessary to set up a program for directly outputting data of a required output format from the first database 3, and each user selects an item and outputs data. With a simple operation, it is possible to output item data or a group of item data in a predetermined format in real time.

A data management device according to the present invention (hereinafter referred to as the present device) implements the above-described method of the present invention.
The following means are adopted. First, in the device of the present invention,
A first database 3 in which an item data group related to each item is stored, and an item predetermined for each specified user, for example, an openable item is selected from the first database, and each item is selected. Means 4 for converting the data into item data groups corresponding to the user and creating the second database 5.

Thus, from the first database 3,
For example, a predetermined item is selected for each user specified as a user in the sales department, a user in the manufacturing department, and an item data group corresponding to each user, for example, public data for the sales department, public data for the manufacturing department Then, the second database 5 is created.

This means 4 extracts the data from the first database 3 every time data in a predetermined range corresponding to the application is input to the first database 3,
Although it is possible to convert the data into item data corresponding to the user, it is possible to increase the operating rate of the system for normal business, for example, once a year, every six months, every quarter, or once every month. It is preferable to extract data in a predetermined range corresponding to a user, convert the data into item data corresponding to the user, and create a second database.

Although the number of the second database 5 may be theoretically one, the range of data to be stored differs depending on the user, for example, for the sales department, the manufacturing department, and the management department. In order to minimize the size of the database corresponding to, and to prevent accidental disclosure of data that does not correspond to users,
For example, a second database 5 corresponding to each user is provided, such as a public database 51 for a sales department and a public database 52 for a manufacturing department.

Further, the apparatus of the present invention further comprises a means A for outputting, in a predetermined format, desired item data selected for each individual user from the group of item data corresponding to the user stored in the second database 5. Is provided.

The means A is configured so that desired item data selected for each individual user from the group of item data corresponding to the user stored in the second database 5 can be output in a predetermined format. For example, a selection unit 6 for each user to select an item name of data to be extracted from the item data group of the second database 5, and the item name selected by the selection unit 6 are stored. Extraction means 7 for extracting item data from the second database 5
And output means 8 for outputting the extracted item data in a predetermined format.

The selection means 6 includes, for example, a display means 61 for displaying selectable item names and a pointer 62 for indicating an unnecessary item name or a necessary item name from the displayed selectable item names. Prepare.

The selection means 6 further comprises input means 63 for setting necessary data extraction conditions such as, for example, a product name, a product code, a period, and a store name. An extraction condition display field 61c for displaying the item name input by the input means 63 is provided.

Therefore, the user operates the selecting means 6 to select an item name to be output and an extraction condition in the item, and then activates the extracting means 7 and the output means 8 to perform a required operation. Output format data can be obtained in real time.

The extracting means 7 and the output means 8 can be configured to operate automatically based on, for example, an operation for confirming the selected contents of the selecting means 6. When the operation of deciding the selection content is completed, it is sufficient to wait until the data is output, and the user can obtain the data of the required output format by a simpler operation.

[0028]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS The method of the present invention and the configuration of the apparatus will be specifically described with reference to the functional block diagram of FIG.

The items described in the slip 1 are input to the system as data by operating the input means 2, and the data is stored separately in a master file 31 and a data file 32 of a first database (backbone database) 3. Is done.

Although only one master file 31 is shown here, for example, a product name master file that records product names and product codes in association with each other, and a purchase name that records purchasers and purchase destination codes in association with each other. A large number of master files are provided, such as a master file, a factory name master file for recording a manufacturing factory name and a factory code in association with each other, and a sales master file for recording a sales destination and a sales destination code in correspondence with each other.

Although only one data file 32 is shown here, a large number of data files 32 are provided in correspondence with the master file 31.
Is recorded in correspondence with each input data and a code for associating the input data with data in the master file 31.

For example, the means 4 for creating the second database every year is operated to access data that can be disclosed corresponding to a specific user such as a sales department, a manufacturing department, or a management department. Then, a group of openable item data within a predetermined range corresponding to the use of the sales department, the manufacturing department, the management department, etc. is extracted from the first database 3, and the extracted data of the master file 31 and the data file 32 are extracted.
Is converted into public data, which is a group of item data corresponding to the user, including all of the data of.

The program for converting data from the first database 3 to public data is hardly changed because, for example, the principle of maintainability for securing corporate accounting is applied.

This public data is stored in a second database (public database) 5 provided for each user. That is, the files of the second database 5 are provided for each specific user, for example, a public database 51 for the sales department and a public database 52 for the manufacturing department.

For example, a public database 5 for the sales department
1 includes product name, product code, purchaser, purchaser code,
Stored data such as store name, store name code, purchase date, purchase price, storage location name, storage location code, sales destination, sales destination code, sales date, and sales price are stored. , Product code, factory name, factory name code, material name, material code, supplier, supplier code, number of purchases, purchase price, production schedule, production results, work in process,
Data such as a shipping destination, a shipping destination code, the number of shipments, a shipment price, and the number of product stocks are stored.

After such a second database 5 is created, when an individual user starts up the system and selects a menu for outputting data from, for example, the public database 51 for the sales department, the selecting means 6 is activated to open the system. Access the database 5.

The selection means 6 includes a display means 61 for displaying selectable data names, and a pointer 62 for indicating unnecessary data or necessary data from the displayed selectable data. 6 is activated, data names that can be disclosed from the public database 5 are input to the selection means 6 in a predetermined order, and the screen of the display means 61 displays, for example, a product code, a product name, and an inventory as shown in FIG. Quantity management,
Item names 61a that can be selected by the user, such as item remarks, slip remarks, and quantities, are displayed in a row, for example.

In addition to the item name 61a illustrated here,
For example, item names such as year, January to December, and the purchaser, storage location, and seller are displayed by scrolling the screen display.

Below each item name 61a, a check mark 61b for checking whether or not each data is displayed is displayed. For example, when a check mark 61b corresponding to an unnecessary item among the displayed item names 61a is pointed, , A check mark 61 provided corresponding to the item name 61a
b is erased.

For items for which the check mark 61a remains, the user can set extraction conditions. That is, below each item name 61a, blank columns 61c for setting extraction conditions are provided in a plurality of upper and lower rows,
After clicking on this blank 61c, for example,
The extraction condition input by the numerical input means 63 such as a tablet or the like is displayed in this blank. In the example shown in FIG. 2, it is displayed that the extraction condition for displaying only the product code of 30000000000 products has been input.

An item name 61a indicating that display is unnecessary.
In the case where the item names 61a that need to be displayed are arranged in a row, if a rearrangement instruction is given by the input means 63 such as a mouse, for example, the item names 61a that do not need to be displayed are erased and Item name 61a is displayed on the left side.

The deleted item name 61a is automatically replaced with the item name 6
Although it may be written in order at the right end of the column 1a, the column of the item name 61a is sequentially blanked from the right end of the column by moving up the item name 61a to the left. Then, after clicking this blank box, when the item name 61a is input by the input means 63, the item name 61a and the check mark 61b are displayed on the screen of the display means 61.

The user can display which item data, which extraction condition, and in which order, by displaying on the display means 61.
That is, after confirming the model (model) of the output mode, by operating the selection and determination means (for example, the execution key provided on the input means 63, the select button of the mouse, etc.), the range of data to be extracted, that is, The output format is determined and stored in the extracting means 7.

The extracting means 7 stores data necessary for the output format selected by the selecting means 6 in the second database 5.
And combine them according to the selected output format. Then, the item data arranged in the selected output format is output by the output unit 8 such as a display unit or a printer.

For example, when the output format is selected as shown in FIG. 2, the product code, product name,
Product code 30000000 out of data such as slip remarks, quantity, packing type, unit price, amount area, cost of sales area, etc.
Data about 00 commodities is displayed on the output means 8 comprising display means.

As described above, the user selects the required item data from the item data group of the second database 5, specifies the display order of the item data, and instructs the output of the item data. With simple operations, it is possible to obtain item data according to the required output format in real time, eliminating the need for programming to obtain data in a different output format. It saves time and effort.

The input means 63 of the selection means 6 described above.
The input means 2 used for inputting data to the backbone database 3 may also be used, and the display means 61 of the selection means 6 may also be used as the display means of the output means 8.

In the above, the second database 5
2 is extracted and output. Of course, for example, “all” 6 in FIG.
By pointing to 1d, the second database 5
It is also possible to extract and output all of the data stored in.

[0049]

As described above, the method of the present invention comprises:
An item predetermined for each specified user is selected from item data related to each item stored in the first database, and each item is converted into an item data group corresponding to the user to create a second database. Then, the desired item data selected for each individual user from the item data group corresponding to the user stored in the second database is output in a predetermined format. According to the method of the present invention, the user can select the desired item data. By performing a simple operation of selecting data,
Desired item data can be obtained in a predetermined manner in real time.

Further, the apparatus of the present invention includes a first database storing an item data group related to each item, and an item predetermined for each user specified from the item data group of the first database. Means for creating a second database by converting it into a group of item data corresponding to each user, and selecting for each individual user from the item data corresponding to the user stored in the second database Means for outputting the desired item data in a predetermined format. Therefore, according to the apparatus of the present invention, the method of the present invention, that is, from the first database storing the item data group related to each item is stored. Selecting a predetermined item for each of the specified users, converting the selected item into an item data group corresponding to each user to create a second database, You can implement the method of outputting the desired item data selected by the user corresponding item data stored in the over scan for each individual user in a predetermined manner. As a result, the user can obtain desired item data in a predetermined manner in real time by performing a simple operation of selecting item data to be output.

[Brief description of the drawings]

FIG. 1 is a functional block diagram of the present invention.

FIG. 2 is an explanatory diagram of a display screen of a selection unit according to the present invention.

FIG. 3 is an explanatory diagram of a display screen of an output unit according to the present invention.

FIG. 4 is a functional block diagram of a conventional example.

[Explanation of symbols]

 3 First database 4 Means for creating a second database 5 Second database A Means for outputting desired item data in a predetermined format

Claims (2)

[Claims] 1. An item predetermined for each specified user is selected from a first database storing an item data group related to each item, and is converted into an item data group corresponding to each user. Creating a second database, and outputting, in a predetermined format, desired item data selected for each individual user from the item data group corresponding to the user stored in the second database. Management method. 2. A first database in which an item data group related to each item is stored, and an item predetermined for each specified user is selected from the first database. Means for converting the item data into a group corresponding to the user to create a second database; and selecting desired item data selected for each individual user from the group of item data corresponding to the user stored in the second database. Means for outputting in a form.