KR20230024831A - Method for managing item bundle information and apparatus for the same - Google Patents

Abstract

According to embodiments of the present invention, a method for managing item bundle information can comprise one or more steps of: receiving first information on a plurality of items; receiving second information related to the mapping of the plurality of items; storing the first information and the second information in a first database which is a relational database; reading the first information and the second information from the first database, and generating bundle information on the plurality of items based on the read first information and second information; and storing the bundle information in a second database which is a non-relational database. Therefore, an instantaneous response can be provided to an item and promotion information requested by a user.

Description

Item bundle information management method and its device {METHOD FOR MANAGING ITEM BUNDLE INFORMATION AND APPARATUS FOR THE SAME}

Disclosure of the present invention relates to a method and apparatus for managing item bundle information. More specifically, the disclosure of the present invention is a method for managing item bundle information by generating mapping information and bundle information from the received information on items and promotion information and inserting or updating them into a relational database or a non-relational database. and its device.

In an Internet shopping mall, a user can select a desired product and purchase the selected product. In addition, in general, when a product is sold, there are other products to which a discount is applied when a product is purchased together with a specific product in order to promote a purchase intention of a consumer.

Prior literature: Korean Patent Publication No. 10-2006-0032376

The user may purchase only a specific product searched for by the user, but may want to purchase other products related to the specific product all at once. In addition, in general, when there are other products to which a discount is applied when purchased together with a specific product, it is difficult for consumers to know such information online. If the user has to search, inquire, and purchase the main item and other related products individually, this not only causes unnecessary burden and inconvenience to the user, but also cannot promote purchase demand for other products. Therefore, in order to solve this problem, there is an urgent need for an electronic device and management method for managing mapping information between items, providing it to a user's terminal based on the mapping information, and efficiently processing this function.

An object to be solved by the present embodiment is to provide a method and apparatus for managing item bundle information. More specifically, the problem to be solved by the present embodiment is to generate mapping information and bundle information from the received information about items and promotion information, and insert or update them into a relational database and a non-relational database, thereby providing promotion information and corresponding promotion information. Items to which promotions are applied are immediately provided to users without risk of competition or data collision.

In order to solve the above problem, a method for managing item bundle information according to embodiments includes receiving first information about a plurality of items; receiving second information related to mapping of the plurality of items; storing the first information and the second information in a first database that is a relational database; reading the first information and the second information from the first database, and generating bundle information for the plurality of items based on the read first and second information; and storing the bundle information in a second database that is a non-relational database. can include

The item bundle information management method according to embodiments may include reading bundle information about an item selected by a user using the item selling service from the second database; and providing the read bundle information to the terminal of the user. may further include.

Furthermore, the first information according to embodiments includes source item information indicating a source item necessarily selected for the mapping to be applied, and a target indicating at least one target item associated with the source item. It may include item information, and the bundle information may include third information indicating the source item and fourth information indicating at least one target item associated with the source item.

Furthermore, a first database according to embodiments may include a first table for representing the source item and the at least one target item, and a second table including the second information related to the mapping, The first table and the second table may further include requester service identification information for identifying a requester service.

Furthermore, bundle information according to embodiments may be generated based on requester service identification information included in the first table and the second table, and the third information is a base of the second database in which the bundle information is stored. It may be a primary key.

In addition, in the step of reading the bundle information according to embodiments, bundle information including the item selected by the user as a source item is checked in a second database, and the item selected by the user included in the checked bundle information is checked. At least one target item related to may be identified.

The item bundle information management method according to embodiments may further include receiving update information on at least one of the mapping information and the plurality of items information; and updating the first database based on requestor service identification information included in the update information. may further include.

Furthermore, the method for managing item bundle information according to embodiments includes updating the bundle information based on requestor service identification information included in the update information and the first information and the second information in the updated first database. ; and storing the updated bundle information in the second database. can include

Updating the bundle information according to embodiments may include inserting the first information and the second information in the updated first database into a queue, and updating the bundle information in the order of insertion into the queue. can do.

Furthermore, the second table according to embodiments includes fifth information indicating the type of mapping, sixth information indicating the property of the mapping, seventh information indicating the priority of the mapping, and fifth information indicating the effective time of the mapping. 8 information may be further included, and the bundle information may further include the fifth to eighth information.

In the step of providing the read bundle information to the user's terminal according to embodiments, the at least one target item may be displayed based on a display order determined based on the seventh information included in the bundle information.

Also, the sixth information according to embodiments may indicate whether the source item and the at least one target item should all be purchased together and whether some of the at least one target item may be excluded and purchased.

An electronic device according to embodiments stores and manages information about items and promotion information applied to items in a relational database and a non-relational database, respectively, so that items and promotion information requested by a user can be provided without additional computational burden and unnecessary delay. can respond immediately.

When a user inquires or inquires about a specific item, the electronic device according to embodiments may immediately provide promotion information and items to which the corresponding promotion is applied to the user without a race condition or risk of data collision.

1 shows an example of internal components of an electronic device according to embodiments.
2 illustrates an example of an electronic device performing a method for managing item bundle information according to embodiments.
3 shows an example of an item bundle mapping table (first table) according to embodiments.
4 shows an example of an item bundle mapping group table (second table) according to embodiments.
5 illustrates an example of a method for storing bundle information in a second database for storing bundle information according to embodiments.
6 illustrates an example of item mapping information (fourth information) included in bundle information according to embodiments.
7 shows an example of a method for managing item bundle information according to embodiments.

