KR100661599B1 - method for building database for online search of off-line media advertisement and recording medium for the database thereby - Google Patents

Abstract

The present invention makes it possible to easily search offline media advertisements on the Internet, to compare and search various products advertised through offline media according to various conditions, and to immediately display detailed information of products that cannot be displayed on offline media. The present invention relates to a method for constructing a database for online retrieval of offline media advertisements that can be confirmed and reserved, and a database recording medium generated thereby.

According to an aspect of the present invention, a method for constructing a database for on-line search of an offline medium advertisement includes: (a) scanning an entire product advertisement image of an offline print medium; (b) dividing the vertical and horizontal lines along the boundary of each individual product advertisement image on the scanned whole product advertisement image and cutting each vertical product advertisement image into a separate product advertisement image file; (c) generating a separate product image input form by inputting the number of columns and rows obtained by the intersection of the horizontal line and the vertical line by a database construction tool; and (d) classifying goods for each cell of the individual product image input form. And assigning at least one condition value for searching, designating a storage path of each stored individual product advertisement image file, and assigning a unique individual product code to construct a database.

Travel, products, advertising, images, offline, links

Description

Method for building database for online search of off-line media advertisement and recording medium for the database

1 is a flowchart illustrating a method for constructing a database for online search of an offline media advertisement of the present invention;

Figure 2a is a diagram illustrating a scanned full product advertisement image,

2B and 2C are exemplary diagrams for explaining an individual product advertisement image input form generation step and the input form thus generated;

2D is an example screen for explaining a step of assigning various condition values to each cell of an individual product advertisement image input form and matching a corresponding individual product advertisement image file;

2E is an example screen for explaining a block designation step for completely restoring an image of a partially cut individual product advertisement;

3a is a diagram illustrating an individual product information table in an offline medium advertisement database constructed by the present invention;

3b is a diagram illustrating the number of columns of individual product advertisements for each entire product advertisement;

3c illustrates a row table of an individual product advertisement for each column of each total product advertisement;

3d is a diagram illustrating a block designation table for an individual product advertisement;

3e is a diagram illustrating a newspaper unique code table,

4 is a diagram illustrating a network for implementing an online search service of an offline media advertisement of the present invention;

5 is a flowchart showing an online search service process of an offline media advertisement of the present invention;

6A is an example screen illustrating a user interface for online search of an offline media advertisement image;

Figure 6b is an example screen showing the search results of the full product advertising image for a particular newspaper,

6C is an example screen showing an individual product advertisement image search result of all newspapers for a specific region.

*** Explanation of symbols for the main parts of the drawing ***

10: client, 12: mobile client,

14: wired PC client, 20: Internet,

30: search service provider, 32: search server,

34: offline media ad database,

40, 50: travel agency, 42, 52: travel agency server,

44, 54: Travel agency database

The present invention provides a method for constructing a database for online search of an offline media advertisement, which supports the selection and search and comparison of various product advertisement images contained in an offline medium according to a desired condition online, thereby facilitating related commerce. And to a database carrying medium generated thereby.

Currently, the existing travel agency's sales method is heavily dependent on the advertising business through offline newspaper advertising. The offline business advertising business is based on the consumer's advertisements and phone the travel agency to find out the details or directly. It is in the form of visiting and consulting. On the other hand, with the development of electronic communication technology, online sales methods such as the Internet are gradually being activated. Currently, most major travel agencies display travel products on web pages through internet sites in addition to sales methods through offline newspaper advertising. It is also operated as an online sales system that accepts reservations.

However, the current offline and online travel agency sales method is operated separately without any connection between the two, there is a problem that the advertising efficiency is significantly reduced. In other words, in the case of sales through off-line advertising, consumers should look for newspaper advertisements and check the products in the region they want to go to. In this process, in order to compare various products, check the travel agency products of the same newspaper or several newspapers. Efforts and efforts should be made to review them. In addition, in the case of travel products advertised in newspapers, due to the limited advertising space of newspapers, only the most basic items such as product prices and travel dates are posted. Therefore, it is inevitable to call or visit a travel agency for details. . Therefore, in order to compare products of various travel agencies, it is necessary to call or visit various travel agencies to compare / analyze and select prices and product conditions.

