CN104281700A - Website inquiring and collecting method and device - Google Patents

Website inquiring and collecting method and device Download PDF

Info

Publication number
CN104281700A
CN104281700A CN 201410550952 CN201410550952A CN104281700A CN 104281700 A CN104281700 A CN 104281700A CN 201410550952 CN201410550952 CN 201410550952 CN 201410550952 A CN201410550952 A CN 201410550952A CN 104281700 A CN104281700 A CN 104281700A
Authority
CN
Grant status
Application
Patent type
Prior art keywords
inquiring
website
collecting
controller
method
Prior art date
Application number
CN 201410550952
Other languages
Chinese (zh)
Inventor
储雨知
Original Assignee
北京国双科技有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/30Information retrieval; Database structures therefor ; File system structures therefor
    • G06F17/30286Information retrieval; Database structures therefor ; File system structures therefor in structured data stores
    • G06F17/30386Retrieval requests
    • G06F17/30424Query processing
    • G06F17/30477Query execution
    • G06F17/30483Query execution of query operations
    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/30Information retrieval; Database structures therefor ; File system structures therefor
    • G06F17/30286Information retrieval; Database structures therefor ; File system structures therefor in structured data stores
    • G06F17/30386Retrieval requests
    • G06F17/30424Query processing
    • G06F17/30533Other types of queries
    • G06F17/30536Approximate and statistical query processing
    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/30Information retrieval; Database structures therefor ; File system structures therefor
    • G06F17/30286Information retrieval; Database structures therefor ; File system structures therefor in structured data stores
    • G06F17/30587Details of specialised database models
    • G06F17/30595Relational databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/30Information retrieval; Database structures therefor ; File system structures therefor
    • G06F17/30861Retrieval from the Internet, e.g. browsers
    • G06F17/30864Retrieval from the Internet, e.g. browsers by querying, e.g. search engines or meta-search engines, crawling techniques, push systems
    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/30Information retrieval; Database structures therefor ; File system structures therefor
    • G06F17/30861Retrieval from the Internet, e.g. browsers
    • G06F17/30876Retrieval from the Internet, e.g. browsers by using information identifiers, e.g. encoding URL in specific indicia, browsing history

Abstract

The invention discloses a website inquiring and collecting method and device. The website inquiring and collecting method includes that a website controller receives an inquiring request; the website controller converts the inquiring request into an inquiring sentence; the website controller executes the inquiring sentence and acquires an inquiring result acquired by executing the inquiring sentence; the website controller records the inquiring result. By the website inquiring and collecting method and device, the problem that unrelated information is prone to being collected when collecting website inquiring information is solved, and effect of optimizing inquiring experience is realized.

Description

网站查询收集方法和装置 Website collection methods and devices

技术领域 FIELD

[0001] 本发明涉及互联网领域,具体而言,涉及一种网站查询收集方法和装置。 [0001] The present invention relates to the field of the Internet, in particular, to a method and apparatus for collecting website.

背景技术 Background technique

[0002] 随着大数据的快速发展,数据的查询效率变得越来越重要。 [0002] With the rapid development of big data, data query efficiency is becoming increasingly important. 然而,用户没有权限直接进行数据查询,而是通过开发者设计的网站所提供的界面来查询数据。 However, the user does not have permission to query data directly, but by developers to design websites that provide an interface to query the data. 开发者设计的网站可以将用户的查询操作转化为实际的查询语句。 Developers can design a website user's query into actual query. 目前,开发者在进行优化查询时大多采用传统的针对数据库层面的性能收集工具,各种数据库通过结构化查询语言(StructuredQuery Language,简称为SQL)进行连接互通,使用SQL语言可以更新数据库中的数据,从数据库中提取数据等。 Currently, developers mostly used during traditional database query optimization level of performance collection tool for a variety of databases through the Structured Query Language (StructuredQuery Language, abbreviated as SQL) to connect interoperability, the use of SQL language can update the data in the database extracting data from the database. 较为常见的关系型数据库管理系统都采用SQL语言,比如关系数据库管理系统SQL Server0数据库引擎是用于存储、处理和保护数据的核心服务。 More common relational database management systems use SQL language, such as relational database management system SQL Server0 database engine is the core service for storing, processing and data protection. 利用数据库引擎可控制访问权限并快速处理事务,从而满足企业内要求极高而且需要处理大量数据的应用需要。 You can control access and rapid transaction processing to meet the need for highly demanding applications within the enterprise and the need to process large amounts of data using the database engine. 使用数据库引擎创建用于联机事务处理或联机分析处理数据的关系数据库。 Create online transaction processing or online analytical processing data in relational databases using the database engine. 这包括创建用于存储数据的表和用于查看、管理和保护数据安全的数据库对象(如索引、视图和存储过程)。 This includes creating tables for storing data and for viewing, managing and protecting data security database objects (such as indexes, views, and stored procedures). 其中,使用SQL Server Profiler捕获服务器事件。 Among them, use SQL Server Profiler to capture server events. SQL ServerProfiler是SQL跟踪的图形用户界面,用于监视数据库引擎或者分析业务的实例。 SQL ServerProfiler SQL Trace is a graphical user interface, for example to monitor or analyze database engine business. SQLServer Profiler可以捕获有关每个事件的数据并将其保存到文件或者表中供以后分析。 SQLServer Profiler can capture data about each event and save it to a file or table for later analysis. SQL Server Profiler是针对数据库层面的工具,在获取用户的查询行为时,必须要运行SQLServer,而SQL Server的运行会消耗系统性能,严重影响用户的查询行为。 SQL Server Profiler is a tool for database level, when obtaining the user's query behavior must be running SQLServer, and running SQL Server consumes system performance, seriously affecting the behavior of the user's query. 此外,使用SQLServer Profiler等数据库层面的工具在获取查询信息过程中会收集很多无关的事件,语句等,淹没了有效的查询信息,严重影响用户的查询体验。 In addition, the use of databases such as SQLServer Profiler level tools will get the query information in the course of many unrelated events, statements, etc., flooded efficient query information, seriously affecting the user's query experience.

[0003] 针对相关技术中在收集网络查询信息时容易收集到无关信息的问题,目前尚未提出有效的解决方案。 [0003] in the related art in the collection of easy to collect network information to query the issue irrelevant information has not yet come up with effective solutions.

发明内容 SUMMARY

[0004] 本发明的主要目的在于提供一种网站查询收集方法和装置,以解决在收集网络查询信息时容易收集到无关信息的问题。 [0004] The main object of the present invention is to provide a method and apparatus for collecting website, in order to solve the problem in the collection of information is easily gathered web queries the irrelevant information.

[0005] 为了实现上述目的,根据本发明的一个方面,提供了一种网站查询收集方法。 [0005] To achieve the above object, according to one aspect of the invention, there is provided a method for collecting website. 该网站查询收集方法包括:网站控制器接收查询请求;网站控制器将查询请求转化为查询语句;网站控制器执行查询语句,并获取执行查询语句得到的查询结果;以及网站控制器记录查询结果。 The website collection method comprising: receiving a query request to Site controller; site controller query into query request; site controller executes the query, and obtaining query results obtained performing the query statement; and Site controller records query results.