Hereinafter, embodiments of the present invention will be described in detail with reference to the accompanying drawings.

In describing the embodiments, descriptions of technical contents that are well known in the technical field to which the present invention pertains and are not directly related to the present invention will be omitted. This is to more clearly convey the gist of the present invention without obscuring it by omitting unnecessary description.

For the same reason, in the accompanying drawings, some components are exaggerated, omitted, or schematically illustrated. Also, the size of each component does not entirely reflect the actual size. In each figure, the same reference number is assigned to the same or corresponding component.

Advantages and features of the present invention, and methods for achieving them, will become clear with reference to the embodiments described below in detail in conjunction with the accompanying drawings. However, the present invention is not limited to the embodiments disclosed below, but may be implemented in various different forms, and only the present embodiments make the disclosure of the present invention complete, and common knowledge in the art to which the present invention belongs It is provided to fully inform the holder of the scope of the invention, and the present invention is only defined by the scope of the claims. Like reference numbers designate like elements throughout the specification.

At this time, it will be understood that each block of the process flow chart diagrams and combinations of the flow chart diagrams can be performed by computer program instructions. These computer program instructions may be embodied in a processor of a general purpose computer, special purpose computer, or other programmable data processing equipment, so that the instructions executed by the processor of the computer or other programmable data processing equipment are described in the flowchart block(s). It creates means to perform functions. These computer program instructions may also be stored in a computer usable or computer readable memory that can be directed to a computer or other programmable data processing equipment to implement functionality in a particular way, such that the computer usable or computer readable memory The instructions stored in are also capable of producing an article of manufacture containing instruction means that perform the functions described in the flowchart block(s). The computer program instructions can also be loaded on a computer or other programmable data processing equipment, so that a series of operational steps are performed on the computer or other programmable data processing equipment to create a computer-executed process to generate computer or other programmable data processing equipment. Instructions for performing processing equipment may also provide steps for performing the functions described in the flowchart block(s).

Additionally, each block may represent a module, segment, or portion of code that includes one or more executable instructions for executing specified logical function(s). It should also be noted that in some alternative implementations it is possible for the functions mentioned in the blocks to occur out of order. For example, it is possible that two blocks shown one after another may in fact be executed substantially in parallel, or that the blocks may sometimes be executed in reverse order depending on their function.

At this time, the term '~unit' used in this embodiment means software or a hardware component such as FPGA or ASIC, and '~unit' performs certain roles. However, '~ part' is not limited to software or hardware. '~bu' may be configured to be in an addressable storage medium and may be configured to reproduce one or more processors. Therefore, as an example, '~unit' refers to components such as software components, object-oriented software components, class components, and task components, processes, functions, properties, and procedures. , subroutines, segments of program code, drivers, firmware, microcode, circuitry, data, databases, data structures, tables, arrays, and variables. Functions provided within components and '~units' may be combined into smaller numbers of components and '~units' or further separated into additional components and '~units'. In addition, components and '~units' may be implemented to play one or more CPUs in a device or a secure multimedia card.

1 shows an example of internal components of an electronic device according to embodiments.

Referring to FIG. 1 , internal components of the electronic device 100 are not limited to the illustrated components. The electronic device 100 may include at least one of a processor 110 , a transceiver 120 , and a memory 130 .

The processor 110 may process a series of steps for performing a method for managing item bundle information according to various embodiments of the present disclosure. The processor 110 may control other elements of the electronic device 100 . Meanwhile, in an embodiment, a product may be used as a term referring to a specific item, and the item may be sold to a user in a service related to the electronic device 100 .

The processor 110 may receive first information about a plurality of items, receive second information related to mapping of the plurality of items, and store the first information and the second information as a relational database. may be stored in a first database, the first information and the second information are read from the first database, and bundle information for the plurality of items is obtained based on the read first and second information. The bundle information may be created, and the bundle information may be stored in a second database that is a non-relational database. Programs or computer readable instructions executed by the processor 110 may be previously stored in the memory 130 or may be received from the outside through the transceiver 120 . The processor 110 may provide the first page to the display of the electronic device 100 .

The transceiver 120 transmits information stored in the memory 130 of the electronic device 100 or information processed by the processor 110 to another device, or functions to receive information from another device to the electronic device 100. can be done

The memory 130 is a configuration implemented in a predetermined storage space of the electronic device 100, and may include a database in which functions such as storage, search, deletion, editing, or addition of data can be freely performed. there is. For example, the memory 130 may include fields or components for processing functions such as data storage, search, deletion, editing, or addition. The memory 130 may store data related to the electronic device 100 performing an information providing method. For example, the memory 130 may store instructions or data for an execution operation of the processor 110 . The memory 130 according to embodiments may include a database for storing information on items and the like. The memory 130 according to embodiments may include at least one of a first database that is a relational database for the first information and the second information and a second database that is a non-relational database for bundle information.

2 illustrates an example of an electronic device performing a method for managing item bundle information according to embodiments.

Referring to FIG. 2 , an electronic device according to embodiments includes an item information processor 20, an item bundling processor 21, a first database 21b as a relational database, a second database 21c as a non-relational database, and rendering. At least one of the processing units 22 may be included.

The item information processing unit 20 according to embodiments receives information (first information) about items from one or more item information sources 20a. The information on the item (first information) may include an item identifier for identifying the item and a vendor identifier for identifying a vendor indicating a supplier of the item.

One or more sources 20a that transmit information about items to the electronic device according to embodiments may be, for example, a retail seller or a wholesale seller that sells the item, or an item sold by the retail seller or the wholesale seller. It may also be an external device that stores information about them.

