CN107291719A - A kind of data retrieval method and device, a kind of date storage method and device - Google Patents

A kind of data retrieval method and device, a kind of date storage method and device Download PDF

Info

Publication number
CN107291719A
CN107291719A CN201610195039.2A CN201610195039A CN107291719A CN 107291719 A CN107291719 A CN 107291719A CN 201610195039 A CN201610195039 A CN 201610195039A CN 107291719 A CN107291719 A CN 107291719A
Authority
CN
China
Prior art keywords
data
time
currency
history average
target
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
Application number
CN201610195039.2A
Other languages
Chinese (zh)
Inventor
刘学
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Alibaba Group Holding Ltd
Original Assignee
Alibaba Group Holding Ltd
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
Application filed by Alibaba Group Holding Ltd filed Critical Alibaba Group Holding Ltd
Priority to CN201610195039.2A priority Critical patent/CN107291719A/en
Priority to TW106105760A priority patent/TW201737127A/en
Priority to PCT/CN2017/077450 priority patent/WO2017167063A1/en
Publication of CN107291719A publication Critical patent/CN107291719A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/248Presentation of query results

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Software Systems (AREA)

Abstract

The embodiment of the present application provides a kind of data retrieval method and device, a kind of date storage method and device, and search method therein is specifically included:Receive retrieval request;The retrieval request includes:The preset very first time is interval;It regard mark data as packet, mapping relations between mark data, time data, the currency of object data and history average are retrieved, to obtain target identification data of the number of the very first time interval interior, target data record in presetting range;The magnitude relationship of currency described in the target data record and the history average is fixed;Export the target identification data.The embodiment of the present application can greatly improve the efficiency of tendency judgement and the acquisition efficiency of target identification data, and can save system resource, and can save human cost.

Description

