KR20030009556A - Classification and Basic Information Management Method of Object-Oriented Programming - Google Patents

Abstract

The present invention efficiently classifies classification systems and reference information based on object-oriented technology in an information system that classifies, stores and utilizes information (reference information such as products, parts, products, etc.) according to a multi-level hierarchical classification (category) system. A method of management, comprising: a base information database management by attribute tables, hierarchical classification management of attributes, modeling of multi-functional products using multiple inheritances, classification hierarchy management by linking and direct duplication of category hierarchies, and standard information items. Product information management by multiple links, registration management of reference information items irrespective of the classification level, and the like.

According to the present invention, when the object-oriented concept is applied to an information management system based on a hierarchical classification system, a flexible and easy classification system modeling and management of reference information that reflects the diversity of the real world are possible, and thus it is active in a rapidly changing environment. Not only can it respond, but it can improve the utilization of information system by facilitating management and search.

Description

Classification and Basic Information Management Method of Object-Oriented Programming}

The present invention relates to a classification system based on object-oriented technology and a method of managing reference information. The present invention provides a method for efficiently managing information using a multi-level hierarchical classification system that can be usefully applied to an electronic catalog system, a parts information system, or an application thereof. It is about how to manage.

In general, a system that manages information according to a classification system such as an existing electronic catalog system uses a hierarchical object relational data model. That is, one category (category) is related to one table in the DBMS, and the attributes of the category inherited from the parent are related to the columns of the table in the DBMS. E-catalogue standardization is an issue due to the rise of e-commerce, but this standardization has a problem that needs to be continuously changed according to the development of the industry, the change of the corporate environment, or the changing patterns of users / customers. The existing object-relational data model structure is not easy to proactively cope with such changes inside and outside the e-business, and it is not easy to express complex multifunctional products. This is because a change or addition of hierarchical structure of the classification system directly affects the DBMS and does not support object-oriented technologies such as multiple inheritance.

Information management by hierarchical classification is widely used in electronic catalog system or product information management system. The difference with the general conventional e-catalogue system,

First, in the object relational data model, each category forms a 1: 1 relationship with the DBMS table, and the attributes defined for each category have a 1: 1 relationship with the columns of the DBMS table. Therefore, even when the user does not define a specific attribute value, NULL data is input to the corresponding column and referred to the search, thereby reducing the speed and utilization of the table. In the present invention, it is possible to improve the table utilization and retrieval speed by compensating for these disadvantages and managing them as a table for each attribute and not storing the attribute without the attribute value in the table of the DBMS.

Second, by defining hierarchical hierarchical relationship of attributes, it is possible not only to classify attributes into groups and to manage them clearly, but also to include sub-attributes using hierarchical structure of attributes when searching by higher attributes. This becomes possible.

Third, the existing object-relational data model allowed only single inheritance, which had limitations in real-world modeling of complex multifunctional products such as DVD Player Combo (DVD Player + VCR Player). The object-oriented data model supports multi-inheritance to enable real-world modeling for multi-functional products, as well as providing up-selling opportunities by allowing users to search for VCR Players or DVD Players, or even DVD Player Combos. It becomes possible.

Fourth, the hierarchical relationship of the existing category has a disadvantage in that the speed decreases when the depth of the hierarchy is increased by recursive inquiry by managing only the parent-child relationship between parents. However, in the present invention, not only the parent-child relationship but also the hierarchical direct relationship (child> father> grandfather> great-grandfather> grandfather) are also managed so that the speed does not affect the depth.

Fifthly, in a general electronic catalog system, one item is registered in only one category and thus cannot be searched in another category. In the present invention, the search is facilitated by allowing the user to be registered in various categories using multiple links of the item. This is a technology that is usefully used in e-Marketplace.

Sixth, in the existing electronic catalog system, items are registered based on the end (final) category of the hierarchy. Therefore, it was almost impossible to expand the classification and add a new category under the terminal. In the present invention, by allowing items to be registered in any category of the classification system, it is possible to increase the utilization of users by providing clarity of item classification, and to flexibly cope with the expansion of categories.

The present invention has been created in view of the above-mentioned conditions. The object-oriented technology is applied to hierarchical classification and information management, and the hierarchical classification of goods, articles, parts, and standard information according to the complex / diversity of the work environment is performed. This paper presents an efficient management method of taxonomy and standard information that can be expressed by modeling and make it easy to change and manage.

1 is a diagram illustrating management of a reference information database by an attribute table.

2 is a diagram illustrating hierarchical classification management of attributes.

3 is a diagram illustrating modeling of a multifunctional product.

4 is a diagram illustrating a classification system management by linkage and serial duplication of a category hierarchy.

5 is a diagram illustrating product information management by multiple links of reference information items.

6 is a diagram illustrating registration management of items irrespective of the classification level.

In order to achieve the above object, the object-oriented technology-based classification system and reference information management method according to the present invention classify information (standard information such as products, parts, products, etc.) according to a multi-level hierarchical classification (category) system. The method relates to the efficient management of classification system and reference information based on object-oriented technology in information systems that are stored and utilized. Multi-functional product modeling, derivative product modeling by flexible hierarchical classification management, category hierarchy link and serial redundancy management, product information management by multiple links of reference information items, registration of reference information items regardless of classification level Management and the like. Hereinafter, a detailed description of the configuration of the present invention with reference to the accompanying drawings.

1 is a reference information database management diagram using an attribute table.