The item information processor 20 according to embodiments may include a front-end interface 201 for receiving information on items from one or more sources 20a. The front-end interface 201 is, for example, one or more user interfaces (User Interfaces) 201a with which a retail seller or wholesale seller interacts to deliver a sale item to an electronic device, or a user interface that manipulates or controls the user interface 201a. It may include a handler (Handler, 201b). Some of the one or more sources may be directly received by the electronic device through one or more user interfaces 201a, and others may be received through the handler 201b.

The item information processing unit 20 according to embodiments may transmit information on items received from one or more sources 20a to the backend processing unit 202 . The back-end processing unit 202 may convert information on items received from one or more sources 20a into a data structure that can be processed by the item bundling processing unit 21 according to embodiments, and one or more sources ( It may be checked whether the information on the items received from 20a) is information received by a legitimate user.

The backend processing unit 202 according to embodiments may include one or more authentication units 202a for verifying whether information on items received from one or more sources 20a is information received by a legitimate user. can The backend processing unit 202 according to embodiments may include an adapter unit 202b that converts information about received items into a data structure that can be processed by the item bundling processing unit 21 according to embodiments. there is.

The backend processing unit 202 according to embodiments may transmit information on authenticated and converted items to the item bundling processing unit 21 according to embodiments.

Meanwhile, the electronic device according to embodiments may further include a first database 21b for storing information and/or mapping information on items processed by the item bundling processing unit 21 . That is, the first database 21b is a relational database, and may store information about items and mapping information in a plurality of tables.

Information (first information) on an item according to embodiments includes source item information indicating a source item that is necessarily selected for mapping of an item to be applied, and at least one target item associated with the source item ( target item) may be included.

Meanwhile, when the electronic device according to embodiments includes only the first database 21b, it may be difficult for the electronic device to provide promotion information to a user using an item selling service without delay. For example, when the electronic device includes only the first database 21b, promotion information applied to a specific item and other items that the user must additionally purchase in order to apply the promotion to the specific item (eg, source item) When a query is made to the electronic device to obtain information on items (eg, target items), the electronic device must perform an operation such as combining and joining several tables included in the first database. do. In addition, when the promotion information is updated or the status of an item to which a promotion is applied is changed (for example, when a specific item to which a promotion is applied is out of stock), the electronic device is a relational database according to a user's query. It is necessary to query the first database again and perform various operations. This configuration is vulnerable to a race condition and a risk of data collision in the process of querying the first database, which is a relational database into which data is sequentially inserted.

Accordingly, the electronic device according to the embodiments includes a second database 21c for immediately providing promotion information and items to which the corresponding promotion is applied to the user when a user inquires or inquires about a specific item without a race condition or risk of data collision. may further include.

In the second database 21c according to embodiments, when a user queries or inquires about a source item (or a category of the source item), promotion information applied to the corresponding source item, information related to a mapping relationship, and the corresponding source item Bundle information configured to immediately check information on target items related to is stored. The second database 21c according to embodiments may be a non-relational database for storing bundle information, and furthermore, the second database 21c may be a NoSQL-based database.

The electronic device according to embodiments may extract bundle information on a corresponding source item from the second database according to embodiments in response to a query for promotion information on a source item that a user intends to purchase, and the extracted bundle The information may be transmitted to the interstellar unit 22 that renders the bundle information on a page provided to the user (eg, an item detail page).

Bundle information according to embodiments may be generated by some or all of the operations of the first database and item bundling processing unit 21 according to embodiments.

The item bundling processing unit 21 may include an item information receiving unit 210, a mapping information receiving unit 211 receiving mapping information related to mapping of items, a CRUD processing unit 212, and a data processing unit 213.

The item information receiving unit 210 according to embodiments may receive information about items received from the item information processing unit 20 according to embodiments and authenticated and converted. For example, the item information receiving unit 210 may receive information on items authenticated and converted by the backend processing unit 202 using one or more application programming interfaces (APIs). The item information receiving unit 210 according to embodiments may parse information on items and transmit data included in the parsed item information to the CRUD processing unit 212 according to embodiments.

The mapping information receiving unit 211 according to embodiments may receive mapping information for indicating mapping of items or a relationship between items. The mapping of items may include, for example, information about a promotion (benefit) applied when purchasing specific items together, or information about items to which a promotion is applied. That is, the mapping information may include, for example, information about the type of item mapping (eg, promotion, free gift, etc.) and items to which the corresponding mapping is applied.

Examples of mapping of items may be as shown in Table 1 below, for example.

of mapping type example Dominant item and attached item Washing machine and 2-year warranty product applied to the washing machine Main item and secondary item A smartphone case compatible with company A's smartphone and company A's smartphone When purchasing item X, offer a discount on item(s) Y at a specific discount rate (e.g., 10%) (Buy X Get Y 10%) Company A's smartphone and a display cover compatible with Company A's smartphone (10% discount provided when purchased together) Recommended items HDMI cable required for installation of Company G's TV set-top box and TV Items related to the fresh item Bread, peanut butter, strawberry jam Multiple fashion items (sets) shown in the image displayed on the product detail page shirts, trousers, shoes, etc. Category of items related to fresh item milk category and cereal category, etc.

Referring to [Table 1] above, mapping of items may be defined as a relationship applicable to at least two items or at least two item categories. Accordingly, mapping information according to embodiments may include, for example, information on a first group item (or item category) and a second group item (or item category) to which mapping can be applied, and mapping When this is applied, information defining or describing the corresponding mapping may be further included. An electronic device according to embodiments may receive mapping information from a device or server 21a that provides a Product Mapping Service (PMS).