[0006] 进一步地,网站控制器通过网站上的显示界面接收外部输入的查询请求,在网站上设置有用于提供输入查询请求的界面。 [0006] Further, the site controller receives a query request through the external input interface displayed on the site, there is provided an interface for providing input query request on the site.

[0007] 进一步地,网站控制器将查询请求转化为查询语句包括:网站控制器对查询请求进行分析处理,获取查询请求中的查询条件,其中,查询条件用于指示查询满足查询条件的查询结果;以及网站控制器将查询条件转化为查询语句。 [0007] Further, the site controller query request into a query comprising: a site controller for analyzing and processing the query request, acquiring a query condition query request, wherein the query criteria for a query indicates query results that satisfy the query ; and site controller will query into a query.

[0008] 进一步地,在网站控制器将查询请求转化为查询语句之后,网络查询收集方法还包括:判断网站控制器是否开始执行查询语句;如果判断出网站控制器开始执行查询语句,则记录起始时刻,其中,起始时刻为网站控制器开始执行查询语句的时刻;在网站控制器执行查询语句之后,网络查询收集方法还包括:判断网站控制器执行查询语句是否完成;如果判断出网站控制器执行查询语句完成,则记录结束时刻,其中,结束时刻为网站控制器执行查询语句结束的时刻;在记录起始时刻和结束时刻之后,网络查询收集方法还包括:通过起始时刻和结束时刻计算网站控制器执行查询语句的时长。 [0008] Further, the site controller after converting the query request query, the query web collection method further comprising: determining whether the site controller starts executing the query; if it is determined that the site controller starts executing the query, the records from start time, wherein the starting time of the start site for the query execution timing controller; site after the controller execute a query, the query web collection method further comprising: determining whether the site controller executes a complete query; if it is determined that the control site performs the query is completed, the recording end time, in which the end time of the query execution time for the end of the site controller; after recording the start time and end time, network queries collection method further comprises: by the start time and end time when calculating the site controller executes the query length.

[0009] 进一步地,查询请求中携带有用户标识,用户标识为用于输入查询请求的用户的标识,在网站控制器接收查询请求之后,网络查询收集方法还包括:对查询请求进行分析处理,获取查询请求中携带的用户标识;网站控制器记录查询结果包括:网站控制器记录用户标识,查询结果,并记录用户标识和查询结果之间的对应关系。 [0009] Furthermore, the query request carries a user identifier, a user identifier for the user to enter a query request identification, site controller, after receiving a query request, the network queries collection method further comprising: analyzing and processing the query request, acquiring the user identifier carried in the query request; site controller records the search results comprising: a site controller records the user ID, query results, and recording a corresponding relationship between the user identifier and the query results.

[0010] 进一步地,在网站控制器记录用户标识,查询结果,并记录用户标识和查询结果之间的对应关系之后,方法还包括:网站控制器接收第一统计请求,其中,第一统计请求用于请求对第一用户的查询次数进行统计;网站控制器获取第一用户标识,第一用户标识为第一用户对应的用户标识;网站控制器根据对应关系获取第一用户标识对应的查询结果;以及网站控制器根据第一用户标识对应的查询结果对第一用户的查询次数进行统计。 After [0010] Further, recording a user identification, the query results in the site controller, and recording correspondence relationship between the user identifier and the query result, the method further comprising: receiving a first site controller Statistics request, wherein the first Statistics request the number of times for requesting the first user query statistics; site controller acquires a first user identifier, a first user to a first user identifier corresponding to the user identifier; site controller obtains a query result corresponding to a first user identifier based on the correspondence ; and a controller counting how often the site of the first user's query based on the query results corresponding to the first user identification.

[0011] 进一步地,网站控制器记录查询结果之后,网络查询收集方法包括:获取存储装置的网络入口地址,其中,存储装置用于存储查询结果;生成插入查询结果的语句;以及将语句写入到网络入口地址对应的存储装置中。 After [0011] Further, the site controller records the results of the query, the query web collection method comprising: obtaining a network address storage means inlet, wherein the storage means for storing a query result; generating insert query statement result; and writing statements address storage means to the corresponding network entry.

[0012] 为了实现上述目的,根据本发明的另一方面,提供了一种网络查询收集装置。 [0012] To achieve the above object, according to another aspect of the present invention, there is provided a collecting device queries the network. 该网络查询收集装置包括:第一接收模块,用于网站控制器接收查询请求;转化模块,用于网站控制器将查询请求转化为查询语句;执行模块,用于网站控制器执行查询语句,并获取执行查询语句得到的查询结果;以及第一记录模块,用于网站控制器记录查询结果。 The network queries collecting apparatus comprising: a first receiving module, site controller for receiving a query request; conversion module, site controller for the query into query request; execution module, site controller to execute a query, and get query execution results obtained; and a first recording module for the site controller records the query results.

[0013] 进一步地,网络查询收集装置还包括:第一判断模块,用于判断网站控制器是否开始执行查询语句;第二记录模块,用于当判断出网站控制器开始执行查询语句时,则记录起始时刻,其中,起始时刻为网站控制器开始执行查询语句的时刻;第二判断模块,用于判断网站控制器执行查询语句是否完成;第三记录模块,用于当判断出网站控制器执行查询语句完成时,则记录结束时刻,其中,结束时刻为网站控制器执行查询语句结束的时刻;计算模块,用于通过起始时刻和结束时刻计算网站控制器执行查询语句的时长。 [0013] Further, the network apparatus further comprising collecting the query: a first determining module, for determining whether the site controller starts executing the query statement; a second recording module, configured to, when it is determined that the site controller starts executing the query, the recording start time, wherein the start time for the site controller begins execution time of the query statement; a second determining module configured to determine whether the site controller to perform complete query; third recording module, configured to, when it is determined that the control site performs query statement is completed, the recording end time, wherein the end time of the end of the query execution time for the site controller; calculating module for calculating the duration of performing a query by the site controller starting time and the end time.

[0014] 进一步地,网络查询收集装置还包括:分析处理模块,用于对查询请求进行分析处理,获取查询请求中携带的用户标识;第四记录模块,用于网站控制器记录用户标识,查询结果,并记录用户标识和查询结果之间的对应关系;第二接收模块,用于网站控制器接收第一统计请求,其中,第一统计请求用于请求对第一用户的查询次数进行统计;第一获取模块,用于网站控制器获取第一用户标识,第一用户标识为第一用户对应的用户标识;第二获取模块,用于网站控制器根据对应关系获取第一用户标识对应的查询结果;以及统计模块,用于网站控制器根据第一用户标识对应的查询结果对第一用户的查询次数进行统计。 [0014] Further, the network queries collecting apparatus further comprises: analysis means for analyzing and processing the query request, acquiring a user identifier carried in the query request; fourth recording means for recording user site controller identifier, a query As a result, and recording a corresponding relationship between the user identifier and the query result; a second receiving module configured to receive a first site controller statistics request, wherein a first request for requesting the statistical number of times the first user query statistics; a first acquiring module, for acquiring a first site controller user identifier, a first user to a first user identifier corresponding to the user identifier; a second acquiring module, for acquiring a first site controller identifier corresponding to a user query according to the correspondence result; and a counting module, site controller for counting how often a first user query according to a query result corresponding to a first user identity.

