A product data structure configuration method and system

Abstract

The present invention discloses a product data structure configuration method and system. The present invention integrates a product data structure model by setting a product type table, a product table, a tariff table, a tariff product relationship table, an attribute table, a tariff attribute relationship table, and a product attribute relationship table. By configuring the product value of the product type table and the product information in the product table, and associating the product value with the product information, by configuring the tariff information of the tariff table and the attribute information of the attribute table, and establishing the first associated content through the tariff product relationship table, establishing the second associated content through the tariff attribute relationship table, and establishing the third associated content through the product attribute relationship table, both single-price product services and personalized tariff product services can be supported, providing applicability and diversity. As a product data structure configuration method and system, the present invention can be widely used in the field of Internet technology.

Description

Technical Field

[0001] The present invention relates to the field of Internet technology, and in particular to a product data structure configuration method and system. Background Art

[0002] With the development of Internet technology, various products have emerged in an endless stream, which can meet the different needs of users in various fields. Different products face different user objects and have different characteristics. For example, there are differences between products facing B-end enterprise users and products facing the online shopping platform that the public contacts on a daily basis. For example, facing B-end enterprise users, product transactions are not a single product sales and payment process, but will include: payment types selected by different customers (such as prepaid / postpaid), tariff types of different products (such as one-time fees, daily rentals, monthly rentals, annual rentals), and tariff calculation methods for different products (such as standard billing, tiered billing). In order to meet the above needs, product data needs to be set in advance when the product is released for sale, and the existing product data structure is designed as a product type table or product information table, which has a relatively simple structure. The configuration of product data only supports product services with a single selling price, and cannot support product tariffs with personalized tariffs. Summary of the invention

[0003] In view of this, in order to solve the above technical problems, an object of the present invention is to provide a product data structure configuration method and system with improved applicability.

[0004] The technical solution adopted by the present invention is:

[0005] A product data structure configuration method, comprising:

[0006] In response to the first operation instruction, configuring a product value of the newly added product in the product type table; the product value represents different product categories;

[0007] In response to the second operation instruction, configure the product information of the newly added product in the product table; the product information is associated with the product value, and the product information includes a product ID;

[0008] In response to the third operation instruction, configuring the tariff information of the newly added product in the tariff table and establishing a first associated content through the tariff product relationship table; the tariff information includes a tariff ID and a tariff type corresponding to the tariff ID, and the first associated content represents an associated relationship between the product ID and the tariff ID;

[0009] In response to the fourth operation instruction, configuring the attribute information of the newly added product in the attribute table; the attribute information includes an attribute ID and a verification attribute of an attribute value corresponding to the attribute ID, the attribute value represents an actual application value of the attribute, and the verification attribute is used to verify the standardization of the attribute value;

[0010] In response to the fifth operation instruction, a second associated content is established through the tariff attribute relationship table and a third associated content is established through the product attribute relationship table; the second associated content represents the association relationship between the attribute ID and the tariff ID, and the third associated content represents the association relationship between the product ID and the attribute ID.

[0011] Further, configuring the product value of the newly added product in the product type table includes:

[0012] Configure the type value of the newly added product in the product type table; the type value indicates that the newly added product belongs to a major product category;

[0013] Configuring a first value under the product category; the first value indicates that the newly added product belongs to a specific product category under the product category;

[0014] Configuring a second value under the specific product category; the second value represents the product type under the specific product category;

[0015] A third numerical value is configured under the product type; the third numerical value represents a product subcategory under the product type; the product value includes the type value, the first numerical value, the second numerical value and the third numerical value.

[0016] Further, configuring the product information of the newly added product in the product table includes:

[0017] Configure the product ID of the newly added product and the product name, business code, prepayment field, status field and product value corresponding to the product ID in the product table;

[0018] The prepayment field indicates whether the product requires prepayment, and the status field indicates the release status of the product.

[0019] Further, configuring the tariff information of the newly added product in the tariff table includes:

[0020] When the newly added product has a tariff, the tariff ID of the newly added product, the tariff name corresponding to the tariff ID, and the tariff type are configured in the tariff table; the tariff ID is the product ID, and the tariff name is the product name;

[0021] Alternatively, when the newly added product has at least two tariffs, the tariff ID corresponding to each tariff of the newly added product, the tariff name corresponding to each tariff and the tariff type are configured in the tariff table; different tariff IDs are determined by adding different preset values ​​to the product ID; the tariff information also includes the tariff name.

[0022] Furthermore, the establishing of the first associated content through the tariff product relationship table includes:

[0023] Generating a tariff product relationship ID as a primary key of the tariff product relationship table;

[0024] An association relationship between the product ID and each of the tariff IDs is established under the tariff product relationship ID.

[0025] Further, the establishing of the second associated content through the tariff attribute relationship table includes:

[0026] Generating a tariff attribute relationship ID as a primary key of the tariff attribute relationship table;

[0027] An association relationship between the attribute ID and each of the tariff IDs is established under the tariff attribute relationship ID.

[0028] Furthermore, the establishing of the third associated content through the product attribute relationship table includes:

[0029] Generate a product attribute relationship ID as a primary key of the product attribute relationship table;

