CN109284288A - A kind of media data hierarchy system - Google Patents
A kind of media data hierarchy system Download PDFInfo
- Publication number
- CN109284288A CN109284288A CN201811049283.3A CN201811049283A CN109284288A CN 109284288 A CN109284288 A CN 109284288A CN 201811049283 A CN201811049283 A CN 201811049283A CN 109284288 A CN109284288 A CN 109284288A
- Authority
- CN
- China
- Prior art keywords
- media
- point
- screen
- attribute
- identity code
- 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.)
- Granted
Links
Classifications
-
- 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
- G06Q30/0242—Determining effectiveness of advertisements
Landscapes
- Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Engineering & Computer Science (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Finance (AREA)
- Economics (AREA)
- Game Theory and Decision Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Marketing (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention discloses a kind of media data hierarchy systems.The hierarchy system includes: point table, media table and screen table;The point table, the media table and the screen table constitute three-level data list structure;The point table is associated with the media table by external key;The media table is associated with the screen table by external key;Point table can accurately describe media geographic location, and media table can clearly describe the advertisement output equipment in a certain geographical location, and screen table can accurately describe the information output carrier that advertisement output equipment has.Have the adaptability of stronger data inside numerous and complicated outdoor media type using hierarchy system provided by the present invention, relative to current two-stage or the data staging scheme of level-one, there is clearer data managing capacity.
Description
Technical field
The present invention relates to media data management domains, more particularly to a kind of media data hierarchy system.
Background technique
In real life, advertisement is seen everywhere, and with the gradually growth of media industry influence power, is carried out by media wide
It is increasingly common thing that dispensing, which is accused, with the popularity for improving commodity, such as: the social activity in bus station's dispensing advertisement, cell
Media, the display screen in market and billboard in high speed etc..From the perspective of customer, advertisement has incorporated the life of oneself
It is living, the commodity for being suitble to oneself are found according to advertisement, for advertisement putting person, the input situation (input situation of advertisement
Specifically include and launch place, placement position and release time etc.) and advertisement launch after brought by benefit be most heavy
It wants.Under normal conditions, it is desirable to which the input situation for knowing advertisement is all to go to scene to reconnoitre by people, then pass on to advertisement dispensing
Person, but this prospecting mode efficiency when encountering large area advertisement and launching is extremely low, and not can guarantee the authenticity of feedback message.
Summary of the invention
The object of the present invention is to provide a kind of media data hierarchy systems, manually check whether advertisement launches with solution and cause
Low efficiency, the problem of authenticity not can guarantee.
A kind of media data hierarchy system, comprising: point table, media table and screen table;The point table, the media
Table and the screen table constitute three-level data list structure;
The point table is associated with the media table by external key;
The media table is associated with the screen table by external key.
Optionally, the point table includes the first attribute;First attribute includes point Identity Code, point name
Title, position coordinate longitude, position coordinate latitude and location expression information;The location expression information is the specific of outdoor media
Position;The outdoor media includes waiting booth media, community Media and high speed media;The point table launches position for determining
It sets.
Optionally, the media table includes the second attribute;Second attribute includes the every row Identity Code of media, media
Title, position point Identity Code and media description information;The media description information includes the specific location of release position;
The release position includes any lamp box in waiting booth, any cell floor in community and any billboard in high speed;
The media table is used to determine the specific location of the release position.
Optionally, the screen table includes third attribute;The third attribute includes the every row Identity Code of screen, media
Point Identity Code and screen description information;The screen description information includes that the advertisement picture in the release position is launched
Face;The advertisement picture launches any surface that face includes the lamp box, any advertising plane in the unit floor and described
Any surface of billboard;The screen table is used to show that the advertisement picture in each release position to launch face.
The media point Identity Code is directed toward the every row Identity Code of media, the position point identity
Code is directed toward the point Identity Code.
Optionally, the three-level data list structure is according to the suitable of the screen table, the media table and the point table
Sequence is associated with using many-one external key.
Optionally, first attribute is described using JSON data structure, dynamically adds corresponding attribute value.
Optionally, second attribute is described using JSON data structure, dynamically adds corresponding attribute value.
Optionally, the third attribute is described using JSON data structure, dynamically adds corresponding attribute value.
To achieve the above object, the present invention provides following schemes:
The specific embodiment provided according to the present invention, the invention discloses following technical effects: the present invention provides one kind
Media data hierarchy system, it is more accurate that outdoor media digitization is described by constituting three-level data list structure, quickly help
It helps outdoor media operator to realize digitization management, without manually arriving site inspection advertisement input situation, reduces manpower money
The waste in source, improves work efficiency, it is ensured that the authenticity of feedback message, meanwhile, the present invention can be accurate by screen table
Learn that each release position specifically launches position and the quantity of advertisement.
Detailed description of the invention
It in order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, below will be to institute in embodiment
Attached drawing to be used is needed to be briefly described, it should be apparent that, the accompanying drawings in the following description is only some implementations of the invention
Example, for those of ordinary skill in the art, without any creative labor, can also be according to these attached drawings
Obtain other attached drawings.
Fig. 1 is media data hierarchy system structure chart provided by the present invention.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, it is obtained by those of ordinary skill in the art without making creative efforts every other
Embodiment shall fall within the protection scope of the present invention.
The object of the present invention is to provide a kind of media data hierarchy systems, can reduce the waste of human resources, improve work
Make efficiency, it is ensured that the authenticity of feedback message, meanwhile, it is capable to accurately learn that each release position specifically launches position and the number of advertisement
Amount.
In order to make the foregoing objectives, features and advantages of the present invention clearer and more comprehensible, with reference to the accompanying drawing and specific real
Applying mode, the present invention is described in further detail.
Fig. 1 is media data hierarchy system structure chart provided by the present invention, as shown in Figure 1, a kind of media data is classified
System, the media data hierarchy system are three-level data list structure, comprising: point table, media table and screen table;The point
Position table (MediaPlace), the media table (Media) and the screen table (MediaScreen) constitute three-level tables of data knot
Structure.
The point table is associated with the media table by external key;
The media table is associated with the screen table by external key.
Table 1 is point list data structure table provided by the present invention, as shown in table 1, wherein data describe (place_
It info) include: bus station's (waiting booth media), cell (community Media), expressway (high speed media).
Table 1
Serial number | Field name | Type | Field description | Length | Allow empty | Default value |
1 | id | uuid | Row id mark | 0 | It is no | |
2 | place_name | varchar | Point title | 255 | It is no | |
3 | loc_lat | float8 | Position coordinate latitude | 8 | It is no | |
4 | loc_lng | float8 | Position coordinate longitude | 9 | It is no | |
5 | place_info | json | Media description information | 255 | It is no |
Table 2 is media list data structure table provided by the present invention, and as shown in table 2, data describe (media_info) packet
Include: in cell some unit floor, some is famous for waiting booth some lamp box, high speed.
Table 2
Table 3 is screen list data structure table provided by the present invention, and as shown in table 3, data describe (screen_info) packet
It includes: light projecting device lamp piece position, a certain advertising plane of waiting booth lamp box, at a high speed some some famous advertising plane.
Table 3
Three-level data list structure according to " screen table ", " media table ", " point table " many-one external key be associated with, " screen table " with
" media_id " terminal is directed toward media table " id ", and " media table " is directed toward point table " id " with " place_id ".
In practical applications, the point table includes the first attribute;First attribute includes point Identity Code, point
Position title, position coordinate longitude, position coordinate latitude and location expression information;The location expression information is outdoor media
Specific location;The outdoor media includes waiting booth media, community Media and high speed media;The point table is thrown for determining
Put position.
In practical applications, the media table includes the second attribute;Second attribute includes the every row identity of media
Code, media name, position point Identity Code and media description information;The media description information includes the tool of release position
Body position;The release position includes any lamp box in waiting booth, any cell floor in community and any in high speed
Billboard;The media table is used to determine the specific location of the release position.
In practical applications, the screen table includes third attribute;The third attribute includes the every row identity of screen
Code, media point Identity Code and screen description information;The screen description information includes the advertisement in the release position
Picture launches face;It includes any surface of the lamp box, any advertising plane in the unit floor that the advertisement picture, which launches face,
And any surface of the billboard;The screen table is used to show that the advertisement picture in each release position to launch face.
The media point Identity Code is directed toward the every row Identity Code of media, the position point identity
Code is directed toward the point Identity Code.
In practical applications, three-level data list structure is according to the screen table, the media table and the point table
Sequence is associated with using many-one external key.
In practical applications, first attribute is described using JSON data structure, dynamically adds corresponding attribute value.
In practical applications, second attribute is described using JSON data structure, dynamically adds corresponding attribute value.
In practical applications, the third attribute is described using JSON data structure, dynamically adds corresponding attribute value.
The present invention describes outdoor media digitization using three-level data list structure is more accurate, can quickly help family
Outer media operator realizes digitization management.
Meanwhile each attribute of point table, media table, screen table is described using JSON data structure, can dynamically be added
Corresponding attribute value, extremely flexibly adapts to different types of outdoor media.
Such as: light projects characterising parameter in cell are as follows: community names, Lou Hao, unit number;Waiting booth media description parameter
Are as follows: bus station's title, section, direction;High speed media: high speed title, direction, distance.
The present invention convenient can must describe the current media data of media operator.Such as: a, being difficult to express statistic media
How many a advertisement pictures can be printed above altogether;B, it is difficult to express statistic and has how many media (such as: waiting booth lamp box) altogether.
Point table can accurately describe media geographic location, and media table can clearly describe a certain geographical location
Interior advertisement output equipment, screen table can accurately describe the information output carrier that advertisement output equipment has.Numerous and complicated
Inside complicated outdoor media type, hierarchy system provided by the present invention has the adaptability of stronger data, relative to working as
The data staging scheme of preceding two-stage or level-one has clearer data managing capacity.
Each embodiment in this specification is described in a progressive manner, the highlights of each of the examples are with other
The difference of embodiment, the same or similar parts in each embodiment may refer to each other.
Used herein a specific example illustrates the principle and implementation of the invention, and above embodiments are said
It is bright to be merely used to help understand method and its core concept of the invention;At the same time, for those skilled in the art, foundation
Thought of the invention, there will be changes in the specific implementation manner and application range.In conclusion the content of the present specification is not
It is interpreted as limitation of the present invention.
Claims (8)
1. a kind of media data hierarchy system characterized by comprising point table, media table and screen table;The point
Table, the media table and the screen table constitute three-level data list structure;
The point table is associated with the media table by external key;
The media table is associated with the screen table by external key.
2. media data hierarchy system according to claim 1, which is characterized in that the point table includes the first attribute;
First attribute includes point Identity Code, point title, position coordinate longitude, position coordinate latitude and location expression
Information;The location expression information is the specific location of outdoor media;The outdoor media includes waiting booth media, community Media
And high speed media;The point table is for determining placement position.
3. media data hierarchy system according to claim 2, which is characterized in that the media table includes the second attribute;
Second attribute includes the every row Identity Code of media, media name, position point Identity Code and media description letter
Breath;The media description information includes the specific location of release position;The release position includes any lamp box in waiting booth, community
Any billboard on interior any cell floor and high speed;The media table is used to determine the specific position of the release position
It sets.
4. media data hierarchy system according to claim 3, which is characterized in that the screen table includes third attribute;
The third attribute includes the every row Identity Code of screen, media point Identity Code and screen description information;The screen
Curtain description information includes that the advertisement picture in the release position launches face;It includes appointing for the lamp box that the advertisement picture, which launches face,
On one side, any surface of any advertising plane in the unit floor and the billboard;The screen table is each for showing
Advertisement picture in the release position launches face.
The media point Identity Code is directed toward the every row Identity Code of media, and the position point Identity Code refers to
To the point Identity Code.
5. media data hierarchy system according to claim 1, which is characterized in that the three-level data list structure is according to institute
The sequence for stating screen table, the media table and the point table is associated with using many-one external key.
6. media data hierarchy system according to claim 2, which is characterized in that first attribute uses JSON data
Structure description, dynamically adds corresponding attribute value.
7. media data hierarchy system according to claim 3, which is characterized in that second attribute uses JSON data
Structure description, dynamically adds corresponding attribute value.
8. media data hierarchy system according to claim 4, which is characterized in that the third attribute uses JSON data
Structure description, dynamically adds corresponding attribute value.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811049283.3A CN109284288B (en) | 2018-09-10 | 2018-09-10 | Media data grading system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811049283.3A CN109284288B (en) | 2018-09-10 | 2018-09-10 | Media data grading system |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109284288A true CN109284288A (en) | 2019-01-29 |
CN109284288B CN109284288B (en) | 2022-03-15 |
Family
ID=65180448
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811049283.3A Active CN109284288B (en) | 2018-09-10 | 2018-09-10 | Media data grading system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109284288B (en) |
Citations (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102047284A (en) * | 2008-06-03 | 2011-05-04 | 高通股份有限公司 | Marketing and advertising framework for a wireless device |
CN103593783A (en) * | 2013-06-26 | 2014-02-19 | 上海仙视电子有限公司 | Shopping guide machine with optimized advertisement system |
CN103823850A (en) * | 2014-02-13 | 2014-05-28 | 南京梅山冶金发展有限公司 | Storage method of multilayer structural relationship database |
CN103888341A (en) * | 2014-02-25 | 2014-06-25 | 周良文 | System and method for performing socialization with objects in music website |
CN104408179A (en) * | 2014-12-15 | 2015-03-11 | 北京国双科技有限公司 | Method and device for processing data from data table |
CN104463460A (en) * | 2014-12-03 | 2015-03-25 | 北京国双科技有限公司 | Method and device for processing scheduling information for network data delivery |
CN106408323A (en) * | 2016-08-29 | 2017-02-15 | 山东易牌网络科技有限公司 | Electronic advertisement management system and method |
WO2017195635A1 (en) * | 2016-05-13 | 2017-11-16 | 株式会社カレンダー広告 | Calendar, advertisement layout device, printed publication, and web distribution system |
CN107679899A (en) * | 2017-09-26 | 2018-02-09 | 北京智云联众科技有限公司 | The content put-on method and device of a kind of advertisement screen |
CN108198042A (en) * | 2018-01-25 | 2018-06-22 | 刘文侠 | A kind of commodity or service match and are associated with displaying and its method of work with the accurate of businessman |
CN108205769A (en) * | 2016-12-20 | 2018-06-26 | 北京神州泰岳智能数据技术有限公司 | A kind of acquisition methods and device of target outdoor media |
US20180204111A1 (en) * | 2013-02-28 | 2018-07-19 | Z Advanced Computing, Inc. | System and Method for Extremely Efficient Image and Pattern Recognition and Artificial Intelligence Platform |
-
2018
- 2018-09-10 CN CN201811049283.3A patent/CN109284288B/en active Active
Patent Citations (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102047284A (en) * | 2008-06-03 | 2011-05-04 | 高通股份有限公司 | Marketing and advertising framework for a wireless device |
US20180204111A1 (en) * | 2013-02-28 | 2018-07-19 | Z Advanced Computing, Inc. | System and Method for Extremely Efficient Image and Pattern Recognition and Artificial Intelligence Platform |
CN103593783A (en) * | 2013-06-26 | 2014-02-19 | 上海仙视电子有限公司 | Shopping guide machine with optimized advertisement system |
CN103823850A (en) * | 2014-02-13 | 2014-05-28 | 南京梅山冶金发展有限公司 | Storage method of multilayer structural relationship database |
CN103888341A (en) * | 2014-02-25 | 2014-06-25 | 周良文 | System and method for performing socialization with objects in music website |
CN104463460A (en) * | 2014-12-03 | 2015-03-25 | 北京国双科技有限公司 | Method and device for processing scheduling information for network data delivery |
CN104408179A (en) * | 2014-12-15 | 2015-03-11 | 北京国双科技有限公司 | Method and device for processing data from data table |
WO2017195635A1 (en) * | 2016-05-13 | 2017-11-16 | 株式会社カレンダー広告 | Calendar, advertisement layout device, printed publication, and web distribution system |
CN106408323A (en) * | 2016-08-29 | 2017-02-15 | 山东易牌网络科技有限公司 | Electronic advertisement management system and method |
CN108205769A (en) * | 2016-12-20 | 2018-06-26 | 北京神州泰岳智能数据技术有限公司 | A kind of acquisition methods and device of target outdoor media |
CN107679899A (en) * | 2017-09-26 | 2018-02-09 | 北京智云联众科技有限公司 | The content put-on method and device of a kind of advertisement screen |
CN108198042A (en) * | 2018-01-25 | 2018-06-22 | 刘文侠 | A kind of commodity or service match and are associated with displaying and its method of work with the accurate of businessman |
Non-Patent Citations (2)
Title |
---|
YANG SONG 等: "A quantitative case study in engineering of the efficacy of quality cheat-sheets", 《2015 IEEE FRONTIERS IN EDUCATION CONFERENCE (FIE)》 * |
王敏 等: "数字标牌广告即时排期优化算法研究", 《电脑知识与技术》 * |
Also Published As
Publication number | Publication date |
---|---|
CN109284288B (en) | 2022-03-15 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20230041991A1 (en) | Density-based dynamic geohash | |
CN105074495B (en) | For the hierarchical service in indoor positioning and the adaptive assistance data of efficiency | |
CN103136807A (en) | Attendance system and attendance method based on location based service (LBS) | |
CN101794466A (en) | Electronic check-in method and system | |
EP2328301A1 (en) | Method and apparatus for managing the authority in workflow component based on authority component | |
CN107330545A (en) | The Method for Information Optimization and Express Logistics system of a kind of Express Logistics system | |
CN101726284A (en) | Place identification method, photographing device and place identification system | |
CN105338065A (en) | Terminal equipment position information protection method and device | |
CN107067171A (en) | Vehicle insurance business intelligence dispatches system | |
CN109284288A (en) | A kind of media data hierarchy system | |
CN105915563B (en) | A kind of information issuing system and its information issuing method based on electronic map | |
CN102663959B (en) | Comprehensive situation intuitive display system and implementation method thereof based on map label processing | |
Uchida et al. | A real-time disaster-related information sharing system based on the utilization of Twitter | |
CN110209987A (en) | A kind of tax-related information promotional display system and method | |
JP4977074B2 (en) | Work display and advertising system | |
Haviser | Community archaeology as an essential element for successful Archaeological Heritage Management | |
CN107205060A (en) | A kind of IP to ID correlating method | |
CN113868360A (en) | Address data processing method and device, electronic equipment and storage medium | |
CN105701603A (en) | Member information updating method and system, platform management system and scene management system | |
Hilal et al. | Towards a heritage management strategy for Ras al-Khaimah (UAE) | |
CN110147422A (en) | A method of fast accurate obtains the information data of advertising equipment in range on map | |
CN111461779A (en) | Map information processing method and device, readable storage medium and electronic equipment | |
CN110309250A (en) | A kind of methods of exhibiting and system of geographic element distribution density | |
CN215576666U (en) | Conference reservation system | |
CN109889570A (en) | A kind of facility information dissemination system and method |
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 | ||
GR01 | Patent grant | ||
GR01 | Patent grant |