The creation of an information-analytical system (IAS) of monitoring students’ activities is considered. The models of monitoring, the realization of data integration with the use of SQL Server Integration Services are formed. The logical models of modules and a general model of the data warehouse are shown. The results of the system use are presented.
monitoring, students’ activity, data warehouse, OLAP, data integration, de-normalization
1. School Management: Dictionary-Reference Book of the Head of Educational Institution / А.М.Moiseyev, А.А.Khvan, А.Е.Kapto, А.V.Lorensov, О.М.Moiseyeva, О.G.Khomeriky, L.G.Osetrova; under the editorship of А.М.Moiseyev, А.А.Khvan. - М.: Ped. S-ty of Russia, 2005. - pp. 320.
2. Belkin, А.S. Fundamentals of Pedagogical Techniques: Short Explanatory Dictionary / А.S.Belkin. - Ekaterinburg: USTU, 1995. - pp. 22.
3. Andreev, V.I. Pedagogics: training course for creative selfdevelopment / V.I.Andreev. - Kazan: Center of Innovation Techniques, 2000. - pp. 608.
4. Dragunovskaya, О.I. Use of students automated monitoring system as a factor of education process improvement / О.I.Dragunovskaya, V.О.Zhurin // Intelligent Potential of the XXI-st Century: steps of perception: Proceedings of the ХXI-st Inter. Youth Sc.-Pract. Conf. - Novosibirsk: Publishing House of CRSC, 2014. - pp. 102-105.
5. Barsegyan, А.А. Methods and Models of Data Analysis: OLAP и Data Mining / А.А.Barsegyan. - SPb.: BHV-Petersburg, 2009. - pp. 336.
6. Textbook on Services SSIS. Creation of Simple ETL-Package. - URL: http://msdn.microsoft.com/ru-ru/library/ms169917.aspx.
7. Spirly, E. Corporate Data Warehouse. Planning, Development and realization / E.Spirly. - SPb.: Williams, 2001. - Vol. 1. - pp. 400.
8. Kopeliovich, D.I. Automated system of monitoring college students’ progress using OLAP technology / D.I.Kopeliovich // Problems and Prospects of Edu-cation Development in Russia: Proceedings of the XI-th Inter. Sc.-Pract. Conf. - Novosibirsk: Pub-lishing House of NSTU, 2011. - pp. 152-156.
9. Kopeliovich, D.I. Students’ data analysis for carrying out of careerguidance work among schoolchieldren / D.I.Kopeliovich, О.I.Dragunovskaya // Information society formation as a factor of innovation development of Russian economy: Proceedings of the Inter. Sc.-Pract. Conf. - Bryansk: Kursiv, 2013. - pp. 338-341.
10. Dragunovskaya, О.I. Use of students’ activity au-tomated monitoring to identify personal qualities in people for works in IT-sphere. / О.I.Dragunovskaya, V.О.Zhurin // Science Youth - 2014: Proceedings of the Inter. Stud. Sc.-Pract. Conf. - Chernigov: ChSIEU, 2014. - pp. 140-141.
11. KopeliovichКопелиович, D.I. Integrated platform for creation of information-analytical systems of monitoring and systems for decisionmaking support / D.I. Kopeliovich, О.I.Dragunovskaya, V.О.Zhurin // Michail-Archangel Readings: Pro-ceedings of the Inter. Sc.-Pract. Conf. - Rybnitsa, 2014. - pp. 353 - 355.
