KR20200013316A - Method, apparatus and computer-readable medium for provide serch word ranking data - Google Patents

Abstract

The present invention relates to a method for providing search word ranking data. According to an embodiment of the present invention, the method comprises: a collection step of collecting ranking data of a real-time search word updated by a search engine set as a collection object at predetermined intervals; and a storage step of generating an excel sheet for storing the ranking data of the real-time search word and accumulating and storing the real-time search word ranking data collected in the collection step in the generated excel sheet. According to an embodiment of the present invention, the apparatus for providing the search word ranking data comprises: a collection unit of collecting ranking data of a real-time search word updated by a search engine set as a collection object at predetermined intervals; and a storage unit for generating an excel sheet for storing the ranking data of the real-time search word and accumulating and storing the real-time search word ranking data collected in the collection step in the generated excel sheet.

Description

METHOD, APPARATUS AND COMPUTER-READABLE MEDIUM FOR PROVIDE SERCH WORD RANKING DATA}

The present invention relates to a method of providing search term ranking data, and specifically, a search term ranking for providing result data obtained by collecting real-time ranking data at predetermined intervals from a search engine and accumulating and storing them on one Excel sheet. It relates to a method of providing data.

In general, a search engine providing a search service performs a function of providing a user with data such as a web site, a newspaper article, an image, a cafe, a blog, or the like that includes the search word in response to the search word when the search word is input. .

On the other hand, the real-time search terms, because of the characteristics of the real-time search terms, the latest trend information that is the subject of recent interest of people is easy because it includes the search target information most frequently searched by the plurality of netizens at a certain time. The advantage is that it can be understood.

On the other hand, Korean Patent No. 10-1614470 (search word list providing apparatus and method using the same) obtains a tag set in the search word to apply the effect corresponding to the tag to the search term list including a search term applied to the effect An apparatus for providing a search word list and a method using the same are provided.

However, in the case of the above-mentioned prior patent, a technology that visually shows an effect by applying an effect to a newly added search term or a tag of a search term that shows a keen interest in a search term list provided on a search engine, and easily checks the nature of the search term. This is an advantage of providing a quick search query or a newly updated search query, but in order to obtain the ranking data of the real-time search query, users who want to collect data from time to time search the search engine to collect the search query information If it was not possible to grasp the ranking of the real-time search term due to busy work, there was a problem that it is difficult to easily obtain past search term ranking data.

For this reason, despite the advantage that real-time search terms can easily identify trend information and can be effectively used to select items for advertising and marketing, people in advertising and marketing jobs have difficulty in utilizing them.

Accordingly, the present invention has a first object of providing ranking information of a real-time search word and a real-time search word that are periodically collected on an Excel sheet that can be viewed by a user terminal by collecting ranking data of a real-time search word from a search engine.

In addition, the present invention is to provide the past real-time search terms and ranking information of the real-time search terms, by extracting the search word information with a high frequency of input on the Excel sheet to generate statistical data, to provide a base material such as advertising and marketing activities There is a second purpose.

In order to achieve the above object, a method of providing search term ranking data according to an embodiment of the present invention may include: a collecting step of collecting rank data of a real-time search word updated by a search engine set as a collection target every predetermined period; And a storing step of generating an Excel sheet in which the ranking data of the real-time search word is stored, and accumulating and storing the real-time search term ranking data collected by the collecting step in the generated Excel sheet.

In the above-described storing step, when it is detected that the ranking data of the real-time search word is collected, the file including the Excel sheet is loaded, and the real-time currently collected in the next row of the row where the real-time search word ranking data collected in the previous cycle is recorded. It is preferable to accumulate and store search term ranking data.

In the above-described storing step, when it is detected that the ranking data of the real-time search word is collected, temporarily storing the ranking data of the real-time search word in the cache memory of the user terminal, and when there is a request to load a file including an Excel sheet from the user terminal. Loads the ranking data of the real-time search query temporarily stored in the cache memory onto an Excel sheet, accumulates and saves the real-time search query ranking data collected in the previous cycle in the next row in the row where it was recorded, and then closes the Excel sheet file. It is desirable to allow this to be performed.

If it is determined that the real-time search term ranking data temporarily stored in the above-described cache memory is effectively stored on the Excel sheet and a close command is performed in the Excel sheet file, it is preferable to initialize the cache memory to an available state.

