CN109725167A - Grain and oil quality inspection Laboratory Instruments equipment interconnection system - Google Patents
Grain and oil quality inspection Laboratory Instruments equipment interconnection 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
Landscapes
- Automatic Analysis And Handling Materials Therefor (AREA)
Abstract
The invention discloses grain and oil quality inspection Laboratory Instruments equipment interconnection systems, steps are as follows: step S1: system provides api interface, receive the data pushed by instrument and equipment software, it is submitted by http POST mode: the unique ID of equipment, sample number into spectrum, detection project, detection time, data item, attachment, the data such as laboratory technician, step S2: txt derived from device software, EXCEL, DOC, PDF is reported or other can parse into the file etc. of text formatting, wherein txt data can be parsed directly, EXCEL, DOC, PDF is first converted into text formatting and parses again, wherein EXCEL, DOC, chart can be converted jpg in PDF, png, the format pictures such as bmp upload to system and directly show in original record.The present invention has a variety of docking concepts, it is easily programmed, provide a variety of frames, bottom communication details and data transfer details are shielded, permission is easy to control, passes through transport layer protocol https, the data of encrypted transmission, so that the safety is improved, versatility is stronger, brings better prospect of the application.
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 Instruments equipment interconnection 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 Instruments equipment interconnection 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 Instruments equipment interconnection system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109725167A (en) |
Cited By (3)
| 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 |
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 | 南方电网科学研究院有限责任公司 | Design of 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 | 南方电网科学研究院有限责任公司 | Design of 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 (5)
| 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 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109725167A (en) | Grain and oil quality inspection Laboratory Instruments equipment interconnection system | |
| US10592302B1 (en) | Method and apparatus for specifying API authorization policies and parameters | |
| US11170099B1 (en) | Filtering policies for evaluation by an embedded machine | |
| US8977600B2 (en) | System and method for continuous analytics run against a combination of static and real-time data | |
| 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 | |
| US9075672B2 (en) | Monadic evaluation of injected query compositions | |
| TW200710673A (en) | Method, system and computer program for controlling access to resources in web applications | |
| US20180013643A1 (en) | Determining events by analyzing stored electronic communications | |
| Slobodian et al. | Legal frameworks for mangrove governance, conservation and use: Assessment summary | |
| JP2023543715A (en) | Analytics platform for federated private data | |
| CN112817779A (en) | Communication method, device, equipment and medium for modular application program | |
| US10567468B2 (en) | Method and system for transparently manipulating downloaded files | |
| Luettgau et al. | NSDF-Catalog: Lightweight Indexing Service for Democratizing Data Delivery | |
| Laurie et al. | Survey for kouprey (Bos sauveli) in western Daklak Province, Vietnam | |
| Theodos et al. | The Location of Economic Development Administration Grants | |
| Weech‐Maldonado et al. | An Examination of COVID‐19 Mortality in High‐Minority Nursing Homes | |
| Shaw et al. | Demystifying IT: A framework for shared understanding between archivists and IT professionals | |
| Jang et al. | Evaluating client application status for V-World Open API service | |
| CN110414189B (en) | Remote non-inductive examination method and system for computer | |
| US20230328049A1 (en) | Enterprise governance inventory and automation tool | |
| US20230185954A1 (en) | Transmission of Sensitive Data in a Communication Network | |
| Harmon et al. | Feature Collection for IoT Devices using DPDK | |
| Siesi | 26 April 2021 WEEKLY REPORT FROM WSRN EARLY WARNING CENTER ON PREVENTING |
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 |