CN102393935A - Wireless inventory verification system based on database synchronization - Google Patents
Wireless inventory verification system based on database synchronization Download PDFInfo
- Publication number
- CN102393935A CN102393935A CN2011101913225A CN201110191322A CN102393935A CN 102393935 A CN102393935 A CN 102393935A CN 2011101913225 A CN2011101913225 A CN 2011101913225A CN 201110191322 A CN201110191322 A CN 201110191322A CN 102393935 A CN102393935 A CN 102393935A
- Authority
- CN
- China
- Prior art keywords
- data
- inventory
- database
- stock
- data synchronization
- 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
Abstract
A wireless inventory verification system based on database synchronization relates to a wireless inventory verification device. The wireless inventory verification system comprises a main database of a supermarket inventory management system, a data synchronism server of an inventory system, and inventory systems. The supermarket inventory management system is connected with the data synchronism server of the inventory system, and the data synchronism server of the inventory system is connected with a plurality of inventory systems. The supermarket inventory verification is easily achieved without network, and the inventory data is easily uploaded under the unobstructed wireless network to replace the conventional paper and pen copying and manual entering, thereby the efficiency is increased greatly and the inventory accuracy is improved.
Description
Technical field
The present invention relates to the supermarket wireless check system, be specifically related to a kind of supermarket wireless check system of taking intermediate database to carry out the data interaction caching technology.
Background technology
The management difficult point in supermarket (retailer) is that range of goods is abundant, the quantity bulky complex, and this difficult point is more outstanding during particularly in the face of stock-taking.In the daily operation in supermarket, make an inventory be one the most numerous and diverse, take time most and the operation of manpower, but enterprise operation achievement and profit and loss must could check via the operation of making an inventory, we can say that it is a yardstick of weighing the standard of supermarket management quality.Make an inventory and play crucial effects in the whole running that is operated in the supermarket.Kinds of goods is of a great variety in the supermarket, and renewal speed is fast, if can not guarantee correct stocking up and stock's control and delivery, will cause the increase of managerial cost, and service quality is difficult to be guaranteed, thereby influences Enterprises'Competitiveness.Simple, the static storehouse management of tradition can't guarantee the efficient utilization of ERM.
The supermarket traditional hand is made an inventory and is adopted the artificial memory, copies registration through paper and pen, not only time and effort consuming, also error rate height.Thereby the purpose of making an inventory in the supermarket is in order to find out the running situation (like the proportion of goods damageds, turnover rate etc.) that actual store quantity analyzes enterprise, and the management decision that out of true or untimely inventory data possibly cause enterprise to make mistake or lag behind.
Summary of the invention
The purpose of this invention is to provide a kind of wireless stock-taking system based on database synchronization; It can easily realize the supermarket stock-taking under the situation of no network; And the uploading of the data that under the unobstructed condition of wireless network, easily realize making an inventory; Substituted that traditional paper and pen is copied, manual typing, not only improved efficient greatly, also improved the accuracy of making an inventory.
In order to solve the existing problem of background technology; The present invention adopts following technical scheme: it comprises supermarket goods entry, stock and sales system MDL, check system data synchronization server and check system; Goods entry, stock and sales system MDL in supermarket is connected with the check system data synchronization server, and the check system data synchronization server is connected with several check systems.
Described check system data synchronization server comprises data backstage service routine, intermediate database and data synchronization service; Data backstage service routine is connected with intermediate database through the ODBC interface; Intermediate database is connected with data synchronization service, and data backstage service routine is connected with supermarket goods entry, stock and sales system MDL through the OLEDB interface.
Described check system comprises intelligence make an inventory program and embedded database, and the intelligence program of making an inventory takes direct-connected mode to be connected with embedded database, and the intelligence program of making an inventory is connected with data synchronization service through Wi-Fi.
Intermediate database of the present invention; Be used for data cached; The goods entry, stock and sales system MDL that wherein has the supermarket to use need download to the data of making an inventory the machine embedded database, and the machine embedded database of making an inventory in addition need upload to the data of supermarket goods entry, stock and sales system MDL; Data backstage service routine operates on the desktop computer, is used for dissimilar supermarket goods entry, stock and sales data layouts is carried out intelligent conversion, and regularly data is write intermediate database and the intermediate database content read and write back; Data synchronization server is used to realize intermediate database and the data sync of making an inventory the machine embedded database; Run on the check system on the intelligent handheld device, this system supports embedded database, the collection of the data that realize making an inventory and with data synchronization server communication the uploading of data of realizing making an inventory.
Data of the present invention are downloaded workflow:
1, data backstage service routine reads the commodity basic document of supermarket goods entry, stock and sales system MDL, is written in the intermediate database;
2, the intelligence program of making an inventory is sent data synchronization request to data synchronization service;
3, data synchronization service response;
4, data synchronization service reads the intermediate data database data, sends to the intelligence program of making an inventory with the data stream mode;
5, the intelligence program of making an inventory writes the download that embedded database is accomplished data with the data stream that receives.
Data upload workflow of the present invention is:
1, the intelligence program of making an inventory reads the data of making an inventory in the embedded database;
2, the intelligence program of making an inventory is sent data synchronization request to data synchronization service;
3, data synchronization service feedback synchronizing signal;
4, the intelligence program of making an inventory sends data to data synchronization service with the data stream mode;
5, data synchronization service writes data in the intermediate database;
6, data backstage service routine reads the intermediate data database data and is written in the supermarket goods entry, stock and sales system MDL, accomplishes uploading of data.
The present invention has following beneficial effect:
1, adopt the Synchronization Technology of Mobile Database of judging according to timestamp to realize data transmission;
2, set up intermediate database and be used for metadata cache;
3, the hand held device software system uses embedded database storage commodity archives and firm offer data;
4, pass through the wireless data transmission of TCPIP agreement;
5, report the voice voice during input disc number of spots automatically, play foolproof function;
Whether intelligent decision was imported by mistake when 6, firm offer quantity was excessive;
When 7, making an inventory the data typing with the commodity quantity that adds up automatically;
8, the inquiry inventory of having made an inventory can be reviewed by system.
Description of drawings:
Fig. 1 is a structural representation of the present invention.
Embodiment:
With reference to Fig. 1; This embodiment adopts following technical scheme: it comprises supermarket goods entry, stock and sales system MDL 1, check system data synchronization server and check system; Goods entry, stock and sales system MDL 1 in supermarket is connected with the check system data synchronization server, and the check system data synchronization server is connected with several check systems.
Described check system data synchronization server comprises data backstage service routine 101, intermediate database 102 and data synchronization service 103; Data backstage service routine 101 is connected with intermediate database 102 through the ODBC interface; Intermediate database 102 is connected with data synchronization service 103, and data backstage service routine 101 is connected with supermarket goods entry, stock and sales system MDL 1 through the OLEDB interface.
Described check system comprises intelligence make an inventory program 201 and embedded database 202, and the intelligence program 201 of making an inventory takes direct-connected mode to be connected with embedded database 202, and the intelligence program 201 of making an inventory is passed through Wi-Fi and is connected with data synchronization service 103.
Described intermediate database 102 adopts Sybase SQL Anywhere 10.
Described data synchronization service 103 adopts Sybase MobiLink 10 middlewares.
Described embedded database 202 adopts UltraLite 10.
The intermediate database 102 of this embodiment; Be used for data cached; The goods entry, stock and sales system MDL that wherein has the supermarket to use need download to the data of making an inventory machine embedded database 202, and the machine embedded database 202 of making an inventory in addition need upload to the data of supermarket goods entry, stock and sales system MDL 1; Data backstage service routine 101 operates on the desktop computer, is used for dissimilar supermarket goods entry, stock and sales data layouts is carried out intelligent conversion, and regularly data is write intermediate database 102 and intermediate database 102 contents are read and write back; Data synchronization server 103 is used to realize intermediate database and the data sync of making an inventory the machine embedded database; Run on the check system on the intelligent handheld device, this system supports embedded database, the collection of the data that realize making an inventory and with data synchronization server communication the uploading of data of realizing making an inventory.
This embodiment data are downloaded workflow:
1, data backstage service routine 101 reads the commodity basic document of supermarket goods entry, stock and sales system MDL 1, is written in the intermediate database 102;
2, intelligence is made an inventory program 201 to data synchronization service 103 transmission data synchronization request;
3, data synchronization service 103 responses;
4, data synchronization service 103 reads intermediate database 102 data, sends to the intelligence program 201 of making an inventory with the data stream mode;
5, the intelligence program 201 of making an inventory writes the download that embedded database 202 is accomplished data with the data stream that receives.
This embodiment data upload workflow is:
1, the intelligence program 201 of making an inventory reads the data of making an inventory in the embedded database 202;
2, intelligence is made an inventory program 201 to data synchronization service 103 transmission data synchronization request;
3, data synchronization service 103 feedback synchronizing signals;
4, the intelligence program 201 of making an inventory sends data to data synchronization service 103 with the data stream mode;
5, data synchronization service 103 writes data in the intermediate database 102;
6, data backstage service routine 101 reads intermediate database 102 data and is written in the supermarket goods entry, stock and sales system MDL 1, accomplishes uploading of data.
This embodiment can easily realize the supermarket stock-taking under the situation of no network; And the uploading of the data that under the unobstructed condition of wireless network, easily realize making an inventory; Substituted that traditional paper and pen is copied, manual typing, not only improved efficient greatly, also improved the accuracy of making an inventory.Database synchronization is a kind of technical method that data are duplicated of between disparate databases, realizing, database synchronization adopts timestamp as the Data Update sign efficiently, guarantees in synchronous process that like this transmission minimal data amount reaches the highest efficient.This technology is particularly suitable for the huge supermarket enterprise of data volume and makes an inventory, and combines invalid transmission again, can convenient, stock-taking method efficiently be provided for the user.
Claims (8)
1. based on the wireless stock-taking system of database synchronization; It is characterized in that it comprises supermarket goods entry, stock and sales system MDL (1), check system data synchronization server and check system; Supermarket goods entry, stock and sales system MDL (1) is connected with the check system data synchronization server, and the check system data synchronization server is connected with several check systems.
2. the wireless stock-taking system based on database synchronization according to claim 1; It is characterized in that described check system data synchronization server comprises data backstage service routine (101), intermediate database (102) and data synchronization service (103); Data backstage service routine (101) is connected with intermediate database (102) through the ODBC interface; Intermediate database (102) is connected with data synchronization service (103), and data backstage service routine (101) is connected with supermarket goods entry, stock and sales system MDL (1) through the OLEDB interface.
3. the wireless stock-taking system based on database synchronization according to claim 1; It is characterized in that described check system comprises intelligence make an inventory program (201) and embedded database (202); The intelligence program (201) of making an inventory takes direct-connected mode to be connected with embedded database (202), and the intelligence program (201) of making an inventory is connected with data synchronization service (103) through Wi-Fi.
4. the wireless stock-taking system based on database synchronization according to claim 1; It is characterized in that data download workflow is: data backstage service routine (101) reads the commodity basic document of supermarket goods entry, stock and sales system MDL (1), is written in the intermediate database (102); Intelligence is made an inventory program (201) to data synchronization service (103) transmission data synchronization request; Data synchronization service (103) response; Data synchronization service (103) reads intermediate database (102) data, sends to the intelligence program (201) of making an inventory with the data stream mode; The intelligence program (201) of making an inventory writes the download that embedded database (202) is accomplished data with the data stream that receives.
5. the wireless stock-taking system based on database synchronization according to claim 1 is characterized in that the data upload workflow is: the intelligence program (201) of making an inventory reads the data of making an inventory in the embedded database (202); Intelligence is made an inventory program (201) to data synchronization service (103) transmission data synchronization request; Data synchronization service (103) feedback synchronizing signal; The intelligence program (201) of making an inventory sends data to data synchronization service (103) with the data stream mode; Data synchronization service (103) writes data in the intermediate database (102); Data backstage service routine (101) reads intermediate database (102) data and is written in the supermarket goods entry, stock and sales system MDL (1), accomplishes uploading of data.
6. the wireless stock-taking system based on database synchronization according to claim 1 is characterized in that described intermediate database (102) adopts Sybase SQL Anywhere 10.
7. the wireless stock-taking system based on database synchronization according to claim 1 is characterized in that described data synchronization service (103) adopts Sybase MobiLink 10 middlewares.
8. the wireless stock-taking system based on database synchronization according to claim 1 is characterized in that described embedded database (202) adopts UltraLite 10.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011101913225A CN102393935A (en) | 2011-07-08 | 2011-07-08 | Wireless inventory verification system based on database synchronization |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011101913225A CN102393935A (en) | 2011-07-08 | 2011-07-08 | Wireless inventory verification system based on database synchronization |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102393935A true CN102393935A (en) | 2012-03-28 |
Family
ID=45861251
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011101913225A Pending CN102393935A (en) | 2011-07-08 | 2011-07-08 | Wireless inventory verification system based on database synchronization |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102393935A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104778574A (en) * | 2015-04-27 | 2015-07-15 | 苏州航瑞成自动化科技有限公司 | Intelligent management system and intelligent management cabinet thereof |
| CN105117881A (en) * | 2015-08-21 | 2015-12-02 | 山东协通通信技术有限公司 | Inventory system suitable for medium and small sized supermarkets |
| CN107123178A (en) * | 2016-01-22 | 2017-09-01 | 安朗杰安防技术（中国）有限公司 | Access control system |
| CN107392712A (en) * | 2017-07-21 | 2017-11-24 | 罗宝丰 | A kind of purchase, sales and inventory management system and its application method |
| CN107730191A (en) * | 2017-11-27 | 2018-02-23 | 中山路得斯空调有限公司 | A kind of safe shared interconnection type inventory management system |
| CN109767159A (en) * | 2018-12-26 | 2019-05-17 | 广州联欣信息科技有限公司 | A kind of wireless inventory checking method, computer readable storage medium and the terminal of cargo |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1384640A (en) * | 2001-04-30 | 2002-12-11 | 亚奇诺信息顾问股份有限公司 | Embedded selling-time management system for data transmission via Internet |
| CN101702194A (en) * | 2009-09-27 | 2010-05-05 | 东莞市树煜智能图书设备科技有限公司 | Fully automatic article checking device |
| CN101794226A (en) * | 2010-03-08 | 2010-08-04 | 山东大学 | Service software construction method and system adapting to multiple business abstraction levels |
-
2011
- 2011-07-08 CN CN2011101913225A patent/CN102393935A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1384640A (en) * | 2001-04-30 | 2002-12-11 | 亚奇诺信息顾问股份有限公司 | Embedded selling-time management system for data transmission via Internet |
| CN101702194A (en) * | 2009-09-27 | 2010-05-05 | 东莞市树煜智能图书设备科技有限公司 | Fully automatic article checking device |
| CN101794226A (en) * | 2010-03-08 | 2010-08-04 | 山东大学 | Service software construction method and system adapting to multiple business abstraction levels |
Non-Patent Citations (1)
| Title |
|---|
| 郭旭展: "《基于.NET技术的移动库存管理系统研究与实现》", 《中文硕士论文全文数据库（电子期刊）》 * |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104778574A (en) * | 2015-04-27 | 2015-07-15 | 苏州航瑞成自动化科技有限公司 | Intelligent management system and intelligent management cabinet thereof |
| CN104778574B (en) * | 2015-04-27 | 2019-08-16 | 苏州航瑞成自动化科技有限公司 | A kind of intelligent management system and its Intelligent management cabinet |
| CN105117881A (en) * | 2015-08-21 | 2015-12-02 | 山东协通通信技术有限公司 | Inventory system suitable for medium and small sized supermarkets |
| CN107123178A (en) * | 2016-01-22 | 2017-09-01 | 安朗杰安防技术（中国）有限公司 | Access control system |
| CN107123178B (en) * | 2016-01-22 | 2019-12-31 | 安朗杰安防技术（中国）有限公司 | Access control system |
| CN107392712A (en) * | 2017-07-21 | 2017-11-24 | 罗宝丰 | A kind of purchase, sales and inventory management system and its application method |
| CN107392712B (en) * | 2017-07-21 | 2021-06-29 | 罗宝丰 | Purchase, sales and inventory management system and using method thereof |
| CN107730191A (en) * | 2017-11-27 | 2018-02-23 | 中山路得斯空调有限公司 | A kind of safe shared interconnection type inventory management system |
| CN109767159A (en) * | 2018-12-26 | 2019-05-17 | 广州联欣信息科技有限公司 | A kind of wireless inventory checking method, computer readable storage medium and the terminal of cargo |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102393935A (en) | Wireless inventory verification system based on database synchronization | |
| CN101576918B (en) | Data buffering system with load balancing function | |
| CN101410816B (en) | Background transcoding | |
| CN102999584B (en) | The cross-platform spatial data services method and system of electric power GIS | |
| WO2017028514A1 (en) | Method and device for storing and reading data | |
| CN101681344A (en) | Bi-directional data modification with synchronization | |
| CN102752372A (en) | File based database synchronization method | |
| CN102609488B (en) | Client, data query method of client, server and data query system | |
| CN109919691B (en) | Data processing system, method and device | |
| CN102063500A (en) | Data migration method and device | |
| CN102521246A (en) | Cloud data warehouse system | |
| CN101082927A (en) | File services method based on ContextFS context file systems | |
| CN110688399A (en) | Stream type calculation real-time report system and method | |
| CN102508854A (en) | Data access device and method | |
| CN104462185A (en) | Digital library cloud storage system based on mixed structure | |
| CN104778229A (en) | Telecommunication service small file storage system and method based on Hadoop | |
| CN101650744A (en) | System and method for processing great data amount based on transport tablespace | |
| CN112380227B (en) | Data synchronization method, device, equipment and storage medium based on message queue | |
| CN103164525A (en) | Method and device for WEB application release | |
| CN103927344A (en) | Data integration method | |
| CN104834635A (en) | Data processing method and device | |
| CN101888393A (en) | Non-uniform cooperative system and method based on component middleware platforms under network environment | |
| CN112579567A (en) | MinIO-based industrial quality inspection file distributed storage system and method | |
| CN107665224A (en) | Scan the mthods, systems and devices of HDFS cold datas | |
| US20240004851A1 (en) | Systems and methods for creating a reorganization-immune blockchain index using mono-increasing sequence records |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20120328 |