Based on the ranking data of the real-time search words stored in the above-described Excel sheet, a search word having a high frequency of input is extracted from the Excel sheet to generate statistical data based on at least one of annual, monthly, weekly and daily, and statistical data Is preferably stored on another sheet of the Excel file containing the Excel sheet.

Before performing the above-mentioned collection step, the search engine information receiving step for receiving the address information for the search engine that the user wants to receive the real-time search query ranking data from the user terminal;

On the other hand, the apparatus for providing search word ranking data according to an embodiment of the present invention, the collection unit for collecting the ranking data of the real-time search word updated by the search engine set as the collection target every predetermined period; And a storage unit generating an Excel sheet in which the ranking data of the real-time search word is stored, and accumulating and storing the real-time search term ranking data collected by the collection unit in the generated Excel sheet.

In addition, the computer-readable recording medium stores instructions for causing the computing device to perform the following steps, the steps of: collecting rank data of real-time search terms updated by a search engine set as a collection target every predetermined period of time. Collecting step; And generating an Excel sheet storing the ranking data of the real-time search word and accumulating and storing the real-time search word ranking data collected by the collecting step in the generated Excel sheet.

According to an embodiment of the present invention, real-time search terms and real-time search terms are provided by accumulating and storing the real-time search terms and the ranking information of the real-time search terms periodically to users who cannot check the real-time search term ranking due to busy work or daily life. There is an effect that can easily obtain the rank information.

In addition, according to an embodiment of the present invention, the past real-time search word and the ranking information of the real-time search word is provided on the Excel sheet, the search word information with a high frequency of input on the Excel sheet to provide as statistical data between recent netizens It is easy to extract the trend information of the subject that is an issue in and can be usefully used in advertising and marketing materials.

1 and 2 are flowcharts illustrating a method of providing search word ranking data according to an embodiment of the present invention.
3 is a block diagram of an apparatus for providing search word ranking data according to an embodiment of the present invention.
4 is an example in which search word ranking data is accumulated and provided at predetermined intervals according to an embodiment of the present invention.
5 is an example of providing statistics of search word ranking data according to an embodiment of the present invention.
6 is an example of setting a reception path of real-time search term ranking data according to an embodiment of the present invention.
7 is a block diagram illustrating an internal configuration of a computing device according to an embodiment of the present invention.

In the following, various embodiments and / or aspects are now disclosed with reference to the drawings. In the following description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of one or more aspects. However, it will also be appreciated by one of ordinary skill in the art that this aspect (s) may be practiced without these specific details. The following description and the annexed drawings set forth in detail certain illustrative aspects of the one or more aspects. However, these aspects are exemplary and some of the various methods in the principles of the various aspects may be used and the descriptions described are intended to include all such aspects and their equivalents.

As used herein, “an embodiment”, “an example”, “aspect”, “an example”, etc., may not be construed as any aspect or design described is better or advantageous than other aspects or designs. .

The terms "comprises" and / or "comprising" also mean that the feature and / or component is present, but exclude the presence or addition of one or more other features, components and / or groups thereof. It should be understood that it does not.

In addition, terms including ordinal numbers such as first and second may be used to describe various components, but the components are not limited by the terms. The terms are used only for the purpose of distinguishing one component from another. For example, without departing from the scope of the present invention, the first component may be referred to as the second component, and similarly, the second component may also be referred to as the first component. The term and / or includes a combination of a plurality of related items or any item of a plurality of related items.

In addition, in the embodiments of the present invention, unless otherwise defined, all terms used herein including technical or scientific terms are generally understood by those skilled in the art to which the present invention belongs. Has the same meaning. Terms such as those defined in the commonly used dictionaries should be interpreted as having meanings consistent with the meanings in the context of the related art, and ideally or excessively formal meanings are not defined clearly in the embodiments of the present invention. Not interpreted as

The present invention relates to a method of providing search term ranking data for providing result data obtained by extracting real-time ranking data from a search engine at predetermined intervals and accumulating and storing the ranking data on one Excel sheet. The first object is to collect the ranking data of the search terms and provide the ranking information of the real-time search query and the real-time search query passed on the Excel sheet that can be viewed from the user terminal, and also to provide the ranking information of the past real-time search query and real-time search word In addition, the second object of the present invention is to provide statistical data by extracting search word information having a high input frequency on an Excel sheet and generating statistical data.

