Error
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering

INFORMATION SYSTEMS AND LOGISTICS IN CIVIL ENGINEERING

FUNDAMENTALS OF DATA SUPPORT OF SYSTEMS OF CONTINUOUS MONITORING OF THE TECHNICAL CONDITION OF UNIQUE STRUCTURES

Vestnik MGSU 11/2012
  • Soshnikov Aleksandr Aleksandrovich - Moscow State University of Civil Engineering (MGSU) postgraduate student, Department of Information Systems, Technology and Automation in Civil Engineering, Moscow State University of Civil Engineering (MGSU), 26 Yaroslavskoe shosse, Moscow, 129337, Russian Federation; This e-mail address is being protected from spambots. You need JavaScript enabled to view it .

Pages 283 - 287

Currently, continuous monitoring of the technical condition of structures is in most cases reduced
to control over indicators compared to a set of limit values. The monitoring system alerts responsible
officers about the facts within or beyond permissible limits and saves files that contain the
measurement data. Generally, data analysis is non-automated and carried out post factum rather
than in the real-time mode. Systems of continuous monitoring of the technical condition of structures
need improved data monitoring, analysis and storage processes as well as the system of their immediate
retrieval. Besides, the above procedures need a thorough assessment. Obviously, any advancement
of technologies improves data processing (data collection, analysis, storage, presentation);
therefore, issues of monitoring and operation of a sustainable system are to attain a new level.
The information support of the system of continuous monitoring of the technical condition
of structures is viewed from the perspective of Information Flow Processing (IFP) and SCADAsystems.
Contemporary SCADA-systems are widely used to control and manage the industrial environment
of plants and factories.
Peculiarities of the system of continuous monitoring of the technical condition of structures
consist in the fact that this system does not produce any direct influence on the subject under control.
Undoubtedly, certain features of the SCADA system architecture (alert generation, integration
with DBMS) might be considered in the course of development of systems of continuous monitoring
of the technical condition of structures.
Systems of continuous monitoring of the technical condition of structures process basic interconnected
monitoring events and generate more complex ones. Thus, the behavior of structures
exposed to diverse influences may be considered in a new perspective.
It is obvious that systems of continuous monitoring of the technical condition of structures
require a data warehouse responsible for managing complex events, data storage and presentation.
Data warehouses are to be the major component of systems of continuous monitoring of the
technical condition of structures.

DOI: 10.22227/1997-0935.2012.11.283 - 287

References
  1. Krutikov O.V., Blokhina N.S., Soshnikov A.A. Kontrol’ sostoyaniya sooruzheniy pri nepreryvnom monitoringe: nakoplenie i predostavlenie dannykh [Continuous Monitoring within the Framework of Control over the Condition of Structures: Data Accumulation and Presentation]. Promyshlennoe i grazhdanskoe stroitel’stvo [Industrial and Civil Engineering]. 2011, no. 11, pp. 35—37.
  2. Processing Flows of Information: from Data Streams to Complex Event Processing. Available at: http://home.dei.polimi.it/margara/papers/survey.pdf. Date of access: 17.08.2012.
  3. Norenkov I.P. Osnovy avtomatizirovannogo proektirovaniya [Fundamentals of Computer-aided Design]. Moscow, MGTU im. N.E. Baumana publ., 2002, 336 p.
  4. Shvetsov D. Intellektual’nye sistemy khraneniya dannykh v ASU TP [Intellectual Systems of Data Storage in Automatic Control Systems]. Sovremennye tekhnologii avtomatizatsii [Contemporary Automation Technologies]. Moscow, 2011, no. 4, pp. 42—46.
  5. GOST R 53778—2010. Zdaniya i sooruzheniya. Pravila obsledovaniya i monitoringa tekhnicheskogo sostoyaniya. Vved. 25.03.2010. [State Standard of Russia 53778—2010. Buildings and Structures. Rules of Examination and Monitoring of the Technical Condition. Introduced on 25.03.2010]. Moscow, Standartinform publ., 2010, 96 p.
  6. Krutikov O.V. Izmeritel’nye sistemy pri nepreryvnom monitoringe mostov [Measurement Systems in the Event of Continuous Monitoring of Bridges]. Moscow, Institut Giprostroymost Publ., 2008, no. 2, pp. 89—92.
  7. Booch G., Maksimchuk R.A., Engle M.W., Yong B.J., Conallen J., Houston K.A. Ob”ektno-orientirovannyy analiz i proektirovanie s primerami prilozheniy [Object-oriented Analysis and Design with Applications]. Moscow, Vil’yams publ., 2010, 720 p.

