CN106326494A - Intelligent fool-proofing charging system and method based on Internet - Google Patents
Intelligent fool-proofing charging system and method based on Internet Download PDFInfo
- Publication number
- CN106326494A CN106326494A CN201610853458.0A CN201610853458A CN106326494A CN 106326494 A CN106326494 A CN 106326494A CN 201610853458 A CN201610853458 A CN 201610853458A CN 106326494 A CN106326494 A CN 106326494A
- Authority
- CN
- China
- Prior art keywords
- station
- data
- cable
- computer
- fool proof
- 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
- 238000000034 method Methods 0.000 title claims abstract description 55
- 230000008569 process Effects 0.000 claims abstract description 28
- 238000004519 manufacturing process Methods 0.000 claims abstract description 23
- 239000000463 material Substances 0.000 claims abstract description 21
- 238000004891 communication Methods 0.000 claims abstract description 10
- 238000006243 chemical reaction Methods 0.000 claims description 4
- 230000005611 electricity Effects 0.000 claims description 3
- 235000021050 feed intake Nutrition 0.000 claims description 3
- 238000012790 confirmation Methods 0.000 claims description 2
- 238000009472 formulation Methods 0.000 claims description 2
- 239000000203 mixture Substances 0.000 claims description 2
- 238000005303 weighing Methods 0.000 claims description 2
- 238000004886 process control Methods 0.000 claims 1
- 238000011161 development Methods 0.000 abstract description 9
- 238000012423 maintenance Methods 0.000 abstract description 6
- 230000000007 visual effect Effects 0.000 abstract 1
- 238000013461 design Methods 0.000 description 27
- 230000006870 function Effects 0.000 description 19
- 238000010586 diagram Methods 0.000 description 9
- 230000018109 developmental process Effects 0.000 description 8
- 230000008859 change Effects 0.000 description 7
- 230000004044 response Effects 0.000 description 7
- 238000005516 engineering process Methods 0.000 description 6
- 238000007726 management method Methods 0.000 description 6
- 238000004458 analytical method Methods 0.000 description 5
- 238000013499 data model Methods 0.000 description 5
- 230000000694 effects Effects 0.000 description 5
- 238000003860 storage Methods 0.000 description 5
- 238000012545 processing Methods 0.000 description 4
- 230000008901 benefit Effects 0.000 description 3
- 230000000875 corresponding effect Effects 0.000 description 3
- 230000035800 maturation Effects 0.000 description 3
- 238000012544 monitoring process Methods 0.000 description 3
- 238000005457 optimization Methods 0.000 description 3
- 238000012795 verification Methods 0.000 description 3
- RTZKZFJDLAIYFH-UHFFFAOYSA-N Diethyl ether Chemical compound CCOCC RTZKZFJDLAIYFH-UHFFFAOYSA-N 0.000 description 2
- 230000009471 action Effects 0.000 description 2
- 238000007405 data analysis Methods 0.000 description 2
- 239000000945 filler Substances 0.000 description 2
- 239000000126 substance Substances 0.000 description 2
- 241000196324 Embryophyta Species 0.000 description 1
- 235000012364 Peperomia pellucida Nutrition 0.000 description 1
- 240000007711 Peperomia pellucida Species 0.000 description 1
- 208000027418 Wounds and injury Diseases 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 229910002056 binary alloy Inorganic materials 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 230000002596 correlated effect Effects 0.000 description 1
- 230000006378 damage Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000000354 decomposition reaction Methods 0.000 description 1
- 238000012938 design process Methods 0.000 description 1
- 238000007599 discharging Methods 0.000 description 1
- 238000011156 evaluation Methods 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 238000000227 grinding Methods 0.000 description 1
- 208000014674 injury Diseases 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000013508 migration Methods 0.000 description 1
- 230000005012 migration Effects 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 238000009790 rate-determining step (RDS) Methods 0.000 description 1
- 230000008439 repair process Effects 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 230000011218 segmentation Effects 0.000 description 1
- 230000009897 systematic effect Effects 0.000 description 1
- 238000012549 training Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/288—Entity relationship models
-
- 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/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
-
- 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/22—Indexing; Data structures therefor; Storage structures
-
- 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/23—Updating
-
- 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/2455—Query execution
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06K—GRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
- G06K17/00—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations
- G06K17/0022—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisious for transferring data to distant stations, e.g. from a sensing device
- G06K17/0025—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisious for transferring data to distant stations, e.g. from a sensing device the arrangement consisting of a wireless interrogation device in combination with a device for optically marking the record carrier
-
- 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
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Abstract
The invention relates to a material charging system and method, in particular to an intelligent fool-proofing charging system and method based on the Internet. The system comprises a process engineer station (ES) host, a warehouse management station (WMS) computer host, an operator station (OS) computer host, a barcode identification station (FS) tablet computer, an electronic scale, an audible and visual alarm, a code scanner (Android system), a router, a Siemens PLC S7-300, an MPI communication cable, an RS485 cable, an RS232 cable, a 24 V power supply and a serial port converter. The charging method includes the steps of task order assigning and production process control. A complete database solution from a server to a terminal is provided, wherein the database server part is a database management system used for database establishment, use and maintenance. Due to the mature architecture, stable performance, embedded development mode and simple grammar of the system, the system can be rapidly developed.
Description
Technical field
The present invention relates to a kind of material jettison system and method thereof, particularly relate to a kind of based on the throwing of internet intelligent fool proof
Material system and method.
Background technology
Fool proof (English: Fool-proofing) is a kind of behavior restraint means prevented and correct, and uses and avoids producing mistake
Method for limiting, allow operator need not spend attention, can the most inerrably complete with Professional knowledge also without experience
Correct operation.In industrial design, in order to avoid the operational error of user causes machine or personal injury, (include unintentionally
The action known or subconscious misoperation or neglectful limb action), have for these it can happen that do pre-
Anti-measure, referred to as fool proof.
Along with implementing of 13 plans, development Chemical Manufacture economy becomes factory's growing interest the most faster
Focus and focus, different types of chemical industry plant produced streamline has not flow process, and once some flow process goes wrong, then
Whole series-produced product will be caused irremediable loss.
At the aspect of fool proof, using the technology of Quick Response Code, Quick Response Code is by a set pattern with certain specific geometric figure
Restrain the chequered with black and white graphic recording data symbol information that is distributed in plane (on two-dimensional directional);On coding dexterously
Utilize the concept of " 0 ", " 1 " bit stream constituting computer-internal logical foundations, use several corresponding with binary system several
What body represents word numerical information, automatic to realize information by image input device or photoelectric scanning device automatically identifying and reading
Process: it has some general character of barcode technology: every kind of code system has its specific character set;Each character occupies certain width
Degree;There is certain verifying function etc..The most also there is the information automatic identification function to different rows and process figure rotation change
Change point.The capacity that he has storage data is the highest and be not easy features such as being tampered.
Summary of the invention
It is an object of the invention to provide a kind of based on internet intelligent fool proof feeding system and method thereof, the present invention provides
The total solution from server to terminal of data base, wherein database server part, is a data base administration
System, is used for setting up, operation and maintenance data base.The framework of its maturation, stable performance, embedded development mode, brief introduction
Grammer so that system can be developed rapidly.
It is an object of the invention to be achieved through the following technical solutions:
A kind of based on internet intelligent fool proof feeding system, described system includes that process engineer stands (ES) main frame, store management
Stand (WMS) host computer, operator station (OS) host computer, bar code identification station (FS) panel computer, electronic scale, sound and light alarm
Device, code reader (android system), router, SIEMENS PLC S7-300, MPI communication cable, RS485 cable, RS232 electricity
Cable, 24V power supply, serial converter;ES station, WMS station, OS station, the main frame at FS station are connected through LAN;ES station is through LAN even
Connect WMS station, OS station, FS station;Electronic scale is by RS485 cable, RS232/RS485 serial converter, RS232 cable and code reader
RS232 serial ports couple, audible-visual annunciator couples with the lead-out terminal of PLC;Hand-held code reader is by LAN and FS station
Panel computer carries out data cube computation;PLC S7-300 is connected with host computer by MPI communication cable.
Described one is based on internet intelligent fool proof feeding system, described S7-300PLC Yu OS station host computer and ether
Net is connected, and S7-300PLC selects the CPU of band Ethernet interface.
Described one is SQL based on internet intelligent fool proof feeding system, the data base in described ES station host
Server data base, and the connection of handheld device end and data base is realized by Json data-interface.
A kind of based on internet intelligent fool proof feeding method, described feeding method includes procedure below:
(1) assign a task list
The technologists of process engineer station (ES), after receiving production task, assigns production task list on computers,
It is sent to storehouse, production control computer, workshop bar code identification computer by LAN or wireless network;Storehouse, production control
System, bar code identification computer return confirmation, and lower single task completes;
(2) production process controls
By material during feeding intake, weigh, linkage between equipment three realizes error-disable function;Bar code identification station and storehouse
In electronic weighing appliance realized by data wire and data communication between the android system of PLC and handheld terminal;Due to
The output data line interface of electronic scale is RS485, and the Data Input Interface of hand-held terminal device is RS232, so needing to use
Data conversion is completed to serial converter.
Described one is based on internet intelligent fool proof feeding method, and described production process rate-determining steps is as follows:
1. feed intake mistake proofing: ensures the correct, including name of material and weight of charging.By material during feeding intake, weigh, set
Linkage between standby three realizes error-disable function;
2. formulation management: before lower production task, technical staff is by lower production task list, and program can calculate every kind of this batch of material
The secondary weight needing to throw in, it is to avoid the mistake that artificial calculating process is likely to occur;
3. the bar code treating throwing material before feeding intake confirms, by the program woven in advance, confirms that this walks material to be thrown
Correctly, it is to avoid the mistake that in production process, feeding sequence is likely to occur.
Advantages of the present invention with effect is:
The present invention uses Apache+PHP+MSSQL structure to develop.It is presently the most maturation, stable, safe enterprise-level
WEB development technique, is widely used in ultra-large type website.The framework of its maturation, stable performance, embedded development mode, brief introduction
Grammer so that system can be developed rapidly.Backstage MSSQL data base is a database platform, it is provided that data base from service
Device is to the total solution of terminal, and wherein database server part, is a data base management system, be used for setting up,
Operation and maintenance data base.MSSQL is widely used in network on internet.
For the present invention is relative to C/S structure, using B/S structure to realize remote real-time monitoring is the most deep change, it
Have such as advantage:
1) task such as client access and complex data computation of being no longer responsible for data, it is only necessary to show, give full play to
The powerful effect of server, thus greatly reduces the requirement to client, reduces investment and use cost.
2) be easily maintained, easily scalable.Attendant is no longer that the maintenance work of program hurries back and forth migration in each client computer
Between, and main attention is placed on function server.Owing to user side is without special software, when network application is entered by enterprise
During row upgrading, only need to update the software of server end, alleviate system maintenance and the cost of upgrading and workload.
3) user operation is easy to use.The client of B/S structure is a browser providing friendly interface, passes through Mus
Mark can realize remote real-time monitoring, and user just can be used directly without training, is beneficial to promote.
4) it is easily achieved cross-platform application, solves situation incompatible under different system.
In sum, the B/S architecture of three layers has the advantage that many tradition C/S architectures do not possess, be
Web technology based on Internet, in conjunction with Traditional control principle, has expanded the function of traditional monitoring application, has been more suitable for the epoch
Development, be technology development trend of the times.
Accompanying drawing explanation
Fig. 1 is that present system flow of information transmits schematic diagram;
Fig. 2 is present system structure chart;
Fig. 3 is present procedure module and business process map thereof;
Fig. 4 is physical operation person and attribute E-R figure thereof;
Fig. 5 is job order and attribute E-R figure thereof;
Fig. 6 is user profile and attribute E-R figure thereof;
Fig. 7 is system structure functional diagram.
Detailed description of the invention
The present invention is described in detail for illustrated embodiment below in conjunction with the accompanying drawings.
The present invention is broadly divided into following step, first looks for realizing the various different scheme of goal systems, is solving
The data flowchart that the stage of reading demand analysis obtains is the basis imagining various possible schemes.Then available from these
Scheme in choose relatively reasonable scheme, then each scheme is designed a corresponding workflow diagram, according to
The system flow chart designed chooses out all of physical element.Should follow carrying out software structure design when
Main operational principle is each functional module Independence Principle, and module may diminish to model, controller, arrives greatly window, program
After Module Division completes, it is possible to start to devise.
The process of design is generally made up of two main stages: system designs, and determines the specific implementation of system;Knot
Structure designs, and determines software configuration.
System structure is as follows:
The full name of B/S pattern: Browser/Server Mode (Browser/Server).Owing to these of structure are not enough, in tradition
Structure in the middle of add last layer, the function that original client computer is responsible for is given intermediate layer and is realized, and this intermediate layer is clothes
Business device layer.So, client, with regard to not responsible original data access, need only install browser in client the most permissible.Former
Come server as database server, on database server installation data library management system and create data base.Clothes
Data base is conducted interviews by the effect of business device exactly, and passes to browser by work net.So, server is browser
Server, is again the browser of database server.
In such a mode, client computer just becomes a simple browser, defines " fat server/thin client "
Pattern, here it is browser server pattern.Structure based on browser server pattern will combine with data base, formation
Computation schema based on data base, and being applied to by this model, has ultimately formed three layers of client-server application structure, and three
The three of application system functional planes have been carried out clear and definite segmentation by Rotating fields so that it is logically the most independent.
Under three-layer architecture, represent that layer, Business Logic, data Layer are divided into three relatively independent unit.
Representing layer i.e. Web browser, comprise the display logic of system, it is positioned at client, is used for generating browsing client
The user interface of display in device.Its task is responsible for obtaining the data of user's typing, completes the verification to logging data, by
The Web browser a certain Web server on network proposes service request, after Web server carries out authentication to user
Send client request operational data to Business Logic by agreement, then ask the operating result of operation to be used by completing user
Grinding a few agreement and send client to, client computer accepts the homepage file transmitted, and its display on Web browser.
Business Logic includes one or more Component service, and they applied business rules realize application logic also
Complete the data required for application program runs to process.As a part for this process, intermediate layer is responsible for processing from data
Store or be sent to the data of data storage.Its task is to accept the request of user, performs corresponding extension application
Being attached with data base, propose data by Peer to database server and process application, application is processed by data base
After the result that data process is submitted to Web server, then sent back client by Web server.
Such three-layer architecture significantly reduces the pressure of client computer, the Web that distributes to of load balancing need not be taken
Business device.Owing to client computer has given server transaction process method part, it is no longer responsible for processing complicated calculations and data access
Deng Key Transactions, be only responsible for display part, thus attendant's no longer maintenance work for program hurry back and forth in each client computer it
Between, and main attention is placed on the renewal work of program on function server.This three-decker is the most separate,
The change of any one layer does not affect the function of other layer.
The overall traffic flow process of system: system manager by logging in, through verification for validated user laggard enter behind website
Platform, i.e. can operate the relevant information of job order;Warehouse keeper is by logging in;Through verifying as legal entrance website
After, can manually input and material is carried out unique tags;Handheld device end, in the flow process produced, by resolving two dimension
Code data also and in data base are compared and are determined whether to perform the function of filler.Need the main program module write and
Business process map is as shown in the figure.
The establishment of data dictionary: data dictionary is the set about data message, namely to comprising in data flow diagram
The set of all elements definition.Any is all to consult uncomprehending bar teleological interpretation, data word for the topmost purposes of people's dictionary
The effect of allusion quotation provides the description information about data to people the most just in software analysis and design process.Data flow diagram and data
Dictionary collectively forms the logical model of system, does not has data dictionary data flow diagram the not strictest, but does not has data flow diagram data
Dictionary also is difficult to play a role.Only data flow diagram and put data flow diagram precise definition together, just can collectively form and be
The specification of system.
Data dictionary be mainly used for the main tool as the molecule stage.One group tight one is set up in data dictionary
The definition caused contributes to improving the communication between analyst and client very much, therefore will eliminate the most possible misunderstanding.Data dictionary
The control information of each data element comprised is of great value.Because listing one given data element of use to own
Program, it is easy to estimate to change the impact that an element will produce, and all affected programs or module can be made phase
Should change.
Owing to temporarily also not having automatic data dictionary processing routine, card form is used to write data dictionary, every card
The information describing a data element is preserved on sheet.This way preferably achieves above-mentioned requirements, particularly updates and revises
Come easily, it is possible to the information of each data element of individual processing.The information comprised on every card has: name, another name, retouches
State, definition, position.
In system concept structure ER model, comprise " entity ", " contact " and " attribute " three bases.
1) entity: entity is the things that objective world exists and can mutually distinguish.It can be people can also be animal;
Can be concrete things can also be abstract conception.
2) contact: contact refers to each things contact to each other in objective world.Contact is divided three classes: man-to-man pass
System, the relation of one-to-many, the relation of multi-to-multi.
3) attribute: the character that attribute is entity or contact is had, a usual entity is portrayed with some attributes.People
Realistic problem is understood the most exactly by entity, contact and attribute these three concept, therefore, the thinking of ER model relatively people
Mode.Additionally, ER model uses simple graphical symbol to represent systems analyst's understanding to problem, it is unfamiliar with the people of computer
Will also understand that it, therefore, ER model can be as the media of communication between user and systems analyst.
One preferable system will be carried out at the initial stage of design and sufficiently analyze work, and will be according to certain order
This is completed, first should carry out data analysis work, design data base.Analytical database Construction Problems time
Wait, it should start with from demand analysis, all data that will use of the system that gets from demand analysis, and planned
Good, extraction entity and attribute thereof, set up model.It is the list entity such as operator, job order, user profile individually below, system
All data to be used, all will be expressed as follows with the form of E-R figure:
As: physical operation person and attribute E-R figure thereof;Job order and attribute E-R figure thereof;User profile and attribute E-R figure thereof.
System based on actual production procedure, main prominent job order is assigned, job order in detail, Quick Response Code generate,
The functions such as Modify password, this system is broadly divided into the big functions of modules of above-mentioned three.Assign module management person at job order can repair
The operation of pending job order such as change, job order can be increased newly, in the attribute of job order can be gone amendment etc. by manager
Hold.
The task of system logic structure is exactly that the ER of conception framework design stage design is schemed, and is converted into and selects DBMS institute
The logical structure that the data model supported is consistent.
System logic structure is as follows:
1. it is mainly, from E-R figure to the logical design in relation schema conversion data storehouse, the general relation that is converted into by conceptual model
Pattern, is namely converted into relation schema by the contact between the entity in E-R figure, entity attributes and entity.Transformed
In journey, following problems may be encountered:
1) Naming Problems.Naming Problems can use original name, it is also possible to names separately, it is to avoid bears the same name.
2) non-atomic attribute question.Non-atomic attribute question can be carried out longitudinal direction and be walked crosswise expansion.
3) contact transfer problem.Contact available relationship represents.
2. the optimization of data model, the result of DB logical design is not unique.In order to improve data base further
The performance of application system, also should the structure of suitably modified data model, improve the speed of inquiry.
3. relational view design, the design of relational view is also called the design of external schema, also makes user model design, and is to use
The data pattern that family can directly access.In same system, different user can have different relational views.Relational view is from logic
Pattern, but in structure with likely differ from logic model, so it is not the primary subset of logic model in form.
4. the particular content of the DB logical design of relational model includes:
1) conceptual schema is to the conversion of relational data base schema.
2) optimization of relation schema.
5. E-R figure is converted into relational model and includes:
Manager's (manager ID, admin name, administrator's password);
Job order (job order ID, operation quantity, task detailed step, execution status of task)
Administrator Info's (manager ID, administrator name, manager's cell-phone number, manager's mailbox)
6. the optimization of data model includes:
(1) data dependence is determined
(2) minimization process is carried out for the data dependence between each relation schema, eliminate the contact of redundancy.
(3) according to the theory of data dependence, relation schema is analyzed one by one, examination whether exist partial functional dependence,
Transitive functional dependence, multivalued dependence etc., determine which normal form is each relation schema be belonging respectively to.
(4) requirement that data are processed by the various application that the analysis phase obtains as desired, analyzes for such application
These patterns of environment are the most suitable, it is determined whether will merge them or decompose.
(5) requirement that data are processed by the various application that the analysis phase obtains as desired, carries out necessity to relation schema
Decomposition or merging, the utilization rate of efficiency and memory space to improve data manipulation.
The physics realization of data base:
The content of 1 atabase Physical Design and method
The physical Design of data base be for logic data model choose a most suitable applied environment physical arrangement (include storage
Structure and storage method).The physical Design of data base is generally divided into two steps, it may be assumed that determine the physical arrangement of data base, is closing coefficient
According to storehouse refers mainly to storage method and storage organization.Physical arrangement is evaluated, evaluation it is important that time and the effect in space
Rate.
2., for database query transaction, need to obtain following information:
1) relation inquired about;
2) attribute involved by condition inquired about;
3) attribute involved by condition connected;
4) inquiry projection property.
3., for database update affairs, need to obtain following information:
1) relation being updated;
2) attribute involved by renewal operating condition that each pass is fastened;
3) amendment operation property value to be changed.
4. the establishment of database table:
According to system function design require and Module Division, the data base of this system background mainly include manager's logon information,
Three parts of the details of manager's details and job order, can be set up following several by data analysis above
Table, being described in detail as follows of each table name:
(1), manager's logon information table, named " bs_login ", the design parameter of this table is as shown in table 1:
Table 1 manager's logon information table
(2), job order details table, named " bs_mask ", the design parameter of this table is as shown in table 2:
Table 2 job order details table
(3), manager's details table, named " bs_user ", the design parameter of this table is as shown in table 3:
Table 3 manager's details table
。
The overall traffic flow process of system:
System manager by logging in, through verification for validated user laggard enter backstage, website, i.e. job order can be correlated with
Information operates;Warehouse keeper is by logging in;After verifying as legal entrance website, can manually input thing
Unique tags carried out by material;Handheld device end, in the flow process produced, is carried out by resolving Quick Response Code data also and in data base
Comparison determines whether to perform the function of filler.
Assign a task and single-ended Apache+PHP+MSSQL technology is combined closely, and create one based on this locality
The operating platform that the task of server is single-ended.This system is mainly directed towards the factory having automatic production line.Whole system is divided into
Content with lower module:
System is based on actual production procedure, and main prominent job order is assigned, job order details, job order perform feelings
The functions such as condition, Quick Response Code generation.Assigning module at job order, operator can here submit job order to, and specifies each
The required material thrown in of individual step and quantity;The detailed module of job order can see the operation quantity, in detail of task accurately
The material of thin input and its quantity;Job order perform module can view the execution state of task include etc. pending,
In execution and the state that performed;Two-dimensional code generation module, uses mainly for warehouse keeper, makes the when of warehouse discharging
A 2 D code information having name of material and quantity is generated by this module.
Android development technique should be used by hand held equipment terminal cleverly, and create one and task single-ended
Data base connect mechanism, utilize the single-ended offer of task data-interface generate a Json data-interface, connect by Json
The existing handheld device end of cause for gossip and the remote access of data base.
Handheld device end is broadly divided into four interfaces, selects the interface of task, selects the interface of a certain operation of this task
And barcode scanning comparison interface.Select task module, access database root by request and choose list according to the Json generation returned;Choosing
Select process module and combine process request access data base according to the unique mark in the data base of this task, according to return
Json obtains correct name of material and required quantity;It is finally barcode scanning module, realizes barcode scanning, root by transferring API
According to information present in the Quick Response Code parsed, it is achieved comparison, and result is transferred to next link.System is with actual life
The functions such as based on runoff yield journey, main prominent job order is assigned, job order is detailed, Quick Response Code generation, Modify password, this system master
It is divided into the big functions of modules of above-mentioned three.Work at the job order pending job order such as assign that module management person can revise
Sequence, can increase job order newly, and the attribute of job order can be gone amendment etc. content by manager.Manufacturer can be made convenient and swift
The various information that feed intake of grasp, carry out production procedure accurately, the quality of product can also be made to be protected simultaneously.
System application design includes: assign a task single module design, and in the development process of system, we are by thin
The system research work caused, carries out positive communication with relevant departments, understands its required system architecture, form a set of function
Perfect system logic flow process, it then follows systematic design discipline.The structure function figure of this system is as shown in the figure.Also include that user logs in
INTERFACE DESIGN and the detailed interface of job order.
Claims (5)
1. one kind based on internet intelligent fool proof feeding system, it is characterised in that described system includes that process engineer stands (ES)
Main frame, store management station (WMS) host computer, operator station (OS) host computer, bar code identification station (FS) panel computer, electronics
Title, audible-visual annunciator, code reader (android system), router, SIEMENS PLC S7-300, MPI communication cable, RS485 electricity
Cable, RS232 cable, 24V power supply, serial converter;ES station, WMS station, OS station, the main frame at FS station are connected through LAN;ES stands
WMS station, OS station, FS station is connected through LAN;Electronic scale is by RS485 cable, RS232/RS485 serial converter, RS232 electricity
Cable couples with the RS232 serial ports of code reader, and audible-visual annunciator couples with the lead-out terminal of PLC;Hand-held code reader passes through LAN
Network carries out data cube computation with the panel computer at FS station;PLC S7-300 is connected with host computer by MPI communication cable.
One the most according to claim 1 is based on internet intelligent fool proof feeding system, it is characterised in that described S7-
300PLC with OS station host computer is connected with Ethernet, and S7-300PLC selects the CPU of band Ethernet interface.
One the most according to claim 1 is based on internet intelligent fool proof feeding system, it is characterised in that described ES station owner
Data base in machine is SQL server data base, and is realized the company of handheld device end and data base by Json data-interface
Connect.
4. one kind based on internet intelligent fool proof feeding method, it is characterised in that described feeding method includes procedure below:
(1) assign a task list
The technologists of process engineer station (ES), after receiving production task, assigns production task list on computers,
It is sent to storehouse, production control computer, workshop bar code identification computer by LAN or wireless network;Storehouse, production control
System, bar code identification computer return confirmation, and lower single task completes;
(2) production process controls
By material during feeding intake, weigh, linkage between equipment three realizes error-disable function;Bar code identification station and storehouse
In electronic weighing appliance realized by data wire and data communication between the android system of PLC and handheld terminal;Due to
The output data line interface of electronic scale is RS485, and the Data Input Interface of hand-held terminal device is RS232, so needing to use
Data conversion is completed to serial converter.
One the most according to claim 4 is based on internet intelligent fool proof feeding method, it is characterised in that described produced
Process control step is as follows:
1. feed intake mistake proofing: ensures the correct, including name of material and weight of charging;
By material during feeding intake, weigh, linkage between equipment three realizes error-disable function;
2. formulation management: before lower production task, technical staff is by lower production task list, and program can calculate every kind of this batch of material
The secondary weight needing to throw in, it is to avoid the mistake that artificial calculating process is likely to occur;
3. the bar code treating throwing material before feeding intake confirms, by the program woven in advance, confirms that this walks material to be thrown
Correctly, it is to avoid the mistake that in production process, feeding sequence is likely to occur.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610853458.0A CN106326494A (en) | 2016-09-27 | 2016-09-27 | Intelligent fool-proofing charging system and method based on Internet |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610853458.0A CN106326494A (en) | 2016-09-27 | 2016-09-27 | Intelligent fool-proofing charging system and method based on Internet |
Publications (1)
Publication Number | Publication Date |
---|---|
CN106326494A true CN106326494A (en) | 2017-01-11 |
Family
ID=57820484
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610853458.0A Pending CN106326494A (en) | 2016-09-27 | 2016-09-27 | Intelligent fool-proofing charging system and method based on Internet |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106326494A (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109726236A (en) * | 2018-12-04 | 2019-05-07 | 江苏光腾光学有限公司 | A kind of method of charging basket charging |
CN111665792A (en) * | 2019-03-06 | 2020-09-15 | 科迈士瑞士股份有限公司 | Computer-implemented method for monitoring a plurality of cable processing machines and monitoring system |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH06155252A (en) * | 1992-11-16 | 1994-06-03 | Nissan Motor Co Ltd | Quality control system in article production process |
US20050198618A1 (en) * | 2004-03-03 | 2005-09-08 | Groupe Azur Inc. | Distributed software fabrication system and process for fabricating business applications |
CN104570980A (en) * | 2013-10-23 | 2015-04-29 | 沈阳机床(集团)有限责任公司 | B/S-architecture-based cross-platform remote monitoring system for numerical control machining production line |
CN104731078A (en) * | 2015-04-03 | 2015-06-24 | 南通理工学院 | Sewage treatment monitoring system based on internet of things |
CN104808639A (en) * | 2015-04-29 | 2015-07-29 | 中国石油大学(华东) | Pharmaceutical product manufacturing execution system and method |
-
2016
- 2016-09-27 CN CN201610853458.0A patent/CN106326494A/en active Pending
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH06155252A (en) * | 1992-11-16 | 1994-06-03 | Nissan Motor Co Ltd | Quality control system in article production process |
US20050198618A1 (en) * | 2004-03-03 | 2005-09-08 | Groupe Azur Inc. | Distributed software fabrication system and process for fabricating business applications |
CN104570980A (en) * | 2013-10-23 | 2015-04-29 | 沈阳机床(集团)有限责任公司 | B/S-architecture-based cross-platform remote monitoring system for numerical control machining production line |
CN104731078A (en) * | 2015-04-03 | 2015-06-24 | 南通理工学院 | Sewage treatment monitoring system based on internet of things |
CN104808639A (en) * | 2015-04-29 | 2015-07-29 | 中国石油大学(华东) | Pharmaceutical product manufacturing execution system and method |
Non-Patent Citations (1)
Title |
---|
赵洪亮;王加奎;江霞;闫吉领;张昭喜;: "基于西门子PLC的煤矿井下自动化监控系统设计" * |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109726236A (en) * | 2018-12-04 | 2019-05-07 | 江苏光腾光学有限公司 | A kind of method of charging basket charging |
CN111665792A (en) * | 2019-03-06 | 2020-09-15 | 科迈士瑞士股份有限公司 | Computer-implemented method for monitoring a plurality of cable processing machines and monitoring system |
CN111665792B (en) * | 2019-03-06 | 2024-04-05 | 科迈士瑞士股份有限公司 | Computer-implemented method for monitoring a plurality of cable processing machines and monitoring system |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106296378B (en) | XBRL-based intelligent financial cloud platform system, construction method and service implementation method | |
CN104808639B (en) | Pharmaceutical product manufacturing execution system and method | |
CN101946258B (en) | Model based deployment of computer based business process on dedicated hardware | |
CN107679192A (en) | More cluster synergistic data processing method, system, storage medium and equipment | |
CN101821710B (en) | System, method and graphical user interface for workflow generation, deployment and/or execution | |
Zheng et al. | Construct food safety traceability system for people’s health under the internet of things and big data | |
CN100449435C (en) | KBE and WEB technology based stamping design and production system | |
CN107077130A (en) | For the method for the manufacture of planning product and the production module with self-description information | |
CN109670267A (en) | A kind of data processing method and device | |
CN101443799A (en) | Systems and methods for process-driven bill of material | |
CN101964081A (en) | Production information system based on factory management infrastructure platform | |
CN104361424A (en) | Master data system integration method based on enterprise service bus (ESB) | |
CN106897862A (en) | A kind of Electric Power Network Planning work in preliminary project stage progress and achievement managing and control system | |
CN106022007A (en) | Cloud platform system and method oriented to biological omics big data calculation | |
CN101770605A (en) | R & D project plan management method and system | |
CN106383720A (en) | Cloud sharing and collaborating method of software product prototype | |
CN106445536A (en) | Automated business design management system | |
CN109767122A (en) | A method of the automatic row that has furniture made to order based on ERP system is single | |
CN103116827A (en) | Rural power grid engineering control system | |
CN109799976A (en) | Real-time air control variable calculation method based on distributive type computing engines | |
Rossetti et al. | A cloud computing architecture for supply chain network simulation | |
CN101894299A (en) | Fast freight departure and entry intelligent declaration system capable of supporting RFID and HS coding and image processing | |
CN107533329A (en) | The method and system of cross discipline data verification inspection in multidisciplinary engineering system | |
CN106326494A (en) | Intelligent fool-proofing charging system and method based on Internet | |
JP2007503649A (en) | Easy display design decision |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
WD01 | Invention patent application deemed withdrawn after publication | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20170111 |