вход по аккаунту


код для вставкиСкачать
Applied Mechanics and Materials
ISSN: 1662-7482, Vol. 770, pp 651-655
© 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
Tomsk Polytechnic University, 30, Lenin Avenue, Tomsk, 634050, Russia
Tomsk State University, 36, Lenin Avenue, Tomsk, 634050, Russia
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.
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 [1]. Versatile and widespread
solution is using of information technologies [2]. 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, (#102730934, University of New South Wales, Sydney, Australia-27/10/17,09:33:41)
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, 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 [6]. While
constructing the prototype of this kind system it should base on the samples of systems aimed at
Applied Mechanics and Materials Vol. 770
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 [10].
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
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 [11].
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.
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
[1] H.-E. Lin, E.F. Mcdonough, Cognitive Frames, Learning Mechanisms, and Innovation
Ambidexterity, J. Journal of Product Innovation Management (2014) 170–188.
[2] 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.
[3] 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.
[4] T.V. Alexeyva, Y. V. Amiridi, V. V. Dik, Information-analytical system, Synergy, Moscow,
[5] N.A. Krinitsky, G.A. Mironov, G.D. Frolov, Automated Information Systems, Home Editorial
physical and mathematical literature publishing house "Science", Moscow, 2014.
[6] V.V. Tsyganov, S.N. Bukharin Information warfare in business and politics. Theory and
Methodology, Academic Project, 2013.
[7] J. Keating, The art of creating web-sites, TTI DC, Moscow, 2012.
[8] I. Kuznetsov, I. Simdyanov, PHP. The practice of creating Web-sites, BHV-Petersburg,
Moscow, 2012.
[9] S. Mitchell, 5 projects of Web-sites from the album to the store, HT Press, Moscow, 2013.
[10] S. Hawkins, Essentials Apache for Web Professionals, Prentice Hall PTR, 2001.
[11] B. Savage, PHP Playbook, Marco Tabini & Associates, Inc, 2011.
[12] B. Timothy, E. Naramore, J. Gerner, Y. Le Scouarnec, J. Stolz, Beginning PHP 6, Apache,
MySQL 6 Web Development, Wrox, 2009.
[13] N. Prohorenok, Development of Web-sites using Perl and MySQL, BHV-Petersburg, Moscow,
Без категории
Размер файла
189 Кб
scientific, 770, 2famm, www, net, 651
Пожаловаться на содержимое документа