CN104281700A - Website inquiring and collecting method and device - Google Patents
Website inquiring and collecting method and device Download PDFInfo
- Publication number
- CN104281700A CN104281700A CN201410550952.0A CN201410550952A CN104281700A CN 104281700 A CN104281700 A CN 104281700A CN 201410550952 A CN201410550952 A CN 201410550952A CN 104281700 A CN104281700 A CN 104281700A
- Authority
- CN
- China
- Prior art keywords
- user
- website
- controller
- query
- inquiry
- Prior art date
- Legal status (The legal status 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 status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/951—Indexing; Web crawling techniques
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/955—Retrieval from the web using information identifiers, e.g. uniform resource locators [URL]
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
Technical field
The present invention relates to internet arena, in particular to a kind of query site collection method and device.
Background technology
Along with the fast development of large data, the search efficiency of data becomes more and more important.But user does not have authority directly to carry out data query, but carry out data query by the interface that the website that developer designs provides.The query manipulation of user can be converted into actual query statement by the website of developer's design.At present, developer adopts traditional performance collection instrument for database aspect mostly when being optimized inquiry, various database is by Structured Query Language (SQL) (Structured Query Language, referred to as SQL) carry out connection intercommunication, use sql like language can data more in new database, from database, extract data etc.Comparatively common Relational DBMS all adopts sql like language, such as relational database management system SQL Server.Database engine is for storing, processing and the kernel service of protected data.Utilize database engine to control access rights and fast processing affairs, thus meet in enterprise the application needs requiring high and needs process mass data.Usage data storehouse engine creates the relational database being used for Transaction Processing or on-line analytical processing data.This comprises the table that creates for storing data and for checking, managing and the database object (as index, view and storing process) of protected data safety.Wherein, SQL Server Profiler is used to catch server event.SQL Server Profiler is the graphic user interface that SQL follows the tracks of, for monitoring data storehouse engine or analyze the example of business.SQL Server Profiler can catch the data about each event and is saved in file or table and be provided with post analysis.SQL Server Profiler is the instrument for database aspect, when obtaining the User behavior of user, must run SQL Server, and the operation of SQL Server meeting consumption systems performance, have a strong impact on the User behavior of user.In addition, use the instrument of the database aspects such as SQL Server Profiler obtaining in Query Information process a lot of irrelevant event of collecting, statement etc., have flooded effective Query Information, and the inquiry having a strong impact on user is experienced.
For the problem easily collecting irrelevant information in correlation technique when collection network Query Information, at present effective solution is not yet proposed.
Summary of the invention
Fundamental purpose of the present invention is to provide a kind of query site collection method and device, to solve the problem easily collecting irrelevant information when collection network Query Information.
To achieve these goals, according to an aspect of the present invention, a kind of query site collection method is provided.This query site collection method comprises: website controller receives inquiry request; Inquiry request is converted into query statement by website controller; Website controller performs query statement, and obtains the Query Result performing query statement and obtain; And website controller record queries result.
Further, website controller receives the inquiry request of outside input by the display interface on website, and website is provided with the interface for providing input inquiry request.
Further, inquiry request is converted into query statement and comprises by website controller: website controller carries out analyzing and processing to inquiry request, obtains the querying condition in inquiry request, and wherein, querying condition is used to indicate the Query Result that inquiry meets querying condition; And querying condition is converted into query statement by website controller.
Further, after inquiry request is converted into query statement by website controller, network inquiry collection method also comprises: judge whether website controller starts to perform query statement; If judge that website controller starts to perform query statement, then the record start moment, wherein, initial time is the moment that website controller starts to perform query statement; After website controller performs query statement, network inquiry collection method also comprises: judge that website controller performs query statement and whether completes; If judge that website controller performs query statement and completes, then the end of record (EOR) moment, wherein, finish time is the moment that website controller execution query statement terminates; After record start moment and finish time, network inquiry collection method also comprises: calculate by initial time and finish time the duration that website controller performs query statement.
Further, carry user ID in inquiry request, user ID is the mark of the user for input inquiry request, after website controller receives inquiry request, network inquiry collection method also comprises: carry out analyzing and processing to inquiry request, obtains the user ID of carrying in inquiry request; Website controller record queries result comprises: website controller record user identifications, Query Result, and the corresponding relation between record user identifications and Query Result.
Further, in website controller record user identifications, Query Result, and after corresponding relation between record user identifications and Query Result, method also comprises: website controller receives the first statistics request, wherein, the first statistics request is added up the inquiry times of first user for asking; Website controller obtains first user mark, and first user is designated user ID corresponding to first user; Website controller obtains Query Result corresponding to first user mark according to corresponding relation; And website controller is added up according to the inquiry times of Query Result to first user of first user mark correspondence.
Further, after the controller record queries result of website, network inquiry collection method comprises: the Web portal address obtaining memory storage, and wherein, memory storage is used for storing queries result; Generate the statement inserting Query Result; And statement is written in memory storage corresponding to Web portal address.
To achieve these goals, according to a further aspect in the invention, a kind of network inquiry gathering-device is provided.This network inquiry gathering-device comprises: the first receiver module, receives inquiry request for website controller; Conversion module, is converted into query statement for website controller by inquiry request; Execution module, performs query statement for website controller, and obtains the Query Result performing query statement and obtain; And first logging modle, for website controller record queries result.
Further, network inquiry gathering-device also comprises: the first judge module, for judging whether website controller starts to perform query statement; Second logging modle, for when judging that website controller starts to perform query statement, then the record start moment, wherein, initial time is the moment that website controller starts to perform query statement; Second judge module, for judging that website controller performs query statement and whether completes; 3rd logging modle, for when judging that website controller execution query statement completes, then the end of record (EOR) moment, wherein, finish time is the moment that website controller execution query statement terminates; Computing module, for calculating by initial time and finish time the duration that website controller performs query statement.
Further, network inquiry gathering-device also comprises: analysis and processing module, for carrying out analyzing and processing to inquiry request, obtains the user ID of carrying in inquiry request; 4th logging modle, for website controller record user identifications, Query Result, and the corresponding relation between record user identifications and Query Result; Second receiver module, receives the first statistics request for website controller, and wherein, the first statistics request is added up the inquiry times of first user for asking; First acquisition module, obtain first user mark for website controller, first user is designated user ID corresponding to first user; Second acquisition module, obtains Query Result corresponding to first user mark for website controller according to corresponding relation; And statistical module, the Query Result inquiry times to first user corresponding according to first user mark for website controller is added up.
By the present invention, website controller is adopted to receive inquiry request; Inquiry request is converted into query statement by website controller; Website controller performs query statement, and obtains the Query Result performing query statement and obtain; And website controller record queries result, to be performed by website controller in network layer and record the Query Result performing query statement and obtain, avoid and easily collect irrelevant information by database performance collection kit information of collecting, solve the problem easily collecting irrelevant information when collection network Query Information, and then reach the effect of Optimizing Queries experience.
Accompanying drawing explanation
The accompanying drawing forming a application's part is used to provide a further understanding of the present invention, and schematic description and description of the present invention, for explaining the present invention, does not form inappropriate limitation of the present invention.In the accompanying drawings:
Fig. 1 is the process flow diagram of the first embodiment according to query site collection method of the present invention;
Fig. 2 is the process flow diagram of the second embodiment according to query site collection method of the present invention;
Fig. 3 is the schematic diagram of the first embodiment according to query site gathering-device of the present invention; And
Fig. 4 is the schematic diagram of the second embodiment according to query site gathering-device of the present invention.
Embodiment
It should be noted that, when not conflicting, the embodiment in the application and the feature in embodiment can combine mutually.Below with reference to the accompanying drawings and describe the present invention in detail in conjunction with the embodiments.
Better the present invention program is understood in order to make those skilled in the art, below in conjunction with the accompanying drawing in the embodiment of the present invention, technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is only the embodiment of a part of the present invention, instead of whole embodiments.Based on the embodiment in the present invention, the every other embodiment obtained under those of ordinary skill in the art do not make creative work prerequisite, all should belong to protection scope of the present invention.
It should be noted that, term " first ", " second " etc. in instructions of the present invention and claims and above-mentioned accompanying drawing are for distinguishing similar object, and need not be used for describing specific order or precedence.Should be appreciated that the data used like this can be exchanged in the appropriate case, so as embodiments of the invention described herein can with except here diagram or describe those except order implement.In addition, term " comprises " and " having " and their any distortion, and intention is to cover not exclusive comprising.
The present invention aims to provide a kind of query site collection method and device.Fig. 1 is the process flow diagram of the first embodiment according to query site collection method of the present invention, and as shown in Figure 1, this query site collection method comprises following step S101 to step S104:
Step S101, website controller receives inquiry request.
Website in the embodiment of the present invention is that website controller is the controller of the website according to MVC Model Design, and this website controller is positioned at network layer according to Model View Controller (Model View Controller, referred to as MVC) Model Design.Be provided with display interface on the web site, this display interface is the interface for providing inquiry request to input, and website controller receives the inquiry request of outside input by the display interface on website.MVC is a kind of program development Design Mode, achieves being separated of display module and functional module, improves the maintainability of program, portability, extensibility and reusability, reduce the development difficulty of program.MVC comprises model, view, controller three layers.Model is the main part of application program, mainly comprises business logic modules and data module.Model and data layout have nothing to do, and such model can provide data for multiple view.Only need write due to the code being applied to model and once just can be reused by multiple view, so decrease the repetition of code.View provides the mutual interface with user.Controller receives the request from interface and gives model and processes.The embodiment of the present invention is based on MVC design pattern, and design website, utilizes the inquiry request that website controller process Website front-end user inputs, and encapsulate the service logic of website.The inquiry request that user inputs is converted into corresponding query statement by website controller, and performs query manipulation, obtains Query Information, is stored by the Query Information that execution query statement obtains, is convenient to combined data, finds out inquiry bottleneck.
User ID is carried in the inquiry request that website controller receives, user ID is the mark of the user for input inquiry request, after website controller receives inquiry request, website controller carries out analyzing and processing to inquiry request, obtains the user ID of carrying in inquiry request.
Step S102, inquiry request is converted into query statement by website controller.
Website controller carries out analyzing and processing to inquiry request after receiving inquiry request, obtains the querying condition in inquiry request.Wherein, querying condition is used to indicate the Query Result that inquiry meets querying condition.After obtaining querying condition, querying condition is converted into query statement by website controller.
Step S103, website controller performs query statement, and obtains the Query Result performing query statement and obtain.
Website controller performs this query statement after inquiry request is converted into query statement.Query site collection method of the present invention, in order to Optimizing Queries, after inquiry request is converted into query statement by website controller, judges whether website controller starts to perform query statement; If judge that website controller starts to perform query statement, then the record start moment, wherein, initial time is the moment that website controller starts to perform query statement; After website controller performs query statement, judge that website controller performs query statement and whether completes; If judge that website controller performs query statement and completes, then the end of record (EOR) moment, wherein, finish time is the moment that website controller execution query statement terminates; After record start moment and finish time, calculate by initial time and finish time the duration that website controller performs query statement.
Step S104, website controller record queries result.
The Query Result performing query statement and obtain is obtained after website controller performs query statement, wherein, this Query Result comprises the duration that website controller performs query statement, user ID, and the corresponding relation of Query Result that the inquiry request of user ID and user corresponding to this user ID of execution obtains.
After the controller record queries result of website, this Query Result is stored.First obtain the Web portal address of memory storage, wherein, memory storage is used for storing queries result.Then generate the statement inserting Query Result, and statement is written in memory storage corresponding to Web portal address.Memory storage in the embodiment of the present invention can be tables of data, also can be that other can realize the container of memory function.The Query Result write storage device that execution query statement obtains there is multiple implementation method.Such as, if memory storage is tables of data, so the modes such as NLog, Entityframework can be adopted.Preferably, in the embodiment of the present invention, the Query Result write tables of data that execution query statement obtains directly is adopted SQL statement, generate SQL statement Query Result being inserted this tables of data.Website controller performs this SQL statement, is write by Query Result in memory storage corresponding to Web portal address.
The query site collection method of the embodiment of the present invention adopts website controller to receive inquiry request; Inquiry request is converted into query statement by website controller; Website controller performs query statement, and obtains the Query Result performing query statement and obtain; And website controller record queries result, solve the problem easily collecting irrelevant information when collection network Query Information, and then reach the effect of Optimizing Queries experience.Meanwhile, the duration performing Query Result, user ID and the network controller execution query statement that query statement obtains is stored, is convenient to express-analysis and inquires about the information such as consuming time and inquiry times, thus realize Optimizing Queries targetedly.
Fig. 2 is the process flow diagram of the second embodiment according to query site collection method of the present invention, and as shown in Figure 2, in order to express-analysis user inquiry times, this query site collection method comprises following step S201 to step S208:
Step S201 to S204, with above-mentioned step S101 to S104.
Step S205, website controller receives the first statistics request, and wherein, the first statistics request is added up the inquiry times of first user for asking.
In order to analysis and consult number of times more accurately, the net news inquiry collection method of the embodiment of the present invention can realize the statistical study without inquiry times to same user, can also realize the statistical study of the different user to same queries request.Looking in new result in the embodiment of the present invention not only comprises user ID, performs the Query Result that query statement obtains, also includes the corresponding relation of user ID and Query Result simultaneously.After the complete Query Result of website controller record, in order to Optimizing Queries, can find fast from Query Result and analysis and consult number of times.The first statistics request that website controller receives is added up the inquiry times of first user for asking.
Step S206, website controller obtains first user mark, and first user is designated user ID corresponding to first user.
In order to add up the inquiry times of different user, first website controller will obtain the user ID of different user, and the corresponding relation of Query Result that user ID and execution query statement obtain.First user in the embodiment of the present invention is not limited only to first user, and first user herein can be any user in website input inquiry request.In the embodiment of the present invention preferably using the network address of the server at user place as user ID, the network address is the preferred embodiment of the present invention, and this user ID can also be the user name etc. that user registers on website as required.
Step S207, website controller obtains Query Result corresponding to first user mark according to corresponding relation.
Owing to recording the corresponding relation of user ID and Query Result in the controller of website, therefore, after acquisition user ID, website controller can directly obtain the Query Result corresponding with this user ID.
Step S208, the inquiry times of Query Result to first user that website controller is corresponding according to first user mark is added up.
User may carry out repeatedly User behavior within a period of time.Website controller is by record user identifications and the corresponding relation performing the Query Result that query statement obtains, the Query Result of first user can be filtered out, by adding up the inquiry times obtaining first user to the Query Result of this first user from this corresponding relation.In like manner, website controller can carry out statistical study to the inquiry times of any user of input inquiry request on that network.
The query site collection method of this embodiment adopts website controller to receive inquiry request; Inquiry request is converted into query statement by website controller; Website controller performs query statement, and obtains the Query Result performing query statement and obtain; And website controller record queries result; Website controller receives the first statistics request, and wherein, the first statistics request is added up the inquiry times of first user for asking; Website controller obtains first user mark, and first user is designated user ID corresponding to first user; Website controller obtains Query Result corresponding to first user mark according to corresponding relation; And website controller is added up according to the inquiry times of Query Result to first user of first user mark correspondence, solves the problem easily collecting irrelevant information when collection network Query Information, and then reaches the effect of Optimizing Queries experience.Meanwhile, utilize website controller record user identifications and the corresponding relation of Query Result performing query statement and obtain, the inquiry times of user can be analyzed by express statistic.
It should be noted that, can perform in the computer system of such as one group of computer executable instructions in the step shown in the process flow diagram of accompanying drawing, and, although show logical order in flow charts, but in some cases, can be different from the step shown or described by order execution herein.
The embodiment of the present invention additionally provides a kind of query site gathering-device.It should be noted that, this query site gathering-device may be used for the query site collection method performing the embodiment of the present invention.
Fig. 3 is the schematic diagram of the first embodiment according to query site gathering-device of the present invention.As shown in Figure 3, this query site gathering-device comprises: the first receiver module 10, conversion module 20, execution module 30 and the first logging modle 40.
First receiver module 10, receives inquiry request for website controller.
Conversion module 20, is converted into query statement for website controller by inquiry request.
Wherein, conversion module 20 specifically comprises acquisition submodule, carries out analyzing and processing for website controller to inquiry request, obtains the querying condition in inquiry request, and wherein, querying condition is used to indicate the Query Result that inquiry meets querying condition; Transformant module, is converted into query statement for website controller by querying condition.
Execution module 30, performs query statement for website controller, and obtains the Query Result performing query statement and obtain.
First logging modle 40, for website controller record queries result.Wherein, the first logging modle 40 can also be used for website controller record user identifications, Query Result, and the corresponding relation between record user identifications and Query Result.
The query site device of this embodiment also comprises: the first judge module, the second logging modle, the second judge module, the 3rd logging modle and computing module.Wherein, the first judge module, for judging whether website controller starts to perform query statement.Second logging modle, for when judging that website controller starts to perform query statement, then the record start moment, wherein, initial time is the moment that website controller starts to perform query statement.Second judge module, for judging that website controller performs query statement and whether completes.3rd logging modle, for when judging that website controller execution query statement completes, then the end of record (EOR) moment, wherein, finish time is the moment that website controller execution query statement terminates.Computing module, for calculating by initial time and finish time the duration that website controller performs query statement.
The query site gathering-device of the present embodiment comprises the first receiver module 10, conversion module 20, execution module 30, the first logging modle 40.In order to add up the inquiry times of user, the query site device of this embodiment also comprises the first judge module, the second logging modle, the second judge module, the 3rd logging modle and computing module.By this embodiment, solve the problem easily collecting irrelevant information when collection network Query Information, and then reach the effect of Optimizing Queries experience.Meanwhile, utilize website controller record user identifications and the corresponding relation performing the Query Result that query statement obtains, be convenient to the inquiry times of express statistic analysis user.
Fig. 4 is the schematic diagram of the second embodiment according to query site gathering-device of the present invention.As shown in Figure 4, this query site gathering-device comprises: the first receiver module 10, conversion module 20, execution module 30, the first logging modle 40, analysis and processing module 110,4th logging modle 120, second receiver module 130, first acquisition module 140, second acquisition module 150 and statistical module 160.
Analysis and processing module 110, for carrying out analyzing and processing to inquiry request, obtains the user ID of carrying in inquiry request.
4th logging modle 120, for website controller record user identifications, Query Result, and the corresponding relation between record user identifications and Query Result.
Second receiver module 130, receives the first statistics request for website controller, and wherein, the first statistics request is added up the inquiry times of first user for asking.
First acquisition module 140, obtain first user mark for website controller, first user is designated user ID corresponding to first user.
Second acquisition module 150, obtains Query Result corresponding to first user mark for website controller according to corresponding relation.
Statistical module 160, the Query Result inquiry times to first user corresponding according to first user mark for website controller is added up.
The query site gathering-device of the embodiment of the present invention comprises: the first receiver module 10, conversion module 20, execution module 30, first logging modle 40, analysis and processing module 110, the 4th logging modle 120, second receiver module 130, first acquisition module 140, second acquisition module 150 and statistical module 160.This query site gathering-device can also comprise: the 3rd acquisition module, and for obtaining the Web portal address of memory storage, wherein, memory storage is used for storing queries result; Generation module, for generating the statement inserting Query Result; Writing module, for being written to statement in memory storage corresponding to Web portal address.The problem easily collecting irrelevant information when collection network Query Information is solved by the query site gathering-device of the embodiment of the present invention.
Query site collection method of the present invention and device, website controller is utilized to obtain inquiry request, this inquiry request is converted into query statement, perform query statement and obtain the Query Result performing query statement and obtain, and record queries result, the above-mentioned Query Information relevant with record execution User behavior about the behavior of inquiry is all realized by the controller of website, this query site cell phone methods and device solve the problem easily collecting irrelevant information when collection network Query Information, and then reach the effect of Optimizing Queries experience.Simultaneously, utilize website controller record to perform query statement and obtain Query Result inquiry duration used, utilize the Query Result that website controller collection execution query statement obtains, user ID, and the corresponding relation of Query Result and user ID, can the inquiry times of Statistic Query duration and user fast.
Obviously, those skilled in the art should be understood that, above-mentioned of the present invention each module or each step can realize with general calculation element, they can concentrate on single calculation element, or be distributed on network that multiple calculation element forms, alternatively, they can realize with the executable program code of calculation element, thus, they can be stored and be performed by calculation element in the storage device, or they are made into each integrated circuit modules respectively, or the multiple module in them or step are made into single integrated circuit module to realize.Like this, the present invention is not restricted to any specific hardware and software combination.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. a network inquiry collection method, is characterized in that, comprising:
Website controller receives inquiry request;
Described inquiry request is converted into query statement by described website controller;
Described website controller performs described query statement, and obtains the Query Result performing described query statement and obtain; And
Query Result described in the controller record of described website.
2. network inquiry collection method according to claim 1, is characterized in that, described website controller receives the inquiry request of outside input by the display interface on website, is provided with on the web for providing the interface inputting described inquiry request.
3. network inquiry collection method according to claim 1, is characterized in that, described inquiry request is converted into query statement and comprises by described website controller:
Described website controller carries out analyzing and processing to described inquiry request, obtains the querying condition in described inquiry request, and wherein, described querying condition is used to indicate the Query Result that inquiry meets described querying condition; And
Described querying condition is converted into described query statement by described website controller.
4. network inquiry collection method according to claim 1, is characterized in that,
After described inquiry request is converted into query statement by described website controller, described network inquiry collection method also comprises: judge whether described website controller starts to perform described query statement; If judge that described website controller starts to perform described query statement, then the record start moment, wherein, described initial time is the moment that described website controller starts to perform described query statement;
After described website controller performs described query statement, described network inquiry collection method also comprises: judge that described website controller performs described query statement and whether completes; If judge that described website controller performs described query statement and completes, then the end of record (EOR) moment, wherein, described finish time is the moment that described website controller performs described query statement and terminates;
Recording described initial time and after described finish time, described network inquiry collection method also comprises:
The duration that described website controller performs described query statement is calculated by described initial time and described finish time.
5. network inquiry collection method according to claim 1, is characterized in that,
User ID is carried in described inquiry request, described user ID is the mark of the user for inputting described inquiry request, after described website controller receives inquiry request, described network inquiry collection method also comprises: carry out analyzing and processing to described inquiry request, obtains the user ID of carrying in described inquiry request;
Described in the controller record of described website, Query Result comprises: user ID described in the controller record of described website, described Query Result, and records the corresponding relation between described user ID and described Query Result.
6. network inquiry collection method according to claim 5, it is characterized in that, user ID described in the controller record of described website, described Query Result, and after recording the corresponding relation between described user ID and described Query Result, described method also comprises:
Described website controller receives the first statistics request, and wherein, described first statistics request is added up the inquiry times of first user for asking;
Described website controller obtains first user mark, and described first user is designated user ID corresponding to described first user;
Described website controller obtains Query Result corresponding to described first user mark according to described corresponding relation; And
The inquiry times of Query Result to described first user that described website controller is corresponding according to described first user mark is added up.
7. network inquiry collection method according to claim 1, is characterized in that, after Query Result described in the controller record of described website, described network inquiry collection method comprises:
Obtain the Web portal address of memory storage, wherein, described memory storage is for storing described Query Result;
Generate the statement inserting described Query Result; And
Described statement is written in memory storage corresponding to described Web portal address.
8. a network inquiry gathering-device, is characterized in that, comprising:
First receiver module, receives inquiry request for website controller;
Conversion module, is converted into query statement for described website controller by described inquiry request;
Execution module, performs described query statement for described website controller, and obtains the Query Result performing described query statement and obtain; And
First logging modle, for Query Result described in the controller record of described website.
9. network inquiry gathering-device according to claim 8, is characterized in that, described network inquiry gathering-device also comprises:
First judge module, for judging whether described website controller starts to perform described query statement;
Second logging modle, for when judging that described website controller starts to perform described query statement, then the record start moment, wherein, described initial time is the moment that described website controller starts to perform described query statement;
Second judge module, for judging that described website controller performs described query statement and whether completes;
3rd logging modle, for when judge described website controller perform described query statement complete time, then the end of record (EOR) moment, wherein, described finish time is the moment that described website controller performs described query statement and terminates;
Computing module, for calculating by described initial time and described finish time the duration that described website controller performs described query statement.
10. network inquiry gathering-device according to claim 8, is characterized in that, described network inquiry gathering-device also comprises:
Analysis and processing module, for carrying out analyzing and processing to described inquiry request, obtains the user ID of carrying in described inquiry request;
4th logging modle, for user ID described in the controller record of described website, described Query Result, and record the corresponding relation between described user ID and described Query Result;
Second receiver module, receives the first statistics request for described website controller, and wherein, described first statistics request is added up the inquiry times of first user for asking;
First acquisition module, obtain first user mark for described website controller, described first user is designated user ID corresponding to described first user;
Second acquisition module, obtains Query Result corresponding to described first user mark for described website controller according to described corresponding relation; And
Statistical module, the Query Result inquiry times to described first user corresponding according to described first user mark for described website controller is added up.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410550952.0A 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 |
|---|---|---|---|
| CN201410550952.0A CN104281700A (en) | 2014-10-16 | 2014-10-16 | Website inquiring and collecting method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104281700A true CN104281700A (en) | 2015-01-14 |
Family
ID=52256573
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410550952.0A Pending CN104281700A (en) | 2014-10-16 | 2014-10-16 | Website inquiring and collecting method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104281700A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109076098A (en) * | 2016-04-15 | 2018-12-21 | 电子湾有限公司 | Data are used across different websites |
| CN117271562A (en) * | 2023-11-21 | 2023-12-22 | 成都凌亚科技有限公司 | Data acquisition processing method and system |
Citations (6)
| 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 |
-
2014
- 2014-10-16 CN CN201410550952.0A patent/CN104281700A/en active Pending
Patent Citations (6)
| 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)
| Title |
|---|
| 卢言君等: "基于MVC设计模式实现通用查询组件", 《微处理机》 * |
| 王继民: "《Web用户查询日志挖掘与应用》", 31 March 2014 * |
| 索红军: "Visual Foxpro 查询与SQL 查询执行时间分析", 《甘肃科技》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109076098A (en) * | 2016-04-15 | 2018-12-21 | 电子湾有限公司 | Data are used across different websites |
| US11368530B2 (en) | 2016-04-15 | 2022-06-21 | Ebay Inc. | Adopting data across different sites |
| CN117271562A (en) * | 2023-11-21 | 2023-12-22 | 成都凌亚科技有限公司 | Data acquisition processing method and system |
| CN117271562B (en) * | 2023-11-21 | 2024-01-19 | 成都凌亚科技有限公司 | Data acquisition processing method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103473672A (en) | System, method and platform for auditing metadata quality of enterprise-level data center | |
| CN101216840A (en) | Data enquiry method and data enquiry system | |
| US9311345B2 (en) | Template based database analyzer | |
| CN105550206B (en) | The edition control method and device of structured query sentence | |
| US20190050435A1 (en) | Object data association index system and methods for the construction and applications thereof | |
| CN104778185A (en) | Determination method for abnormal SQL (structured query language) statement and server | |
| CN106484699B (en) | Method and device for generating database query field | |
| CN109740129B (en) | Report generation method, device and equipment based on blockchain and readable storage medium | |
| CN102622238A (en) | Method and device for interface layout of mobile devices | |
| CN108875044B (en) | Contact searching method and device, storage medium and electronic equipment | |
| CN104050182A (en) | Configurable rule for monitoring data of in-memory database | |
| US10409866B1 (en) | Systems and methods for occupation normalization at a job aggregator | |
| CN111143391A (en) | Data sharing exchange method and system | |
| CN103248511B (en) | A kind of analysis methods, devices and systems of single-point service feature | |
| CN109947635A (en) | A kind of data reporting method, device, storage medium and terminal device | |
| CN101425070B (en) | Deadlock positioning method, deadlock positioning device and data system | |
| CN102508884A (en) | Method and device for acquiring hotpot events and real-time comments | |
| CN104281700A (en) | Website inquiring and collecting method and device | |
| CN111125226B (en) | Configuration data acquisition method and device | |
| KR100798577B1 (en) | Analyzing system and analyzing method for data quality problem | |
| Karataş et al. | Global constraints on feature models | |
| CN109828983A (en) | PG data base processing method, device, electronic equipment and storage medium | |
| Gao et al. | Whom to blame? Automatic diagnosis of performance bottlenecks on smartphones | |
| TWI499238B (en) | A method of cross - platform record traceability | |
| CN103744989B (en) | Method for querying hierarchical node data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150114 |