CN109725167A - Grain and oil quality inspection laboratory instrument equipment butt joint system - Google Patents
Grain and oil quality inspection laboratory instrument equipment butt joint system Download PDFInfo
- Publication number
- CN109725167A CN109725167A CN201811631139.0A CN201811631139A CN109725167A CN 109725167 A CN109725167 A CN 109725167A CN 201811631139 A CN201811631139 A CN 201811631139A CN 109725167 A CN109725167 A CN 109725167A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- grain
- quality inspection
- oil quality
- 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
- 238000007689 inspection Methods 0.000 title claims abstract description 12
- 210000001503 joint Anatomy 0.000 title abstract 2
- 238000001514 detection method Methods 0.000 claims description 12
- 238000007726 management method Methods 0.000 claims description 6
- 238000001228 spectrum Methods 0.000 claims description 6
- 230000006870 function Effects 0.000 claims description 3
- 238000013523 data management Methods 0.000 claims description 2
- 230000005540 biological transmission Effects 0.000 abstract description 3
- 238000004891 communication Methods 0.000 abstract description 2
- 238000006243 chemical reaction Methods 0.000 abstract 1
- 238000003032 molecular docking Methods 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 3
- 238000000034 method Methods 0.000 description 3
- 230000006872 improvement Effects 0.000 description 2
- 230000002452 interceptive effect Effects 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 229910000831 Steel Inorganic materials 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000000903 blocking effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000005246 galvanizing Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 239000010959 steel Substances 0.000 description 1
Landscapes
- Automatic Analysis And Handling Materials Therefor (AREA)
Abstract
The invention discloses a grain and oil quality inspection laboratory instrument equipment butt joint system, which comprises the following steps: step S1: the system provides an API interface, receives data pushed by instrument and equipment software, and submits the data in an http POST mode: device unique ID, sample number, test item, test time, data item, accessory, lab, etc., step S2: txt, EXCEL, DOC, PDF reports or other files capable of being analyzed into text formats and the like exported by device software, wherein txt data can be directly analyzed, EXCEL, DOC, PDF are firstly converted into text formats and then analyzed, and graphs in EXCEL, DOC, PDF can be converted into jpg, png, bmp and other formats and then uploaded to a system to be directly displayed in original records. The invention has various butt-joint schemes, is easy to program, provides various frames, shields the bottom layer communication details and the data transmission conversion details, is easy to control the authority, encrypts the transmitted data through the transport layer protocol https, improves the safety, has stronger universality and brings better use prospect.
Description
Technical field
The invention belongs to docking system fields, in particular to grain and oil quality inspection Laboratory Instruments equipment interconnection system.
Background technique
There are four types of docking system scheme mainly includes, the first Socket mode is simplest interactive mode.It is typical
Ability C/S interactive mode, a client computer, a server, server providing services carry out service visit by IP address and port
It asks, and client computer carries out interacting message by the specified port of connection server.Wherein transport protocol can be TCP/UDP association
View, and server and arranged request message format and response message format, second of ftp/ file-sharing server mode is
The A and system B that unites arranges file server address, file designation rule, the contents such as file content format, by uploading files to text
Part server carries out data interaction, the third Database vendors data mode, system A and system B by connecting the same data
Same table of library server carries out data exchange, the 4th kind of message mode, and system A and system B pass through a messaging service
Device carries out data exchange, and system A sends a message to message server, if the message that system B ordering system A is sended over, disappears
Breath server meeting message is pushed to B, and both sides arrange message format；Mode when existing docking system docks is single,
It is easy to cause data channel blocking too fat to move when carrying out big data exchange, reduces the speed of docking transmission.
Summary of the invention
The main purpose of the present invention is to provide grain and oil quality inspection Laboratory Instruments equipment interconnection systems, can effectively solve to carry on the back
The problems in scape technology.
To achieve the above object, the technical scheme adopted by the invention is as follows:
Grain and oil quality inspection Laboratory Instruments equipment interconnection system, follows the steps below to implement:
Step S1: system provides api interface, receives the data pushed by instrument and equipment software, is mentioned by http POST mode
It hands over: the data such as the unique ID of equipment, sample number into spectrum, detection project, detection time, data item, attachment, laboratory technician；
Step S2: crawl interface data: system actively calls instrument and equipment software interface API, supports webservice, https/
The interface data of the various ways such as http grabs；Txt derived from device software, EXCEL, DOC, PDF are reported or other can be solved
The file etc. of text formatting is analysed into, wherein txt data can be parsed directly, EXCEL, DOC, and PDF is first converted into text formatting again
It parses, wherein EXCEL, chart can be converted jpg in DOC, PDF, and the format pictures such as png, bmp upload to system directly in original
Begin to show in record, file can upload downloading or SMB sharing mode by FTP；Database: being connected by JDBC, is supported more
Kind frequently-used data library, mysql, SqlServer, access, oracle etc., the parsing for passing through the data source that distinct device is arranged are advised
Then, parsing data source obtains the unique ID of equipment, sample number into spectrum, detection project, detection time, testing result data and chart etc. and closes
Key information automatically grabs the system of being uploaded to.
Preferably, the mysql is a kind of relational database management system, and relational database saves the data in different
In table, rather than all data are placed in one big warehouse, which adds speed and improve flexibility, mysql institute
The sql like language used is the most frequently used standardized language for accessing database.
Preferably, the SqlServer is a relational database management system, and SQL statement can be used to execute various
Data in the operation of various kinds, such as more new database extract data etc. from database.
Preferably, the access combines MicrosoftJet Database Engine and graphic user interface
Two features are one of the system programs of Microsoft Office, the graphic user interface and software of database engine
The combined data base management system of developing instrument.
Preferably, the Database Systems oracle general as one, it has complete data management function；Make
For a relational database, it is the product of a complete relationship；As distributed data base, it realizes distributed treatment function
Energy.
Compared with prior art, the invention has the following beneficial effects:
In the present invention, have a variety of docking concepts, be easily programmed, provide a variety of frames, shield bottom communication details and
Data transfer details, is easy to control permission, passes through transport layer protocol https, the data of encrypted transmission, so that safety proposes
Height, versatility is stronger, and no matter client is .net framework, and java, python are possible, especially webservice
Specification, so that service becomes general, in the case where data volume is big, can be transmitted by file, not time out, be not take up net
Network bandwidth brings better prospect of the application.
Specific embodiment
In a specific embodiment, the detailed process of high-strength alloyed steel plate hot dip galvanizing process is described clear and completely.
It should be pointed out that these descriptions are example, the range being not intended to limit the present invention.In addition, in the following description, saving
It has omited to descriptions of well-known structures and technologies, has obscured idea of the invention to avoid unnecessary.
Specific step is as follows:
The present invention is grain and oil quality inspection Laboratory Instruments equipment interconnection system, and system provides api interface, is received by instrument and equipment software
The data of push are submitted by http POST mode: the unique ID of equipment, sample number into spectrum, detection project, detection time, data
The data such as item, attachment, laboratory technician, txt, EXCEL, DOC derived from device software, PDF report or other can parse into text
The file etc. of format, wherein txt data can be parsed directly, EXCEL, DOC, and PDF is first converted into text formatting and parses again, wherein
Chart can be converted jpg in EXCEL, DOC, PDF, and the format pictures such as png, bmp upload to system directly in original record
It has been shown that, file can upload downloading by FTP or SMB sharing mode, database are connected by JDBC, supports a variety of typical numbers
According to library, mysql, SqlServer, access, oracle etc., the resolution rules of the data source by the way that distinct device is arranged, parsing
Data source obtains the key messages such as the unique ID of equipment, sample number into spectrum, detection project, detection time, testing result data and chart,
Automatically grab the system of being uploaded to.
The above shows and describes the basic principles and main features of the present invention and the advantages of the present invention.The technology of the industry
Personnel are it should be appreciated that the present invention is not limited to the above embodiments, and the above embodiments and description only describe this
The principle of invention, without departing from the spirit and scope of the present invention, various changes and improvements may be made to the invention, these changes
Change and improvement all fall within the protetion scope of the claimed invention.The claimed scope of the invention by appended claims and its
Equivalent thereof.
Claims (5)
1. grain and oil quality inspection Laboratory Instruments equipment interconnection system, follows the steps below to implement:
Step S1: system provides api interface, receives the data pushed by instrument and equipment software, is mentioned by http POST mode
It hands over: the data such as the unique ID of equipment, sample number into spectrum, detection project, detection time, data item, attachment, laboratory technician；
Step S2: crawl interface data: system actively calls instrument and equipment software interface API, supports webservice, https/
The interface data of the various ways such as http grabs；Txt derived from device software, EXCEL, DOC, PDF are reported or other can be solved
The file etc. of text formatting is analysed into, wherein txt data can be parsed directly, EXCEL, DOC, and PDF is first converted into text formatting again
It parses, wherein EXCEL, chart can be converted jpg in DOC, PDF, and the format pictures such as png, bmp upload to system directly in original
Begin to show in record, file can upload downloading or SMB sharing mode by FTP；Database: being connected by JDBC, is supported more
Kind frequently-used data library, mysql, SqlServer, access, oracle etc., the parsing for passing through the data source that distinct device is arranged are advised
Then, parsing data source obtains the unique ID of equipment, sample number into spectrum, detection project, detection time, testing result data and chart etc. and closes
Key information automatically grabs the system of being uploaded to.
2. grain and oil quality inspection Laboratory Instruments equipment interconnection system according to claim 1, which is characterized in that the mysql
It is a kind of relational database management system, relational database saves the data in different tables, rather than all data are put
In one big warehouse, which adds speed and flexibility is improved, sql like language used in mysql is for accessing
The most frequently used standardized language of database.
3. grain and oil quality inspection Laboratory Instruments equipment interconnection system according to claim 1, which is characterized in that described
SqlServer is a relational database management system, and SQL statement can be used to execute various operations, such as update
Data in database extract data etc. from database.
4. grain and oil quality inspection Laboratory Instruments equipment interconnection system according to claim 1, which is characterized in that described
Access combines two features of MicrosoftJet Database Engine and graphic user interface, is Microsoft
One of system program of Office, the graphic user interface and Software Development Tools combined one of database engine
A data base management system.
5. grain and oil quality inspection Laboratory Instruments equipment interconnection system according to claim 1, which is characterized in that the oracle
The Database Systems general as one, it has complete data management function；As a relational database, it is one
The product of complete relationship；As distributed data base, it realizes distributed processing power.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811631139.0A CN109725167A (en) | 2018-12-29 | 2018-12-29 | Grain and oil quality inspection laboratory instrument equipment butt joint system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811631139.0A CN109725167A (en) | 2018-12-29 | 2018-12-29 | Grain and oil quality inspection laboratory instrument equipment butt joint system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109725167A true CN109725167A (en) | 2019-05-07 |
Family
ID=66296036
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811631139.0A Pending CN109725167A (en) | 2018-12-29 | 2018-12-29 | Grain and oil quality inspection laboratory instrument equipment butt joint system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109725167A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112953988A (en) * | 2019-12-10 | 2021-06-11 | 浙江宇视科技有限公司 | Data docking method and device based on FTP |
| CN113127413A (en) * | 2021-05-12 | 2021-07-16 | 北京红山信息科技研究院有限公司 | Operator data processing method, device, server and storage medium |
| CN113553294A (en) * | 2021-06-24 | 2021-10-26 | 青岛奥利普自动化控制系统有限公司 | Laboratory centralized instrument docking data processing method and system |
| CN113962569A (en) * | 2021-10-26 | 2022-01-21 | 冰山松洋生物科技(大连)有限公司 | Biological laboratory integrated management system based on cloud service |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102053611A (en) * | 2010-12-29 | 2011-05-11 | 启明信息技术股份有限公司 | Unmanned management method and system for test equipment |
| CN102495556A (en) * | 2011-12-13 | 2012-06-13 | 北京首钢自动化信息技术有限公司 | Configurable apparatus data acquisition method |
| CN206058263U (en) * | 2016-07-27 | 2017-03-29 | 南方电网科学研究院有限责任公司 | Laboratory management system based on intelligent data acquisition |
| CN107862472A (en) * | 2017-12-01 | 2018-03-30 | 中国兵器装备集团自动化研究所 | Quality data collection system and its collecting method based on terminal profile |
-
2018
- 2018-12-29 CN CN201811631139.0A patent/CN109725167A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102053611A (en) * | 2010-12-29 | 2011-05-11 | 启明信息技术股份有限公司 | Unmanned management method and system for test equipment |
| CN102495556A (en) * | 2011-12-13 | 2012-06-13 | 北京首钢自动化信息技术有限公司 | Configurable apparatus data acquisition method |
| CN206058263U (en) * | 2016-07-27 | 2017-03-29 | 南方电网科学研究院有限责任公司 | Laboratory management system based on intelligent data acquisition |
| CN107862472A (en) * | 2017-12-01 | 2018-03-30 | 中国兵器装备集团自动化研究所 | Quality data collection system and its collecting method based on terminal profile |
Non-Patent Citations (1)
| Title |
|---|
| 冀汶莉: "《电子商务数据库技术》", 31 May 2011 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112953988A (en) * | 2019-12-10 | 2021-06-11 | 浙江宇视科技有限公司 | Data docking method and device based on FTP |
| CN112953988B (en) * | 2019-12-10 | 2023-03-24 | 浙江宇视科技有限公司 | Data docking method and device based on FTP |
| CN113127413A (en) * | 2021-05-12 | 2021-07-16 | 北京红山信息科技研究院有限公司 | Operator data processing method, device, server and storage medium |
| CN113127413B (en) * | 2021-05-12 | 2024-03-01 | 北京红山信息科技研究院有限公司 | Operator data processing method, device, server and storage medium |
| CN113553294A (en) * | 2021-06-24 | 2021-10-26 | 青岛奥利普自动化控制系统有限公司 | Laboratory centralized instrument docking data processing method and system |
| CN113962569A (en) * | 2021-10-26 | 2022-01-21 | 冰山松洋生物科技(大连)有限公司 | Biological laboratory integrated management system based on cloud service |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109725167A (en) | Grain and oil quality inspection laboratory instrument equipment butt joint system | |
| Kim et al. | PUG-View: programmatic access to chemical annotations integrated in PubChem | |
| US8977600B2 (en) | System and method for continuous analytics run against a combination of static and real-time data | |
| US8626573B2 (en) | System and method of integrating enterprise applications | |
| JP5003271B2 (en) | Method and program for showing an electronic communication document in which a copy of the electronic communication document is stored to a related person, and a method and system for showing to at least one of a related person and a contributor that the electronic communication document is stored And equipment | |
| US9953099B2 (en) | Repackageable virtualized transparent access to heterogeneous data sources | |
| US8566578B1 (en) | Method and system for ensuring compliance in public clouds using fine-grained data ownership based encryption | |
| US9734466B2 (en) | Multi-tenancy engine | |
| US10713376B2 (en) | Fine grain security for analytic data sets | |
| US9503505B2 (en) | Monadic evaluation of injected query compositions | |
| CN112148679A (en) | Data interaction method, system, device and storage medium based on multiple data platforms | |
| US20100132044A1 (en) | Computer Method and Apparatus Providing Brokered Privacy of User Data During Searches | |
| US20180013643A1 (en) | Determining events by analyzing stored electronic communications | |
| US20210304143A1 (en) | Data classification in application programming interfaces at attribute level | |
| Luettgau et al. | NSDF-catalog: Lightweight indexing service for democratizing data delivery | |
| Bitzer et al. | Mashups as an architecture for knowledge management systems | |
| Costa Silva et al. | Comparison Framework for Team-Based Communication Channels | |
| Horsburgh et al. | Adapting OGC's SensorThings API and data model to support data management and sharing for environmental sensors | |
| US20220400119A1 (en) | Open architecture secured intel multi-level security system | |
| US20230328049A1 (en) | Enterprise governance inventory and automation tool | |
| Flanagan et al. | The Power of Ai-Enhanced Search: A Study on the Role of Information Systems in Delivering Relevant Search Results | |
| Zaslavskiy et al. | Implementation of the new REST API for open source LBS-platform Geo2Tag | |
| Bispo et al. | Is there a role of EU national soil data organizations in contributing to EUSO? The French example | |
| RU52218U1 (en) | AUTOMATED SYSTEM OF SITUATIONAL ANALYSIS | |
| Humbert | Dependence, innovation and gerontological coordination: socio-technical devices for the autonomy of the elderly? |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190507 |