[0015] 通过本发明,采用网站控制器接收查询请求;网站控制器将查询请求转化为查询语句;网站控制器执行查询语句,并获取执行查询语句得到的查询结果;以及网站控制器记录查询结果,在网络层通过网站控制器执行并记录执行查询语句得到的查询结果,避免了通过数据库性能收集工具收集信息容易收集到无关信息,解决了在收集网络查询信息时容易收集到无关信息的问题,进而达到了优化查询体验的效果。 [0015] By the present invention, a site controller receives a query request; site controller query into query request; site controller executes the query, and obtaining query results obtained performing the query statement; and Site controller records the results of the query in the network layer through the site controller to perform and record the results of the SQL query will execute the query, to avoid the collection tool to collect information unrelated to easily gather information, solve problems in the collection of network query information easy to gather information through a database-independent performance, thus achieving the optimization of queries to experience the effect.

附图说明 BRIEF DESCRIPTION

[0016] 构成本申请的一部分的附图用来提供对本发明的进一步理解,本发明的示意性实施例及其说明用于解释本发明,并不构成对本发明的不当限定。 [0016] The drawings constitute a part of this application are intended to provide further understanding of the invention, exemplary embodiments of the present invention are used to explain the present invention without unduly limiting the present invention. 在附图中: In the drawings:

[0017] 图1是根据本发明的网站查询收集方法的第一实施例的流程图; [0017] FIG. 1 is a flowchart illustrating a first embodiment of the method according to the query collection site to the present invention;

[0018] 图2是根据本发明的网站查询收集方法的第二实施例的流程图; [0018] FIG 2 is a flowchart of a second embodiment of the method according to the query collection site to the present invention;

[0019] 图3是根据本发明的网站查询收集装置的第一实施例的示意图;以及 [0019] FIG. 3 is a schematic view of a first embodiment of the present invention is the site of the collecting device queries; and

[0020] 图4是根据本发明的网站查询收集装置的第二实施例的示意图。 [0020] FIG. 4 is a schematic view of a second embodiment of the query collecting apparatus according to the present invention is the site.

具体实施方式 detailed description

[0021] 需要说明的是,在不冲突的情况下,本申请中的实施例及实施例中的特征可以相互组合。 [0021] Incidentally, in the case of no conflict, embodiments and features of the embodiments of the present application can be combined with each other. 下面将参考附图并结合实施例来详细说明本发明。 Below with reference to accompanying drawings and embodiments of the present invention will be described in detail.

[0022] 为了使本领域的技术人员更好的理解本发明方案,下面将结合本发明实施例中的附图,对本发明实施例中的技术方案进行清楚、完整地描述,显然,所描述的实施例仅仅是本发明一部分的实施例,而不是全部的实施例。 [0022] In order to enable those skilled in the art a better understanding of the invention, in conjunction with the following drawings of the present invention embodiments, the technical solutions of the embodiments of the present invention will be clearly and completely described, obviously, the described Example embodiments are merely part of embodiments of the present invention rather than all embodiments. 基于本发明中的实施例,在本领域普通技术人员没有做出创造性劳动前提下所获得的所有其他实施例,都应当属于本发明的保护范围。 Based on the embodiments of the present invention, all other embodiments of ordinary skill in the art without creative efforts shall be made available, shall fall within the protection scope of the present invention.

[0023] 需要说明的是,本发明的说明书和权利要求书及上述附图中的术语“第一”、“第二”等是用于区别类似的对象,而不必用于描述特定的顺序或先后次序。 [0023] Incidentally, the above-mentioned book and in the figures the terms "first," "second," and the like are used for distinguishing between similar objects, and not necessarily for describing a particular sequential or claimed in the specification and claims of the present invention priorities. 应该理解这样使用的数据在适当情况下可以互换,以便这里描述的本发明的实施例能够以除了在这里图示或描述的那些以外的顺序实施。 It should be understood that the data so used are interchangeable under appropriate circumstances, embodiments of the present invention described herein are capable to addition order than those in the embodiments illustrated or described herein. 此外,术语“包括”和“具有”以及他们的任何变形,意图在于覆盖不排他的包含。 Furthermore, the terms "including" and "having," as well as any of their deformation, intended to cover non-exclusive inclusion.

[0024] 本发明旨在提供一种网站查询收集方法及装置。 [0024] The present invention aims to provide a method and apparatus for collecting website. 图1是根据本发明的网站查询收集方法的第一实施例的流程图,如图1所示,该网站查询收集方法包括如下的步骤SlOl至步骤S104: FIG 1 is a flowchart of a first embodiment of the present invention, the method for collecting site inquiry, as shown, the website collecting method comprising the steps of SlOl to step S104 in FIG. 1:

[0025] 步骤S101,网站控制器接收查询请求。 [0025] step S101, the controller receives a query request sites.

[0026] 本发明实施例中的网站是根据模型视图控制器(Model View Controller,简称为MVC)模式设计的,网站控制器是根据MVC模式设计的网站的控制器,该网站控制器位于网络层。 [0026] Example embodiments of the present invention is the site Model View Controller (Model View Controller, simply referred to as MVC) pattern design, site controller is designed according to the MVC pattern site controller, the site controller at the network layer . 在该网站上设置有显示界面,该显示界面为用于提供查询请求输入的界面,网站控制器通过网站上的显示界面接收外部输入的查询请求。 Provided on the site display interface, the display interface is an interface for providing input query request, the site controller receives a query request through the external input interface displayed on the site. MVC是一种程序开发设计模式,实现了显示模块与功能模块的分离,提高了程序的可维护性、可移植性、可扩展性与可重用性,降低了程序的开发难度。 MVC design pattern is a program development, to achieve the separation of the display module and the function module, the program improve maintainability, portability, scalability and reusability, reduce the development process more difficult. MVC包括模型、视图、控制器三层。 Including MVC model, view, controller three. 模型是应用程序的主体部分,主要包括业务逻辑模块和数据模块。 Model is the main part of the application, including the business logic modules and data modules. 模型与数据格式无关,这样一个模型能为多个视图提供数据。 Independent models and data format, such a model can provide data for a plurality of views. 由于应用于模型的代码只需写一次就可以被多个视图重用,所以减少了代码的重复。 Since the code is applied to the model only write once to be reused multiple views, so reducing the duplication of code. 视图提供与用户的交互的界面。 Interactive interface view offers the user. 控制器接收来自界面的请求并交给模型进行处理。 The controller receives the request from the interface and to the process model. 本发明实施例基于MVC设计模式,设计网站,利用网站控制器处理网站前端用户输入的查询请求,并封装了网站的业务逻辑。 Embodiments of the present invention is based on the MVC design pattern, the design website, using website controller queries the user input processing front end site and the site encapsulates business logic. 网站控制器将用户输入的查询请求转化为相应的查询语句,并执行查询操作,获取查询信息,将执行查询语句得到的查询信息进行存储,便于汇总数据,找出查询瓶颈。 Site controller will query request input by the user into the corresponding query statement, and execute the query operation information acquiring a query, executes the query information of the SQL query store, easy to aggregate data, the query to find bottlenecks.

