JP2010073056A - Data association definition system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a data association definition system which is used together with an application development support system and thoroughly and completely recognizes information handled in the application and a range of influence when the information is changed. <P>SOLUTION: A server of the data association definition system cooperating with a support system has: a means for adding an attribute "unneccessary" when a data item normally held by the support system is unnecessary for a customer; a means for relating a term with the data item when a name of the data item does not match the customer's term; a means for defining a data classification item classified by semantic unit to which the data item belongs and storing a data classification item ID in association with a data item ID into a data classification item table; and a means for extracting data classification item ID stored in the data classification item table without redundancy and storing it into the job data table together with the "unneccessary" attribute information of the data item. <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention relates to a data related definition system used together with a business application development support system.

2. Description of the Related Art There is known a system that includes a business template for sales management / accounting and the like and a development framework (a business application program / process component group) and supports development of a business system, that is, a business application. For example, there is a sales and accounting integrated solution “Fit-ONE (registered trademark)”. By using this, it is possible to define and develop business application requirements based on business templates and development frameworks such as sales management and accounting. Therefore, it is possible to realize an introduction period equivalent to that of package software while maintaining business suitability equivalent to scratch development. In addition, it is possible to systemize the unique business process that is the source of the company's strength.
In addition, there are the following patent documents as known technical documents related to the present invention.
Japanese Patent Application Laid-Open No. 2001-92946 JP 2003-337832 A JP 2004-302683 A

However, since there are multiple customers in actual sales management / accounting, etc., there are differences in the status of each customer (or each department within the customer), orders, sales, etc., even in the same meaning. May be treated in different terms.
For this reason, business templates and development frameworks such as sales management and accounting in business application development support systems such as Fit-ONE (registered trademark) have redundant information to be applied to multiple customers. It is not easy to delete only unnecessary information. This is due to the fact that in business application development support systems such as Fit-ONE (registered trademark), business templates such as sales management and accounting, and the development framework include the physical configuration of the database. ing. Therefore, if there is unnecessary information depending on the customer, it is necessary to process the data item of the target database as unused, instead of physically deleting it from the database configuration. If unused information is not organized, problems such as erroneous use of originally unused items may occur due to internal processing or data migration. Therefore, it is useful in the development and maintenance of business applications to be able to grasp which items in the database are unused, while maintaining completeness and completeness.

  When a business application such as sales management / accounting is applied to a plurality of customers, there are various mechanisms for managing information in a manner independent of specific terms. However, no mechanism has yet been presented that can grasp information handled by business applications such as sales management / accounting and the scope of influence when the information is changed while maintaining completeness and completeness.

  The present invention is a data-related definition system used together with a business application development support system having a business template for sales management / accounting, etc., and information handled by a business application such as sales management / accounting and when the information is changed It is an object to provide a data-related definition system for grasping the range of influence of an object in a comprehensive and complete manner.

In order to solve the above-described problems, in the present invention, similar semantic information is associated with all information in operations such as sales management and accounting. The associated information is managed as one unit in a semantic unit. The configuration of the present invention is as follows.
A data-related definition system having a server that performs data processing in cooperation with a business application development support system having a business template such as sales management / accounting to support the development of a customer's business application,
The business application development support system has a data item table storing a data item ID uniquely identifying each data item and its attribute information for a plurality of data items held as a standard,
In order to associate the terminology in the target customer for each of all data items that the business application development support system has as a standard, the server,
A first means for determining whether or not the data item is necessary for the customer to be applied and, if unnecessary, giving an attribute of being unnecessary to the data item;
Determining whether or not the data item name of the data item matches the term in the customer to be applied, and if not, second means for associating the term with the data item;
Data classification is defined by defining which data classification item the data item belongs to in a unit of meaning and associating the data classification item ID uniquely identifying the data classification item with the data item ID of the data item A third means for storing in the item table;
A fourth means for extracting the data classification item ID stored in the data classification item table without duplication and storing it in the business data table together with information on presence / absence of an attribute that is unnecessary for the corresponding data item; Have.

By using the data related definition system of the present invention together with the business application development support system, the following effects are obtained.
(1) In business applications such as sales management / accounting, it becomes possible to manage information in a manner independent of specific terms. This makes it possible to improve the business suitability of business applications such as sales management and accounting.
(2) In business applications such as sales management / accounting, it becomes possible to grasp the relevance of data in a comprehensive and complete manner. As a result, the development efficiency of business applications such as sales management and accounting can be improved.