For more detailed description of the method of providing search word ranking data according to the present invention for achieving the above object will be described with reference to the drawings.

1 and 2 illustrate flowcharts of a method of providing search word ranking data according to an exemplary embodiment.

First, referring to FIG. 1, first, a collecting step S10 of collecting ranking data of a real-time search word updated by a search engine set as a collection target every predetermined period may be performed.

At this time, the predetermined period may be set to, for example, 15 minutes, that is, every 15 minutes by the function of the step S10 to collect the updated ranking data of the real-time search query cumulatively stored on the Excel sheet It can be understood that.

In another embodiment of the present invention, as shown in FIG. 2, a search for receiving address information of a search engine for which a user wants to receive real-time search term ranking data from a user terminal before performing the above-described step S10. The engine information receiving step S1 may be further included.

In this case, the above-described search engine is a software designed to search for desired information on the Internet, and when a search term is inputted, the search engine serves as a database that informs the address list of the web service including the search term. It can be understood as a concept to perform, and representative search engines include Google, Naver, Yahoo, and NetSearch.

On the other hand, by performing the above-described step S1 of the present invention, the user receives the web address information of the search engine that the user wants to receive the real-time search query ranking data, which is the presence of various search engines online Reflects the characteristics that may vary according to the propensity of netizens for each search engine, and the present invention reflects the above-described characteristics, and when the user prefers or the user needs data of a real-time search word of a specific search engine, By receiving address information, a real-time search word from a search engine set as a collection target can be easily collected, stored on a sheet of an Excel file, and provided to a user terminal.

Returning to FIG. 1 again, after performing step S10, an Excel sheet is generated in which the ranking data of the real-time search word is stored, and the real-time search term ranking data collected by performing the above-described step S10 is accumulated and stored in the generated Excel sheet. Step S20 may be performed.

On the other hand, as a first embodiment of the above-described step S20, in the above-described step S20, when it is detected that the ranking data of the real-time search word is collected, the real-time search term ranking data collected in a previous cycle by loading a file including an Excel sheet The currently collected real-time search term ranking data may be accumulated and stored in the next row of the recorded row.

In more detail with respect to the above-described embodiment, for example, it is assumed that after the Excel sheet is generated, the search term ranking data is recorded and stored in one row, and the preset period is set to, for example, 15 minutes later. When 15 minutes later, the user terminal issues an open command to an Excel file including an Excel sheet in which real-time search term ranking data is stored. It can be stored in the record.

That is, the user can easily obtain real-time search term ranking data accumulated in time series with a period from an Excel file including the above-described Excel sheet, and thus can easily extract a search term that is an issue for each time. Will be.

Meanwhile, according to the second embodiment of the above-described step S20 in the present invention, when the above-described step S20 is detected that the ranking data of the real-time search word is collected, the ranking data of the real-time search word is temporarily stored in the cache memory of the user terminal. When a request for loading a file including an Excel sheet is received from a user terminal, the ranking data of the real-time search term temporarily stored in the cache memory is loaded onto the excel sheet, and the next row of the row where the real-time search term ranking data collected in the previous cycle is recorded. After accumulating and storing the data in batches, the close command can be executed in the Excel sheet file.

In other words, it does not store the search term ranking data collected at predetermined intervals as soon as it is collected and stores them in an Excel file, but caches the collected query rank data until an Excel file opening request is made from an input means of the user terminal. Temporarily stored in memory, and when it is determined that the Excel file is opened due to the presence of an opening request by the input means of the user terminal, the search word ranking data temporarily stored in the aforementioned cache memory is loaded on the Excel sheet of the opened Excel file. To store them in batches.

That is, the time required for storing and closing the data by opening the Excel file in the user terminal can be significantly reduced, thereby minimizing the frequent operation of the Excel file, thereby optimizing the performance of the user terminal.

In the present invention, when the real-time search term ranking data temporarily stored in the cache memory is effectively stored on the Excel sheet and the close command is executed in the Excel sheet file, in the above-described embodiment, the cache memory may be made available. It is preferable to initialize.