[0027] 网站控制器接收的查询请求中携带有用户标识,用户标识为用于输入查询请求的用户的标识,在网站控制器接收查询请求之后,网站控制器对查询请求进行分析处理,获取查询请求中携带的用户标识。 [0027] The site controller receives the query request carries a user identifier, a user identifier for user identification input query request, the query request after receiving site controller, site controller for analyzing and processing the query request, acquiring a query a user identifier carried in the request.

[0028] 步骤S102,网站控制器将查询请求转化为查询语句。 [0028] step S102, the website controller queries into a query.

[0029] 网站控制器接收查询请求后对查询请求进行分析处理,获取查询请求中的查询条件。 [0029] The site controller, after receiving a query request for analyzing and processing the query request, acquiring a query condition query request. 其中,查询条件用于指示查询满足查询条件的查询结果。 Among them, the query is used to indicate the query results that satisfy the query. 获取查询条件之后网站控制器将查询条件转化为查询语句。 After acquiring the site controller will query query into a query.

[0030] 步骤S103,网站控制器执行查询语句,并获取执行查询语句得到的查询结果。 [0030] step S103, a site controller executes the query, execute the query and get the results of the SQL query.

[0031] 网站控制器将查询请求转化为查询语句后执行该查询语句。 [0031] The site controller executes the query request into a query after query. 本发明网站查询收集方法为了优化查询,在网站控制器将查询请求转化为查询语句之后,判断网站控制器是否开始执行查询语句;如果判断出网站控制器开始执行查询语句,则记录起始时刻,其中,起始时刻为网站控制器开始执行查询语句的时刻;在网站控制器执行查询语句之后,判断网站控制器执行查询语句是否完成;如果判断出网站控制器执行查询语句完成,则记录结束时刻,其中,结束时刻为网站控制器执行查询语句结束的时刻;在记录起始时刻和结束时刻之后,通过起始时刻和结束时刻计算网站控制器执行查询语句的时长。 Website collection method of the present invention in order to optimize the query, the site controller after the query into query request, determines whether the site controller starts executing the query; if it is determined that the site controller starts executing the query, the recording starting time, among them, the starting time for the site controller starts executing time of the query; after a site controller executes the query, to determine the site controller executes the query is complete; if it is determined the site controller executes the query is completed, the recording end time in which the end time of the query execution time for the end of the site controller; when after recording the start time and end time, the site controller is calculated by the start time and end time execute a query length.

[0032] 步骤S104,网站控制器记录查询结果。 [0032] step S104, the website controller records the query results.

[0033] 网站控制器执行查询语句后获取执行查询语句得到的查询结果,其中,该查询结果包括网站控制器执行查询语句的时长,用户标识,以及用户标识和执行该用户标识对应的用户的查询请求得到的查询结果的对应关系。 [0033] The site controller performs the query in a query result obtaining the SQL query, wherein the query result includes a site controller executes the query length, user identification, user identification and query execution and user identifier corresponding to the user correspondence relationship request query results obtained.

[0034] 网站控制器记录查询结果之后,将该查询结果进行存储。 [0034] After the site controller records the query results, the query results are stored. 首先获取存储装置的网络入口地址,其中,存储装置用于存储查询结果。 First, obtain the network address storage means inlet, wherein the storage means for storing a query result. 然后生成插入查询结果的语句,并将语句写入到网络入口地址对应的存储装置中。 Query result is then generated insert statement and the statement written to the memory means a network address corresponding to the entry. 本发明实施例中的存储装置可以是数据表,也可以是其他能够实现存储功能的容器。 Embodiments of the present invention may be a data storage device table, and may be other container storage function can be realized. 将执行查询语句得到的查询结果写入存储装置有多种实现方法。 The results obtained by executing the query statement written to the storage device has a variety of implementations. 比如,假如存储装置为数据表,那么可以采用NLog、Entityframework等方式。 For example, if the storage device is a data table, you may be employed NLog, Entityframework like. 优选地,本发明实施例中将执行查询语句得到的查询结果写入数据表直接采用SQL语句,生成将查询结果插入该数据表的SQL语句。 Preferably, the query results in the query execution Example embodiments of the present invention obtained in the write data table directly from the SQL statement, query results generated SQL statement is inserted in the Table. 网站控制器执行该SQL语句,将查询结果写入网络入口地址对应的存储装置中。 Site controller executes the SQL statement, query results into the storage means an entry address corresponding to a network.

[0035] 本发明实施例的网站查询收集方法采用网站控制器接收查询请求;网站控制器将查询请求转化为查询语句;网站控制器执行查询语句,并获取执行查询语句得到的查询结果;以及网站控制器记录查询结果,解决了在收集网络查询信息时容易收集到无关信息的问题,进而达到了优化查询体验的效果。 [0035] website collecting method embodiment of the present invention uses site controller receives the query request; site controller query into query request; site controller executes the query, and obtaining query results obtained performing the query statement; and Site controller records the query results to solve the problems in the collection of network query information easy to gather irrelevant information, thus achieving the optimization of queries to experience the effect. 同时,将执行查询语句得到的查询结果、用户标识以及网络控制器执行查询语句的时长进行存储,便于快速分析查询耗时和查询次数等信息,从而实现针对性的优化查询。 Meanwhile, the query execution query results obtained, the user ID and the length of the network controller stores the execution of the query statement, query information to facilitate rapid analysis and time-consuming queries, etc., in order to achieve targeted optimization of queries.

[0036] 图2是根据本发明的网站查询收集方法的第二实施例的流程图,如图2所示,为了快速分析用户查询次数,该网站查询收集方法包括如下的步骤S201至步骤S208: [0036] FIG 2 is a flowchart of a second embodiment of the present invention the website Example query collection methods, in order to quickly analyze the number of queries the user, the website collecting method comprising the steps of S201 to step S208 in FIG. 2:

[0037] 步骤S201至S204,同上述的步骤SlOl至S104。 [0037] Step S201 to S204, with the above-described steps SlOl to S104.

[0038] 步骤S205,网站控制器接收第一统计请求,其中,第一统计请求用于请求对第一用户的查询次数进行统计。 [0038] Step S205, the controller receives a first site Statistics request, wherein a first request for requesting the statistical number of times the first user query statistics.

[0039] 为了更准确的分析查询次数,本发明实施例的网讯查询收集方法可以实现对同一用户的不用查询次数的统计分析,还可以实现对相同查询请求的不同用户的统计分析。 [0039] For a more accurate analysis of the number of queries, the query Reuters collecting method embodiment of the present invention can be achieved without statistical analysis of the frequency and the same user's query, statistical analysis of different users for the same query request may also be implemented. 本发明实施例中的查新结果中不仅包含用户标识,执行查询语句得到的查询结果,同时还包含有用户标识与查询结果的对应关系。 The embodiments of the present invention includes not only the result of the checking a user identification, query execution query results obtained, also contains the subscriber identifier and the correspondence relationship query results. 当网站控制器记录完查询结果之后,为了优化查询,可以从查询结果中快速找到并分析查询次数。 After completion of the site controller records the query results, in order to optimize the query, you can quickly find and analyze queries from the query results. 网站控制器接收的第一统计请求用于请求对第一用户的查询次数进行统计。 The first statistical site controller receives a request for the number of times the first request for the user's query statistics.

