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

Operational management system for warehouse logistics of metal trading companies

Vestnik MGSU 6/2014
  • Khayrullin Rustam Zinnatullovich - Moscow State University of Civil Engineering (MGSU) Doctor of Physical and Mathematical Sciences, senior scientific worker, Professor, Department of Higher Mathematics, 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 172-178

Logistics is an effective tool in business management. Metal trading business is a part of metal promotion chain from producer to consumer. It's designed to serve as a link connecting the interests of steel producers and end users. We should account for the specifics warehousing trading. The specificity of warehouse metal trading consists primarily in the fact that the purchase is made in large lots, and the sale - in medium and small parties. Loading and unloading of cars and trucks is produced by overhead cranes. Some part of the purchased goods are shipped in relatively large lots without presales preparation. Another part of the goods undergoes presale preparation. Indoor and outdoor warehouses are used with the address storage system. In the process of prolonged storage the metal rusts. Some part of the goods is subjected to final completion (cutting, welding, coloration) in service centers and small factories, usually located at the warehouse. The quantity of simultaneously shipped cars, and the quantity of the loader workers brigade can reach few dozens. So it is necessary to control the loading workers, to coordinate and monitor the performance of loading and unloading operations, to make the daily analysis of their work, to evaluate the warehouse operations as a whole. There is a need to manage and control movement of cars and trucks on the warehouse territory to reduce storage and transport costs and improve customer service. ERP-systems and WMS-systems, which are widely used, do not cover fully the functions and processes of the warehouse trading, and do not effectively manage all logistics processes. In this paper the specialized software is proposed. The software is intended for operational logistics management in warehouse metal products trading. The basic functions and processes of metal warehouse trading are described. The effectiveness indices for logistics processes and key effective indicators of warehouse trading are proposed. The developed software permit taking into account the described above specifics of metal products warehouse trading. The software can be easily integrated with ERP-systems and WMS-systems. The software contains the module of consolidation, which allows evaluating and comparing the quality of the logistics operations in a group of companies. The software was implemented and effectively used in a large metal trading company, which has few dozens of warehouses. Some results of mathematical simulation are presented.

DOI: 10.22227/1997-0935.2014.6.172-178

References
  1. Sergeev V.I. Logistika v biznese [Logistics in Business]. Moscow, Infra-M Publ., 2007, 608 p.
  2. Shol' E.I. Informatsionnoe obespechenie logisticheskikh tekhnologiy [Information Support of Logistic Technologies]. RISK: resursy, informatsiya, snabzhenie, konkurentsiya [RISK: Resources, Information, Supply, Competition]. 2006, no. 1, pp. 12—18.
  3. Kaplan R., Norton D. The Balanced Scorecard: Translating Strategy into Action. Harvard Business Review Press, 1 edition, 1996, 336 p.
  4. Vetluzhskih I.S. Strategicheskaya karta, sistemnyy podkhod i KPI: Instrumenty dlya rukovoditeley [Strategic Map, System Approach and KPI. Tools for Managers]. Moscow, Alpina Business Books, Alpina Publishers, 2008, 208 p.
  5. Mashchenko V.E. Sistemnoe korporativnoe upravlenie [System Corporate Management]. Moscow, Sirin Publ., 2003, 251 p.
  6. Abdikeev N.M., Dan'ko T.P., Il'demenov S.V., Kiselev A.D. Reinzhiniring biznesprotsessov [Reengineering of Business Processes]. Moscow, Eksmo Publ., 2007, 592 p.
  7. Kharitonova N.A., Kharitonova E.N., Sarana E.Yu. K voprosu o formirovanii kompleksnoy sistemy sbytovogo logisticheskogo kontrollinga na promyshlennom predpriyatii [On the Question of a Complex System Formation for Logistics Controlling Distribution of Industrial Company]. Nauchno-tekhnicheskie vedomosti SPbGPU: Ekonomicheskie nauki [Scientific and Technical News of St.Petersburg State Polytechnical University]. 2009, no. 1, pp. 190—194.
  8. Oleynik P.P. Osnovnye standarty korporativnykh informatsionnykh sistem: MPS, MRP, MRP-II, ERP, CSRP, ERP-II [Basic Standards of Corporate Information Systems: MPS, MRP, MRP-II, ERP, CSRP, ERP-II ]. Moscow, LAMBERT Publ., 2011, 88 p.
  9. O'Leary D. ERP-sistemy: vybor, vnedrenie, ekspluataciya. Sovremennoe planirovanie i upravlenie resursami predpriyatiya [ERP-systems: Selection, Implementation, Operation. Modern Enterprise Resource Planning]. Moscow, Vershina Publ., 2004, 272 p.
  10. Gayfulin B.N., Obukhov I.A. Avtomatizirovannye sistemy upravleniya predpriyatiyami standarta ERP/MRP-II [Automated Enterprise Management Systems of the Standard ERP / MRP-II]. Moscow, Bogorodskiy pechatnik, 2001, 104 p.
  11. Pаyterkin S.V., Oladov N.A., Isaev D.V. Tochno vovremja dlja Rossii. Praktika primenenija ERP-sistem [Just in time for Russia. Practice of application of ERP-systems]. Moscow, Alpina publisher, 2003, 368 p.
  12. Trapulenis R. Struktura i osobennosti sistemy SOLVO.WMS [Structure and Features of the System SOLVO.WMS]. Korporativnye sistemy [Corporate Systems]. 2006, no. 6, pp. 55—58.
  13. Trapulenis R. Sistema SOLVO.WMS [SOLVO.WMS System]. Uslugi i tseny [Prices and services]. 2008, no. 18, pp. 40—42.
  14. Filipenko I.A. Vybor PO dlya avtomatizatsii upravleniya [Choosing Software for Management Automation]. Korporativnye sistemy [Corporate Systems]. 2001, no. 3, pp. 21—22 .
  15. Khayrullin R.Z. Tekhnologiya issledovaniya upravlyaemykh sistem [Research Technology for Controlled Systems]. Gornyy informatsionno-analiticheskiy byulleten' [Mining Information and Analytical Bulletin]. 1999, no. 4, pp. 111—113.

