The industry data analysis system by database

Paweł Drzymała, Henryk Welfle, Sławomir Wiak, Jakub Rutkowski


The paper presents the possibility of creating of network application to preview and the analysis of data process, accumulated by system of SCADA class (Supervisory Control And Data Acquisition). The Siemens – WinCC system was used as accumulating data platform. The main functions of presented system is the access to the current data (the measurements), their analysis, visualization, the monitoring of the productive alarms as well as the filing of accumulated data. The paper presents the example of practical use of modern technologies integration to built the effective, industrial solution.


database; management system; SCADA; WinCC; MS SQL Server 2005; web application; Google Web Toolkit

Full Text:

PDF (Polski)


Dokumentacja i materiały firmy Siemens

Cooper R, Collins Ch.: GWT in Practice. Manninng, 2008.

Watt A.: .Microsoft SQL Server(tm) 2005 for Dummies. Wiley Publishing Inc, Indianapolis 2006.

Begin C, Goodin B.: iBatis in Action. Manninng, 2007.

Kay M.: XSLT Programmer's Reference. Wrox Press, Birmingham 2005.

Tickwell D.: XSLT Mastering XML Transformations. O'Reilly, 2006.

Specyfikacja XSLT 2.0

Microsoft Developer Network

Drzymała P., Welfle H., Wiak S.: System sterowania przepływem pracy w oparciu o środowisko Oracle Workflow. "Bazy danych. Rozwój metod i technologii. Bezpieczeństwo, wybrane technologie i zastosowania" pod redakcją: S. Kozielski, B. Małysiak, P. Kasprowski, D. Mrozek, WKŁ, Warszawa 2008, s. 27-48.