[0030] An association relationship between the product ID and the attribute ID is established under the product attribute relationship ID.

[0031] Further, configuring the attribute information of the newly added product in the attribute table includes:

[0032] In the attribute table, configure the attribute ID of the newly added product as the primary key of the attribute table, and configure the inspection attribute, attribute type, attribute name, attribute specification operation type, attribute status and attribute default value corresponding to the attribute ID; the attribute type indicates that the inspection attribute, the attribute name, the attribute specification operation type, the attribute status and the attribute default value belong to the product attribute or the tariff attribute, the attribute default value is the initial value of the attribute value, the attribute specification operation type indicates the display form of the attribute information, and the attribute information also includes the attribute type, the attribute name, the attribute specification operation type, the attribute status and the attribute default value.

[0033] Furthermore, the method further comprises:

[0034] In response to the sixth operation instruction, a specific value range is configured in the attribute specification table; the specific value range is used to limit the size of the attribute value of a preset type.

[0035] The present invention also provides a product data structure configuration system, comprising:

[0036] A first configuration module, configured to configure a product value of a newly added product in the product type table in response to a first operation instruction; the product value represents different product categories;

[0037] A second configuration module, configured to configure product information of the newly added product in the product table in response to a second operation instruction, wherein the product information is associated with the product value and includes a product ID;

[0038] A third configuration module, configured to configure the tariff information of the newly added product in the tariff table and establish a first associated content through the tariff product relationship table in response to a third operation instruction; the tariff information includes a tariff ID and a tariff type corresponding to the tariff ID, and the first associated content represents an associated relationship between the product ID and the tariff ID;

[0039] A fourth configuration module, configured to configure the attribute information of the newly added product in the attribute table in response to a fourth operation instruction; the attribute information includes an attribute ID and a verification attribute of an attribute value corresponding to the attribute ID, the attribute value represents an actual application value of the attribute, and the verification attribute is used to verify the standardization of the attribute value;

[0040] The fifth configuration module is used to establish a second associated content through a tariff attribute relationship table and a third associated content through a product attribute relationship table in response to a fifth operation instruction; the second associated content represents the association relationship between the attribute ID and the tariff ID, and the third associated content represents the association relationship between the product ID and the attribute ID.

[0041] The present invention also provides a product data structure configuration device, comprising a processor and a memory;

[0042] The memory stores a program;

[0043] The processor executes the program to implement the product data structure configuration method.

[0044] The present invention also provides a computer-readable storage medium, wherein the storage medium stores a program, and when the program is executed by a processor, the product data structure configuration method is implemented.

[0045] The beneficial effects of the present invention are as follows: the present invention integrates a product data structure model by setting a product type table, a product table, a tariff table, a tariff-product relationship table, an attribute table, a tariff attribute relationship table, and a product attribute relationship table; configures the product value in the product type table and the product information in the product table, and associates the product value with the product information; configures the tariff information in the tariff table and the attribute information in the attribute table; and establishes a first associated content through the tariff-product relationship table, a second associated content through the tariff attribute relationship table, and a third associated content through the product attribute relationship table. Whether it is a product service with a single selling price or a product service with personalized tariffs, it can support both, thereby providing applicability and diversity. BRIEF DESCRIPTION OF THE DRAWINGS

[0046] Figure 1 A schematic diagram of the steps of the product data structure configuration method of the present invention;

[0047] Figure 2 It is a schematic diagram of the relationship between the tables of the specific embodiments of the present invention. DETAILED DESCRIPTION

[0048] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present application.

[0049] The terms "first", "second", "third" and "fourth" etc. in the specification and claims of the present application and the drawings are used to distinguish different objects, rather than to describe a specific order. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions. For example, a process, method, system, product or device that includes a series of steps or units is not limited to the listed steps or units, but optionally includes steps or units that are not listed, or optionally includes other steps or units inherent to these processes, methods, products or devices.

[0050] Reference to "embodiments" herein means that a particular feature, structure, or characteristic described in conjunction with the embodiments may be included in at least one embodiment of the present application. The appearance of the phrase in various locations in the specification does not necessarily refer to the same embodiment, nor is it an independent or alternative embodiment that is mutually exclusive with other embodiments. It is explicitly and implicitly understood by those skilled in the art that the embodiments described herein may be combined with other embodiments.

[0051] In the embodiment of the present invention, the standard tariff refers to a product tariff with a relatively simple and common charging logic, which is applicable to most products; the personalized tariff refers to a product tariff with a complex charging logic, which is only applicable to corresponding products.

[0052] like Figure 1 As shown, an embodiment of the present invention provides a product data structure configuration method, including steps S100-S500:

[0053] S100: In response to a first operation instruction, configure a product value of a newly added product in a product type table.