On the other hand, even in the case of the existing travel agency operating method through the online media, there is a problem in that the expenses are doubled because they are operated separately without being connected with the offline media advertisement. In addition, in order to select a travel product from a consumer's point of view, it is necessary to visit various travel agency newspaper advertisements or sites, whether offline or online, to compare and analyze the products in various ways, and to select the product that is most suitable for the consumer himself at the lowest cost. There is a problem that must suffer a lot of time and effort because it can.

The present invention has been made to solve the above-described problems, to make it easy to search offline media advertising on the Internet, to compare and search the various products advertised through the offline media according to various conditions, offline It is an object of the present invention to provide a database construction method for online search of offline media advertisements and a database recording medium generated by the detailed information of a product which cannot be displayed on a medium, so that reservations can be made immediately.

According to an aspect of the present invention, there is provided a method for constructing a database for an online search of an offline media advertisement, including: (a) scanning an entire product advertisement image of an offline print media; (b) dividing the vertical and horizontal lines along the boundary of each individual product advertisement image on the scanned whole product advertisement image and cutting each vertical product advertisement image into a separate product advertisement image file; (c) generating a separate product image input form by inputting the number of columns and rows obtained by the intersection of the horizontal line and the vertical line by a database construction tool; and (d) classifying goods for each cell of the individual product image input form. And assigning at least one condition value for searching, designating a storage path of each stored individual product advertisement image file, and assigning a unique individual product code to construct a database.

Hereinafter, with reference to the accompanying drawings will be described in detail a preferred embodiment of the database construction method for the online search of the offline media advertising of the present invention and the database recording medium generated thereby, taking a travel product as an example, Offline media will be explained using newspapers as an example.

1 is a flowchart illustrating a database construction method for an online search of an offline media advertisement of the present invention. First, in step S10 of FIG. 1, a travel product advertisement image posted on a specific page of a newspaper is scanned through a scanner. In the case of a travel product advertisement of a newspaper, a plurality of individual product advertisements are displayed in a group. Hereinafter, the entire product advertisement, which is displayed in groups on one side of the newspaper, is referred to as the 'all product advertisement'.

2A is a diagram illustrating the scanned whole product advertisement image. As shown in FIG. 2A, the overall product advertisement image is often larger than the A4 size. In this case, the scan is divided into a first scan portion and a second scan portion, as shown.

Next, in step S20, the scanned entire product advertisement image file is stored. As described above, when the scan is divided into a plurality of parts, the image product is integrated into one image file by using an image editing tool such as Photoshop.

In step S22, the entire product advertisement image file stored as described above is read through an image editing tool, divided into individual product advertisement images, and cut, and each of them is stored as an individual product advertisement image file in step S24. However, since most of the individual product advertisements are displayed in the form of a rectangular box, the vertical lines are divided along the boundaries of the individual product advertisement images throughout the upper and lower widths of the individual product advertisement images in the segmentation cutting process, and then each vertical line is divided again. The horizontal lines are cut along the upper and lower boundaries of the individual product advertisement image.

In this process, the boundary of the left or right side of one individual product advertisement image may deviate from the left or right boundary of another individual product advertisement image on the upper side or the lower side, so that one individual product advertisement image is centered on an arbitrary vertical line. It may be cut into two or more parts, but in this case, it may be restored to an intact individual product image through a block designation step as described below. In FIG. 2A, portions marked in red represent vertical and horizontal lines, respectively. Hereinafter, each vertical partition line is defined as 'columns', horizontal partition lines are defined as 'rows', and a space formed by each column and row is defined as 'cells'.

