AGGREGATOR OF THE UNIVERSITY CONTINGENT QUANTITY

G.P. Kolomoets, D.V. Pashkov

Abstract


Purpose of the article – to represent the solution of the problem of data aggregation from different systems in a single, Web-based application developed with the use of cross-platform open source software. The paper describes the architecture and implementation of university students’ contingent quantity aggregator – the software application that is working with several university information systems (IS). The application has convenient tools contingent quantity calculating and displaying it in summary form and in the form of diagrams. Application is implemented on the Java platform and uses a three-tier client-server architecture with application server. For IS databases access we used JDBC technology, access was organized via servlets’ methods, Spring framework objects (beans) was used as data sources, Feature of these objects is to use the generic method developed by the authors to connect to different IS and universal method that returns data from the database, in the form either of a one-dimensional or twodimensional data collection. So adding a new data source is a simple procedure based on the XML configuration. The system also implements the administrative tools that include management of users and roles, and logging.

Keywords


servlet, Java Server Pages (JSP), database, Spring, Structured Query Language (SQL), JavaScript, jQuery, Web-page

GOST Style Citations






DOI: http://dx.doi.org/10.15588/1607-3274-2012-2-25



Copyright (c) 2014 G.P. Kolomoets, D.V. Pashkov

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Address of the journal editorial office:
Editorial office of the journal «Radio Electronics, Computer Science, Control»,
Zaporizhzhya National Technical University, 
Zhukovskiy street, 64, Zaporizhzhya, 69063, Ukraine. 
Telephone: +38-061-769-82-96 – the Editing and Publishing Department.
E-mail: rvv@zntu.edu.ua

The reference to the journal is obligatory in the cases of complete or partial use of its materials.