[0040] 步骤S206,网站控制器获取第一用户标识,第一用户标识为第一用户对应的用户标识。 [0040] step S206, the controller acquires a first site user identifier, a first user identifier for the first user corresponding to the user identifier.

[0041] 为了统计不同用户的查询次数,网站控制器首先要获取不同用户的用户标识,以及用户标识与执行查询语句得到的查询结果的对应关系。 [0041] In order to count the number of different user's query, the site controller must first get a different user's user ID, and the correspondence between the results of the query the user identification and execution of the SQL query. 本发明实施例中的第一用户不仅限于第一个用户,此处的第一用户可以是在网站输入查询请求的任意用户。 Embodiments of the present invention is not limited to the first user the first user, where the first user input query request may be any user on a website. 本发明实施例中优选地将用户所在的服务器的网络地址作为用户标识,网络地址只是本发明的优选实施方式,根据需要该用户标识还可以是用户在网站上注册的用户名等。 In preferred embodiments of the present invention, the embodiment of the network address of the server where the user is a preferred embodiment of a user identifier, a network address is just the present invention, the needs of the user identification may also be the user registered on site and user name.

[0042] 步骤S207,网站控制器根据对应关系获取第一用户标识对应的查询结果。 [0042] In step S207, the controller accesses the website search results corresponding to a first user identifier based on the correspondence.

[0043] 由于网站控制器中记录有用户标识与查询结果的对应关系,因此,在获取用户标识之后,网站控制器可以直接获取与该用户标识相对应的查询结果。 [0043] Since the site controller records a corresponding relationship between the user identifier and the query results, therefore, after acquiring a user identifier, the site controller may obtain query results corresponding to the user ID directly.

[0044] 步骤S208,网站控制器根据第一用户标识对应的查询结果对第一用户的查询次数进行统计。 [0044] step S208, count the number of times the site controller a first user query according to a query result corresponding to a first user identity.

[0045] 用户在一段时间内可能进行了多次查询行为。 [0045] user over a period of time may be a number of query behavior. 网站控制器通过记录用户标识与执行查询语句得到的查询结果的对应关系,可以从该对应关系中筛选出第一用户的查询结果,通过对该第一用户的查询结果进行统计得到第一用户的查询次数。 Website controller records the correspondence between the results of the query user identification and execution of the SQL query, you can filter out from the correspondence between the results of the first user's query, the query results by the first user statistics to get a first user queries. 同理,网站控制器可以对任意在该网络上输入查询请求的用户的查询次数进行统计分析。 Similarly, the site controller can enter the number of the user's query request inquiry for any statistical analysis on the network.

[0046] 该实施例的网站查询收集方法采用网站控制器接收查询请求;网站控制器将查询请求转化为查询语句;网站控制器执行查询语句,并获取执行查询语句得到的查询结果;以及网站控制器记录查询结果;网站控制器接收第一统计请求,其中,第一统计请求用于请求对第一用户的查询次数进行统计;网站控制器获取第一用户标识,第一用户标识为第一用户对应的用户标识;网站控制器根据对应关系获取第一用户标识对应的查询结果;以及网站控制器根据第一用户标识对应的查询结果对第一用户的查询次数进行统计,解决了在收集网络查询信息时容易收集到无关信息的问题,进而达到了优化查询体验的效果。 [0046] website collection method of this embodiment employs site controller receives a query request; site controller query into query request; site controller executes the query, and obtaining query results obtained performing the query statement; and Site Control results records; site controller receives a first request statistics, wherein a first request for requesting the statistical number of times the first user query statistics; site controller acquires a first user identifier, a first user to a first user identifier corresponding user identification; the site controller to obtain query results corresponding to the first user identifier based on the correspondence; and a controller counting how often the site of the first user's query based on the query results of the first user identifier corresponding to solve the query in the collection network easy to collect information unrelated to the question of when the information, thus achieving the optimization of queries to experience the effect. 同时,利用网站控制器记录用户标识与执行查询语句得到的查询结果的对应关系,可以快速统计分析用户的查询次数。 At the same time, the use of the site controller records the correspondence between the results of user identification and execution of the SQL query, you can quickly statistical analysis of the number of times the user's query.

[0047] 需要说明的是,在附图的流程图示出的步骤可以在诸如一组计算机可执行指令的计算机系统中执行,并且,虽然在流程图中示出了逻辑顺序,但是在某些情况下,可以以不同于此处的顺序执行所示出或描述的步骤。 [0047] It should be noted that the steps illustrated in the flowchart drawings can be executed on a computer system such as a set of executable instructions, and, although in the flowchart shown in a logical order, but in some case, the steps shown or may be performed in a different order than described herein.

[0048] 本发明实施例还提供了一种网站查询收集装置。 [0048] Embodiments of the present invention further provides a website collecting device. 需要说明的是,该网站查询收集装置可以用于执行本发明实施例的网站查询收集方法。 It should be noted that the website can be collected by means for performing queries embodiment site collection method embodiment of the present invention.

[0049] 图3是根据本发明的网站查询收集装置的第一实施例的示意图。 [0049] FIG. 3 is a schematic view of a first embodiment of the collection device of the present invention according to the website query. 如图3所示,该网站查询收集装置包括:第一接收模块10,转化模块20,执行模块30和第一记录模块40。 Collecting apparatus As shown, the website 3 comprising: a first receiving module 10, conversion module 20, the execution module 30 and the first recording module 40.

[0050] 第一接收模块10,用于网站控制器接收查询请求。 [0050] a first receiving module 10, the controller receiving a query request for the website.

[0051] 转化模块20,用于网站控制器将查询请求转化为查询语句。 [0051] The conversion module 20, a site controller will query into query request.

[0052] 其中,转化模块20具体包括获取子模块,用于网站控制器对查询请求进行分析处理,获取查询请求中的查询条件,其中,查询条件用于指示查询满足查询条件的查询结果;转化子模块,用于网站控制器将查询条件转化为查询语句。 [0052] wherein the conversion module 20 specifically includes obtaining sub-module, site controller for analyzing and processing the query request, acquiring a query condition query request, wherein the query criteria for a query indicates query result satisfies the query condition; Conversion sub-module, site controller for the query into a query.

[0053] 执行模块30,用于网站控制器执行查询语句,并获取执行查询语句得到的查询结果O [0053] The execution module 30 for site controller executes the query, execute a query and get results obtained in O

[0054] 第一记录模块40,用于网站控制器记录查询结果。 [0054] The first recording module 40 for site controller records the query results. 其中,第一记录模块40还可以用于网站控制器记录用户标识,查询结果,并记录用户标识和查询结果之间的对应关系。 Wherein the first recording module 40 may also be used for site controller records the user ID, query results, and recording a corresponding relationship between the user identifier and the query results.

