CN105740333A - Visual advertisement management platform, and implementation method thereof - Google Patents
Visual advertisement management platform, and implementation method thereof Download PDFInfo
- Publication number
- CN105740333A CN105740333A CN201610045784.9A CN201610045784A CN105740333A CN 105740333 A CN105740333 A CN 105740333A CN 201610045784 A CN201610045784 A CN 201610045784A CN 105740333 A CN105740333 A CN 105740333A
- Authority
- CN
- China
- Prior art keywords
- data
- query
- dimension
- tolerance
- block
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0241—Advertisements
Abstract
The invention discloses a visual advertisement management platform, and an implementation method thereof. The platform comprises an inquiry area unit, and an inquiry object generation unit, wherein the inquiry area unit is used for the display of a model tree to a user and the input of data inquiry items at the front end of a page; the model tree is corresponding to a preset data model in the xml format and comprises measurements, dimensions and groups, and the data inquiry items comprise inquiry fields and relevant filtering conditions; the measurements are practical data indicators that business personnel are concerned about, and each measurement is corresponding to a certain column of a fact datasheet; the dimensions are data analysis perspectives of the business personnel, and each dimension is corresponding to a certain column of a dimension datasheet; each group is a combination of the dimensions and the measurements in a same category as required by businesses; the inquiry object generation unit is used for accepting the dragging of the measurements and the dimensions on the model tree by the user, as well as the filtering conditions and inquiry conditions set by the user in a selection box, so that corresponding inquiry objects can be constructed.
Description
Technical field
The invention belongs to mobile Internet field, relate to a kind of visual advertising management platform.
Background technology
At present, the advertising platform of great Bu company produces more than one hundred million advertisement log data every day, wherein, for convenient statistics, analyzes ad data, according to different business demands, builds different data warehouses.When business personnel obtains data from data warehouse, makes statistical analysis charts, it is necessary to according to the hand-written sql query script of business demand, and Query Result is exported as data file for making chart.
This mode, has the disadvantages that first, it has not been convenient to, namely business is required for emergency hand and builds query script every time；Second, not intuitively, namely every time only it can be seen that data file, if desired for checking chart, then need manual making, overall work efficiency is had large effect by this.
Summary of the invention
The technical problem to be solved is to provide a kind of visual advertising management platform, this platform gets final product in-time generatin query script in front end based on pulling, and the result available chart displaying finally shown, the computer capacity for user is less demanding, and has convenience, intuitively advantage.
This invention address that the technical scheme that above-mentioned technical problem is taked is as follows:
A kind of visual advertising management platform, including:
Query region unit, for representing model tree and choice box in page front end to user；
Described model tree is corresponding with the data model of xml form set in advance, and this model tree includes: tolerance, dimension and packet, has querying condition option and filtercondition option in described choice box；
Wherein, tolerance is the data target with practical significance that business personnel pays close attention to, certain string in corresponding fact table；Dimension is the angle of business personnel's analytical data, certain string in corresponding dimension data table；Packet is that by similar dimension, tolerance is put together according to service needed；
Query object generate unit, for accepting tolerance and the dimension that user pulls on model tree, and in choice box setting filtercondition and querying condition, build corresponding query object；
Query processing unit, is used for receiving above query object, according to the tables of data that query object is corresponding, and takes out Query Result formation data result collection；
Front end data display unit, is presented to user by data result further in the way of form or chart.
Preferably, it is additionally provided with data model definitions unit, for storing the data model of xml form；
And the tables of data in ad data warehouse, data row are carried out Semantic mapping, build the ad data model with tolerance, dimensional attribute.
Preferably, described query object generates unit, farther includes query object block definition subelement, for building attribute block according to query object, wherein, described query object attribute block includes query block, filter block, packet filtering block, sort block and record number stop block.
Preferably, described query processing unit, farther include inquiry sql and build subelement, described sql builds subelement by resolving each attribute block of query object, builds the sql query statement that described ad data warehouse is relevant.
Preferably, described query processing unit, farther include data set and build subelement, described data set builds subelement, for according to the sql query statement provided, inquiring about data base, the data set result of return structure structure is general, that be prone to extension, there is gauge outfit attribute.
A kind of visual advertising management realizes method, comprises the following steps:
Step 1) represent model tree and choice box to user in page front end；
Described model tree is corresponding with the data model of xml form set in advance, and this model tree includes: tolerance, dimension and packet, has querying condition option and filtercondition option in described choice box；
Wherein, tolerance is the data target with practical significance that business personnel pays close attention to, certain string in corresponding fact table；Dimension is the angle of business personnel's analytical data, certain string in corresponding dimension data table；Packet is that by similar dimension, tolerance is put together according to service needed；
Step 2) accept tolerance and dimension that user pulls on model tree, and the filtercondition set in choice box and querying condition, build corresponding query object；
Step 3) receive above query object, according to the tables of data that query object is corresponding, and take out Query Result formation data result collection；Data result is presented to user in the way of form or chart.
Preferably, the data model of xml form it is previously stored with；
And the tables of data in ad data warehouse, data row are carried out Semantic mapping, build the ad data model with tolerance, dimensional attribute.
Preferably, described step 3) farther include: building attribute block according to query object, wherein, described query object attribute block includes query block, filter block, packet filtering block, sort block and record number stop block.
Preferably, described step 3) farther include: resolve each attribute block of query object, build the sql query statement that described ad data warehouse is relevant.
Preferably, described step 3), farther include, according to the sql query statement provided, to inquire about data base, the data set result of return structure structure is general, that be prone to extension, there is gauge outfit attribute.
After this invention takes above scheme, achieve data query sum to it is investigated and see visualization, wherein, business personnel gets final product in-time generatin query script in front end based on pulling, and the result available chart displaying finally shown, computer capacity for user is less demanding, and has convenience, intuitively advantage.
Other features and advantages of the present invention will be set forth in the following description, and, partly become apparent from description, or understand by implementing the present invention.The purpose of the present invention and other advantages can be realized by structure specifically noted in the description write, claims and accompanying drawing and be obtained.
Accompanying drawing explanation
Below in conjunction with accompanying drawing, the present invention is described in detail, so that the above-mentioned advantage of the present invention is definitely.Wherein,
Fig. 1 is the structural representation of the visual advertising management platform of the present invention；
Fig. 2 is the schematic diagram of the data model of the visual advertising management platform of the present invention；
Fig. 3 is the data model schematic diagram to model tree of the visual advertising management platform of the present invention；
Fig. 4 is the schematic diagram of the query object structure of the visual advertising management platform of the present invention；
Fig. 5 is the structural representation of the embodiment of the visual advertising management platform of the present invention；
Fig. 6 is the association schematic diagram of the tables of data of the visual advertising management platform of the present invention；
Fig. 7 a-Fig. 7 d is the structure table association schematic diagram of the visual advertising management platform of the present invention；
The chart that Fig. 8 is the visual advertising management platform of the present invention represents schematic diagram；
Fig. 9 is the schematic diagram of the data model of the visual advertising management platform of invention.
Detailed description of the invention
Describing embodiments of the present invention in detail below with reference to drawings and Examples, to the present invention, how application technology means solve technical problem whereby, and the process that realizes reaching technique effect can fully understand and implement according to this.As long as it should be noted that do not constitute conflict, each embodiment in the present invention and each feature in each embodiment can be combined with each other, and the technical scheme formed is all within protection scope of the present invention.
Embodiment one:
Present invention is primarily based on existing advertising inquiry platform, it needs to inquire about by means of manual, for this, be primarily intended to and accomplish following result:
A. data modeling:
Namely beforehand through the tables of data to ad data warehouse, data row carry out Semantic mapping, build service-oriented, the understandable business model of user, thus, business personnel is no longer necessary to understand the data structure of data warehouse, only need to understand the data model closer to business.
B. visualization is inquired about:
Namely by resolution data pattern query object, automatically build inquiry sql and inquire about data.Business personnel only need to by simply pulling the tolerance of business model, dimension and input filtercondition, quickly, easily ad data is inquired about and analysis operation.
C. result pictorialization
Namely by Query Result being converted to the input of foreground chart components.Business personnel can with intuitive way analytical data.
For this, as it is shown in figure 1, construct a kind of visual advertising management platform, including:
Query region unit, for representing model tree and input data query item in page front end to user；
Described model tree is corresponding with the data model of xml form set in advance, and this model tree includes: tolerance, dimension and packet, and described data query item has inquiry field and relevance filtering condition；
Wherein, tolerance is the data target with practical significance that business personnel pays close attention to, certain string in corresponding fact table；Dimension is the angle of business personnel's analytical data, certain string in corresponding dimension data table；Packet is that by similar dimension, tolerance is put together according to service needed；
Query object generate unit, for accepting tolerance and the dimension that user pulls on model tree, and in choice box setting filtercondition and querying condition, build corresponding query object；
Query processing unit, is used for receiving above query object, inquires about tables of data according to query object, and takes out Query Result formation data result collection；
Front end data display unit, is presented to user by data result further in the way of form or chart.
After this invention takes such scheme, achieve data query sum to it is investigated and see visualization, wherein, business personnel gets final product in-time generatin query script in front end based on pulling, and the result available chart displaying finally shown, computer capacity for user is less demanding, and has convenience, intuitively advantage.
Embodiment two:
Based on above example one, it is described in detail.In one embodiment, it is preferred that, it is additionally provided with data model definitions unit, for xml format memory data model；
And the tables of data in ad data warehouse, data row are carried out Semantic mapping, build the ad data model with tolerance, dimensional attribute.
Preferably, described query object generates unit, farther includes query object block definition subelement, for building attribute block according to query object, wherein, described query object attribute block includes query block, filter block, packet filtering block, sort block and record number stop block.
Preferably, described query processing unit, farther include inquiry sql and build subelement, described sql builds subelement by resolving each attribute block of query object, builds the sql query statement that described ad data warehouse is relevant.
Preferably, described query processing unit, farther include data set and build subelement, described data set builds subelement, for according to the sql query statement provided, inquiring about data base, the data set result of return structure structure is general, that be prone to extension, there is gauge outfit attribute.
Embodiment three:
As in figure 2 it is shown, data model mainly adopts xml document mode to define, it comprises tolerance, dimension and/or packet.
When in use, it presents to user in the way of model tree, such as Fig. 3.
Wherein, tolerance is the data target with practical significance that business personnel pays close attention to, and generally corresponds to certain string in fact table, and is generally numeral, for instance " request " in ad data, " displaying ", the index such as " click ".
Additionally, tolerance is except deriving from fact table, it is possible to derive from existing tolerance, for instance " clicking rate " in ad data, reality is exactly " clicking/show * 100% ".
Dimension: be the angle of business personnel's analytical data, generally corresponds to certain string in dimension data table.Such as, " city " in ad data, " advertisement ", " media ".
Packet: be tolerance, the set of dimension, it is simple to business personnel is according to service needed, and by similar dimension, tolerance is put together.
Wherein, after data model builds, it presents to user in front end page in the way of model tree, and user can pass through the tolerance pulling on model tree, and dimension builds query object.
As shown in Figure 4, upper figure business personnel is by " date " on hard wide model tree, " day exposure ", " hits ", " clicking rate " is dragged to the Field Inquiry region on right side, and is provided with filtercondition " 2014-10-01 to 2015-12-01 " at " date " place, and definition is with reference to Fig. 9 more specifically.
Wherein, further, query region is divided into " dimension district " and " tolerance district ", and the dimension of model is mainly put in " dimension district ", and the tolerance of model is put in " tolerance district ".
The reason so distinguished is tolerance is can do to add up to, average that wait polymerization calculating, and when being polymerized tolerance and being used for filtering, it and common filtration are distinguishing.
In query object, common correspondence " filter " attribute that filters, polymeric filter correspondence " having " attribute, they are respectively used to build " where " and " having " of sql.
When business personnel completes input, clicks " inquiry ", input can be generated query block by foreground on request, and ultimately forms the query object of json form.
Wherein, after above query object generates, namely query processing unit can build inquiry sql according to query object, and Query Result is also generated data set by inquiry data base；
Wherein, in an embodiment, data model has tables of data and the incidence relation of data row, tables of data.Further, tables of data and data row can with the tolerance of data business model, and dimension is corresponding, and namely they and above data row carry out man-to-man Semantic mapping.
Namely in one embodiment,
Tables of data: be defined with " table " label, provides the title used in a model and the true table name in data warehouse.Such as upper figure defines " report_uv_all " fact table and " date_info " dimension data table.
Data arrange: be defined with " column " label, also provide the title used in a model and truly arrange name in data warehouse table.Such as upper figure defines " click " and clicks row.
Table associates: is defined with " relation " label, respectively specifies that the master meter of association, from table, and is used for the row associated in them, additionally further specify the mode of table association.
Further, including the fact that table and dimension table in the table of association, all dimension tables can associate by direct or indirect and true table, and the dimension table of indirect association is to set up incidence relation by other dimension table and true table.
Further, tables of data and tolerance, the corresponding relation between dimension is as follows:
Being defined with " field " label, it is intended that tolerance, the title of dimension, by them and tables of data, data row carry out man-to-man mapping." hits " tolerance of such as upper figure definition, it derives from " click " row of " report_uv_all " table.
Tolerance, the Semantic mapping rule of dimension is very simple, it is simply that unique row specifying data warehouse table, when business personnel uses tolerance, during dimension, it is possible to navigate to data warehouse table and row easily.
Computation measure: when tolerance is not derived from data row, we with existing, can arrange relevant tolerance with data and define.Such as " clicking rate " computation measure of upper figure definition, it defines by " day exposure " and " hits " two tolerance.Computation measure cannot directly from data warehouse query, it is necessary to first finds the value of calculation of correlation from data warehouse, is then calculating.
Model tree:
The tolerance of data model, dimension is the structure definition with tree, and model can be regarded as a tree, its vacuum metrics by us, and dimension is the node on model tree.
Model tree, the tolerance on tree, by using association tree assembly, are not difficult to become data model in foreground, and dimension can be dragged in query region.
Business personnel is operated by the tolerance in model tree, and dimension uses the tolerance of data model, dimension.Data model is shown in Fig. 3 to the change of model tree.
Business personnel is by pulling the tolerance of model tree, and dimension, to query region, arranges the contents such as filtercondition, polymerizing condition, sequence, just can build query object.
The content that query object inputs with user is relevant, mainly includes the contents such as inquiry field, filtercondition, sort field.Fig. 4 is the use-case building query object, and Fig. 5 is the structural representation of an embodiment.
In Fig. 4, business personnel is by " date " on hard wide model tree, " day exposure ", and " hits ", " clicking rate " is dragged to the Field Inquiry region on right side, and is provided with filtercondition " 2014-10-01 to 2015-12-01 " at " date " place.
Query region is divided into " dimension district " and " tolerance district ", and the dimension of model is mainly put in " dimension district ", and the tolerance of model is put in " tolerance district ".The reason so distinguished is tolerance is can do to add up to, average that wait polymerization calculating, and when being polymerized tolerance and being used for filtering, it and common filtration are distinguishing.
In query object, common correspondence " filter " attribute that filters, polymeric filter correspondence " having " attribute, they are respectively used to build " where " and " having " of sql.
When business personnel completes input, clicks " inquiry ", input can be generated the query object of json form by foreground on request.This object has following important attribute.
Whole data query pulls the tolerance of model tree from business personnel, and dimension, to query region, then completes to finally enter and click " inquiry " and returns result.
After having had query object, the groundwork that query processing engine to do is exactly the sql that the input of query object is converted to final inquiry.
Being not difficult to find out from the definition of the definition of model and query object, measuring, dimension transfers the row of tables of data to and builds the query term of sql from query object, filtering item, packet filtering item, order item is not difficult, and difficulty is the table association how constructing sql from query object.
By collecting the tolerance used in query object, dimension, we can find out the table that inquiry is required, but only these tables are inadequate, it would be desirable to finding out minimum table set, they can be associated, and includes again the table needed for all inquiries.Certainly, all of table also can be associated by we, but the performance of so inquiry can be very poor.We are given in snowflake model table finding out comprising and appoint to the minimum contingency table set based algorithm of one group of table below.
Such as, for the snowflake model table of Fig. 6 incidence relation, wherein " A " is true table, and other table is dimension table.When the required table of inquiry is (A, E, I), it is intended that the table of association is (A, B, E, C, G, I).In order to obtain the table of above-mentioned association, we add count attribute for each table, the counting of the required table of inquiry is 0, trace back to true table then up, often recalling once, counting adds 1, when the number that the count attribute value of certain table is the required table of inquiry, this table is the master meter of contingency table, and the table used in trace-back process is then for the table of association.Detailed process is shown in Fig. 7 a-Fig. 7 d.
Wherein, in Fig. 7 a-Fig. 7 d, chart (A, E, I) counting starts upwards to recall from 0, finally at Table A, counts consistent with the number of table, and therefore Table A is the master meter of contingency table.The table (B, G, C) that inquiry table (A, E, I) and backtracking are used has collectively constituted contingency table (A, E, I, B, G, C).Having had contingency table, we carry out extreme saturation from master meter A, the order (A, B, E, C, G, I) drawn eventually for contingency table of being not difficult.
Having had contingency table and query object, we just can build the sql of inquiry, inquires about data by sql, just can obtain the data of final needs.For the ease of data are done further calculating, we devise data set organization, for depositing the result that inquiry returns.Data set is a two-dimensional structure, including the storage of row definition and each row of data.
Query Result Output of for ms is the most frequently used data exhibiting mode, and we can design simple grid control, receives the data set that background query returns, and data are presented to business personnel in the way of form.As shown in Figure 8, it is that form represents Query Result.
Query Result also can represent by the mode of figure, for instance conventional cake, post, line chart.We can by the figure control increased income, for instance echart, d3.js etc., it is achieved data are mapped.
The present embodiment can apply in following application scenarios:
A. the hard wide full dimensional analysis of data
To firmly wide daily record data, according to advertisement, media, region, the multiple dimension such as adline, to request, is shown, is clicked isometry index and carry out data analysis.
B. the anti-analysis of practising fraud of media
Mobile phone model according to media is distributed, Regional Distribution, within 24 hours, shows curve distribution, and media are carried out cheating probability analysis by the multiple angles such as customer loss being shown to click.
Embodiment four:
Corresponding with apparatus above embodiment, the invention also discloses a kind of visual advertising management and realize method, comprise the following steps:
Step 1) represent model tree and input data query item in page front end to user；
Described model tree is corresponding with the data model of xml form set in advance, and this model tree includes: tolerance, dimension and packet, and described data query item has inquiry field and relevance filtering condition；
Wherein, tolerance is the data target with practical significance that business personnel pays close attention to, certain string in corresponding fact table；Dimension is the angle of business personnel's analytical data, certain string in corresponding dimension data table；Packet is that by similar dimension, tolerance is put together according to service needed；
Step 2) accept tolerance and dimension that user pulls on model tree, and the filtercondition set in choice box and querying condition, build corresponding query object；
Step 3) receive above query object, inquire about tables of data according to query object, and take out Query Result formation data result collection；Data result is presented to user in the way of form or chart.
Preferably, in advance with xml format memory data model；
And the tables of data in ad data warehouse, data row are carried out Semantic mapping, build the ad data model with tolerance, dimensional attribute.
Preferably, described step 3) farther include: building attribute block according to query object, wherein, described query object attribute block includes query block, filter block, packet filtering block, sort block and record number stop block.
Preferably, described step 3) farther include: resolve each attribute block of query object, build the sql query statement that described ad data warehouse is relevant.
Preferably, described step 3), farther include, according to the sql query statement provided, to inquire about data base, the data set result of return structure structure is general, that be prone to extension, there is gauge outfit attribute.
The present invention has the effect that device is similar, namely it achieves data query sum and it is investigated and see visualization, wherein, business personnel gets final product in-time generatin query script in front end based on pulling, and the result available chart displaying finally shown, computer capacity for user is less demanding, and has convenience, intuitively advantage.
It should be noted that, for said method embodiment, in order to be briefly described, therefore it is all expressed as a series of combination of actions, but those skilled in the art should know, the application is not by the restriction of described sequence of movement, because according to the application, some step can adopt other orders or carry out simultaneously.Secondly, those skilled in the art also should know, embodiment described in this description belongs to preferred embodiment, necessary to involved action and module not necessarily the application.
Those skilled in the art are it should be appreciated that embodiments herein can be provided as method, system or computer program.Therefore, the application can adopt the form of complete hardware embodiment, complete software implementation or the embodiment in conjunction with software and hardware aspect.
Last it is noted that the foregoing is only the preferred embodiments of the present invention, it is not limited to the present invention, although the present invention being described in detail with reference to previous embodiment, for a person skilled in the art, technical scheme described in foregoing embodiments still can be modified by it, or wherein portion of techniques feature carries out equivalent replacement.All within the spirit and principles in the present invention, any amendment of making, equivalent replacement, improvement etc., should be included within protection scope of the present invention.
Claims (10)
1. a visual advertising management platform, it is characterised in that including:
Query region unit, for representing model tree and input data query item in page front end to user；
Described model tree is corresponding with the data model of xml form set in advance, and this model tree includes: tolerance, dimension and packet, and described data query item has inquiry field and relevance filtering condition；
Wherein, tolerance is the data target with practical significance that business personnel pays close attention to, certain string in corresponding fact table；Dimension is the angle of business personnel's analytical data, certain string in corresponding dimension data table；Packet is that by similar dimension, tolerance is put together according to service needed；
Query object generate unit, for accepting tolerance and the dimension that user pulls on model tree, and in choice box setting filtercondition and querying condition, build corresponding query object；
Query processing unit, is used for receiving above query object, inquires about tables of data according to query object, and takes out Query Result formation data result collection；
Front end data display unit, is presented to user by data result further in the way of form or chart.
2. visual advertising management platform according to claim 1, it is characterised in that be additionally provided with data model definitions unit, with xml format memory data model；
And the tables of data in ad data warehouse, data row are carried out Semantic mapping, build the ad data model with tolerance, dimensional attribute.
3. visual advertising management platform according to claim 1, it is characterized in that, described query object generates unit, farther include query object block definition subelement, for building attribute block according to query object, wherein, described query object attribute block includes query block, filter block, packet filtering block, sort block and record number stop block.
4. the visual advertising management platform according to claim 1 or 3, it is characterized in that, described query processing unit, farther include inquiry sql and build subelement, described sql builds subelement by resolving each attribute block of query object, builds the sql query statement that described ad data warehouse is relevant.
5. visual advertising management platform according to claim 4, it is characterized in that, described query processing unit, farther include data set and build subelement, described data set builds subelement, for according to the sql query statement provided, inquiring about data base, the data set result of return structure structure is general, that be prone to extension, there is gauge outfit attribute.
6. visual advertising management realizes a method, comprises the following steps:
Step 1) represent model tree and input data query item in page front end to user；
Described model tree is corresponding with the data model of xml form set in advance, and this model tree includes: tolerance, dimension and packet, and described data query item has inquiry field and relevance filtering condition；
Wherein, tolerance is the data target with practical significance that business personnel pays close attention to, certain string in corresponding fact table；Dimension is the angle of business personnel's analytical data, certain string in corresponding dimension data table；Packet is that by similar dimension, tolerance is put together according to service needed；
Step 2) accept tolerance and dimension that user pulls on model tree, and the filtercondition set in choice box and querying condition, build corresponding query object；
Step 3) receive above query object, inquire about tables of data according to query object, and take out Query Result formation data result collection；Data result is presented to user in the way of form or chart.
7. visual advertising management according to claim 6 realizes method, it is characterised in that in advance with xml format memory data model；
And the tables of data in ad data warehouse, data row are carried out Semantic mapping, build the ad data model with tolerance, dimensional attribute.
8. visual advertising management according to claim 6 realizes method, it is characterised in that described step 3) farther include: build attribute block according to query object, wherein, described query object attribute block includes query block, filter block, packet filtering block, sort block and record number stop block.
9. the visual advertising management according to claim 6 or 8 realizes method, it is characterised in that described step 3) farther include: resolve each attribute block of query object, build the sql query statement that described ad data warehouse is relevant.
10. visual advertising management according to claim 9 realizes method, it is characterized in that, described step 3, farther include according to the sql query statement provided, inquiry data base, the data set result of return structure structure is general, that be prone to extension, there is gauge outfit attribute.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610045784.9A CN105740333A (en) | 2016-01-23 | 2016-01-23 | Visual advertisement management platform, and implementation method thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610045784.9A CN105740333A (en) | 2016-01-23 | 2016-01-23 | Visual advertisement management platform, and implementation method thereof |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105740333A true CN105740333A (en) | 2016-07-06 |
Family
ID=56246513
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610045784.9A Pending CN105740333A (en) | 2016-01-23 | 2016-01-23 | Visual advertisement management platform, and implementation method thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105740333A (en) |
Cited By (25)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105740365A (en) * | 2016-01-27 | 2016-07-06 | 北京掌阔移动传媒科技有限公司 | Rapid query method and apparatus for data warehouse |
| CN106776834A (en) * | 2016-11-28 | 2017-05-31 | 中通服公众信息产业股份有限公司 | A kind of data analysis based on index is from access method and system |
| CN106855889A (en) * | 2016-12-29 | 2017-06-16 | 深圳市华傲数据技术有限公司 | The development approach and device of the extemporaneous query function of the tables of data of different data sources |
| CN106909610A (en) * | 2017-01-10 | 2017-06-30 | 中电科华云信息技术有限公司 | Visualization based on browser pulls the method and system of inquiry data |
| CN107145558A (en) * | 2017-05-02 | 2017-09-08 | 山东浪潮通软信息科技有限公司 | A kind of self-service visualization data analysing method based on data set |
| CN107679025A (en) * | 2017-09-20 | 2018-02-09 | 北京数猎天下科技有限公司 | A kind of diagrammatic representation to worksheet carries out operation and maintenance method |
| CN107766428A (en) * | 2017-09-15 | 2018-03-06 | 北京大学 | A kind of automatic method and system for realizing data visualization |
| CN107908657A (en) * | 2017-10-17 | 2018-04-13 | 平安科技（深圳）有限公司 | Querying method, device, computer equipment and the storage medium of bordereau |
| CN108154376A (en) * | 2016-12-06 | 2018-06-12 | 腾讯科技（北京）有限公司 | Data processing method and device |
| CN108536342A (en) * | 2017-03-02 | 2018-09-14 | 腾讯科技（深圳）有限公司 | A kind of data query method and device |
| CN108563666A (en) * | 2018-01-05 | 2018-09-21 | 成都兴政电子政务运营服务有限公司 | A kind of data visualization processing system and method based on big data technology |
| CN109033157A (en) * | 2018-06-14 | 2018-12-18 | 山东鲁能软件技术有限公司 | A kind of complex data search method and system based on customized search condition tree |
| CN109241196A (en) * | 2017-07-06 | 2019-01-18 | 阿里巴巴集团控股有限公司 | Data query method and device, equipment |
| CN109308292A (en) * | 2018-11-27 | 2019-02-05 | 北京京东尚科信息技术有限公司 | Crowd orients method for digging, device and computer readable storage medium |
| CN109325651A (en) * | 2018-07-31 | 2019-02-12 | 合肥工业大学 | A kind of dynamic cooperative relationship visualization technology evaluation method for supporting project management |
| CN109783495A (en) * | 2019-01-11 | 2019-05-21 | 华青融天(北京)软件股份有限公司 | A kind of multi-dimensional data processing method, device and computer equipment |
| CN109993449A (en) * | 2019-04-08 | 2019-07-09 | 中交一公局海威工程建设有限公司 | Laboratory equipment management method, BIM Visualization Platform, equipment and medium |
| CN109992589A (en) * | 2019-04-11 | 2019-07-09 | 北京启迪区块链科技发展有限公司 | Method, apparatus, server and the medium of SQL statement are generated based on visual page |
| CN110633082A (en) * | 2019-09-26 | 2019-12-31 | 山东浪潮商用系统有限公司 | Dynamic data display method and system combining echart and html |
| CN111597172A (en) * | 2020-03-25 | 2020-08-28 | 北京梦天门科技股份有限公司 | Multi-dimensional big data analysis display system based on check list |
| CN112445796A (en) * | 2020-11-02 | 2021-03-05 | 许继集团有限公司 | New energy station report generation method |
| CN112825107A (en) * | 2019-11-21 | 2021-05-21 | 北京沃东天骏信息技术有限公司 | Method and device for generating chart |
| CN113127442A (en) * | 2020-01-10 | 2021-07-16 | 马上消费金融股份有限公司 | Visualization method and device of data model and storage medium |
| CN114925665A (en) * | 2022-06-08 | 2022-08-19 | 杭州比智科技有限公司 | Graph data editing method and system based on web table |
| CN117473981A (en) * | 2023-12-22 | 2024-01-30 | 深圳市明源云客电子商务有限公司 | Statement analysis method, device, equipment and computer readable storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101286151A (en) * | 2007-04-13 | 2008-10-15 | 国际商业机器公司 | Method for establishing multidimensional model and data store mode mappings and relevant system |
| CN102841938A (en) * | 2012-08-14 | 2012-12-26 | 北京久其软件股份有限公司 | Method and system for generating parameterized report |
| CN103164222A (en) * | 2013-02-25 | 2013-06-19 | 用友软件股份有限公司 | Multidimensional modeling system and multidimensional modeling method |
-
2016
- 2016-01-23 CN CN201610045784.9A patent/CN105740333A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101286151A (en) * | 2007-04-13 | 2008-10-15 | 国际商业机器公司 | Method for establishing multidimensional model and data store mode mappings and relevant system |
| CN102841938A (en) * | 2012-08-14 | 2012-12-26 | 北京久其软件股份有限公司 | Method and system for generating parameterized report |
| CN103164222A (en) * | 2013-02-25 | 2013-06-19 | 用友软件股份有限公司 | Multidimensional modeling system and multidimensional modeling method |
Cited By (37)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105740365A (en) * | 2016-01-27 | 2016-07-06 | 北京掌阔移动传媒科技有限公司 | Rapid query method and apparatus for data warehouse |
| CN106776834A (en) * | 2016-11-28 | 2017-05-31 | 中通服公众信息产业股份有限公司 | A kind of data analysis based on index is from access method and system |
| CN108154376B (en) * | 2016-12-06 | 2021-06-11 | 腾讯科技（北京）有限公司 | Data processing method and device |
| CN108154376A (en) * | 2016-12-06 | 2018-06-12 | 腾讯科技（北京）有限公司 | Data processing method and device |
| CN106855889A (en) * | 2016-12-29 | 2017-06-16 | 深圳市华傲数据技术有限公司 | The development approach and device of the extemporaneous query function of the tables of data of different data sources |
| CN106909610A (en) * | 2017-01-10 | 2017-06-30 | 中电科华云信息技术有限公司 | Visualization based on browser pulls the method and system of inquiry data |
| CN106909610B (en) * | 2017-01-10 | 2020-11-24 | 中电科华云信息技术有限公司 | Method and system for visually dragging and querying data based on browser |
| CN108536342A (en) * | 2017-03-02 | 2018-09-14 | 腾讯科技（深圳）有限公司 | A kind of data query method and device |
| CN107145558A (en) * | 2017-05-02 | 2017-09-08 | 山东浪潮通软信息科技有限公司 | A kind of self-service visualization data analysing method based on data set |
| CN107145558B (en) * | 2017-05-02 | 2020-06-09 | 浪潮通用软件有限公司 | Self-service visualized data analysis method based on data set |
| CN109241196A (en) * | 2017-07-06 | 2019-01-18 | 阿里巴巴集团控股有限公司 | Data query method and device, equipment |
| CN107766428B (en) * | 2017-09-15 | 2021-09-24 | 北京大学 | Method and system for automatically realizing data visualization |
| CN107766428A (en) * | 2017-09-15 | 2018-03-06 | 北京大学 | A kind of automatic method and system for realizing data visualization |
| CN107679025A (en) * | 2017-09-20 | 2018-02-09 | 北京数猎天下科技有限公司 | A kind of diagrammatic representation to worksheet carries out operation and maintenance method |
| WO2019076050A1 (en) * | 2017-10-17 | 2019-04-25 | 平安科技（深圳）有限公司 | Business report query method and apparatus, computer device and storage medium |
| CN107908657A (en) * | 2017-10-17 | 2018-04-13 | 平安科技（深圳）有限公司 | Querying method, device, computer equipment and the storage medium of bordereau |
| CN108563666A (en) * | 2018-01-05 | 2018-09-21 | 成都兴政电子政务运营服务有限公司 | A kind of data visualization processing system and method based on big data technology |
| CN109033157A (en) * | 2018-06-14 | 2018-12-18 | 山东鲁能软件技术有限公司 | A kind of complex data search method and system based on customized search condition tree |
| CN109033157B (en) * | 2018-06-14 | 2021-07-27 | 山东鲁能软件技术有限公司 | Complex data retrieval method and system based on user-defined search condition tree |
| CN109325651A (en) * | 2018-07-31 | 2019-02-12 | 合肥工业大学 | A kind of dynamic cooperative relationship visualization technology evaluation method for supporting project management |
| CN109325651B (en) * | 2018-07-31 | 2021-12-28 | 合肥工业大学 | Dynamic cooperation relation visualization technology evaluation method supporting project management |
| CN109308292A (en) * | 2018-11-27 | 2019-02-05 | 北京京东尚科信息技术有限公司 | Crowd orients method for digging, device and computer readable storage medium |
| CN109783495A (en) * | 2019-01-11 | 2019-05-21 | 华青融天(北京)软件股份有限公司 | A kind of multi-dimensional data processing method, device and computer equipment |
| CN109993449A (en) * | 2019-04-08 | 2019-07-09 | 中交一公局海威工程建设有限公司 | Laboratory equipment management method, BIM Visualization Platform, equipment and medium |
| CN109992589A (en) * | 2019-04-11 | 2019-07-09 | 北京启迪区块链科技发展有限公司 | Method, apparatus, server and the medium of SQL statement are generated based on visual page |
| CN109992589B (en) * | 2019-04-11 | 2020-04-10 | 北京启迪区块链科技发展有限公司 | Method, device, server and medium for generating SQL (structured query language) statements based on visual page |
| CN110633082A (en) * | 2019-09-26 | 2019-12-31 | 山东浪潮商用系统有限公司 | Dynamic data display method and system combining echart and html |
| CN112825107A (en) * | 2019-11-21 | 2021-05-21 | 北京沃东天骏信息技术有限公司 | Method and device for generating chart |
| CN112825107B (en) * | 2019-11-21 | 2024-03-01 | 北京沃东天骏信息技术有限公司 | Method and device for generating chart |
| CN113127442A (en) * | 2020-01-10 | 2021-07-16 | 马上消费金融股份有限公司 | Visualization method and device of data model and storage medium |
| CN113127442B (en) * | 2020-01-10 | 2023-12-22 | 马上消费金融股份有限公司 | Method, device and storage medium for visualizing data model |
| CN111597172A (en) * | 2020-03-25 | 2020-08-28 | 北京梦天门科技股份有限公司 | Multi-dimensional big data analysis display system based on check list |
| CN111597172B (en) * | 2020-03-25 | 2024-02-02 | 北京梦天门科技股份有限公司 | Multi-dimensional big data analysis display system based on checklist |
| CN112445796A (en) * | 2020-11-02 | 2021-03-05 | 许继集团有限公司 | New energy station report generation method |
| CN112445796B (en) * | 2020-11-02 | 2024-03-01 | 许继集团有限公司 | New energy station report generation method |
| CN114925665A (en) * | 2022-06-08 | 2022-08-19 | 杭州比智科技有限公司 | Graph data editing method and system based on web table |
| CN117473981A (en) * | 2023-12-22 | 2024-01-30 | 深圳市明源云客电子商务有限公司 | Statement analysis method, device, equipment and computer readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105740333A (en) | Visual advertisement management platform, and implementation method thereof | |
| CN110618983B (en) | JSON document structure-based industrial big data multidimensional analysis and visualization method | |
| CN110929042B (en) | Knowledge graph construction and query method based on power enterprise | |
| Rao et al. | Spatial hierarchy and OLAP-favored search in spatial data warehouse | |
| US20230244702A1 (en) | Automated geospatial data analysis | |
| CN103605651A (en) | Data processing showing method based on on-line analytical processing (OLAP) multi-dimensional analysis | |
| CN110851667A (en) | Integrated analysis method and tool for multi-source large data | |
| CN104700190A (en) | Method and device for matching item and professionals | |
| CN111414410B (en) | Data processing method, device, equipment and storage medium | |
| CN104317936A (en) | ROLAP (relational on-line analysis processing) analysis engine design method and device on basis of star models | |
| Tešendić et al. | Business intelligence in the service of libraries | |
| CN111125352A (en) | Knowledge graph-based associated data visualization data cockpit construction method | |
| CN116468010A (en) | Report generation method, device, terminal and storage medium | |
| JP6375029B2 (en) | A metadata-based online analytical processing system that analyzes the importance of reports | |
| CN113946594B (en) | Integrated query method, device and equipment for industrial multi-source heterogeneous data | |
| Petermann et al. | Graph mining for complex data analytics | |
| CN112634004B (en) | Method and system for analyzing blood-cause atlas of credit investigation data | |
| CN112527918A (en) | Data processing method and device | |
| CN114092024A (en) | Investment project full-process management method and system | |
| CN113535966A (en) | Knowledge graph creating method, information obtaining method, device and equipment | |
| US10860651B2 (en) | Method, apparatus, and computer-readable medium for generation of missing data | |
| CN114860737B (en) | Processing method, device, equipment and medium of teaching and research data | |
| CN109933622A (en) | A kind of data visualisation system and implementation method | |
| CN110597899B (en) | Project expense management method and system | |
| US11341187B2 (en) | Method, apparatus, and computer-readable medium for missing data identification |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160706 |