KR20080107031A - Method and system for searching the ucc moving picture of area information - Google Patents

Abstract

A method and a system for searching a UCC moving picture of area information are provided to enable a user to efficiently search a UCC moving picture of area information according to region, theme, period or type. A UCC database(500) updates constructed contents, and an updating engine(400) stores a new or changed UCC moving picture at a UCC moving picture data mart(600). A search terminal(100) enables a user to input a search term to search a UCC moving picture of area information, and a search sever(200) converts the inputted search term to a normalized search text and transmits the text to a search engine(300) which searches information at the data mart.

Description

 Local information search system and method for local user-generated videos {Method and System for searching the UCC moving picture of area information}

1 is a flow chart schematically showing the configuration of a local information retrieval system for a local information user-produced video according to a preferred embodiment of the present invention.

2 is a diagram illustrating an internal configuration of a local information user-produced video data mart according to an exemplary embodiment of the present invention.

3 is a view showing the contents of the new table data mart according to the present invention;

4 is a view showing the contents of the change table data mart according to the present invention;

5 is a flowchart of a method for searching local information according to the present invention.

 According to the present invention, after constructing a local information UCC database in which UCC and location information are combined, using the same, accurate information of local user-produced videos such as travel destinations, restaurants, lodgings, homestays, golf courses, etc. The present invention relates to a local information retrieval system and method for targeting local information user-produced video that can be searched.

In recent years, local information UCC has become an important means of coping with local information collection. UCC (User Created Content) refers to online content created by users without commercial intentions. In the United States, commonly known as UGC (User Generated Content).

Conventionally, even if the local information is displayed on the electronic map, it is manually performed by inputting the electronic map on the photo, text data collected by the local information provider or the photo or text provided by the advertiser. In addition to this, there was a problem that it was difficult to provide sufficient local information due to lack of information.

In recent years, UCC has become an important means of coping with local information collection. Currently, however, after constructing a 'local information UCC database' that combines UCC photos (including text) or UCC videos with location information in the UCC, the local information service that targets local user-generated videos There are no UCC videos such as entertainment, adult content, and news that are not related to local information.

Since the existing local information guide service takes a huge cost to collect local information, it is mostly to guide local information providers to businesses that have requested advertisements. In this way, local information is not provided from the actual consumer's point of view, but local information is provided from the local information provider or advertiser's point of view.

The present invention has been made to solve the above problems, the purpose of which is to use the local information UCC produced by the general public without commercial intention as a means for providing local information to the UCC producer directly on the electronic map the position Build a 'local information UCC database' combining UCC and location information by inputting it, and use local information UCC database to create local user information such as travel destinations, restaurants, lodging, homestay, golf course, fishing, and mountain climbing on wired and wireless networks. The present invention relates to a local information retrieval system and method for a local information UCC video that can be searched more efficiently by enabling a search by region (domestic, overseas), theme, type, and period.

Therefore, the present invention has been proposed to solve the above problems according to the prior art, the object of the present invention is to use the local information UCC produced by the public without commercial intention as a local information providing means to the location of the electronic information in the UCC UCC producers can directly input on the map to build a local information UCC database that combines UCC and location information, and use the local information UCC database to travel destinations, restaurants, lodgings, homestays, golf courses, fishing, and mountaineering in wired and wireless networks. Local information search system and method for local user-made videos that can be searched more efficiently by enabling search of local user-made videos such as local (domestic, overseas), themes, types, and periods. It is about.

Hereinafter, with reference to the embodiment according to the present invention will be described in detail.

The local information retrieval system for local information user-produced video according to the present invention includes at least a classification code, a UCC video name (content), a UCC photo name (content), and a UCC when a business operator registers (inputs) a UCC produced by a public. UCC picture information, UCC picture theme information, UCC video location, UCC picture location, date of production, date of construction, including the date of construction and the field information is added, if the field information is added or changed UCC to update the constructed content Local information database 500;

An update engine 400 for tying newly added or changed items in the local information UCC database and storing corresponding local information user-produced videos in the data mart;

A data mart 600 for storing a local information user-produced video typed by the update engine;

A search terminal 100 in which a user inputs a search word to search for a local user-generated video;

