CN103530413B - Method and device for processing data - Google Patents
Method and device for processing data Download PDFInfo
- Publication number
- CN103530413B CN103530413B CN201310517194.8A CN201310517194A CN103530413B CN 103530413 B CN103530413 B CN 103530413B CN 201310517194 A CN201310517194 A CN 201310517194A CN 103530413 B CN103530413 B CN 103530413B
- Authority
- CN
- China
- Prior art keywords
- time
- parameter
- time parameter
- key
- major key
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 18
- 238000003672 processing method Methods 0.000 claims description 17
- 241000208340 Araliaceae Species 0.000 claims description 6
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 claims description 6
- 235000003140 Panax quinquefolius Nutrition 0.000 claims description 6
- 235000008434 ginseng Nutrition 0.000 claims description 6
- 238000010586 diagram Methods 0.000 description 9
- 238000013500 data storage Methods 0.000 description 6
- PEDCQBHIVMGVHV-UHFFFAOYSA-N Glycerine Chemical compound OCC(O)CO PEDCQBHIVMGVHV-UHFFFAOYSA-N 0.000 description 2
- 230000006855 networking Effects 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 238000012163 sequencing technique Methods 0.000 description 2
- 230000008859 change Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000008439 repair process Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2477—Temporal data queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Probability & Statistics with Applications (AREA)
- Fuzzy Systems (AREA)
- Electric Clocks (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention discloses a method and a device for processing data. The method for processing the data includes acquiring time foreign keys which are key fields for describing first time parameters of internet entities; acquiring time primary keys in preset timetables; searching second time parameters corresponding to the time primary keys according to corresponding relations of the time foreign keys and the time primary keys; storing the second time parameters and the internet entities in database tables. The time primary keys are key fields for describing preset time parameters, and the second time parameters are INT (integer) data of the first time parameters. The method and the device have the advantages that the problem that a large quantity of memory space is required for storing time parameters corresponding to data in database tables in the prior art can be solved, and an effect of saving storage space can be realized.
Description
Technical field
The present invention relates to internet arena, in particular to a kind of data processing method and device.
Background technology
In internet arena, the data processing to the substantial amounts in software system is depended on to corresponding to data mostly
The process of time parameter, in the related, the data storage and its during corresponding time parameter in database table, general storage
The time data of time parameter, for example, when the corresponding time parameter of certain data is on January 10th, 2013, in data base
This substantial amounts of memory headroom of time parameter time needs of on January 10th, 2013 is stored in table.
For the corresponding time parameter of data storage needs substantial amounts of memory headroom in database table in correlation technique
Problem, not yet proposes at present effective solution.
The content of the invention
Present invention is primarily targeted at provide a kind of data processing method and device, to solve correlation technique in data
The corresponding time parameter of data storage needs the problem of substantial amounts of memory headroom in the table of storehouse.
To achieve these goals, according to an aspect of the invention, there is provided a kind of data processing method.The method bag
Include：Acquisition time external key, wherein, time external key is the critical field of the very first time parameter for describing internet entity；Obtain pre-
If the time major key in timetable, wherein, time major key is the critical field for describing Preset Time parameter；By time external key with
The corresponding relation of time major key searches corresponding second time parameter of time major key, wherein, the second time parameter is the very first time
The INT type data of parameter；And store the second time parameter and internet entity in database table.
Further, before time external key is obtained, the method also includes：When whether judge very first time parameter be default
Between time parameter in table, wherein, only in the time parameter in judging very first time parameter for Preset Time table, during acquisition
Between external key.
Further, the second time parameter include time parameter for representing week and/or for represent month when
Between parameter and/or the time parameter for representing festivals or holidays, the time is searched by the corresponding relation of time external key and time major key
Corresponding second time parameter of major key includes：Time major key is searched by time external key and the corresponding relation of time major key corresponding
Week parameter and/or month parameter and/or festivals or holidays parameter.
Further, store before the second time parameter and internet entity in database table, the method also includes：It is logical
Cross time external key and search the INT types coding of internet entity ID with the corresponding relation of time major key；And judge that the second time joined
The INT types coding of number and corresponding networked entity ID of the second time parameter with the presence or absence of in database table, wherein, when judging the
When the INT types coding of two time parameters and corresponding networked entity ID of the second time parameter is present in database table, then do not preserve
Second time parameter and corresponding networked entity ID of the second time parameter INT types coding, when judge the second time parameter and
When the INT types coding of corresponding networked entity ID of the second time parameter is not present in database table, then the second time parameter is preserved
Encode with the INT types of corresponding networked entity ID of the second time parameter.
Further, time external key includes：The very first time external key corresponding with the first internet entity and mutual with second
The second corresponding time external key of networked entity, time major key includes：Very first time major key and the second time major key, its feature exists
In searching corresponding second time parameter of time major key by the time external key and the corresponding relation of time major key includes：It is logical
Cross very first time external key the 3rd time parameter corresponding with the corresponding relation of very first time major key lookup very first time major key；Pass through
Second time external key the 4th time parameter corresponding with the corresponding relation of the second time major key the second time major key of lookup；According to
The size of three time parameters and the 4th time parameter is determining the sequence of the first internet entity and the second internet entity.
To achieve these goals, according to a further aspect in the invention, there is provided a kind of data processing equipment.The device bag
Include：First acquisition unit, for obtaining time external key, wherein, time external key is the very first time parameter for describing internet entity
Critical field；Second acquisition unit, for obtaining Preset Time table in time major key, wherein, time major key is pre- for description
If the critical field of time parameter；First searching unit, during for being searched with the corresponding relation of time major key by time external key
Between corresponding second time parameter of major key, wherein, the second time parameter for very first time parameter INT type data；And storage
Unit, for storing the second time parameter and internet entity in database table.
Further, the data processing equipment also includes：First judging unit, for judging before time external key is obtained
Whether very first time parameter is the time parameter in Preset Time table, wherein, first acquisition unit is additionally operable to only judging
When one time parameter is the time parameter in Preset Time table, time external key is obtained.
Further, the second time parameter include time parameter for representing week and/or for represent month when
Between parameter and/or the time parameter for representing festivals or holidays, the first searching unit is additionally operable to by the time external key and time
The corresponding relation of major key searches the corresponding week parameter of time major key and/or month parameter and/or festivals or holidays parameter.
Further, the data processing equipment also includes：Second searching unit, during for storing second in database table
Between before parameter and internet entity, the INT of internet entity ID is searched by the corresponding relation of time external key and time major key
Type is encoded；Second judging unit, for judging the INT types of the second time parameter and corresponding networked entity ID of the second time parameter
Coding whether there is in database table, wherein, memory element is additionally operable to work as judges the second time parameter and the second time parameter
When the INT types coding of corresponding networked entity ID is present in database table, then the second time parameter and the second time ginseng are not preserved
The INT types coding of corresponding networked entities ID of number, when judging that the second time parameter and the corresponding networking of the second time parameter are real
When the INT types coding of body ID is not present in database table, then the second time parameter and the corresponding networking of the second time parameter are preserved
The INT types coding of entity ID.
Further, time external key includes：The very first time external key corresponding with the first internet entity and mutual with second
The second corresponding time external key of networked entity, time major key includes：Very first time major key and the second time major key, first searches
Unit also includes：First searching modul, for searching first with the corresponding relation of very first time major key by very first time external key
Corresponding 3rd time parameter of time major key；Second searching modul, for by the second time external key and the second time major key
Corresponding relation searches corresponding 4th time parameter of the second time major key；Determining module, for according to the 3rd time parameter and
The size of four time parameters is determining the sequence of the first internet entity and the second internet entity.
By the present invention, using acquisition time external key, wherein, time external key is the very first time ginseng for describing internet entity
Several critical fielies；The time major key in Preset Time table is obtained, wherein, time major key is the key for describing Preset Time parameter
Field；Corresponding second time parameter of time major key is searched by time external key and the corresponding relation of time major key, wherein, second
Time parameter is the integer of very first time parameter（Integer, abbreviation INT）Type data；And store second in database table
Time parameter and internet entity, solve in correlation technique the corresponding time parameter of the data storage in database table need it is big
The problem of the memory headroom of amount, and then reached the effect for saving memory space.
Description of the drawings
The accompanying drawing for constituting the part of the application is used for providing a further understanding of the present invention, the schematic reality of the present invention
Apply example and its illustrate, for explaining the present invention, not constituting inappropriate limitation of the present invention.In the accompanying drawings：
Fig. 1 is the schematic diagram of data processing equipment according to a first embodiment of the present invention；
Fig. 2 is the schematic diagram that the index of Internet advertising of the invention shows situation；
Fig. 3 is the schematic diagram of data processing equipment according to a second embodiment of the present invention；
Fig. 4 is the schematic diagram of data processing equipment according to a third embodiment of the present invention；
Fig. 5 is the schematic diagram of data processing equipment according to a fourth embodiment of the present invention；
Fig. 6 is the flow chart of data processing method according to a first embodiment of the present invention；And
Fig. 7 is the flow chart of data processing method according to a second embodiment of the present invention.
Specific embodiment
It should be noted that in the case where not conflicting, the feature in embodiment and embodiment in the application can phase
Mutually combination.Below with reference to the accompanying drawings and in conjunction with the embodiments describing the present invention in detail.
In order that those skilled in the art is better understood from the present invention program, below in conjunction with the embodiment of the present invention
Accompanying drawing, to the embodiment of the present invention in be clearly and completely described, it is clear that described embodiment be only the present invention one
Partial embodiment, rather than the embodiment of whole.Based on the embodiment in the present invention, do not have in those of ordinary skill in the art
The every other embodiment obtained under the premise of creative work is made, should all belong to protection scope of the present invention.
It should be noted that description and claims of this specification and the term " first " in above-mentioned accompanying drawing, "
Two " it is etc. the object for distinguishing similar, without for describing specific order or precedence.It should be appreciated that so using
Data can exchange in the appropriate case, so as to embodiments of the invention described herein can with except illustrating here or
Order beyond those of description is implemented.Additionally, term " comprising " and " having " and their any deformation, it is intended that cover
Lid is non-exclusive to be included.
A kind of embodiments in accordance with the present invention, there is provided data processing equipment, the data processing equipment is used in data base
With INT type time data memory parameters during data storage in table.
Fig. 1 is the schematic diagram of data processing equipment according to a first embodiment of the present invention.
As shown in figure 1, the device includes：First acquisition unit 10, second acquisition unit 20, the first searching unit 30 and deposit
Storage unit 40.
First acquisition unit 10 is used to obtain time external key, wherein, when time external key is to describe the first of internet entity
Between parameter critical field, very first time parameter stores in database table with the date data type of date.Need explanation
It is that in embodiments of the present invention, internet entity can include one or more, each internet entity can include one again
Individual or multiple very first time parameters, and each unique time external key of very first time parameter correspondence, whole very first time parameters
Can be stored in timetable with the corresponding time external key of whole very first time parameters, and the description field of different time external keys
Different, so, first acquisition unit 10 can be used for obtaining time external key from timetable.In addition, internet entity can
Think Internet advertising.
For example, the cost form of an Internet advertising includes the time（It is accurate to day）, Internet advertising, click and consumption
Deng index parameter, when Internet advertising includes Internet advertising A and Internet advertising B, the cost report was monitored in one month
Table, then can obtain the index parameters such as the corresponding click of one or more time parameter and consumption of Internet advertising A, together
When, it is also possible to the index parameters such as the corresponding click of one or more time parameter and consumption of Internet advertising B are obtained, here
Time parameter be very first time parameter, so, each time parameter one time external key of correspondence of the cost form, each
Time external key points to its corresponding time parameter, and by time parameter other index letters of corresponding internet entity can be corresponded to
Breath.
Second acquisition unit 20 is used to obtain the time major key in Preset Time table, wherein, time major key is default for description
The critical field of time parameter.It should be noted that in embodiments of the present invention, one can be stored in Preset Time table and is preset
Time period, for example, in Preset Time table store preset time period can be 2000-1-1 to 2055-12-30, when this is default
Between each unique time major key of time parameter correspondence in section, and the time parameter in the time period can be as accurate as day.
When the corresponding Preset Time parameter of time major key is equal with the corresponding very first time parameter of time external key, the time major key correspondence
Critical field it is identical with the corresponding critical field of time external key, so, the corresponding time can be found by time external key
Major key.For example, when very first time parameter be 2000-1-1 when, then the corresponding critical field of time external key of very first time parameter with
The corresponding critical field of time major key of 2000-1-1 is identical in Preset Time table, so, by the time external key of 2000-1-1
The time major key of 2000-1-1 in Preset Time table can be found.
First searching unit 30 is used for corresponding by time external key and the corresponding relation of time major key lookup time major key
Second time parameter, wherein, the second time parameter is the INT type data of very first time parameter.In embodiments of the present invention, the time
The corresponding relation of external key and time major key can be the corresponding critical field of time external key and the corresponding critical field of time major key
Corresponding relation, when the critical field of certain time external key is identical with the critical field of certain time major key, the time external key
Corresponding with the time major key, otherwise the time external key and the time major key are not corresponded to.For example, because outside the time of 2000-1-1
Key is identical with the critical field of the time major key of 2000-1-1 in Preset Time table, so the time external key and the time major key phase
Correspondence, so, the first searching unit 30 can find the 2000-1- in Preset Time table by the time external key of 2000-1-1
1 time major key, further, by the time major key of 2000-1-1 the of the corresponding INT types of 2000-1-1 can be found
Two time parameters, for example, when the preset time period stored in Preset Time table is 2000-1-1 to 2055-12-30, it is assumed that
Second time parameter of the corresponding INT types of 2000-1-1 is 1, and according to the sequencing corresponding time corresponding INT of time
Second time parameter of type increases successively 1.
Preferably, in embodiments of the present invention, the second time parameter can include for represent week time parameter and/
Or for representing the time parameter and/or time parameter for representing festivals or holidays in month, the first searching unit 30 is additionally operable to lead to
Cross time external key week parameter corresponding with the corresponding relation of time major key lookup time major key and/or month parameter and/or section
Holiday parameter, wherein, week parameter, month parameter and festivals or holidays parameter corresponding time be very first time parameter.For example,
One searching unit 30 is additionally operable to find 2000-1-1 by time external key and the corresponding relation of time major key and what day is, is several
Month and whether be festivals or holidays etc..
Memory element 40 is used to store the second time parameter and internet entity in database table.In the embodiment of the present invention
In, memory element 40 is used in database table according to corresponding other index letters of the second time parameter storage internet entity
Breath.For example, memory element 40 store internet entity when can by the second of the corresponding 2000-1-1 of the internet entity when
Between parameter 1 store in database table, rather than store 2000-1-1 this date type data.Preferably, memory element 40
It is additionally operable to store the second time parameter for representing week, month and festivals or holidays, so, user can be by inquiring about database table
Solve week information, month information and holiday information and its interconnection of the very first time parameter of internet entity and internet entity
Other indication informations of network entity etc..
For example, the cost form of an Internet advertising includes Internet advertising ID, time, clicks on, represents number of times and cost
Deng indication information, wherein, the time here is very first time parameter, and very first time parameter is stored in timetable, leads to
The embodiment of the present invention is crossed, the time external key of very first time parameter can be obtained by first acquisition unit 10, and can be by second
Acquiring unit 20 obtains the time major key in Preset Time table and by the first searching unit 30 by time external key and time master
The corresponding relation of key searches corresponding second time parameter of time major key, wherein, the second time parameter includes week, month and section
Holiday etc., last memory element 40 the second time parameter and Internet advertising can be stored in database table and the Internet is wide
Other indication informations accused.So, user can obtain the information shown in Fig. 2 by inquiry database table, it is particularly possible to obtain
Whether certain time be day Saturday and the Internet advertising in the click situation of day Saturday and represent situation, wherein, transverse axis is
Time shafts, the longitudinal axis on the left side represents number of clicks, and the longitudinal axis on the right is represented and represents number of times, and the broken line of top was represented in each time
Click situation, the broken line of lower section represents the situation that represents in each time, and the stain on two broken lines represents day Saturday.
So, by can be found using the first searching unit 30 internet entity the day moon type very first time parameter
Second time parameter of corresponding INT types, and it is right with its by storing the second time parameter of INT types using memory element 40
The internet entity answered, has reached the effect for saving memory space.
Fig. 3 is the schematic diagram of data processing equipment according to a second embodiment of the present invention.
As shown in figure 3, the embodiment can be used as the preferred implementation of embodiment illustrated in fig. 1, the data of the embodiment
Processing meanss are except the first acquisition unit 10 including first embodiment, second acquisition unit 20, the first searching unit 30 and deposit
Outside storage unit 40, also including the first judging unit 50.
The effect and first of first acquisition unit 10, second acquisition unit 20, the first searching unit 30 and memory element 40
It is identical in embodiment, will not be described here.
First judging unit 50 is used to judge whether very first time parameter is Preset Time table before time external key is obtained
In time parameter, wherein, first acquisition unit be additionally operable to only judge very first time parameter in Preset Time table when
Between parameter when, obtain time external key.For example, it is assumed that the time parameter in Preset Time table is 2000-1-1 to 2055-12-30,
When very first time parameter is 1999-10-1, the first judging unit 50 may determine that 1999-10-1 is not in Preset Time table
Time parameter, i.e. first acquisition unit do not obtain time external key；When very first time parameter is 2013-10-1, first judges
Unit 50 may determine that 2013-10-1 is the time parameter in Preset Time table, i.e., first acquisition unit obtains time external key.
Fig. 4 is the schematic diagram of data processing equipment according to a third embodiment of the present invention.
As shown in figure 4, the embodiment can be used as the preferred implementation of embodiment illustrated in fig. 1, the data of the embodiment
Processing meanss are except the first acquisition unit 10 including first embodiment, second acquisition unit 20, the first searching unit 30 and deposit
Outside storage unit 40, also including the second searching unit 60 and the second judging unit 70.
Phase in first acquisition unit 10, the effect of the searching unit 30 of second acquisition unit 20 and first and first embodiment
Together, will not be described here.
Second searching unit 60 is used to store in database table before the second time parameter and internet entity, by when
Between the corresponding relation of external key and time major key search internet entity identity（Identity, abbreviation ID）INT types coding.
For example, ID codings respectively 1,2,3 ... ... the N of multiple internet entities can be preset.
Second judging unit 70 is used to judge the INT of the second time parameter and corresponding networked entity ID of the second time parameter
Type coding whether there is in database table, wherein, memory element 40 is additionally operable to work as judges the second time parameter and the second time
When the INT types coding of corresponding networked entity ID of parameter is present in database table, then when not preserving the second time parameter and second
Between corresponding networked entity ID of parameter INT types coding, when judging that the second time parameter and the second time parameter are corresponding
When the INT types coding of network entity ID is not present in database table, then preserves the second time parameter and the second time parameter is corresponding
The INT types coding of networked entity ID.
So, in embodiments of the present invention, replace preserving the name of networked entity with the INT types coding for preserving networked entity ID
Claim, reached the effect for saving memory space.
Fig. 5 is the schematic diagram of data processing equipment according to a fourth embodiment of the present invention.
As shown in figure 5, the embodiment can be used as the preferred implementation of embodiment illustrated in fig. 1, the data of the embodiment
Processing meanss include that first acquisition unit 10, second acquisition unit 20, the first searching unit 30 and the storage of first embodiment is single
Unit 40, wherein, the first searching unit 30 includes the second searching unit 60 and the second judging unit 70.
The effect of first acquisition unit 10 and second acquisition unit 20 with it is identical in first embodiment, here is no longer gone to live in the household of one's in-laws on getting married
State.
When first searching modul 301 is used to search first with the corresponding relation of very first time major key by very first time external key
Between corresponding 3rd time parameter of major key.Second searching modul 302 is used for by the second time external key and the second time major key
Corresponding relation searches corresponding 4th time parameter of the second time major key.Wherein, time external key includes：With the first internet entity
Corresponding very first time external key and the second time external key corresponding with the second internet entity, time major key includes：First
Time major key and the second time major key, the 3rd time parameter and the 4th time parameter are date type data.Determining module 303
For according to the size of the 3rd time parameter and the 4th time parameter determining the first internet entity and the second internet entity
Sequence.For example, the 3rd time parameter that the first searching modul 301 finds is 20, the second searching modul 302 find the
Four time parameters are 21, it is determined that module 303 can determine the first internet entity and the second internet entity in database table
Middle to arrange 20 and 21 respectively, the first internet entity and the second internet entity are adjacent, and the first internet entity comes the
Before two internet entities.
Memory element 40 is additionally operable to according to the 3rd time parameter of the first internet entity and the second internet entity
Four time parameters are stored in order in database table.
Preferably, in embodiments of the present invention, it is also possible to by the first searching modul 301 find the 3rd time parameter and
Second searching modul 302 finds the 4th time parameter to obtain corresponding first interconnection of the 3rd time parameter from memory element 40
Network entity and corresponding second internet entity of the 4th time parameter, as such, it is possible to the internet entity of user's needs is filtered out,
And show the internet entity to user.
A kind of embodiments in accordance with the present invention, there is provided data processing method, the data processing method is used in data base
With INT type time data memory parameters during data storage in table.The data processing method may operate in computer-processing equipment
On.It should be noted that the data processing method that the embodiment of the present invention is provided can pass through at the data of the embodiment of the present invention
Manage device to perform, the data processing equipment of the embodiment of the present invention can be used for performing the file storage side of the embodiment of the present invention
Method.
Fig. 6 is the flow chart of data processing method according to a first embodiment of the present invention.
As shown in fig. 6, the method includes steps S101 to step S107：
Step S101, obtains time external key.
Time external key is the critical field of the very first time parameter for describing internet entity, and the very first time, parameter was in data base
Stored with the date data type of date in table.It should be noted that in embodiments of the present invention, internet entity can include
One or more, each internet entity can include one or more very first time parameter, and each very first time again
The unique time external key of parameter correspondence, All Time external key can be stored in time foreign-key table, and different time external keys
Description field is different.In addition, internet entity can be Internet advertising.
For example, the cost form of an Internet advertising includes the time（It is accurate to day）, Internet advertising, click and consumption
Deng index parameter, when Internet advertising includes Internet advertising A and Internet advertising B, the cost report was monitored in one month
Table, then can obtain the index parameters such as the corresponding click of one or more time parameter and consumption of Internet advertising A, together
When, it is also possible to the index parameters such as the corresponding click of one or more time parameter and consumption of Internet advertising B are obtained, here
Time parameter be very first time parameter, so, each time parameter one time external key of correspondence of the cost form, each
Time external key points to its corresponding time parameter, and by time parameter other index letters of corresponding internet entity can be corresponded to
Breath.
Step S103, obtains the time major key in Preset Time table.
Time major key is the critical field for describing Preset Time parameter.It should be noted that in embodiments of the present invention, in advance
If can store a default time period in timetable, for example, the preset time period stored in Preset Time table can be
2000-1-1 to 2055-12-30, the unique time major key of each time parameter correspondence in the preset time period, and this when
Between time parameter in section can be as accurate as day.When the corresponding Preset Time parameter corresponding with time external key first of time major key
When time parameter is equal, the corresponding critical field of time major key is identical with the corresponding critical field of time external key, so, leads to
The time external key of mistake can find corresponding time major key.For example, when very first time parameter be 2000-1-1 when, then the very first time ginseng
Several corresponding critical fielies of time external key is identical with the corresponding critical field of time major key of 2000-1-1 in Preset Time table,
So, the time major key of 2000-1-1 in Preset Time table can be found by the time external key of 2000-1-1.
Step S105, searches the time major key corresponding by the time external key and the corresponding relation of the time major key
The second time parameter.
Second time parameter is the INT type data of very first time parameter.In embodiments of the present invention, time external key and time
The corresponding relation of major key can be the corresponding relation of the corresponding critical field of time external key and the corresponding critical field of time major key,
When the critical field of certain time external key is identical with the critical field of certain time major key, the time external key and the time major key
Corresponding, otherwise the time external key and the time major key are not corresponded to.For example, because the time external key and Preset Time of 2000-1-1
The critical field of the time major key of 2000-1-1 is identical in table, so the time external key is corresponding with the time major key, so, can
To find the time major key of the 2000-1-1 in Preset Time table by the time external key of 2000-1-1, further, pass through
The time major key of 2000-1-1 can find the second time parameter of the corresponding INT types of 2000-1-1, for example, work as Preset Time
In table store preset time period be 2000-1-1 to 2055-12-30 when, it is assumed that the corresponding INT types of 2000-1-1 second when
Between parameter be 1, and the second time parameter according to the sequencing corresponding time corresponding INT types of time increases successively 1.
Preferably, in embodiments of the present invention, the second time parameter can include for represent week time parameter and/
Or for representing the time parameter and/or time parameter for representing festivals or holidays in month, the first searching unit 30 is additionally operable to lead to
Cross time external key week parameter corresponding with the corresponding relation of time major key lookup time major key and/or month parameter and/or section
Holiday parameter, wherein, week parameter, month parameter and festivals or holidays parameter corresponding time be very first time parameter.For example,
One searching unit 30 is additionally operable to find 2000-1-1 by time external key and the corresponding relation of time major key and what day is, is several
Month and whether be festivals or holidays etc..
Step S107, stores second time parameter and the internet entity in database table.
For example, can be by second time parameter of the corresponding 2000-1-1 of the internet entity when internet entity is stored
1 storage stores this date type data of 2000-1-1 in database table.
So, by find internet entity the day moon type the corresponding INT types of very first time parameter the second time
Parameter, and by storing second time parameter and its corresponding internet entity of INT types, reached and saved memory space
Effect.
In embodiments of the present invention, before step S101, the data method also includes：Whether judge very first time parameter
For the time parameter in Preset Time table.
In embodiments of the present invention, only obtain in the time parameter in judging very first time parameter for Preset Time table
Take time external key.For example, it is assumed that the time parameter in Preset Time table is 2000-1-1 to 2055-12-30, when very first time ginseng
When number is 1999-10-1, it can be determined that it is not the time parameter in Preset Time table, i.e. first acquisition unit to go out 1999-10-1
Time external key is not obtained；When very first time parameter is 2013-10-1, it can be determined that it is in Preset Time table to go out 2013-10-1
Time parameter, i.e., first acquisition unit obtain time external key.
In embodiments of the present invention, before step S107, the data method also includes：By time external key and time master
The corresponding relation of key searches the INT types coding of internet entity ID and judges that the second time parameter and the second time parameter are corresponding
The INT types coding of networked entity ID is with the presence or absence of in database table.For example, the ID codings point of multiple internet entities can be preset
Wei 1,2,3 ... ... N.
So, step S107 also includes that the second time parameter and corresponding networked entity ID of the second time parameter ought be judged
INT types coding when existing in database table, then do not preserve the second time parameter and the corresponding networked entity of the second time parameter
The INT types coding of ID, when the INT types for judging the second time parameter and corresponding networked entity ID of the second time parameter are encoded not
When existing in database table, then the INT types coding of the second time parameter and corresponding networked entity ID of the second time parameter is preserved.
So, in embodiments of the present invention, replace preserving the name of networked entity with the INT types coding for preserving networked entity ID
Claim, reached the effect for saving memory space.
Fig. 7 is the flow chart of data processing method according to a second embodiment of the present invention.
As shown in fig. 7, the data processing method includes steps S201 to step S206, the embodiment can conduct
The preferred implementation of embodiment illustrated in fig. 6.
Step S201 and step S202, with S101 the step of embodiment illustrated in fig. 6 and step S102, will not be described here.
It should be noted that time external key includes：The very first time external key corresponding with the first internet entity and with
The second corresponding time external key of two internet entities.Time major key includes：Very first time major key and the second time major key, the 3rd
Time parameter and the 4th time parameter are date type data.
Step S203, searches very first time major key corresponding by very first time external key and the corresponding relation of very first time major key
The 3rd time parameter.
Step S204, searches the second time major key corresponding by the second time external key and the corresponding relation of the second time major key
The 4th time parameter.
Step S205, according to the size of the 3rd time parameter and the 4th time parameter determining the first internet entity and
The sequence of two internet entities.
For example, when the 3rd time parameter for finding be 20 and the 4th time parameter be 21, then can determine the first interconnection
Network entity and the second internet entity arrange respectively 20 and 21, the first internet entity and the second the Internet reality in database table
Body phase is adjacent, and the first internet entity is come before the second internet entity.Preferably, in embodiments of the present invention,
Can be corresponding to obtain the 3rd time parameter from memory element 40 by finding the 3rd time parameter and the 4th time parameter
First internet entity and corresponding second internet entity of the 4th time parameter, as such, it is possible to filter out the mutual of user's needs
Networked entity, and show the internet entity to user.
Step S206, stores the second time parameter and internet entity in database table.
The second time parameter and internet entity are stored in database table can be included according to the first internet entity
4th time parameter of the 3rd time parameter and the second internet entity stores in order the second time parameter in database table
And internet entity.
It should be noted that can be in such as one group computer executable instructions the step of the flow process of accompanying drawing is illustrated
Perform in computer system, and, although show logical order in flow charts, but in some cases, can be with not
The order being same as herein performs shown or described step.
Obviously, those skilled in the art should be understood that above-mentioned each module of the invention or each step can be with general
Computing device realizing, they can be concentrated on single computing device, or are distributed in multiple computing devices and are constituted
Network on, alternatively, they can be realized with the executable program code of computing device, it is thus possible to they are stored
Performed by computing device in the storage device, or they be fabricated to respectively each integrated circuit modules, or by they
In multiple modules or step be fabricated to single integrated circuit module to realize.So, the present invention is not restricted to any specific
Hardware and software is combined.
The preferred embodiments of the present invention are the foregoing is only, the present invention is not limited to, for the skill of this area
For art personnel, the present invention can have various modifications and variations.It is all within the spirit and principles in the present invention, made any repair
Change, equivalent, improvement etc., should be included within the scope of the present invention.
Claims (8)
1. a kind of data processing method, it is characterised in that include：
Acquisition time external key, wherein, the time external key is the critical field of the very first time parameter for describing internet entity；
The time major key in Preset Time table is obtained, wherein, the time major key is the critical field for describing Preset Time parameter；
The corresponding second time ginseng of the time major key is searched by the time external key and the corresponding relation of the time major key
Number, wherein, second time parameter is the INT type data of the very first time parameter；And
Second time parameter and the internet entity are stored in database table；
Wherein, before second time parameter and the internet entity are stored in database table, methods described also includes：
The INT types coding of internet entity ID is searched by the time external key and the corresponding relation of the time major key；And
Whether judge the INT types coding of second time parameter and corresponding networked entity ID of second time parameter
In there is the database table,
Wherein, as the INT for judging second time parameter and corresponding networked entity ID of second time parameter
When type coding is present in the database table, then second time parameter and the corresponding institute of second time parameter are not preserved
The INT types coding of networked entity ID is stated, when judging that second time parameter and second time parameter are corresponding described
When the INT types coding of networked entity ID is not present in the database table, then second time parameter and described second are preserved
The INT types coding of corresponding networked entity ID of time parameter.
2. data processing method according to claim 1, it is characterised in that described before the acquisition time external key
Method also includes：
Judge that whether the very first time parameter is the time parameter in the Preset Time table,
Wherein, only when the time parameter during the very first time parameter is the Preset Time table is judged, when obtaining described
Between external key.
3. data processing method according to claim 1, it is characterised in that second time parameter is included for representing
The time parameter in week and/or time parameter and/or time parameter for representing festivals or holidays for representing month, by institute
Stating time external key the second time parameter corresponding with the corresponding relation of the time major key lookup time major key includes：Pass through
Time external key week parameter corresponding with the corresponding relation of the time major key lookup time major key and/or month ginseng
Number and/or festivals or holidays parameter.
4. data processing method according to claim 1, the time external key includes：It is corresponding with the first internet entity
Very first time external key and the second time external key corresponding with the second internet entity, the time major key includes：When first
Between major key and the second time major key, it is characterised in that the corresponding relation by the time external key and the time major key
Searching corresponding second time parameter of the time major key includes：
The very first time major key is searched by the very first time external key and the corresponding relation of the very first time major key corresponding
The 3rd time parameter；
The second time major key is searched by the second time external key and the corresponding relation of the second time major key corresponding
The 4th time parameter；
According to the size of the 3rd time parameter and the 4th time parameter determining first internet entity and institute
State the sequence of the second internet entity.
5. a kind of data processing equipment, it is characterised in that include：
First acquisition unit, for obtaining time external key, wherein, the time external key is the very first time for describing internet entity
The critical field of parameter；
Second acquisition unit, for obtaining Preset Time table in time major key, wherein, the time major key for description it is default when
Between parameter critical field；
First searching unit, for searching the time major key with the corresponding relation of the time major key by the time external key
Corresponding second time parameter, wherein, second time parameter is the INT type data of the very first time parameter；And
Memory element, for storing second time parameter and the internet entity in database table；
Second searching unit, for storing second time parameter and the internet entity in database table before, lead to
Cross the time external key and search the INT types coding of internet entity ID with the corresponding relation of the time major key；
Second judging unit, for judging second time parameter and the corresponding networked entity of second time parameter
The INT types coding of ID whether there is in the database table,
Wherein, the memory element is additionally operable to work as and judges second time parameter and the corresponding institute of second time parameter
The INT types coding of networked entity ID is stated when existing in the database table, does not then preserve second time parameter and described the
The INT types coding of corresponding networked entity ID of two time parameters, when judging second time parameter and described second
When the INT types coding of corresponding networked entity ID of time parameter is not present in the database table, then described second is preserved
The INT types coding of time parameter and corresponding networked entity ID of second time parameter.
6. data processing equipment according to claim 5, it is characterised in that also include：
First judging unit, for judging whether the very first time parameter is described default before the acquisition time external key
Time parameter in timetable,
Wherein, the first acquisition unit is additionally operable to only in judging that the very first time parameter is the Preset Time table
During time parameter, the time external key is obtained.
7. data processing equipment according to claim 5, it is characterised in that second time parameter is included for representing
The time parameter in week and/or time parameter and/or time parameter for representing festivals or holidays for representing month, described
One searching unit is additionally operable to corresponding by the time external key and the corresponding relation of the time major key lookup time major key
Week parameter and/or month parameter and/or festivals or holidays parameter.
8. data processing equipment according to claim 5, it is characterised in that the time external key includes：With the first interconnection
The corresponding very first time external key of network entity and the second time external key corresponding with the second internet entity, the time major key
Including：Very first time major key and the second time major key, the first searching unit also includes：
First searching modul, it is described for being searched by the very first time external key and the corresponding relation of the very first time major key
Corresponding 3rd time parameter of very first time major key；
Second searching modul, it is described for being searched by the second time external key and the corresponding relation of the second time major key
Corresponding 4th time parameter of second time major key；
Determining module, for according to the size of the 3rd time parameter and the 4th time parameter determining that described first is mutual
The sequence of networked entity and second internet entity.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310517194.8A CN103530413B (en) | 2013-10-28 | 2013-10-28 | Method and device for processing data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310517194.8A CN103530413B (en) | 2013-10-28 | 2013-10-28 | Method and device for processing data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103530413A CN103530413A (en) | 2014-01-22 |
| CN103530413B true CN103530413B (en) | 2017-05-10 |
Family
ID=49932422
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310517194.8A Active CN103530413B (en) | 2013-10-28 | 2013-10-28 | Method and device for processing data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103530413B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104463627B (en) * | 2014-12-05 | 2017-12-19 | 北京国双科技有限公司 | Data processing method and device |
| CN105095522B (en) * | 2015-09-22 | 2018-09-25 | 南开大学 | Relation table set external key recognition methods based on nearest neighbor search |
| CN106021369A (en) * | 2016-05-11 | 2016-10-12 | 上海佳依佳信息科技有限公司 | Method and equipment for data change management |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101197876A (en) * | 2006-12-06 | 2008-06-11 | 中兴通讯股份有限公司 | Method and system for multi-dimensional analysis of message service data |
| CN101452450A (en) * | 2007-11-30 | 2009-06-10 | 上海市电力公司 | Multiple source data conversion service method and apparatus thereof |
| CN102486775A (en) * | 2010-12-01 | 2012-06-06 | 金蝶软件（中国）有限公司 | Method and device for querying business data |
| CN102867023A (en) * | 2012-08-15 | 2013-01-09 | 北京地拓科技发展有限公司 | Method for storing and reading grid data and device |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8046557B2 (en) * | 2005-12-05 | 2011-10-25 | Intelitrac Inc. | Apparatus and method for on-demand in-memory database management platform |
-
2013
- 2013-10-28 CN CN201310517194.8A patent/CN103530413B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101197876A (en) * | 2006-12-06 | 2008-06-11 | 中兴通讯股份有限公司 | Method and system for multi-dimensional analysis of message service data |
| CN101452450A (en) * | 2007-11-30 | 2009-06-10 | 上海市电力公司 | Multiple source data conversion service method and apparatus thereof |
| CN102486775A (en) * | 2010-12-01 | 2012-06-06 | 金蝶软件（中国）有限公司 | Method and device for querying business data |
| CN102867023A (en) * | 2012-08-15 | 2013-01-09 | 北京地拓科技发展有限公司 | Method for storing and reading grid data and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103530413A (en) | 2014-01-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104504077B (en) | The statistical method and device of web page access data | |
| CN104391951B (en) | The loading method and device of webpage thermodynamic | |
| CN108769111A (en) | A kind of server connection method, computer readable storage medium and terminal device | |
| CN105335409A (en) | Target user determination method and device and network server | |
| CN110276060B (en) | Data processing method and device | |
| CN105517104B (en) | Terminal establishes the method and terminal of network connection by APN | |
| CN103530413B (en) | Method and device for processing data | |
| CN109408522A (en) | A kind of update method and device of user characteristic data | |
| CN108153731B (en) | Uncommon word processing method calculates equipment and computer storage medium | |
| CN110245128A (en) | Method for building up and device, storage medium, the electronic device of meta-model | |
| CN104408189A (en) | Keyword ranking display method and device | |
| CN105550220B (en) | A kind of method and device of the access of heterogeneous system | |
| CN107133339A (en) | Circuit query method and apparatus and storage medium, processor | |
| CN107070932A (en) | The anonymous methods for preventing label neighbours from attacking in community network dynamic publishing | |
| CN106897198A (en) | A kind of processing method and processing device of daily record data | |
| US20210064660A1 (en) | Graph search using index vertices | |
| CN110134867A (en) | Corporation information query method and Related product | |
| CN114491085B (en) | Graph data storage method and distributed graph data calculation method | |
| CA2881329C (en) | Method and device for grouping contacts in social network | |
| CN106649374A (en) | Navigation tag ordering method and device | |
| CN106776657A (en) | A kind of domain name search method and equipment | |
| CN105808591A (en) | Flow rate display method and device | |
| CN108965578A (en) | Information-pushing method and device | |
| CN104408138B (en) | Data search method and device | |
| CN107169044A (en) | A kind of city talent resource integrated management method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: Parallel processed data prcessing method and apparatus thereof Effective date of registration: 20190531 Granted publication date: 20170510 Pledgee: Shenzhen Black Horse World Investment Consulting Co.,Ltd. Pledgor: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. Registration number: 2019990000503 |
|
| PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
| CP02 | Change in the address of a patent holder |
Address after: 100083 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing Patentee after: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. Address before: 100086 Beijing city Haidian District Shuangyushu Area No. 76 Zhichun Road cuigongfandian 8 layer A Patentee before: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. |
|
| CP02 | Change in the address of a patent holder | ||
| PP01 | Preservation of patent right |
Effective date of registration: 20240604 Granted publication date: 20170510 |
|
| PP01 | Preservation of patent right |