The CRUD processing unit 212 according to embodiments performs a task for inserting or updating information about items according to embodiments and mapping information according to embodiments into a first database and a second database according to embodiments. carry out The CRUD processing unit 212 according to embodiments creates data to be inserted into the first database 21b and the second database 21c according to embodiments, searches data in the database (read), and updates ( update) and delete operations.

The CRUD processing unit 212 according to embodiments processes information on items according to embodiments and mapping information according to embodiments, and converts the processed information into an item bundle mapping table (first database) included in the first database. table) and item bundle mapping group table (second table). An item bundle mapping table according to embodiments may be referred to as a first table, a first schema, and the like, and an item bundle mapping group table may be referred to as a second table and a second schema.

The first database 21b according to embodiments may include a first table and a second table according to embodiments as a schema, and each table may include, for example, one or more primary keys Or it can be related to a foreign key. The first table and the second table according to the embodiments will be described in detail in FIGS. 3 and 4 .

The data processing unit 213 according to embodiments may search information on items according to embodiments and mapping information (eg, information included in the first database) according to embodiments, and search Bundle information to be stored in the second database according to embodiments may be generated by processing information and mapping information on the selected items. Bundle information according to embodiments will be described in detail with reference to FIG. 5 . The data processing unit 213 according to embodiments may query data included in the first database 21b and process the retrieved data in association with the operation of the CRUD processing unit 212 according to embodiments. In addition, the data processing unit 213 generates bundle information by processing the information received from the item information receiving unit 210 and the mapping information receiving unit 211 according to the embodiments in association with the operation of the CRUD processing unit 212. may be

The item bundling processing unit 21 according to embodiments inserts or updates bundle information processed and generated by the CRUD processing unit 212 or data processing unit 213 according to embodiments into a second database according to embodiments do.

On the other hand, for example, when a specific item is sold out, mapping information associated with the sold-out item and other items associated with the sold-out item (eg, other items to which a promotion is applied when purchased together with the sold-out item) items) must be changed in the second database. In this case, there may be a plurality of changed items in the second database, and when a plurality of items are updated or inserted at the same time, a data conflict may occur. Accordingly, the item bundling processing unit according to embodiments may further include a queue 214a to sequentially update or insert items of bundle information updated or inserted into the second database. The item bundling processing unit 21 according to embodiments includes a queue producer 214 for sequentially sorting and inserting or pushing bundle information to be updated or inserted into the queue 214a, and bundles inserted into the queue 214a. In order to insert the information into the second database 21c, a queue consumer 215 that sequentially retrieves bundle information may be further included.

An electronic device according to embodiments stores and manages information about items and promotion information applied to items in a relational database and a non-relational database, respectively, so that items and promotion information requested by a user can be provided without additional computational burden and unnecessary delay. can respond immediately.

When a user inquires or inquires about a specific item, the electronic device according to embodiments may immediately provide promotion information and items to which the corresponding promotion is applied to the user without a race condition or risk of data collision.

3 shows an example of an item bundle mapping table (first table) according to embodiments.

The first table according to the embodiments shown in FIG. 3 may refer to an item bundle mapping table included in the first database shown in FIG. 2 . The item bundle mapping table (first table) stores, for example, information describing items applied to specific mapping information. For example, the first table includes a source item (eg, identification information identifying the source item or information indicating the category of the source item, etc.) that is necessarily selected for a specific mapping to be applied. Target items (for example, identification information for identifying the target item or information indicating the category of the target item, etc.) are included for each item.

For example, referring to FIG. 3 , the first table according to the embodiments includes source item information for representing a source item and target item information for representing a target item.

The source item information may include, for example, a source item identifier (sourceItemId) parameter and a source item type (sourceItemType) parameter. The Source Item Type parameter defines what the value of the Source Item Identifier parameter means. For example, when 'CATEGORY' is source_item_type and the source item identifier parameter is '10', the source item may be defined as an item having an item category value of 10. Also, for example, when 'VENDOR_ITEM' is source_item_type, an item having an identifier value of 200 for a product sold by a specific vendor may be defined.

Similarly, the target item information may include, for example, a target item identifier (sourceItemId) parameter and a target item type (sourceItemType) parameter. The Target Item Type parameter defines what the value of the Target Item Identifier parameter means. For example, when source_item_type is 'CATEGORY' and the target item identifier parameter is '10', the target item may be defined as an item having an item category value of 10.

The first table according to the embodiments may further include a table identifier (id) for identifying each item representing the source item(s) and target item(s) shown in the first table, and the corresponding table identifier is It can be the primary key of 1 table.

The first table according to the embodiments is a requestor service for identifying a service or source from which the source item(s) and target item(s) shown in the first table are provided (or information on the item is provided and mapping is requested). It may further include identification information. Requester service identification information according to embodiments includes, for example, information identifying a requested service (or a source according to embodiments) (requesterService) and information identifying a request requested in the requested service (requesterServiceProvidedId). can include

Requester service identification information (eg, requesterService and requesterServiceProvidedId) according to embodiments are externally used by the electronic device to combine (or join) the first table and the second table to generate bundle information according to embodiments. It may be a foreign key. That is, requester service identification information (eg, information in which requesterService and requesterServiceProvidedId are combined) in each item of the first table may be a foreign key used to combine the first table and the second table.

