CN113434510A - General commodity information model and commodity information storage method - Google Patents
General commodity information model and commodity information storage method Download PDFInfo
- Publication number
- CN113434510A CN113434510A CN202110750738.XA CN202110750738A CN113434510A CN 113434510 A CN113434510 A CN 113434510A CN 202110750738 A CN202110750738 A CN 202110750738A CN 113434510 A CN113434510 A CN 113434510A
- Authority
- CN
- China
- Prior art keywords
- commodity
- attribute
- template
- common
- information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 53
- 238000004590 computer program Methods 0.000 claims description 10
- 230000003993 interaction Effects 0.000 claims description 10
- 230000000875 corresponding effect Effects 0.000 description 40
- 238000010586 diagram Methods 0.000 description 7
- 238000004891 communication Methods 0.000 description 5
- 230000008569 process Effects 0.000 description 4
- 238000000605 extraction Methods 0.000 description 3
- 241000531116 Blitum bonus-henricus Species 0.000 description 2
- 235000008645 Chenopodium bonus henricus Nutrition 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000008859 change Effects 0.000 description 1
- 230000002596 correlated effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0633—Lists, e.g. purchase orders, compilation or processing
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a general commodity information model and a commodity information storage method. The method comprises the following steps: establishing a plurality of data tables which are mutually related in a database according to the common attribute template and the commodity attribute template; wherein the common attribute template records common attribute information of all commodities; the commodity attribute template corresponding to each commodity type in the common attribute information records the unique attribute information of the commodity type; the method comprises the steps of obtaining information of a target commodity, wherein the information comprises common attribute information and unique attribute information, storing the common attribute information into a plurality of created first data tables, wherein the first data tables comprise the common attribute information recorded by a common attribute template, and storing the unique attribute information into a plurality of created second data tables, and the second data tables comprise the unique attribute information recorded by a commodity attribute template. The invention can improve the flexibility of commodity information operation in the electronic commerce system and can play a good role in supporting business innovation and evolution of the electronic commerce system.
Description
Technical Field
The invention relates to the field of electronic commerce, in particular to a universal commodity information model and a commodity information storage method.
Background
In the electronic commerce system, the information of the commodities is of great importance, which is the core of the whole electronic commerce system and is the basis for generating all business data of the electronic commerce system. Most electronic commerce systems cannot flexibly operate commodity information, for example, add, extract, retrieve and the like on the commodity information, so that the development of business innovation and evolution of the electronic commerce systems on price dimension, quality dimension, service dimension and the like before, during and after commodity sale is restricted.
Disclosure of Invention
The invention provides a general commodity information model and a commodity information storage method, which are used for overcoming the defect that an electronic commerce system cannot flexibly operate commodity information and improving the flexibility of commodity information operation in the electronic commerce system, thereby playing a good role in supporting business innovation and evolution of the electronic commerce system.
In a first aspect, the present invention provides a method for storing commodity information, including:
establishing a plurality of data tables which are mutually related in a database according to the common attribute template and the commodity attribute template; the common attribute template records common attribute information of all commodities; the commodity attribute template corresponding to each commodity type in the common attribute information records the unique attribute information of the commodity type;
the method comprises the steps of obtaining information of a target commodity, wherein the information of the target commodity comprises common attribute information and specific attribute information, storing the common attribute information of the target commodity into a plurality of created first data tables, wherein the first data tables comprise the common attribute information recorded by a common attribute template, and storing the specific attribute information of the target commodity into a plurality of created second data tables, and the second data tables comprise the specific attribute information recorded by a commodity attribute template.
According to a commodity information storage method provided by the present invention, the common attribute information further includes: the commodity name, the commodity identifier, the name of the common attribute, the type of the common attribute, the identifier of the common attribute and the commodity attribute value of the common attribute, and the unique attribute information includes: the name of the unique attribute, the type of the unique attribute, the identifier of the unique attribute and the commodity attribute value of the unique attribute, wherein a plurality of data tables which are mutually associated are created in the database, and the data tables comprise:
creating a commodity attribute template table for recording names of commodity attribute templates corresponding to commodity types in a database;
creating a commodity template attribute table for recording identifiers of unique attributes of commodity attribute templates in a database, setting names of corresponding commodity attribute templates for the identifiers of the unique attributes in the commodity template attribute table, and enabling the commodity template attribute table to be connected with the commodity attribute template table through the names of the commodity attribute templates;
establishing a commodity table for recording commodity names in a database, wherein according to the commodity type of a commodity corresponding to the commodity name, connection is established between the commodity name in the commodity table and a commodity attribute template table corresponding to the commodity attribute template table name through a commodity attribute template table name corresponding to the commodity type;
establishing a commodity attribute table for recording names of common attributes, types of the common attributes, identifiers of the common attributes, names of unique attributes, types of the unique attributes and identifiers of the unique attributes in a database, setting common attribute flag bits for common attribute information in the commodity attribute table, and setting unique attribute flag bits for unique attribute information in the commodity attribute table;
aiming at the type of each commodity attribute value, a commodity attribute value table for recording the type of the commodity attribute value is established in a database, identifiers of corresponding commodities are respectively set for the commodity attribute values in each commodity attribute value table, identifiers of common attributes are set for the commodity attribute values of the common attributes in the commodity attribute value table, identifiers of unique attributes are set for the commodity attribute values of the unique attributes in the commodity attribute value table, each commodity attribute value table is connected with the commodity attribute table through the identifiers of the common attributes or the identifiers of the unique attributes, and the connection is established with the commodity table through the identifiers of the commodities.
According to a product information storage method provided by the present invention, the storing common attribute information of the target product in a plurality of first data tables created, the first data tables including common attribute information recorded in the common attribute template, and storing specific attribute information of the target product in a plurality of second data tables created, the second data tables including specific attribute information recorded in the product attribute template, includes:
storing the name of a commodity attribute template corresponding to the commodity type of the target commodity into the commodity attribute template table;
storing the identifier of the unique attribute of the target commodity in the commodity template attribute table;
storing the commodity name and the identifier of the target commodity in the commodity table;
storing the name of the common attribute, the type of the common attribute and the identifier of the common attribute of the target commodity, and the name of the unique attribute, the type of the unique attribute and the identifier of the unique attribute into the commodity attribute table;
and respectively storing the commodity attribute values of the common attributes and the commodity attribute values of the specific attributes of the target commodities into the corresponding commodity attribute value tables.
According to a commodity information storage method provided by the present invention, the type of the commodity attribute value includes at least one of the following: text type, number type, single-selection drop-down menu type, multiple-selection drop-down menu type and commodity detail type.
According to the commodity information storage method provided by the invention, the type of the common attribute comprises a basic attribute and a brand attribute; the types of unique attributes include marketing attributes, service attributes, and interaction attributes.
According to the commodity information storage method provided by the invention, the method further comprises an extended service template for recording commodity extended services, and the method further comprises the following steps:
establishing a commodity expansion service table in a database according to the expansion service template, setting a corresponding commodity identifier for the commodity expansion service in the commodity expansion service table, and enabling the commodity expansion service table to be connected with the commodity table through the commodity identifier;
and acquiring the identifier of the target commodity and storing the identifier into the created commodity expansion service table.
In a second aspect, the present invention further provides a general merchandise information model, including:
the common attribute template is constructed on the basis of a plurality of data tables which are established in a database and are mutually associated, and is used for recording common attribute information of all commodities;
and the commodity attribute template is constructed on the basis of a plurality of data tables which are established in the database and are mutually associated, corresponds to each commodity type respectively, and is used for recording the unique attribute information of each commodity type.
The general commodity information model provided by the invention further comprises:
and the extended service template is constructed based on a plurality of data tables which are established in a database and are mutually associated, and is used for recording the extended service information of the commodity.
In a third aspect, the present invention further provides an electronic device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the merchandise information storage method according to any one of the above methods when executing the computer program.
In a fourth aspect, the present invention also provides a non-transitory computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, realizes the steps of the merchandise information storage method according to any one of the above.
The invention provides a general commodity information model and a commodity information storage method.A plurality of data tables which are mutually associated are established in a database according to a common attribute template and a commodity attribute template; the common attribute template records common attribute information of all commodities; the commodity attribute template corresponding to each commodity type in the common attribute information records the unique attribute information of the commodity type; acquiring information of a target commodity, wherein the information of the target commodity comprises common attribute information and unique attribute information, storing the common attribute information of the target commodity into a plurality of created first data tables, wherein the first data tables comprise the common attribute information recorded by the common attribute template, and storing the unique attribute information of the target commodity into a plurality of created second data tables, and the second data tables comprise the unique attribute information recorded by the commodity attribute template; by reasonably splitting the commodity attributes, constructing a common attribute template for storing common attribute information of commodities and a commodity attribute template for storing unique attribute information of the commodity types by using the database, the addition of new commodity types, new commodities and new commodity attributes, the retrieval and extraction of stored commodity information and other operations are facilitated, the flexibility of commodity information operation in an electronic commerce system can be improved, and therefore a good support effect on business innovation and evolution of the electronic commerce system can be achieved.
Drawings
In order to more clearly illustrate the technical solutions of the present invention or the prior art, the drawings needed for the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and those skilled in the art can also obtain other drawings according to the drawings without creative efforts.
FIG. 1 is a schematic diagram of a structure of a general merchandise information model provided by the present invention;
FIG. 2 is a schematic diagram of a structure of a general merchandise information model applied to an electronic mall;
FIG. 3 is a flow chart illustrating a method for storing merchandise information according to the present invention;
FIG. 4 is a flow chart illustrating the creation of a plurality of data tables associated with each other in a database according to the present invention;
FIG. 5 is a schematic diagram of a plurality of data tables created in a database provided by the present invention;
FIG. 6 is a schematic flow chart of storing common attribute information and unique attribute information of a target product into a plurality of data tables according to the present invention;
fig. 7 is a schematic structural diagram of an electronic device provided by the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention clearer, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings, and it is obvious that the described embodiments are some, but not all embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The general commodity information model and the commodity information storage method of the present invention will be described below with reference to fig. 1 to 5.
Referring to fig. 1, fig. 1 is a schematic structural diagram of a general product information model provided by the present invention, and as shown in fig. 1, the general product information model 100 may include a common attribute template 110 and a product attribute template 120, where the common attribute template 110 is used to record common attribute information of all products, the product attribute template 120 corresponds to each product type and is used to record unique attribute information of each product type, and the common attribute template 110 and the product attribute template 120 are used to create a plurality of data table structures associated with each other in a database.
Optionally, the information of the massive commodities is collected, processed by deduplication and the like, and the processed information of the commodities is classified into common attribute information and specific attribute information according to a preset attribute classification strategy, where the common attribute information of the commodities may include names of common attributes, types of the common attributes, commodity attribute values of the common attributes, and the like. Wherein the type of the common attribute may include basic attributes, such as a commodity type, a commodity name, a brand of the commodity, and the like; in the case of brand management, the types of common attributes may also include brand attributes, such as the name of the brand, the LOGO of the brand, the official network of the brand, the story of the brand, etc.; the embodiment of the invention does not limit the types of the common attributes of the commodities.
Alternatively, the unique attribute information of the article may include a name of the unique attribute, a type of the unique attribute, an article attribute value of the unique attribute, and the like. The type of the specific attribute may include at least one of marketing attribute, service attribute, interaction attribute, and the like; for example, the marketing attribute may include hot selling of the product, clearing of the product, and the like, the service attribute may include a warranty period of the product, a change time of the product, and the like, and the interaction attribute may include an agent of the product, a factory address of the product, and the like. Taking the commodity type as a household appliance and the household appliance as an air conditioner as an example, the type of the specific attribute is a service attribute, the name of the specific attribute is the warranty period of the commodity, and the commodity attribute value of the specific attribute is 1 year.
Optionally, the general merchandise information model 100 may further include: the extended service template is used for recording extended service information of the commodity, is constructed based on a plurality of data tables which are established in a database and are mutually associated, and can be properly set according to actual service requirements during actual application. Optionally, the extended service information of the goods may include a label of the goods, a specification of the goods, a style of the goods, a place of origin of the goods, and the like, for example, the label of the goods may include a label of a single goods, a label of a group of goods, and the like, and the specification of the goods may include a unit of a single goods, a unit of a group of goods, and the like, and the type of the extended service information of the goods is not limited in the embodiment of the present invention.
Referring to fig. 2, fig. 2 is a schematic diagram of a composition structure of a general merchandise information model applied to an electronic mall, and as shown in fig. 2, the general merchandise information model applied to an electronic mall provided by the present invention obtains a general merchandise information model 200, which includes: the system comprises a common attribute template 210 for recording common attribute information of all goods in the electronic mall, and goods attribute templates, namely a home appliance attribute template 220, a clothing attribute template 230 and a car attribute template 240, which are respectively corresponding to the goods types, namely home appliances, clothing and cars in the electronic mall and are used for recording unique attribute information of each goods type.
The common attribute template 210 includes basic attributes 211 and brand attributes 212 of the goods, and the common attribute information of the goods in the common attribute template 210 may be preset, or may also be determined from attribute information that all goods types in the electronic mall have in common according to a preset condition.
The home appliance attribute template 220 includes: marketing attributes 221, service attributes 222, and interaction attributes 223 of the home appliance; the clothing attribute template 230 includes: marketing attributes 231, service attributes 232, and interaction attributes 233 of the garment; the car property template 240 includes: marketing attributes 241, service attributes 242, and interaction attributes 243 of the car. The marketing attribute 221, the service attribute 222 and the interaction attribute 223 in the appliance attribute template 220 may be determined according to attribute information of all appliances in the electronic mall; the marketing attribute 231, the service attribute 232 and the interaction attribute 233 in the clothing attribute template information 230 can be determined according to the attribute information of all the clothing in the electronic mall; the marketing attribute 241, the service attribute 242, and the interaction attribute 243 in the car attribute template 240 may be determined according to the attribute information of all cars in the electronic mall.
In practical application, the commodity attribute information in the common attribute template 210, the home appliance attribute template 220, the clothing attribute template 230 and the automobile attribute template 230 can be added or deleted at any time according to requirements.
As shown in fig. 2, in the general product information model 200, an extended service template may be set for each product specification and each product label, and the product specification information and the product label information may be recorded in the extended service template. The business management such as the classification of commodities in the electronic mall, brand management, marketing channel management, price management and the like can be realized through the commodity information recorded in the general commodity information model 200.
Referring to fig. 3, fig. 3 is a schematic flow chart of a method for storing commodity information according to the present invention, in which the method for storing commodity information is implemented by using a general commodity information model 100, and as shown in fig. 3, the method for storing commodity information at least includes:
301, creating a plurality of data tables which are related to each other in a database according to the common attribute template and the commodity attribute template; wherein, the common attribute template records the common attribute information of all commodities; and recording the unique attribute information of each commodity type by the commodity attribute template corresponding to each commodity type in the common attribute information.
In the embodiment of the present invention, the general commodity information model 100 may be implemented by creating a plurality of data tables associated with each other in a database by using the storage and management capability of the database for data, for example, the general commodity information model 100 may be constructed by using a relational database, and the type of the database for implementing the general commodity information model 100 is not limited in the embodiment of the present invention.
And 302, acquiring information of the target commodity, wherein the information of the target commodity comprises common attribute information and unique attribute information, storing the common attribute information of the target commodity into a plurality of created first data tables, the first data tables comprise the common attribute information recorded by the common attribute template, and storing the unique attribute information of the target commodity into a plurality of created second data tables, and the second data tables comprise the unique attribute information recorded by the commodity attribute template.
In the embodiment of the present invention, after the data table is created in the database to construct the general commodity information model 100, the information of the target commodity may be acquired, and the information of the target commodity is stored in the data table created in the database, so that the commodity information is stored in the general commodity information model 100, for example, the general commodity information model 100 may be applied to a certain electronic mall, and the target commodity may be a certain commodity in the electronic mall. The common attribute information of the target commodity is stored in a plurality of first data tables created in a database, so that the common attribute information of the target commodity is added into a common attribute template, the specific attribute information of the target commodity is stored in a plurality of second data tables created in the database, and the specific attribute information of the target commodity is added into a corresponding commodity attribute template.
The commodity information storage method provided by the invention comprises the steps of establishing a plurality of data tables which are mutually associated in a database according to a common attribute template and a commodity attribute template; the common attribute template records common attribute information of all commodities; the commodity attribute template corresponding to each commodity type in the common attribute information records the unique attribute information of the commodity type; acquiring information of a target commodity, wherein the information of the target commodity comprises common attribute information and unique attribute information, storing the common attribute information of the target commodity into a plurality of created first data tables, wherein the first data tables comprise the common attribute information recorded by the common attribute template, and storing the unique attribute information of the target commodity into a plurality of created second data tables, and the second data tables comprise the unique attribute information recorded by the commodity attribute template; by reasonably splitting the commodity attributes, constructing a common attribute template for storing common attribute information of commodities and a commodity attribute template for storing unique attribute information of the commodity types by using the database, the addition of new commodity types, new commodities and new commodity attributes, the retrieval and extraction of stored commodity information and other operations are facilitated, the flexibility of commodity information operation in an electronic commerce system can be improved, and therefore a good support effect on business innovation and evolution of the electronic commerce system can be achieved.
Referring to fig. 4, fig. 4 is a schematic flow chart illustrating a process of creating a plurality of data tables associated with each other in a database according to the present invention, as shown in fig. 4, in this embodiment, the common attribute information includes: the commodity name, the commodity identifier, the name of the common attribute, the type of the common attribute, the identifier of the common attribute and the commodity attribute value of the common attribute, and the unique attribute information includes: the name of the unique attribute, the type of the unique attribute, the identifier of the unique attribute, and the product attribute value of the unique attribute. Creating a plurality of data tables in a database, wherein the data tables are correlated with each other, and the data tables at least comprise:
401, a product attribute template table for recording names of product attribute templates corresponding to product types is created in a database.
In some optional examples, the general product information model 100 is constructed by using a relational database for a certain electronic mall, and a product attribute template table may be created in the database according to all product types in the electronic mall, and names of product attribute templates respectively corresponding to the product types in the electronic mall are recorded in the created product attribute template table. For example, as shown in fig. 5, the created product attribute template table is pms _ eav _ attribute _ set, and names of the product attribute templates in the product attribute template table are a home appliance attribute template, a clothing attribute template, a car attribute template, and the like.
402, creating a product template attribute table for recording identifiers of unique attributes of the product attribute template in the database, setting names of corresponding product attribute templates for the identifiers of the unique attributes in the product template attribute table, and enabling the product template attribute table to be connected with the product attribute template table through the names of the product attribute templates.
In some optional examples, still taking an example that a certain electronic mall uses a relational database to construct the general commodity information model 100, an article template attribute table may be created in the database according to all unique attributes of each commodity type in the electronic mall, identifiers of all unique attributes in each commodity attribute template in the electronic mall are recorded in the created commodity template attribute table, and the unique attributes in the commodity template attribute table may establish connection with corresponding commodity attribute templates in the commodity attribute template table through names of the commodity attribute templates. For example, as shown in fig. 5, the created commodity template attribute table is pms _ eav _ entry _ attribute, and the warranty period of the home appliance in the commodity template attribute table is connected to the home appliance attribute template corresponding to the commodity attribute template table by the name of the home appliance attribute template.
And 403, creating a commodity table for recording commodity names and identifiers of commodities in the database, setting names of corresponding commodity attribute templates for the commodity names in the commodity table, and enabling the commodity table to be connected with the commodity attribute template table through the names of the commodity attribute templates.
In some optional examples, still taking an example that a certain electronic mall utilizes a relational database to construct the general commodity information model 100, a commodity table may be created in the database according to all commodities in the electronic mall, all commodity names and identifiers under each commodity type in the electronic mall are recorded in the created commodity table, in the case that the commodity names are the same, the commodity is uniquely identified by the identifier of the commodity, and the commodities in the commodity table may establish a connection with a corresponding commodity attribute template in the commodity attribute template table through the name of the commodity attribute template. For example, as shown in fig. 5, the created product table is pms _ product _ entry, and a certain garment in the product table may establish a connection with a corresponding garment attribute template in the product attribute template table by the name of the garment attribute template.
404, creating a product attribute table for recording the name of the common attribute, the type of the common attribute, the identifier of the common attribute, the name of the unique attribute, the type of the unique attribute, and the identifier of the unique attribute in the database, setting a common attribute flag bit for the common attribute information in the product attribute table, and setting a unique attribute flag bit for the unique attribute information in the product attribute table.
In some optional examples, still taking the example that a certain electronic mall uses a relational database to construct the general merchandise information model 100, an article attribute table may be created in the database according to all the merchandise attributes in the electronic mall, names, types and identifiers of the merchandise attributes of all the merchandise in the electronic mall are recorded in the created article attribute table, wherein the article attributes include common attributes of the merchandise and unique attributes of the article type, and each merchandise attribute in the article attribute table may be set with a flag, and the flag may be used to distinguish whether the article attribute is a common attribute or a unique attribute. For example, as shown in fig. 5, the created product attribute table is pms _ eav _ attribute, and the flag bit set for each product attribute in the product attribute table is _ common.
405, for each type of the product attribute value, creating a product attribute value table for recording the type of the product attribute value in the database, setting identifiers of corresponding products for the product attribute values in each product attribute value table, setting identifiers of common attributes for the product attribute values of common attributes in the product attribute value table, setting identifiers of unique attributes for the product attribute values of unique attributes in the product attribute value table, enabling each product attribute value table to be connected with the product attribute table through the identifiers of the common attributes or the identifiers of the unique attributes, and establishing connection with the product table through the identifiers of the products.
In some optional examples, still taking an example that a certain electronic mall utilizes a relational database to construct the general commodity information model 100, a commodity attribute value table corresponding to the type of each commodity attribute value may be respectively created in the database according to the types of all commodity attribute values in the electronic mall, commodity attribute values corresponding to the types of each commodity attribute value in the electronic mall are respectively recorded in each created commodity attribute value table, and the commodity attribute values in each commodity attribute value table may be connected to the corresponding commodity attributes in the commodity attribute table through identifiers of the commodity attributes, and may be connected to the corresponding commodities in the commodity table through the identifiers of the commodities. Optionally, the type of the article attribute value includes at least one of a text type, a number type, a single-selection drop-down menu type, a multiple-selection drop-down menu type, an article detail type, and the like. For example, as shown in fig. 5, the created text type value table is pms _ product _ entry _ varchar, the created number type value table is pms _ product _ entry _ int, the created single drop menu type value table is pms _ eav _ attribute _ option, and the created product detail type value table is pms _ product _ entry _ text. When the information of the commodity is stored in the created data table, the commodity attribute values are stored in the corresponding commodity attribute value table according to the types of the attribute values, for example, the commodity attribute values of the text type can be saved in pms _ product _ entry _ varchar, and the commodity attribute values of the digital type can be saved in pms _ product _ entry _ int, and for the special commodity attribute values of the pull-up menu type, it is necessary to record the contents of the pull-down menu not only in pms _ eav _ attribute _ option, but also add which pull-down menu is selected in pms _ product _ entry _ varchar, and when the commodity detail contents are more, the pull-down menu is saved in pms _ product _ entry _ text.
In the embodiment, a general commodity information model is realized by creating a commodity attribute template table, a commodity template attribute table, a commodity attribute table and a commodity attribute value which are associated with each other in a database by using a relational database, and operations such as adding a new commodity type, a new commodity and a new commodity attribute, retrieving and extracting stored commodity information and the like can be realized by using the storage and management capacity of the database on data.
Referring to fig. 6, fig. 6 is a schematic flow chart illustrating a process of storing common attribute information and unique attribute information of a target product into a plurality of data tables according to the present invention, and as shown in fig. 6, the process of storing the common attribute information of the target product into a plurality of created first data tables, where the first data tables include the common attribute information recorded by the common attribute template, and the process of storing the unique attribute information of the target product into a plurality of created second data tables, where the second data tables include the unique attribute information recorded by the product attribute template, and at least includes:
601, storing the name of the product attribute template corresponding to the product type of the target product into a product attribute template table.
An identifier of a unique attribute of the target product is stored 602 in the product template attribute table.
603, store the commodity name and the identifier of the target commodity in the commodity table.
604, the name of the common attribute, the type of the common attribute, and the identifier of the common attribute, and the name of the unique attribute, the type of the unique attribute, and the identifier of the unique attribute of the target commodity are stored in a commodity attribute table.
605 store the product attribute value of the common attribute and the product attribute value of the unique attribute of the target product in the corresponding product attribute value tables, respectively.
In the embodiment of the present invention, the first data table may include a product table, a product attribute table, and a product attribute value table, and the second data table may include a product attribute template table, a product template attribute table, a product attribute table, and a product attribute value table. The description of 601, 602, 603, 604 can refer to the description of 401, 402, 403, 404, 405 in fig. 4, and will not be repeated here.
Still taking an example that a certain electronic mall builds the universal commodity information model 100 by creating a plurality of data tables associated with each other by using a relational database, when information of a target commodity is stored in the created plurality of data tables, if a commodity type to which the target commodity belongs is an existing type, that is, the target commodity is not a first commodity of the commodity type, a name of a corresponding commodity attribute template already exists in the commodity attribute template table, at this time, when the information of the target commodity is stored in the created plurality of data tables, the operation of 601 is not required to be executed; if the commodity type to which the target commodity belongs is not the existing type, that is, the target commodity is the first commodity of the commodity type, the name of the corresponding commodity attribute template does not exist in the commodity attribute template table, and at this time, when the information of the target commodity is stored in the created plurality of data tables, the operation of 601 does not need to be executed.
In some optional implementation manners, the general commodity information model may further include an extended service template for recording commodity extended services, the commodity information storage method may further create a commodity extended service table in the database according to the extended service template, set an identifier of a corresponding commodity for the commodity extended services in the commodity extended service table, and enable the commodity extended service table to establish connection with the corresponding commodity in the commodity table through the identifier of the commodity; and acquiring the identifier of the target commodity and storing the identifier into the created commodity expansion service table.
After the common attribute information and the unique attribute information of the target product are recorded in the common attribute template and the product attribute template of the general product information model by storing the common attribute information and the unique attribute information of the target product in the plurality of data tables created in the database in association with each other, when the product information is searched or extracted, the common attribute information or the unique attribute information of a certain product can be input, and all the common attribute information and the unique attribute information of the product can be acquired based on the association of the plurality of data tables.
Taking still an example that a certain electronic mall builds the universal product information model 100 by creating a plurality of data tables associated with each other by using a relational database, after storing information of all products in the electronic mall into the created plurality of data tables, by inputting a product name of a certain product, querying in the plurality of data tables associated with each other created in the database according to the product name, acquiring an identifier of the product from the product table, and acquiring a name of a common attribute, a type of the common attribute, and an identifier of the common attribute of the product from the product attribute table; according to the identifier of the commodity and the identifier of the common attribute of the commodity, the commodity attribute value of the common attribute of the commodity can be obtained from a commodity attribute value table; because the name of the common attribute of the commodity comprises the commodity type, the commodity attribute value of the commodity type of the commodity can be obtained through the commodity attribute value table, and the commodity type of the commodity is known; according to the commodity type of the commodity, the name of the commodity attribute template corresponding to the commodity type can be obtained from the commodity attribute template table; according to the name of the commodity attribute template of the commodity, the identifier of the unique attribute of the commodity can be obtained from the commodity template attribute table; according to the identifier of the unique attribute of the commodity, the name of the unique attribute of the commodity and the type of the unique attribute can be obtained from the commodity attribute table; the product attribute value of the unique attribute of the product can be acquired from the product attribute value table based on the identifier of the product and the identifier of the unique attribute thereof. Therefore, the retrieval and extraction of all information of the commodity are realized by inputting the commodity name.
Fig. 7 illustrates a physical structure diagram of an electronic device, and as shown in fig. 7, the electronic device may include: a processor (processor)710, a communication Interface (Communications Interface)720, a memory (memory)730, and a communication bus 740, wherein the processor 710, the communication Interface 720, and the memory 730 communicate with each other via the communication bus 740. Processor 710 may invoke logic instructions in memory 730 to store a method with merchandise information, the method comprising:
establishing a plurality of data tables which are mutually related in a database according to the common attribute template and the commodity attribute template; the common attribute template records common attribute information of all commodities; the commodity attribute template corresponding to each commodity type in the common attribute information records the unique attribute information of the commodity type;
the method comprises the steps of obtaining information of a target commodity, wherein the information of the target commodity comprises common attribute information and specific attribute information, storing the common attribute information of the target commodity into a plurality of created first data tables, wherein the first data tables comprise the common attribute information recorded by a common attribute template, and storing the specific attribute information of the target commodity into a plurality of created second data tables, and the second data tables comprise the specific attribute information recorded by a commodity attribute template.
In addition, the logic instructions in the memory 730 can be implemented in the form of software functional units and stored in a computer readable storage medium when the software functional units are sold or used as independent products. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
In another aspect, the present invention also provides a computer program product comprising a computer program stored on a non-transitory computer-readable storage medium, the computer program comprising program instructions which, when executed by a computer, enable the computer to perform the merchandise information storage method provided by the above methods, the method comprising:
establishing a plurality of data tables which are mutually related in a database according to the common attribute template and the commodity attribute template; the common attribute template records common attribute information of all commodities; the commodity attribute template corresponding to each commodity type in the common attribute information records the unique attribute information of the commodity type;
the method comprises the steps of obtaining information of a target commodity, wherein the information of the target commodity comprises common attribute information and specific attribute information, storing the common attribute information of the target commodity into a plurality of created first data tables, wherein the first data tables comprise the common attribute information recorded by a common attribute template, and storing the specific attribute information of the target commodity into a plurality of created second data tables, and the second data tables comprise the specific attribute information recorded by a commodity attribute template.
In yet another aspect, the present invention also provides a non-transitory computer-readable storage medium having stored thereon a computer program, which when executed by a processor, is implemented to perform the article information storage method provided above, the method including:
establishing a plurality of data tables which are mutually related in a database according to the common attribute template and the commodity attribute template; the common attribute template records common attribute information of all commodities; the commodity attribute template corresponding to each commodity type in the common attribute information records the unique attribute information of the commodity type;
the method comprises the steps of obtaining information of a target commodity, wherein the information of the target commodity comprises common attribute information and specific attribute information, storing the common attribute information of the target commodity into a plurality of created first data tables, wherein the first data tables comprise the common attribute information recorded by a common attribute template, and storing the specific attribute information of the target commodity into a plurality of created second data tables, and the second data tables comprise the specific attribute information recorded by a commodity attribute template.
The above-described embodiments of the apparatus are merely illustrative, and the units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
Through the above description of the embodiments, those skilled in the art will clearly understand that each embodiment can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware. With this understanding in mind, the above-described technical solutions may be embodied in the form of a software product, which can be stored in a computer-readable storage medium such as ROM/RAM, magnetic disk, optical disk, etc., and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the methods described in the embodiments or some parts of the embodiments.
Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (10)
1. A commodity information storage method, characterized by comprising:
establishing a plurality of data tables which are mutually related in a database according to the common attribute template and the commodity attribute template; the common attribute template records common attribute information of all commodities; the commodity attribute template corresponding to each commodity type in the common attribute information records the unique attribute information of the commodity type;
the method comprises the steps of obtaining information of a target commodity, wherein the information of the target commodity comprises common attribute information and specific attribute information, storing the common attribute information of the target commodity into a plurality of created first data tables, wherein the first data tables comprise the common attribute information recorded by a common attribute template, and storing the specific attribute information of the target commodity into a plurality of created second data tables, and the second data tables comprise the specific attribute information recorded by a commodity attribute template.
2. The commodity information storage method according to claim 1, wherein the common attribute information further includes: the commodity name, the commodity identifier, the name of the common attribute, the type of the common attribute, the identifier of the common attribute and the commodity attribute value of the common attribute, and the unique attribute information includes: the name of the unique attribute, the type of the unique attribute, the identifier of the unique attribute and the commodity attribute value of the unique attribute, wherein a plurality of data tables which are mutually associated are created in the database, and the data tables comprise:
creating a commodity attribute template table for recording names of commodity attribute templates corresponding to commodity types in a database;
creating a commodity template attribute table for recording identifiers of unique attributes of commodity attribute templates in a database, setting names of corresponding commodity attribute templates for the identifiers of the unique attributes in the commodity template attribute table, and enabling the commodity template attribute table to be connected with the commodity attribute template table through the names of the commodity attribute templates;
establishing a commodity table for recording commodity names in a database, wherein according to the commodity type of a commodity corresponding to the commodity name, connection is established between the commodity name in the commodity table and a commodity attribute template table corresponding to the commodity attribute template table name through a commodity attribute template table name corresponding to the commodity type;
establishing a commodity attribute table for recording names of common attributes, types of the common attributes, identifiers of the common attributes, names of unique attributes, types of the unique attributes and identifiers of the unique attributes in a database, setting common attribute flag bits for common attribute information in the commodity attribute table, and setting unique attribute flag bits for unique attribute information in the commodity attribute table;
aiming at the type of each commodity attribute value, a commodity attribute value table for recording the type of the commodity attribute value is established in a database, identifiers of corresponding commodities are respectively set for the commodity attribute values in each commodity attribute value table, identifiers of common attributes are set for the commodity attribute values of the common attributes in the commodity attribute value table, identifiers of unique attributes are set for the commodity attribute values of the unique attributes in the commodity attribute value table, each commodity attribute value table is connected with the commodity attribute table through the identifiers of the common attributes or the identifiers of the unique attributes, and the connection is established with the commodity table through the identifiers of the commodities.
3. The product information storage method according to claim 2, wherein the storing common attribute information of the target product in a plurality of first data tables created, the first data tables containing common attribute information recorded in the common attribute template, and storing specific attribute information of the target product in a plurality of second data tables created, the second data tables containing specific attribute information recorded in the product attribute template, includes:
storing the name of a commodity attribute template corresponding to the commodity type of the target commodity into the commodity attribute template table;
storing the identifier of the unique attribute of the target commodity in the commodity template attribute table;
storing the commodity name and the identifier of the target commodity in the commodity table;
storing the name of the common attribute, the type of the common attribute and the identifier of the common attribute of the target commodity, and the name of the unique attribute, the type of the unique attribute and the identifier of the unique attribute into the commodity attribute table;
and respectively storing the commodity attribute values of the common attributes and the commodity attribute values of the specific attributes of the target commodities into the corresponding commodity attribute value tables.
4. The commodity information storage method according to claim 2 or 3, wherein the type of the commodity attribute value includes at least one of: text type, number type, single-selection drop-down menu type, multiple-selection drop-down menu type and commodity detail type.
5. The commodity information storage method according to claim 2 or 3, wherein the types of the common attributes include a basic attribute and a brand attribute; the types of unique attributes include marketing attributes, service attributes, and interaction attributes.
6. The commodity information storage method according to claim 5, further comprising an extended service template for recording commodity extended services, the method further comprising:
establishing a commodity expansion service table in a database according to the expansion service template, setting a corresponding commodity identifier for the commodity expansion service in the commodity expansion service table, and enabling the commodity expansion service table to be connected with the commodity table through the commodity identifier;
and acquiring the identifier of the target commodity and storing the identifier into the created commodity expansion service table.
7. A generic merchandise information model, comprising:
the common attribute template is constructed on the basis of a plurality of data tables which are established in a database and are mutually associated, and is used for recording common attribute information of all commodities;
and the commodity attribute template is constructed on the basis of a plurality of data tables which are established in the database and are mutually associated, corresponds to each commodity type respectively, and is used for recording the unique attribute information of each commodity type.
8. The universal merchandise information model of claim 7, further comprising:
and the extended service template is constructed based on a plurality of data tables which are established in a database and are mutually associated, and is used for recording the extended service information of the commodity.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the steps of the merchandise information storage method according to any one of claims 1 to 6 when executing the program.
10. A non-transitory computer-readable storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements the steps of the merchandise information storage method according to any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110750738.XA CN113434510B (en) | 2021-07-02 | 2021-07-02 | General commodity information model and commodity information storage method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110750738.XA CN113434510B (en) | 2021-07-02 | 2021-07-02 | General commodity information model and commodity information storage method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113434510A true CN113434510A (en) | 2021-09-24 |
| CN113434510B CN113434510B (en) | 2023-12-29 |
Family
ID=77758809
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110750738.XA Active CN113434510B (en) | 2021-07-02 | 2021-07-02 | General commodity information model and commodity information storage method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113434510B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114676073A (en) * | 2022-05-18 | 2022-06-28 | 飞腾信息技术有限公司 | TLB table item management method, device and storage medium |
Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2003196132A (en) * | 2001-12-27 | 2003-07-11 | Nec Corp | Commodity information management system |
| KR20050014931A (en) * | 2003-08-01 | 2005-02-21 | (주)코어로직스 | Method for storing multiple attribute information for speedy search and computer readable recording medium having the computer readable multiple attribute information stored therein |
| CN102222100A (en) * | 2011-06-21 | 2011-10-19 | 青岛海信传媒网络技术有限公司 | Method and device for commodity information access |
| JP2013003405A (en) * | 2011-06-17 | 2013-01-07 | Nippon Telegr & Teleph Corp <Ntt> | Commodity attribute display system and operation method thereof |
| CN104598520A (en) * | 2014-12-12 | 2015-05-06 | 北京京东尚科信息技术有限公司 | Commodity information processing method and device |
| US9075840B1 (en) * | 2014-10-27 | 2015-07-07 | Intuitive Control Systems, Llc | Method and computer program product for allowing a software application to interact with a product |
| US20160055244A1 (en) * | 2014-08-22 | 2016-02-25 | Adelphic, Inc. | Audience on Networked Devices |
| CN106067132A (en) * | 2016-05-27 | 2016-11-02 | 乐视控股（北京）有限公司 | The method to set up of item property and device |
| CN106408321A (en) * | 2015-07-31 | 2017-02-15 | 华为技术有限公司 | Management method and device of commodity template, and method and device for calling database, and system |
| CN107464162A (en) * | 2017-07-28 | 2017-12-12 | 腾讯科技（深圳）有限公司 | Commodity association method, apparatus and computer-readable recording medium |
| CN107679247A (en) * | 2017-10-31 | 2018-02-09 | 南威软件股份有限公司 | A kind of method that electric business website realizes self-defined maintenance items extension information |
| CN109766339A (en) * | 2018-11-30 | 2019-05-17 | 广州因特信息科技有限公司 | A kind of product information storage method and system, medium realized based on matrix type |
| CN111857674A (en) * | 2020-07-31 | 2020-10-30 | 中国工商银行股份有限公司 | Business product generation method and device, electronic equipment and readable storage medium |
-
2021
- 2021-07-02 CN CN202110750738.XA patent/CN113434510B/en active Active
Patent Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2003196132A (en) * | 2001-12-27 | 2003-07-11 | Nec Corp | Commodity information management system |
| KR20050014931A (en) * | 2003-08-01 | 2005-02-21 | (주)코어로직스 | Method for storing multiple attribute information for speedy search and computer readable recording medium having the computer readable multiple attribute information stored therein |
| JP2013003405A (en) * | 2011-06-17 | 2013-01-07 | Nippon Telegr & Teleph Corp <Ntt> | Commodity attribute display system and operation method thereof |
| CN102222100A (en) * | 2011-06-21 | 2011-10-19 | 青岛海信传媒网络技术有限公司 | Method and device for commodity information access |
| US20160055244A1 (en) * | 2014-08-22 | 2016-02-25 | Adelphic, Inc. | Audience on Networked Devices |
| US9075840B1 (en) * | 2014-10-27 | 2015-07-07 | Intuitive Control Systems, Llc | Method and computer program product for allowing a software application to interact with a product |
| CN104598520A (en) * | 2014-12-12 | 2015-05-06 | 北京京东尚科信息技术有限公司 | Commodity information processing method and device |
| CN106408321A (en) * | 2015-07-31 | 2017-02-15 | 华为技术有限公司 | Management method and device of commodity template, and method and device for calling database, and system |
| CN106067132A (en) * | 2016-05-27 | 2016-11-02 | 乐视控股（北京）有限公司 | The method to set up of item property and device |
| CN107464162A (en) * | 2017-07-28 | 2017-12-12 | 腾讯科技（深圳）有限公司 | Commodity association method, apparatus and computer-readable recording medium |
| CN107679247A (en) * | 2017-10-31 | 2018-02-09 | 南威软件股份有限公司 | A kind of method that electric business website realizes self-defined maintenance items extension information |
| CN109766339A (en) * | 2018-11-30 | 2019-05-17 | 广州因特信息科技有限公司 | A kind of product information storage method and system, medium realized based on matrix type |
| CN111857674A (en) * | 2020-07-31 | 2020-10-30 | 中国工商银行股份有限公司 | Business product generation method and device, electronic equipment and readable storage medium |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114676073A (en) * | 2022-05-18 | 2022-06-28 | 飞腾信息技术有限公司 | TLB table item management method, device and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113434510B (en) | 2023-12-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107911249B (en) | Method, device and equipment for sending command line of network equipment | |
| CN107515882B (en) | Data query method and device | |
| CN108268565B (en) | Method and system for processing user browsing behavior data based on data warehouse | |
| CN111401008B (en) | Document auditing system, document auditing method and device | |
| CN107679247A (en) | A kind of method that electric business website realizes self-defined maintenance items extension information | |
| US10609524B2 (en) | Keyword-based information processing method and device | |
| CN106327257A (en) | Electronic order management method and system | |
| CN104579909B (en) | Method and equipment for classifying user information and acquiring user grouping information | |
| CN110704486B (en) | Data processing method, device, system, storage medium and server | |
| CN107741889A (en) | Document recovery method, system, readable storage medium storing program for executing and terminal | |
| CN114610951A (en) | Data processing method and device, electronic equipment and readable storage medium | |
| CN113434510B (en) | General commodity information model and commodity information storage method | |
| CN104765792B (en) | A kind of method, apparatus and system of dimension data storage | |
| WO2022223024A1 (en) | Data processing method and apparatus, device, and storage medium | |
| CN107818117B (en) | Data table establishing method, online query method and related device | |
| CN103942213A (en) | Data paging method and device | |
| CN112487251A (en) | User ID data association method and device | |
| CN107104889B (en) | Draft mail synchronization method, draft mail synchronization device and draft mail synchronization terminal based on IMAP protocol | |
| CN106600176B (en) | Information input processing method and device | |
| JP6273969B2 (en) | Data processing apparatus, information processing apparatus, method, and program | |
| CN105678515A (en) | Project management method and device | |
| CN111858609A (en) | Fuzzy query method and device for block chain | |
| CN104834277A (en) | Management method, management device, and management system | |
| CN110852743A (en) | Data acquisition method and device | |
| CN114528452B (en) | Method and system for realizing data tag based on cigarette and wine sales |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |