Database Architecture of Diagnostic System for Large Power Transformers

  • Liliana Byczkowska-Lipińska
  • Agnieszka Wosiak
Part of the Studies in Computational Intelligence book series (SCI, volume 225)


Supporting service staff is the most important task of expert system for technical state of electric device. Permanent data acquisition enables displaying current parameters and forecasts for the future. It is also recommendable for the system to provide remedy actions in case of a particular fault.

According to above - mentioned requirements, computer system for monitoring power transformers was designed and implemented. The project of a database is one of the most important elements, that must have been taken into consideration during the process of system implementation.


Diagnostic System Data Compression Power Transformer Structure Query Language Manufacturing Execution System 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Asaro, T.: Intelligent Data Archiving. The Enterprise Strategy Group, Inc (2007)Google Scholar
  2. 2.
    Bugajny K., Kaźmierski M., Kersz I., Pinkiewicz I., Wosiak A., Olech W., Rzeczkowski A., Szymański Z.: System monitoringu transformatorów sieciowych weksploatacji, oprogramowanie systemoweGoogle Scholar
  3. 3.
    Cichosz, P.: Systemy uczace sie, Wydawnictwa Naukowo–Techniczne, Warszawa (2000)Google Scholar
  4. 4.
    Keene, W.N.: Large Database Alternatives. NEON Enterprise Software, Inc. (2007)Google Scholar
  5. 5.
    Korbicz, J., Kościelny, J.M., Kowalczuk, Z., Cholewa, W.: Diagnostyka procesów, WNT Warszawa (2002)Google Scholar
  6. 6.
    Lipinski, P., Puchala, D., Wosiak, A., Byczkowska–Lipinska, L.: Transformer Monitoring System Taking Advantage of Hybrid Wavelet Fourier Transform. In: ISEF 2007—XIII International Symposium on Electromagnetic Fields in Mechatronics, Electrical and Electronic Engineering Prague, Czech Republic, September 2007, s 126–129 (2007)Google Scholar
  7. 7.
    Lipiński, P.: A New Adaptive Wavlet Transform. In: Proceedings of the 11th International Conference on System Modelling Control, Warszawa 2005, s 179–188 (2005)Google Scholar
  8. 8.
    Mulawka, J.: Systemy ekspertowe. WNT Warszawa (1996)Google Scholar
  9. 9.
    Mullins, C.S.: Database Archiving: Managing Data for Long Retention Periods, NEON Enterprise Software, Inc. (2007)Google Scholar
  10. 10.
    Sayood, K.: Kompresja danych. Wprowadzenie, Wydawnictwo RM, Warszawa (2002)Google Scholar
  11. 11.
    Baum J., Dornemann K., Stirl T., Tenbohlen S.: Enhanced Diagnosis of Power Transformers using On—and Off–line Methods: Results, Examples and Future Trends, Cigre, paper 12–204, Paris, 2000Google Scholar
  12. 12.
    Liebfried, T., Knorr, W., Kosmata, A., Sundermann, U., Viereck, K., Dohnal, D., Breitenbauch, B.: On–line Monitoring of Power Transformers–Trends. In: New Developments and Firs Experiences, Cigre, 12–211, Paris (1998)Google Scholar
  13. 13.
    Pettersson, L., Fantana, N.L., Sundermann, U.: Life Assessment: Ranking of Power Transformers Using Condition Based Evaluation. A New Approach. Cigre 12–204, Paris (1998)Google Scholar
  14. 14.
    Provanzana, J.H., Gattens, P.R., Hagman, W.H., Moore, H.R., Harley, J.W., Triner, J.E.: Transformer Condition Monitoring—Realizing an Integrated Adaptive Analysis System, Cigre 12 - 105, Paris (1992)Google Scholar
  15. 15.
    Kavamura, T., Fushimi, Y., Shimano, T., Amano, N., Ebisawa, Y., Hosokawa, N.: Improvement in Maintenance and Inspection and Pursuit of Economical Effectiveness of Transformers in Japan, Cigre 12–107, Paris (2002)Google Scholar
  16. 16.
    Boss, P., Lorin, P., Viscardi, A., Harley, J.W., Isecke, J.: Economical aspects and practical experiences of power transformer on - line monitoring, Cigre 12–202, Paris (2000)Google Scholar
  17. 17.
    Aschwanden, T., Hassig, M., Fuhr, J., Lorin, P., Houhanessian, V., Zaengl, W., Schenk, A., Zweiacker, P., Piras, A., Dutoid, J.: Development and application of new condition assessment methods for power transformers, Cigre 12–207, Paris (1998)Google Scholar
  18. 18.
    Carbonell, J.G., Michalski, R.S., Mitchell, T.M.: An overview of machine learning. Machine learning: An Artificial Intelligence Approach, Vol. 1, Tioga (1983)Google Scholar
  19. 19.
    Byczkowska–Lipińska, L., Wosiak, A.: Projekt inteligentnego systemu diagnostyki wibroakustycznej, Materialy konferencyjne. In: VI Krajowa Konferencja Naukowo–Techniczna DPP 2003 (2003)Google Scholar
  20. 20.
    Byczkowska - Lipińska L., Wosiak A.: Architecture of Monitoring System For Large Power Transformers. In: Techniczna Elektrodynamika, Kijów 2006, no. 6, str.: 32–35 (2006) ISSN 0204–3599Google Scholar
  21. 21.
    Byczkowska–Lipińska L., Wosiak A.: Zastosowanie Systemu Informatycznego w Diagnostyce Transformatorów. In: XVI Sympozjum PTZE, Zastosowania Elektromagnetyzmu w Nowoczesnych Technikach i Informatyce, Wisa 25–27 wrzenia 2006, str. 73–75 (2006) ISSN 1233–3336Google Scholar
  22. 22.
    Wosiak, A.: System monitorowania pracy transformatora energetycznego. In: V Sympozjum Modelowanie i Symulacja Komputerowa w Technice, Wyzsza Szkola Informatyki, Lodz 2006, str. 133–136 (2006)Google Scholar
  23. 23.
    Kaźmierski, M., Kersz, I., Wosiak, A.: System monitoringu stanu transformatorów w ukadzie ”on - line”, realizacja praktyczna. Konferencja Zarzadzanie Eksploatacja Transformatorów, Wisa Jawornik 26–28 kwietnia 2006, str. 121–134 (2006)Google Scholar
  24. 24.
    Byczkowska - Lipińska L., Wosiak A.: Monitoring System of the State of Electric Devices. In: Proceeding of the International Conference TCSET, Modern Problems of Ratio Engeneering Telecomminications and Copmuter Science, Lviv - Slavske, Ukraine, February 28–March 4 2006, str. 31–33 (2006)Google Scholar
  25. 25.
    Kaźmierski, M., Kersz, I., Wosiak, A.: System monitoringu stanu transformatorów energetycznych, wstepne doświadczenia eksploatacyjne, Przeglad Elektrotechniczny Konferencje 2006, nr 1, ss. 121–124 (2006)Google Scholar
  26. 26.
    Byczkowska-Lipińska, L., Wosiak, A.: System diagnostyczny do oceny stanu pracy transformatora energetycznego, Przeglad Elektrotechniczny nr 12/2006 (2006)Google Scholar
  27. 27.
    Gunderloy, M., Chipman, M.: SQL Server 7, Mikom, Warszawa (1999)Google Scholar
  28. 28.
    Gallagher, S.: Microsoft SQL Server 7. Ksiega Experta, Helion, Warszawa (2000)Google Scholar
  29. 29.
    Riordan, R.M.: Programowanie Microsoft SQL Server 2000 krok po kroku, Read–Me, Warszawa (2001)Google Scholar
  30. 30.
    Brachman, R., Levesque, H.: Readings in Knowledge Representation. Morgan Kaufmann, Los Altos (1985)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2009

Authors and Affiliations

  • Liliana Byczkowska-Lipińska
    • 1
  • Agnieszka Wosiak
    • 1
  1. 1.Institute of Computer ScienceTechnical University of LodzLodzPoland

Personalised recommendations