The first table according to embodiments may further include mapping status information indicating whether mapping between the source item(s) and the target item(s) shown in the first table is valid. For example, if the mapping status information (status) is AVAILABLE (or True), it indicates that the mapping of the source item (s) and target item (s) defined in the corresponding item is currently valid, and the mapping information indicates that it can On the other hand, for example, if the mapping status information (status) is DELETED (or False), it indicates that the mapping of the source item(s) and target item(s) defined in the item is not currently valid, and the It may indicate that mapping information associated with the source item(s) and the target item(s) is deleted or that the mapping is not valid even though it is not deleted.

The first table according to embodiments may further include information indicating a priority for mapping of source item(s) and target item(s) shown in the first table. For example, when the priority for mapping is low, the mapping of corresponding source item(s) and target item(s) may be exposed to service users as a lower priority. For example, the electronic device according to embodiments may read bundle information from the second database according to embodiments. An electronic device according to embodiments may provide the read bundle information to a user's terminal. In a process of providing the read bundle information to a user's terminal, the electronic device according to embodiments selects at least one target item included in corresponding bundle information based on a display order determined based on seventh information included in the bundle information. It can be displayed (or controlled to be displayed) on the user's terminal.

4 shows an example of an item bundle mapping group table (second table) according to embodiments.

The second table according to the embodiments shown in FIG. 4 may mean an item bundle mapping group table included in the first database shown in FIG. 2 . The item bundle mapping group table (second table) stores information describing specific mapping information, for example. For example, the second table includes bibliography and detailed information on each mapping information.

For example, referring to FIG. 4, the second table according to the embodiments stores mapping information for mapping items, and includes a table identifier (id) identifying an item describing each mapping information, requestor service identification information (for example, requesterService and requesterServiceProvidedId), requester owner information indicating the owner of the requester (requesterOwnerId), type information of each mapping (mappingType), property information of each mapping (mappingProperties), and priority information of each mapping (priority) , effective date information (effectiveDate) of each mapping, status information (status) of each mapping, creation time information (createdAt) of each mapping, last updated update time information (updatedAt) of each mapping, creation subject information (createdBy) , update subject information (updatedBy), bidirectional mapping information (bidirectionalMapping), and metadata including additional information.

A table identifier (id) according to embodiments may be a primary key of the second table.

The requester service identification information (eg, requesterService and requesterServiceProvidedId) may be the subject of the service that transmits mapping information and/or information on items according to embodiments (eg, wholesale/retail seller or related external server, etc.) ) can mean. The requestor service identification information may be a foreign key used by the electronic device to combine (or join) the first table and the second table in order to generate bundle information according to embodiments.

Requester service identification information according to embodiments may further include requester owner identification information (requesterOwnerId) for identifying an owner of the requested service. The requestor owner identification information may mean identification information for identifying an owner of corresponding mapping information. The requestor owner identification information may refer to identification information for identifying a vendor (eg, supplier) of an external system that allows various authentications capable of controlling mapping for item bundling.

Mapping type information (mappingType) indicates a type of mapping of items according to corresponding embodiments. For example, mapping type information includes a value indicating whether the mapping is a promotion relationship (BUNDLE_PROMOTION), a value indicating whether the mapping is contractually mapped (CONTRACT), and a value indicating whether the mapping is to recommend purchasing items together. It may be at least one of (RECOMMENDATION), a value indicating whether the source item and the target item(s) are related items (RELATED_ITEM), and a value indicating that the target item(s) are items related to insurance for the source item (INSURANCE).

The mapping property information (mappingProperty) may be information defining properties of the corresponding mapping. Attribute information of the mapping may have, for example, a JSON (JavaScript Object Notation) data structure of a map composed of pairs of strings. The electronic device according to embodiments may insert or update mapping information according to embodiments into a second database according to embodiments according to a value of attribute information of mapping.

The mapping property information (mappingProperty) may be, for example, information including a map having the syntax shown in [Table 2] below.

Property name values descriptions disablePartialCancellation "true", "false" If the corresponding parameter does not exist, the default setting value may be 'false'.
If the value of the corresponding parameter is 'true', it indicates that the mapping relationship between items to be mapped cannot be canceled arbitrarily.
If the value of the corresponding parameter is 'false', it indicates that the mapping relationship between items to be mapped can be canceled arbitrarily. mustBuyTogether "true", "false" If the corresponding parameter does not exist, the default setting value may be 'false'.
If the value of the corresponding parameter is 'true', the mapped target items may always be items that must be purchased together with the source item.
If the value of the corresponding parameter is 'false', it indicates that the mapped target items can be purchased separately. ?? Reserved

Priority information of mapping may be information indicating a priority of corresponding mapping information according to embodiments. Effective date information (effectiveDate) of mapping represents a date when corresponding mapping information according to embodiments becomes effective. Mapping expiration date information (expiryDate) indicates a date when corresponding mapping information according to embodiments is terminated. Mapping status information (status), source item (s) and target items (shown in the first table) s) may further include mapping status information indicating whether mapping is valid. For example, if the mapping status information (status) is AVAILABLE (or True), it indicates that the mapping of the source item (s) and target item (s) defined in the corresponding item is currently valid, and the mapping information indicates that it can On the other hand, for example, if the mapping status information (status) is DELETED (or False), it indicates that the mapping of the source item(s) and target item(s) defined in the item is not currently valid, and the It may indicate that mapping information associated with the source item(s) and the target item(s) is deleted or that the mapping is not valid even though it is not deleted.