In other words, it is a configuration that reflects the characteristics of cache memory having a small capacity instead of fast data processing. By initializing the cache memory to an available state, the cache memory is maintained in a stable state while maintaining the performance of the system and the life of a storage device. Can be improved.

Meanwhile, in the present invention, the above-described first embodiment and the second embodiment may be performed independently of each other, but one or more embodiments may be executed in combination with each other sequentially or simultaneously, and the present invention is not limited thereto.

On the other hand, according to another embodiment of the present invention, at least any one of annual, monthly, weekly and daily by extracting a search word having a high frequency of input on the Excel sheet based on the real-time search term ranking data stored in the Excel sheet by the storing step Statistical data based on one can be generated.

In this case, the above-described statistical data is stored in another Excel sheet on an Excel file that includes an Excel sheet that generates search term ranking data that is accumulated and stored in time series based on a preset period. In addition to acquiring real-time search term ranking data accumulated for each cycle, search term information that is sorted in order of high frequency of input can be further obtained based on at least one of annual, monthly, weekly and daily.

In other words, the user can easily obtain information of search words with high interest by netizens that are maintained or changed over time, and can be usefully used as advertisement and marketing materials. In addition, the effect of advertising and marketing is maximized. It can be expected to produce and sell the contents.

Overall, according to an embodiment of the present invention, the user can not check the real-time search term ranking due to busy work or daily life to provide the results of the real-time search term and the real-time search term by accumulating and storing the ranking information of the real-time search word There is an effect that can easily obtain the ranking information of the real-time search word.

In addition, according to an embodiment of the present invention, by providing the past real-time search word and the ranking information of the real-time search word on the Excel sheet, by extracting the search word information with a high frequency of input on the Excel sheet to provide as statistical data, recent netizens There is an effect that can be useful for advertising and marketing materials by easily extracting the trend information of the subjects in question.

Although the above embodiments have been described with reference to the limited embodiments and drawings, various modifications and variations are possible to those skilled in the art from the above description.

3 is a block diagram of an apparatus 10 for providing search word ranking data according to an exemplary embodiment.

In the following description, description of unnecessary embodiments that overlap with the above description of FIGS. 1 and 2 will be omitted.

In an embodiment of the present disclosure, the apparatus 10 for providing search word ranking data described above may include a data collector 11 and a storage 12.

In this case, the above-described data collector 11 may be understood to perform a function of collecting ranking data of the real-time search word updated by the search engine 30 set as a collection target every predetermined period. It can be understood that the above-mentioned step S10 of FIG. 1 performs all of the functions performed.

That is, according to the present invention, the user may easily extract a search term which is an issue by time, by providing the user with data including the ranking of the real-time search word updated every predetermined period (for example, 15 minutes), and ranking the search term. According to the fluctuation and the frequency of input of the search word input on the Excel sheet, it is possible to select the search word that is an issue according to the raw data.

Meanwhile, the storage unit 12 generates an Excel sheet in which the ranking data of the real-time search word is stored, and accumulates and stores the real-time search term ranking data collected by the collection unit 11 described above in the generated Excel sheet. It will be understood that this will soon be possible for all of the functions performed by the aforementioned step S20 of FIG. 1.

On the other hand, although not shown in Figure 3, in the preferred embodiment of the present invention, the search engine information receiving unit may be further included in the apparatus 10 for providing search word ranking data.

In this case, the above-described search engine information receiving unit may be understood to perform a function of receiving address information on the search engine 30 to which the user is to receive the real-time search term ranking data from the user terminal 20. The above-described search engine information receiver will be understood to be able to perform all the functions performed in step S1 of FIG. 1.

That is, the search engine information receiving unit may store the past search term ranking list extracted and accumulated by the user's preferred search engine 30 from the user terminal 20 in an Excel file that can be viewed by the user terminal 20. Accordingly, the user can easily grasp past real-time search term ranking data regardless of time, thereby maximizing convenience.

In other words, according to the respective components constituting the apparatus 10 for providing search term ranking data, in the present invention, the real-time search word and the real-time are periodically provided to users who cannot check the real-time search word ranking due to busy work or daily life. Extracts the ranking information of search terms and provides the accumulated and saved result to easily obtain the ranking information of the real-time search query and real-time search query, and provides the ranking information of past real-time search query and real-time search query on the Excel sheet. By extracting search word information with a high frequency of input into the image and providing it as statistical data, it can be expected to be useful for advertising and marketing materials.

