CN113434510B - General commodity information model and commodity information storage method - Google Patents
General commodity information model and commodity information storage method Download PDFInfo
- Publication number
- CN113434510B CN113434510B CN202110750738.XA CN202110750738A CN113434510B CN 113434510 B CN113434510 B CN 113434510B CN 202110750738 A CN202110750738 A CN 202110750738A CN 113434510 B CN113434510 B CN 113434510B
- Authority
- CN
- China
- Prior art keywords
- commodity
- attribute
- template
- information
- common
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 45
- 230000000875 corresponding effect Effects 0.000 claims description 48
- 230000003993 interaction Effects 0.000 claims description 10
- 238000004590 computer program Methods 0.000 claims description 9
- 230000002596 correlated effect Effects 0.000 claims description 3
- 230000008093 supporting effect Effects 0.000 abstract description 4
- 238000010586 diagram Methods 0.000 description 7
- 238000004891 communication Methods 0.000 description 5
- 230000003287 optical effect Effects 0.000 description 2
- 230000007547 defect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
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)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a general commodity information model and a commodity information storage method. The method comprises the following steps: creating 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 specific 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 specific attribute information, storing the common attribute information into a plurality of created first data tables, the first data tables comprise the common attribute information recorded by a common attribute template, and storing the specific attribute information into a plurality of created second data tables, and the second data tables comprise the specific attribute information recorded by the commodity attribute template. The invention can promote the flexibility of commodity information operation in the electronic commerce system and can play a good supporting role in 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 general commodity information model and a commodity information storage method.
Background
In an electronic commerce system, information of commodities is important, and is the core of the whole electronic commerce system and the basis for generating all business data of the electronic commerce system. Most electronic commerce systems cannot flexibly operate commodity information, such as adding, extracting, retrieving and the like, so that 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 solving 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 supporting role in business innovation and evolution of the electronic commerce system.
In a first aspect, the present invention provides a commodity information storage method, including:
creating 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 specific attribute information of the commodity type;
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 the 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 the commodity attribute template.
According to the commodity information storage method provided by the invention, the common attribute information further comprises: commodity name, commodity identifier, name of common attribute, type of common attribute, identifier of common attribute, and commodity attribute value of common attribute, the unique attribute information includes: a name of the unique attribute, a type of the unique attribute, an identifier of the unique attribute, a commodity attribute value of the unique attribute, said creating a plurality of data tables in a database that are interrelated, comprising:
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 specific attributes of commodity attribute templates in a database, setting names of corresponding commodity attribute templates for the identifiers of the specific 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;
Creating a commodity table for recording commodity names in a database, wherein connection is established between the commodity names and commodity attribute template tables corresponding to the commodity attribute template table names in the commodity table according to commodity types corresponding to the commodity names and the commodity attribute template table names corresponding to the commodity types;
creating a commodity attribute table for recording names of common attributes, types of common attributes, identifiers of common attributes, names of unique attributes, types of unique attributes and identifiers of 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;
for each type of commodity attribute value, creating a commodity attribute value table for recording the type of the commodity attribute value in a database, respectively setting identifiers of corresponding commodities for commodity attribute values in each commodity attribute value table, setting identifiers of common attributes for commodity attribute values of common attributes in the commodity attribute value table, setting identifiers of unique attributes for commodity attribute values of unique attributes in the commodity attribute value table, and enabling each commodity attribute value table to establish connection with the commodity attribute table through the identifiers of the common attributes or the identifiers of the unique attributes and establish connection with the commodity table through the identifiers of the commodities.
According to the commodity information storage method provided by the present invention, the common attribute information of the target commodity is stored in a plurality of created first data tables, the first data tables contain the common attribute information of the common attribute template record, and the specific attribute information of the target commodity is stored in a plurality of created second data tables, the second data tables contain the specific attribute information of the commodity attribute template record, and the method includes:
storing names of commodity attribute templates corresponding to commodity types of the target commodity into the commodity attribute template table;
storing an identifier of a unique attribute of the target commodity into the commodity template attribute table;
storing the commodity name and identifier of the target commodity into the commodity table;
storing 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 into the commodity attribute table;
and storing commodity attribute values of common attributes and commodity attribute values of specific attributes of the target commodity into corresponding commodity attribute value tables respectively.
According to the commodity information storage method provided by the invention, the type of the commodity attribute value comprises at least one of the following: text type, number type, single-choice drop-down menu type, multiple-choice drop-down menu type, item detail type.
According to the commodity information storage method provided by the invention, the types of the common attributes comprise basic attributes and brand attributes; the types of the unique attributes include marketing attributes, service attributes, and interaction attributes.
The invention provides a commodity information storage method, which further comprises an extended service template for recording commodity extended service, and the method further comprises the following steps:
creating a commodity expansion business table in a database according to the expansion business template, setting identifiers of corresponding commodities for commodity expansion businesses in the commodity expansion business table, and enabling the commodity expansion business table to be connected with the commodity table through the identifiers of the commodities;
and acquiring the identifier of the target commodity and storing the identifier into the created commodity expansion business table.
In a second aspect, the present invention also provides a general commodity information model, including:
a common attribute template constructed based on a plurality of data tables which are created in a database and are mutually related, and the common attribute template is used for recording common attribute information of all commodities;
And the commodity attribute template is constructed based on a plurality of data tables which are created and correlated in a database, respectively corresponds to each commodity type and is used for recording the specific 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 created in a database and are mutually related and is used for recording the extended service information of the commodity.
In a third aspect, the present invention also provides an electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the steps of any of the merchandise information storage methods described above when the program is executed.
In a fourth 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, implements the steps of a merchandise information storage method as described in any one of the above.
According to the general commodity information model and the commodity information storage method, a plurality of data tables which are mutually related are created in a database according to a common attribute template and a 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 specific attribute information of the commodity type; acquiring 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 the 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 the commodity attribute template; through reasonable splitting of commodity attributes, a common attribute template for storing common attribute information of commodities and a commodity attribute template for storing specific attribute information of commodity types are constructed by utilizing a database, so that operations such as adding new commodity types, new commodity and new commodity attributes, retrieving and extracting stored commodity information and the like can be conveniently realized, flexibility of commodity information operation in an electronic commerce system can be improved, and therefore, a good supporting effect can be played on business innovation and evolution of the electronic commerce system.
Drawings
In order to more clearly illustrate the invention or the technical solutions of the prior art, the following description will briefly explain the drawings used in the embodiments or the description of the prior art, and it is obvious that the drawings in the following description are some embodiments of the invention, and other drawings can be obtained according to the drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic diagram of the composition structure of a general merchandise information model provided by the invention;
FIG. 2 is a schematic diagram of a general merchandise information model applied to an electronic mall;
FIG. 3 is a schematic flow chart of a method for storing merchandise information provided by the invention;
FIG. 4 is a flow chart of creating a plurality of data tables in a database that are interrelated in accordance with 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 flow chart of storing common attribute information and unique attribute information of a target commodity in 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
For the purpose of making the objects, technical solutions and advantages of the present invention more apparent, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings, and it is apparent that the described embodiments are some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the 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 diagram of a composition structure of a general commodity information model provided in the present invention, as shown in fig. 1, the general commodity information model 100 may include a common attribute template 110 and a commodity attribute template 120, where the common attribute template 110 is used for recording common attribute information of all commodities, the commodity attribute template 120 corresponds to each commodity type respectively and is used for recording unique attribute information of each commodity type, and the common attribute template 110 and the commodity attribute template 120 are used for creating a plurality of data table structures associated with each other in a database.
Optionally, the information of the mass commodities is collected, subjected to processing such as duplication removal and the like, and classified into common attribute information and specific attribute information according to a preset attribute classification strategy, wherein the common attribute information of the commodities can comprise names of common attributes, types of the common attributes, commodity attribute values of the common attributes and the like. Wherein the types of common attributes may include basic attributes such as the type of merchandise, the name of the merchandise, the brand of the merchandise, etc.; in the case of implementing 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, and so on; the embodiment of the invention does not limit the type of the common attribute of the commodity.
Alternatively, the unique attribute information of the commodity may include a name of the unique attribute, a type of the unique attribute, a commodity attribute value of the unique attribute, and the like. Wherein, the type of the specific attribute can comprise at least one of marketing attribute, service attribute, interaction attribute and the like; for example, the marketing attribute may include a commodity hot sale, a commodity warehouse clearance, etc., the service attribute may include a warranty period of the commodity, a package time of the commodity, etc., the interaction attribute may include an agent of the commodity, a factory site of the commodity, etc., and the type of the specific attribute of the commodity is not limited in the embodiment of the present invention. Taking the commodity type as a household appliance and the household appliance as an air conditioner as an example, the type of the special attribute is a service attribute, the name of the special attribute is the warranty period of the commodity, and the commodity attribute value of the special attribute is 1 year.
Optionally, the generic merchandise information model 100 may further include: the extended service template is used for recording the extended service information of the commodity, is also constructed based on a plurality of data tables which are created and correlated in a database, and can be properly set according to actual service requirements in actual application. Alternatively, the extended service information of the commodity may include a label of the commodity, a specification of the commodity, a style of the commodity, a place of production of the commodity, and the like, for example, the label of the commodity may include a label of a single commodity, a label of a group of commodities, and the like, the specification of the commodity may include a unit of a single commodity, a unit of a group of commodities, and the like, and the type of the extended service information of the commodity 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 the general merchandise information model provided by the present invention applied to a certain electronic mall, and as shown in fig. 2, the general merchandise information model provided by the present invention is applied to a certain electronic mall, and the obtained general merchandise information model 200 includes: a common attribute template 210 for recording common attribute information of all commodities in the electronic mall, and commodity attribute templates, namely, a home appliance attribute template 220, a clothing attribute template 230 and an automobile attribute template 240, which correspond to commodity types, namely, home appliances, clothing and automobiles, of the electronic mall, respectively, and are used for recording unique attribute information of each commodity type.
The common attribute template 210 includes a basic attribute 211 and a brand attribute 212 of the commodity, and common attribute information of the commodity in the common attribute template 210 may be preset, or may be determined from attribute information commonly owned by all commodity types in the electronic mall according to a preset condition, and a determination manner of the common attribute information of the commodity in the common attribute template 210 is not limited in the embodiment of the present invention.
Wherein, household appliance attribute template 220 comprises: marketing properties 221, service properties 222, and interaction properties 223 of the home appliance; the garment properties template 230 includes: marketing properties 231, service properties 232, and interaction properties 233 of the garment; the automobile property template 240 includes: marketing properties 241, service properties 242, and interaction properties 243 for automobiles. Marketing attribute 221, service attribute 222 and interaction attribute 223 in home appliance attribute template 220 may be determined according to attribute information of all home appliances in the electronic mall; marketing attributes 231, service attributes 232 and interaction attributes 233 in the clothing attribute template information 230 can be determined according to the attribute information of all the clothing in the electronic mall; marketing attributes 241, service attributes 242, and interaction attributes 243 in the car attribute template 240 may be determined from attribute information of all cars in the electronic marketplace.
In practical applications, 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, an extended service template may be set in the general commodity information model 200 for the specification of the commodity and the label of the commodity, respectively, and the specification information of the commodity and the label information of the commodity may be recorded in the extended service template, respectively. Business management such as classification, brand management, marketing channel management, price management and the like of commodities in the electronic mall can be realized through commodity information recorded in the general commodity information model 200.
Referring to fig. 3, fig. 3 is a flow chart of a commodity information storage method according to the present invention, where the commodity information storage method is implemented by using a general commodity information model 100, and as shown in fig. 3, the commodity information storage method at least includes:
301, creating a plurality of data tables which are mutually related in a database according to a common attribute template and a 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 specific attribute information of the commodity type.
In the embodiment of the present invention, the general merchandise 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 capabilities of the database, for example, the general merchandise information model 100 may be constructed by using a relational database, and the type of the database implementing the general merchandise information model 100 is not limited in the embodiment of the present invention.
302, 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 the commodity attribute template.
In the embodiment of the present invention, after the general commodity information model 100 is built by creating the data table in the database, the information of the target commodity may be stored in the data table created in the database by acquiring the information of the target commodity, 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 information of the target commodity can comprise common attribute information and specific attribute information, the common attribute information of the target commodity is added to the common attribute template by storing the common attribute information of the target commodity into a plurality of first data tables created in a database, and the specific attribute information of the target commodity is stored into a plurality of second data tables created in the database, so that the specific attribute information of the target commodity is added to the corresponding commodity attribute template.
According to the commodity information storage method provided by the invention, a plurality of data tables which are mutually related are created in a database according to a common attribute template and a 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 specific attribute information of the commodity type; acquiring 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 the 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 the commodity attribute template; through reasonable splitting of commodity attributes, a common attribute template for storing common attribute information of commodities and a commodity attribute template for storing specific attribute information of commodity types are constructed by utilizing a database, so that operations such as adding new commodity types, new commodity and new commodity attributes, retrieving and extracting stored commodity information and the like can be conveniently realized, flexibility of commodity information operation in an electronic commerce system can be improved, and therefore, a good supporting effect can be played on business innovation and evolution of the electronic commerce system.
Referring to fig. 4, fig. 4 is a schematic flow chart 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: commodity name, commodity identifier, name of common attribute, type of common attribute, identifier of common attribute, and commodity attribute value of common attribute, the unique attribute information includes: the name of the unique attribute, the type of the unique attribute, the identifier of the unique attribute, the commodity attribute value of the unique attribute. Creating a plurality of data tables associated with each other in a database, at least comprising:
a commodity attribute template table for recording names of commodity attribute templates corresponding to commodity types is created 401 in a database.
In some optional examples, the general commodity information model 100 is constructed by using a relational database for a certain electronic mall, and a commodity attribute template table may be created in the database according to all commodity types in the electronic mall, where names of commodity attribute templates corresponding to commodity types in the electronic mall are recorded. For example, as shown in fig. 5, the created commodity attribute template table is pms_ eav _attribute_set, and the names of the commodity attribute templates in the commodity attribute template table are home appliance attribute templates, clothing attribute templates, automobile attribute templates, and the like.
And 402, creating a commodity template attribute table for recording identifiers of the specific attributes of the commodity attribute templates in the database, setting names of the corresponding commodity attribute templates for the identifiers of the specific 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.
In some optional examples, taking a relationship database still used by a certain electronic mall to construct the general commodity information model 100 as an example, a commodity template attribute table may be created in the database according to all the specific attributes of each commodity type in the electronic mall, in the created commodity template attribute table, identifiers of all the specific attributes in each commodity attribute template in the electronic mall are recorded, and the specific attributes in the commodity template attribute table may be connected with corresponding commodity attribute templates in the commodity attribute template table through names of commodity attribute templates. For example, as shown in fig. 5, the created commodity template attribute table is pms_ eav _entity_attribute, and the warranty period of the home appliance in the commodity template attribute table is connected with the corresponding home appliance attribute template in the commodity template table by the name of the home appliance attribute template.
403, creating a commodity table for recording commodity names and identifiers of commodities in a 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, taking a relationship database still used by a certain electronic mall to construct the general commodity information model 100 as an example, a commodity table may be created in the database according to all commodities in the electronic mall, in the created commodity table, all commodity names and identifiers under each commodity type in the electronic mall are recorded, under the condition that the commodity names are the same, the commodity is uniquely identified by the identifier of the commodity, and the commodity in the commodity table may be connected with the 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 commodity table is pms_product_entity, and a garment in the commodity table can be connected with a corresponding garment attribute template in the commodity attribute template table through the name of the garment attribute template.
404, creating a commodity attribute table for recording names of common attributes, types of common attributes, identifiers of common attributes, names of unique attributes, types of unique attributes and identifiers of 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.
In some optional examples, taking still a relationship database for a certain electronic mall to construct the general commodity information model 100 as an example, a commodity attribute table may be created in the database according to all commodity attributes in the electronic mall, in the created commodity attribute table, names, types and identifiers of commodity attributes of all commodities in the electronic mall are recorded, where the commodity attributes include common attributes of the commodities and unique attributes of commodity types, and a flag bit may be set for each commodity attribute in the commodity attribute table, and the flag bit may be used to distinguish whether the commodity attributes are common attributes or unique attributes. For example, as shown in fig. 5, the created commodity attribute table is pms_ eav _attribute, and the flag bit set for each commodity attribute in the commodity attribute table is_common.
405, for each type of commodity attribute value, creating a commodity attribute value table for recording the type of the commodity attribute value in a database, respectively setting identifiers of corresponding commodities for commodity attribute values in each commodity attribute value table, setting identifiers of common attributes for commodity attribute values of common attributes in the commodity attribute value table, setting identifiers of unique attributes for commodity attribute values of unique attributes in the commodity attribute value table, and enabling each commodity attribute value table to be connected with the commodity attribute table through the identifiers of common attributes or the identifiers of unique attributes, and establishing connection with the commodity table through the identifiers of commodities.
In some optional examples, still taking a relationship database for a certain electronic mall to construct the general commodity information model 100 as an example, commodity attribute value tables corresponding to the types of all commodity attribute values in the electronic mall 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 all commodity attribute values in the electronic mall are respectively recorded in the created commodity attribute value tables, and the commodity attribute values in each commodity attribute value table may be connected with the commodity attributes corresponding to the commodity attribute tables through identifiers of the commodity attributes, and may be connected with the corresponding commodities in the commodity tables through identifiers of the commodities. Optionally, the type of the commodity attribute value includes at least one of a text type, a number type, a single-choice drop-down menu type, a multiple-choice drop-down menu type, a commodity detail type, and the like. For example, as shown in fig. 5, the created text type value table is pms_product_entity_source, the created digital type value table is pms_product_entity_int, the created single-selection drop-down menu type value table is pms_ eav _attribute_option, and the created commodity detail type value table is pms_product_entity_text. When information of the commodity is stored in the created data table, the commodity attribute value is stored in the corresponding commodity attribute value table according to the type of the attribute value, for example, the commodity attribute value of the character type can be stored in pms_product_entity_source, the commodity attribute value of the digital type can be stored in pms_product_entity_int, the commodity attribute value of the pull menu type is special, the content of the pull menu needs to be recorded in pms_ eav _attribute_option, and the pull-down menu is selected when commodity details are more, and the commodity is stored in pms_product_entity_source_text.
The embodiment utilizes the relational database to realize the general commodity information model by creating a commodity attribute template table, a commodity template attribute table, a commodity attribute table and commodity attribute values which are related to each other in the database, and can realize the operations of adding new commodity types, new commodities and new commodity attributes, retrieving and extracting stored commodity information and the like by utilizing the storage and management capacity of the database on data.
Referring to fig. 6, fig. 6 is a schematic flow chart of storing common attribute information and specific attribute information of a target commodity into a plurality of data tables, and as shown in fig. 6, storing common attribute information of a target commodity into a plurality of created first data tables, wherein the first data tables contain common attribute information of the common attribute template record, and storing specific attribute information of the target commodity into a plurality of created second data tables, wherein the second data tables contain specific attribute information of the commodity attribute template record, and at least include:
601, storing names of commodity attribute templates corresponding to commodity types of target commodities into a commodity attribute template table.
602, storing an identifier of a specific attribute of the target commodity in a commodity template attribute table.
603, store the commodity name and identifier of the target commodity in the commodity table.
604, storing 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 in the commodity attribute table.
605, the commodity attribute value of the common attribute and the commodity attribute value of the unique attribute of the target commodity are respectively stored in the corresponding commodity attribute value table.
In the embodiment of the invention, the first data table may include a commodity table, a commodity attribute table and a commodity attribute value table, and the second data table may include a commodity attribute template table, a commodity template attribute table, a commodity attribute table and a commodity attribute value table. The description of 601, 602, 603, 604 can be found in fig. 4 for the description of 401, 402, 403, 404, 405, and will not be repeated here.
Still take a certain electronic mall to construct a general commodity information model 100 by creating a plurality of data tables related to each other by using a relational database as an example, when the information of the target commodity is stored in the created plurality of data tables, if the commodity type to which the target commodity belongs is an existing type, that is, if the target commodity is not the first commodity of the commodity type, the name of the commodity attribute template corresponding to the target commodity is already present 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 is not required to be executed; if the type of the commodity to which the target commodity belongs is not an existing type, that is, if the target commodity is the first commodity of the commodity type, the name of the corresponding commodity attribute template is not in the commodity attribute template table, and at this time, when the information of the target commodity is stored in the created multiple data tables, the operation of 601 is not required to be executed.
In some optional implementation manners, the general commodity information model may further include an extension service template for recording commodity extension service, and the commodity information storage method may further create a commodity extension service table in the database according to the extension service template, set identifiers of corresponding commodities for commodity extension services in the commodity extension service table, and enable the commodity extension service table to establish connection with corresponding commodities in the commodity table through the identifiers of the commodities; and acquiring the identifier of the target commodity and storing the identifier in the created commodity extension service table.
After common attribute information and unique attribute information of a target commodity are recorded in a common attribute template and a commodity attribute template of a general commodity information model by storing the common attribute information and the unique attribute information of the target commodity in a plurality of data tables created in a database, when commodity information is searched or extracted, all the common attribute information and the unique attribute information of a commodity can be acquired based on the correlation of the plurality of data tables by inputting the common attribute information or the unique attribute information of the commodity.
Still take a relational database for a certain electronic mall to construct a general commodity information model 100 by creating a plurality of data tables related to each other as an example, after information of all commodities in the electronic mall is stored in the created plurality of data tables, the commodity name of a certain commodity can be input, the identifier of the commodity is obtained from the commodity tables according to the commodity name which is searched in the created plurality of data tables related to each other, and the name of the common attribute, the type of the common attribute and the identifier of the common attribute of the commodity are obtained from the commodity attribute tables; 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 names of the common attributes of the commodities comprise commodity types, commodity attribute values of the commodity types of the commodities can be obtained through a commodity attribute value table, and the commodity types of the commodities are also known; according to the commodity type of the commodity, the name of a commodity attribute template corresponding to the commodity type can be obtained from a commodity attribute template table; according to the name of the commodity attribute template of the commodity, the identifier of the specific attribute of the commodity can be obtained from a commodity template attribute table; according to the identifier of the specific attribute of the commodity, the name of the specific attribute of the commodity and the type of the specific attribute can be obtained from a commodity attribute table; based on the identifier of the commodity and the identifier of the unique attribute thereof, the commodity attribute value of the unique attribute of the commodity can be obtained from the commodity attribute value table. Therefore, the retrieval and extraction of all information of the commodity are realized by inputting the commodity name.
Fig. 7 illustrates a physical schematic diagram of an electronic device, as shown in fig. 7, which may include: processor 710, communication interface (Communications Interface) 720, memory 730, and communication bus 740, wherein processor 710, communication interface 720, memory 730 communicate with each other via communication bus 740. Processor 710 may invoke logic instructions in memory 730 to store the method with merchandise information, the method comprising:
creating 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 specific attribute information of the commodity type;
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 the 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 the commodity attribute template.
Further, the logic instructions in the memory 730 described above may be implemented in the form of software functional units and may be stored in a computer readable storage medium when sold or used as a stand alone product. Based on this understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, a network device, etc.) to perform 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, random Access Memory), a magnetic disk, or an optical disk, or 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 method of storing merchandise information provided by the methods described above, the method comprising:
Creating 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 specific attribute information of the commodity type;
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 the 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 the 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 above-provided commodity information storage methods, the method comprising:
creating 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 specific attribute information of the commodity type;
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 the 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 the commodity attribute template.
The apparatus embodiments described above are merely illustrative, wherein the elements illustrated as separate elements may or may not be physically separate, and the elements shown as elements may or may not be physical elements, may be located in one place, or may be distributed over a plurality of network elements. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment. Those of ordinary skill in the art will understand and implement the present invention without undue burden.
From the above description of the embodiments, it will be apparent to those skilled in the art that the embodiments may be implemented by means of software plus necessary general hardware platforms, or of course may be implemented by means of hardware. Based on this understanding, the foregoing technical solution may be embodied essentially or in a part contributing to the prior art in the form of a software product, which may be stored in a computer readable storage medium, such as ROM/RAM, a magnetic disk, an optical disk, etc., including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the method described in the respective embodiments or some parts of the embodiments.
Finally, it should be noted that: the above embodiments are only for illustrating the technical solution of the present invention, and are not limiting; although the 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 scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention.
Claims (8)
1. A commodity information storage method, wherein the commodity information storage method is applied to a commodity information model, the commodity information model comprising a common attribute template and a commodity attribute template, the method comprising:
creating 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 specific attribute information of the commodity type;
obtaining information of a target commodity, splitting commodity attribute of the target commodity, enabling the information of the target commodity to comprise 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 the 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 the commodity attribute template;
The common attribute information further includes: commodity name, commodity identifier, name of common attribute, type of common attribute, identifier of common attribute, and commodity attribute value of common attribute, the unique attribute information includes: a name of the unique attribute, a type of the unique attribute, an identifier of the unique attribute, a commodity attribute value of the unique attribute, said creating a plurality of data tables in a database that are interrelated, comprising:
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 specific attributes of commodity attribute templates in a database, setting names of corresponding commodity attribute templates for the identifiers of the specific 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;
creating a commodity table for recording commodity names in a database, wherein connection is established between the commodity names and commodity attribute template tables corresponding to the commodity attribute template table names in the commodity table according to commodity types corresponding to the commodity names and the commodity attribute template table names corresponding to the commodity types;
Creating a commodity attribute table for recording names of common attributes, types of common attributes, identifiers of common attributes, names of unique attributes, types of unique attributes and identifiers of 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;
for each type of commodity attribute value, creating a commodity attribute value table for recording the type of the commodity attribute value in a database, respectively setting identifiers of corresponding commodities for commodity attribute values in each commodity attribute value table, setting identifiers of common attributes for commodity attribute values of common attributes in the commodity attribute value table, setting identifiers of unique attributes for commodity attribute values of unique attributes in the commodity attribute value table, and enabling each commodity attribute value table to establish connection with the commodity attribute table through the identifiers of the common attributes or the identifiers of the unique attributes and establish connection with the commodity table through the identifiers of the commodities.
2. The article information storage method according to claim 1, wherein the storing the common attribute information of the target article into the created plurality of first data tables containing the common attribute information of the common attribute template record, and storing the unique attribute information of the target article into the created plurality of second data tables containing the unique attribute information of the article attribute template record, comprises:
Storing names of commodity attribute templates corresponding to commodity types of the target commodity into the commodity attribute template table;
storing an identifier of a unique attribute of the target commodity into the commodity template attribute table;
storing the commodity name and identifier of the target commodity into the commodity table;
storing 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 into the commodity attribute table;
and storing commodity attribute values of common attributes and commodity attribute values of specific attributes of the target commodity into corresponding commodity attribute value tables respectively.
3. The commodity information storage method according to claim 1 or 2, wherein the type of commodity attribute value comprises at least one of: text type, number type, single-choice drop-down menu type, multiple-choice drop-down menu type, item detail type.
4. The commodity information storage method according to claim 1 or 2, wherein the types of the common attributes include a basic attribute and a brand attribute; the types of the unique attributes include marketing attributes, service attributes, and interaction attributes.
5. The merchandise information storage method of claim 4, further comprising an extended service template for recording merchandise extended services, the method further comprising:
creating a commodity expansion business table in a database according to the expansion business template, setting identifiers of corresponding commodities for commodity expansion businesses in the commodity expansion business table, and enabling the commodity expansion business table to be connected with the commodity table through the identifiers of the commodities;
and acquiring the identifier of the target commodity and storing the identifier into the created commodity expansion business table.
6. A general commodity information storage apparatus, which uses the commodity information storage method according to claim 1, comprising:
a common attribute template constructed based on a plurality of data tables which are created in a database and are mutually related, and the common attribute template is used for recording common attribute information of all commodities;
the commodity attribute template is constructed based on a plurality of data tables which are created and correlated in a database, respectively corresponds to each commodity type and is used for recording the specific attribute information of each commodity type;
and the extended service template is constructed based on a plurality of data tables which are created in a database and are mutually related and is used for recording the extended service information of the commodity.
7. 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 of any one of claims 1 to 5 when the program is executed by the processor.
8. A non-transitory computer readable storage medium having stored thereon a computer program, wherein the computer program when executed by a processor implements the steps of the merchandise information storage method of any one of claims 1 to 5.
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 CN113434510A (en) | 2021-09-24 |
| CN113434510B true 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) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114676073B (en) * | 2022-05-18 | 2022-09-23 | 飞腾信息技术有限公司 | TLB table item management method, device and storage medium |
Citations (12)
| 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 |
| 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 |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2016029178A1 (en) * | 2014-08-22 | 2016-02-25 | Adelphic, Inc. | Audience on networked devices |
-
2021
- 2021-07-02 CN CN202110750738.XA patent/CN113434510B/en active Active
Patent Citations (12)
| 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 |
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113434510A (en) | 2021-09-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107911249B (en) | Method, device and equipment for sending command line of network equipment | |
| CN107220266B (en) | Method and device for creating service database, storing service data and determining service data | |
| CN111401008B (en) | Document auditing system, document auditing method and device | |
| CN104579909B (en) | Method and equipment for classifying user information and acquiring user grouping information | |
| CN101276364A (en) | Method, system and apparatus for combining distributed computational data | |
| CN102509012A (en) | Method for mapping contents of electronic medical record into electronic medical record standard database | |
| CN110019542B (en) | Generation of enterprise relationship, generation of organization member database and identification of same name member | |
| KR101143673B1 (en) | Method and device for handling metadata | |
| CN114610951A (en) | Data processing method and device, electronic equipment and readable storage medium | |
| CN107741889A (en) | Document recovery method, system, readable storage medium storing program for executing and terminal | |
| CN113434510B (en) | General commodity information model and commodity information storage method | |
| CN110019754A (en) | A kind of method for building up of knowledge base, device and equipment | |
| CN106649602A (en) | Way, device and server of processing business object data | |
| CN106547646A (en) | A kind of data backup and restoration methods, data backup and recovery device | |
| WO2022223024A1 (en) | Data processing method and apparatus, device, and storage medium | |
| CN107729330A (en) | The method and apparatus for obtaining data set | |
| CN105354149B (en) | A kind of internal storage data lookup method and device | |
| JP4852834B2 (en) | Application requirement design support system and method | |
| CN112487251A (en) | User ID data association method and device | |
| CN106372985B (en) | Order data processing method and device | |
| JP6273969B2 (en) | Data processing apparatus, information processing apparatus, method, and program | |
| CN104899213B (en) | A kind of method and apparatus for parsing institution term | |
| CN115098738A (en) | Service data extraction method and device, storage medium and electronic equipment | |
| CN110309235B (en) | Data processing method, device, equipment and medium | |
| 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 |