[0055] 该实施例的网站查询装置还包括:第一判断模块,第二记录模块,第二判断模块,第三记录模块和计算模块。 [0055] The website apparatus embodiment further comprises: a first judging module, a second recording module, a second determination module, a calculation module and a third recording module. 其中,第一判断模块,用于判断网站控制器是否开始执行查询语句。 Wherein the first determining module configured to determine whether the site controller starts executing the query. 第二记录模块,用于当判断出网站控制器开始执行查询语句时,则记录起始时刻,其中,起始时刻为网站控制器开始执行查询语句的时刻。 A second recording module, configured to, when it is determined that the site controller starts executing the query, the recording start time, wherein the starting time of the time begin to query site controller. 第二判断模块,用于判断网站控制器执行查询语句是否完成。 A second determination module configured to determine whether the site controller executes the query is complete. 第三记录模块,用于当判断出网站控制器执行查询语句完成时,则记录结束时刻,其中,结束时刻为网站控制器执行查询语句结束的时刻。 The third recording module for the site when it is determined that the controller executes the query is completed, the recording end time, in which the end time of the query execution time for the end of the site controller. 计算模块,用于通过起始时刻和结束时刻计算网站控制器执行查询语句的时长。 Calculation module, for the duration of the query execution site controller is calculated by the start time and end time.

[0056] 本实施例的网站查询收集装置包括第一接收模块10,转化模块20,执行模块30,第一记录模块40。 [0056] Example embodiment of this site queries collecting means comprises a first receiving module 10, conversion module 20, the execution module 30, a first recording module 40. 为了对用户的查询次数进行统计,该实施例的网站查询装置还包括第一判断模块,第二记录模块,第二判断模块,第三记录模块和计算模块。 To count the number of times the user's query, website apparatus of this embodiment further includes a first determining module, a second recording module, a second determination module, a calculation module and a third recording module. 通过该实施例,解决了在收集网络查询信息时容易收集到无关信息的问题,进而达到了优化查询体验的效果。 With this embodiment, to solve the problems in the collection of network query information easy to gather irrelevant information, thus achieving the optimization of queries to experience the effect. 同时,利用网站控制器记录用户标识与执行查询语句得到的查询结果的对应关系,便于快速统计分析用户的查询次数。 At the same time, the use of the site controller records the correspondence between the results of user identification and execution of the SQL query for quick statistical analysis of the number of times the user's query.

[0057] 图4是根据本发明的网站查询收集装置的第二实施例的示意图。 [0057] FIG. 4 is a schematic view of a second embodiment of the query collecting apparatus according to the present invention is the site. 如图4所示,该网站查询收集装置包括:第一接收模块10,转化模块20,执行模块30,第一记录模块40,分析处理模块110,第四记录模块120,第二接收模块130,第一获取模块140,第二获取模块150和统计模块160。 Collection means shown in FIG. 4 the website comprises: a first receiving module 10, conversion module 20, the execution module 30, a first recording module 40, evaluation module 110, a fourth recording module 120, a second receiving module 130, a first acquiring module 140, a second acquisition module 150 and statistics module 160.

[0058] 分析处理模块110,用于对查询请求进行分析处理,获取查询请求中携带的用户标识。 [0058] The evaluation module 110 for analyzing and processing the query request, acquiring a user identifier carried in the query request.

[0059] 第四记录模块120,用于网站控制器记录用户标识,查询结果,并记录用户标识和查询结果之间的对应关系。 [0059] The fourth recording module 120 for recording user control site identification, query results, and recording a corresponding relationship between the user identifier and the query results.

[0060] 第二接收模块130,用于网站控制器接收第一统计请求,其中,第一统计请求用于请求对第一用户的查询次数进行统计。 [0060] The second receiving module 130, a controller for receiving a first site Statistics request, wherein a first request for requesting the statistical number of times the first user query statistics.

[0061] 第一获取模块140,用于网站控制器获取第一用户标识,第一用户标识为第一用户对应的用户标识。 [0061] The first acquisition module 140, a site controller acquires a first user identifier, a first user identifier for the first user corresponding to the user identifier.

[0062] 第二获取模块150,用于网站控制器根据对应关系获取第一用户标识对应的查询结果。 [0062] The second acquiring module 150, the controller acquires a site identifier corresponding to the first user query result according to the corresponding relation.

[0063] 统计模块160,用于网站控制器根据第一用户标识对应的查询结果对第一用户的查询次数进行统计。 [0063] The statistics module 160, a controller for counting how often the site of the first user query according to a query result corresponding to a first user identity.

[0064] 本发明实施例的网站查询收集装置包括:第一接收模块10,转化模块20,执行模块30,第一记录模块40,分析处理模块110,第四记录模块120,第二接收模块130,第一获取模块140,第二获取模块150和统计模块160。 [0064] website collection device embodiment of the present invention comprises: a first receiving module 10, conversion module 20, the execution module 30, a first recording module 40, evaluation module 110, a fourth recording module 120, a second receiving module 130 The first acquiring module 140, a second acquisition module 150 and statistics module 160. 该网站查询收集装置还可以包括:第三获取模块,用于获取存储装置的网络入口地址,其中,存储装置用于存储查询结果;生成模块,用于生成插入查询结果的语句;写入模块,用于将语句写入到网络入口地址对应的存储装置中。 The website collecting apparatus may further comprise: a third acquiring module, for acquiring a network entry address storage means, wherein the storage means for storing a query result; generating module for generating insert query statement result; write module, statements for writing to the storage means an entry address corresponding to a network. 通过本发明实施例的网站查询收集装置解决了在收集网络查询信息时容易收集到无关ί目息的问题。 Site embodiment of the present invention solves the problem of collecting device query in the collection of information is easily collected web queries ί irrespective of destination information.

[0065] 本发明的网站查询收集方法和装置,利用网站控制器获取查询请求,将该查询请求转化为查询语句,执行查询语句并获取执行查询语句得到的查询结果,以及记录查询结果,上述有关查询的行为和记录执行查询行为相关的查询信息都是通过网站的控制器实现的,该网站查询手机方法及装置解决了在收集网络查询信息时容易收集到无关信息的问题,进而达到了优化查询体验的效果。 [0065] website collection method and apparatus of the present invention, the controller accesses the website using a query request, the query request into a query, execute the query and obtain query results obtained performing the query statement, query result, and recording the relevant behavior query query query execution information and records related behavior are implemented by the controller of the website, the website phone method and device to solve the problem in the collection of network query information easy to gather irrelevant information, thus achieving optimized query experience the effect. 同时,利用网站控制器记录执行查询语句得到查询结果所用的查询时长,利用网站控制器收集执行查询语句得到的查询结果,用户标识,以及查询结果与用户标识的对应关系,可以快速的统计分析查询时长和用户的查询次数。 At the same time, the use of the site controller record executive when the SQL query query query results used by the site controller collects execute the query results the SQL query, the user identifier, and the correspondence between the query results with the user ID, you can quickly statistical analysis inquiry duration and number of user queries.

[0066] 显然,本领域的技术人员应该明白,上述的本发明的各模块或各步骤可以用通用的计算装置来实现,它们可以集中在单个的计算装置上,或者分布在多个计算装置所组成的网络上,可选地,它们可以用计算装置可执行的程序代码来实现,从而,可以将它们存储在存储装置中由计算装置来执行,或者将它们分别制作成各个集成电路模块,或者将它们中的多个模块或步骤制作成单个集成电路模块来实现。 [0066] Obviously, those skilled in the art should understand that the modules or steps of the present invention described above can be used general-purpose computing device, they can be integrated in a single computing device or distributed across multiple computing devices available on the Internet, optionally, they can be implemented with program codes executable by a computing device, so that, to be performed by a computing device stored in a storage device, or they are made into integrated circuit modules, or they plurality of modules or steps are manufactured into a single integrated circuit module. 这样,本发明不限制于任何特定的硬件和软件结合。 Thus, the present invention is not limited to any particular hardware and software combination.

