CN103345669A - Electronic goods shelf price collection system - Google Patents
Electronic goods shelf price collection system Download PDFInfo
- Publication number
- CN103345669A CN103345669A CN2013102669839A CN201310266983A CN103345669A CN 103345669 A CN103345669 A CN 103345669A CN 2013102669839 A CN2013102669839 A CN 2013102669839A CN 201310266983 A CN201310266983 A CN 201310266983A CN 103345669 A CN103345669 A CN 103345669A
- Authority
- CN
- China
- Prior art keywords
- price
- esl
- data
- database
- esl management
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Cash Registers Or Receiving Machines (AREA)
Abstract
The invention relates to an electronic goods shelf price collection system which is characterized by being formed by a plurality of electronic goods shelf labels, an ESL communication network, an ESL management server, an ESL management database, an ESL management system, a WAN application gateway, a data collection middleware, a price foundation database, a price management system and the like. The electronic goods shelf price collection system overcomes the shortcomings in the prior art, solves a series of problems that a manual price collection method is big in workload, low in efficiency and prone to making mistakes, cannot be monitored and the like, can manage contents displayed by price tickets, can collect and transmit price information to the price management department in real time, and provides data required by decision making for the price management department.
Description
Technical field
The present invention relates to a kind of price acquisition system based on electronic bin tag system.
Background technology
Implementing effectively supervision to decontroling commodity and service price, is the hang-up that faces of price at different levels department for a long time.How balance is carried out the relieving of commodity price and the supervision of service price, is related to the long term growth of price work.Traditional price collection, price regulatory measure significant discomfort are answered demand for development: (1) level of informatization is lower, and great majority still adopt traditional manual operations in each link of price collecting work, and price supervision relies on the staff and sends inspection.There is very big deficiency at aspects such as processing speed, work efficiencies; (2) acquisition means is single, does not set up long-acting oversight mechanisms such as routine monitoring, monitoring in real time, and it is not prompt enough and not comprehensive that a lot of important basis of price data are grasped, for work brings a lot of inconvenience; (3) management has high input, and management can not effectively cover all scopes.Owing to lack effective supervision mechanism and information-based means, range of management extensively causes management to have high input manpower and materials cost height; (4) Sharing degree is not high, a lot of pricing informations, data all be single department using, lack unimpeded channel and offer the department that other need use these resources, cause the duplication of labour, the wasting of resources.
At present, various places all adopt manual method that commodity price information is gathered, and calculate Consumer Prices index (CPI) on this basis.Adopt valency person and hold the commercial investigation catalogue of the valency of need adopting, as multiple daily commodities in use such as rice, edible oil, vegetables, toothpaste, toilet paper, washing powder, every sample commodity are manually asked valency, arrangement and registration.The price that every kind of commodity are gathered according to specification weight is also different, adopts in the valency process very careful.Artificial charting is adopted in most of area, gathers the mode of typing, and some local requirement is adopted valency person and reported by mobile phone short messages.The collecting work amount is big, mistakes and omissions and maloperation appear in picking rate slowly, easily, can't supervise adopt valency person typing whether in time and accurately.
The information system management means have been adopted in some area, Guangzhou price monitor and early warning system reports mode every day on the net by price person, realization is to the supervision of fair-price shop price: shops before 16 o'clock every days again responsible departments of the government's price monitoring website carry second day par shop commodity up and down with reference to retail price, finish second day price adjustment voluntarily; The price person of shops finishes the price collection fixed time every day and uploads pricing information in the OA system." adopting the valency device " of special-purpose band gsm communication used in certain areas, and every kind of commodity instant input behind the valency of asking is adopted in the valency device, sends to statistics bureau or price control department immediately.The valency device of adopting has the GPS location, and whether statistics bureau can monitor at any time adopts valency person at the collection point collection in worksite, has guaranteed the ageing and accuracy of data.
CPI is the relative number of one group of commodity and the change of service item price, is average overall target, and it has reflected the degree of currency inflation (or deflation) to a certain extent, also is to obtain further to calculate on the basis of pricing information at the valency of adopting.A city needs hundreds of to adopt the valency point, has 278 as the valency of the adopting point in the urban district, present Changchun.CPI comprises eight big classes, adopts in the valency actual, compares commodity more frequently for, price movement closely related with resident living, as fresh and alive food such as fresh vegetable, fresh fruits, and price of investigation in per at least 5 days, 2 times-3 times prices are gathered in the investigation in every month of general commodity.
Patent " utilizing the web crawler program to carry out the method that price is collected on the net " (application number: 200410062211.4) designed the method for carrying out the price collection by the web crawler program on the net, towards the Internet web page information search commercial articles pricing information, the commodity price information accuracy deficiency that collects, and be only limited to internet, applications, can not satisfy the collection of entity selling price and pricing information accuracy requirement.
Patent " a kind of goods shelf electronic price system and information processing method " (application number: 201010257420.X), patent " electronic bin tag system, commodity price management devices, mobile terminal device, electronic shelf label device, commodity price management method, commodity price update method, commodity price supervisory routine and commodity price refresh routine " (application number: 200880130913.8) designed the method for electronic shelf label display of commodity price, do not related to the design that price data is gathered.
(application number: 201220055227.2) design is mainly used in the consumer and obtains merchandise news and compare with the consumption data database data patent " a kind of outdoor price gather compare device ", is not for the collection of administrative authority to commodity price data.
Summary of the invention
The object of the present invention is to provide a kind of electronic bin price acquisition system, this price acquisition system has overcome the prior art deficiency, a series of problems such as workload is big in the artificial price acquisition method, efficient is low, make mistakes easily, can't supervise have been solved, can manage the price tickets displaying contents, and pricing information collected price control department in real time, for administrative authority provides decision-making required data.
Technical scheme of the present invention is achieved in that
A kind of electronic bin price acquisition system, it is characterized in that: comprise several electronic shelf labels, ESL communication network, ESL management server, ESL management database, ESL management system, WAN application gateway, Data-collection middleware, basis of price database, price control system, wherein
Described each electronic shelf label is connected communication by the ESL communication network with the ESL management server, obtaining more new data and update displayed content from the ESL management server, and each electronic shelf label sends confirmation and gives the ESL management server after upgrading successfully;
Described ESL communication network obtains the more new data that the ESL management server sends, and is forwarded to corresponding electronic shelf label on request, and this ESL communication network receives electronic shelf label and sends information simultaneously, is transmitted to the ESL management server after remittance is whole;
Described ESL management server is connected communication with ESL management database, WAN application gateway, and this ESL management server is realized corresponding inquiry and in-stockroom operation to ESL management database transmit operation order;
Described ESL management system is connected communication with the ESL management database, safeguards with the realization to data in the ESL management database;
Described WAN application gateway is connected communication with the ESL management database, sends Data-collection middleware with the data with the ELS management database to by the internet;
Described Data-collection middleware is connected communication with the basis of price database, deposits the basis of price database in after will receiving next data preparation;
Described price control system is connected communication with the basis of price database, and this price control system reads commodity price information from the basis of price database, and the information that reads is analyzed and put in order.
Beneficial effect of the present invention: native system can manage the price demonstration, in conjunction with data communication means, realize the remote collection of commodity price data---commodity price and ESL displaying contents are set in the ESL management system, transmitting more by wire/radio network, new data is sent to electronic shelf label and shows, simultaneously behind the display update, price data transmits by the internet and is saved in the basis of price database, can analyze and handle price data by the price control system.Native system has overcome the prior art deficiency, a series of problems such as workload is big in the artificial price acquisition method, efficient is low, make mistakes easily, can't supervise have been solved, can manage the price tickets displaying contents, and pricing information collected price control department in real time, for administrative authority provides decision-making required data.
Description of drawings
Fig. 1 is theory structure schematic block diagram of the present invention.
Fig. 2 expands theory structure schematic block diagram after the application for the present invention.
Specific embodiment
To help to understand the present invention by example.But do not limit content of the present invention.All distortion that those of ordinary skill in the art can directly derive or associate from content disclosed by the invention all should be thought protection scope of the present invention.
For realizing purpose of the present invention, a kind of electronic bin price acquisition system of the present invention, as shown in Figure 1, it comprises several electronic shelf labels 1, ESL communication network 2, ESL management server 3, ESL management database 4, ESL management system 5, WAN application gateway 6, Data-collection middleware 7, basis of price database 8, price control system 9, wherein
Described each electronic shelf label 1 is connected communication by ESL communication network 2 with ESL management server 3, obtaining more new data and update displayed content from ESL management server 3, and each electronic shelf label 1 sends confirmation and gives ESL management server 3 after upgrading successfully.Described ESL communication network 2 is the aggregate of communication network and communication facilities, and wherein said communication network is wired or wireless or wired and wireless hybrid network, and described communication facilities is embedded hardware system or general purpose type computer system.Described ESL communication network 2 constitutes by a plurality of hardware devices and communication protocol according to actual environment (network topology, scale) configuration.Described ESL communication network 2 obtains the more new data that the ESL management server sends, be forwarded to corresponding electronic shelf label 1 on request, this ESL communication network 2 receives electronic shelf label 1 and sends information (as information such as state, renewal affirmations) simultaneously, is transmitted to ESL management server 3 after remittance is whole.
Described ESL management server 3 is connected communication with ESL management database 4, WAN application gateway 6, and this ESL management server 3 is realized corresponding inquiry and in-stockroom operation to the 4 transmit operation orders of ESL management database.Specifically be, use the communication protocol of IEEE 802.3 or IEEE 802.11 to communicate between described ESL management server 3 and the ESL communication network 2, ESL management server 3 is receiving inquiry or the storage request that ESL communication network 2 sends, ESL management server 3 is by modes such as ODBC data-interface, JDBC data-interfaces, based on ICP/IP protocol communication, to the 4 transmit operation orders of ESL management database, realize corresponding inquiry and in-stockroom operation.According to request, ESL management server 3 reads the data in the ESL management database 4, is sent to ESL communication network 2 then.ESL management server 3 receives electronic shelf label 1 and upgrades successful information, preserves data to ESL management database 4.
Described each electronic shelf label 1 is the embedded hardware system, and it communicates by wireless mode or wired mode and ESL communication network 2.Electronic shelf label 1 can have multiple screen size and specification, and also available different technology (LCD, Electronic Paper) is made.
Described ESL management system 5 is connected communication with ESL management database 4, safeguards with the realization to data in the ESL management database 4.The user can realize the maintenance of data in the ESL management database 4 comprising interpolation, deletion, the modification of ESL equipment, functions such as ESL displaying contents (price, title etc.) management by ESL management system 5.
Described WAN application gateway 6 is connected communication with ESL management database 4, communicate by ODBC data-interface or JDBC data-interface and based on ICP/IP protocol between described ESL management database 4 and the WAN application gateway 6, send Data-collection middleware 7 with the data with ELS management database 4 to by internet 10.Described Data-collection middleware 7 is connected communication with basis of price database 8, deposits basis of price database 8 in after will receiving next data preparation.Described WAN application gateway 6 is the embedded hardware system, between this WAN application gateway 6 and the Data-collection middleware 7 by the internet, communicate based on ICP/IP protocol.Described Data-collection middleware 7 is embedded hardware system or the hardware system that software systems are installed, and this Data-collection middleware 7 and basis of price database 8 are by internet or LAN (Local Area Network), communicate based on ICP/IP protocol.Described Data-collection middleware 7 can place on the internet, carries out tcp/ip communication with the WAN application gateway 6 of a plurality of marketing units, receives pricing informations with the WAN application gateway 6 from zones of different, different marketing units, deposits basis of price database 8 after the arrangement in.In addition, described basis of price database 8 can place on the internet, also can place with Data-collection middleware 7 and be in the same LAN (Local Area Network), basis of price database 8 and Data-collection middleware 7 communicate by TCP/IP, for Data-collection middleware 7, price control system 9 provide data storage and inquiry service.
Described price control system 9 is connected communication with basis of price database 8, this price control system 9 reads commodity price information from basis of price database 8, and the information that reads analyzed and put in order, comprise functions such as price data inquiry, statistical report form, data analysis derivation, corresponding service processing, and correlation function also can be expanded flexibly with business, namely as shown in Figure 2, basis of price database 8 and CPI analytic system 20, can realize CPI data analysis and statistics, satisfy the application needs of CPI administrative authority.In addition, between described price control system 9 and the basis of price database 8 be utilize ODBC data-interface or JDBC data-interface, by internet or LAN (Local Area Network), communicate based on ICP/IP protocol.
In the present embodiment, each system development technology and content are:
Electronic shelf label 1 comprises power module, 2.4G communication module, 2.1 " the Electronic Paper display module; power module adopts the lithium battery power supply of 430mAH; the 2.4G communication module adopts CC2540 Soc or the CC2530 Soc chip of America NI company, and this chip combines 8051 kernels, Zigbee protocol stack or bluetooth BLE protocol stack and the 2.4G wireless communication module of standard; 2.1 " the Electronic Paper display module is that resolution is the dot matrix Electronic Paper of 172*72 and the module of the integrated encapsulation of driving circuit, be connected with CC2540 Soc or CC2530 Soc by the SPI interface.
WAN application gateway 6, ESL management server 3 and Data-collection middleware 7 adopt the JAVA technological development.
ESL management database 4 uses the FireBird Database Systems, adopts the JDBC data-interface to communicate and visit based on ICP/IP protocol.Basis of price database 8 uses the Oracle system database, adopts the JDBC data-interface to communicate and visit based on ICP/IP protocol.
Described ESL management server 3, ESL management database 4, ESL management system 5, WAN application gateway 6 are to divide according to logic function, can according to circumstances be deployed in flexibly in one or more hardware systems in the reality exploitation.In the scheme as shown in Figure 2, ESL management system 5 is to be arranged in the ESL management server 3 with ESL management database 4, shares a hardware system with ESL management server 3.
(1) interpolation of ESL equipment, deletion, modification;
(2) modification of ESL displaying contents (price, title etc.);
(3) Classification Management;
(4) upgrade record queries;
(5) ESL indicating template management;
(6) keeper and rights management etc.
(1) interpolation of ESL equipment, deletion, modification;
(2) ESL devices allocation;
(3) marketing unit's management;
(4) price updating record queries;
(5) pricing information statistical study;
(6) data derive;
(7) keeper and rights management etc.
The course of work of the present invention is as follows: the sales management personnel increase/revise commodity price newly in the ESL management system, change ESL shows information, and deposit pricing information and displaying contents in the ESL management database; Electronic shelf label sends status information by the ESL communication network to the ESL management server, the report running status; Whether the ESL management server queries has the electronic shelf label of duty displaying contents to be updated, if any, corresponding displays content data is forwarded to the target electronic shelf label by the ESL communication network; Electronic shelf label update displayed content, with operating result and feedback of status to the ESL management server; The ESL management server receives the electronic shelf label status information, deposits execution result (success, failure etc.) in the ESL management database; The WAN application gateway regularly will upgrade the Data-collection middleware that successful price data (trade name, price movement, time etc.) is reported to the internet; Data-collection middleware receives and puts the data that each price collection point sends in order, deposits the basis of price database in.
Claims (9)
1. electronic bin price acquisition system, it is characterized in that: comprise several electronic shelf labels (1), ESL communication network (2), ESL management server (3), ESL management database (4), ESL management system (5), WAN application gateway (6), Data-collection middleware (7), basis of price database (8), price control system (9), wherein
Described each electronic shelf label (1) is connected communication by ESL communication network (2) with ESL management server (3), obtaining more new data and update displayed content from ESL management server (3), and each electronic shelf label (1) sends confirmation and gives ESL management server (3) after upgrading successfully;
Described ESL communication network (2) obtains the more new data that ESL management server (3) sends, be forwarded to corresponding electronic shelf label (1) on request, this ESL communication network (2) receives electronic shelf label (1) and sends information simultaneously, is transmitted to ESL management server (3) after remittance is whole;
Described ESL management server (3) is connected communication with ESL management database (4), WAN application gateway (6), and this ESL management server (3) is realized corresponding inquiry and in-stockroom operation to ESL management database (4) transmit operation order;
Described ESL management system (5) is connected communication with ESL management database (4), safeguards with the realization to data in the ESL management database (4);
Described WAN application gateway (6) is connected communication with ESL management database (4), sends Data-collection middleware (7) with the data with ELS management database (4) to by internet (10);
Described Data-collection middleware (7) is connected communication with basis of price database (8), deposits basis of price database (8) in after will receiving next data preparation;
Described price control system (9) is connected communication with basis of price database (8), and this price control system (9) reads commodity price information from basis of price database (8), and the information that reads is analyzed and put in order.
2. according to the described electronic bin price of claim 1 acquisition system, it is characterized in that: described each electronic shelf label (1) is for the embedded hardware system, and it communicates by wireless mode or wired mode and ESL communication network (2).
3. according to the described electronic bin price of claim 1 acquisition system, it is characterized in that: described ESL communication network (2) is the aggregate of communication network and communication facilities, wherein said communication network is wired or wireless or wired and wireless hybrid network, and described communication facilities is embedded hardware system or general purpose type computer system.
4. according to the described electronic bin price of claim 1 acquisition system, it is characterized in that: described ESL management server (3) communicates by wired or wireless LAN and based on IEEE 802.3 or IEEE 802.11 communication protocols with ESL management database (4), and described ESL management server (3) communicates by LAN protocol with ESL communication network (2).
5. according to the described electronic bin price of claim 1 acquisition system, it is characterized in that: communicate by ODBC data-interface or JDBC data-interface and based on ICP/IP protocol between described ESL management database (4) and ESL management server (3), ESL management system (5), the WAN application gateway (6).
6. according to the described electronic bin price of claim 5 acquisition system, it is characterized in that: described WAN application gateway (6) is for the embedded hardware system, and this WAN application gateway (6) and Data-collection middleware (7) are by the internet, communicate based on ICP/IP protocol.
7. according to the described electronic bin price of claim 6 acquisition system, it is characterized in that: described Data-collection middleware (7) is for the embedded hardware system or the hardware system of software systems is installed, and this Data-collection middleware (7) and basis of price database (8) are by internet or LAN (Local Area Network), communicate based on ICP/IP protocol.
8. according to the described electronic bin price of claim 1 acquisition system, it is characterized in that: described basis of price database (8) and price control system (9) are by internet or LAN (Local Area Network), communicate based on ICP/IP protocol.
9. described electronic bin price acquisition system according to Claim 8 is characterized in that: described price control system (9) and basis of price database (8) utilize ODBC data-interface or JDBC data-interface, by internet or LAN (Local Area Network), communicate based on ICP/IP protocol.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013102669839A CN103345669A (en) | 2013-06-29 | 2013-06-29 | Electronic goods shelf price collection system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013102669839A CN103345669A (en) | 2013-06-29 | 2013-06-29 | Electronic goods shelf price collection system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103345669A true CN103345669A (en) | 2013-10-09 |
Family
ID=49280464
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2013102669839A Pending CN103345669A (en) | 2013-06-29 | 2013-06-29 | Electronic goods shelf price collection system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103345669A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103745360A (en) * | 2013-12-30 | 2014-04-23 | 镇江市高等专科学校 | Electronic price tag for goods shelf |
| CN107146063A (en) * | 2017-07-13 | 2017-09-08 | 卢竹林 | Intelligent commodity shelf system, WMS and goods exhibition management system |
| CN107708181B (en) * | 2017-10-24 | 2021-01-05 | 佛山市广华合志科技有限公司 | Data communication system, electronic shelf label system and communication method thereof |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101930460A (en) * | 2010-08-19 | 2010-12-29 | 杭州中瑞思创科技股份有限公司 | Goods shelf electronic price system and information processing method |
| CN102254199A (en) * | 2010-05-18 | 2011-11-23 | 东芝泰格有限公司 | Electronic shelf label control apparatus and method |
-
2013
- 2013-06-29 CN CN2013102669839A patent/CN103345669A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102254199A (en) * | 2010-05-18 | 2011-11-23 | 东芝泰格有限公司 | Electronic shelf label control apparatus and method |
| CN101930460A (en) * | 2010-08-19 | 2010-12-29 | 杭州中瑞思创科技股份有限公司 | Goods shelf electronic price system and information processing method |
Non-Patent Citations (1)
| Title |
|---|
| 孙寒玉殊: "《物价采集监测管理系统设计与实现》", 《中国优秀硕士学位论文全文数据库信息科技辑》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103745360A (en) * | 2013-12-30 | 2014-04-23 | 镇江市高等专科学校 | Electronic price tag for goods shelf |
| CN107146063A (en) * | 2017-07-13 | 2017-09-08 | 卢竹林 | Intelligent commodity shelf system, WMS and goods exhibition management system |
| CN107708181B (en) * | 2017-10-24 | 2021-01-05 | 佛山市广华合志科技有限公司 | Data communication system, electronic shelf label system and communication method thereof |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Georgakopoulos et al. | Internet of things: from internet scale sensing to smart services | |
| Gao et al. | Mapping county-level mobility pattern changes in the United States in response to COVID-19 | |
| Rahmani et al. | Internet of things applications: opportunities and threats | |
| US8094029B2 (en) | System for monitoring and recording hand hygiene performance | |
| CN109800250B (en) | System architecture for no longer configuring enterprise central server | |
| CN203012789U (en) | Intelligent storage control system | |
| CN104777813A (en) | Comprehensive meteorological observation operation monitoring system and monitoring method thereof | |
| CN103440560A (en) | Commodity price collecting and monitoring method | |
| CN103559576A (en) | Energy management system | |
| CN203968152U (en) | A kind of automatic vending machine supervisory systems based on cloud computing | |
| CN202373029U (en) | Commodity circulation tracing system | |
| CN101609610A (en) | A kind of Flight Information data acquisition unit and disposal route thereof | |
| CN202094938U (en) | Web-based wireless temperature and humidity monitoring network | |
| CN101931645A (en) | Wireless temperature-humidity monitoring system based on Web | |
| CN103337115B (en) | A kind of price collection system based on POS marketing system | |
| CN104268770A (en) | Supermarket visiting customer characteristic analysis system | |
| CN104063766A (en) | Building energy efficiency management system based on cloud computing and big data technology | |
| CN105160477A (en) | RFID-based geographical position simulation positioning method and asset equipment management system using the method | |
| CN108073996B (en) | Urban energy panoramic interactive big data platform management system and method | |
| CN109118256A (en) | A kind of commodity traceability system based on two dimensional code | |
| CN103345669A (en) | Electronic goods shelf price collection system | |
| US20140222538A1 (en) | Customer experience management for an organization | |
| CN113743547B (en) | Asset supervision method and platform based on RFID tag and storage medium | |
| CN103455876A (en) | Commodity price supervisory system based on electronic shelf labels | |
| Soyemi et al. | A Web-based Decision Support System with SMS-based Technology for Agricultural Information and Weather Forecasting |
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: 20131009 |