The mapping creation time information (createdAt) may be information indicating a time when corresponding mapping information according to embodiments is created. The updated time information (updatedAt) may be information indicating a last updated time of corresponding mapping information according to embodiments. The creation subject information (createdBy) may be information indicating a subject for which corresponding mapping information according to embodiments was created. The update subject information (updatedBy) may be information indicating a subject whose corresponding mapping information according to embodiments was last updated.

The bidirectionalMapping information may be information indicating whether the mapped source item(s) and target item(s) have a unidirectional or bidirectional mapping relationship. For example, when the value of the bidirectional information is 0, the electronic device configures the user to purchase related target items together when the user selects a source item, whereas when the user selects an individual target item, the associated source item It can be set not to be selected. For example, when the value of the bidirectionality information is 1, the electronic device configures the user to purchase related target items together when the user selects a source item, and at the same time sets the associated source item when the user selects an individual target item. It can also be set to be selectable.

Metadata may include additional information related to the corresponding mapping.

5 illustrates an example of a method of storing bundle information of a second database for storing bundle information according to embodiments.

Bundle information according to the embodiments shown in FIG. 5 may refer to bundle information according to embodiments stored in the second database 21c shown in FIG. 2 . Bundle information of an item may include, for example, one or more target items related to a specific source item (or category of the source item) and information about the corresponding mapping.

Bundle information according to embodiments may be generated by combining and/or joining the first table and the second table included in the first database according to embodiments based on requester service identification information included in each table. can Accordingly, bundle information according to embodiments may be information in which target item(s) associated with a corresponding source item and mapping information associated with a corresponding source item are organized for each source item.

Accordingly, referring to FIG. 5 , bundle information according to embodiments includes source item information, mapping type information (mapping_type) for corresponding bundle information, requestor service identification information, item mapping information (item_mapping), and mapping property information (mapping_properties). can include

Referring to FIG. 5 , source item information included in bundle information according to embodiments represents information for identifying a source item according to embodiments. For example, the source item information includes a source item identifier (source_item_id) parameter and A source item type (source_item_type) parameter may be included. A source item identifier (source_item_id) parameter and a source item type (source_item_type) parameter alone or in combination may be a primary key used to identify bundle information according to embodiments. Source item information included in bundle information according to embodiments may be referred to as third information.

The source item identifier (source_item_id) parameter included in the bundle information may be, for example, a source item identifier (sourceItemId) derived in a process in which the electronic device combines and/or joins the first table and the second table in the first database. there is. Similarly, the source item type (source_item_type) parameter included in the bundle information may be a source item type (sourceItemType) parameter derived in a process in which the electronic device combines and/or joins the first table and the second table in the first database. .

A source item type (source_item_type) parameter in bundle information according to embodiments defines what a value of a source item identifier (source_item_id) parameter means. For example, when 'CATEGORY' is source_item_type and the source item identifier parameter is '10', the source item may be defined as an item having an item category value of 10. Also, for example, when 'VENDOR_ITEM' is source_item_type, an item having an identifier value of 200 for a product sold by a specific vendor may be defined.

Referring to FIG. 5 , mapping_type information included in bundle information according to embodiments indicates a type of mapping corresponding to corresponding bundle information. For example, it may be mapping type information (mappingType) derived in a process in which the electronic device combines and/or joins the first table and the second table in the first database.

Referring to FIG. 5 , requester service identification information (requester_service, requester_service_providedId alone or a combination thereof) included in bundle information according to embodiments is mapping information according to embodiments and/or service information about items transmitted. It may mean a subject (eg, a wholesale/retail seller or a related external server). The requester service identification information may be a requester service identification information (requesterService, requesterServiceProvidedId alone or a combination thereof) parameter derived in a process of combining and/or joining the first table and the second table in the first database by the electronic device. Requestor service identification information included in bundle information according to embodiments may be unique information (unique key) of each item of bundle information according to embodiments.

Referring to FIG. 5 , item mapping information (item_mapping) included in bundle information according to embodiments is related (or mapping) to a source item (ie, source_item_id and/or source_item_type) according to embodiments corresponding to bundle information. It may be information indicating the target item(s). Item mapping information (item_mapping) according to embodiments may be data expressed in JSON format, for example. Item mapping information according to embodiments may be data having a syntax shown in FIG. 6 . An example of item mapping information will be described with reference to FIG. 6 . Item mapping information according to embodiments may be called, for example, fourth information.

Referring to FIG. 5 , mapping property information (mapping_properties) included in bundle information according to embodiments may be information representing properties of a mapping corresponding to bundle information according to embodiments. Mapping property information included in bundle information according to embodiments may be derived from mapping property information (mappingProperties) in the second table according to the embodiments shown in FIG. 4 . That is, the mapping property information included in the bundle information may be mapping property information (mappingProperties) derived in a process in which the electronic device combines and/or joins the first table and the second table in the first database. Mapping property information (mapping_properties) may have a syntax shown in [Table 3], for example.

