CN101297248B - Database interface for field device - Google Patents

Database interface for field device Download PDF

Info

Publication number
CN101297248B
CN101297248B CN200680039760.7A CN200680039760A CN101297248B CN 101297248 B CN101297248 B CN 101297248B CN 200680039760 A CN200680039760 A CN 200680039760A CN 101297248 B CN101297248 B CN 101297248B
Authority
CN
China
Prior art keywords
communication module
interface
measured value
database
web client
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.)
Expired - Fee Related
Application number
CN200680039760.7A
Other languages
Chinese (zh)
Other versions
CN101297248A (en
Inventor
安德烈亚斯·艾森曼
弗里多林·法伊斯特
拉尔夫·舍茨勒
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Vega Grieshaber KG
Original Assignee
Vega Grieshaber KG
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Priority claimed from DE102005051580A external-priority patent/DE102005051580A1/en
Application filed by Vega Grieshaber KG filed Critical Vega Grieshaber KG
Publication of CN101297248A publication Critical patent/CN101297248A/en
Application granted granted Critical
Publication of CN101297248B publication Critical patent/CN101297248B/en
Expired - Fee Related legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Landscapes

  • Computer And Data Communications (AREA)
  • Arrangements For Transmission Of Measured Signals (AREA)

Abstract

The present invention relates to a communication module for a measuring device with a first interface, a second interface and an integrated web client. The first interface can have a measuring device connected to it, whereas the second interface can have a database connected to it. The communication module is in a form such that it receives a measured value on the first interface and forwards it to the second interface using the web client.

Description

The database interface that is used for field apparatus
Present patent application requires the U.S. Provisional Patent Application 60/730,713 submitted on October 27th, 2005 and the right of priority of the German patent application 10 2,005 051580.0 submitted on October 27th, 2005, and its disclosed content is by with reference to being incorporated into this.
The present invention relates generally to the technical field of measuring technique.Especially, the present invention relates to a kind of communication module for measuring equipment, database, measured value acquisition system, arrange for the treatment of method and the measuring equipment of measured value.
When gathering measured value, usually the measured value with the various process parameter is bonded to each other, in order to realize analyzing based on this.At this, what occur more continually is, must different and usually each other away from the position obtain measured value, and these measured values must be transferred to middle position and store.Use central storage means can realize for example using unified Data Protection Scheme at different measured values.Possible is only to provide a kind of analysis framework, to handle different measurement results in addition.
Usually carry out in the position of measuring the measured value of physical process information translation for being analyzed by electronic data-processing equipment.Field apparatus is numerical value with the physical process information translation, and these numerical value must be forwarded to central analysis equipment at last.
Now, the transmission of the central database of procedural information from field apparatus to analytical equipment for example connects (Waehlverbindungen), is integrated into the Web server the field apparatus by exchange, sends by E-mail, SMS or by fax and carries out.In all these methods, in order to obtain metrical information, must be on one's own initiative from the receiver gathering information.This means that measured value is provided by field apparatus in the place of agreement, these measured values are extracted from this place by user, the example (Instanz) that particularly is further processed subsequently.
In order to make this extraction become easy, though can use polling method, this method is used for the regular time intervals inquiry and the information that is provided is provided, but be difficult to realize information extraction immediately after information is collected by this polling method or by the extracting method that the user triggers.And under irregular measured value collection situation, may occur be, inquiring and providing the time interval between the measured value very big, perhaps may occur inquiring with too short interval, make measuring system be subjected to extra load owing to inquiring frequently, and its performance be affected.
Task of the present invention is that a kind of better measured value generator is provided.
Correspondingly, provide a kind of and had the communication module that is used for measuring equipment according to the feature of independent claims, database, measured value acquisition system, for the treatment of the method for measured value and have measuring equipment and the measuring equipment of communication module is arranged.
According to one embodiment of present invention, provide a kind of communication module for measuring equipment, it has first and second interfaces and Web client.On first interface, can be connected with measuring equipment.By second interface, between communication module and database, can connect.
Communication module is built as and makes it by the Web client measured value that receives on first interface is transmitted to second interface, and measured value is provided there.
The Web client is a kind of application, and it is communicated by letter with Web server.Usually, the Web client is in order to use so-called HTTP(Hypertext Transport Protocol) with communicating by letter of Web server.In this article, the Web client also should can be understood as a process, and this process is as unit independently or be integrated in the total system and be performed at processor, and controls two communications between the system.Control information at the behavior of Web client obtains from institute's saved software.
After carrying out measurement, the Web client can identify and have effective measured value.The measured value that the Web client can provide first interface by communication module carries out offering database by second interface after the inter-process to measured value on communication module.Measured value or with measure related other information (for example address designation of measuring equipment number, the time of measurement or the duration of measurement) and can directly be transferred to database at this, perhaps be transferred in the memory storage of database.
By use the Web client and thus operational, at the affirmation mechanism of data transmission, the result of can the control survey value transmitting, and under error situation, can make corresponding reaction by communication module.For example, under the situation that causes makeing mistakes owing to wrong transmission (transmission of this mistake may be disturbed owing to transmission and cause), repeat transmission information.
According to another embodiment of the present invention, provide a kind of database that has interface and server.The interface of database is built as at this and makes it be suitable for being connected with the Web client or communicating by letter.Database can receive measured value, and wherein this measured value is by communication module, particularly by the Web client transmission that is integrated on the communication module.
In other words, this means that the interface of database and the interface of communication module are complementary, in order to can receive the information that is sent by communication module.In this context, coupling means to be not only interface physically the coupling each other of interface and especially database and communication module, and this coupling also relate to explain and extraction by the possibility of the information of communication module transmission.Wherein relate to usually the explanation of the information of carrying out at higher interface layer or protocol layer.
On communication module and database, carry out the treatment step opposite with transmission in order to communicate by letter.Communication module is packaged into the form that is suitable for transmitting according to rule given in advance with message, particularly measured value, and database, particularly server can extract this message according to corresponding rule.Like this, communication can be carried out to the direction of database in communication module, also can carry out in the opposite direction.
For the communication of database to the communication module direction, the server of database can be taken on the role with message packing and transmission message, and the Web client on communication module unpacks the message that receives.The rule that communicates institute's basis between communication module and database can be stored in the script or program coordinated with each other.
According to another embodiment of the present invention, provide a kind of measured value acquisition system that has at least one communication module and at least one database.The measured value acquisition system is built as and makes communication module provide measured value by the Web client for database.
By the measured value acquisition system, the reliable or fault-tolerant transmission of the information that can realize between communication module and database.
By the Web client, communication module can link to each other with database.Thus, can realize the reliable transmission of measured value between communication module and database, and the interface between communication module and database can mate with new requirement neatly.
According to another embodiment of the present invention, provide a kind of for the method for handling measured value by communication module.In order to implement this method, receive measured value at first interface, and by the Web client this measured value is transmitted at least one second interface.
Obtain in the expansion scheme of further expansion scheme by communication module and database of this method.
According to another embodiment of the present invention, provide a kind of measuring equipment to arrange.This measuring equipment is arranged the measuring equipment that has for gathering at least one measured value.In addition, this measuring equipment arranges to have communication module, and wherein on first interface, at least one measured value can be fed to this communication module.
Measuring equipment with communication module is arranged the direct visit that can realize the measured value of measuring equipment.Often may be necessary is that at the measuring equipment that can gather measured value with for example can edit between the analytic unit of the measured value of gathering and use bus system, this bus system is used for communicating between measuring equipment and analytic unit.What possibility was necessary for this reason is measured value to be converted to special bus signals.Have measuring equipment and communication module if measuring equipment is arranged, then communication module can need not measuring equipment is directly visited on intermediate conversion ground by bus measured value.Communication module can be integrated in the measuring equipment layout, perhaps for example can come integrated by spiral dead lock (Schraubverschluss).In this way and method, also can expand existing measuring equipment and it is retrofited.
According to another embodiment of the present invention, provide a kind of communication module, wherein first interface is the measuring equipment internal interface.
By the measuring equipment internal interface, communication module can directly be provided by the measuring-signal that is provided by measuring equipment or measuring unit.Thus, can avoid signal being converted to another transformat.This conversion for example can be necessary, in order to will link to each other with communication module away from the measuring equipment of communication module.For this reason, what possibility was necessary is for example (for example to pass through bus protocol
Figure S2006800397607D00041
Bus protocol) connects measuring equipment at a distance.By the measuring equipment internal interface is provided, needn't employs standard agreement and be used for transmission.
According to another embodiment of the present invention, provide a kind of communication module, wherein first interface be selected from I2C,
Figure S2006800397607D00042
Profibus, Fieldbus Foundation TM(foundation fieldbus) and VEGA VBUS.
When first interface during corresponding to canonical measure value host-host protocol, different measuring equipments can link to each other with communication module.What for example possibility was necessary is canonical measure value host-host protocol to be used for first interface, in order to the measuring equipment of different manufacturers is connected to communication module.In this article, interface itself is not only to refer to the physics plug, but should also comprise the agreement by the physical connection operation.Wherein should also comprise and use for example script.
According to another embodiment of the present invention, provide a kind of communication module, wherein second interface is write with script.Wherein can relate to the more high-rise of host-host protocol or interface.Description by the script docking port can realize the flexible coupling with the communication parter of communication module.For example for the communicating by letter of database, communication module may must provide definite information.Requirement for the type of wanting information transmitted, order and quantity can change.By by being loaded on the communication module and for example can using or describe interface by the script of the Web client executing of communication module, can realize the flexible coupling with database.
Second interface of communication module for example can be standard http interface, and the data that this interface will transmit when the http connection is set up are submitted to the form of single dos command line DOS as URI (unified resource identifier).In this dos command line DOS, different parameter (for example time of Ce Lianging, sequence number or measured value) can be encoded.So write the rule that second interface can be the Web client with script, the Web client should be expanded the HTML (Hypertext Markup Language) row according to this rule, and this HTML (Hypertext Markup Language) row should be transferred to communication parter.Calling among the HTTP can be need not by common now network to handle matchingly and understand.
According to another embodiment of the present invention, provide a kind of communication module, wherein this communication module can be connected to database by telecommunication media.Telecommunication media can be telephone network, directly connect or the Internet.Communicate to connect according to selected, can use different transmission equipments respectively.Directly connection for example can be by null modem (Nullmodem) or usually can be by the cross spider of RJ 45 or RS 232 standards.If communication module will be connected to telephone network, then may need the modulator-demodular unit for digital data transmission.If telecommunication media will be connected to the Internet, then use TCP/IP Socket software usually.
According to another embodiment of the present invention, provide a kind of communication module, this communication module is built as event control ground and transmits measured value.
Event control can make up in many ways.The example of event control is to provide measured value in the time of determining, definite date or the interval determined.Can firing event the event of control also for example can be measuring error, perhaps have measured value after finishing measuring.Surpassing or be lower than definite measured value also can firing event control.
According to another embodiment of the present invention, provide a kind of communication module, wherein the Web client is configured to software module.The Web client is configured to software module, and the life period that can be implemented in communication module can improve the software of Web client, and can move this improvement.In this way, the Web client can be mated with new software version, and needn't change whole communication module.
According to another embodiment of the present invention, provide a kind of database, wherein this database is fabricated the measured value that receives for storage.
The storage of measured value can be carried out data and collects, wherein importantly, and should comparison or go up the measured value of adjacent arrangement analysis time.These values can the random time after measuring be transferred from the storer of database.
According to another embodiment of the present invention, provide a kind of database, wherein this database is built as be used to being connected to communication module.And the coupling of communication module can realize the exchanges data of measured value between communication module and database.Thus, the function of measuring system can be distributed on the different unit.Communication module can be optimized at the transmission of measured value, and for example database can be optimized at the storage of data.
According to another embodiment of the present invention, provide a kind of database, wherein database has display device, and this display device is built as for showing measured value.By this display device, can be with the measured value stored from database, particularly from the memory storage of database, transfer, manifest and analyze according to rule given in advance in case of necessity.
According to another embodiment of the present invention, provide a kind of database, wherein the interface of database is write with script.Writing interface with script can realize making the communication of being undertaken by communication module to mate neatly with the emerging requirement of possibility.For example may be necessary is that store measurement values new or other parameter must be expanded between communication module and database thus and want information transmitted in order to store.By higher layer interface, that write with script, can be when the transmission measurement value at changing or new requirement be reacted.
According to another embodiment of the present invention, provide a kind of database, wherein database can link to each other with communication module by (being selected from the Internet, telephone network and direct-connected) telecommunication media.
Communication module and database can separate on the position.Particularly in the application of on the position, gathering as central data in away from each other the measurement scene (for example big plant area can occur like that), it can be favourable using telecommunication media between communication module and database.
Hereinafter with reference to accompanying drawing advantageous embodiments of the present invention is described.
Fig. 1 shows the block scheme of communication module according to an embodiment of the invention.
Fig. 2 shows the synoptic diagram that has the measuring equipment of integrated communication module according to an embodiment of the invention.
Fig. 3 shows the synoptic diagram of measured value acquisition system according to an embodiment of the invention.
That Fig. 4 shows is according to an embodiment of the invention, the synoptic diagram that is connected of communication module and database.
That Fig. 5 shows is according to an embodiment of the invention, be used for bringing in the input mask (Eingabemaske) at the script interface of transmission information by Web client.
Fig. 6 shows the initialization script of script situation according to an embodiment of the invention (Skriptfall).
Fig. 7 shows the database interface in the script according to an embodiment of the invention.
That Fig. 8 shows is according to an embodiment of the invention, at the process flow diagram of the script of Fig. 7.
Fig. 9 shows the script for querying database according to an embodiment of the invention.
That Figure 10 shows is according to an embodiment of the invention, at the process flow diagram of the script of Fig. 9.
View in the accompanying drawing is schematically and not to conform with ratio.In following description to Fig. 1 to Figure 10, use identical reference number for identical or corresponding element.
Fig. 1 shows the block diagram of communication module according to an embodiment of the invention.Communication module 101 has measured value treatment facility 105 and Web client 103.Measured value treatment facility 105 can be connected on the measuring equipment by first interface 106.For this reason, first interface 106 is for example corresponding to a kind of bus protocol, for example I 2C,
Figure S2006800397607D00071
Profibus, Fieldbus Foundation TM(foundation fieldbus) or VEGA VBUS.Thus, can be set up to the connection of the measuring equipment that has respective bus arbitrarily by first interface 106.
Measuring equipment can be arranged on outside the communication module 101, and therefore is not illustrated in Fig. 1.Communication between communication module 101 and measuring equipment is undertaken by first interface 106.At this, the measured value of measuring equipment arrives the measured value treatment facility 105 of communication module 101.
In measured value treatment facility 105, received measured value is prepared for transmission.That is to say, carry out format match or the analysis of measured value.By measured value treatment facility 105 is connected 104 with the inside that Web client 103 links to each other, ready measurement data or the data that will transmit are forwarded to Web client 103.Web client 103 be positioned at interface 102 near, Web client 103 links to each other with this interface 102.
In Web client 103, be can be by the data layout of telecommunication media transmission with data edition.For this reason, the data form or the HTML (Hypertext Markup Language) sentence structure that for example are converted into script format, can be read by script.Web client 103 links to each other with second interface 102 of communication module 101, and can be provided for the Another Application use by second interface 102 with form of scripts editor's data.
Not shown this application in Fig. 1.Yet this application examples is as being the database that has the interface of corresponding coupling.The interface of database can directly be connected with second interface 102 at this, perhaps connects by telecommunication media, and is to be understood that message format by the Web client-side editing.
Memory application can be away from communication module 101.For still can with this application communication, second interface 102 does not directly link to each other with this application, but is connected to telecommunication media.Telecommunication media can be for example telephone network, directly connect or the Internet.By this telecommunication media, can between database and communication module 101, carry out the position away from communication.
Fig. 2 shows the synoptic diagram that measuring equipment according to an embodiment of the invention is arranged, also namely has the measuring equipment of integrated communication module.In Fig. 2, communication module 101 directly links to each other with the measurement mechanism 201 of measuring equipment or sensor 203.Measurement mechanism 201 and sensor device 202 have together formed measuring equipment 203, sensor 203 or field apparatus 203.
Integrated physical connection between communication module 101 and sensor 203 for example can be set up by the spiral dead lock, wherein communication module 101 and measurement mechanism 201 screw thread that has coupling respectively.Communicating to connect between communication module 101 and sensor 203 can realize by second interface (not being illustrated in Fig. 2) of communication module 101.Communication module 101 can directly be obtained measured value from measurement mechanism 201.The measured value that measurement mechanism 201 is provided be the physical process parameter measured by sensor device 202 by the value behind the editor.
By the direct connection of measuring equipment 203, for example direct connection of level gauging equipment or pressure measuring device does not have the measuring equipment 203 of communication module can add communication module 101, and makes it possible to be connected to database.
Fig. 3 shows the synoptic diagram of measured value acquisition system according to an embodiment of the invention.Measured value acquisition system 301 has communication module 101 and database 304.Communication module 101 links to each other with the interface 303 of database 304 by second interface 102 of communication module 101.Transmission is undertaken by telecommunication media 302 (for example the Internet, Intranet, telephone network or directly connection).As the physical connection by telecommunication media 302, at two interfaces 102 and 303 for example can use that RS232 is connected, modulator-demodular unit connects or Ethernet connects.
Measured value is provided by two measuring equipments 203, and wherein these measuring equipments are made of sensor device 202 and measurement mechanism 201.Measuring equipment 203 links to each other with communication module 101 by first interface 106.Measuring equipment offers communication module 101 by first interface 106 with its procedure parameter of determining.First interface 106 for example can be
Figure S2006800397607D00081
Profibus, Fieldbus Foundation TM(foundation fieldbus) or VEGA VBUS.Measured value can irrespectively be carried out with another correspondence (for example communication module 101 and database 304 communicates by letter) by measuring equipment 203 to the communication of communication module 101.
Substitute measuring equipment 203, also analytical equipment 203 can be connected to communication module 101.This analytical equipment is for example as the VEGALOG 571 of VEGA company, VEGAMET 515 or VEGAMET 624 and obtain.Usually, the task of analytical equipment is, measuring equipment or the sensor of simulating is connected to digital distributed analysis system.Analytic system for example can be the database 304 of the server 305 under comprising.
Analog sensor does not have digital interface, and therefore at first can not be connected directly to the number bus system.Yet the sensor with analog interface can be connected to analytical equipment.Analytical equipment is collected the simulated data of analogue measurement equipment or analog sensor, and these data are converted to digital signal, and these signals for example are distributed to database by number bus system 102 or 106.Analytical equipment at this according to analogue measurement bus protocol and digital measurement bus protocol assumption agreement translation function or gateway function.In addition, exist under a plurality of analogue measurement sensor situation that are connected, analytical equipment analogue measurement parameter single, that provide is provided together, in order to these measurement parameters are sent in the concentrated area in individual digit stream.
The example of number bus system 106 is VEGA agreement DISBUS or LOGBUS, and wherein analytical equipment can be connected on the communication module 101 by this number bus system.Yet also can use any disclosed measurement bus system.
Yet also possible is that except being used for connecting the analog interface of simulation measuring equipment, analytical equipment also has be used to the interface that is connected to communication network 302, for example Ethernet interface.If analytical equipment itself additionally also has communication module, then analytical equipment can be connected to database, and needn't use independent communication module.That is to say that analytical equipment (particularly being integrated in communication module wherein) can be directly and database communication.
Communication module 101 also can be used in the measuring system of built modular.For this reason, communication module 101 for example can be constructed as the plug-in card in can the plug-in package supporting mass, and other module that can the Control Component supporting mass in the assembly supporting mass or plug-in card are to access of database.
The measured value of sensor 203 is with regular or irregular interval notifying communication module 101.Expire as the timing element in the communication module 101, in communication module 101, exist measured value or new measured value can be used as event.Other event is to be lower than or measured value that surpass to determine or the interference of sensor or communication module.Each event can cause measured value is transferred to database 304 from communication module 101.For example, communication module 101 is VEGAMET systems of VEGA company.The Web client that is positioned on the communication module 101 will be encoded to by the measured value that first interface 106 receives for database 304 readable and forms that can pass through network or telecommunication media 302 transmission.
For this reason, for example by the Web client 103 on the communication module 101 with existing, want information transmitted to be converted to the sentence structure consistent with URI, be used for transmitting by HTTP(Hypertext Transport Protocol).For example, have sequence number 12345678 (this sequence number is that the passage 1 at measuring equipment 203 is performed, and in label TAG1 value of providing 38) measuring equipment event by unit m on July 29th, 2005 10:5:21 be converted to following sentence structure:
/vmi/vmi_input.php?sernum=12345678&channel=1&tag=TAG1&val=38&unit=m&date_time=2005-07-29?10:5:21。
The TCP that communication module 101 is interrupted the port 80 (http port) to database connects, and connect set up after, with the http head " GET/vmi/vmi_input.php? sernum=12345678﹠amp; Channel=1﹠amp; Tag=TAG1﹠amp; Val=38﹠amp; Unit=m﹠amp; Date time=2005-07-29 10:5:21 http/1.0 " introduce and inquire.Substitute GET, fully also can use other http transmission method, for example POST or HEAD.
This script calls and can come notification database 304 by telecommunication media 302 by http protocol.Physical interface 303 at database is connected with server 305.This server for example can be the Apache of server family, PHP and MySQL, or the IIS of server family, SQL, ASP server.At this, each server can be respectively independently and distributed server.In addition, can be as requested with the server combination in any.
Runnable interface script 306 and display script 308 on server 305, wherein this server 305 has constituted database 304 with memory storage 307.
In communication module 101 or the Web client that is performed in the equipment 101 at the scene information is connected by HTTP and to be transferred to server 305.On this server 305, from interface script 306 (for example CGI, PHP or ASP script), obtain information.These values are stored in the memory storage 307 by connecting 309 subsequently.Thus, value is stored in the database 304.
Database 304 is arranged in communication network 302.In this way, website custody provider (Webhosting Provider) for example can run the database 304 for field apparatus 101.By distribution communication module 101 and database 304, each system can move dividually.The information of the information of field apparatus 203 or communication module 101 can directly be transferred in the database 304.At this, communication module can monitor the result of this transmission or this action, and reacts under the situation of makeing mistakes.By CRC check and the feedback that has mistake, by database 304, particularly server 305 is notified the situation of makeing mistakes to communication module.After identifying this mistake, communication module 101 can repeat transmission.Under case of successful, communication module 101 obtains " finishing (Done) " message.
Script 306 is used for receiving the measured value that is sent by communication module 101, and is stored in measured value on the memory storage 307 or controls this storage.
In order to inquire or assay value, measured value particularly is by connecting 310 with display device 311 or display device 311 and database 304 and particularly linking to each other with display script 308 in server 305 operations.Connecting 310 can realize by the telecommunication media 302 identical with the connection between communication module 101 and database 304.Especially, display device 311 can link to each other by directly being connected 310 with database 304.In order to show, for example can to start display script 308 on the server by Web browser by display device 311, and read the measured value that is stored on the memory storage 307 thus.By display script 308, measured value for example can be converted into definite display format, and is used to show.
That Fig. 4 shows is according to an embodiment of the invention, the synoptic diagram that is connected of communication module 101 and database 304.For example, if use the Internet or Intranet as telecommunication media 302, then can use and in Intranet or the Internet, be provided for all protection mechanisms that protected data connects.An example of the protection mechanism in the Internet or Intranet 302 is to use so-called virtual connections 401 (VPN) or tunnel 401.At this, the input end of communication network 302, namely further be embodied as in the Virtual Channel 401 with being connected of interface 102 and 303 and be connected 402.
At tunnel internal, data can be encrypted.Use standard agreement to be used for transmitting measured values as HTTP and make that transmission is transparent for network 302, thus, can use the standard security method of telecommunication media 302 to connect for data.Thus, the data protection by virtual path 401 can need not to be used for matchingly measured value is transferred to database 304 from communication module 101.
That Fig. 5 shows is according to an embodiment of the invention, be used for the input mask by the script interface of Web client transmissions information.For this reason, figure 5 illustrates input mask 501.On input mask 501, can describe some values.These values can be the values that will transmit.For example, can be sequence number 502, for example have value 12345678.Other value can be the label 503 with value TAG1.Another value that will transmit can be that value is 38 value 504, and at input mask 501 unit 505 has been described at last, and it can have value m.Thus, generate URI (unified resource identifier) sentence structure (Schreibweise) that mates with interface 306 from these input values 502,503,504,505 by the Web client and be used for transmitting by HTTP, this sentence structure has following form.
/vmi/vmi_input.php?sernum=12345678&channel=1&tag=TAG1&val=38&unit=m&date_time=2005-07-29?10:5:21。
The value that provides correspondingly is converted to the URI data layout and is finished by the Web client by the communication of http subsequently.
Fig. 6 shows the initialization script for script file according to an embodiment of the invention.For the expression of unanimity, can be summarized in together and available in configuration file for script file 306 and 308 necessary parameter.For example, can use Bian Liang $g_hostname, $g_port, $g_db_username, $g_db_passowrd Yi Ji $g_database_name.Thus, variable for example can be preset with following value:
$g_hostname=“localhost”
$g_port=3306
$g_db_username=“root”
$g_db_passowrd=“”
$g_database_name=“vmi”。
Thus, corresponding value is provided for the script file use with corresponding title.
Fig. 7 shows the database interface in the script according to an embodiment of the invention.
Fig. 8 shows the process flow diagram that belongs to Fig. 7.What can see in Fig. 8 is, S0 begins with stationary state, according to the configuration file described in Fig. 6 all variablees that are used is carried out initialization in first step S1.Thus, the parameter in the loading scripts file.
In step S2 subsequently, be disconnected to the connection of database, the availability of wherein controlling database simultaneously.After the connection that is disconnected to database, in step S3, receive message by the Web client, and from the script file that receives or the address file of summing up, extract measured value or the other value of information.
In following step S4, the value of extracting is provided in the pre-determined position of memory storage 307 of database 304 for use.After these values were stored in the database in step S4, the process of Fig. 8 turned back among the stationary state S5.
Fig. 9 shows the script for querying database according to an embodiment of the invention.
Figure 10 shows the process flow diagram that belongs to Fig. 9.Can be drawn by Figure 10, from stationary state S10, in step S11, carry out the initialization of parameter by the configuration file among Fig. 6 equally.After this initialization, in step S12, can set up and being connected of database 304, particularly with being connected of the memory storage 307 of database.Simultaneously, the existence to database is tested in step S12.
In step S13, from database 304, read desired information, and in step S14, show the moment of the information, for example measured value or the measured value that are read with defined mode and method in the script.After reading in step S14 and showing measured value, this program turns back to stationary state S15.
Will be pointed out that additionally that " having " do not get rid of other elements or step, and " one " does not get rid of a plurality of.In addition, it is to be noted, also can be used in combination with additional features or the step of above-described additional embodiments with reference to the described feature of one of above-described embodiment or step.Reference number in the claims should not be considered as restriction.
Communication module and database by with pressure measuring device and level gauging device association be described.For technicians, be apparent that this description relates generally to measuring equipment.Other examples of measuring equipment are temperature measurement equipment, flow measurement or gas measuring apparatus.

Claims (14)

1. communication module (101) that is used for pressure measuring device or level gauging equipment has:
First interface (106);
Second interface (102);
Web client (103);
Wherein first interface (106) is built as be used to being connected to measuring equipment (203);
Wherein second interface (102) is built as be used to being connected to database (304);
Wherein Web client (103) is configured to and will be encoded in the inquiry by the http head by the measured value of first interface (106) reception;
Wherein the http head has at least one among http transmission method GET, POST or the HEAD;
Wherein communication module (101) is built as the measured value that will receive on first interface (106) and offers second interface (102) by Web client (103).
2. communication module according to claim 1 (101), wherein first interface (106) is the measuring equipment internal interface.
3. communication module according to claim 1 (101), wherein first interface (106) is selected from I 2C,
Figure FSB00001022419200011
Profibus, Fieldbus Foundation TMAnd VEGA VBUS.
4. according to each described communication module (101) in the claim 1 to 3, wherein second interface (102) is write with script.
5. according to each described communication module (101) in the claim 1 to 3, wherein communication module (101) can be selected from the Internet, telephone network and direct-connected telecommunication media (302) by at least one and be connected to database (304).
6. according to each described communication module (101) in the claim 1 to 3, wherein communication module (101) is built as in the mode of event control and transmits measured value.
7. according to each described communication module (101) in the claim 1 to 3, wherein Web client (103) is built as software module.
8. database (304) that is used for pressure measuring device or level gauging equipment has:
Interface (303);
Server (305);
Wherein database (304) is built as for being connected to according to each described communication module (101) of claim 1 to 7;
Wherein interface (303) is fabricated the communication module (101) that has Web client (103) be used to being connected to;
Wherein database (304) is built as received communication module (101) to be encoded to the measured value that the mode in the inquiry sends by the http head;
Wherein the http head has at least one among http transmission method GET, POST or the HEAD.
9. database according to claim 8 (304) also has:
Display device (311);
Wherein display device (311) is built as the demonstration measured value.
10. according to Claim 8 or 9 described databases (304), wherein interface (303) is write with script.
11. according to Claim 8 or 9 described databases (304), wherein database (304) can be connected to communication module (101) by being selected from the Internet, telephone network and direct-connected telecommunication media (302).
12. a measured value acquisition system (301) has: at least one is according to each described communication module (101) in the claim 1 to 7;
At least one is each described database (304) in 11 according to Claim 8;
Wherein measured value acquisition system (301) is built as: make communication module (101) by Web client (103) measured value be offered database.
13. a method that is used for handling by communication module measured value, wherein this method comprises:
Receive measured value at least one first interface;
To be encoded in the inquiry by the http head by the measured value that first interface receives;
Wherein the http head has at least one among http transmission method GET, POST or the HEAD;
The measured value that to encode by the Web client is transmitted at least one second interface.
14. a measured value acquisition system has:
Be used for gathering the measuring equipment (203) of at least one measured value;
According to each described communication module (101) in the claim 1 to 7, on first interface (106), described at least one measured value can be flowed to this communication module (101).
CN200680039760.7A 2005-10-27 2006-10-26 Database interface for field device Expired - Fee Related CN101297248B (en)

Applications Claiming Priority (5)

Application Number Priority Date Filing Date Title
US73071305P 2005-10-27 2005-10-27
DE102005051580.0 2005-10-27
US60/730,713 2005-10-27
DE102005051580A DE102005051580A1 (en) 2005-10-27 2005-10-27 Communication module for a measuring device comprises a first interface connected to a measuring device, a second interface connected to a data bank and a web client
PCT/EP2006/010334 WO2007048608A1 (en) 2005-10-27 2006-10-26 Database interface for field device

Publications (2)

Publication Number Publication Date
CN101297248A CN101297248A (en) 2008-10-29
CN101297248B true CN101297248B (en) 2013-07-10

Family

ID=40066593

Family Applications (1)

Application Number Title Priority Date Filing Date
CN200680039760.7A Expired - Fee Related CN101297248B (en) 2005-10-27 2006-10-26 Database interface for field device

Country Status (1)

Country Link
CN (1) CN101297248B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
DE102011107323A1 (en) * 2011-07-06 2013-01-10 Abb Ag Method for transmitting a process image via a gateway device

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1525271A (en) * 2003-01-28 2004-09-01 ����-��˹â��ϵͳ�ɷ����޹�˾ Process control system with an embedded safety system
CN1561472A (en) * 2001-08-21 2005-01-05 柔斯芒特阿纳利蒂卡尔公司 Shared-use data processing for process control systems
CN1609918A (en) * 2004-11-22 2005-04-27 上海理工大学 System integrated process control and communication experiment system

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1561472A (en) * 2001-08-21 2005-01-05 柔斯芒特阿纳利蒂卡尔公司 Shared-use data processing for process control systems
CN1525271A (en) * 2003-01-28 2004-09-01 ����-��˹â��ϵͳ�ɷ����޹�˾ Process control system with an embedded safety system
CN1609918A (en) * 2004-11-22 2005-04-27 上海理工大学 System integrated process control and communication experiment system

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
CN 1561472 A,说明书第5-14页、附图1-2.
V.Kapsalis,A.kalogeras,K.Charatsis,G.Papadopoulos.Seamless Integration of distributed real time monitoring and control applications utilising emerging technologies.IECON’01: The 27th annual conference of the IEEE Industrial electronics society.2001,176-180. *

Also Published As

Publication number Publication date
CN101297248A (en) 2008-10-29

Similar Documents

Publication Publication Date Title
US20020046221A1 (en) Method, system, and apparatus for providing data regarding the operation and monitoring of a control system
US20140188933A1 (en) Method for Operating a Field Device
CN105794152B (en) The system and method and device of the interaction based on web are carried out with building automatic
CN108667807A (en) A kind of protocol self-adapting method and system based on monitoring cloud platform and gateway
US7685267B2 (en) Method and system for connecting to a field device
CN103136095A (en) Method, device and system of test application program interface
US11595468B2 (en) Data capture on a serial device
US7725627B2 (en) Serial port that supports multiple protocols
CN101371245A (en) Distributed capture and aggregation of dynamic application usage information
CN105138454B (en) A kind of automated testing method for B/S framework security softwares
CN107463453A (en) Method, apparatus, equipment and the storage medium to be communicated between same terminal different application
CN102594618A (en) Method and device for realizing storage device test of storage area network (SAN)
CN108376111A (en) Information processing unit, information processing method and recording medium
US20240056463A1 (en) Method and system to detect abnormal message transactions on a network
KR101478903B1 (en) Service providing method and system for processing information of node based on profile of node in instance hosting environment
KR101478902B1 (en) Method and system for providing service based on profile according to node property in instance hosting environment
CN104735126A (en) Method for transferring data from a field device to a web browser
Aguirre et al. Low-cost supervisory control and data acquisition systems
CN101297248B (en) Database interface for field device
CN201726425U (en) Embedded network server
CN113190286A (en) MES system, loading method, terminal and medium for dynamically and remotely loading functional plug-ins
CN106292578A (en) A kind of sewage treatment plant operation data acquiring and transmission system
CN117130318B (en) Industrial data acquisition method, device, system and readable storage medium
Ashraf et al. Implementation of Intranet-SCADA using LabVIEW based data acquisition and management
Kirubashankar et al. A real-time web-enabled platform for information monitoring and fault diagnosis in a distributed control system

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant
CF01 Termination of patent right due to non-payment of annual fee
CF01 Termination of patent right due to non-payment of annual fee

Granted publication date: 20130710

Termination date: 20211026