[0054] In an embodiment of the present invention, a product value is used to characterize different product categories, and the first operation instruction includes but is not limited to an operation instruction input through a mouse, a touchpad or a keyboard. It should be noted that the product type table can be pre-set and stored, and the editing of the content in the product type table is implemented in response to the first operation instruction, or the product type table can be a newly created type table, and the addition of the content of the newly created type table is implemented in response to the first operation instruction. The product type table is used to store the classification data of products and classify and divide the types of products, similar to a library's bookshelf catalog. The product categories of newly added products include but are not limited to product categories, product types, and product subcategories. Among them, the embodiment of the present application is described by taking the product type table as being pre-set and stored as an example. In an embodiment of the present invention, the product value includes but is not limited to the type value, the first numerical value, the second numerical value, the third numerical value, and each value or type_value of the product type table.

[0055] Optionally, configuring the product value of the newly added product in the product type table in step S100 includes steps S101-S104:

[0056] S101. Configure the type value of the newly added product in the product type table.

[0057] In the embodiment of the present invention, the type value indicates that the newly added product belongs to a product category. For example, if the product type table has 6 products, and the newly added product to be added at this time is a product category of multi-cloud products, the product type table after adding is shown in Table 1. It should be noted that the type value 0 indicates a product category, and the id in Table 1 can be automatically generated or also set in response to the first operation instruction.

[0058] Table 1

[0059]

[0060] S102. Configure the first value under the product category.

[0061] In an embodiment of the present invention, the first numerical value indicates that the newly added product belongs to a specific product category under the product category. For example, as shown in Table 1, after the type value of the newly added product is determined, the first numerical value of the newly added product can be automatically generated, or the first numerical value can be manually configured. From Table 1, it can be seen that the first numerical value indicates a specific product category under the product category or is called a category name, where the category name can be edited in response to the first operation instruction. In an embodiment of the present invention, Table 1 is a part of the product type table.

[0062] S103. Configure a second value under a specific product category.

[0063] In an embodiment of the present invention, the second numerical value represents the product type under a specific product category. For example, as shown in Table 2, it is a product type under a specific product category of multi-cloud products. It should be noted that the id in Table 2 can be automatically generated or also set in response to the first operation instruction. Among them, the product type includes but is not limited to the type and quantity in Table 2. When the product type of the newly added product has one or more, the second numerical value, product type name and id can be configured in Table 2 accordingly. In an embodiment of the present invention, Table 2 is also a part of the product type table.

[0064] Table 2

[0065]

[0066] S104. Configure a third value under the product type.

[0067] In an embodiment of the present invention, the third numerical value represents a product subcategory under the product type. As shown in Table 3, assuming that the product type of the newly added product is a basic service, and the product subcategory is a product subcategory under the basic service, the third numerical value is configured to represent the specific product subcategory under the basic service. It should be noted that the second numerical value can be the Value or type_value in Table 3, wherein the type_value is generated according to the Value in Table 3, the second numerical value in Table 2, and the third numerical value, specifically the Value+second numerical value+third numerical value in Table 3. It should be noted that the id in Table 3 can be automatically generated or also set in response to the first operation instruction; Table 3 is also a part of the product type table, and the number of subcategory names is not limited to Table 3. In an embodiment of the present invention, the product category is associated with the product type under the product category, the product subcategory under the product type, and the products under the product subcategory.

[0068] Table 3

[0069]

[0070]

[0071] S200: In response to the second operation instruction, configure product information of the newly added product in the product table.

[0072] Likewise, the second operation instruction includes but is not limited to an operation instruction inputted through a mouse, a touch pad or a keyboard.

[0073] It should be noted that the product table may be a part of the product type table, or the product type table may be a part of the product table.

[0074] Optionally, configuring product information of the newly added product in the product table in step S200 includes step S201:

[0075] S201. Configure the product ID of the newly added product in the product table and the product name, business code, prepayment field, status field and product value corresponding to the product ID.

[0076] In the embodiment of the present invention, the product table can be pre-set and stored, and the content in the product table can be edited in response to the second operation instruction, or the product table can be a newly created table, and the newly created table content can be added in response to the second operation instruction. The product table uses the product value or the ID corresponding to the product value as a foreign key to store the basic information of the product. It should be noted that the prepayment field represents whether the product requires prepayment, for example, the prepayment field "1" indicates that prepayment is required, and the prepayment field "0" indicates that prepayment is not required; the status field represents the release status of the product, for example, the status field "3" represents that the product status is on the shelf but not released, and "2" represents on the shelf release, and the default value of the general product configuration is "2". Among them, the product information is associated with the product value, and the product information includes but is not limited to the product ID, the product name corresponding to the product ID, the business code, the prepayment field, the status field, the product code, the creation time, the product value (for example, the first value, the second value, and the sub-category type value or Value (indicating the sub-category) in Table 3, etc.). It should be noted that the configuration in the embodiment of the present application can refer to automatic system configuration or manual configuration.

[0077] For example, in the above example, taking the newly added product belonging to the computing subcategory in the basic service as an example, in the product table, the product ID and product code are 800001, the name of the new product is "Cloud Host ECS-Annual and Monthly Package", the first value 1 (representing the product category), the business code 160000014 (different product categories have different codes, and you can pre-set '160000014' for multi-cloud), the Value "1" and the subcategory type value "118" in Table 3. It should be noted that the association between product information and product values ​​can use the product ID and product code as the primary key, and the product value or the id corresponding to the product value as the foreign key, and associate the product value with the product ID and product code to achieve the association between the product type table and the product table.

