CN108255861A - The inquiry processing method and device of a kind of ad data - Google Patents
The inquiry processing method and device of a kind of ad data Download PDFInfo
- Publication number
- CN108255861A CN108255861A CN201611247041.6A CN201611247041A CN108255861A CN 108255861 A CN108255861 A CN 108255861A CN 201611247041 A CN201611247041 A CN 201611247041A CN 108255861 A CN108255861 A CN 108255861A
- Authority
- CN
- China
- Prior art keywords
- data
- checked
- tables
- advertisement
- factual
- 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
- 238000003672 processing method Methods 0.000 title claims abstract description 10
- 238000000034 method Methods 0.000 claims abstract description 50
- 238000012545 processing Methods 0.000 claims description 10
- 235000013399 edible fruits Nutrition 0.000 claims description 2
- 230000004044 response Effects 0.000 description 18
- 230000008901 benefit Effects 0.000 description 5
- 230000008569 process Effects 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 4
- 238000004590 computer program Methods 0.000 description 2
- 230000004888 barrier function Effects 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000001035 drying Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000000977 initiatory effect Effects 0.000 description 1
- 238000012423 maintenance Methods 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
-
- 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/242—Query formulation
- G06F16/2433—Query languages
-
- 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/2457—Query processing with adaptation to user needs
Abstract
The invention discloses the inquiry processing methods and device of a kind of ad data.Wherein method includes:Multiple tables of data are set, including:One or more is for the fact that store advertisement factual data table and/or the dimension table of one or more dimensional informations for being used to store advertisement factual data;Obtain ad data inquiry instruction input by user;The ad data inquiry instruction is parsed, determines one or more tables of data to be checked, is the query statement of tables of data generating structure to be checked;Corresponding tables of data is inquired according to the query statement of the structuring of generation, obtains query result;The query result is showed into user.The technical solution can automatically generate the query sentence of database of regular price-line advertising business personnel structuring heavy in hand, regular price-line advertising business personnel is allowd just to obtain corresponding query result by inputting simple ad data inquiry instruction, accuracy and efficiency suffer from good guarantee.
Description
Technical field
The present invention relates to technical field of data processing, and in particular to the inquiry processing method and device of a kind of ad data.
Background technology
Web advertisement is the important revenue source of website operator, and website may provide advertising display clothes for multiple advertisers
Business, and take in often closely bound up with displaying, the click of advertisement etc., it is therefore desirable to these data informations are collected as advertisement
Data are preserved.The numerous and disorderly, various of ad data causes the storage of ad data and inquiry that can not all pass through general service people
Member carries out simple realization, generally requires that special data processing personnel is set to be handled, results in business personnel in this way and wish
When ad data is checked in prestige, elder generation is needed to carry out communication early period with data processing personnel, obtain profession, structuring data query
Sentence, then to being inquired in corresponding database, not only less efficient, also easily error.
Invention content
In view of the above problems, it is proposed that the present invention overcomes the above problem in order to provide one kind or solves at least partly
State the inquiry processing method and device of the ad data of problem.
One side according to the present invention provides a kind of inquiry processing method of ad data, including:
Multiple tables of data are set, including:One or more is for the fact that store advertisement factual data table and/or one
Or the dimension table of multiple dimensional informations for being used to store advertisement factual data;
Obtain ad data inquiry instruction input by user;
The ad data inquiry instruction is parsed, determines one or more tables of data to be checked, is to be checked
The query statement of tables of data generating structure;
Corresponding tables of data is inquired according to the query statement of the structuring of generation, obtains query result;
The query result is showed into user.
Optionally, the advertisement factual data includes at least one of following:
Advertising display data, ad click data, Advertising consumption data.
Optionally, the ad data inquiry instruction includes:
Advertisement factual data to be checked and/or the dimensional information of advertisement factual data to be checked.
Optionally, this method further includes:
The advertisement factual data of each true table storage and/or the advertisement fact of each dimension table storage are recorded in metadata table
The dimensional information of data;
It is described that the ad data inquiry instruction is parsed, determine that one or more tables of data to be checked include:
According to the advertisement factual data to be checked and/or the dimension of advertisement factual data to be checked included in ad data inquiry instruction
Information is spent, corresponding tables of data to be checked is inquired from the metadata table.
Optionally, the true table and/or the dimension table are stored in one or more databases;
The query statement for tables of data generating structure to be checked includes:Determine the data where tables of data to be checked
Library;According to type of database, the query statement of the structuring of respective type of database is met for tables of data to be checked generation.
Optionally, this method further includes:
The storage location of each tables of data is recorded in metadata table;
Database where the determining tables of data to be checked includes:Data to be checked are inquired from the metadata table
Database where table.
Optionally, this method further includes:
According to one or more dimensional informations of advertisement factual data, generation includes the logic of logical relation between each tables of data
Relational graph;
The query statement for tables of data generating structure to be checked includes:It is to be checked according to the logic relation picture
Ask the query statement of tables of data generating structure.
Optionally, this method further includes:
Front end page is provided, instruction is generated in response to the logic relation picture that the front end page returns, it will be with each tables of data
Corresponding figure returns to the front end page;
Instruction is built in response to the logical relation that the front end page returns, establishes logical relation between each tables of data simultaneously
Generate corresponding logic relation picture.
Optionally, this method further includes:
Front end page is provided, instruction is shown in response to the logic relation picture that the front end page returns, will be patrolled with corresponding
It collects relational graph and returns to the front end page;
The acquisition ad data inquiry instruction input by user includes:The receiving front-end page return to logic relation picture
The selection instruction of middle one or more figure.
Optionally, this method further includes:
Front end page is provided, the diagrammatic representation template that the front end page returns is received and chooses instruction;
It is described user to be showed to include the query result:Corresponding diagrammatic representation is chosen from diagrammatic representation template library
Template shows the query result with the diagrammatic representation template of selection.
Another aspect according to the present invention provides a kind of query processing device of ad data, including:
Storage unit, suitable for setting multiple tables of data, including:One or more is for the fact that store advertisement factual data
The dimension table of table and/or one or more dimensional informations for being used to store advertisement factual data;
Ad data inquiry instruction acquiring unit, suitable for obtaining ad data inquiry instruction input by user;
Resolution unit suitable for being parsed to the ad data inquiry instruction, determines one or more numbers to be checked
It is the query statement of tables of data generating structure to be checked according to table;
Query unit is inquired corresponding tables of data suitable for the query statement of the structuring according to generation, is looked into
Ask result;
Display unit, suitable for the query result is showed user.
Optionally, the advertisement factual data includes at least one of following:
Advertising display data, ad click data, Advertising consumption data.
Optionally, the ad data inquiry instruction includes:
Advertisement factual data to be checked and/or the dimensional information of advertisement factual data to be checked.
Optionally, the storage unit is further adapted for recording the advertisement factual data of each true table storage in metadata table
And/or the dimensional information of the advertisement factual data of each dimension table storage;
The resolution unit, suitable for according to the advertisement factual data to be checked that is included in ad data inquiry instruction and/
Or the dimensional information of advertisement factual data to be checked, corresponding tables of data to be checked is inquired from the metadata table.
Optionally, the storage unit, suitable for the true table and/or the dimension table are stored in one or more numbers
According in library;
The resolution unit, the database being adapted to determine where tables of data to be checked;It is to be checked according to type of database
Tables of data generation meets the query statement of the structuring of respective type of database.
Optionally, the storage unit, suitable for recording the storage location of each tables of data in metadata table;
The resolution unit, suitable for inquiring the database where tables of data to be checked from the metadata table.
Optionally, which further includes:
Logic relation picture unit, suitable for one or more dimensional informations according to advertisement factual data, generation includes each number
According to the logic relation picture of logical relation between table;
The resolution unit, suitable for being the inquiry language of tables of data generating structure to be checked according to the logic relation picture
Sentence.
Optionally, the logic relation picture unit, is also adapted to provide front end page, is returned in response to the front end page
Logic relation picture generation instruction, the front end page is returned to by figure corresponding with each tables of data;In response to the preceding end page
The logical relation structure instruction that face returns, the logical relation established between each tables of data simultaneously generate corresponding logic relation picture.
Optionally, the logic relation picture unit, is also adapted to provide front end page, is returned in response to the front end page
Logic relation picture displaying instruction, will return to the front end page with corresponding logic relation picture;
The ad data inquiry instruction acquiring unit, suitable for the return of the receiving front-end page to one in logic relation picture
Or the selection instruction of multiple figures.
Optionally, the display unit, is also adapted to provide front end page, receives the diagrammatic representation that the front end page returns
Template chooses instruction;Corresponding diagrammatic representation template is chosen from diagrammatic representation template library, with the diagrammatic representation template exhibition of selection
Show the query result.
It can be seen from the above, technical scheme of the present invention, advertisement factual data, dimension table storage advertisement are stored using true table
The dimensional information of factual data when receiving ad data inquiry instruction, parses it, so that it is determined that number to be checked
According to table, and it is the query statement of these tables of data generating structures, then corresponding tables of data is inquired to obtain query result.
The technical solution can automatically generate the query sentence of database of regular price-line advertising business personnel structuring heavy in hand so that general
Logical advertising business personnel can just obtain corresponding query result by inputting simple ad data inquiry instruction, accuracy and
Efficiency suffers from good guarantee.
Above description is only the general introduction of technical solution of the present invention, in order to better understand the technological means of the present invention,
And it can be implemented in accordance with the contents of the specification, and in order to allow above and other objects of the present invention, feature and advantage can
It is clearer and more comprehensible, below the special specific embodiment for lifting the present invention.
Description of the drawings
By reading the detailed description of hereafter preferred embodiment, it is various other the advantages of and benefit it is common for this field
Technical staff will become clear.Attached drawing is only used for showing the purpose of preferred embodiment, and is not considered as to the present invention
Limitation.And throughout the drawings, the same reference numbers will be used to refer to the same parts.In the accompanying drawings:
Fig. 1 shows a kind of flow signal of the inquiry processing method of ad data according to an embodiment of the invention
Figure;
Fig. 2 shows a kind of structural representations of the query processing device of ad data according to an embodiment of the invention
Figure.
Specific embodiment
The exemplary embodiment of the disclosure is more fully described below with reference to accompanying drawings.Although the disclosure is shown in attached drawing
Exemplary embodiment, it being understood, however, that may be realized in various forms the disclosure without should be by embodiments set forth here
It is limited.On the contrary, these embodiments are provided to facilitate a more thoroughly understanding of the present invention, and can be by the scope of the present disclosure
Completely it is communicated to those skilled in the art.
Fig. 1 shows a kind of flow signal of the inquiry processing method of ad data according to an embodiment of the invention
Figure, as shown in Figure 1, this method includes:
Step S110 sets multiple tables of data, including:The fact that one or more is used to store advertisement factual data table,
And/or the dimension table of one or more dimensional informations for being used to store advertisement factual data.
For example, industry, region, advertiser belonging to advertisement etc. is all the different dimensions of advertisement factual data, for example,
One click behavior has been recorded in the true table of click, is clicked true table and is included industry dimension, region dimension and advertiser
Dimension.And the name of advertiser may only be had recorded or in advertisement primary dimension table under advertiser's dimension item in true table by clicking
Code name, if business personnel wants to recognize the relevant information of the advertiser, then also need to search advertisement primary dimension table, in this way
The data storage capacity in true table can be greatly reduced.
Step S120 obtains ad data inquiry instruction input by user.
Here user can input non-structured inquiry instruction, but can meet certain format, if such as providing
Dry input frame, inputs " click " in the input frame of " fact ", " industry=automobile " is inputted in the input frame of " dimension ", choosing
It selects the corresponding period to be inquired, the ad click data that automobile industry generates within the period can be obtained in this way.
Step S130 parses ad data inquiry instruction, one or more tables of data to be checked is determined, to treat
Inquire the query statement of tables of data generating structure.
For example, it is to click true table that parsing, which obtains the fact that user wishes inquiry table, dimension table is industry dimension table, then
It can be stored in MySQL database according to the query statement of the attribute generating structure of the two tables, such as the two tables,
Corresponding SQL query statement can so be generated.
Step S140 inquires corresponding tables of data according to the query statement of the structuring of generation, obtains inquiry knot
Fruit.
Query result is showed user by step S150.
As it can be seen that method shown in FIG. 1, advertisement factual data, dimension table storage advertisement factual data are stored using true table
Dimensional information, when receiving ad data inquiry instruction, it is parsed, so that it is determined that tables of data to be checked, and
For the query statement of these tables of data generating structures, then corresponding tables of data is inquired to obtain query result.The technology
Scheme can automatically generate the query sentence of database of regular price-line advertising business personnel structuring heavy in hand so that regular price-line advertising
Business personnel can just obtain corresponding query result by inputting simple ad data inquiry instruction, and accuracy and efficiency are all
There is good guarantee.
In one embodiment of the invention, advertisement factual data includes at least one of following:Advertising display data,
Ad click data, Advertising consumption data.
Wherein, advertising display data can include ad content displaying number, advertising display template displaying number, this
A little data can be recorded when server is pushed to Webpage;Ad click data can include ad content, advertisement
Click on area, user's session information, these can be by Webpage recording and sending;Advertising consumption data can wrap
Include the expense that advertiser is advertisement payment.
In one embodiment of the invention, in the above method, ad data inquiry instruction includes:Advertisement thing to be checked
The dimensional information of real data and/or advertisement factual data to be checked.Such as it is just introduced in the step S120 of previous embodiment
The example of non-structured advertising inquiry instruction input by user, and in one embodiment of the invention, the above method is also
Including:The advertisement factual data of each true table storage and/or the advertisement fact number of each dimension table storage are recorded in metadata table
According to dimensional information;Ad data inquiry instruction is parsed, determines that one or more tables of data to be checked include:According to
The advertisement factual data to be checked and/or the dimension letter of advertisement factual data to be checked included in ad data inquiry instruction
Breath inquires corresponding tables of data to be checked from metadata table.
That is, when parsing " click " from advertising inquiry input by user instruction, it is possible to according to metadata
The information recorded in table determines the fact that be checked table to click true table --- this is because business personnel can not be intuitive
Recognize table name of each table when backstage stores in ground.In fact, in storage, the table name for clicking true table also generally will not be straight
It connects and is expressed as " clicking true table ".Such benefit also resides in, and stores data with can standardizing, such as automobile industry,
Business personnel may be referred to as automobile industry, it is also possible to which referred to as automobile is easy for generating information barrier in this way.
In one embodiment of the invention, in the above method, true table and/or dimension table are stored in one or more numbers
According in library;Query statement for tables of data generating structure to be checked includes:Determine the database where tables of data to be checked;Root
According to type of database, the query statement of the structuring of respective type of database is met for tables of data to be checked generation.
According to the characteristic of ad data, different database purchase fact table and dimension table can be selected, for example, for number
According to larger data are measured, the hive databases for supporting big data may be used;For stream data, SparkSQL may be used
Storage.And for different types of database, the query statement of corresponding structuring is also different, it is therefore desirable to according to number
The query statement of structuring to match according to the type generation in library.
In one embodiment of the invention, the above method further includes:The storage of each tables of data is recorded in metadata table
Position;Database where determining tables of data to be checked includes:The number where tables of data to be checked is inquired from metadata table
According to library.
The storage location that metadata table records each tables of data is had chosen in the present embodiment, query metadata table first in this way
Determine the database where tables of data to be checked, it is possible to the structuring to match is further generated according to the type of the database
Query statement.
In one embodiment of the invention, the above method further includes:It is tieed up according to the one or more of advertisement factual data
Information is spent, generation includes the logic relation picture of logical relation between each tables of data;Inquiry for tables of data generating structure to be checked
Sentence includes:It is the query statement of tables of data generating structure to be checked according to logic relation picture.
It sketched in the aforementioned embodiment, the details of each dimension will not be recorded in true table, but be recorded in
In different dimension tables, then true table and dimension table are also meaned that there are logical relation, for example, clicking true table and industry
Dimension table, region dimension table, advertisement primary dimension table are there are logical relation, the star-like knot being also formed centered on true table
Structure.Similarly, true table, the true table of displaying are consumed also all with identical or different dimension table there are logical relation, it in this way can be with
The logic relation picture of logical relation between each tables of data is protected according to total data table or the generation of partial data table.And the knot of database
Structure characteristic so that query sentence of database is also structuring, can also be closed according to the logic included in logic relation picture
System, the query statement of generating structure.
In one embodiment of the invention, the above method further includes:Front end page is provided, is returned in response to front end page
Logic relation picture generation instruction, figure corresponding with each tables of data is returned into front end page;It is returned in response to front end page
Logical relation structure instruction, the logical relation established between each tables of data simultaneously generates corresponding logic relation picture.
For example, data maintenance personnel can see that it has permission the tables of data of editor in front end page, in front end page
It can be seen that multiple figures for representing each tables of data, then these figures are connected, are formed comprising logical relation
Chart, this process are exactly the building process of logic relation picture.For example, the fact that script there was only 4 dimensions in table, when need
When increasing a dimension newly, it is possible to a corresponding dimension table is created, it, can be by the newly-increased dimension in logic relation picture
The corresponding figure of table with it is corresponding the fact table figure be attached, thereby realize according to logical relation build instruct, build
It founds the logical relation between each tables of data and generates corresponding logic relation picture.
In one embodiment of the invention, the above method further includes:Front end page is provided, is returned in response to front end page
Logic relation picture displaying instruction, front end page will be returned to corresponding logic relation picture;Obtain advertisement number input by user
Include according to inquiry instruction:What the receiving front-end page returned instructs the selection of figures one or more in logic relation picture.
Logic relation picture is opened to the user for carrying out inquiry operation in the present embodiment so that user inputs ad data
The process of inquiry instruction is more convenient, takes full advantage of the structural features of database, simple, intuitive in this way.For example, user hooks
It selected industry dimension table, clicked true table and region dimension table, and add corresponding restrictive condition, it is possible to check that certain industry exists
The click volume of the advertisement of certain region.
In one embodiment of the invention, the above method further includes:Front end page is provided, what the receiving front-end page returned
Diagrammatic representation template chooses instruction;User is showed to include query result:Corresponding figure is chosen from diagrammatic representation template library
Table shows template, and query result is shown with the diagrammatic representation template of selection.
It provides in the present embodiment and graphically shows query result, wherein, diagrammatic representation template can be column
The common display form such as shape figure, cake chart, user can be selected according to demand.Query result can directly be pushed to
Front end page, the user for initiating to inquire can also be pushed in the time of setting or after the completion of inquiry in the form of mail etc..
Fig. 2 shows a kind of structural representations of the query processing device of ad data according to an embodiment of the invention
Figure, as shown in Fig. 2, the query processing device 200 of ad data includes:
Storage unit 210, suitable for setting multiple tables of data, including:One or more is used to store advertisement factual data
The dimension table of true table and/or one or more dimensional informations for being used to store advertisement factual data.
Ad data inquiry instruction acquiring unit 220, suitable for obtaining ad data inquiry instruction input by user.
Resolution unit 230 suitable for being parsed to ad data inquiry instruction, determines one or more data to be checked
Table is the query statement of tables of data generating structure to be checked.
Query unit 240 is inquired corresponding tables of data suitable for the query statement of the structuring according to generation, is obtained
Query result.
Display unit 250, suitable for query result is showed user.
As it can be seen that device shown in Fig. 2, advertisement factual data, dimension table storage advertisement factual data are stored using true table
Dimensional information, when receiving ad data inquiry instruction, it is parsed, so that it is determined that tables of data to be checked, and
For the query statement of these tables of data generating structures, then corresponding tables of data is inquired to obtain query result.The technology
Scheme can automatically generate the query sentence of database of regular price-line advertising business personnel structuring heavy in hand so that regular price-line advertising
Business personnel can just obtain corresponding query result by inputting simple ad data inquiry instruction, and accuracy and efficiency are all
There is good guarantee.
In one embodiment of the invention, in above device, advertisement factual data includes at least one of following:Extensively
Accuse display data, ad click data, Advertising consumption data.
In one embodiment of the invention, in above device, ad data inquiry instruction includes:Advertisement thing to be checked
The dimensional information of real data and/or advertisement factual data to be checked.
In one embodiment of the invention, in above device, storage unit 210 is further adapted for recording in metadata table
The dimensional information of the advertisement factual data of each fact table storage and/or the advertisement factual data of each dimension table storage;Resolution unit
230, suitable for true according to the advertisement factual data to be checked included in ad data inquiry instruction and/or advertisement to be checked
The dimensional information of data inquires corresponding tables of data to be checked from metadata table.
In one embodiment of the invention, in above device, storage unit 210, suitable for by true table and/or dimension table
It is stored in one or more databases;Resolution unit 230, the database being adapted to determine where tables of data to be checked;According to number
According to library type, the query statement of the structuring of respective type of database is met for tables of data to be checked generation.
In one embodiment of the invention, in above device, storage unit 210 is each suitable for being recorded in metadata table
The storage location of tables of data;Resolution unit 230, suitable for inquiring the database where tables of data to be checked from metadata table.
In one embodiment of the invention, above device further includes:Logic relation picture unit, suitable for according to the advertisement fact
One or more dimensional informations of data, generation include the logic relation picture of logical relation between each tables of data;Resolution unit 230,
Suitable for according to logic relation picture, being the query statement of tables of data generating structure to be checked.
In one embodiment of the invention, in above device, logic relation picture unit is also adapted to provide front end page,
Instruction is generated in response to the logic relation picture that front end page returns, figure corresponding with each tables of data is returned into front end page;
Instruction is built in response to the logical relation that front end page returns, and the logical relation established between each tables of data and generating is patrolled accordingly
Collect relational graph.
In one embodiment of the invention, in above device, logic relation picture unit is also adapted to provide front end page,
Instruction is shown in response to the logic relation picture that front end page returns, and will return to front end page with corresponding logic relation picture;Extensively
Data query instruction acquiring unit 220 is accused, suitable for the return of the receiving front-end page to figures one or more in logic relation picture
Selection instruction.
In one embodiment of the invention, in above device, display unit is also adapted to provide front end page, before reception
The diagrammatic representation template that end page face returns chooses instruction;Corresponding diagrammatic representation template is chosen from diagrammatic representation template library, with
The diagrammatic representation template displaying query result of selection.
It should be noted that the specific embodiment of above-mentioned each device embodiment and aforementioned corresponding method embodiment is specific
Embodiment is identical, and details are not described herein.
In conclusion technical scheme of the present invention, advertisement factual data, dimension table storage advertisement thing are stored using true table
The dimensional information of real data when receiving ad data inquiry instruction, parses it, so that it is determined that data to be checked
Table, and be the query statement of these tables of data generating structures, then corresponding tables of data is inquired to obtain query result.It should
Technical solution can automatically generate the query sentence of database of regular price-line advertising business personnel structuring heavy in hand so that common
Advertising business personnel can just obtain corresponding query result, accuracy and effect by inputting simple ad data inquiry instruction
Rate suffers from good guarantee.
It should be noted that:
Algorithm and display be not inherently related to any certain computer, virtual bench or miscellaneous equipment provided herein.
Various fexible units can also be used together with teaching based on this.As described above, required by constructing this kind of device
Structure be obvious.In addition, the present invention is not also directed to any certain programmed language.It should be understood that it can utilize various
Programming language realizes the content of invention described herein, and the description done above to language-specific is to disclose this hair
Bright preferred forms.
In the specification provided in this place, numerous specific details are set forth.It is to be appreciated, however, that the implementation of the present invention
Example can be put into practice without these specific details.In some instances, well known method, structure is not been shown in detail
And technology, so as not to obscure the understanding of this description.
Similarly, it should be understood that in order to simplify the disclosure and help to understand one or more of each inventive aspect,
Above in the description of exemplary embodiment of the present invention, each feature of the invention is grouped together into single implementation sometimes
In example, figure or descriptions thereof.However, the method for the disclosure should be construed to reflect following intention:I.e. required guarantor
Shield the present invention claims the more features of feature than being expressly recited in each claim.More precisely, as following
Claims reflect as, inventive aspect is all features less than single embodiment disclosed above.Therefore,
Thus the claims for following specific embodiment are expressly incorporated in the specific embodiment, wherein each claim is in itself
Separate embodiments all as the present invention.
Those skilled in the art, which are appreciated that, to carry out adaptively the module in the equipment in embodiment
Change and they are arranged in one or more equipment different from the embodiment.It can be the module or list in embodiment
Member or component be combined into a module or unit or component and can be divided into addition multiple submodule or subelement or
Sub-component.Other than such feature and/or at least some of process or unit exclude each other, it may be used any
Combination is disclosed to all features disclosed in this specification (including adjoint claim, abstract and attached drawing) and so to appoint
Where all processes or unit of method or equipment are combined.Unless expressly stated otherwise, this specification is (including adjoint power
Profit requirement, abstract and attached drawing) disclosed in each feature can be by providing the alternative features of identical, equivalent or similar purpose come generation
It replaces.
In addition, it will be appreciated by those of skill in the art that although some embodiments described herein include other embodiments
In included certain features rather than other feature, but the combination of the feature of different embodiments means in of the invention
Within the scope of and form different embodiments.For example, in the following claims, embodiment claimed is appointed
One of meaning mode can use in any combination.
The all parts embodiment of the present invention can be with hardware realization or to be run on one or more processor
Software module realize or realized with combination thereof.It will be understood by those of skill in the art that it can use in practice
Microprocessor or digital signal processor (DSP) realize the query processing device of ad data according to embodiments of the present invention
In some or all components some or all functions.The present invention is also implemented as described herein for performing
The some or all equipment or program of device (for example, computer program and computer program product) of method.In this way
Realization the present invention program can may be stored on the computer-readable medium or can have one or more signal shape
Formula.Such signal can be downloaded from internet website to be obtained either providing or with any other shape on carrier signal
Formula provides.
It should be noted that the present invention will be described rather than limits the invention, and ability for above-described embodiment
Field technique personnel can design alternative embodiment without departing from the scope of the appended claims.In the claims,
Any reference mark between bracket should not be configured to limitations on claims.Word "comprising" does not exclude the presence of not
Element or step listed in the claims.Word "a" or "an" before element does not exclude the presence of multiple such
Element.The present invention can be by means of including the hardware of several different elements and being come by means of properly programmed computer real
It is existing.If in the unit claim for listing equipment for drying, several in these devices can be by same hardware branch
To embody.The use of word first, second, and third does not indicate that any sequence.These words can be explained and run after fame
Claim.
Embodiment of the invention discloses that A1, a kind of inquiry processing method of ad data, wherein, this method includes:
Multiple tables of data are set, including:One or more is for the fact that store advertisement factual data table and/or one
Or the dimension table of multiple dimensional informations for being used to store advertisement factual data;
Obtain ad data inquiry instruction input by user;
The ad data inquiry instruction is parsed, determines one or more tables of data to be checked, is to be checked
The query statement of tables of data generating structure;
Corresponding tables of data is inquired according to the query statement of the structuring of generation, obtains query result;
The query result is showed into user.
A2, the method as described in A1, wherein, the advertisement factual data includes at least one of following:
Advertising display data, ad click data, Advertising consumption data.
A3, the method as described in A1, wherein, the ad data inquiry instruction includes:
Advertisement factual data to be checked and/or the dimensional information of advertisement factual data to be checked.
A4, the method as described in A3, wherein, this method further includes:
The advertisement factual data of each true table storage and/or the advertisement fact of each dimension table storage are recorded in metadata table
The dimensional information of data;
It is described that the ad data inquiry instruction is parsed, determine that one or more tables of data to be checked include:
According to the advertisement factual data to be checked and/or the dimension of advertisement factual data to be checked included in ad data inquiry instruction
Information is spent, corresponding tables of data to be checked is inquired from the metadata table.
A5, the method as described in A1, wherein, the fact table and/or the dimension table are stored in one or more data
In library;
The query statement for tables of data generating structure to be checked includes:Determine the data where tables of data to be checked
Library;According to type of database, the query statement of the structuring of respective type of database is met for tables of data to be checked generation.
A6, the method as described in A5, wherein, this method further includes:
The storage location of each tables of data is recorded in metadata table;
Database where the determining tables of data to be checked includes:Data to be checked are inquired from the metadata table
Database where table.
A7, the method as described in A1, wherein, this method further includes:
According to one or more dimensional informations of advertisement factual data, generation includes the logic of logical relation between each tables of data
Relational graph;
The query statement for tables of data generating structure to be checked includes:It is to be checked according to the logic relation picture
Ask the query statement of tables of data generating structure.
A8, the method as described in A7, wherein, this method further includes:
Front end page is provided, instruction is generated in response to the logic relation picture that the front end page returns, it will be with each tables of data
Corresponding figure returns to the front end page;
Instruction is built in response to the logical relation that the front end page returns, establishes logical relation between each tables of data simultaneously
Generate corresponding logic relation picture.
A9, the method as described in A7, wherein, this method further includes:
Front end page is provided, instruction is shown in response to the logic relation picture that the front end page returns, will be patrolled with corresponding
It collects relational graph and returns to the front end page;
The acquisition ad data inquiry instruction input by user includes:The receiving front-end page return to logic relation picture
The selection instruction of middle one or more figure.
A10, the method as described in A1, wherein, this method further includes:
Front end page is provided, the diagrammatic representation template that the front end page returns is received and chooses instruction;
It is described user to be showed to include the query result:Corresponding diagrammatic representation is chosen from diagrammatic representation template library
Template shows the query result with the diagrammatic representation template of selection.
The embodiment of the present invention also discloses the query processing device of B11, a kind of ad data, wherein, which includes:
Storage unit, suitable for setting multiple tables of data, including:One or more is for the fact that store advertisement factual data
The dimension table of table and/or one or more dimensional informations for being used to store advertisement factual data;
Ad data inquiry instruction acquiring unit, suitable for obtaining ad data inquiry instruction input by user;
Resolution unit suitable for being parsed to the ad data inquiry instruction, determines one or more numbers to be checked
It is the query statement of tables of data generating structure to be checked according to table;
Query unit is inquired corresponding tables of data suitable for the query statement of the structuring according to generation, is looked into
Ask result;
Display unit, suitable for the query result is showed user.
B12, the device as described in B11, wherein, the advertisement factual data includes at least one of following:
Advertising display data, ad click data, Advertising consumption data.
B13, the device as described in B11, wherein, the ad data inquiry instruction includes:
Advertisement factual data to be checked and/or the dimensional information of advertisement factual data to be checked.
B14, the device as described in B13, wherein,
The storage unit is further adapted for recording the advertisement factual data of each true table storage and/or each in metadata table
The dimensional information of the advertisement factual data of dimension table storage;
The resolution unit, suitable for according to the advertisement factual data to be checked that is included in ad data inquiry instruction and/
Or the dimensional information of advertisement factual data to be checked, corresponding tables of data to be checked is inquired from the metadata table.
B15, the device as described in B11, wherein,
The storage unit, suitable for the true table and/or the dimension table are stored in one or more databases;
The resolution unit, the database being adapted to determine where tables of data to be checked;It is to be checked according to type of database
Tables of data generation meets the query statement of the structuring of respective type of database.
B16, the device as described in B15, wherein,
The storage unit, suitable for recording the storage location of each tables of data in metadata table;
The resolution unit, suitable for inquiring the database where tables of data to be checked from the metadata table.
B17, the device as described in B11, wherein, which further includes:
Logic relation picture unit, suitable for one or more dimensional informations according to advertisement factual data, generation includes each number
According to the logic relation picture of logical relation between table;
The resolution unit, suitable for being the inquiry language of tables of data generating structure to be checked according to the logic relation picture
Sentence.
B18, the device as described in B17, wherein,
The logic relation picture unit, is also adapted to provide front end page, is closed in response to the logic that the front end page returns
System's figure generation instruction, the front end page is returned to by figure corresponding with each tables of data;It is returned in response to the front end page
Logical relation structure instruction, the logical relation established between each tables of data simultaneously generates corresponding logic relation picture.
B19, the device as described in B17, wherein,
The logic relation picture unit, is also adapted to provide front end page, is closed in response to the logic that the front end page returns
System's figure displaying instruction, will return to the front end page with corresponding logic relation picture;
The ad data inquiry instruction acquiring unit, suitable for the return of the receiving front-end page to one in logic relation picture
Or the selection instruction of multiple figures.
B20, the device as described in B11, wherein,
The display unit, is also adapted to provide front end page, receives the diagrammatic representation template choosing that the front end page returns
Instruction fetch;Corresponding diagrammatic representation template is chosen from diagrammatic representation template library, with described in the diagrammatic representation template displaying of selection
Query result.
Claims (10)
1. a kind of inquiry processing method of ad data, wherein, this method includes:
Multiple tables of data are set, including:One or more is for the fact that store advertisement factual data table and/or one or more
The dimension table of a dimensional information for being used to store advertisement factual data;
Obtain ad data inquiry instruction input by user;
The ad data inquiry instruction is parsed, determines one or more tables of data to be checked, is data to be checked
The query statement of table generating structure;
Corresponding tables of data is inquired according to the query statement of the structuring of generation, obtains query result;
The query result is showed into user.
2. the method for claim 1, wherein the advertisement factual data includes at least one of following:
Advertising display data, ad click data, Advertising consumption data.
3. the method for claim 1, wherein the ad data inquiry instruction includes:
Advertisement factual data to be checked and/or the dimensional information of advertisement factual data to be checked.
4. method as claimed in claim 3, wherein, this method further includes:
The advertisement factual data of each true table storage and/or the advertisement factual data of each dimension table storage are recorded in metadata table
Dimensional information;
It is described that the ad data inquiry instruction is parsed, determine that one or more tables of data to be checked include:According to
The advertisement factual data to be checked and/or the dimension letter of advertisement factual data to be checked included in ad data inquiry instruction
Breath inquires corresponding tables of data to be checked from the metadata table.
5. the method for claim 1, wherein the true table and/or the dimension table are stored in one or more numbers
According in library;
The query statement for tables of data generating structure to be checked includes:Determine the database where tables of data to be checked;
According to type of database, the query statement of the structuring of respective type of database is met for tables of data to be checked generation.
6. a kind of query processing device of ad data, wherein, which includes:
Storage unit, suitable for setting multiple tables of data, including:The fact that one or more is used to store advertisement factual data table,
And/or the dimension table of one or more dimensional informations for being used to store advertisement factual data;
Ad data inquiry instruction acquiring unit, suitable for obtaining ad data inquiry instruction input by user;
Resolution unit suitable for being parsed to the ad data inquiry instruction, determines one or more tables of data to be checked,
Query statement for tables of data generating structure to be checked;
Query unit inquires corresponding tables of data suitable for the query statement of the structuring according to generation, obtains inquiry knot
Fruit;
Display unit, suitable for the query result is showed user.
7. device as claimed in claim 6, wherein, the advertisement factual data includes at least one of following:
Advertising display data, ad click data, Advertising consumption data.
8. device as claimed in claim 6, wherein, the ad data inquiry instruction includes:
Advertisement factual data to be checked and/or the dimensional information of advertisement factual data to be checked.
9. device as claimed in claim 8, wherein,
The storage unit is further adapted for recording the advertisement factual data of each true table storage and/or each dimension in metadata table
The dimensional information of the advertisement factual data of table storage;
The resolution unit, suitable for according to the advertisement factual data to be checked included in ad data inquiry instruction and/or treating
The dimensional information of the advertisement factual data of inquiry inquires corresponding tables of data to be checked from the metadata table.
10. device as claimed in claim 6, wherein,
The storage unit, suitable for the true table and/or the dimension table are stored in one or more databases;
The resolution unit, the database being adapted to determine where tables of data to be checked;It is data to be checked according to type of database
Table generation meets the query statement of the structuring of respective type of database.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201611247041.6A CN108255861A (en) | 2016-12-29 | 2016-12-29 | The inquiry processing method and device of a kind of ad data |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201611247041.6A CN108255861A (en) | 2016-12-29 | 2016-12-29 | The inquiry processing method and device of a kind of ad data |
Publications (1)
Publication Number | Publication Date |
---|---|
CN108255861A true CN108255861A (en) | 2018-07-06 |
Family
ID=62720195
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201611247041.6A Pending CN108255861A (en) | 2016-12-29 | 2016-12-29 | The inquiry processing method and device of a kind of ad data |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108255861A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109635168A (en) * | 2018-12-12 | 2019-04-16 | 成都四方伟业软件股份有限公司 | Chart output method and device |
Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101271473A (en) * | 2008-04-29 | 2008-09-24 | 华为技术有限公司 | Data query method, device and system |
CN102479223A (en) * | 2010-11-25 | 2012-05-30 | 中国移动通信集团浙江有限公司 | Data query method and system |
CN102508929A (en) * | 2011-12-01 | 2012-06-20 | 浪潮(北京)电子信息产业有限公司 | System, device and method for realizing data migration of heterogeneous database |
CN102521416A (en) * | 2011-12-28 | 2012-06-27 | 用友软件股份有限公司 | Data correlation query method and data correlation query device |
US20130346192A1 (en) * | 2012-06-20 | 2013-12-26 | Yahoo! Inc. | Method and system for displaying a theme based advertisement on a search box |
CN105808591A (en) * | 2014-12-30 | 2016-07-27 | 阿里巴巴集团控股有限公司 | Flow rate display method and device |
CN106033466A (en) * | 2015-03-20 | 2016-10-19 | 华为技术有限公司 | Database query method and device |
-
2016
- 2016-12-29 CN CN201611247041.6A patent/CN108255861A/en active Pending
Patent Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101271473A (en) * | 2008-04-29 | 2008-09-24 | 华为技术有限公司 | Data query method, device and system |
CN102479223A (en) * | 2010-11-25 | 2012-05-30 | 中国移动通信集团浙江有限公司 | Data query method and system |
CN102508929A (en) * | 2011-12-01 | 2012-06-20 | 浪潮(北京)电子信息产业有限公司 | System, device and method for realizing data migration of heterogeneous database |
CN102521416A (en) * | 2011-12-28 | 2012-06-27 | 用友软件股份有限公司 | Data correlation query method and data correlation query device |
US20130346192A1 (en) * | 2012-06-20 | 2013-12-26 | Yahoo! Inc. | Method and system for displaying a theme based advertisement on a search box |
CN105808591A (en) * | 2014-12-30 | 2016-07-27 | 阿里巴巴集团控股有限公司 | Flow rate display method and device |
CN106033466A (en) * | 2015-03-20 | 2016-10-19 | 华为技术有限公司 | Database query method and device |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109635168A (en) * | 2018-12-12 | 2019-04-16 | 成都四方伟业软件股份有限公司 | Chart output method and device |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US7505983B2 (en) | Extending data flows | |
CN102708136B (en) | The index to feature and search including the use of reusable index field | |
US20160110670A1 (en) | Relational analysis of business objects | |
US20060215832A1 (en) | Data access service queries | |
KR20030074647A (en) | A method of configuring a product | |
CN107229730A (en) | Data query method and device | |
US8285721B2 (en) | Mapping item records to product records | |
CN105573966A (en) | Adaptive Modification of Content Presented in Electronic Forms | |
AU2006202224A1 (en) | An intellectual property analysis and report generating system and method | |
US20090171683A1 (en) | Use of Constraints to Enforce Complex Payment Policies | |
US20120143725A1 (en) | Methods and systems for influencing search and shopping decisions in electronic procurement | |
CN110222285A (en) | The methods of exhibiting of reading page calculates equipment and computer storage medium | |
CN108256970A (en) | A kind of method that Products Show is carried out based on shopping need | |
CN108009147A (en) | Electronics book cover generation method, electronic equipment and computer-readable storage medium | |
US20100169228A1 (en) | Integrated Negotiation Engine | |
CN108052310A (en) | A kind of data processing method and server based on business model description information | |
CN106294361B (en) | Information providing method and information providing system | |
CN106777405B (en) | Method for promoting low-frequency commodity transaction based on SaaS service | |
CN108255861A (en) | The inquiry processing method and device of a kind of ad data | |
US20130191304A1 (en) | Tools and Methods for Creating Dynamic Feedback Forms | |
CN105426541B (en) | A kind of storage method and device of general data | |
JP5620589B2 (en) | Product information search | |
CN108021588B (en) | Integration method and device for user first purchase data facing electronic commerce | |
US8170973B2 (en) | Satisfying rules through a configuration of list processing methods | |
US9836776B2 (en) | Generation and search of multidimensional linked lists and computing array |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180706 |
|
RJ01 | Rejection of invention patent application after publication |