Download

AUTOCAD IN THE OPERATIONAL MANAGEMENT OF THE CONSTRUCTION SITE

Vestnik MGSU 4/2016
  • Tsareva Marina Vladimirovna - Moscow State University of Civil Engineering (National Research University) (MGSU) Associate Professor, Department of Descriptive Geometry and Graphics, Moscow State University of Civil Engineering (National Research University) (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 140-147

Operational management of the construction is usually based on information analysis systems, which are aimed at the monitoring of working schedule and volumes as consistent with predicated schedules. The result of such systems’ operation is traditional information graphics (diagrams, charts, etc.), which provides idea on the current state of the construction site and deviations from the planned settings. The author considers the visualization technology of construction of objects using an image of the situation on the AutoCAD drawings, converted into an interactive format. The article focuses on imperfections of the existing technologies of information support of the managers. The creation of unified IT platform is offered on the basis of CAD for creating an integrated information storage and visualization of the environment using electronic drawings and diagrams. Using interactive methods it is possible to illustrate the condition of almost any part of the construction project using these drawings and diagrams. E-drawings contain the basic information resources - estimates, plans, sections, specifications, technology, construction, etc. necessary for the calculation of indicators. The author proved that implementation of visualization is most efficient in case of electronic drawings in 3D format.

DOI: 10.22227/1997-0935.2016.4.140-147

References
  1. Tsareva M.V. Situatsionnaya sistema dlya investitsionnogo proekta [Situational system for investment project]. Ob”edinennyy nauchnyy zhurnal. Ekonomika i finansy [Economics and Finance — Scientific Journal]. 2004, no. 27. (In Russian)
  2. Codd E.F., Codd S.B., Salley C.T. Providing OLAP (On-Line Analytical Processing) to User-Analysts : An IT mandate. Technical report. 1993. Available at: http://www.minet.uni-jena.de/dbis/lehre/ss2005/sem_dwh/lit/Cod93.pdf.
  3. Bazhin I.I. Informatsionnye sistemy menedzhmenta [Information Management Systems]. Moscow, GU VShE Publ., 2000, 687 p. (In Russian)
  4. Bowman W.J. Graphic Communication. 1968, John Wiley & Sons Inc, 222 p.
  5. Voronin V.A. Formirovanie integrirovannykh sub''ektov khozyaystvovaniya v stroitel’stve s primeneniem metoda kognitivnogo modelirovaniya [Formation of Integrated Business Entities in the Construction Using the Method of Cognitive Modeling]. Vestnik Universiteta (GUU) [University Bulletin (State University of Management)]. 2010, no. 7, pp. 102—110. (In Russian)
  6. Grachev V., Samodelov V. Primenenie sovremennykh tekhnologiy upravleniya v sovershenstvovanii deyatel’nosti predpriyatiy [The Use of Modern Technologies to Improve Management of Enterprises]. Finansovaya gazeta [Financial Newspaper]. 2007, no. 31. (In Russian)
  7. Zotov V.A. Problema razrabotki kognitivnykh sredstv vizualizatsii ekonomicheskoy informatsii v dinamike [Development Problem of Cognitive Visualization Tools of Economic Information in the Dynamics]. Informatsionnye tekhnologii v XXI veke : materialy nauchno-prakticheskoy konferentsii k 100-letiyu REA [Information Technologies on the 21st Century : Materials of Science and Practice Conference to 100 Anniversary of PRUE]. Moscow, Izdatel’stvo Rossiyskoy ekonomicheskoy akademii Publ., 2007. (In Russian)
  8. Kaplan R.S., Norton D.P. Strategy Maps: Converting Intangible Assets into Tangible Outcomes. Harvard Business Review Press, 1 edition, 2004, 454 p.
  9. Campbell A., Sommers K.L. Strategic Synergy (Management Readers). Butterworth-Heinemann, 1992, 240 p.
  10. Mescon M.H., Albert M., Khedouri F. Management: Individual and Organizational Effectiveness. Harpercollins College Div; 2 Sub edition, 1985, 756 p.
  11. Ponomareva N.I. Osobennosti formirovaniya uchetno-analiticheskoy sistemy v stroitel’nykh organizatsiyakh [Peculiarities of Formation of Accounting and Analytical Systems in Construction Companies]. Uspekhi sovremennogo estestvoznaniya [Success of Modern Natural Science]. 2008, no. 7, pp. 72—75. (In Russian)
  12. Trakhtengerts E.A. Komp’yuternaya podderzhka peregovorov pri soglasovanii upravlencheskikh resheniy [Computer Support of Negotiations When Discussing Administrative Decisions]. Moscow, Sinteg Publ., 2003, 272 p. (Seriya «Sistemy i problemy upravleniya» [Series: Systems and Problems of Management]) (In Russian)
  13. Walsh C. Key Management Ratios. T Press, 4 edition, 2009, 408 p.
  14. Edel’steyn G. Intellektual’nye sredstva analiza, interpretatsii i predstavleniya dannykh v informatsionnykh khranilishchakh [Intelligent Analysis, Interpretation and Presentation of Data in the Information Storage]. ComputerWeek-Moscow. 1996, no. 16, pp. 32—33. (In Russian)
  15. Tel’noy V.I., Tsareva M.V. Ispol’zovanie informatsionnykh tekhnologiy pri prepodavanii komp’yuternoy grafiki [Use of Information Technologies in Teaching Computer Graphics]. Vestnik MGSU [Proceedings of Moscow State University of Civil Engineering]. 2012, no. 6, pp. 161—165. (In Russian)
  16. Bachurina S.S., Resin V.I., Traynev V.A. Strategiya korporativnogo menedzhmenta v gradostroitel’stve [The Strategy of Corporate Management in Urban Planning]. Moscow, Dashkov i Ko Publ., 2010, 512 p. (In Russian)
  17. Drucker P.F. Management Challenges for the 21st Century. HarperBusiness, 1st edition, 224 p.
  18. Tel’noy V.I., Tsareva M.V., Rychkova A.V. Razrabotka trekhmernykh modeley pri provedenii zanyatiy po komp’yuternoy grafike [Development of Three-Dimensional Models in Conducting Classes in Computer Graphics]. Integratsiya, partnerstvo i innovatsii v stroitel’noy nauke i obrazovanii : sbornik materialov Mezhdunarodnoy nauchnoy konferentsii (12—13 noyabrya 2014 g., Moskva) [Integration, Partnership and Innovations in Construction Science and Education : Collection of the Materials of the International Scientific Conference (November 12—13, 2014, Moscow)]. Moscow, MGSU Publ., 2015, pp. 332—335. (In Russian)

Download

Results 1 - 2 of 2