[0078] S300: In response to the third operation instruction, configure the tariff information of the newly added product in the tariff table and establish the first associated content through the tariff product relationship table.

[0079] Similarly, the third operation instruction includes but is not limited to an operation instruction input through a mouse, a touchpad or a keyboard. In an embodiment of the present invention, the tariff information includes a tariff ID and a tariff type corresponding to the tariff ID, and the first associated content represents the association between the product ID and the tariff ID. Specifically, the tariff table is used to store the tariff information corresponding to the product, such as the tariff type, the tariff name, the tariff billing method, etc.; the tariff product relationship table is used as an intermediate table to bind the relationship between the product and the tariff to form a one-to-many or many-to-many relationship. Similarly, the tariff table and the tariff product relationship table can be pre-set and stored, and the editing of the content in the table can be implemented in response to the third operation instruction, or the tariff table and the tariff product relationship table can be newly created tables, and the addition of the newly created table content can be implemented in response to the third operation instruction.

[0080] Optionally, configuring the tariff information of the newly added product in the tariff table in step S300 includes step S111 or S112:

[0081] In the embodiment of the present invention, the tariff information includes but is not limited to the tariff ID, the tariff name corresponding to the tariff ID, the tariff type and the configuration time. Optionally, the tariff type includes but is not limited to preset interval payment or one-time payment, for example, the preset interval is one month, which is the contract monthly rent.

[0082] S111. When a newly added product has a tariff, configure the tariff ID of the newly added product, the tariff name corresponding to the tariff ID, and the tariff type in the tariff table; the tariff ID is the product ID, and the tariff name is the product name.

[0083] Specifically, when a new product has a tariff, the tariff ID of the new product is configured in the tariff table, and the tariff ID can be a product ID, and the tariff name can be a product name. It should be noted that a tariff can refer to a content that needs to be paid and a corresponding tariff type.

[0084] S112. When the newly added product has at least two tariffs, configure the tariff ID corresponding to each tariff of the newly added product, the tariff name corresponding to each tariff, and the tariff type in the tariff table; different tariff IDs are determined by adding different preset values ​​to the product ID.

[0085] In an embodiment of the present invention, when a newly added product has at least two tariffs, that is, it has at least two items of content that need to be paid, and each item of content that needs to be paid corresponds to a tariff type. Specifically, the tariff ID corresponding to each tariff of the newly added product, the tariff name corresponding to each tariff, and the tariff type are configured in the tariff table. Optionally, different tariff IDs are determined by accumulating different preset values ​​by the product ID. For example, when the product ID is 800001, the preset values ​​can be set to 01, 02... 0N (N is greater than or equal to 1), that is, one of the tariff IDs is 80000101, and the other tariff ID is 80000102. Among them, the tariff ID can be used as the tariff name.

[0086] Optionally, in step S300, establishing the first associated content in the tariff table through the tariff product relationship table includes steps S121-S122:

[0087] S121. Generate a tariff product relationship ID as the primary key of the tariff product relationship table.

[0088] Specifically, the tariff product relationship ID may be generated automatically by the system or manually set, wherein the tariff product relationship ID serves as the primary key of the tariff product relationship table.

[0089] S122. Establish an association relationship between the product ID and each tariff ID under the tariff product relationship ID.

[0090] Specifically, an association relationship between the product ID and each tariff ID is established under the tariff product relationship ID. For example, if a newly added product has one tariff, that is, one tariff ID, then an association relationship between the product ID and each tariff ID is established under the tariff product relationship ID; if a newly added product has more than two tariffs, for example, three tariffs, that is, three tariff IDs, then an association relationship between the product ID and the three tariff IDs is established under the tariff product relationship ID. It should be noted that the tariff product relationship table has three fields, one field is the tariff product relationship ID, which is the primary key in the tariff product relationship table for unique identification, and the other two fields are the product ID and the tariff ID. The product ID is associated with the tariff ID, and the product ID in the table is associated with the product ID in the product table, and the tariff ID in the table is associated with the tariff ID in the tariff table, that is, the association between the tariff table and the product table is realized through the tariff product relationship table.

[0091] S400: In response to a fourth operation instruction, configure attribute information of the newly added product in the attribute table.

[0092] Similarly, the fourth operation instruction includes but is not limited to an operation instruction input through a mouse, touchpad or keyboard. Similarly, the attribute table can be pre-set and stored, and the editing of the content in the table can be implemented in response to the fourth operation instruction, or the attribute table can be a newly created table, and the addition of the newly created table content can be implemented in response to the fourth operation instruction. Among them, the attribute table is divided into tariff attributes and product attributes, which are used to store independent attribute information of products or tariffs, and are stored in the form of a vertical table. For example, the product description is a piece of data, and the tariff description is a piece of data, including some other special attributes are stored in the table; attributes can be reused for use scenarios such as page display or billing.

[0093] Optionally, step S400 includes step S401:

[0094] S401. Configure the attribute ID of the newly added product as the primary key of the attribute table in the attribute table, and configure the inspection attribute, attribute type, attribute name, attribute specification operation type, attribute status and attribute default value corresponding to the attribute ID.