A search server 200 for receiving a search word input by the user from a search terminal through a network and converting the search term into a normalized search sentence and transmitting the search term to a search engine; And

It includes a search engine 300 for searching the data mart by executing a search statement received from the search server.

The search terminal 100 may be applied to a personal computer, a mobile phone and a personal digital assistant (PDA).

On the other hand, the local information retrieval method according to the present invention is at least the classification code, UCC video name (content), when the local information provider registered (input) UCC produced by the public for the general public who provided the UCC to the local information provider; Construct a local information UCC database 500 including field information including information including UCC photo name (contents), UCC video theme information, UCC photo theme information, UCC video location, UCC photo location, production date, and change date; Updating the constructed content when the field information is added or changed;

  An update engine of a provider providing a local user-generated video search service extracts a specific field from the updated local information UCC database and types new or changed items in the local information UCC database to search for a data mart (600). Forming);

When the user inputs a search word in the search terminal 100, the input search word is transmitted to the search server 200 of the operator through a network;

A search server of the operator converting the received search word into a normalized search sentence for execution by the search engine 300 and transmitting the search term to the search engine of the operator; And

And a search engine receiving the normalized search statement and outputting the searched information to the search terminal by executing the received search statement with respect to the new and change table data marts.

1 is a block diagram of a system for retrieving a local information service service target for UCC video local information according to a preferred embodiment of the present invention.

As shown in FIG. 1, a local information search system for a local user-created video includes at least a search terminal 100, a search server 200, a search engine 300, an update engine 400, and a local information UCC. Database 500, the local information user-created video datamart 600 is included.

The update engine 400 functions to form a data mart 600 for retrieving local information user-generated video by tying newly input or changed items from the source UCC database 500.

Here, the local information UCC database 500 is a database in which the general public who produced the UCC directly inputs the location of the UCC on the electronic map, and the local information provider establishes and maintains the database. Contents), UCC photo name (contents), UCC video theme information, UCC photo theme information, UCC video location, UCC photo location, production date, change date, etc., and the UCC video data is added and modified. .

That is, a newly added record is added to a newly provided (registered) UCC video, and if the existing UCC video information is changed (for example, the contents are changed), the corresponding record is modified or replaced, and the production date field is Save the date of the modification or replacement in.

The update engine 400 forms a local user-produced video data mart 600 for searching local information from the local information UCC database 500.

That is, by querying the local information UCC database 500, the production change date is not stored in the production change date field, classification code, UCC video name (contents), UCC photo name (contents), UCC video theme information, UCC photo theme Select a record set whose fields are information, UCC video location, UCC photo location, and production date, and identify the code, UCC video name (contents), UCC video theme information, UCC video location, and new production date. Information stored in the user-created video new table 620 in the order of listing.

In addition, by searching the local information UCC database 500, in the change date field, identification code, UCC video name (contents), UCC photo name (contents), UCC video theme information, UCC photo theme information, UCC video location, UCC photo location , Select a record set with a production change date as a field, and change it into a field with a code, UCC movie name (contents), UCC movie theme information, UCC video location, and production change date. In the order listed).

The search engine 300 searches for desired local information from the local information UCC database 500 and the local information UCC video data mart 600 by executing a normalized search statement input from a search server, and searching the search terminal 100. Output to

 Local information search is possible by region (domestic, overseas), theme, type, period.

Search by region is through the UCC video location information field of the local information UCC video data mart 600, search by theme through the search of the UCC video content field, search by period is the new production date field and change of the data mart (600) This is done by searching one field each.

In addition, as in a general search statement, each search condition can be combined into “OR” or “AND”.

For example, if you want to search for a newly-developed honeymoon or experience destination, a family meeting, or a restaurant suitable for a birthday party, you can combine the search condition by region, search condition by period, and search condition by theme as "AND" to execute the query. Done.

In this case, the user does not directly write a normalized search sentence, and when the user selects or inputs a search word through the web from the search terminal 100, the search server 200 receives the input so that the search engine 300 can execute the search term. The search engine 300 converts the search result into a normalized search statement.

As shown in FIG. 2, the UCC video local information data mart 600 is a data mart for searching local information UCC video formed through the update engine 400 in the local information UCC database.