Although the above embodiments have been described with reference to the limited embodiments and drawings, various modifications and variations are possible to those skilled in the art from the above description.

4 illustrates an example in which search word ranking data is accumulated and provided for each predetermined period according to an embodiment of the present invention. In the following description, unnecessary implementation overlapping with the description of FIGS. 1 to 3 described above is provided. The description of the example will be omitted.

In the present invention, the search term ranking data collected from the search engine may be accumulated and stored on the sheet included in the Excel file. In this case, the time information 101 for collecting the search term ranking data may be stored on the Excel sheet. Ranking information 102 of the collected search word may be included.

For example, 100 of FIG. 4 illustrates search term information collected every 9 minutes from 9 am on July 2, 2018, and at 9 am, soccer player Lee Kang-in is ranked first. , Russia and Spain were ranked 2nd, and hurricane career forecast was ranked 3rd.

That is, even when the user fails to check the real-time search word in a busy work and busy daily time, there is an effect of easily obtaining the ranking information of the real-time search word and the real-time search word accumulated in a predetermined cycle.

Although the above embodiments have been described with reference to the limited embodiments and drawings, various modifications and variations are possible to those skilled in the art from the above description.

FIG. 5 illustrates an example in which statistics of search word ranking data are provided according to an embodiment of the present invention. In the following description, an unnecessary embodiment overlapping with the description of FIGS. 1 to 4 will be described. It will be omitted.

Meanwhile, in the present invention, statistical data based on at least one of yearly, monthly, weekly, and daily days may be generated by extracting a search word having a high frequency of input from the collected real-time search word ranking data on an Excel sheet.

That is, as shown in 200, when the period for generating the statistical data is set for each day, for example, 201, the input frequency 203 for each search term is calculated from the real-time search term ranking data collected daily, Statistical data may be generated by sorting in the order of search terms 202 having the calculated input frequency values.

In this case, the above-described statistical data is generated on an Excel file including an Excel sheet in which real-time search term ranking data is periodically collected and accumulated, and is stored on an Excel sheet different from the Excel sheet in which the real-time search term ranking data is stored. Preferably stored.

That is, when the Excel sheet in which the real-time search term ranking data is accumulated and stored in time series is sheet 1, it will be understood that the above-described statistical data is generated in the sheet 2 210.

That is, in the present invention, in addition to collecting and providing ranking data of a real-time search word, the search word information with high input frequency is extracted on an Excel sheet and provided as statistical data, which is useful for advertising and marketing materials. It can be expected to produce and sell contents that maximize the effects of advertising and marketing.

Although the above embodiments have been described with reference to the limited embodiments and drawings, various modifications and variations are possible to those skilled in the art from the above description.

6 illustrates an example of setting a reception path of real-time search term ranking data according to an embodiment of the present invention. In the following description, an unnecessary embodiment overlapping with the description of FIGS. 1 to 5 will be described. The description will be omitted.

Referring to 300 of FIG. 6, in the present invention, before the above-mentioned step of collecting the real-time search term ranking data, the user receives address information about a search engine for which the user wants to receive real-time search term ranking data from the user terminal in real time. Search path ranking data receiving path can be set.

In this case, as an embodiment of the present invention, an interface for providing a list of search engines or receiving web address information of a search engine from an input means of a user terminal may be further included in order to receive address information about a search engine. The invention is not limited thereto.

That is, it reflects the characteristics that various search engines exist online and the real-time search terms can be changed according to the propensity of netizens for each search engine, and the present invention reflects the above-described characteristics so that the user prefers or the user searches for a specific search. By receiving the web address information of the relevant search engine, such as when the real-time search data of the engine is required, the real-time search query from the search engine set as a collection target can be easily collected, stored on a sheet of an Excel file, and provided to the user terminal. It is.

Meanwhile, one or more address information of the above-described search engine may be input. Preferably, the search engine may store the real-time search term ranking data collected for each search engine on different sheets so as to be distinguished from each other.

Although the above embodiments have been described with reference to the limited embodiments and drawings, various modifications and variations are possible to those skilled in the art from the above description.