[0095] Optionally, the attribute information includes, but is not limited to, the attribute ID, the inspection attribute of the attribute value corresponding to the attribute ID, the attribute type, the attribute code, the attribute name, the attribute specification operation type, the attribute state, the service classification, and the attribute default value. Among them, the attribute type indicates that the inspection attribute, the attribute name, the attribute specification operation type, the attribute state, and the attribute default value belong to the product attribute or the tariff attribute, the attribute default value is the initial value of the attribute value, the attribute specification operation type indicates the display form of the attribute information, the attribute value indicates the actual application value of the attribute, and the inspection attribute is used to inspect the standardization of the attribute value.

[0096] It should be noted that the attribute code can be the same as the attribute ID. The attribute type of "1" indicates the tariff attribute, and the attribute type of "0" indicates the product attribute. If it is a tariff attribute, it is associated with the tariff attribute relationship table, and if it is a product attribute, it is associated with the product attribute relationship table. In the embodiment of the present invention, the attribute specification operation type represents the display form of the attribute information. For example, the attribute specification operation type can be: 0: single selection in the drop-down box; 1: the text input box cannot be modified; 2: the text input box can be modified; 3: multiple selection; 4: textarea; 9: ordinary text; 10 time selection; 11: hidden value. For example, the attribute is a tariff attribute, and the attribute specification operation type is 0. When the user selects the tariff type, he can select a one-time payment or a preset interval payment through the drop-down box option. If the preset interval payment is made, a specific attribute value can also be entered, for example, the attribute value 1 represents 1 month, and the attribute value 2 represents 2 months. It should be noted that the attribute value refers to the actual application value of the attribute. For example, if the attribute is a quantity, then 100 quantities, this 100 is the attribute value; if the attribute is a remark, then the content in the remark is the attribute value). The attribute name represents the name corresponding to the attribute. For example, when it is related to the tariff type, the attribute name and can be the tariff type. When the attribute is a note of the attribute value, for example, when the preset interval payment or one-time payment in the tariff type is explained, the attribute name can be the tariff description. The attribute status is 1, which means that the attribute is valid, and 2 means that the attribute is invalid. In the embodiment of the present invention, the inspection attribute is used to check the standardization of the attribute value, that is, to check whether the attribute value meets the requirements, and to verify the attribute value. The verification function of the attribute value is to limit some illegal inputs when the user fills in the attribute value, such as quantity. The value filled in should be a number, and Chinese characters or punctuation marks cannot be filled in. The inspection attribute is stored in an array string, including but not limited to: [0: no check; 1: required; 2: non-negative number; 3: keep 2 decimal places; 4: string; 5: positive number; 6: 1~10; 7: amount, value needs to be *100; 8: positive integer; 9: discount value], for example: 1, 3 means that the attribute is required and the value with two decimal places is filled in. The inspection attribute can include one or more combinations. For example, when the inspection attribute includes 6 and 8, the user must fill in one of 1, 2, 3, 4, 5, 6, 7, 8, 9, and 10 when filling in the attribute value, otherwise the inspection fails and the valid attribute value cannot be determined. In addition, the attribute default value is the initial value of the attribute value, such as the attribute representing quantity. If the attribute default value is filled in with 1, the quantity is initially 1 when the user selects a product. If it is not filled in, the user needs to fill in the quantity of the purchased product himself or modify the attribute default value.

[0097] S500: In response to the fifth operation instruction, establish the second associated content through the tariff attribute relationship table and establish the third associated content through the product attribute relationship table.

[0098] Similarly, the fifth operation instruction includes but is not limited to an operation instruction input through a mouse, a touchpad or a keyboard. In an embodiment of the present invention, the second associated content represents the association relationship between the attribute ID and the tariff ID, and the third associated content represents the association relationship between the product ID and the attribute ID. It should be noted that the tariff attribute relationship table and the product attribute relationship table can be pre-set and stored, and the editing of the content in the table is realized in response to the fifth operation instruction, or the tariff attribute relationship table and the product attribute relationship table can be newly created tables, and the addition of the newly created type table content is realized in response to the fifth operation instruction. Among them, the product attribute relationship table is used as an intermediate table to bind the relationship between products and attributes to form a one-to-many or many-to-many relationship; a product can have multiple attributes, and one attribute can also be reused by multiple products to form a many-to-many relationship. The tariff attribute relationship table is used as an intermediate table to bind the relationship between tariffs and attributes to form a one-to-many or many-to-many relationship; a tariff can have multiple attributes, and one attribute can also be reused by multiple tariffs to form a many-to-many relationship.

[0099] Optionally, establishing the second associated content through the tariff attribute relationship table in step S500 includes steps S511-S512:

[0100] S511. Generate a tariff attribute relationship ID as the primary key of the tariff attribute relationship table.

[0101] Specifically, the tariff attribute relationship ID may be generated automatically by the system or manually set, wherein the tariff attribute relationship ID serves as the primary key of the tariff attribute relationship table.

[0102] S512: Establish an association relationship between the attribute ID and each tariff ID under the tariff attribute relationship ID.

