Applied Mechanics and Materials ISSN: 1662-7482, Vol. 770, pp 651-655 doi:10.4028/www.scientific.net/AMM.770.651 © 2015 Trans Tech Publications, Switzerland Submitted: 2015-03-13 Accepted: 2015-03-18 Online: 2015-06-22 Using of Information Systems for Socio-Economic Management Applications in Mechanical Engineering Enterprises Bleikher Oksana1, a, Kvesko Svetlana2, b 1 Tomsk Polytechnic University, 30, Lenin Avenue, Tomsk, 634050, Russia 2 Tomsk State University, 36, Lenin Avenue, Tomsk, 634050, Russia a email: [email protected], bemail: [email protected] Keywords: mechanical engineering, information systems, modeling. Abstract. The paper summarizes an experience of information system implementation in mechanical engineering industry of Russia Federation. Methodological spaces of information supply in mechanical engineering enterprise have been approved. Effectiveness of creation and usage of non-unified information systems for information gathering about local socio-economic issues has been estimated. Conjointly with the friendly user interface individually tuned for each stakeholder, and realized on the base widely used webserver Apache 2.2, using programming language PHP, as well as using database engine mysql 5.5 with report import into unified format like SPSS or Excel, the system confirms its own usefulness. Introduction Mechanical engineering is aggressive branch of modern Russia. Rapid economic expansion of Mechanical engineering industry is one of the top priority government tasks. At present the Government program of Russian Federation “Development of industry and increasing its competitiveness” (Federation published No.328 Decree of the Government of RF of 15th April 2014). On the base of both international and Russian investigations the program sets substantial reference on development of Mechanical engineering industry as well as indicators of profit. At the same time the government might control of Mechanical engineering industry processes indirectly only, because government functions had decreased since market economy has been devised. In that way, only owners and board of directors can effectively solve the problems of Mechanical engineering enterprises. Historically there was situation when economic cooperation has been destroyed and now we understood that repairing of economic relations between partners of post-Soviet republics rather more complicated then create new economic and industry cooperation independent on previous relationship in this area. Every mechanical engineering enterprise represents a conglomerate of complicated functional, territorial, financial cooperative process which required integral control for effective management of the enterprise. Besides a decomposition of economic-industry problem has been formed historically there are issues related to inability to pay, embedding of international standards of product release, involvement investors, search for creativity, supply state-of-art equipment as well as training of the personnel. Complexity of decision making includes the fact that the Mechanical engineering branch is one of the most industrial productions affecting on other industrial and economic activities and reflects on scientific and technology state, and defense capacity of the state. Developing Countries have Mechanical engineering participating in 25-35% Gross Domestic Product and corresponding population quantity occupied in this area. In order to effectively put the problem for both small enterprise or big industrial complex, it’s required to provide comprehensive information about production, economic, personnel, marketing processes onto the all administrative and production departments . Versatile and widespread solution is using of information technologies . In modern design flows, on the base analysis of scientific technical literature, we might tell about several groups of information systems using for management applications in Mechanical engineering industry of Russian Federation. Preliminary basis of classification is dedication of information system. It includes given below factors: All rights reserved. No part of contents of this paper may be reproduced or transmitted in any form or by any means without the written permission of Trans Tech Publications, www.scientific.net. (#102730934, University of New South Wales, Sydney, Australia-27/10/17,09:33:41) 652 Urgent Problems of Up-to-Date Mechanical Engineering production constructing, automation of production process, life-time management of production, accounting system and planning of economic financial processes. Also the basis might include integration of system functions such as production management, production economic, corporative systems. Besides, these systems may be classified by software technologies. It depends on using client-server architecture with ability for integration with widely used industry DBMS, support a distributed data processing, module based building from operation-independent units with extension by open source standards (API, COM+, CORBA etc), providing a lot of technologies Internet/Intranet. Thus, the information system for Mechanical engineering branch can be formulated on the base three features: dedication, coverage of processes and information technologies usage [4, 5]. Nevertheless at this stage in order to ensure a normal management and development of Mechanical engineering enterprises, it ought to solve the class of local socio-economic tasks, which are not supplied with information resources still. These tasks can be divided on automatic-anonymous investigations are directed to gather information for solving local conflicts in single department or distributed Mechanical engineering complex or enterprise; local survey of product consumers; survey of experts for improvement of product quality; local survey of directors of single sector of Mechanical engineering branch; non-unified kind of investigations for public authority of different levels with wide spatial survey. For instance, local information systems can be used for solution of conflict of interest in distribution network; survey of medicine experts regarding improvement of consumer properties of equipment for “beauty industry”; local anonymous survey of directors of Mechanical engineering enterprises in case of monitoring of conditions for development Mechanical engineering enterprises in local region with public authority participation. Hypothetically these systems will be essential in distribution because even insignificant relocation of percentage of product purchasing can increase merchandising and make work more effectively. By using the medicine equipment, the medicine experts will do the best fix the requirement to equipment during their working hours and send requirements quickly by the internet. Directors sometimes need the anonymous principle at problem formulation in public authority area. Public authority needs the anonymous principle for gathering true information from consumers of government services for control of person accountable. A conflict resolver quickly can help to personnel to solve the conflict because it operatively got information about conflict situation. Using local information systems provide within shortest possible period of time, with minimum cost, at wide spatial coverage to gather and elaborate the opinions of concerned people for making solution of socio-economic problem. During approbation of local information system for investigation of business conditions in Tomsk region with support of the Department of the Tomsk region, the total time of creation, distribution at corporative portal, getting and analysis of gathered data, amounted 30 working days. Among them the time of creation was 12 days, distribution time was 2 days, the time for gathering data was 13 days and time for data analysis was 3 days. Sampling includes 803 people. Spatial coverage was 316,9 sq.km, the length from north to south – about 600 km, from west to east – 780 km. On the territory there are 140 municipalities of the region. The quantity of qualified features has been analyzed for business development is 107. For building these systems it required specialists one from IT, one from sociology and one profile specialist depending on investigation area. For example, for conflict solving the profile specialist will be ‘conflict resolver’; for creation government program for improvement conditions for Mechanical engineering industry will be the official from public or federal authority; for the enterprise survey it’s required the director. The role of profile specialist consists of problem formulation; the role of sociologist is preparing survey/polling or questionnaire; the role of IT specialist is building of friendly and stable software application for gathering required information. The final data analysis has to be discussed later in collaboration with the sociologist, IT specialist and profile specialist. Historically there isn’t common practice of creation and implementation of information system for solution local socio-economic problem at Mechanical engineering enterprises . While constructing the prototype of this kind system it should base on the samples of systems aimed at Applied Mechanics and Materials Vol. 770 653 investigation of socio-economic processes which have a long-time approbation (at least 10 years); All-Russian coverage of objects under investigation, based on modern information technologies, have been adapted to Russian socio-economic investigations. During latest 20 years, there is AllRussian system has been widely used, so-called Russian Public Opinion Research Center (RPORC). Information system RPORC represents a complex of information technologies which has ability to input and store incoming data, using variables of different types, getting reports in different forms like tables, diagrams, charts, as well as unified modules for computation and presentation data about socio-economic processes and objects. Presumably we can orientate functionally on RPORC, but research of information technologies for implementation required taking into account specific of Mechanical engineering branch. We will pay attention on this fact below in the paper. During research of information technology there were criteria for data gathering: accessibility, user friendly interface, efficiency, and scalability. The accessibility is parameter for integration the system under different platforms (for instance desktop PC or mobile device). This feature allows effectively use the system for all stakeholders participating in the investigation. Simplicity has been reached due to user friendly interface. The efficiency concludes in obtaining and data analysis as soon as possible after survey. At last, the system should be easy modified in case similar kind of investigation. For instance, when spatial or objects conditions got changed. According to the requirements there was given below PC platform has been configured for system implementation. The system has been realized on webserver Apache 2.2. Its main advantage is open-source solution, work on different OS platforms: Microsoft Windows, Linux, BSD, Mac OS, Novell NetWare, BeOS; flexibility configuration, world widespread and database support. This webserver is used on the most of host-providers, so it can be easy deployed on any system. In case of site model selection (static or dynamic), during 2012 year, at Tomsk Polytechnic University’ portal, the experimental site has been started. It used for gathering a socio-economic data for business development conditions of Tomsk enterprises. It’s known there are two kind of sites: static or dynamic. The static one allows the data modifying only on creation the page stage. This variant is not acceptable because the socio-economic investigations of business and organizations contain a lot of research objects and at least 2 categories of users (by functions: researchers and respondents). Creation of dynamic site allows separate the data between different user categories by content and interfacing. For the respondents there will be questions, for the researchers there will be the interface with getting reports [7,8,9]. In the design technologies to create a dynamic website have been used. This made possible to share information packets for different types of users on the content and interface. For the respondents these were questions, for researchers - an interface for designing reports. To create a dynamic web site was applied the programming language PHP 5.3.x, which is "de facto" the basis for the development of web applications for web server Apache . The programming language PHP has five important characteristics: • academicism; • simplicity; • efficiency; • security; • flexibility. There is one more feature that makes PHP particularly attractive: it is free. Moreover, it is distributed as an Open Source. Academicism of PHP language is that it will be familiar to programmers working in different areas and continuing to develop the created information system in the coming years. A particularly important feature of this programming language is for monitoring, because this process involves, on the one hand, the monotony in the research objects and indicators, on the other hand, from year to year requires an expanding the modules for the calculation of indicators. Thus, the use of PHP can ensure the continuity of the system among the different groups of developers. 654 Urgent Problems of Up-to-Date Mechanical Engineering Simplicity of PHP consists in the fact that its scripts are corresponding to the volume and complexity of the task and may consist as of 10 000 and one line. The efficiency of PHP is the most important factor when programming for multi-user environments such as information systems for socio-economic research. PHP allows for a flexible and efficient security both at the system level and at the application level, which is extremely important to obtain reliable information on research. One of the obvious features of PHP is the ability to work with different browsers and devices, as users of the information system may have very different technical capabilities . Thus, PHP is currently the most attractive option for the development of information systems implemented in Mechanical engineering industry applications. For the collection and storage of data was used MySQL - a free database management system (DBMS) because it is an effective solution for small and medium-sized applications, a part of the server WAMP, AppServ, LAMP and portable build servers Denver, XAMPP. MySQL database is flexible because it provides support for many types of tables: users can select as table type MyISAM, supporting full-text search, and table InnoDB, supporting transactions at the level of individual records [12, 13]. So, the use of the database engine MySQL 5.5. seems to be optimal. The choice is related to the fact that MySQL is available as a plugin to a web server apache, and easy adaptation to fit the requirements of the system, in particular, the import of the reports in the desired data formats, particularly in table format, Excel (xls) can be realized. During the implementation of systems for sociological research the developer faces the problem of the translation of the input data, often expressed in the form of qualitative parameter, in the data, which can then be adequately analyzed. For example, when conducting sociological research face to face (researcher-subject), a sociologist himself assesses the response to the question, thus limiting the range of possible options in accordance with the specified requirements for further analysis results. In the case of "online" research, on the one hand, it is necessary to prevent the "narrowing" answers, on the other hand, get a response, which can lead to an analytical mind as to produce a final report, and for the further conduct of sociological research. In this paper, to solve this problem have been selected criteria which helped to correlated every question with a variety of options with different weight indication for further analytics. As a result, in the course of the study the respondent is asked to answer a series of questions in the most convenient form, while the researcher receives a report in the form template which he formed preparing research questions. Summary So, as a result of the study it can be concluded that the most effective solution for Mechanical engineering enterprises is the use of non-unified information system, taking into account the regulatory and legal definition of Mechanical engineering enterprises, the territorial division of the research groups objects with user-friendly interface for each stakeholder, implemented as a site on the web server Apache 2.2., in the programming language PHP, using the database engine MySQL 5.5. with import statements in any unified settlement system type SPSS, Excel. Settlements indicators recommended in the harmonized system. Applied Mechanics and Materials Vol. 770 655 References  H.-E. Lin, E.F. Mcdonough, Cognitive Frames, Learning Mechanisms, and Innovation Ambidexterity, J. Journal of Product Innovation Management (2014) 170–188.  H. Fidlerova, J. Prachar, M. Horvathova, Inventory optimization and modeling techniques applied within manufacturing company, Modeling and Computation in Engineering III Proceedings of the 3rd International Conference on Modeling and Computation in Engineering, CMCE (2014) 209-214.  H.J. Wang, H.Y. Li, K.M. Sun, L.S. Yi, Design and implementation of an indoor environment monitoring system in smart home system, 2013 International Conference on Mechanical Engineering and Applied Mechanics, MEAM (2013) 160-165.  T.V. Alexeyva, Y. V. Amiridi, V. V. Dik, Information-analytical system, Synergy, Moscow, 2013.  N.A. Krinitsky, G.A. Mironov, G.D. Frolov, Automated Information Systems, Home Editorial physical and mathematical literature publishing house "Science", Moscow, 2014.  V.V. Tsyganov, S.N. Bukharin Information warfare in business and politics. Theory and Methodology, Academic Project, 2013.  J. Keating, The art of creating web-sites, TTI DC, Moscow, 2012.  I. Kuznetsov, I. Simdyanov, PHP. The practice of creating Web-sites, BHV-Petersburg, Moscow, 2012.  S. Mitchell, 5 projects of Web-sites from the album to the store, HT Press, Moscow, 2013.  S. Hawkins, Essentials Apache for Web Professionals, Prentice Hall PTR, 2001.  B. Savage, PHP Playbook, Marco Tabini & Associates, Inc, 2011.  B. Timothy, E. Naramore, J. Gerner, Y. Le Scouarnec, J. Stolz, Beginning PHP 6, Apache, MySQL 6 Web Development, Wrox, 2009.  N. Prohorenok, Development of Web-sites using Perl and MySQL, BHV-Petersburg, Moscow, 2009.