property name values descriptions defaultItemType "VENDOR_ITEM", etc. The default value within the item_mappings column mustBuyTogether "true", "false" When the corresponding parameter does not exist, the default setting value may be 'false'. If the value of the corresponding parameter is 'true', the mapped target items may always be items that must be purchased together with the source item.
If the value of the corresponding parameter is 'false', it indicates that the mapped target items can be purchased separately. maxApplicableBundlePromotion "1", "2", "3" ... The maximum number of bundled items (i.e., target items corresponding to source items) that the bundle promotion can be applied to. In the front end, the electronic device may restrict the customer from selecting more items than this value among target items to which a mapping corresponding to the bundle information is applied. PARTIAL_PURCHASABLE "true", "false" If the corresponding parameter does not exist, the default setting value may be 'false'. If the value of the corresponding parameter is "false", bundled items (eg, target items corresponding to the source item) are used alone. Can be set to disable ordering. PARTIAL_EXCLUDABLE "true", "false" If the corresponding parameter does not exist, the default setting value may be 'false'. If the value of the corresponding parameter is "false", bundled items (eg, target items corresponding to the source item) are used alone. Indicates that it cannot be excluded. PARTIAL_REFUNDABLE "true", "false" If the corresponding parameter does not exist, the default setting value may be 'false'. If the value of the corresponding parameter is "false", bundled items (eg, target items corresponding to the source item) are used alone. Indicates that refunds are not possible. PARTIAL_EXCHANGABLE "true", "false" If the corresponding parameter does not exist, the default setting value may be 'false'. If the value of the corresponding parameter is "false", bundled items (eg, target items corresponding to the source item) are used alone. Indicates that they cannot be exchanged. ... reserved

Bundle information according to embodiments may be information generated based on data included in the first table and the second table included in the first database according to embodiments. Accordingly, the bundle information according to the embodiments includes effective date information (effective_date), expiration date information (expiry date), status information (status), title information (title), description information (description), priority as shown in FIG. It may further include priority information and version information indicating a version. An electronic device according to embodiments may store information on items and promotion information applied to items in a relational database and a non-relational database, respectively. By storing and managing, it is possible to respond immediately to items and promotional information requested by users without additional computational burden and unnecessary delay.

When a user inquires or inquires about a specific item, the electronic device according to embodiments may immediately provide promotion information and items to which the corresponding promotion is applied to the user without a race condition or risk of data collision.

6 illustrates an example of item mapping information (fourth information) included in bundle information according to embodiments.

Item mapping information according to the embodiments shown in FIG. 6 may mean, for example, an item mapping information (item_mappings) parameter included in bundle information shown in FIG. 5 . 600 of FIG. 6 represents syntax of item mapping information (fourth information), and 601 to 602 represent examples of item mapping information based on the syntax shown in 600 .

Item mapping information according to embodiments may be information representing information on target items related to source item(s) of bundle information in a list form. As shown in 601 to 602, information on each target item may be expressed in a data structure in the form of a map or dictionary separated by braces, and item mapping information is each target item separated by braces. It may be a list-type data structure including a map or dictionary-type data structure for .

600 of FIG. 6 represents a syntax of information about each target item included in the item mapping information in 601 to 602 . Referring to 600 of FIG. 6 , information on each target item may include at least one of identifier information (itemId) of the target item, type information (itemType) of the target item, and group item information (groupItems). there is.

Type information (itemType) may be type information necessary to specify a target item. The identifier information (itemId) may be identification information for a type specified in type information (itemType). For example, when the value of the type information (itemType) is 'VENDOR_ITEM' and the value of the identifier information (itemId) is '10', the target item is VENDOR_ITEM, that is, the item whose vendor item value is 10 is the target item. can be defined as

Group item information (groupItems) means group items grouped together with a target item specified by identifier information (itemId) of a corresponding target item and type information (itemType) of the corresponding target item according to embodiments. can do.

A group item grouped with a specific item may mean, for example, an item of the same kind as a specific item and different in some attributes (eg, size, color, etc.). For example, a group item grouped together with a white mobile phone case may include a yellow mobile phone case and a purple mobile phone case of the same type. Also, for example, the group items grouped together in the pattern A may include a yellow mobile phone case and a purple mobile phone case of the same type.

7 shows an example of a method for managing item bundle information according to embodiments.

Some or all of the operations 700 to 704 of the item bundle information management method according to the embodiments shown in FIG. 7 may be performed by an electronic device according to the embodiments.

Referring to FIG. 7 , the electronic device may receive first information about a plurality of items (700). First information according to embodiments includes source item information indicating a source item necessarily selected for mapping to be applied, and source item information indicating at least one target item associated with the source item. can include

Referring to FIG. 7 , the electronic device may receive second information related to mapping of the plurality of items (701).

Referring to FIG. 7 , the electronic device may store the first information and the second information in a first database that is a relational database (702).

A first database according to embodiments may include a first table for representing the source item and the at least one target item, and a second table including the second information related to the mapping. The first table and the second table according to embodiments may each include requester service identification information (eg, requesterService, requesterServiceProviderId alone or a combination thereof) for identifying a requester service. For example, the first table according to embodiments may refer to the item bundle mapping table (first table) shown in FIG. 3, and the second table may refer to the item bundle mapping group table (second table) shown in FIG. 4. can mean

The second table according to embodiments includes fifth information indicating the type of mapping of items according to embodiments, sixth information indicating properties of the mapping, seventh information indicating priority of the mapping, and validity of the mapping. At least one of the eighth information indicating time may be further included.

The sixth information according to embodiments may further include information indicating whether the source item and the at least one target item should be purchased together and whether some of the at least one target item may be excluded and purchased. there is.

Referring to FIG. 7 , the electronic device reads the first information and the second information from the first database, and bundle information on the plurality of items based on the read first and second information. can be created (703). Bundle information according to embodiments may be generated based on requestor service identification information included in the first table and the second table.

The reading step according to embodiments may include checking bundle information including an item selected by a user as a source item in a second database, and selecting at least one target associated with the item selected by the user included in the checked bundle information. You can check the item.