[0103] Specifically, an association relationship between the attribute ID and each tariff ID is established under the tariff attribute relationship ID. For example, if the newly added product has one tariff, that is, one tariff ID, then an association relationship between the attribute ID and each tariff ID is established under the tariff attribute relationship ID; if the newly added product has more than two tariffs, for example, three tariffs, that is, three tariff IDs, then an association relationship between the attribute ID and the three tariff IDs is established under the tariff attribute relationship ID. It should be noted that the tariff attribute relationship table has three fields, one field is the tariff attribute relationship ID, which is the primary key in the tariff attribute relationship table as a unique identifier, and the other two fields are the tariff ID and the attribute ID, respectively. According to the primary key identifier, it is possible to know which tariff ID is associated with which attribute ID. Even if it is one-to-many or many-to-many, the corresponding relationship can be clearly known, and it is configured in an independent tariff attribute relationship table. The corresponding relationship is clear, which can maintain correctness and improve configuration efficiency.

[0104] Optionally, establishing the third associated content through the product attribute relationship table in step S500 includes steps S521-S522:

[0105] S521. Generate a product attribute relationship ID as the primary key of the product attribute relationship table.

[0106] Specifically, the product attribute relationship ID may be generated automatically by the system or manually set, wherein the product attribute relationship ID serves as the primary key of the product attribute relationship table.

[0107] S522. Establish an association relationship between the product ID and the attribute ID under the product attribute relationship ID.

[0108] Specifically, an association relationship between the product ID and the attribute ID is established under the product attribute relationship ID. For example, if a newly added product has multiple attributes, that is, multiple attribute IDs, then an association relationship between the product ID and the three attribute IDs is established under the product attribute relationship ID. It should be noted that the product attribute relationship table has three fields, one field is the product attribute relationship ID, which is the primary key in the product attribute relationship table for unique identification, and the other two fields are the attribute ID and the product ID. Based on the primary key identification, it is possible to know which product ID is associated with which attribute ID. Even if it is one-to-many or many-to-many, the corresponding relationship can be clearly known, and it is configured in an independent tariff attribute relationship table. The corresponding relationship is clear, which can maintain correctness and improve configuration efficiency.

[0109] Specifically, the product data structure configuration method further includes step S600:

[0110] S600: In response to a sixth operation instruction, configure a specific value range in the attribute specification table.

[0111] Similarly, the sixth operation instruction includes but is not limited to an operation instruction input through a mouse, a touchpad or a keyboard. In an embodiment of the present invention, a specific value range is used to limit the size of a preset type of attribute value. The attribute specification table can be pre-set and stored, and the editing of the content in the table is implemented in response to the sixth operation instruction. The attribute specification table can be a newly created table, and the addition of the newly created type table content is implemented in response to the sixth operation instruction. Among them, the attribute specification table can be an independent table, or it can be a subtable of the attribute table, which is used for special attributes and the attribute value group set for the attribute, and the specification information of the special attribute. The special attribute contains special sub-attributes, and the special sub-attributes are stored in the attribute specification table. For example, if the attribute of a product is the service period, the attribute value specification of the service period is that only the selected attribute value of the service period is from January to December, that is, the specific value range is from January to December, then January to December are stored in the attribute specification table, or when the attribute of the product includes a multiple-choice box, that is, the specific value range is the content in the multiple-choice box, then the content of the multiple-choice box (that is, the attribute value) is configured in the attribute specification table; preset types include but are not limited to multiple-choice boxes and attribute values ​​of service period, etc.

[0112] like Figure 2 As shown, it is a schematic diagram of the relationship between eight tables of an embodiment of the present invention, the product type table is associated with the product table, the product table is associated with the tariff table through the tariff product relationship table, the product table is associated with the attribute table through the product attribute relationship table, the attribute table is associated with the attribute specification table, and the attribute table is associated with the tariff table through the tariff attribute relationship table.

[0113] The product data structure configuration method of the embodiment of the present invention aims at the pain point that the structure of the existing method is relatively simple and cannot be integrated into a more complex transaction process. The product data structure configuration method of the embodiment of the present invention designs a total of 8 data structure tables, namely, product type table, product table, rate product relationship table, rate table, product attribute relationship table, rate attribute relationship table, attribute table, attribute specification table, which can well integrate the product data structure to form a universal product data structure model, which can support the listing of diverse product services in different application scenarios, from the simplest unit price × quantity products to complex tiered billing products, call volume billing products, call volume tiered billing products, etc. It should be noted that the product data structure model constructed and utilized by the product data structure configuration method of the embodiment of the present invention can be applied to the product model of the BOSS business support system, the mall platform, and the product business acceptance of the standard rate and personalized rate for the big data business and cloud computing business. The basic information of the product, the product rate information and the special attribute information of the product are configured through the product data structure model and then put on the shelf for sale.

[0114] The embodiment of the present invention further provides a product data structure configuration system, including:

[0115] A first configuration module is used to configure a product value of a newly added product in the product type table in response to a first operation instruction; the product value represents different product categories;

[0116] A second configuration module, configured to configure product information of a newly added product in the product table in response to a second operation instruction, wherein the product information is associated with a product value and includes a product ID;