Hereinafter, an embodiment of a data relation definition system of the present invention will be described. 1 to 7 show system configuration examples of the present invention.
FIG. 1 is a diagram showing a schematic configuration of a data relation definition system. The data input unit 1, the display unit 2 for displaying the processing result, the data processing unit 3 for performing processing as necessary on the input data, and the external storage device 4 for storing the processed data. The data processing unit 3 is implemented by an appropriate server computer, and software for realizing the functions of the system is installed.

FIG. 2 shows the relationship between the five tables used in this system. These tables are stored in the external storage device 4. The five tables and their roles are as follows.
Data item table 6: Stores data item information.
Table information table 7: Stores table information.
Table configuration table 5: Defines a table configuration (links the data item table 6 and the table information table 7).
Data classification item table 8: Information obtained by classifying a plurality of data items in a semantic unit is stored as a data classification item.
Business data table 9: Centrally manages data classification items for each customer to which Fit-ONE is applied.

  The data item table 6, the table information table 7, and the table configuration table 5 are business application development support systems having business templates such as sales management / accounting (for example, sales-accounting integrated solution Fit-ONE (registered trademark)). These are standard functions, and these portions have known configurations, but the data classification item table 8 and the business data table 9 which are new configurations according to the present invention function in cooperation with these.

  FIG. 3 shows an example schema of the data item table 6. A table that centrally manages data items used in a business application, and has a data item ID 10, a data item name 11, an attribute digit 12, and an attribute type 13 as attribute information. The data item ID 10 is an ID for uniquely identifying the data item, and the data item name 11 is a Japanese data item name. The attribute digit 12 has the maximum number of digits of the data item, and the attribute type is the data type of the data item (character string type, date type, numeric type, etc.). For example, data having a data item ID “COMPANYID” has a data item name “company ID” and is defined by “20” digits in a variable-length character string.

  FIG. 4 shows an example schema of the table information table 7. A table ID 14 is allocated and stored for each table. The table name 15 is a name that briefly describes the contents of the table. For example, the table name of the table whose table ID is “JYTYUTBL” is defined as “order table”.

  FIG. 5A shows a schema example of the table configuration table 5. The table configuration table 5 stores related information of the table ID 16 (linked with the table ID 14 of the table information table 7 in FIG. 4) and the data item ID 17 (linked with the data item ID 10 of the data item table 6 in FIG. 3). The The meaning (key item / basic item, etc.) of the data item having the data item ID 17 in the table having the table ID 16 is stored in the data item section 18. In addition, in the table having the table ID 16, information on the order in which the data item having the data item ID 17 is arranged is managed by the data item order 19.