[0067] 以上所述仅为本发明的优选实施例而已,并不用于限制本发明,对于本领域的技术人员来说,本发明可以有各种更改和变化。 [0067] The above description is only preferred embodiments of the present invention, it is not intended to limit the invention to those skilled in the art, the present invention may have various changes and variations. 凡在本发明的精神和原则之内,所作的任何修改、等同替换、改进等,均应包含在本发明的保护范围之内。 Any modification within the spirit and principle of the present invention, made, equivalent substitutions, improvements, etc., should be included within the scope of the present invention.

Claims (10)

  1. 1.一种网络查询收集方法,其特征在于,包括: 网站控制器接收查询请求; 所述网站控制器将所述查询请求转化为查询语句; 所述网站控制器执行所述查询语句,并获取执行所述查询语句得到的查询结果;以及所述网站控制器记录所述查询结果。 CLAIMS 1. A method for collecting network queries, characterized by comprising: a site controller receives a query request; the site controller to the query request into a query; the site controller executes the query, and acquires execute the query statement query results obtained; and the site controller records the query results.
  2. 2.根据权利要求1所述的网络查询收集方法,其特征在于,所述网站控制器通过网站上的显示界面接收外部输入的查询请求,在所述网站上设置有用于提供输入所述查询请求的界面。 The network queries collection method according to claim 1, wherein said site controller receives a query request through the external input interface displayed on the site, the site provided for providing an input to the query request interface.
  3. 3.根据权利要求1所述的网络查询收集方法,其特征在于,所述网站控制器将所述查询请求转化为查询语句包括: 所述网站控制器对所述查询请求进行分析处理,获取所述查询请求中的查询条件,其中,所述查询条件用于指示查询满足所述查询条件的查询结果;以及所述网站控制器将所述查询条件转化为所述查询语句。 The network queries collection method according to claim 1, wherein said site controller the query into the query request comprises: the site controller to the query request analysis processing, acquires the query said query request, wherein the query criteria for a query indicates query result satisfies the query condition; and the site controller the query into the query condition.
  4. 4.根据权利要求1所述的网络查询收集方法,其特征在于, 在所述网站控制器将所述查询请求转化为查询语句之后,所述网络查询收集方法还包括:判断所述网站控制器是否开始执行所述查询语句;如果判断出所述网站控制器开始执行所述查询语句,则记录起始时刻,其中,所述起始时刻为所述网站控制器开始执行所述查询语句的时刻; 在所述网站控制器执行所述查询语句之后,所述网络查询收集方法还包括:判断所述网站控制器执行所述查询语句是否完成;如果判断出所述网站控制器执行所述查询语句完成,则记录结束时刻,其中,所述结束时刻为所述网站控制器执行所述查询语句结束的时刻; 在记录所述起始时刻和所述结束时刻之后,所述网络查询收集方法还包括: 通过所述起始时刻和所述结束时刻计算所述网站控制器执行所述查询语句的时长。 4. The network queries collection method according to claim 1, characterized in that, after conversion to the site controller queries the query request, said method further comprising collecting network query: determining the site controller whether to start execution of the query statement; if it is determined that the site controller starts executing the query, the recording start time, wherein the time for starting the execution time of the start site controller query statement ; after the site controller executes the query statement, query the network to collect further comprising: determining the site controller executes the query is completed; if it is determined that the site controller executes the query is completed, the recording end time, wherein the end time is the site controller executes the query statement ending time; after the recording start time and the end time, the method further comprises collecting network query : the site controller is calculated by the start time and end time of the execution of the query long statement.
  5. 5.根据权利要求1所述的网络查询收集方法,其特征在于, 所述查询请求中携带有用户标识,所述用户标识为用于输入所述查询请求的用户的标识,在所述网站控制器接收查询请求之后,所述网络查询收集方法还包括:对所述查询请求进行分析处理,获取所述查询请求中携带的用户标识; 所述网站控制器记录所述查询结果包括:所述网站控制器记录所述用户标识,所述查询结果,并记录所述用户标识和所述查询结果之间的对应关系。 5. The method of collection of the web query to claim 1, wherein the query request carries a user identifier, the user identifier input for the query request of the user identification, the control site after receiving the query request, said method further comprising collecting network query: the query request analysis process to obtain the querying user identifier carried in the request; the site controller records the query result comprises: the site the controller records the user identifier, the query result, and records the user identifier and the correspondence between the query results.
  6. 6.根据权利要求5所述的网络查询收集方法,其特征在于,在所述网站控制器记录所述用户标识,所述查询结果,并记录所述用户标识和所述查询结果之间的对应关系之后,所述方法还包括: 所述网站控制器接收第一统计请求,其中,所述第一统计请求用于请求对第一用户的查询次数进行统计; 所述网站控制器获取第一用户标识,所述第一用户标识为所述第一用户对应的用户标识; 所述网站控制器根据所述对应关系获取所述第一用户标识对应的查询结果;以及所述网站控制器根据所述第一用户标识对应的查询结果对所述第一用户的查询次数进行统计。 6. The network queries the collection method as claimed in claim 5, wherein the site controller records the user identifier, the query result, and records the correspondence between the user identifier and the query result after relation, said method further comprising: said statistics request to receive a first site controller, wherein the first count number of the first request for requesting the user's query statistics; controller acquires a first user of the website identifying the first user identifier is a user identifier corresponding to a first user; site controller acquires a query result corresponding to the identifier of the first user according to the correspondence; and the site controller in accordance with the a first user identifier corresponding to the number of the first query result to the user's query statistics.
  7. 7.根据权利要求1所述的网络查询收集方法,其特征在于,所述网站控制器记录所述查询结果之后,所述网络查询收集方法包括: 获取存储装置的网络入口地址,其中,所述存储装置用于存储所述查询结果; 生成插入所述查询结果的语句;以及将所述语句写入到所述网络入口地址对应的存储装置中。 7. The method of collection of the web query according to claim 1, wherein said controller records the website after the query result, the method for collecting network query comprising: obtaining a network address storage means inlet, wherein said storage means for storing the query result; generating a statement in the query result; and writing the sentence storage means to the corresponding network entry address.
  8. 8.—种网络查询收集装置,其特征在于,包括: 第一接收模块,用于网站控制器接收查询请求; 转化模块,用于所述网站控制器将所述查询请求转化为查询语句; 执行模块,用于所述网站控制器执行所述查询语句,并获取执行所述查询语句得到的查询结果;以及第一记录模块,用于所述网站控制器记录所述查询结果。 8.- such networks query collecting device, characterized by comprising: a first receiving module, site controller for receiving a query request; conversion module, a site controller for the query into query request; performed module, for the site controller executes the query, and the query result acquired in executing the query statement obtained; and a first recording means for recording the results of the query site controller.
  9. 9.根据权利要求8所述的网络查询收集装置,其特征在于,所述网络查询收集装置还包括: 第一判断模块,用于判断所述网站控制器是否开始执行所述查询语句; 第二记录模块,用于当判断出所述网站控制器开始执行所述查询语句时,则记录起始时刻,其中,所述起始时刻为所述网站控制器开始执行所述查询语句的时刻; 第二判断模块,用于判断所述网站控制器执行所述查询语句是否完成; 第三记录模块,用于当判断出所述网站控制器执行所述查询语句完成时,则记录结束时刻,其中,所述结束时刻为所述网站控制器执行所述查询语句结束的时刻; 计算模块,用于通过所述起始时刻和所述结束时刻计算所述网站控制器执行所述查询语句的时长。 9. The collecting device according to query network according to claim 8, wherein said collection means further comprises a network query: a first determining module, for determining whether the site controller begins execution of the query statement; a second a recording module, configured to, when it is determined that the site controller starts executing the query, the recording start time, wherein the start time for the site controller begins execution time of the query statement; first two determination means for determining the site controller executes the query is completed; third recording module, configured to, when it is determined that the site controller executes the query is completed, the recording end time, wherein, the end time is the site controller executes the query statement ending time; calculating means for calculating the length of the site controller and the start time to the end time of execution of the query statement.
  10. 10.根据权利要求8所述的网络查询收集装置,其特征在于,所述网络查询收集装置还包括: 分析处理模块,用于对所述查询请求进行分析处理,获取所述查询请求中携带的用户标识; 第四记录模块,用于所述网站控制器记录所述用户标识,所述查询结果,并记录所述用户标识和所述查询结果之间的对应关系; 第二接收模块,用于所述网站控制器接收第一统计请求,其中,所述第一统计请求用于请求对第一用户的查询次数进行统计; 第一获取模块,用于所述网站控制器获取第一用户标识,所述第一用户标识为所述第一用户对应的用户标识; 第二获取模块,用于所述网站控制器根据所述对应关系获取所述第一用户标识对应的查询结果;以及统计模块,用于所述网站控制器根据所述第一用户标识对应的查询结果对所述第一用户的查询次数进行统计。 10. The network of claim 8, wherein the query collecting apparatus, wherein said apparatus further comprises collecting network query: analysis module for analyzing and processing the query request, the query request acquiring carried a user identifier; fourth recording means for recording the site controller to the user identifier, the query result, and records the corresponding relationship between the user identifier and the query result; a second receiving module, for the site controller receives a first request statistics, wherein the first count number of the first request for requesting the user's query statistics; a first acquiring module, for acquiring a site controller first user identifier, the first user identifier is a user identifier corresponding to the first user; a second acquiring module, for acquiring control of the website search results corresponding to the identifier of the first user according to the mapping relation; and a statistics module, the controller for counting how often the site of the first user query according to a query result corresponding to the identifier of the first user.