[0117] A third configuration module, configured to configure the tariff information of the newly added product in the tariff table and establish a first associated content through the tariff product relationship table in response to the third operation instruction; the tariff information includes a tariff ID and a tariff type corresponding to the tariff ID, and the first associated content represents an associated relationship between the product ID and the tariff ID;

[0118] A fourth configuration module, configured to configure attribute information of the newly added product in the attribute table in response to a fourth operation instruction; the attribute information includes an attribute ID and a test attribute of an attribute value corresponding to the attribute ID, the attribute value represents an actual application value of the attribute, and the test attribute is used to test the standardization of the attribute value;

[0119] The fifth configuration module is used to respond to the fifth operation instruction to establish the second associated content through the tariff attribute relationship table and the third associated content through the product attribute relationship table; the second associated content represents the association relationship between the attribute ID and the tariff ID, and the third associated content represents the association relationship between the product ID and the attribute ID.

[0120] The contents of the above method embodiments are all applicable to the present system embodiments. The functions specifically implemented by the present system embodiments are the same as those of the above method embodiments, and the beneficial effects achieved are also the same as those achieved by the above method embodiments.

[0121] The embodiment of the present invention also provides a product data structure configuration device, the device comprising a processor and a memory;

[0122] The memory is used to store programs;

[0123] The processor is used to execute the program to implement the product data structure configuration method of the embodiment of the present invention. The device of the embodiment of the present invention can realize the function of product data structure configuration. The device can be any intelligent terminal including a mobile phone, a tablet computer, a computer, a personal digital assistant (PDA), a point of sales (POS), a car computer, etc.

[0124] The contents of the above method embodiments are all applicable to the present device embodiments. The functions specifically implemented by the present device embodiments are the same as those of the above method embodiments, and the beneficial effects achieved are also the same as those achieved by the above method embodiments.

[0125] An embodiment of the present invention further provides a computer-readable storage medium, which stores a program, and the program is executed by a processor to complete the product data structure configuration method as described in the aforementioned embodiment of the invention.

[0126] The embodiment of the present invention also provides a computer program product including instructions, which, when executed on a computer, enables the computer to execute the product data structure configuration method of the aforementioned embodiment of the invention.

[0127] The terms "first", "second", "third", "fourth", etc. (if any) in the specification of the present application and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchangeable where appropriate, so that the embodiments of the present application described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any of their variations are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device comprising a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0128] It should be understood that in the present application, "at least one (item)" means one or more, and "plurality" means two or more. "And / or" is used to describe the association relationship of associated objects, indicating that three relationships may exist. For example, "A and / or B" can mean: only A exists, only B exists, and A and B exist at the same time, where A and B can be singular or plural. The character " / " generally indicates that the objects associated before and after are in an "or" relationship. "At least one of the following" or similar expressions refers to any combination of these items, including any combination of single or plural items. For example, at least one of a, b or c can mean: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", where a, b, c can be single or multiple.

[0129] In the several embodiments provided in the present application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic, for example, the division of units is only a logical function division, and there may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point, the coupling or direct coupling or communication connection between each other shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms. The units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the scheme of this embodiment. In addition, each functional unit in each embodiment of the present application can be integrated in a processing unit, or each unit can exist physically separately, or two or more units can be integrated in one unit. The above-mentioned integrated unit can be implemented in the form of hardware or in the form of software functional units.

[0130] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application is essentially or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including multiple instructions to enable a computer device (which can be a personal computer, server, or network device, etc.) to execute all or part of the steps of each embodiment method of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (Read-Only Memory, referred to as ROM), random access memory (Random Access Memory, referred to as RAM), disk or optical disk and other media that can store programs.

[0131] The above embodiments are only used to illustrate the technical solutions of the present application, rather than to limit them. Although the present application has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or replace some of the technical features therein by equivalents. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present application.

Claims

1. A product data structure configuration method, characterized in that: include: In response to the first operation instruction, configuring a product value of the newly added product in the product type table; the product value represents different product categories; In response to the second operation instruction, configure the product information of the newly added product in the product table; the product information is associated with the product value, and the product information includes a product ID; In response to the third operation instruction, configuring the tariff information of the newly added product in the tariff table and establishing a first associated content through the tariff product relationship table; the tariff information includes a tariff ID and a tariff type corresponding to the tariff ID, and the first associated content represents an associated relationship between the product ID and the tariff ID; In response to the fourth operation instruction, configuring the attribute information of the newly added product in the attribute table; The attribute information includes an attribute ID and a verification attribute of an attribute value corresponding to the attribute ID, wherein the attribute value represents an actual application value of the attribute, and the verification attribute is used to verify the standardization of the attribute value; In response to the fifth operation instruction, a second associated content is established through the tariff attribute relationship table and a third associated content is established through the product attribute relationship table; wherein the establishment of the third associated content through the product attribute relationship table includes: generating a product attribute relationship ID as a primary key of the product attribute relationship table; establishing an associated relationship between the product ID and the attribute ID under the product attribute relationship ID; the second associated content represents the associated relationship between the attribute ID and the tariff ID, and the third associated content represents the associated relationship between the product ID and the attribute ID; The product type table is associated with the product table, the product table is associated with the tariff table through the tariff product relationship table, the product table is associated with the attribute table through the product attribute relationship table, the product attribute relationship table is used to bind the relationship between the product and the attribute, the attribute table is associated with the attribute specification table, and the attribute table is associated with the tariff table through the tariff attribute relationship table; The method further includes: in response to a sixth operation instruction, configuring a specific value range in the attribute specification table; the specific value range is used to limit the size of the attribute value of a preset type.