Next, in step S30, a unique full product code is assigned to the entire product advertisement image to be handled at present, but this step S30 may be automatically given by the unique serial number system. In a subsequent step S32, the individual product advertisement image input form is generated by inputting the number of columns partitioned in step S22 and the number of rows for each column. FIG. 2B is an exemplary diagram for explaining an individual product advertisement image input form generation step, and FIG. 2C is an exemplary view showing the individual product advertisement image input form generated in this way.

In the overall product advertisement image of FIG. 2A, the number of columns is 5, and assuming that the number of rows for each column is 15, 18, 9, 12, and 11, in order, input 5 in the blank indicating the number of columns. In this case, a blank space for inputting the number of rows for each column is generated. When the number of rows is input to the blanks generated, and the 'OK' button is pressed, as shown in FIG. An individual product advertisement image input form is generated.

For each cell of the individual product advertisement image input form generated as described above, a unique individual product code is automatically assigned in the order of the top to the bottom of each column, and each individual product code is uniquely assigned within the entire product code. (Relatively unique individual product codes) or uniquely assigned (absolutely unique individual product codes) within the entire database.

Meanwhile, in order to provide a search service according to various conditions in addition to the unique individual product code, it is necessary to assign various condition values to each individual product advertisement. For this purpose, in step S34, a corresponding condition for each cell of the generated input form is provided. After assigning the value, the path of the location where the individual product advertisement image file exists is matched.

2D is an exemplary screen for explaining a step of assigning various condition values to an individual product advertisement image input form and matching a corresponding individual product advertisement image file. As shown in FIG. 2D, the first blank on the right side of 'Entering Code' is a field for inputting a newspaper code C1 uniquely assigned to a newspaper company in which the entire product advertisement image is displayed. The two blanks that come in are fields for entering the pre-uniquely assigned travel agency code (C2) for the advertiser, that is, the travel agency, and the next blank is the travel type, eg package, honeymoon, golf. A travel type code (C3) uniquely assigned in advance for a travel type such as travel, training, backpacking or filial piety tourism, and the next blank is a travel area code uniquely assigned in advance for various travel areas. (C4) is a field to enter, and the following spaces are the unique product code (C5) input fields described above.

In addition, the 'image path' button at the bottom of the individual product advertisement image can be used to designate the path of the location where the individual product advertisement image exists, and in the 'URL input' field for linking with the online web page, The storage location of the web page containing the detailed information about the product advertisement is entered.

In step S36, an individual product advertisement table for all the product advertisements thus obtained is constructed and stored. Next, in steps S38 and S40, block designation is performed on partial images cut into two or more parts in order to generate an intact individual product advertisement image, thereby constructing and storing a block designation table for individual product advertisements.

2E is an example screen for explaining a block designation step for completely restoring an individual product advertisement image cut in two parts. As shown in FIG. 2E, a cell a1 assigned with a unique product code 1 and a cell b1 on the right with a unique product code 16 form a single individual product advertisement image and block it. If you want to specify, enter the unique product code in the blank to the left of the 'Block Input Cell' at the bottom and press the 'Enter' button. When the block designation is made in this way, the cell a1 and the cell b1 are treated as one cell so that the user moves to the same web page even if the user clicks on the image matching the cell.

As described above, the database construction work of the individual product advertisement images for one entire product advertisement image is completed. Steps S30 to S40 may be performed by a database building tool manufactured for the present invention.

3A is a diagram illustrating an individual product information table in an offline medium advertisement database constructed according to the present invention. In FIG. 3A, 'idx' represents unique product code attributes for individual product advertisements, and 'search1', 'search2', 'search3' and 'search4' respectively represent newspaper company attribute, travel agency attribute, travel type attribute and travel region attribute. 'Url' represents the link information attribute of the web page containing the detailed information of the individual product advertisement image, 'img' represents the position attribute of the file containing the individual product advertisement image, 'level' and 'xy' 'Indicates the attributes of the column and the row where the individual product advertisement image is located in the entire product advertisement image, and finally' width 'and' height 'indicate the horizontal and vertical size attributes of the individual product advertisement image, respectively. .

3B is a diagram illustrating a table of the number of individual product advertisements for each entire product advertisement. As illustrated in FIG. 3B, 'good code' represents an entire product code attribute, and 'good_can' represents a number attribute of a column of each total product advertisement image. Similarly, FIG. 3C is a diagram illustrating a row table of individual product advertisements for each column of each total product advertisement.

FIG. 3D illustrates a block designation table for an individual product advertisement. According to this example screen, '6', '7' and '6' in the entire product advertisement image having the entire product code of '2004729131331' in the first row. It can be seen that the partial images having the individual product code of '8' are combined to form one individual product advertisement image. According to such a block designation table, when there is an output request for any one partial image, the remaining partial images are also output. 3E is a diagram illustrating a newspaper code table.

4 is a diagram illustrating a network for implementing an online search service of an offline media advertisement of the present invention. As shown in FIG. 4, the network configuration according to the online search service of the offline media advertisement according to the present invention is largely performed by the client 10, the search service provider 30, and the plurality of travel agencies 40 and 50. The connection may be made by a communication network such as 20. In the above-described configuration, the client 10 is again a wired PC client 14 composed of a mobile phone or a client having a mobile communication function such as a PDA or a notebook (hereinafter referred to as a 'mobile client') 12 and a wired personal computer. Can be distinguished.

The search service provider 30 is largely connected to a search server 32 providing a search service to the client 10 and a search server 32 to provide a data requested by the search server 32, that is, the present invention. It can be made by including an offline media advertising database 34 built by. Finally, the travel agencies 40 and 50 store the contents of these web pages and the travel agency servers 42 and 52 which provide web pages and the like with detailed information related to the travel products requested by the client 10. Which may comprise a travel agency database 44, 54. By the way, the search service provider 30 may be integrated with each travel agency 40, 50, in this case, the search server 32, the offline media advertising database 34 and the travel agency server 42 , 52 and travel agency databases 44, 54 may be organically constructed.

5 is a flowchart showing an online search service process of an offline media advertisement of the present invention, and unless otherwise described, the search server 32 is mainly performed. As shown in Fig. 5, according to the online search service of the offline medium advertisement of the present invention, the client 10 first accesses the search server 32 to perform necessary preliminary procedures, for example, registration and login. In this state, in step S50 it is determined whether there is a request for the entire product advertisement image from the client (10).

6A is an example screen illustrating a user interface for online search of an offline media advertisement image. As shown in FIG. 6A, the search server 32 operates a user interface for providing various search services to the client 10. As described above, the search by newspaper company, the search by travel agency, the search by travel type, and the travel region. Functions such as search can be provided in the form of a pull-down menu, for example.

In this state, when the user clicks on the 'Travel type' menu bar, detailed items on the type of travel are listed, and the user can select a type of travel to be searched by a simple operation of selecting one of them. Therefore, the determination of step S50 can be accomplished by checking whether the client 10 has selected a newspaper by clicking a newspaper-specific search.

As a result of the determination in step S50, when there is a request for the entire product advertisement image, the search server 32 searches the offline media advertisement database using the corresponding newspaper code as a key, and loads the corresponding whole product advertisement image file in step S52. To transmit it to the client 10. FIG. 6B is an example screen showing a search result of all product advertisement images for a specific newspaper company transmitted as described above, and is an example screen posted on one page of a specific date and specific newspaper company.

As a result of the determination in step S50, if the entire product advertisement image file is not requested, the process proceeds to step S60 to determine whether there is a request for an individual product advertisement image having a specific condition value, which is determined by the user in the example screen of FIG. 6A. This can be done by clicking on the 'Main Region' menu-bar and checking which one of the items listed is selected. As a result of the determination in step S60, when the user requests an individual product advertisement image having a specific condition value, the search server 32 searches the offline medium advertisement database 34 as a key to retrieve the corresponding individual product image. After step S62 is performed to send it to the client (10).

