search query: @instructor Aro, Jouni / total: 9
reference: 6 / 9
« previous | next »
Author:Asikainen, Jukka
Title:OPC UA Java History Gateway with Inherent Database Integration
OPC UA Java Historia-Gateway ja tietokantaintegraatio
Publication type:Master's thesis
Publication year:2014
Pages:vii + 54 s. + liitt. 8      Language:   eng
Department/School:Sähkötekniikan korkeakoulu
Main subject:Automaation tietotekniikka   (AS-116)
Supervisor:Seilonen, Ilkka
Instructor:Aro, Jouni
Electronic version URL: http://urn.fi/URN:NBN:fi:aalto-201405131796
OEVS:
Electronic archive copy is available via Aalto Thesis Database.
Instructions

Reading digital theses in the closed network of the Aalto University Harald Herlin Learning Centre

In the closed network of Learning Centre you can read digital and digitized theses not available in the open network.

The Learning Centre contact details and opening hours: https://learningcentre.aalto.fi/en/harald-herlin-learning-centre/

You can read theses on the Learning Centre customer computers, which are available on all floors.

Logging on to the customer computers

  • Aalto University staff members log on to the customer computer using the Aalto username and password.
  • Other customers log on using a shared username and password.

Opening a thesis

  • On the desktop of the customer computers, you will find an icon titled:

    Aalto Thesis Database

  • Click on the icon to search for and open the thesis you are looking for from Aaltodoc database. You can find the thesis file by clicking the link on the OEV or OEVS field.

Reading the thesis

  • You can either print the thesis or read it on the customer computer screen.
  • You cannot save the thesis file on a flash drive or email it.
  • You cannot copy text or images from the file.
  • You cannot edit the file.

Printing the thesis

  • You can print the thesis for your personal study or research use.
  • Aalto University students and staff members may print black-and-white prints on the PrintingPoint devices when using the computer with personal Aalto username and password. Color printing is possible using the printer u90203-psc3, which is located near the customer service. Color printing is subject to a charge to Aalto University students and staff members.
  • Other customers can use the printer u90203-psc3. All printing is subject to a charge to non-University members.
Location:P1 Ark Aalto  1084   | Archive
Keywords:OPC UA Gateway
Java
SQL
OPC UA History Data
välityspalvelin
historiadata
Abstract (eng):OPC Unified Automation is a highly-developed information modelling and managing framework in use in the automation industry.
OPC UA takes into account the communication, data modelling and security aspects w.r.t information exchange between devices in the factory floor.
In practice the information exchange is done between server and client instances.
Of these, servers hold the process data, and clients access it.
An intermediate gateway is developed, which accesses (and allows managing) several other servers from a single instance.
The storing of process data within the OPC UA framework is another main topic of this thesis.
The thesis presents an SQL data model to storing time series process data acquired from multiple servers.
The data itself is modelled using the OPC UA semantics.
Additionally, the connectivity and data mapping to few SQL implementations is solved.
A solution addressing both the storing and integration aspects is introduced in the form of the OPC UA History Gateway.
The OPC UA History Gateway illustrates capabilities of the OPC UA framework in the data acquisition and device integration in the modern automation environment.
The implemented (prototype) solution is shown to aggregate and store plant floor device information.
The OPC UA History Gateway also provides trend data to clients, making more refined data analysis possible.
Abstract (fin):OPC Unified Automation on automaatioteollisuudessa käytetty määrittely tiedon mallintamiseen ja hallintaan.
Määrittely kuvaa mm. kommunikoinnin, tiedon mallintamisen ja turvallisen tiedonsiirron automaatiolaitteiden välillä.
Tiedonsiirto tapahtuu palvelimien ja näihin yhteydessä olevien asiakassovellusten välillä.
Työssä toteutetaan eräänlainen välityspalvelin (gateway) tiedon kokoamiseen.
Välityspalvelin on yhteydessä useisiin muihin palvelimiin, joiden tietoja voi käsitellä sen kautta.
Työn toinen tärkeä osa-alue on prosessitiedon tallentaminen SQL tietokantaan.
Tähän tarkoitukseen työssä esitellään tietokannan rakenne, joka mahdollistaa OPC UA:lla mallinnetun tiedon tallentamisen (ja palauttamisen).
Työssä myös toteutetaan prosessitiedon tallennus ja luku tietokannasta Javaa ja OPC UA:ta käyttäen.
Samalla ratkaistaan osittainen OPC UA tietomallin esittäminen SQL tietokannassa.
Työn ratkaisuna on prototyyppi OPC UA historiavälityspalvelimesta.
Palvelin kokoaa useiden OPC UA palvelimien tietoja yhteen palvelimeen ja kykenee näin yhdistämään laitetietoja laajalta alalta.
Palvelin myös tarjoaa aikasarjoja (pysyvästi) tallennetusta prosessidatasta, mikä mahdollistaa kehittyneemmän tiedon analysoinnin.
ED:2014-06-18
INSSI record number: 49321
+ add basket
« previous | next »
INSSI