A kind of data retrieval method and device, a kind of date storage method and device
Technical field
The application is related to information technology technical field, more particularly to a kind of data retrieval method and device, A kind of date storage method and device.
Background technology
With the rapid development of information technology, industry data amount sharp increase.What current every profession and trade was emerged in large numbers Big data has data volume big and the characteristic with temporal correlation, and statistical analysis is carried out to big data can be with Industry decision-making is formulated in help.For example, for the industry based on trade type data, such as finance, electricity Sub- commercial affairs etc., are analyzed big data, can quickly extract commercially valuable information.Its In, a kind of common big data analysis demand is specially:Increasing of the determine object data within some period Long or downward trend.For example, it is assumed that website has tens million of members, then need to all members' Turnover data are analyzed, to obtain the meeting that turnover data show a rising trend within some period Member.
A kind of existing scheme can using growth of the tendency chart determine object data within some period or Person's downward trend, with by means of the eustasy of the full curve of tendency chart, to reflect the dynamic of object data State change procedure.Specifically, all object datas can disposably be read, point-by-point mapping.
However, in actual applications, above-mentioned point-by-point mapping process needs to expend substantial amounts of duration, and takes More system resource.In addition, analysis personnel are after checking and analyzing the tendency chart drawn and obtained, ability Corresponding tendency judgement result is obtained, a large amount of human costs are not only consumed, and have impact on tendency judgement Efficiency.
The content of the invention
The embodiment of the present application technical problem to be solved is to provide a kind of data retrieval method, Neng Gou great The acquisition efficiency of the big efficiency and target identification data for improving tendency judgement, and can save system resource, And human cost can be saved.
Accordingly, the embodiment of the present application additionally provides a kind of data searcher, a kind of date storage method And device, realization and application to ensure the above method.
In order to solve the above problems, this application discloses a kind of data retrieval method, including:
Receive retrieval request;The retrieval request includes:The preset very first time is interval;
Using mark data as packet, in mark data, time data, the currency of object data and go through Mapping relations between history average are retrieved, and are remembered with obtaining the very first time interval interior, target data Target identification data of the number of record in presetting range;Currency described in the target data record and The magnitude relationship of the history average is fixed;
Export the target identification data.
Alternatively, the magnitude relationship of the currency and the history average is fixed, including:It is described current Value is more than the history average, or, the currency is less than the history average.
Alternatively, the number of the target data record is in presetting range, including:The target data The number of record exceedes threshold value.
Alternatively, the threshold value is more than or equal to 1/2nd of the very first time interval length, and institute State the threshold value length interval less than or equal to the very first time.
Alternatively, it is described using mark data as packet, in mark data, time data, object data Currency and history average between mapping relations the step of retrieved, including:
Using mark data as packet, in mark data, time data, the currency of object data and go through Mapping relations between history average are retrieved, to obtain the object data values and the history average The target data record that magnitude relationship is fixed;
Set up and the mapping relations between conservation object data and the number of the target data record;
Examined in mapping relations between the number of the object data and the target data record Rope, to obtain target identification data of the number of target data record in presetting range
Alternatively, the history average includes:Object data values current time data it is corresponding second when Between average in interval, second time interval includes:Earlier than the time number of the current time data According to.
On the other hand, this application discloses a kind of date storage method, including:
According to the mapping relations between the currency of mark data, time data and object data, institute is determined Average of the object data in corresponding second time interval of current time data is stated, corresponding history is used as Average;Second time interval includes:Earlier than the time data of the current time data;
According to the history average, set up and preserve mark data, time data, object data it is current Mapping relations between value and history average.
Alternatively, the terminal of second time interval is previous time data.
Alternatively, the length of second time interval is more than or equal to the two of the very first time interval length / mono-, and the length of second time interval is less than or equal to the very first time interval length.
Another further aspect, this application discloses a kind of data searcher, including:
Receiving module, for receiving retrieval request;The retrieval request includes:The preset very first time It is interval;
Retrieve module, for using mark data as packet, in mark data, time data, number of objects According to currency and history average between mapping relations retrieved, it is interval to obtain very first time Target identification data of interior, target data record the number in presetting range;The target data record Described in the magnitude relationship of currency and the history average fix;And
Output module, for exporting the target identification data.
Alternatively, the magnitude relationship of the currency and the history average is fixed, including:It is described current Value is more than the history average, or, the currency is less than the history average.
Alternatively, the number of the target data record is in presetting range, including:The target data The number of record exceedes threshold value.
Alternatively, the retrieval module, including:
First retrieval submodule, for using mark data as packet, mark data, time data, Mapping relations between the currency and history average of object data are retrieved, to obtain the number of objects The target data record fixed according to the magnitude relationship of value and the history average;
Submodule is preserved, for setting up and between conservation object data and the number of the target data record Mapping relations;And
Second retrieval submodule, between the number of the object data and the target data record Mapping relations in retrieved, to obtain target mark of the number of target data record in presetting range Know data.
Another aspect, this application discloses a kind of data storage device, including:
Determining module, for reflecting between the currency according to mark data, time data and object data Relation is penetrated, average of the object data in corresponding second time interval of current time data is determined, It is used as corresponding history average;Second time interval includes:Earlier than the current time data when Between data;And
Preserving module, for according to the history average, setting up and preserving mark data, time data, Mapping relations between the currency and history average of object data.
Compared with existing scheme, the embodiment of the present application includes advantages below:
Relative to the drawing process of tendency chart in existing scheme, because the embodiment of the present application is using simple inspection Rope logic meet target identification data (user's mark of such as turnover sustainable growth of particular tendency Or website logo) retrieval, therefore the efficiency of tendency judgement and obtaining for target identification data can be greatly improved Efficiency is taken, and system resource can be saved.
In addition, relative to analysis personnel in existing scheme after checking and analyzing the tendency chart drawn and obtained, Corresponding tendency judgement result can be just obtained, the embodiment of the present application, which can be exported directly, meets particular tendency Target identification data, therefore, it is possible to the acquisition of the efficiency and target identification data that further improve tendency judgement Efficiency, and corresponding human cost can be saved.
Brief description of the drawings
Fig. 1 is a kind of step flow chart of date storage method embodiment of the application;;
Fig. 2 is a kind of step flow chart of data retrieval method embodiment of the application;
Fig. 3 is a kind of structured flowchart of data searcher embodiment of the application;And
Fig. 4 is a kind of structured flowchart of data storage device embodiment of the application.
Embodiment
To enable above-mentioned purpose, the feature and advantage of the application more obvious understandable, with reference to attached Figure and embodiment are described in further detail to the application.
Drafting for tendency chart in existing scheme expends the more system money of substantial amounts of duration, occupancy The analysis of source and tendency chart is needed to expend the technical problem of substantial amounts of human cost, and the application is implemented Example provides a kind of magnitude relationship according to currency and history average in continuum and determines object data Trend scheme, it can be realized in the way of base is retrieved, specifically, can be carried in retrieval request Preset very first time is interval, and using mark data as packet, in mark data, time data, right Mapping relations between the currency and history average of image data are retrieved, to obtain the above-mentioned very first time Target identification data of the number of interval interior, target data record in presetting range, above-mentioned target data The magnitude relationship of above-mentioned currency and above-mentioned history average is fixed in record, and then exports above-mentioned target identification Data.
Because above-mentioned history average can be used for representing object data in the corresponding history of existing object data Between it is interval in, therefore it can reflect general status of the object data in above-mentioned historical time interval, thus this The magnitude relationship of above-mentioned currency and above-mentioned history average can reflect that object data is worked as in application embodiment Preceding increment change, specifically, if above-mentioned currency is more than above-mentioned history average, corresponding increment is Just, if above-mentioned currency is less than above-mentioned history average, corresponding increment is negative;Therefore, it is above-mentioned current The magnitude relationship fixation of value and above-mentioned history average can reflect that certain particular tendency (becomes as increased or declining Gesture), determine current identification so as to the number according to interval interior target data record of the above-mentioned very first time Specific growth or downward trend that whether data show on the whole in the very first time interval object data. Further, can be with when the number of target data record is in presetting range in the above-mentioned very first time is interval The particular tendency that the object data in very first time interval shows on the whole is determined, therefore can be by current identification Data are exported as target identification data.
To sum up, relative to the drawing process of tendency chart in existing scheme, because the embodiment of the present application is using letter Single retrieval logic meet target identification data (such as use of turnover sustainable growth of particular tendency Family is identified or website logo) retrieval, therefore the efficiency and target identification number of tendency judgement can be greatly improved According to acquisition efficiency, and system resource can be saved.
In addition, relative to analysis personnel in existing scheme after checking and analyzing the tendency chart drawn and obtained, Corresponding tendency judgement result can be just obtained, the embodiment of the present application, which can be exported directly, meets particular tendency Target identification data, therefore, it is possible to the acquisition of the efficiency and target identification data that further improve tendency judgement Efficiency, and corresponding human cost can be saved.
The protocol procedures that the embodiment of the present application is provided can apply in the scene of big data, wherein, it is above-mentioned Big data may belong to the industry based on the trade type data such as finance, ecommerce, can also belong to doctor Medicine, meteorology etc. need to store the industry of substantial amounts of monitoring information, it will be understood that the embodiment of the present application for Specific big data is not any limitation as.
In addition, the protocol procedures that the application is provided can be run on information equipment, in actual applications, Above- mentioned information equipment is specifically included but not limited:Smart mobile phone, tablet personal computer, E-book reader, MP3 (dynamic image expert's compression standard audio aspect 3, Moving Picture Experts Group Audio Layer III) player, MP4 (dynamic image expert's compression standard audio aspects 4, Moving Picture Experts Group Audio Layer IV) player, pocket computer on knee, vehicle mounted electric Brain, desktop computer, set top box, intelligent TV set, wearable device etc..
Storage method embodiment
Reference picture 1, shows a kind of step flow chart of date storage method embodiment of the application, tool Body may include steps of:
Step 101, close according to the mapping between mark data, the currency of time data and object data System, determines average of the object data in corresponding second time interval of current time data, as Corresponding history average;Second time interval can specifically include:Earlier than the current time data Time data;
Step 102, according to the history average, set up and preserve mark data, time data, object Mapping relations between the currency and history average of data.
In the embodiment of the present application, the mapping between the currency of mark data, time data and object data Relation can specifically include:Key (mark data), Time (time data) and Data (number of objects According to currency) 3 fields.
Above-mentioned mark data can be used for identifying object data to be retrieved, for example, it can include:User ID (mark, Identity), website ID, commodity ID etc..Generally, the value of Key fields can be represented For keyk, wherein, k can represent key numbering.
Above-mentioned time data can be used for the production time for representing object data, wherein, above-mentioned object data can With the specific production cycle, to be generally separated by a production cycle between adjacent time data.For example, The above-mentioned production cycle can include:Year, month, day, hour, minute etc..Generally, Time fields Value can be expressed as timet, wherein, k can represent Time numbering.
So that the production cycle is day as an example, if time1=" 2015-01-01 ", then time2=" 2015-01-02 ";
So that the production cycle is hour as an example, if time1=" 2015-01-01 01 ", then time2=" 2015-01-01 02 ".
Object data can be used for the data for representing data to be retrieved and trend to be determined, for example, above-mentioned right Image data can specifically include:Website traffic, spending amount, turnover etc., it typically is integer type. Generally, the value data of Data fieldsk,tKey can be representedkIn timetThe object of correspondence current time data Data (such as visit capacity 20000).
With reference to table 1 (c_data), reflecting between a kind of Key, Time and Data of the application is shown The signal of relation is penetrated, wherein, Key is specially website id, and Time is using day as the production cycle, Data tools Body is visit capacity.It is appreciated that the embodiment of the present application is for specific between Key, Time and Data Mapping relations are not any limitation as.
Table 1 (c_data)
In the embodiment of the present application, there is a plurality of data record in the mapping relations of similar table 1, wherein, often Include mark data, current time data (expression current point in time) and number of objects in data record According to currency.
Further, the second time interval can be interval for historical time corresponding with current time data, its In, second time interval can specifically include:Earlier than the time data of the current time data; That is, at least one time data is earlier than current time data in the second time interval described above, thus The history of history average can be ensured, so as to reflect object data in above-mentioned second time interval General status.
In actual applications, the very first time interval can specifically include:Beginning and end, wherein, The corresponding time data of starting point can time data corresponding earlier than terminal.In a kind of optional reality of the application Apply in example, the terminal of second time interval can be previous time data.Wherein, previous time number Can a time early unit period more corresponding than current time data according to the corresponding time.Assuming that when current Between data be timet, then previous time data can be timet-1.In a kind of application example of the application, Assuming that the length of above-mentioned second time interval is n, then above-mentioned second time interval can be expressed as [timet-n,timet-1], that is, above-mentioned second time interval specifically includes the n before current time data The object data of individual production cycle.
In a kind of alternative embodiment of the application, it is assumed that avg (k, t, n) represents keykIn timetHistory Average, then can obtain key in above-mentioned second time interval that length is n firstkObject data, so Afterwards, acquired all object datas are summed, finally, using summed result and n ratio as Corresponding history average.By taking table 1 as an example, avg (1, t, n) represents web1 visit capacity past n days History average, avg (2, t, n) represents web2 history average of the visit capacity past n days
In actual applications, the length n of usual second time interval value is bigger, then to historical data Expression it is more accurate, that is, the object data that above-mentioned history average is reflected is in above-mentioned second time interval Interior general status is more accurate.Meanwhile, the length n of the second time interval value is bigger, then above-mentioned to go through Amount of calculation needed for the corresponding determination process of history average is bigger.It is appreciated that those skilled in the art can be with According to practical application request, a n value more balanced is taken between the degree of accuracy and amount of calculation.
For example, in another alternative embodiment of the application, the length of second time interval can be with / 2nd of the length interval more than or equal to the very first time, and the length of second time interval can be with The length interval less than or equal to the very first time.Wherein, above-mentioned very first time interval can be for investigate and The time interval of retrieval, it can be determined according to practical application request.For example, wanting to determine object data Particular tendency in some time interval (such as nearest one month), then can using the time interval as The very first time is interval.It is appreciated that 1/2nd of the above-mentioned length f interval more than or equal to the very first time, And the length interval less than or equal to the very first time, only as the length n of the second time interval of the application Alternative embodiment, in fact, those skilled in the art can also be according to practical application request, using it His n values, such as less than f/2, or, more than f etc..
In another alternative embodiment of the application, above-mentioned steps 102 can be by keykAnd when current Between data t, the currency data of object datak,t, past n days history average avg (k, t, n), as One data record storage is into corresponding tables of data (hereinafter referred to as retrieving table).
With reference to table 2, the signal of the distribution key (c_data_compare) of the application is shown, its It can specifically include:Key, Time, Data and Avg_data (the history average in past n days) etc. 4 Individual average, Avg_data therein is to be directed to the mapping relations of table 1 to n values 5 using step 101 Obtain.
Table 2 (c_data_compare)
To sum up, the embodiment of the present application can be by the currency and mistake of the object data of each production cycle The history average of n production cycle is gone to be stored in a data of retrieval table record, that is, above-mentioned inspection The production cycle of rope table can be identical with the production cycle of object data, therefore, it is possible to ensure history average number According to continuation.
Search method embodiment
Reference picture 2, shows a kind of step flow chart of data retrieval method embodiment of the application, tool Body may include steps of:
Step 201, reception retrieval request;It can include in the retrieval request:The preset very first time It is interval;
Step 202, using mark data as packet, in mark data, time data, object data Mapping relations between currency and history average are retrieved, to obtain in the very first time interval, Target identification data of the number of target data record in presetting range;Institute in the target data record The magnitude relationship for stating currency and the history average is fixed;
Step 203, the output target identification data.
Fig. 1 is generated in retrieval table (c_data_compare) and is stored mark data keyk, time number According to timet, object data currency datak,tWith the mapping relations between history average avg (k, t, n).
Using the embodiment of the present application, when there is very first time interval [timet1,timet2] (assuming that siding-to-siding block length For f=t2-t1) in keep particular tendency object data determination demand when, can be by above-mentioned determination demand The Search Requirement for above-mentioned retrieval table is converted into, specifically, the corresponding retrieving of above-mentioned Search Requirement It can specifically include:Retrieved using key to be grouped in retrieval table, to obtain [timet1,timet2] in, Currency datak,tThe number for the data record fixed with history average avg (k, t, n) magnitude relationship is pre- Target identification data in the range of putting.
It should be noted that above-mentioned steps 201 can pass through preset Retrieval Interface (such as input frame) Receive the retrieval request of user's input, it will be understood that tool of the embodiment of the present application for reception retrieval request Body process is not any limitation as.
Above-mentioned steps 203, which export the target identification data, can specifically include:In current information equipment On by above-mentioned target identification data display to user, or, by current information equipment to others believe Cease equipment and send above-mentioned target identification data etc., the embodiment of the present application exports described for above-mentioned steps 203 The detailed process of target identification data is not any limitation as.
In actual applications, the magnitude relationship of the currency and the history average is fixed, specifically can be with Including:The currency is more than the history average, or, the currency is less than the history average.
In a kind of alternative embodiment of the application, the number of the target data record is in presetting range It is interior, it can specifically include:The number of the target data record exceedes threshold value.
In another alternative embodiment of the application, the threshold value can be more than or equal to the very first time / 2nd of interval length, and the threshold value can be less than or equal to the very first time interval length Degree.Assuming that threshold value is q, then f/2≤q≤f.In practical application, a kind of mark data is in [timet1,timet2] Inside specifically include f datas record, therefore above-mentioned f/2≤q≤f ensure that f datas record in it is more than half Data record meets currency datak,tMore than (or less than) history average avg (k, t, n) condition, I.e. more than half data records can show particular tendency, in such cases, and the trend of the mark data is true It is set to the particular tendency, ensure that the reasonability that trend is determined.Certainly, above-mentioned f/2≤q≤f is As q alternative embodiment, in fact, those skilled in the art can also according to practical application request, Using the q values less than f/2, the embodiment of the present application is not any limitation as specific q values.
In another alternative embodiment of the application, the history average can specifically include:Number of objects According to average of the value in corresponding second time interval of current time data, second time interval is specific It can include:Earlier than the time data of the current time data.It is possible thereby to ensure going through for history average Shi Xing, so as to reflect general status of the object data in above-mentioned second time interval.
In a kind of alternative embodiment of the application, it is described using mark data as packet, mark data, The step of mapping relations between time data, the currency of object data and history average are retrieved 202, it can specifically include:
Step S1, using mark data as packet, work as in mark data, time data, object data Mapping relations between preceding value and history average are retrieved, to obtain the object data values and described go through The target data record that the magnitude relationship of history average is fixed;
Step S2, the mapping set up simultaneously between conservation object data and the number of the target data record are closed System;
In step S3, the mapping relations between the number of the object data and the target data record Retrieved, to obtain target identification data of the number of target data record in presetting range.
In a kind of application example of the application, step S1 can retrieve [timet1,timet2] interior, all Currency datak,tMore than (or less than) history average avg (k, t, n) target data record.
Step S2 can calculate the number D_count of correspondence target data record using Key fields as packet. It is alternatively possible to set up and between conservation object data Key and the number D_count of target data record Mapping relations, and the mapping relations are preserved to middle table tmp_c_data_compare.
Further, step S3 can determine presetting range, and in middle table tmp_c_data_compare Target identification data of the middle retrieval D_count in presetting range.For example, can be according to very first time area Between length f and to retrieve reliability requirement, in q interval (f/2≤q and q≤f) A value is chosen, and D_count is retrieved in tmp_c_data_compare tables>=q mark data, It is used as corresponding target identification data.
It should be noted that above-mentioned steps S1- steps S3 substep retrieval is intended only as alternative embodiment, In fact, those skilled in the art can also realize this according to practical application request by single step retrieval Apply for the function of embodiment.
In a kind of application example of the application, want to retrieve timet1=' 2015-01-05 ' arrive timet2=' Key, the f=4 increased is kept between 2015-01-08 ', then can determine q=3 (namely the currencys of 3 days More than history average), then it can construct corresponding query statement, the inquiry target of the query statement can be with For key, querying condition can include:Retrieve time in table c_data_compare>=' 2015-01-05 ' and time<=' 2015-01-8 ' and Data>Avg_data and meet above-mentioned condition data record number Mesh is more than or equal to 3.
In actual applications, the embodiment of the present application be applied to support SQL (SQL, Structured Query Language) language big data scene in, relatively good technology effect can be produced Really, specifically, recall precision can be greatly improved.Certainly, the language that the embodiment of the present application is supported is not It is limited to SQL, C language, JAVA language are also in the protection domain of the embodiment of the present application.
To sum up, the embodiment of the present application has the following advantages that:
Firstth, the embodiment of the present application can be by the currency and mistake of the object data of each production cycle The history average of n production cycle is gone to be stored in a data of retrieval table record, that is, above-mentioned inspection The production cycle of rope table can be identical with the production cycle of object data, can not only ensure history average number According to continuation, and can be provided for the data retrieval of the embodiment of the present application abundance data;
Secondth, due to the mark data of the embodiment of the present application, time data, the currency of object data and A variety of mark datas, therefore the retrieval of the embodiment of the present application can be included in mapping relations between history average Can be in units of mark data, retrieving currency in above-mentioned mapping relations, to be more than (or less than) history equal The data acknowledgment number of value returns interior target identification data preset, namely obtained retrieval result includes:Mesh Mark key set;Accordingly, with respect to drawing tendency chart respectively for every kind of mark data in existing scheme Process, because the embodiment of the present application using simple retrieval logic meet the target mark of particular tendency Know the retrieval of data (the user's mark or website logo of such as turnover sustainable growth), therefore can be significantly The efficiency of tendency judgement and the acquisition efficiency of target identification data are improved, and system resource can be saved.
3rd, relative to analysis personnel in existing scheme after checking and analyzing the tendency chart drawn and obtained, Corresponding tendency judgement result can be just obtained, the embodiment of the present application, which can be exported directly, meets particular tendency Target identification data, therefore, it is possible to the acquisition of the efficiency and target identification data that further improve tendency judgement Efficiency, and corresponding human cost can be saved.
4th, the application can adjust corresponding retrieval quality by threshold values q setting;
5th, in f/2≤q≤f, it ensure that the equal energy of more than half data records in f datas record Particular tendency is showed, in such cases, the trend of the mark data is defined as the particular tendency, energy Enough ensure the reasonability that trend is determined.
It should be noted that for embodiment of the method, in order to be briefly described, therefore it is all expressed as into one The combination of actions of series, but those skilled in the art should know, the embodiment of the present application is not by institute The limitation of the sequence of movement of description, because according to the embodiment of the present application, some steps can use other Order is carried out simultaneously.Secondly, those skilled in the art should also know, described in the specification Embodiment belong to preferred embodiment, involved action not necessarily the embodiment of the present application must Must.
Retrieve device embodiment
Reference picture 3, shows a kind of structured flowchart of data searcher embodiment of the application, specifically Following module can be included:
Receiving module 301, for receiving retrieval request;It can include in the retrieval request:Preset The very first time is interval;
Retrieve module 302, for using mark data as packet, in mark data, time data, right Mapping relations between the currency and history average of image data are retrieved, to obtain the very first time Target identification data of the number of interval interior, target data record in presetting range;The target data The magnitude relationship of currency described in record and the history average is fixed;And
Output module 303, for exporting the target identification data.
In a kind of alternative embodiment of the application, the size of the currency and the history average is closed System is fixed, and can specifically include:The currency is more than the history average, or, the currency Less than the history average.
In another alternative embodiment of the application, the number of the target data record is in preset model In enclosing, it can specifically include:The number of the target data record exceedes threshold value.
In another alternative embodiment of the application, when the threshold value can be more than or equal to described first Between interval length 1/2nd, and the threshold value can be less than or equal to the very first time interval length Degree.
In another alternative embodiment of the application, the retrieval module 302 can specifically include:
First retrieval submodule, for using mark data as packet, mark data, time data, Mapping relations between the currency and history average of object data are retrieved, to obtain the number of objects The target data record fixed according to the magnitude relationship of value and the history average;
Submodule is preserved, for setting up and between conservation object data and the number of the target data record Mapping relations;And
Second retrieval submodule, between the number of the object data and the target data record Mapping relations in retrieved, to obtain target mark of the number of target data record in presetting range Know data
In a kind of alternative embodiment of the application, the history average can specifically include:Object data It is worth the average in corresponding second time interval of current time data, second time interval includes: Earlier than the time data of the current time data.
Storage device embodiment
Reference picture 4, shows a kind of structured flowchart of data storage device embodiment of the application, specifically Following module can be included:
Determining module 401, between the currency according to mark data, time data and object data Mapping relations, determine that the object data is equal in corresponding second time interval of current time data Value, is used as corresponding history average;Second time interval includes:Earlier than the current time data Time data;And
Preserving module 402, for according to the history average, setting up and preserving mark data, time number According to the mapping relations between, the currency of object data and history average.
In a kind of alternative embodiment of the application, the terminal of second time interval can be previous Time data.
In another alternative embodiment of the application, the length of second time interval can be more than Equal to 1/2nd of the length in very first time interval, and the length of second time interval can be less than The length interval equal to the very first time.
For device embodiment, because it is substantially similar to embodiment of the method, so the ratio of description Relatively simple, the relevent part can refer to the partial explaination of embodiments of method.
Each embodiment in this specification is described by the way of progressive, and each embodiment is stressed Be all between difference with other embodiment, each embodiment identical similar part mutually referring to .
It should be understood by those skilled in the art that, the embodiment of the embodiment of the present application can be provided as method, dress Put or computer program product.Therefore, the embodiment of the present application can using complete hardware embodiment, completely The form of embodiment in terms of software implementation or combination software and hardware.Moreover, the embodiment of the present application Can use can be situated between in one or more computers for wherein including computer usable program code with storage The computer journey that matter is implemented on (including but is not limited to magnetic disk storage, CD-ROM, optical memory etc.) The form of sequence product.
In a typical configuration, above computer equipment includes one or more processors (CPU), input/output interface, network interface and internal memory.Internal memory potentially includes computer-readable medium In volatile memory, the shape such as random access memory (RAM) and/or Nonvolatile memory Formula, such as read-only storage (ROM) or flash memory (flash RAM).Internal memory is computer-readable medium Example.Computer-readable medium includes permanent and non-permanent, removable and non-removable media It can realize that information is stored by any method or technique.Information can be computer-readable instruction, Data structure, the module of program or other data.The example of the storage medium of computer includes, but Phase transition internal memory (PRAM), static RAM (SRAM), dynamic random is not limited to deposit Access to memory (DRAM), other kinds of random access memory (RAM), read-only storage (ROM), Electrically Erasable Read Only Memory (EEPROM), fast flash memory bank or other in Deposit technology, read-only optical disc read-only storage (CD-ROM), digital versatile disc (DVD) or other Optical storage, magnetic cassette tape, tape magnetic rigid disk storage other magnetic storage apparatus or it is any its His non-transmission medium, the information that can be accessed by a computing device available for storage.According to herein Define, computer-readable medium does not include the computer readable media (transitory media) of non-standing, Such as the data-signal and carrier wave of modulation.
The embodiment of the present application is with reference to according to the method for the embodiment of the present application, terminal device (system) and meter The flow chart and/or block diagram of calculation machine program product is described.It should be understood that can be by computer program instructions Each flow and/or square frame and flow chart and/or square frame in implementation process figure and/or block diagram The combination of flow and/or square frame in figure.Can provide these computer program instructions to all-purpose computer, The processor of special-purpose computer, Embedded Processor or other programmable data processing terminal equipments is to produce One machine so that pass through the computing devices of computer or other programmable data processing terminal equipments Instruction produce be used to realize in one flow of flow chart or multiple flows and/or one square frame of block diagram or The device for the function of being specified in multiple square frames.
These computer program instructions, which may be alternatively stored in, can guide computer or other programmable datas to handle In the computer-readable memory that terminal device works in a specific way so that be stored in this computer-readable Instruction in memory, which is produced, includes the manufacture of command device, and command device realization is in flow chart one The function of being specified in flow or multiple flows and/or one square frame of block diagram or multiple square frames.
These computer program instructions can also be loaded into computer or other programmable data processing terminals are set It is standby upper so that series of operation steps is performed on computer or other programmable terminal equipments in terms of producing The processing that calculation machine is realized, so that the instruction performed on computer or other programmable terminal equipments provides use In realization in one flow of flow chart or multiple flows and/or one square frame of block diagram or multiple square frames The step of function of specifying.
Although having been described for the preferred embodiment of the embodiment of the present application, those skilled in the art are once Basic creative concept is known, then other change and modification can be made to these embodiments.So, Appended claims are intended to be construed to include preferred embodiment and fall into the institute of the embodiment of the present application scope Have altered and change.
Finally, in addition it is also necessary to explanation, herein, such as first and second or the like relation art Language is used merely to make a distinction an entity or operation with another entity or operation, and not necessarily It is required that or implying between these entities or operation there is any this actual relation or order.And And, term " comprising ", "comprising" or any other variant thereof is intended to cover non-exclusive inclusion, from And make it that the process, method, article or the terminal device that include a series of key elements not only will including those Element, but also other key elements including being not expressly set out, or also include being this process, side Method, article or the intrinsic key element of terminal device.In the absence of more restrictions, by sentence The key element that "including a ..." is limited, it is not excluded that in the process including above-mentioned key element, method, thing Also there is other identical element in product or terminal device.
Above to a kind of data retrieval method provided herein, a kind of data searcher, a kind of number According to storage method and a kind of data storage device, it is described in detail, it is used herein specifically individual Example is set forth to the principle and embodiment of the application, and the explanation of above example is only intended to side Assistant solves the present processes and its core concept;Simultaneously for those of ordinary skill in the art, According to the thought of the application, it will change in specific embodiments and applications, to sum up Above-mentioned, this specification content should not be construed as the limitation to the application.

Claims (14)

1. a kind of data retrieval method, it is characterised in that including:
Receive retrieval request;The retrieval request includes:The preset very first time is interval;
It regard mark data as packet, mapping relations between mark data, time data, the currency of object data and history average are retrieved, to obtain target identification data of the number of the very first time interval interior, target data record in presetting range;The magnitude relationship of currency described in the target data record and the history average is fixed;
Export the target identification data.
2. according to the method described in claim 1, it is characterised in that the magnitude relationship of the currency and the history average is fixed, including:The currency is more than the history average, or, the currency is less than the history average.
3. according to the method described in claim 1, it is characterised in that the number of the target data record in presetting range, including:The number of the target data record exceedes threshold value.
4. method according to claim 3, it is characterised in that the threshold value is more than or equal to 1/2nd of the very first time interval length, and the threshold value is less than or equal to the very first time interval length.
5. according to any described method in Claims 1-4, it is characterised in that it is described using mark data as packet, the step of mapping relations between mark data, time data, the currency of object data and history average are retrieved, including:
Using mark data as packet, the mapping relations between mark data, time data, the currency of object data and history average are retrieved, to obtain the target data record that the magnitude relationship of the object data values and the history average is fixed;
Set up and the mapping relations between conservation object data and the number of the target data record;
Retrieved in mapping relations between the number of the object data and the target data record, to obtain target identification data of the number of target data record in presetting range.
6. according to any described method in Claims 1-4, it is characterised in that the history average includes:Average of the object data values in corresponding second time interval of current time data, second time interval includes:Earlier than the time data of the current time data.
7. a kind of date storage method, it is characterised in that including:
According to the mapping relations between the currency of mark data, time data and object data, average of the object data in corresponding second time interval of current time data is determined, corresponding history average is used as;Second time interval includes:Earlier than the time data of the current time data;
According to the history average, set up and preserve mark data, the mapping relations between the currency of time data, object data and history average.
8. method according to claim 7, it is characterised in that the terminal of second time interval is previous time data.
9. the method according to claim 7 or 8, it is characterised in that the length of second time interval is more than or equal to 1/2nd of the very first time interval length, and the length of second time interval is less than or equal to the very first time interval length.
10. a kind of data searcher, it is characterised in that including:
Receiving module, for receiving retrieval request;The retrieval request includes:The preset very first time is interval;
Retrieve module, for regarding mark data as packet, mapping relations between mark data, time data, the currency of object data and history average are retrieved, to obtain target identification data of the number of the very first time interval interior, target data record in presetting range;The magnitude relationship of currency described in the target data record and the history average is fixed;And
Output module, for exporting the target identification data.
11. device according to claim 10, it is characterised in that the magnitude relationship of the currency and the history average is fixed, including:The currency is more than the history average, or, the currency is less than the history average.
12. device according to claim 10, it is characterised in that the number of the target data record in presetting range, including:The number of the target data record exceedes threshold value.
13. according to any described device in claim 10 to 12, it is characterised in that the retrieval module, including:
First retrieval submodule, for regarding mark data as packet, mapping relations between mark data, time data, the currency of object data and history average are retrieved, to obtain the target data record that the magnitude relationship of the object data values and the history average is fixed;
Submodule is preserved, for the mapping relations set up and between conservation object data and the number of the target data record;And
Second retrieval submodule, for being retrieved in the mapping relations between the number of the object data and the target data record, to obtain target identification data of the number of target data record in presetting range.
14. a kind of data storage device, it is characterised in that including:
Determining module, for the mapping relations between the currency according to mark data, time data and object data, determines average of the object data in corresponding second time interval of current time data, is used as corresponding history average;Second time interval includes:Earlier than the time data of the current time data;And
Preserving module, the mapping relations for according to the history average, setting up and preserving mark data, between the currency of time data, object data and history average.
CN201610195039.2A 2016-03-30 2016-03-30 A kind of data retrieval method and device, a kind of date storage method and device Pending CN107291719A (en)

Priority Applications (3)

Application Number Priority Date Filing Date Title
CN201610195039.2A CN107291719A (en) 2016-03-30 2016-03-30 A kind of data retrieval method and device, a kind of date storage method and device
TW106105760A TW201737127A (en) 2016-03-30 2017-02-21 Data retrieval method and device, and data storage method and device
PCT/CN2017/077450 WO2017167063A1 (en) 2016-03-30 2017-03-21 Data retrieval method and device, and data storage method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610195039.2A CN107291719A (en) 2016-03-30 2016-03-30 A kind of data retrieval method and device, a kind of date storage method and device

Publications (1)

Publication Number Publication Date
CN107291719A true CN107291719A (en) 2017-10-24

Family

ID=59963491

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610195039.2A Pending CN107291719A (en) 2016-03-30 2016-03-30 A kind of data retrieval method and device, a kind of date storage method and device

Country Status (3)

Country Link
CN (1) CN107291719A (en)
TW (1) TW201737127A (en)
WO (1) WO2017167063A1 (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109815004A (en) * 2017-11-21 2019-05-28 腾讯科技(深圳)有限公司 Request load control method, device, storage medium and computer equipment
CN114072788A (en) * 2019-07-02 2022-02-18 国际商业机器公司 Random sampling from search engine
CN115001853A (en) * 2022-07-18 2022-09-02 山东云天安全技术有限公司 Abnormal data identification method and device, storage medium and computer equipment

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
TWI687821B (en) * 2018-11-21 2020-03-11 核桃運算股份有限公司 Data tracking apparatus, method, and computer program product thereof
CN111311112A (en) * 2020-03-10 2020-06-19 开封博士创新技术转移有限公司 Enterprise intellectual property data management method and device, electronic equipment and readable storage medium
CN111427892B (en) * 2020-03-25 2022-11-25 中国电子科技集团公司第二十八研究所 Active data blocking management method and device for active target

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1971566A (en) * 2005-11-21 2007-05-30 Sap股份公司 Tracking usage of data elements in electronic business communications
CN102346894A (en) * 2010-08-03 2012-02-08 阿里巴巴集团控股有限公司 Output method, system and server of recommendation information
CN103678402A (en) * 2012-09-21 2014-03-26 厦门雅迅网络股份有限公司 Real-time data statistics method of mass data
CN104216977A (en) * 2014-09-01 2014-12-17 北京优特捷信息技术有限公司 Time series data search method and device
CN105354623A (en) * 2015-09-30 2016-02-24 中国电力科学研究院 Abnormality detection optimization method oriented to power grid spatio-temporal data

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6611726B1 (en) * 1999-09-17 2003-08-26 Carl E. Crosswhite Method for determining optimal time series forecasting parameters
US8756200B2 (en) * 2004-05-14 2014-06-17 Oracle International Corporation Undo advisor
CN104408143A (en) * 2014-12-01 2015-03-11 北京国双科技有限公司 Webpage data monitoring method and device
CN104462445A (en) * 2014-12-15 2015-03-25 北京国双科技有限公司 Webpage access data processing method and webpage access data processing device

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1971566A (en) * 2005-11-21 2007-05-30 Sap股份公司 Tracking usage of data elements in electronic business communications
CN102346894A (en) * 2010-08-03 2012-02-08 阿里巴巴集团控股有限公司 Output method, system and server of recommendation information
CN103678402A (en) * 2012-09-21 2014-03-26 厦门雅迅网络股份有限公司 Real-time data statistics method of mass data
CN104216977A (en) * 2014-09-01 2014-12-17 北京优特捷信息技术有限公司 Time series data search method and device
CN105354623A (en) * 2015-09-30 2016-02-24 中国电力科学研究院 Abnormality detection optimization method oriented to power grid spatio-temporal data

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
在水一方2: "上升趋势的判断方法及操作策略", 《HTTP://WWW.360DOC.COM/CONTENT/13/0728/15/297960_303134449.SHTML》 *

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109815004A (en) * 2017-11-21 2019-05-28 腾讯科技(深圳)有限公司 Request load control method, device, storage medium and computer equipment
CN114072788A (en) * 2019-07-02 2022-02-18 国际商业机器公司 Random sampling from search engine
US11797615B2 (en) 2019-07-02 2023-10-24 International Business Machines Corporation Random sampling from a search engine
CN115001853A (en) * 2022-07-18 2022-09-02 山东云天安全技术有限公司 Abnormal data identification method and device, storage medium and computer equipment
CN115001853B (en) * 2022-07-18 2022-11-04 山东云天安全技术有限公司 Abnormal data identification method and device, storage medium and computer equipment

Also Published As

Publication number Publication date
WO2017167063A1 (en) 2017-10-05
TW201737127A (en) 2017-10-16

Similar Documents

Publication Publication Date Title
CN107291719A (en) A kind of data retrieval method and device, a kind of date storage method and device
CN107844565B (en) Commodity searching method and device
US10504120B2 (en) Determining a temporary transaction limit
Adarkwa Impact of remittances on economic growth: Evidence from selected West African countries (Cameroon, Cape Verde, Nigeria and Senegal)
US9442949B2 (en) System and method for compressing data in a database
CN108205580A (en) A kind of image search method, device and computer readable storage medium
US11182364B2 (en) Data analysis support apparatus and data analysis support method
CN109614507B (en) Remote sensing image recommendation device based on frequent item mining
CN107357812A (en) A kind of data query method and device
US10552484B2 (en) Guided data exploration
CN109460519A (en) Browse object recommendation method and device, storage medium, server
CN111985201B (en) Data processing rule generation method and device and electronic equipment
CN111930848A (en) Data partition storage method, device and system
CN106202209A (en) The storage of distributed structured data and querying method towards commodity screening application
CN108804594A (en) A kind of construction method and device of news content full-text search engine
CN107644033B (en) Method and equipment for querying data in non-relational database
Prathap A three-dimensional bibliometric evaluation of research in polymer solar cells
CN110147504A (en) Regional Education satisfaction with the resource evaluation method and system
JP7213890B2 (en) Accelerated large-scale similarity computation
CN108241652A (en) Keyword clustering method and device
CN110389932A (en) Electric power automatic document classifying method and device
CN109241048A (en) For the data processing method of data statistics, server and storage medium
Cromley et al. A concentration-based approach to data classification for choropleth mapping
CN110309273A (en) Answering method and device
CN107391533A (en) Generate the method and device of graphic data base Query Result

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for 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: 20171024