CN103559635A - Data processing method and device used for inquiring advertising material status - Google Patents
Data processing method and device used for inquiring advertising material status Download PDFInfo
- Publication number
- CN103559635A CN103559635A CN201310552099.1A CN201310552099A CN103559635A CN 103559635 A CN103559635 A CN 103559635A CN 201310552099 A CN201310552099 A CN 201310552099A CN 103559635 A CN103559635 A CN 103559635A
- Authority
- CN
- China
- Prior art keywords
- state
- advertisement material
- time
- storage
- time interval
- 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
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a data processing method and device used for inquiring advertising material status. The data processing method used for inquiring advertising material status includes the steps of acquiring the status of advertising materials, judging whether the status of the advertising materials changes or not, acquiring time corresponding to the latest status of the advertising materials if it is judged out that the status of the advertising materials has changed, and recording the deadline corresponding to a time interval in which historical status of the advertising materials is stored as the time corresponding to the latest status. Through the data processing method and device used for inquiring advertising material status, the efficiency for inquiring the advertising material status can be improved.
Description
Technical field
The present invention relates to internet arena, in particular to a kind of data processing method for queries ad material state and device.
Background technology
The state of advertisement material can become and change along with the time, according to the history of this state, changed tracking and the recruitment evaluation that trend can be carried out advertisement state.Traditional approach is for all advertisement materials, under specific time granularity, advertisement state is carried out to record.Such as all recording once the state of all advertisement materials every day.
While utilizing traditional approach to carry out recording of advertisement material state, all will be to all advertisement material recording status every the fixing cycle, namely every the fixing cycle, the total quantity that will newly-increased record count equals the advertisement material that will record, when advertisement material quantity a lot, and time granularity is smaller time, records very fast that number can increase, and causes recording storage space and takies larger.
In the change trend of queries ad material state, because the record of the advertisement material state of storing is a lot, need queries ad material state record one by one, cause search efficiency low.
For queries ad material state in prior art, change the inefficient problem of trend, not yet propose at present effective solution.
Summary of the invention
Fundamental purpose of the present invention is to provide a kind of disposal route and device of advertisement material status data, while recording advertisement material state to solve in prior art, takies the problem that storage space is larger.
To achieve these goals, according to an aspect of the present invention, provide a kind of disposal route of advertisement material status data.According to the disposal route of advertisement material status data of the present invention, comprise: the state that obtains advertisement material; Whether the state that judges advertisement material changes; If judge the state of advertisement material, change, obtain the time corresponding to last state of advertisement material; And the time interval of historical advertisement material state storage is recorded as to the time that last state is corresponding corresponding closing time.
Further, at the last state that obtains advertisement material, after the corresponding time, this data processing method also comprises: the time interval of new material state storage is recorded as to time that last state is corresponding to maximum time.
Whether the state that further, judges advertisement material changes and comprises: the state value that obtains the last state of advertisement material; Obtain the state value of historical advertisement material; Whether the state value of the state value of the last state of comparative advertising material and historical advertisement material is identical; If the state value of the last state of advertisement material is identical with the state value of historical advertisement material, determine that the state of advertisement material does not change; And if the state value of the last state of advertisement material is different with the state value of historical advertisement material, determine that the state of advertisement material changes.
Further, after the time interval of historical material state storage is recorded as to the time that last state is corresponding corresponding closing time, data processing method also comprises: obtain query time interval; Utilize query time interval in the advertisement material state of storage, to search the interval corresponding state value of query time, wherein, the advertisement material state of storage comprises last state and the historical advertisement material state of advertisement material; And the interval corresponding state value of the query time inquiring is filled in query time interval.
Further, utilizing query time interval in the advertisement material state of storage, to inquire about the interval corresponding state value of query time comprises: the initial time of obtaining query time interval; Obtain the closing time in query time interval; The initial time that judges query time interval whether be greater than storage advertisement material state initial time and be less than advertisement material state closing time of storage; Judge query time interval the advertisement material state that whether is greater than storage closing time initial time and be less than advertisement material state closing time of storage; And if the initial time in query time interval whether be greater than storage advertisement material state initial time and be less than advertisement material state closing time of storage, or whether be greater than the closing time in query time interval storage advertisement material state initial time and be less than advertisement material state closing time of storage, using state value corresponding to the time interval inquiring as the interval corresponding state value of query time.
To achieve these goals, according to a further aspect in the invention, provide a kind for the treatment of apparatus of advertisement material status data.According to the treating apparatus of advertisement material status data of the present invention, comprise: the first acquiring unit, for obtaining the state of advertisement material; Judging unit, for judging whether the state of advertisement material changes; Second acquisition unit, while changing for the state judging advertisement material, obtains the time corresponding to last state of advertisement material; And record cell, for the time interval of historical advertisement material state storage is recorded as to the time that last state is corresponding corresponding closing time.
Further, data processing equipment also comprises: time interval unit, for the last state obtaining advertisement material after the corresponding time, is recorded as time that last state is corresponding to maximum time by the time interval of new material state storage.
Further, judging unit comprises: the first acquisition module, for obtaining the state value of the last state of advertisement material; The second acquisition module, for obtaining the state value of historical advertisement material; Whether comparison module is identical with the state value of historical advertisement material for the state value of last state of comparative advertising material; The first determination module, when identical with the state value of historical advertisement material for the state value of the last state at advertisement material, determines that the state of advertisement material does not change; And second determination module, when different with the state value of historical advertisement material for the state value of the last state at advertisement material, determine that the state of advertisement material changes.
Further, data processing equipment also comprises: the 3rd acquiring unit, after the time interval of historical material state storage is recorded as to the time that last state is corresponding corresponding closing time, obtains query time interval; Search unit, for utilizing query time interval to search the interval corresponding state value of query time at the advertisement material state of storage, wherein, the advertisement material state of storage comprises last state and the historical advertisement material state of advertisement material; And filler cells, for the interval corresponding state value of the query time inquiring is filled in query time interval.
Further, search unit and comprise: very first time acquisition module, for obtaining the initial time in query time interval; The second time-obtaining module, for obtaining the closing time in query time interval; The first judge module, for judge the initial time in query time interval whether be greater than storage advertisement material state initial time and be less than advertisement material state closing time of storage; The second judge module, for judge query time interval the advertisement material state that whether is greater than storage closing time initial time and be less than advertisement material state closing time of storage; And the 3rd determination module, for initial time in query time interval, whether be greater than storage advertisement material state initial time and be less than advertisement material state closing time of storage, or whether be greater than the initial time of advertisement material state of storage and the advertisement material state that is less than storage the closing time in query time interval during closing time, using state value corresponding to the time interval inquiring as the interval corresponding state value of query time.
By the present invention, adopt the state that obtains advertisement material; Whether the state that judges described advertisement material changes, if judging the state of described advertisement material changes, obtain the time corresponding to last state of described advertisement material, and the time interval of historical material state storage is recorded as to the time that described last state is corresponding corresponding closing time, solve queries ad material state in prior art and changed the inefficient problem of trend, and then reached the effect that improves advertisement material status poll efficiency.
Accompanying drawing explanation
The accompanying drawing that forms the application's a part is used to provide a further understanding of the present invention, and schematic description and description of the present invention is used for explaining the present invention, does not form inappropriate limitation of the present invention.In the accompanying drawings:
Fig. 1 is according to the process flow diagram of the data processing method of first embodiment of the invention;
Fig. 2 is according to the process flow diagram of the data processing method of second embodiment of the invention;
Fig. 3 is according to the schematic diagram of the data processing equipment for queries ad material state of the embodiment of the present invention; And
Fig. 4 is according to the schematic diagram of the data processing equipment of second embodiment of the invention.
Embodiment
It should be noted that, in the situation that not conflicting, embodiment and the feature in embodiment in the application can combine mutually.Describe below with reference to the accompanying drawings and in conjunction with the embodiments the present invention in detail.
In order to make those skilled in the art person understand better the present invention program, 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, rather than whole embodiment.Embodiment based in the present invention, those of ordinary skills, not making the every other embodiment obtaining under creative work prerequisite, should belong to the scope of protection of the invention.
It should be noted that, the term " first " in instructions of the present invention and claims and above-mentioned accompanying drawing, " second " etc. are for distinguishing similar object, and needn't be for describing specific order or precedence.The data that should be appreciated that such use suitably can exchanged in situation, so as embodiments of the invention described herein can with except diagram here or describe those order enforcement.In addition, term " comprises " and " having " and their any distortion, intention is to cover not exclusive comprising, for example, those steps or unit that the process that has comprised series of steps or unit, method, system, product or equipment are not necessarily limited to clearly list, but can comprise clearly do not list or for these processes, method, product or equipment intrinsic other step or unit.
The embodiment of the present invention provides a kind of data processing method for queries ad material state.The method may operate on computer processor unit, below in conjunction with accompanying drawing, the method is described.
Fig. 1 is according to the process flow diagram of the data processing method of first embodiment of the invention.As shown in the figure, the data processing method of this queries ad material state comprises the steps:
Step S101, obtains the state of advertisement material.The state of advertisement material can be up-to-date advertisement material state, in order to judge whether the state of advertisement material changes, the nearest advertisement material state of storage and the up-to-date advertisement material state obtaining can be compared.
Step S102, judges whether the state of advertisement material changes.The state of advertisement material can be weighed according to the state value of advertisement material, and wherein, the state value of advertisement material can be used for weighing the residing state of current advertisement material, thereby judges whether the state of advertisement material changes.
Step S103, changes if judge the state of advertisement material, obtains the time corresponding to last state of advertisement material.State value to advertisement material contrasts, if it is different to judge the state value of advertisement material, determines that the state of advertisement material changes, and obtains the corresponding time of up-to-date state of advertisement material.For example, the state value of nearest (for example 13:00) advertisement material of storing in database is 8, and the state value of an advertisement material of up-to-date (for example 13:01) is 10, determines that the state of advertisement material changes.The state of a up-to-date advertisement material is the last state of advertisement material, and the time that this last state is corresponding is 13:01, records this time.
Step S104, is recorded as by the time interval of historical advertisement material state storage the time that last state is corresponding corresponding closing time.Historical advertisement material state is a nearest advertisement material of storing in the database in previous example, and its initial time is the 13:00 in example, will be recorded as the time that last state is corresponding, i.e. 13:01 its closing time.So, the time interval of historical advertisement material state storage is 13:00-13:01.
Known by above-mentioned steps, while changing due to the state at advertisement material, obtain the time corresponding to last state of advertisement material, and the time interval of historical advertisement material state storage is recorded as to the time that last state is corresponding corresponding closing time, can when upgrading advertisement material state, reduce the storage number of the state of advertisement material, the state of the advertisement material that only more kainogenesis state changes, and, upgraded closing time corresponding to advertisement material state, when certain interval advertisement material state is inquired about, can be easily according to initial time with search advertisement material state closing time, improved search efficiency.
It should be noted that, judge that the interval whether advertisement material state changes can be the fixed cycle, for example, within every 1 minute, judge once, also can judge every day once, the judgement cycle can be determined according to the needs of data processing.
Preferably, at the last state that obtains advertisement material after the corresponding time, the time interval of new material state storage is recorded as to time that last state is corresponding to maximum time, time in the time of can being changed into the change of advertisement material state when advertisement material state changes again this maximum time, can upgrade more easily advertisement material state, and more accurate, during convenient inquiry, determine the time interval of inquiring about.
Wherein, maximum time can be the time that system sets in advance, due to the time of uncertain advertisement material state continuance, also the time that uncertain this advertisement material state changes, maximum time can be set to for example 2099-9-1, because time span is larger, can be accurate in the time of can guaranteeing according to time interval queries ad material state, do not conflict with query time.
Whether the state that judges advertisement material changes and can judge according to the state value of advertisement material, and this determination methods comprises the following steps:
Step 1021, obtains the state value of the last state of advertisement material.The state value of the last state of the advertisement material obtaining is here the state value of the last state of advertisement material.
Step 1022, obtains the state value of historical material.The state of historical material is the state adjacent with the last state of advertisement material, is the Last status of the last state of advertisement material, and the state value of historical material can be identical or different from the state value of the last state of advertisement material.
Step 1023, whether the state value of the last state of comparative advertising material and the state value of historical material be identical.According to above-mentioned example, the state value of the last state of advertisement material is 10, and the state value of historical material is 8, determines that the state value of last state of advertisement material is different with the state value of historical material.
Step 1024, if the state value of the last state of advertisement material is identical with the state value of historical material, determines that the state of advertisement material does not change.
Step 1025, if the state value of the last state of advertisement material is different with the state value of historical material, determines that the state of advertisement material changes.
The state value of last state and the state value of historical material by judgement advertisement material are not identical, there is change in the state that can determine advertisement material, thereby the time when changing to state the closing time of the historical advertisement material state changing and change, and last state is stored in database, record between the cut-off region of last state is maximum time, therefore the advertisement material can a recording status changing, reduces the record count of advertisement material, improves search efficiency.
Fig. 2 is according to the process flow diagram of the data processing method of second embodiment of the invention.As shown in the figure, this data processing method comprises the steps:
Step S201, obtains the state of advertisement material.The state of advertisement material can be up-to-date advertisement material state, can also be arbitrary the advertisement material state being stored in database.In order to judge whether the state of advertisement material changes, the nearest advertisement material state of storage is compared with up-to-date advertisement material state, so the advertisement material state obtaining can be a nearest advertisement material state and the up-to-date advertisement material state being stored in database.
Step S202, judges whether the state of advertisement material changes.The state of advertisement material can be weighed according to the state value of the last state of advertisement material, and wherein, the state value of the last state of advertisement material can be used for weighing the residing state of current advertisement material, thereby judges whether the state of advertisement material changes.
Step S203, changes if judge the state of advertisement material, obtains the time corresponding to last state of advertisement material.State value to the last state of advertisement material contrasts, if judge the state value difference of the last state of advertisement material, determines that the state of advertisement material changes, and obtains the corresponding time of up-to-date state of advertisement material.For example, the state value of the last state of nearest (for example 13:00) advertisement material of storing in database is 8, and the state value of the last state of an advertisement material of up-to-date (for example 13:01) is 10, determines that the state of advertisement material changes.The state of a up-to-date advertisement material is the last state of advertisement material, and the time that this last state is corresponding is 13:01, records this time.
Step S204, is recorded as by the time interval of historical advertisement material state storage the time that last state is corresponding corresponding closing time.Historical advertisement material state is a nearest advertisement material of storing in the database in previous example, and its initial time is the 13:00 in example, will be recorded as the time that last state is corresponding, i.e. 13:01 its closing time.So, the time interval of historical advertisement material state storage is 13:00-13:01.
Step S205, obtains query time interval.The query time interval obtaining can comprise certain time period before current time, can also comprise current time certain time period afterwards, but, because the advertisement material state of certain time period after current time does not also occur and record, therefore, generally query time interval is current time certain time period before.
For example, current time is 2013-3-2, and query time interval can be 2013-2-1～2013-4-1, and the initial time in query time interval is the time before current time, can, for the time after current time, can be also current time the closing time in query time interval.
Step S206, utilizes query time interval in the advertisement material state of storage, to search the interval corresponding state value of this query time.If the time interval of the advertisement material state of the interval corresponding storage of query time only has one, interval only corresponding state value of this query time so, if it is a plurality of that the time interval of the advertisement material state of the storage that query time is interval corresponding has, interval corresponding a plurality of state values of this query time so.
Step S207, is filled into the interval corresponding state value of the query time inquiring in query time interval.If inquire a plurality of state values, a plurality of state values that inquire are filled in corresponding query time interval.Thereby can see the variation tendency of advertisement material state value in query time interval, be used for carrying out tracking and the recruitment evaluation of advertisement.
Data processing method below in conjunction with the table 1 pair embodiment of the present invention describes.Table 1 shows the status data of the advertisement material of the total storage of database.
| Sequence number | State value | Initial | Cut-off |
| 1 | 5 | 2013-1-1 | 2013-1-10 |
| 2 | 10 | 2013-1-11 | 2013-3-1 |
| 3 | 8 | 2013-3-2 | 2099-9-1 |
Utilize query time interval in the advertisement material state of storage, to inquire about the concrete steps of state value corresponding to query time as follows:
Step S2061, obtains the initial time in query time interval.For example, the initial time of obtaining query time interval is 2013-2-1.
Step S2062, obtains closing time in query time interval.Be 2013-4-1 the closing time of for example, obtaining query time interval.
Step S2063, the initial time that judges query time interval whether be greater than storage advertisement material state initial time and be less than advertisement material state closing time of storage.In database, search qualified advertisement material state, in the present example, the initial time 2013-2-1 that judges query time interval whether be greater than storage advertisement material state initial time and be less than advertisement material state closing time of storage, in table 1, inquiry character is should the advertisement material of condition is sequence number 2, its initial time is 2013-1-11, and be 2013-3-1 closing time, and state value is 10.
Step S2064, judge query time interval the advertisement material state that whether is greater than storage closing time initial time and be less than advertisement material state closing time of storage.In database, search qualified advertisement material state, in the present example, 2013-4-1 closing time that judges query time interval whether be greater than storage advertisement material state initial time and be less than advertisement material state closing time of storage, in table 1, inquiry character is should the advertisement material of condition is sequence number 3, its initial time is 2013-3-2, and be 2099-9-1 closing time, and state value is 8.
Step S2065, if the initial time in query time interval whether be greater than storage advertisement material state initial time and be less than advertisement material state closing time of storage, or whether be greater than the closing time in query time interval storage advertisement material state initial time and be less than advertisement material state closing time of storage, using state value corresponding to the time interval inquiring as the interval corresponding state value of query time.
According to step S2063 and step S2064, find sequence number and be respectively 2 and 3 advertisement material state, the interval of inquiry is divided into two time periods, i.e. 2013-2-1～2013-3-1 and 2013-3-2～2013-4-1.The state value of sequence number 2 10 is filled to time period 2013-2-1～2013-3-1, the state value of sequence number 38 is filled to time period 2013-3-2～2013-4-1.Therefore the interval corresponding state value of query time is 8 and 10, can determine the variation tendency of advertisement physical state in this query time interval according to the state value of filling, thereby carry out assessment and analysis.
The embodiment of the present invention also provides a kind of data processing equipment for queries ad material state.
The data processing equipment for queries ad material state that the data processing method for queries ad material state of the embodiment of the present invention can provide by the embodiment of the present invention is carried out, the data processing method for queries ad material state that the data processing equipment for queries ad material state of the embodiment of the present invention also can provide for carrying out the embodiment of the present invention.
Fig. 3 is according to the schematic diagram of the data processing equipment for queries ad material state of the embodiment of the present invention.As described in Figure, this data processing equipment comprises: the first acquiring unit 10, judging unit 20, second acquisition unit 30 and record cell 40.
The first acquiring unit 10 is for obtaining the state of advertisement material.The state of advertisement material can be up-to-date advertisement material state, in order to judge whether the state of advertisement material changes, the nearest advertisement material state of storage and the up-to-date advertisement material state obtaining can be compared.
Judging unit 20 is for judging whether the state of advertisement material changes.The state of advertisement material can be weighed according to the state value of advertisement material, and wherein, the state value of advertisement material can be used for weighing the residing state of current advertisement material, thereby judges whether the state of advertisement material changes.
When second acquisition unit 30 changes for the state judging advertisement material, obtain the time corresponding to last state of advertisement material.State value to advertisement material contrasts, if it is different to judge the state value of advertisement material, determines that the state of advertisement material changes, and obtains the corresponding time of up-to-date state of advertisement material.For example, the state value of nearest (for example 13:00) advertisement material of storing in database is 8, and the state value of an advertisement material of up-to-date (for example 13:01) is 10, determines that the state of advertisement material changes.The state of a up-to-date advertisement material is the last state of advertisement material, and the time that this last state is corresponding is 13:01, records this time.
Record cell 40 is for being recorded as by the time interval of historical advertisement material state storage the time that last state is corresponding corresponding closing time.Historical advertisement material state is a nearest advertisement material of storing in the database in previous example, and its initial time is the 13:00 in example, will be recorded as the time that last state is corresponding, i.e. 13:01 its closing time.So, the time interval of historical advertisement material state storage is 13:00-13:01.
Known by above-mentioned steps, while changing due to the state at advertisement material, obtain the time corresponding to last state of advertisement material, and the time interval of historical advertisement material state storage is recorded as to the time that last state is corresponding corresponding closing time, can when upgrading advertisement material state, reduce the storage number of the state of advertisement material, the state of the advertisement material that only more kainogenesis state changes, and, upgraded closing time corresponding to advertisement material state, when certain interval advertisement material state is inquired about, can be easily according to initial time with search advertisement material state closing time, improved search efficiency.
It should be noted that, judge that the interval whether advertisement material state changes can be the fixed cycle, for example, within every 1 minute, judge once, also can judge every day once, the judgement cycle can be determined according to the needs of data processing.
Further, this data processing equipment also comprises time interval unit, be used at the last state that obtains advertisement material after the corresponding time, the time interval of new material state storage is recorded as to time that last state is corresponding to maximum time, time in the time of can being changed into the change of advertisement material state when advertisement material state changes again this maximum time, can upgrade more easily advertisement material state, and more accurate, during convenient inquiry, determine the time interval of inquiring about.
Wherein, maximum time can be the time that system sets in advance, due to the time of uncertain advertisement material state continuance, also the time that uncertain this advertisement material state changes, maximum time can be set to for example 2099-9-1, because time span is larger, can be accurate in the time of can guaranteeing according to time interval queries ad material state, do not conflict with query time.
Judging unit 20 judges whether the state of advertisement material changes and can judge according to the state value of advertisement material, and this judging unit 20 comprises the first acquisition module, the second acquisition module, comparison module, the first determination module and the second determination module.
The first acquisition module is for obtaining the state value of the last state of advertisement material.The state value of the last state of the advertisement material obtaining is here the state value of the last state of advertisement material.
The second acquisition module is for obtaining the state value of historical advertisement material.The state of historical material is the state adjacent with the last state of advertisement material, is the Last status of the last state of advertisement material, and the state value of historical material can be identical or different from the state value of the last state of advertisement material.
Whether comparison module is identical with the state value of historical advertisement material for the state value of last state of comparative advertising material.According to above-mentioned example, the state value of the last state of advertisement material is 10, and the state value of historical material is 8, determines that the state value of last state of advertisement material is different with the state value of historical material.
When the first determination module is identical with the state value of historical advertisement material for the state value of last state at advertisement material, determine that the state of advertisement material does not change.
When the second determination module is different with the state value of historical advertisement material for the state value of last state at advertisement material, determine that the state of advertisement material changes.
The state value of last state and the state value of historical material by judgement advertisement material are not identical, there is change in the state that can determine advertisement material, thereby the time when changing to state the closing time of the historical advertisement material state changing and change, and last state is stored in database, record between the cut-off region of last state is maximum time, therefore the advertisement material can a recording status changing, reduces the record count of advertisement material, improves search efficiency.
Fig. 4 is according to the schematic diagram of the data processing equipment of second embodiment of the invention.As shown in the figure, this data processing equipment comprises the first acquiring unit 10, judging unit 20, second acquisition unit 30 and record cell 40, also comprises the 3rd acquiring unit 50, searches unit 60 and filler cells 70.Wherein, the first acquiring unit 10, judging unit 20, second acquisition unit 30 and record cell 40 shown in this figure are identical with record cell 40 functions with the first acquiring unit 10, judging unit 20, second acquisition unit 30 in the data processing equipment shown in Fig. 3, and therefore not to repeat here.
The 3rd acquiring unit 50, for after the time interval of historical material state storage is recorded as to the time that last state is corresponding corresponding closing time, obtains query time interval.The query time interval obtaining can comprise certain time period before current time, can also comprise current time certain time period afterwards, but, because the advertisement material state of certain time period after current time does not also occur and record, therefore, generally query time interval is current time certain time period before.
For example, current time is 2013-3-2, and query time interval can be 2013-2-1～2013-4-1, and the initial time in query time interval is the time before current time, can, for the time after current time, can be also current time the closing time in query time interval.
Search unit 60 for utilizing query time interval to search the interval corresponding state value of query time at the advertisement material state of storage, wherein, the advertisement material state of storage comprises last state and the historical advertisement material state of advertisement material.If the time interval of the advertisement material state of the interval corresponding storage of query time only has one, interval only corresponding state value of this query time so, if it is a plurality of that the time interval of the advertisement material state of the storage that query time is interval corresponding has, interval corresponding a plurality of state values of this query time so.
Filler cells 70 is for being filled into the interval corresponding state value of the query time inquiring in query time interval.If inquire a plurality of state values, a plurality of state values that inquire are filled in corresponding query time interval.Thereby can see the variation tendency of advertisement material state value in query time interval, be used for carrying out tracking and the recruitment evaluation of advertisement.
Data processing method below in conjunction with the table 1 pair embodiment of the present invention describes.Table 1 shows the status data of the advertisement material of the total storage of database.
| Sequence number | State value | Initial | Cut-off |
| 1 | 5 | 2013-1-1 | 2013-1-10 |
| 2 | 10 | 2013-1-11 | 2013-3-1 |
| 3 | 8 | 2013-3-2 | 2099-9-1 |
Search unit 60 and utilize query time interval in the advertisement material state of storage, to search the interval corresponding state value of query time, search unit 60 and comprise very first time acquisition module, the second time-obtaining module, the first judge module, the second judge module and the 3rd determination module.
Very first time acquisition module is for obtaining the initial time in query time interval.For example, the initial time of obtaining query time interval is 2013-2-1.
The second time-obtaining module is for obtaining the closing time in query time interval.For example, the initial time of obtaining query time interval is 2013-2-1.
The first judge module for the initial time that judges query time interval, whether be greater than storage advertisement material state initial time and be less than advertisement material state closing time of storage.In database, search qualified advertisement material state, in the present example, the initial time 2013-2-1 that judges query time interval whether be greater than storage advertisement material state initial time and be less than advertisement material state closing time of storage, in table 1, inquiry character is should the advertisement material of condition is sequence number 2, its initial time is 2013-1-11, and be 2013-3-1 closing time, and state value is 10.
The second judge module for judge query time interval the advertisement material state that whether is greater than storage closing time initial time and be less than advertisement material state closing time of storage.In database, search qualified advertisement material state, in the present example, 2013-4-1 closing time that judges query time interval whether be greater than storage advertisement material state initial time and be less than advertisement material state closing time of storage, in table 1, inquiry character is should the advertisement material of condition is sequence number 3, its initial time is 2013-3-2, and be 2099-9-1 closing time, and state value is 8.
The 3rd determination module, for initial time in query time interval, whether be greater than storage advertisement material state initial time and be less than advertisement material state closing time of storage, or whether be greater than the initial time of advertisement material state of storage and the advertisement material state that is less than storage the closing time in query time interval during closing time, using state value corresponding to the time interval inquiring as the interval corresponding state value of query time.
Utilize the first judge module and the second judge module to find sequence number and be respectively 2 and 3 advertisement material state, the interval of inquiry is divided into two time periods, i.e. 2013-2-1～2013-3-1 and 2013-3-2～2013-4-1.The state value of sequence number 2 10 is filled to time period 2013-2-1～2013-3-1, the state value of sequence number 38 is filled to time period 2013-3-2～2013-4-1.Therefore the interval corresponding state value of query time is 8 and 10, can determine the variation tendency of advertisement physical state in this query time interval according to the state value of filling, thereby carry out assessment and analysis.
The embodiment of the present invention also provides a kind of computer-readable storage medium.This computer-readable storage medium can have program stored therein, and this program is for carrying out the part or all of step of the above-mentioned data processing method for queries ad material state.
It should be noted that, for aforesaid each embodiment of the method, for simple description, therefore it is all expressed as to a series of combination of actions, but those skilled in the art should know, the present invention is not subject to the restriction of described sequence of movement, because according to the present invention, some step can adopt other orders or carry out simultaneously.Secondly, those skilled in the art also should know, the embodiment described in instructions all belongs to preferred embodiment, and related action and module might not be that the present invention is necessary.
In the above-described embodiments, the description of each embodiment is all emphasized particularly on different fields, in certain embodiment, there is no the part of detailed description, can be referring to the associated description of other embodiment.
In the several embodiment that provide in the application, should be understood that disclosed device can be realized by another way.For example, device embodiment described above is only schematic, the for example division of described unit, be only that a kind of logic function is divided, during actual realization, can there is other dividing mode, for example a plurality of unit or assembly can in conjunction with or can be integrated into another system, or some features can ignore, or do not carry out.Another point, shown or discussed coupling each other or direct-coupling or communication connection can be by some interfaces, indirect coupling or the communication connection of device or unit can be electrical or other form.
The described unit as separating component explanation can or can not be also to separate on material, and the parts that show as unit can be or can not be also material unit, can be positioned at a place, or also can be distributed in a plurality of network element.Can select according to the actual needs some or all of unit wherein to realize the object of the present embodiment scheme.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, can be also that the independent material of unit exists, and also can be integrated in a unit two or more unit.Above-mentioned integrated unit both can adopt the form of hardware to realize, and also can adopt the form of SFU software functional unit to realize.
If the form of SFU software functional unit of usining described integrated unit realizes and during as production marketing independently or use, can be stored in a computer read/write memory medium.Understanding based on such, the all or part of of the part that technical scheme of the present invention contributes to prior art in essence in other words or this technical scheme can embody with the form of software product, this computer software product is stored in a storage medium, comprises that some instructions are with so that a computer equipment (can be personal computer, database or the network equipment etc.) is carried out all or part of step of method described in each embodiment of the present invention.And aforesaid storage medium comprises: various media that can be program code stored such as USB flash disk, ROM (read-only memory) (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), portable hard drive, magnetic disc or CDs.
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 modification of doing, be equal to replacement, improvement etc., within all should being included in protection scope of the present invention.
Claims (10)
1. for a data processing method for queries ad material state, it is characterized in that, comprising:
Obtain the state of advertisement material;
Whether the state that judges described advertisement material changes;
If judge the state of described advertisement material, change, obtain the time corresponding to last state of described advertisement material; And
The time interval of historical advertisement material state storage is recorded as to the time that described last state is corresponding corresponding closing time.
2. data processing method according to claim 1, is characterized in that, at the last state that obtains described advertisement material, after the corresponding time, described data processing method also comprises:
The time interval of new material state storage is recorded as to time that described last state is corresponding to maximum time.
3. data processing method according to claim 1, is characterized in that, whether the state that judges described advertisement material changes and comprise:
Obtain the state value of the last state of described advertisement material;
Obtain the state value of described historical advertisement material;
Whether the state value of the state value of the last state of more described advertisement material and described historical advertisement material is identical;
If the state value of the last state of described advertisement material is identical with the state value of described historical advertisement material, determine that the state of described advertisement material does not change; And
If the state value of the last state of described advertisement material is different with the state value of described historical advertisement material, determine that the state of described advertisement material changes.
4. data processing method according to claim 1, is characterized in that, after the time interval of historical material state storage is recorded as to the time that described last state is corresponding corresponding closing time, described data processing method also comprises:
Obtain query time interval;
Utilize described query time interval in the advertisement material state of storage, to search the interval corresponding state value of described query time, wherein, the advertisement material state of described storage comprises last state and the described historical advertisement material state of described advertisement material; And
The interval corresponding state value of the described query time inquiring is filled in described query time interval.
5. data processing method according to claim 4, is characterized in that, utilizes described query time interval in the advertisement material state of storage, to inquire about the interval corresponding state value of described query time and comprises:
Obtain the initial time in described query time interval;
Obtain the closing time in described query time interval;
The initial time that judges described query time interval whether be greater than described storage advertisement material state initial time and be less than advertisement material state closing time of described storage;
Judge described query time interval the advertisement material state that whether is greater than described storage closing time initial time and be less than advertisement material state closing time of described storage; And
If the initial time in described query time interval whether be greater than described storage advertisement material state initial time and be less than advertisement material state closing time of described storage, or the initial time of the advertisement material state that whether is greater than described storage closing time in described query time interval and be less than advertisement material state closing time of described storage, using state value corresponding to the time interval inquiring as the interval corresponding state value of described query time.
6. for a data processing equipment for queries ad material state, it is characterized in that, comprising:
The first acquiring unit, for obtaining the state of advertisement material;
Judging unit, for judging whether the state of described advertisement material changes;
Second acquisition unit, while changing for the state judging described advertisement material, obtains the time corresponding to last state of described advertisement material; And
Record cell, for being recorded as by the time interval of historical advertisement material state storage the time that described last state is corresponding corresponding closing time.
7. data processing equipment according to claim 6, is characterized in that, described data processing equipment also comprises:
Time interval unit, for the last state obtaining described advertisement material after the corresponding time, is recorded as time that described last state is corresponding to maximum time by the time interval of new material state storage.
8. data processing equipment according to claim 6, is characterized in that, described judging unit comprises:
The first acquisition module, for obtaining the state value of the last state of described advertisement material;
The second acquisition module, for obtaining the state value of described historical advertisement material;
Whether comparison module is identical with the state value of described historical advertisement material for the state value of last state of more described advertisement material;
The first determination module, when identical with the state value of described historical advertisement material for the state value of the last state at described advertisement material, determines that the state of described advertisement material does not change; And
The second determination module, when different with the state value of described historical advertisement material for the state value of the last state at described advertisement material, determines that the state of described advertisement material changes.
9. data processing equipment according to claim 6, is characterized in that, described data processing equipment also comprises:
The 3rd acquiring unit, after the time interval of historical material state storage is recorded as to the time that described last state is corresponding corresponding closing time, obtains query time interval;
Search unit, for utilizing described query time interval, at the advertisement material state of storage, search the interval corresponding state value of described query time, wherein, the advertisement material state of described storage comprises last state and the described historical advertisement material state of described advertisement material; And
Filler cells, for being filled into the interval corresponding state value of the described query time inquiring in described query time interval.
10. data processing equipment according to claim 9, is characterized in that, described in search unit and comprise:
Very first time acquisition module, for obtaining the initial time in described query time interval;
The second time-obtaining module, for obtaining the closing time in described query time interval;
The first judge module, for judge the initial time in described query time interval whether be greater than described storage advertisement material state initial time and be less than advertisement material state closing time of described storage;
The second judge module, for judge described query time interval the advertisement material state that whether is greater than described storage closing time initial time and be less than advertisement material state closing time of described storage; And
The 3rd determination module, for initial time in described query time interval, whether be greater than described storage advertisement material state initial time and be less than advertisement material state closing time of described storage, or the initial time of the advertisement material state that whether is greater than described storage closing time in described query time interval and the advertisement material state that is less than described storage be during closing time, using state value corresponding to the time interval inquiring as the interval corresponding state value of described query time.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310552099.1A CN103559635A (en) | 2013-11-07 | 2013-11-07 | Data processing method and device used for inquiring advertising material status |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310552099.1A CN103559635A (en) | 2013-11-07 | 2013-11-07 | Data processing method and device used for inquiring advertising material status |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103559635A true CN103559635A (en) | 2014-02-05 |
Family
ID=50013875
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310552099.1A Pending CN103559635A (en) | 2013-11-07 | 2013-11-07 | Data processing method and device used for inquiring advertising material status |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103559635A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112204990A (en) * | 2018-12-20 | 2021-01-08 | 海信视像科技股份有限公司 | Receiving apparatus, receiving method, transmitting apparatus, transmitting method, and transmitting/receiving system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20010007097A1 (en) * | 2000-01-04 | 2001-07-05 | Yong-Nam Kim | System and method for recording internet advertisement access history |
| CN1964279A (en) * | 2006-09-25 | 2007-05-16 | 华为技术有限公司 | A method to process network element data |
| CN101067818A (en) * | 2007-06-06 | 2007-11-07 | 中国工商银行股份有限公司 | Data incremental backup and recovery method applied to data bank |
| CN102547409A (en) * | 2011-12-26 | 2012-07-04 | 深圳市同洲视讯传媒有限公司 | Advertisement data interactive system and method |
| CN102591672A (en) * | 2011-01-11 | 2012-07-18 | 酷手机多媒体股份有限公司 | Method and system for updating and broadcasting advertisements |
| CN103200206A (en) * | 2012-01-06 | 2013-07-10 | 腾讯科技（深圳）有限公司 | Advertisement displaying method and advertisement displaying client |
-
2013
- 2013-11-07 CN CN201310552099.1A patent/CN103559635A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20010007097A1 (en) * | 2000-01-04 | 2001-07-05 | Yong-Nam Kim | System and method for recording internet advertisement access history |
| CN1964279A (en) * | 2006-09-25 | 2007-05-16 | 华为技术有限公司 | A method to process network element data |
| CN101067818A (en) * | 2007-06-06 | 2007-11-07 | 中国工商银行股份有限公司 | Data incremental backup and recovery method applied to data bank |
| CN102591672A (en) * | 2011-01-11 | 2012-07-18 | 酷手机多媒体股份有限公司 | Method and system for updating and broadcasting advertisements |
| CN102547409A (en) * | 2011-12-26 | 2012-07-04 | 深圳市同洲视讯传媒有限公司 | Advertisement data interactive system and method |
| CN103200206A (en) * | 2012-01-06 | 2013-07-10 | 腾讯科技（深圳）有限公司 | Advertisement displaying method and advertisement displaying client |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112204990A (en) * | 2018-12-20 | 2021-01-08 | 海信视像科技股份有限公司 | Receiving apparatus, receiving method, transmitting apparatus, transmitting method, and transmitting/receiving system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107038166B (en) | Method and device for inquiring reservable warehouse capacity, reserving and canceling reservation warehousing | |
| CN102129442B (en) | Distributed database system and data accessing method | |
| CN108510311A (en) | A kind of method, apparatus and electronic equipment of determining marketing program | |
| CN102811371A (en) | Method, system and device for recommending intelligent television application program | |
| CN104537115A (en) | Method and device for exploring user interests | |
| CN103942712A (en) | Product similarity based e-commerce recommendation system and method thereof | |
| CN103500235A (en) | Multimedia file recommendation method and device | |
| CN103678662A (en) | Application program searching method and device | |
| CN104408640A (en) | Application software recommending method and apparatus | |
| CN103605776A (en) | Method and device for processing data of information database | |
| CN109583921A (en) | Advertising budget acquisition methods, device, storage medium and processor | |
| CN102646097A (en) | Clustering method and device | |
| CN105354193A (en) | Caching method, query method, caching apparatus and query apparatus for database data | |
| CN105022807A (en) | Information recommendation method and apparatus | |
| Lin et al. | Scheduling a bi-criteria flowshop manufacturing cell with sequence-dependent family setup times | |
| AU2024202927A1 (en) | Computer-based data collection, management, and forecasting | |
| CN110069488A (en) | A kind of date storage method, method for reading data and its device | |
| CN105868279A (en) | Application recommendation method and server | |
| CN107622409B (en) | Method and device for predicting vehicle purchasing capacity | |
| CN105162643A (en) | Flow estimation method and device, and calculating equipment | |
| CN108021713A (en) | A kind of method and apparatus of clustering documents | |
| CN103559635A (en) | Data processing method and device used for inquiring advertising material status | |
| CN116228374A (en) | Logistics industry market single data early warning method, device, equipment and storage medium | |
| CN106202302A (en) | Collecting method, Apparatus and system | |
| CN104123307A (en) | Data loading method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | 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: 20140205 |