Referring to FIG. 5A, for example, a table whose table ID is “JYTYUTBL” is composed of data of four data items whose data item IDs are “COMPANYID”, “SERINO”, “JUTYUBI”, and “JYTYU_EMPID”, respectively. Has been. Among them, the data item whose data item ID is “SERINO” is defined second in the table whose table ID is “JYTYUTBL”. In the table whose table ID is “JYTYUTBL”, data of data items whose data item IDs are “COMPANYID” and “SERINO” is key information.
FIG. 5B shows an example in which a table whose table ID is “JYTYUTBL” is created based on the table configuration table 5 of FIG. 5A. The name of this table is “order reception table” referring to the table information table 7 of FIG.

  FIG. 6 shows an example schema of the data classification item table 8. The data classification ID 24 is an ID for uniquely identifying the data classification, and classifies the data item ID 25 (associated with the data item ID 10 in the data item table 6 in FIG. 2) in a meaningful unit. The data classification name 26 is a Japanese data classification name and is a name defined for a semantic unit.

  When a plurality of data item IDs 25 are associated with one data classification ID 24, it can be determined that the associated plurality of data item IDs 25 have the same meaning. For example, when the data classification ID of each data item ID 25 of “JYTYU_EMPID”, “SYUKA_EMPID”, “URIAGE_EMPID”, and “SAIKEN_EMPID” is defined as “EMPLOYEEID”, “JYTYU_EMPID”, “SYUKA_EMPID”, “URIAGE_EMPID”, and “URIAGE_EMPID” “SAIKEN_EMPID” exists as a plurality of data item IDs 25, but can be determined to have the same meaning. The meaning in this case is “employee ID” of the data classification name 26.

  When one data item ID 25 is associated with one data classification ID 24, the data item name of the data item ID 25 (data item name 11 in the data item table of FIG. 3) can be directly associated with the data classification name 26. . For example, the data item ID 25 “PROCESSEDGOOD” is defined as “processed product” in the data item name 11 in FIG. 3, but is the only data item ID 25 associated with the data classification ID 24 “SETGOOD”. It can be handled as the data classification name 26 “set product”. Note that each data item ID 25 must be associated with one data classification ID 26 without fail.

  FIG. 7 shows a schema example of the business data table 9. The business data table 9 stores a data classification ID 27 (linked to the classification ID 24 of the data classification item table 8 of FIG. 6). In one business application such as sales management / accounting, all necessary data classification IDs 27 are extracted and stored without duplication of meaning. If the information that the business application development support system has as standard is unnecessary, the deletion category 28 can be used to give information (“1”) that it is unnecessary.

  FIG. 8 shows a flow of a method for creating a data relation definition using the data relation definition system of the present invention. This process is standardized by the business application development support system when applying a business application development support system (for example, sales-accounting integrated solution Fit-ONE (registered trademark)) to the business application development of a given customer. This is done for all data items. First, it is determined whether or not one of the data items held as a standard is necessary for the customer to be applied (step 29). If unnecessary, an attribute that is unnecessary is temporarily given to the data item (step 30). Thereafter, it is determined whether or not the data item name of the data item matches the term of the customer to be applied (step 31). If they do not match, the term of the customer to be applied is associated with the data item (step 32). Finally, the data category to which the data item belongs is defined (step 33). This is performed by associating the data item ID with the data category ID as in the data category item table shown in FIG. Note that the data classification item (data classification ID) takes over the attribute of being unnecessary given temporarily in step 30 to the defined data item. After the processing for all the data items held as standard is completed (step 34), the business data table shown in FIG. 7 is created using the data classification item (data classification ID) (step 35). Through the above processing, it is possible to define data items in terms of application target customers, and related information between the data items is managed in an integrated manner.

  FIG. 9 shows an image diagram when the data relation definition system of the present invention is applied to a plurality of customers. By using the data-related definition system of the present invention, it is applicable to a plurality of customers without changing the table information and the like that the business application development support system has as a standard. An example of data update when the data-related definition system of the present invention is used is as follows. First, the data input from the input unit (step 36) is temporarily stored in the business data table for the target customer (see FIG. 7) after performing the processing required for each business (step 37) (step 38). . The data to be registered / updated temporarily stored in the business data table can be identified from the information in the data classification item table (see Fig. 6), which data item is affected, and reflected within the required range (Step 39). The table data can be confirmed from the display section of the screen (step 40). In the data relation definition system, a table definition document can be output in terms of the customer to be applied (step 41).

It is a schematic block diagram of the data related definition system of this invention. It is a relationship figure between several tables used by this invention. It is an example of the data item table used by this invention. It is an example of the table information table used by this invention. It is an example of the table structure table used by this invention. It is an example of the table produced based on the data structure table of FIG. 5A. It is an example of the data classification item table used by this invention. It is an example of the business data table used by this invention. It is a flowchart (flow of a data related definition process) of the process in the system of this invention. It is a functional block diagram of the whole system of this invention.

Explanation of symbols

  1: input unit, 2: display unit, 3: data processing unit, 4: external storage device, 5: table configuration table, 6: data item table, 7: table information table, 8: data classification item table, 9: business Data table

Claims (1)

A data-related definition system having a server that performs data processing in cooperation with a business application development support system having a business template such as sales management / accounting to support the development of a customer's business application,
The business application development support system has a data item table storing a data item ID uniquely identifying each data item and its attribute information for a plurality of data items held as a standard,
In order to associate the terminology in the target customer for each of all data items that the business application development support system has as a standard, the server,
A first means for determining whether or not the data item is necessary for the customer to be applied and, if unnecessary, giving an attribute of being unnecessary to the data item;
Determining whether or not the data item name of the data item matches the term in the customer to be applied, and if not, second means for associating the term with the data item;
Data classification is defined by defining which data classification item the data item belongs to in a unit of meaning and associating the data classification item ID uniquely identifying the data classification item with the data item ID of the data item A third means for storing in the item table;
A fourth means for extracting the data classification item ID stored in the data classification item table without duplication and storing it in the business data table together with information on presence / absence of an attribute that is unnecessary for the corresponding data item; A data-related definition system characterized by comprising:

Images