230 likes | 380 Views
Long Term Static Monitoring Software SDB.Net Presented by: Daniele Posenato. SDB. Contents. Introduction Old SDB Main characteristics Problems SDB.Net : what news Conclusion Questions and Answers. SDB. Introduction . Introduction software. Monitoring. Distributed.
E N D
Long Term Static Monitoring SoftwareSDB.Net Presented by: Daniele Posenato SDB
Contents • Introduction • Old SDB • Main characteristics • Problems • SDB.Net: what news • Conclusion • Questions and Answers SDB
Introduction software Monitoring Distributed Point SDB DiView Static DyMon DyMon Dynamic
Old SDB introduction SDB is the acronym of Standard Data Base • Scheduling, downloading, measuring of SOFO Sensors and thermocouples • Save the measurements on a MS Access database • Visualize the history of a sensor on graph or table • Set zero measurement
Old SDBintroduction • SDB Standard– scheduling, downloading, control, visualization • SDB View – visualization, export, setting of warnings • SDB Pro – virtual sensors, real-time partial analysis • SDB SPADS – deformed shape, spatial analysis
Old SDBproperties 3rd Parties MuSt Sensoptic Campbell SOFO Adam SDB Database SOFO SDB SDB View SDB Pro
Old SDB Problems • It is written in Microsoft VB6, that it is not anymore supported by Microsoft • One single exe file for the configuration, scheduling, processing, visualization and warning • It works only with MS access database • It can manage only small databases • It uses obsolete libraries • It can have problems during the installation on new MS OS • Since Vb6 is not a structured language: • The maintenance is difficult, domino effect • It is not flexible, add a new sensor or a new reading unit require a lot of programming • It is difficult to test • It has an old style fashion
SDB.Net characteristics • SDB.Net is the natural evolution of the SDB software with the aim to overcome all the limitations present on the original SDB • It is completely developed in C#.NET, compatible with .net framework 3.5 and later versions and it can be run on all the Microsoft platforms • It is much more flexible and adaptable to the client necessities • It will be much easier to be maintained and expanded • The SDB.Net designed based on a client-server architecture in which the Kernel (server) works as service and interacts directly with the reading units and with the database where the measurements are saved. At the same time, it answers over to all the requests received from all the active User Interfaces (clients) that can be located on the same PC or remotely over a data network
SDB.Net characteristics • Several types of databases are currently supported: MS Access, SQL server, Postgres, Oracle, MySQL… • Multiple users using the UI can send the requests of data via internet to the same Kernel located everywhere in the world • It manages most the reading units and sensors of the Roctest group • The integration of a new sensor or a new reading unit is simplified • A single Kernel can simultaneously manage several local and remote databases of different types • A UI can access several Kernels at the same time, allowing e.g. connection to multiple sites • It can send automatically email or SMS in case of warning • Auto synchronization of a remote database with a local copy, for backup and replication
SDB.Net functioning principle Kernel (User Interface) User Interface Net User Interface User Interface
SDB.Net Kernel • It is installed as a service • A single Kernel can simultaneously manage several local and remote databases of different types • It processes at the same time several UI requests • It manages the warnings, sends email and SMS • It plays several agendas and saves the measurements • It manages the all the requests for the DB synchronization
SDB.Net User Interface • Installed as an application • It can communicate to the local copy of the database or directly with a remote kernel • It allows • To create and modify the configuration of sensors, agendas, reading units • Control the execution of a measurement (measure now) • To create views of the data (sensors, period of visualization) • Manage the warning criteria (thresholds, emails, phone numbers,…)
SDB.NetPro introduction • It requires a license • Simplify real-time interpretation of the measurements • Possibility to combine real sensors using mathematical functions to create more powerful sensors • Real-time calculation and presentation of indirectly measured parameters such as • curvature • average shear strain • thermal strain • load etc… • Visualization and analysis of calculated measurements • Enable the use of Must, Sensoptic, Campbell, read from file and other sensors
SDB.Netpro Createsensorsbased on complexmathematical functions
SDB.NetView introduction • Automatic data export of • Selected group of sensors • Selected monitoring periods • Complete data visualization of selected group of sensors over selected monitoring periods in form of • Tables • Diagrams • Values presented on structure's photo, schema or plan • Automatic elaboration and visualization in real-time environment • Pre-Warnings and Warnings in form of • Yellow and red fields in tables or structure’s photo, schema or plan • Perform action on critical situations (E-mails, SMS) • Save the view to database (It requires a license)
SDB View • Data visualization • Pre-warnings and Warnings • Automatic data exporting to txt, xls, html, xml..
SDB.NetView warnings • In case of pre-warning or warning can be sent via • SMS • Email • In a xml configuration file can be specified several • SMS systems (GSM modem via RS232 or via TCP, or web services) • SMTP servers • In case of a service does not work the next one is used, this to guarantee a redundancy • If the SDB fails to send a warning after a certain period it retries to resend it
SDB.Netconclusion • Based on .NET framework • Designed for static monitoring of point wise sensors • Compatible with many database types • Direct access to the remote data via client-server architecture • Direct access to a local copy for offline analysis • More flexible and easier to maintain • Multiple agendas can be active at the same time
Thank you for your attention SMARTEC Where instrumentation technologies meet http://www.roctest-group.com