FIG. 6C is an example screen showing an image search result of individual product advertisements of all newspapers for a specific local condition, and it can be seen that product advertisements of respective newspaper companies are provided in groups in relation to travel products in Southeast Asia.

Next, in step S54, it is determined whether the specific individual product advertisement image is clicked from the images provided in step S52 or step S62, that is, whether there is a request of the detailed web page for the specific individual product advertisement image. As a result of the determination in step S54, when there is a request of the detailed web page for the specific individual product advertisement, the process proceeds to step S56 and the web page linked to the individual product advertisement image is transmitted to the client 10, and in step S58 It handles tasks such as reservation on web page. As a result of the determination in step S60, if it is not a request for an individual product advertisement image, the client 10 provides a function among other functions provided by the search server 32.

The database construction method for online search of the offline medium and the database recording medium generated by the present invention are not limited to the above-described embodiments, and various modifications can be made within the scope of the technical idea of the present invention. . For example, in the above, the travel product advertisement is taken as an example of the product advertisement, but the present invention is not limited thereto, and may be applied to a real estate product advertisement or a fluid product advertisement. In addition, it may be applied to offline media advertisements through magazines, catalogs, or flyers in addition to advertisements through newspaper pages. In the process of cutting individual products, horizontal lines may be drawn first instead of vertical lines, and then vertical lines may be drawn between these horizontal lines. Furthermore, the configuration and input interface of the database building tool can be changed accordingly.

According to the present invention as described above, the user (consumer) does not need to review the various newspapers to select a product that is suitable for them, and calls each travel agency to check the details that cannot be displayed on the newspaper pages. There is no need to visit or visit, so you can simply search for the conditions you need online and compare and analyze various travel products without wasting time and unnecessary effort.

On the other hand, the travel agency, the advertiser who advertises in the newspaper, does not have the disadvantage that the cost-effective advertisement almost disappears after one day, and the content exposure effect takes advantage of the continuous online characteristics and advantages. You have wins and economic benefits. In particular, in the case of the majority of large travel companies that use both offline advertising and online sales methods, offline newspaper advertising can be linked with online, and various marketing can be carried out. Can be maximized.

You can also search for multiple travel products on the online travel agency site in the same way.

Consumers are provided with a means to compare their choices with each other, and each newspaper utilizes this sales invention to display the advertiser's newspaper advertisements on the newspaper's online site and directly connect the products to the travel agency. The service can be provided to improve the order of advertisement and the efficiency of the advertisement, and can obtain the additional benefit of having the means to provide the advertiser with the effect of the integrated advertising on and off.

Claims (6)

delete (a) scanning the entire product advertisement image of the offline print media; (b) cut vertical and horizontal lines along the boundary of each individual product advertisement image on the scanned whole product advertisement image, and cut the vertical and horizontal lines into respective individual product advertisement images, wherein the vertical lines are divided into upper and lower widths of the entire product advertisement image. Partitioning and cutting the horizontal line between the divided vertical lines, and storing the divided horizontal lines as individual product advertisement image files; (c) generating an individual product image input form by inputting the number of columns and rows obtained by the intersection of the horizontal line and the vertical line by a database building tool; and (d) assigning at least one condition value for product classification and retrieval to each cell of the individual product image input form, specifying a storage path of each stored individual product advertisement image file, and specifying a unique individual product code. A method of constructing a database for online search of offline media advertisements comprising the step of granting a database. The method according to claim 2, wherein in the partitioning process of step (b), when one individual product advertisement image is cut into two or more portions, cells in which one intact individual product advertisement image is interspersed and matched are designated as one block. And a step of constructing a table, wherein the method for constructing a database for on-line search of offline media advertisements is made. According to claim 3, wherein the product advertisement is a travel product advertisement posted on the newspaper offline, And the condition value is a newspaper company, a travel agency, a travel type, or a travel area. 5. The method of claim 4, wherein in step (d), link information of a web page containing detailed information about the individual product advertisement is assigned. A recording medium which contains a database constructed by the method of any one of claims 2 to 5.

Images