Therefore, the data mart 600 does not store all the UCC video information stored in the database in which the UCC video and the location information are combined, but changes the video information or the newly produced video information among the stored video information in the database in which the UCC video and the location information are combined. For the UCC video information, the classification code, the UCC video name, the UCC video theme-specific information, the UCC video location, the new production date or the change date are stored.

Thus, the data mart 600 includes at least a new table 620 and a change table 640.

As shown in FIG. 3, the new table 620 is a table for storing newly produced local information user-produced video, and includes at least a division code, a UCC video name, information on a UCC video theme, a UCC video location, and a new production date. Include.

As shown in FIG. 4, the change table 640 is a table for storing changed local information UCC video, and includes at least a division code, a UCC video name, UCC video theme-specific information, a UCC video location, and a production change date as fields. .

As described above, the present invention, unlike the way in which the existing local living information provider provides the local living information limited to simply photographs and text contents that are formally self-produced at a huge cost, up to the location information in the UCC video Systematic and objective local user-produced video is provided by providing local user information that is grafted to each region (domestic, overseas), theme, type, period, etc. in well harmonized multimedia form using GIS engine of GIS. Can be easily retrieved.

In addition, the present invention can be searched in a variety of regions, themes, and periods when searching for local information, as well as within a radius circle or polygon within a few meters (for example 500 meters, 1,000 meters, etc.) from the user location By freely selecting local information search targets and displaying the searched local user-created videos in the form of electronic maps, numbers, search (popular) rankings and charts, information searchers can search for information conveniently and easily.

In particular, the present invention can shorten the local information search time for a general individual who needs local information in Korea and abroad, and can grasp easily and systematically accurately. Businesses who need local information can reduce manpower and cost in collecting local information, and can analyze only by region and collect only necessary information, and projects such as restaurants, destinations, accommodations, homestays, etc. introduced in local user videos In order to prevent departure of existing customers and to discover new customers, they can provide better service and monitor customer satisfaction. This will soon contribute to the development of the service industry, such as food, travel and accommodation.

Claims (4)

For the general public who provided the UCC to the local information provider, when the local information provider registers (inputs) the UCC produced by the public, at least the classification code, UCC video name (content), UCC photo name (content), and UCC video theme information , UCC picture theme information, UCC video location, UCC picture location, the date of production, the date of production, including the date of construction is constructed by the field information, if the field information is added or changed UCC and location to update the constructed content Local information UCC database to which information is grafted; An update engine for tying newly added or changed local information user-produced videos in the local information UCC database and storing them in the local information UCC video data mart; A data mart storing a local information user-produced video typed by the update engine; A search terminal in which a user inputs a search term to search for a local user-generated video; A search server that receives a search word input by the user from a search terminal through a network, converts the search term into a normalized search statement, and transmits the search term to a search engine; And And a search engine for searching the local information UCC video data mart by executing a search statement received from the search server. The system of claim 1, wherein the search terminal is one of a personal computer, a mobile phone, and a personal digital assistant (PDA). The UCC video data mart according to claim 1, wherein the local information UCC video data mart includes at least a classification code, a UCC video name (content), UCC video theme information, and UCC for a new or changed local information user-produced video extracted from the local information UCC database. UCC video local information retrieval system, characterized in that for storing the video positioning, production date, change date information. For the general public who provided UCC to the local information provider, when the local information provider registers (inputs) the UCC produced by the public, at least the classification code, UCC video name (content), UCC video theme information, and UCC photo name (content) Constructing information including the UCC location, production date, and modification date as field information, and updating the constructed contents when the field information is added or changed;   An update engine of an operator providing a local user-generated video search service extracts specific fields from the updated local information UCC database and types new or changed local information UCC videos in the local information UCC database to search for local information. Forming a mart; When the user inputs a search word in the search terminal, the input search word is transmitted to the search server of the operator through a network; A search server of a service provider converting the received search word into a normalized search sentence for execution by a search engine and transmitting the searched word to a search engine of a service provider; And And a search engine receiving the normalized search sentence and outputting the searched information to the search terminal by executing the received search sentence with respect to the local information user-generated video data mart. How to find user-generated videos.

Images