CN 201410550952 2014-10-16 2014-10-16 Website inquiring and collecting method and device CN104281700A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN 201410550952 CN104281700A (en) 2014-10-16 2014-10-16 Website inquiring and collecting method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN 201410550952 CN104281700A (en) 2014-10-16 2014-10-16 Website inquiring and collecting method and device

Publications (1)

Publication Number Publication Date
CN104281700A true true CN104281700A (en) 2015-01-14

Family

ID=52256573

Family Applications (1)

Application Number Title Priority Date Filing Date
CN 201410550952 CN104281700A (en) 2014-10-16 2014-10-16 Website inquiring and collecting method and device

Country Status (1)

Country Link
CN (1) CN104281700A (en)

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1484174A (en) * 2002-09-21 2004-03-24 鸿富锦精密工业(深圳)有限公司 Universal inquiry statement dynamic generation system and method
CN101159592A (en) * 2007-08-10 2008-04-09 北大方正集团有限公司;北京方正阿帕比技术有限公司;北京大学 Statistical method and device of internet data information clicking rates
CN101183393A (en) * 2007-12-21 2008-05-21 腾讯科技(深圳)有限公司 Information attention update method and device
US20100174571A1 (en) * 2009-01-04 2010-07-08 Sandra Lee Jerome Open Dealership Management System developed in MySQL, PHP, HTML, and JavaScript
CN101989195A (en) * 2009-07-30 2011-03-23 上海杉达学院 Data architecture for information system and architecture method
CN102663024A (en) * 2012-03-22 2012-09-12 北京英孚斯迈特信息技术有限公司 Data portal system for enterprise data unified platform

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1484174A (en) * 2002-09-21 2004-03-24 鸿富锦精密工业(深圳)有限公司 Universal inquiry statement dynamic generation system and method
CN101159592A (en) * 2007-08-10 2008-04-09 北大方正集团有限公司;北京方正阿帕比技术有限公司;北京大学 Statistical method and device of internet data information clicking rates
CN101183393A (en) * 2007-12-21 2008-05-21 腾讯科技(深圳)有限公司 Information attention update method and device
US20100174571A1 (en) * 2009-01-04 2010-07-08 Sandra Lee Jerome Open Dealership Management System developed in MySQL, PHP, HTML, and JavaScript
CN101989195A (en) * 2009-07-30 2011-03-23 上海杉达学院 Data architecture for information system and architecture method
CN102663024A (en) * 2012-03-22 2012-09-12 北京英孚斯迈特信息技术有限公司 Data portal system for enterprise data unified platform

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
卢言君等: "基于MVC设计模式实现通用查询组件", 《微处理机》 *
王继民: "《Web用户查询日志挖掘与应用》", 31 March 2014 *
索红军: "Visual Foxpro 查询与SQL 查询执行时间分析", 《甘肃科技》 *

Similar Documents

Publication Publication Date Title
Zheng et al. Service-generated big data and big data-as-a-service: an overview
US20130074092A1 (en) Optimized Memory Configuration Deployed on Executing Code
US7376682B2 (en) Time model
US20140156683A1 (en) Integrating event processing with map-reduce
US20050114288A1 (en) Dynamic functional module availability
US20050055673A1 (en) Automatic database diagnostic monitor architecture
US20120198073A1 (en) Dynamically organizing cloud computing resources to facilitate discovery
US20130254196A1 (en) Cost-based optimization of configuration parameters and cluster sizing for hadoop
US20070294208A1 (en) Updating a data warehouse schema based on changes in an observation model
US20030110153A1 (en) Database performance monitoring method and tool
US8694574B2 (en) Optimized settings in a configuration database with boundaries
US20070234306A1 (en) Tracing performance of machine-readable instructions
US7822710B1 (en) System and method for data collection
Zhang et al. On complexity and optimization of expensive queries in complex event processing
CN102693132A (en) Method for automatically sorting application program based on Android
US20120054146A1 (en) Systems and methods for tracking and reporting provenance of data used in a massively distributed analytics cloud
US20130159353A1 (en) Generating a test workload for a database
US8527451B2 (en) Business semantic network build
CN101404666A (en) Infinite layer collection method based on Web page
US20050108188A1 (en) Method, apparatus, and computer program product for implementing enhanced query governor functions
CN102479084A (en) Method and device for acquiring log by Android terminal
US20130305224A1 (en) Rules Engine for Architectural Governance
US20110252018A1 (en) System and method for creating search index on cloud database
CN101546308A (en) Web page search method and web page search system based on overdue retrieval
US20110252020A1 (en) Enhanced utlization of query optimization

Legal Events

Date Code Title Description
C06 Publication
C10 Entry into substantive examination