2. The product data structure configuration method according to claim 1, characterized in that: The configuration of the product value of the newly added product in the product type table includes: Configure the type value of the newly added product in the product type table; the type value indicates that the newly added product belongs to a major product category; Configuring a first value under the product category; the first value indicates that the newly added product belongs to a specific product category under the product category; Configuring a second value under the specific product category; the second value represents the product type under the specific product category; A third numerical value is configured under the product type; the third numerical value represents a product subcategory under the product type; the product value includes the type value, the first numerical value, the second numerical value and the third numerical value.

3. The product data structure configuration method according to claim 1, characterized in that: The configuring the product information of the newly added product in the product table includes: Configure the product ID of the newly added product and the product name, business code, prepayment field, status field and product value corresponding to the product ID in the product table; The prepayment field indicates whether the product requires prepayment, and the status field indicates the release status of the product.

4. The product data structure configuration method according to claim 1, characterized in that: The configuring the tariff information of the newly added product in the tariff table includes: When the newly added product has a tariff, the tariff ID of the newly added product, the tariff name corresponding to the tariff ID, and the tariff type are configured in the tariff table; the tariff ID is the product ID, and the tariff name is the product name; Alternatively, when the newly added product has at least two tariffs, the tariff ID corresponding to each tariff of the newly added product, the tariff name corresponding to each tariff and the tariff type are configured in the tariff table; different tariff IDs are determined by adding different preset values ​​to the product ID; the tariff information also includes the tariff name.

5. The product data structure configuration method according to claim 4, characterized in that: The establishing of the first associated content through the tariff product relationship table includes: Generating a tariff product relationship ID as a primary key of the tariff product relationship table; An association relationship between the product ID and each of the tariff IDs is established under the tariff product relationship ID.

6. The product data structure configuration method according to claim 4, characterized in that: The establishing of the second associated content through the tariff attribute relationship table includes: Generating a tariff attribute relationship ID as a primary key of the tariff attribute relationship table; An association relationship between the attribute ID and each of the tariff IDs is established under the tariff attribute relationship ID.

7. The product data structure configuration method according to claim 1, characterized in that: Configuring the attribute information of the newly added product in the attribute table includes: In the attribute table, configure the attribute ID of the newly added product as the primary key of the attribute table, and configure the inspection attribute, attribute type, attribute name, attribute specification operation type, attribute status and attribute default value corresponding to the attribute ID; the attribute type indicates that the inspection attribute, the attribute name, the attribute specification operation type, the attribute status and the attribute default value belong to the product attribute or the tariff attribute, the attribute default value is the initial value of the attribute value, the attribute specification operation type indicates the display form of the attribute information, and the attribute information also includes the attribute type, the attribute name, the attribute specification operation type, the attribute status and the attribute default value.

8. A product data structure configuration system, characterized in that: include: A first configuration module, configured to configure a product value of a newly added product in the product type table in response to a first operation instruction; The product values ​​represent different product categories; A second configuration module, configured to configure product information of the newly added product in the product table in response to a second operation instruction, wherein the product information is associated with the product value and includes a product ID; A third configuration module, configured to configure the tariff information of the newly added product in the tariff table and establish a first associated content through the tariff product relationship table in response to a third operation instruction; the tariff information includes a tariff ID and a tariff type corresponding to the tariff ID, and the first associated content represents an associated relationship between the product ID and the tariff ID; A fourth configuration module, configured to configure the attribute information of the newly added product in the attribute table in response to a fourth operation instruction; the attribute information includes an attribute ID and a verification attribute of an attribute value corresponding to the attribute ID, the attribute value represents an actual application value of the attribute, and the verification attribute is used to verify the standardization of the attribute value; A fifth configuration module, configured to establish, in response to a fifth operation instruction, a second associated content through a tariff attribute relationship table and a third associated content through a product attribute relationship table; wherein the establishment of the third associated content through the product attribute relationship table comprises: generating a product attribute relationship ID as a primary key of the product attribute relationship table; establishing an associated relationship between the product ID and the attribute ID under the product attribute relationship ID; the second associated content represents an associated relationship between the attribute ID and the tariff ID, and the third associated content represents an associated relationship between the product ID and the attribute ID; The product type table is associated with the product table, the product table is associated with the tariff table through the tariff product relationship table, the product table is associated with the attribute table through the product attribute relationship table, the product attribute relationship table is used to bind the relationship between the product and the attribute, the attribute table is associated with the attribute specification table, and the attribute table is associated with the tariff table through the tariff attribute relationship table; The system is further used to: configure a specific value range in the attribute specification table in response to a sixth operation instruction; the specific value range is used to limit the size of the attribute value of a preset type.

Images