Download

FORMATION OF THE STRUCTURE AND COMPOSITION OF THE DATA BANK OF THE SYSTEM OF OPERATIONAL MONITORING OF UNIQUE CONSTRUCTION FACILITIES

Vestnik MGSU 11/2012
  • Soshnikov Aleksandr Aleksandrovich - Moscow State University of Civil Engineering (MGSU) postgraduate student, Department of Information Systems, Technology and Automation in Civil Engineering, Moscow State University of Civil Engineering (MGSU), 26 Yaroslavskoe shosse, Moscow, 129337, Russian Federation; This e-mail address is being protected from spambots. You need JavaScript enabled to view it .
  • Blokhina Nina Sergeevna - Moscow State University of Civil Engineering (MGSU) Candidate of Technical Sciences, Associate Professor, Department of Information Systems, Technology and Automation in Civil Engineering, Moscow State University of Civil Engineering (MGSU), 26 Yaroslavskoe shosse, Moscow, 129337, Russian Federation; This e-mail address is being protected from spambots. You need JavaScript enabled to view it .

Pages 288 - 292

The subject matter of the article is the system of continuous monitoring of the technical condition
of structures and its components. The authors also consider the approach to formation of the
data bank based on the cyclic data warehouse. The cyclic data warehouse (CS) is the basic element
of the data bank. Portions of data that represent continuous measurements taken in the non-stop
mode can be rapidly and efficiently saved into the CS system. CS is a file of a fixed size containing
a header and a sequence of objects. Data is supplied into the CS continuously in the cyclic mode:
incoming new data portions replace the outdated ones. New items are written over the old ones
when the storage time of the latter is expired. Data access in the CS is possible within the period
between the recording and replacement of the item.
The proposed option of the system of continuous monitoring of the technical condition of structures
ensures effective asynchronous data transmission between software modules and servers
and data consistency, because:
there is no more need for any additional data deletion operations;
the fixed size of a CS item allows fast data positioning in the CS file in the course of the random
access.
CS of sufficient size will provide for the possibility of a long delay in data transmission in case
of an abnormal situation occurring in the course of operation of the system of continuous monitoring
of the technical condition of structures.
Long-term operation of cyclic data warehouses has proven their effectiveness. For example,
a cyclic data warehouse is incorporated into a continuous monitoring system of the bridge over the
Matsesta River as the core data bank element.

DOI: 10.22227/1997-0935.2012.11.288 - 292

References
  1. GOST R 8.596—2002 Metrologicheskoe obespechenie izmeritel’nykh sistem. Osnovnye polozheniya. [State Standard R 8.596—2002. Metrological Assurance of Systems of Measurements. Main Provisions]. 15 p.
  2. Krutikov O.V., Blokhina N.S., Soshnikov A.A. Kontrol’ sostoyaniya sooruzheniy pri nepreryvnom monitoringe: nakoplenie i predostavlenie dannykh [Control over Condition of Structures Using Their Continuous Monitoring: Data Accumulation and Presentation]. Promyshlennoe i grazhdanskoe stroitel’stvo [Industrial and Civil Engineering]. 2011, 11, pp. 35—37.
  3. Krutikov O.V. Izmeritel’nye sistemy pri nepreryvnom monitoringe mostov [Measurement Systems of Continuous Bridge Monitoring]. Institut Giprostroymost Publ., 2008, no. 2, pp. 89—92.
  4. How NTFS Works, Microsoft. Available at: http://technet.microsoft.com/en-us/library/cc781134(WS.10).aspx. Date of access: 15.08.2012.
  5. Matveev I.K., Kravchenko E.A., Manokhin A.A., Krutikov O.V. Most pod kontrolem [The Bridge under Control]. Avtomobil’nye dorogi [Motor Roads]. 2005, no. 6, pp. 24—26.
  6. Krutikov O.V., Syrkov A.V., Gershuni I.Sh. Sozdanie sistemy nepreryvnogo monitoringa sostoyaniya vantovogo mosta Fakel cherez r. Shaitanku v Salekharde [Development of the System of Continuous Monitoring of the Condition of Fakel, a Cable Bridge over the Shaitanka River in Salekhard]. Vestnik mostostroeniya [Bridge Building News Bulletin]. 2008, no. 2, pp. 38—42.

Download

Results 1 - 2 of 2