7 is a block diagram illustrating an internal configuration of a computing device according to an embodiment of the present disclosure.

As illustrated in FIG. 7, the computing device 11000 may include at least one processor 11100, a memory 11200, a peripheral interface 11300, and an input / output subsystem ( At least one I / O subsystem 11400, a power circuit 11500, and a communication circuit 11600. In this case, the computing device 11000 may correspond to a user terminal A connected to the tactile interface device A or the computing device B described above.

The memory 11200 may include, for example, high-speed random access memory, magnetic disk, SRAM, DRAM, ROM, flash memory, or nonvolatile memory. have. The memory 11200 may include a software module, an instruction set, or other various data necessary for the operation of the computing device 11000.

In this case, accessing the memory 11200 from another component such as the processor 11100 or the peripheral interface 11300 may be controlled by the processor 11100.

The peripheral interface 11300 may couple the input and / or output peripherals of the computing device 11000 to the processor 11100 and the memory 11200. The processor 11100 may execute a software module or an instruction set stored in the memory 11200 to perform various functions for the computing device 11000 and process data.

Input / output subsystem 11400 can couple various input / output peripherals to peripheral interface 11300. For example, the input / output subsystem 11400 may include a controller for coupling a peripheral device such as a monitor or keyboard, a mouse, a printer, or a touch screen or a sensor, as necessary, to the peripheral interface 11300. According to another aspect, the input / output peripherals may be coupled to the peripheral interface 11300 without passing through the input / output subsystem 11400.

The power circuit 11500 may supply power to all or part of the components of the terminal. For example, power circuit 11500 may be a power management system, one or more power sources such as batteries or alternating current (AC), charging systems, power failure detection circuits, power converters or inverters, power status indicators or power sources. It can include any other components for creation, management, distribution.

The communication circuit 11600 may enable communication with another computing device using at least one external port.

Alternatively, as described above, the communication circuit 11600 may include an RF circuit to transmit and receive an RF signal, also known as an electromagnetic signal, to enable communication with other computing devices.

7 is merely an example of the computing device 11000, and the computing device 11000 may include some components shown in FIG. 7, or may include additional components not shown in FIG. 7, or may include two components. It may have a configuration or arrangement that combines two or more components. For example, the computing device for a communication terminal in a mobile environment may further include a touch screen or a sensor, in addition to the components illustrated in FIG. 7, and various communication methods (WiFi, 3G, LTE) in the communication circuit 1160. , Bluetooth, NFC, Zigbee, etc.) may include a circuit for RF communication. Components included in the computing device 11000 may be implemented in hardware, software, or a combination of both hardware and software, including integrated circuits specialized for one or more signal processing or applications.

Methods according to an embodiment of the present invention may be implemented in the form of program instructions that may be executed by various computing devices and may be recorded in a computer readable medium. In particular, the program according to the present embodiment may be configured as a PC-based program or an application dedicated to a mobile terminal. An application to which the present invention is applied may be installed in a user terminal through a file provided by a file distribution system. For example, the file distribution system may include a file transmitter (not shown) for transmitting the file at the request of the user terminal.

The apparatus described above may be implemented as a hardware component, a software component, and / or a combination of hardware components and software components. For example, the devices and components described in the embodiments may include, for example, processors, controllers, arithmetic logic units (ALUs), digital signal processors, microcomputers, field programmable gate arrays (FPGAs), It may be implemented using one or more general purpose or special purpose computers, such as a programmable logic unit (PLU), microprocessor, or any other device capable of executing and responding to instructions. The processing device may execute an operating system (OS) and one or more software applications running on the operating system. The processing device may also access, store, manipulate, process, and generate data in response to the execution of the software. For ease of understanding, one processing device may be described as being used, but one of ordinary skill in the art will appreciate that the processing device includes a plurality of processing elements and / or a plurality of types of processing elements. It can be seen that it may include. For example, the processing device may include a plurality of processors or one processor and one controller. In addition, other processing configurations are possible, such as parallel processors.

The software may include a computer program, code, instructions, or a combination of one or more of these, and configure the processing device to operate as desired, or process it independently or in combination. You can command the device. Software and / or data may be any type of machine, component, physical device, virtual equipment, computer storage medium or device in order to be interpreted by or to provide instructions or data to the processing device. It may be embodied permanently or temporarily. The software may be distributed over networked computing devices so that they are stored or executed in a distributed manner. The software and data may be stored on one or more computer readable recording media.