Bundle information according to embodiments includes third information for indicating the source item (eg, source_item_id and source_item_type included in the table shown in FIG. 5 alone or in combination) and at least one target item associated with the source item. It may include at least one of the fourth information (eg, item_mapping shown in FIG. 5) indicating the . Third information according to embodiments may be a primary key of the second database in which the bundle information is stored.

Bundle information according to embodiments may be stored in the second database according to embodiments in the form of a table shown in FIG. 5 , for example. Bundle information according to embodiments may further include, for example, fourth information according to embodiments shown in FIG. 6 . Bundle information according to embodiments may be generated based on requester service identification information included in the first table and the second table.

Referring to FIG. 7 , the electronic device may store the bundle information in a second database that is a non-relational database (704).

The electronic device according to embodiments further performs the steps of reading bundle information about an item selected by the user using the item selling service from the second database, and providing the read bundle information to the terminal of the user. can do. In the step of reading according to embodiments, bundle information including the item selected by the user as a source item may be checked in the second database, and at least one item related to the item selected by the user included in the checked bundle information may be checked. You can check the target item of .

Providing the read bundle information to the user's terminal by the electronic device according to embodiments may include displaying the at least one target item based on a display order determined based on the seventh information included in the bundle information. can

Receiving, by an electronic device according to embodiments, update information about at least one of information about the mapping and information about the plurality of items; and updating the first database based on requestor service identification information included in the update information. In an electronic device according to embodiments, updating the bundle information based on requestor service identification information included in the update information and the first information and the second information in the updated first database, and the updated bundle At least one of the steps of storing information in the second database may be further included. Updating bundle information according to embodiments includes inserting the first information and the second information in the updated first database into a queue, and updating the bundle information in the order in which they are inserted into the queue. can

An electronic device according to embodiments stores and manages information about items and promotion information applied to items in a relational database and a non-relational database, respectively, so that items and promotion information requested by a user can be provided without additional computational burden and unnecessary delay. can respond immediately.

When a user inquires or inquires about a specific item, the electronic device according to embodiments may immediately provide promotion information and items to which the corresponding promotion is applied to the user without a race condition or risk of data collision.

On the other hand, preferred embodiments of the present invention have been disclosed in the present specification and drawings, and although specific terms have been used, they are only used in a general sense to easily explain the technical content of the present invention and help understanding of the present invention. It is not intended to limit the scope of the invention. It is obvious to those skilled in the art that other modified examples based on the technical idea of the present invention can be implemented in addition to the embodiments disclosed herein.

An electronic device or terminal according to the above-described embodiments includes a processor, a memory for storing and executing program data, a permanent storage unit such as a disk drive, a communication port for communicating with an external device, a touch panel, and a key ), user interface devices such as buttons, and the like. Methods implemented as software modules or algorithms may be stored on a computer-readable recording medium as computer-readable codes or program instructions executable on a processor. Here, the computer-readable recording medium includes magnetic storage media (e.g., read-only memory (ROM), random-access memory (RAM), floppy disk, hard disk, etc.) and optical reading media (e.g., CD-ROM) ), and DVD (Digital Versatile Disc). A computer-readable recording medium may be distributed among computer systems connected through a network, and computer-readable codes may be stored and executed in a distributed manner. The medium may be readable by a computer, stored in a memory, and executed by a processor.

This embodiment can be presented as functional block structures and various processing steps. These functional blocks may be implemented with any number of hardware or/and software components that perform specific functions. For example, an embodiment is an integrated circuit configuration such as memory, processing, logic, look-up table, etc., which can execute various functions by control of one or more microprocessors or other control devices. can employ them. Similar to components that can be implemented as software programming or software elements, the present embodiments include data structures, processes, routines, or various algorithms implemented as combinations of other programming constructs, such as C, C++, Java ( It can be implemented in a programming or scripting language such as Java), assembler, or the like. Functional aspects may be implemented in an algorithm running on one or more processors. In addition, this embodiment may employ conventional techniques for electronic environment setting, signal processing, and/or data processing. Terms such as "mechanism", "element", "means" and "composition" may be used broadly and are not limited to mechanical and physical components. The term may include a meaning of a series of software routines in association with a processor or the like.

The foregoing embodiments are merely examples and other embodiments may be implemented within the scope of the claims described below.

On the other hand, preferred embodiments of the present invention have been disclosed in the present specification and drawings, and although specific terms have been used, they are only used in a general sense to easily explain the technical content of the present invention and help understanding of the present invention. It is not intended to limit the scope of the invention. It is obvious to those skilled in the art that other modified examples based on the technical idea of the present invention can be implemented in addition to the embodiments disclosed herein.

Claims (1)

A method for managing item bundle information of an electronic device related to an item selling service, the method comprising:
Receiving first information including source item information for specifying a source item and target item information for specifying a target item associated with the source item;
Receiving second information including mapping type information and information for specifying one or more source items and target items related by the mapping type information;
storing the first information and the second information in a first database that is a relational database;
The first information and the second information are read from the first database, bundle information for a plurality of items is generated based on the read first information and the second information, and the second database is a non-relational database. storing in; and
reading the bundle information from the second database in response to a query for checking promotion information received from a terminal of a user using the item selling service; including,
The bundle information includes information on one or more target items related based on the source item and the mapping type information,
If the mapping type information corresponds to the first property, the one or more target items are set to be available for purchase when purchasing the source item, and if the mapping type information corresponds to the second property, the target item is also purchased when purchasing the source item. set to be
How to manage item bundle information.

Images