The conventional e-catalogue system has a hierarchical classification of root> mechanical comp> bearing as shown in FIG. 1, and each attribute has attributes of p1 and p2, mechanical comp for p3 and p4, and bearing for p5 and p6. In this case, three tables corresponding to root (p1, p2), mechanical comp (p3, p4), and bearing (p5, p6) are generated.

When item is registered based on end (final) category such as Bearing as in Fig. 1), if the definition of attribute by category is ambiguous or the user does not input, the value of the attribute (p2, p4, P6) is NULL. As a result, it wastes DB tables and affects the search. In fact, in the case of the domestic company P, the item code defined at the top level and the attribute of the unit weight contained 333,510 attribute values in the item code, but the unit code contained 10,514 attribute values. Therefore, it can be seen that the input rate of the attribute of danjung is about 3.15%. However, as shown in b) of FIG. 1, when managing this as a property-specific table, only the property in which a value is input is stored and managed, thereby reducing the waste of the table and improving the search speed.

2 is a hierarchical classification management diagram of attributes.

If the attributes are organized and managed in a hierarchical system like in FIG. 2, the hierarchical search can be performed using only the attributes. In addition, due to the hierarchical relationship defined for the property, as shown in Fig. 2, when searching for the upper property diameter, the inner and outer diameters of the lower part are also searched and the results are output to expand the scope of the search. There is this.

3 is a modeling diagram of a multifunctional product.

In the existing electronic catalog system, the object-oriented multi-inheritance concept was not applied. As a result, product information that is complex and multifunctional is restricted in terms of expression and search. As shown in a) of FIG. 3, in the existing electronic catalog system, the DVD Combo composite product is classified at the same level as the DVD player and the VCR player, and the attributes defining the product must be defined separately from the DVD player and the VCR player. However, if this applies to the object inheritance technology of multiple inheritance as shown in b) of Figure 3, if DVD Combo is defined as a subordinate of DVD Player and VCR Player, DVD Combo does not have to define additional properties. When searching for a VCR player, the DVD Combo is also searched. This enables real-world modeling of multifunctional products, improves functionality when searching for DVD players or VCR players, and provides up-selling opportunities by showing new DVD Combos.

4 is a diagram illustrating a classification system management by link and serial duplication of a category hierarchy.

The duplication management of category hierarchical information is hierarchically managing the classification system of categories. As shown in (a) of FIG. 4, the parent-child relationship (子-父, 父-祖父, 祖父-曾祖父, 曾祖父-高祖父) ), As well as the hierarchical lineal relationship (line-to-line relationship from 子 to high 子), i.e., 子-父, 子-祖父, 子-曾祖父, 子-高祖父) is also a concept of managing together. By using hierarchical lineal relationship (a concept similar to the straight line of genealogy), it is easy to search the lineage relationship of classification system or the classification path, etc. There is an advantage that is not affected.

5 is a product information management diagram by multiple links of reference information items.

Multilinking of items overcomes the limitations of existing solutions (a structure in which one item is registered and used in only one category), so that a single product is classified into several categories of the classification system. When applied to this, it is possible to search and utilize product information in various related categories of the classification system, thereby providing opportunities for up-selling or cross-selling.

The multilink procedure of an item is as follows.

1) The product (DVD V2000) is registered to the standard DVD Player category using the Rated Power defined above and the Heads attribute defined in the DVD Player.

2) Add its own attribute Rewind Speed to the additional VCR Player category to link the product (DVD V2000) registered in 1) above.

3) Items that have passed through 1) and 2) can be searched in the category of DVD Player and VCR Player.

6 is a registration control diagram of reference information irrespective of the classification level.

The registration management of the reference information irrespective of the classification level is to register in the category of the higher level rather than the end of the classification system in the item registration. This is a useful method to extend the classification system to the emergence of derivatives. When modeling a derivative (BIC Ball Point Pen) as shown in Figure 6A, the Ball Point Pen and the BIC Ball Point Pen must be searched separately. However, when modeling as shown in b) of FIG. 6, the BIC Ball Point Pen can be inquired even when the Ball Point Pen is searched. The classification system is constantly changing due to the emergence of new products and changes in the business environment. Registration management of reference information irrespective of classification level is a way to proactively respond to these changes and flexibly define products.

As described above, according to the object-oriented technology-based classification system and the management method of the reference information according to the present invention, when the object-oriented concept is applied to the information management system by the hierarchical classification system, it is flexible to reflect the diversity of the real world. Modeling and management of standard information can be managed easily and not only to respond to rapidly changing environmental changes, but also to facilitate the search, thereby improving the utilization of the information system.

Claims (6)

In constructing an information system that manages data, a method of constructing a table for each attribute defining the table does not constitute a table corresponding to a class / entity / category. A method of classifying and managing attributes hierarchically in the construction of the information system of claim 1, and using the hierarchical classification relation to use them for searching. A method of modeling classes / entities / categories using multiple inheritance concepts in the construction of the information system of claim 1 Method of using hierarchical direct relationship as well as parent-child relationship in order to define, search, and search hierarchical classification in building information system of claim 1 In the construction of the information system of claim 1, in order to register the reference information in various categories and use them in the search, the method is registered in the reference category and additionally registered in the various sub-categories and searched and utilized. A method of registering and using reference information in a category of an intermediate level that is not at the end of the hierarchy classification in the construction of the information system of claim 1