Method according to the embodiment is implemented in the form of program instructions that can be executed by various computer means may be recorded on a computer readable medium. The computer readable medium may include program instructions, data files, data structures, and the like, alone or in combination. Program instructions recorded on the media may be those specially designed and constructed for the purposes of the present disclosure, or they may be of the kind well-known and available to those having skill in the computer software arts. Examples of computer-readable recording media include magnetic media such as hard disks, floppy disks, and magnetic tape, optical media such as CD-ROMs, DVDs, and magnetic disks, such as floppy disks. Magneto-optical media, and hardware devices specifically configured to store and execute program instructions, such as ROM, RAM, flash memory, and the like. Examples of program instructions include not only machine code generated by a compiler, but also high-level language code that can be executed by a computer using an interpreter or the like. The hardware device described above may be configured to operate as one or more software modules to perform the operations of the embodiments, and vice versa.

Although the embodiments have been described with reference to the limited embodiments and the drawings as described above, various modifications and variations are possible to those skilled in the art from the above description. For example, the described techniques may be performed in a different order than the described method, and / or components of the described systems, structures, devices, circuits, etc. may be combined or combined in a different form than the described method, or other components. Or, even if replaced or substituted by equivalents, an appropriate result can be achieved. Therefore, other implementations, other embodiments, and equivalents to the claims also fall within the scope of the claims that follow.

Claims (8)

A method of providing search term ranking data implemented in a user terminal including at least one processor and at least one memory storing instructions executable by the processor, the method comprising:
A collection step of collecting rank data of a real-time search word updated by a search engine set as a collection target every predetermined period; And
Generating an Excel sheet storing the ranking data of the real-time search term and accumulating and storing the real-time search term ranking data collected by the collecting step in the generated Excel sheet; How to Provide.
The method of claim 1,
The storing step,
If it is detected that the ranking data of the real-time search query is collected,
And loading the file including the Excel sheet and accumulating and storing the currently collected real-time search term ranking data in the next row of the row in which the real-time search term ranking data collected in the previous cycle is recorded.
The method of claim 1,
The storing step,
If it is detected that the ranking data of the real-time search query is collected,
Temporarily storing the rank data of the real-time search term in the cache memory of the user terminal, and when there is a request to load a file including the Excel sheet from the user terminal, ranking data of the real-time search term temporarily stored in the cache memory; Loaded onto an Excel sheet, the real-time search term ranking data collected in a previous cycle are collectively stored and stored in the next row of the recorded row, and then the search term ranking data is executed in the Excel sheet file. How to provide.
The method of claim 3,
When it is determined that the real-time search term ranking data temporarily stored in the cache memory is effectively stored on the Excel sheet and a close command is performed on the Excel sheet file,
And providing search term ranking data, wherein the cache memory is initialized to an available state.
The method of claim 1,
Based on the ranking data of the real-time search words stored in the Excel sheet, a search word having a high frequency of input is extracted from the Excel sheet to generate statistical data based on at least one of annual, monthly, weekly and daily, and the statistics Method of providing search term ranking data, characterized in that the data is stored on another sheet of the Excel file including the Excel sheet.
The method of claim 1,
Before performing the collection step,
And a search engine information receiving step of receiving address information of a search engine from which the user wants to receive real-time search term ranking data from the user terminal.
An apparatus for providing search term ranking data implemented in a user terminal including at least one processor and at least one memory storing instructions executable by the processor, the apparatus comprising:
A collector configured to collect rank data of a real-time search word updated by a search engine set as a collection target every preset period; And
And a storage unit generating an Excel sheet in which the ranking data of the real-time search word is stored, and accumulating and storing the real-time search term ranking data collected by the collection unit in the generated Excel sheet. Provision device.
As a computer-readable recording medium,
The computer-readable recording medium stores instructions for causing a computing device to perform the following steps, the steps:
A collection step of collecting rank data of a real-time search word updated by a search engine set as a collection target every predetermined period; And
And generating an Excel sheet in which the ranking data of the real-time search word is stored and accumulating and storing the real-time search term ranking data collected by the collection step in the generated Excel sheet. Record carrier.

Images