CC BY
110
APPLICATION OF INTELLIGENT BUSINESS SYSTEM WITHIN THE ADMINISTRATIVE INFORMATION SYSTEM FOR COMPLEX SERVICES
1Nenkov Nayden 2Varbanov Stefan
1Faculty of Mathematics and Computer Science, Konstantin Preslavsky University of Shumen, Shumen, Bulgaria 2 Ministry of agriculture and food, Chief Expert IT Directorate Sofia, Bulgaria;
ARTICLE INFO
ABSTRACT
Received 12 April 2016 Accepted 22 April 2016 Published 30 April 2016
KEYWORDS
BI - Business intelligence, agrifood chain,
business intelligence platform-ClickView,
Ministry of agriculture and food, such as Enterprise resource planning (ERP), Customer relationship management (CRM), Supply chain management (SCM)
The document describes the application of BI tool in the practice of E-Government in Bulgaria. The field of application is the agrifood chain in the Republic of Bulgaria. To develop a system for the analysis and reporting of the integrated information system is selected business intelligent QlikView platform.Below are the main advantages and the reasoning upon the choices being made.
© 2016 The Authors.
Introduction. The subject of business are the high profile of the data,whichare generating different operations in the business. They are related to a summary of fundamental processes in its development. The location of the data is in a variety of systems, subsystems as well in different geographic regions. Business intelligence is a set of theories, methodologies, architectures and technologies that transform raw data into meaningful and useful business information (Chaudhuri& etc, 2011). BI does not generate data, but uses the data created by other business applications such as Enterprise resource planning (ERP), Customer relationship management (CRM), Supply chain management (SCM), etc. (Petrova, 2014). Business intelligence is the art of knowing and making business advantage thanks to the low level analysis of the data. Business Intelligence offers solutions in many areas - marketing, customer retention, inventory control, financial modeling and even in public policy in relation to such sensitive issues such as security. It can give you the answers to many questions, such as why competition conquered market shares, which products have the greatest contribution to profit, how to reap more profits, what subdivision of the company is the most effective, how to increase productivity, which are the best and worst customers, where there are losses and why, etc.
Drawing from the information gathered, the repeating patterns regularities and causal links Business intelligent system makes evaluation and analysis of aggregate information, and to produce forecasts for the development of the company (Rausch & etc.,2013).
The main purpose of Business Intelligence is timely provision of quality information for managers,necessary for making management decisions and the formation of effective management impacts (Rao, 2003; Petrova 2013).
The use of such funds in the State administration is time for optimization and enhancement of
its efficiency in complex modern conditions.
The purpose of the article was to show application of BI in an administrative system in particular in the agro management chain in the country.
Exhibition. The main body of the Executive power, which implements policies in the agriculture sector is the Ministry of agriculture and food.They are related to the conduct of national policy for the development of plant and animal production and related activities, carrying out the State policy in the field of grain production, trade and storage of grain and grain processing, production,trade in and use of feed and food safety;management of the activities on the implementation of the common agricultural policy (Cap), food safety Policy and the common fisheries policy (CFP) of the European Union.
For this purpose, it uses about 278 registers, created on the basis of the normative acts (laws, rules, and regulations), data processing functions, access to them and use of them.The structure and the access to the registers are highly decentralized, often stored in them are heterogeneous data, regardless of the presence of the same source data.That significantly disrupts the connectivity between them due to the complete lack of semantic interoperability.In terms of access to the data in the registers contain around 100 business information, and the rest are completely or partially public.
In the development of the registers are used different systems for database management (DBMS), such as the main ones are Oracle, SQL, MySQL, MS Access and Firebird,and nearly one-third of the registers are available in paper form or tabular records of Word or Excel (Petrova& etc., 2014).
This poses a number of problems such as the presence of strong dynamics regarding the content and the need to maintain a portion of the records resulting from frequent changes of the regulations,changing the functions or because they don't do the input data, the presence of heterogeneous information systems developed, the absence of a central level of such a system,obsolete hardware and software, which adds to the risk of disruption of the provision,the absence of own network infrastructure to ensure the security of the transmission center for exchanging data between different geographical units.
Along with hardware and software solutions of those problems is available for system accountability, analysis and based on (BI-Business Intelligence)based on QlikView with radial architecture with Center Ministry - linked in VPN channels with 28 regional structures of the MINISTRY implemented in principle as follows:
Fig.1. Scheme for an analysis of data in the information system
QlikView provides an associative interface for data analysis. QlikView manages associations in different arrays of data at the level of the engine, rather than at the level of the application(Harmsen& etc, 2012).QlikView stores individual tables in your in-memory associative engine (in RAM). Each node of the data in each field is associated with any other node of data, no matter where it is in the whole general scheme. Datasets may present tables with thousands of fields.
Unlike the traditional Business intelligence tools when the user clicks the object from the data in a field, QlikView here does not perform any requests. Instead, all the other fields are automatically
http:/ijite. org/
2(4) April 2016 11
filtered out based on the choice that is made. The selected object from the user turns green. Arrays of the data associated with the selected object analysis are stained in white, and the unrelated information is marked in grey.
Fig. 2. A choice an object by QlikView for analysis
So, when the users look at two different sites of data they can easily understand exactly how they interact with each other. If you want to restrict the data to only one product, country or year, for example, they can see how the rest of the data in their analytical array. They are not restricted of seeing only the effect on the specified query with QlikView, all data is converted in real time, no matter what are the sources. All associations, relative to the total array of data are reserved, answering every question in the business time of its occurrence, without the need for additional processing. The data from all the tables is available in the context always and ready to provide a response on the next business question, whatever it is.
The data in QlikView is stored in simple tabular format and are compressed through what QlikTech (producers of QlikView) called a symbol table similar to the dictionary (the so-called compression dictionary from token — tokens and signs, along with information about where in the table is their issue) - in this way, all the fields in the column have the same length, allowing data stored in arrays, so the address of each line can be computed more easily. They are retrieved through the scans, as the selection occurs in the order in which the records are stored. The stored data is thus in qvdformat. To achieve associative QlikView user interface apply a scheme of data by type of snowflake (snowflake schema), which allows a single road connection between the tables. This imposes some limitations to be made in the database from which we derive the information or in the script for loading in QlikView. For example, if we have two keys by which we want to communicate, they must be of the same name, or if you have two columns with the same name, but the meanings are different things have to change so you can have different names.
To overcome the limitations of the traditional on premise, the Business intelligent systems such as Business Objects, QlikView in-memory stores data in a compressed format with associations set between the performance of data, not relational join operations, as in traditional databases. These associations are derived automatically by the QlikView, during the process of loading data on the basis of matching the column names in the tables. The associative technology, which QlickTech claim is not so much based on the Association, and more recently on the storage of data in the framework of a simple tabular format.
Conclusion. The decision on the choice of QlikView for inclusion in the integrated information system of the Ministry allows the management to build a flexible strategy in the management of resources and prediction of the main advantages of QlikView result from associative architecture that does not need constant reconfiguration, in order to respond to new business issues. This makes QlikView a really quick tool for integration. Because of the architecture of QlikView retains all the associations between the individual fields for users, this leads to easy and intuitive use
of the analyses. QlikView allows users to interact with information that leads to making of better business decisions with good financial results.This creates conditions for smart choices and decisions in this complex and changing environment (Buzko& etc. 2016).
REFERENCES
1. Buzko. I., Dyachenko, Y., Petrova, M., Nenkov, N., Tuleninova, D.&Koeva K. (2016). Artificial Intelligence Technologies in Human Resource Development. The 14th International Conference IT&Management 2016, ISMA, Riga, Latvia. ISSN 1691-2489. Information Technologies, Management and Society, 175-177.
2. Chaudhuri, S., Dayal, U. & Narasayya, V. (August 2011). An Overview Of Business Intelligence Technology. Communications of the ACM 54 (8): 88-98. doi:10.1145/1978542.1978562. Retrieved 26 October 2011.
3. Harmsen, B. & Garcia M. (2012). QlikView 11 for Developers. Packt Publishing. ISBN-10: 1849686068. ISBN-13: 978-1849686068.
4. Rausch, P., Sheta, A. &Ayesh, A.(2013). Business Intelligence and Performance Management: Theory, Systems, and Industrial Applications. Springer Verlag U.K. ISBN 978-1-4471-4865-4.
5. Rao, R. (2003)."From unstructured data to actionable intelligence" Professional5(6):29.Retrieved 2016-03-15 from http://www.ramanarao.com/papers/rao-itpro-2003-11.pdf.
6. Petrova M. (2011). The Bulgarian electronic government in 2011 - challenges and prospects. REVISTA NAJIONALÂ DE DREPT (Publicatie periodica §tiintifico-practica), Universitatea de Stat din Moldova, Chisinau, Moldova, nr.9 (132), 13-18. ISSN 1811-0770.
7. Petrova M. (2012). The research of e-Government of the Bulgarian Public Sector Organizations. Business Competences: Monograph. Edited by I. Spica. [vol.4]. Riga: Scientific institution Business competence centre. 108-121.
8. Petrova, M. (2013). Bestact - software for visualization of digitalized family registers and civil status acts, Journal of Information Engineering and Applications, International Institute for Science. Technology and Education, ISSN 2224-5782. ISSN 2225-0506, Vol 3, No 10.
9. Petrova, M.M., Dolganov, D.N., Zakonnova, L.I. & Verchagina, I.Y. (2014).Awareness of electronic systems and e-government services as a metamotivational process, Journal Federal State Budgetary Educational Institution of Higher Professional Education T.F. Gorbachev Kuzbass State Technical University, ISSN:1999-4125, N: 1 (101), 170-175.Retrieved from http:// elibrary.ru/item.asp?id=21225840 (in Russian).
10. Petrova, M. (2014). Informatization of public in Bulgaria.Ed. FABER. Veliko Tarnovo. (in Bulgarian).
http:/Ajite. org/
2(4) April 2016 13
