SQLReports - Yet Another Relational Database Reporting System

Sergey Afonin, Alexander Kozitsyn, Ivan Astapov

2014

Abstract

Popular web application frameworks, such as Django, do not provide efficient tools for rapid report development. Specialized reporting software are targeted at visual representation and can generate perfect printed versions of the report. In this paper we describe a minimalistic but quite powerful reporting system developed for a web-based university information system. This reporting system supports zero-programing report development, parametrization of SQL queries, interactive results processing by means of client-side JavaScript libraries, and cross-report references. Main features are similar to well-known reporting systems, such as JasperReports, with more attention to reuse of developed reports, simplicity and interactivity.

References

  1. Bennett, D. and Hu, D. (2013). System for database reporting. US Patent 8,620,952.
  2. Danciu, T. and Chirita, L. (2007). Basic notions of JasperReports. In Danciu, T. and Chirita, L., editors, The Definitive Guide to iReport, pages 15-23. Apress.
  3. Ferraiolo, D. F., Barkley, J. F., and Kuhn, D. R. (1999). A role-based access control model and reference implementation within a corporate intranet. ACM Trans. Inf. Syst. Secur., 2(1):34-64.
  4. Ganz, C. J. (2007). Crystal Reports and BusinessObjects XI. In Pro Crystal Enterprise/Business Objects XI Programming, pages 199-227. Apress.
  5. Giordano, M. and Polese, G. (2013). Visual computermanaged security: A framework for developing access control in enterprise applications. IEEE Software, 30(5):62-69.
  6. Gjorgjevikj, D., Madjarov, G., Chorbev, I., Angelovski, M., Georgiev, M., and Dikovski, B. (2011). ASGRT: Automated report generation system. In Gusev, M. and Mitrevski, P., editors, ICT Innovations 2010, volume 83 of Communications in Computer and Information Science, pages 369-376. Springer Berlin Heidelberg.
  7. Risi, M., Sessa, M., Tucci, M., and Tortora, G. (2014). Code modeling of graph composition for data warehouse report visualization. Knowledge and Data Engineering, IEEE Transactions on, 26(3):563-576.
  8. Tabb, L. and Herrmann, C. (1998). Methods for hypertext reporting in a relational database management system. US Patent 5,787,416.
  9. Warren, W. (2013). Efficient delivery of cross-linked reports with or without live access to a source data repository. US Patent 8,521,841.
  10. Yeh, A. and Kundu, A. (2006). Method and system for a reporting information services architecture. US Patent 7,051,038.
Download


Paper Citation


in Harvard Style

Afonin S., Kozitsyn A. and Astapov I. (2014). SQLReports - Yet Another Relational Database Reporting System . In Proceedings of the 9th International Conference on Software Engineering and Applications - Volume 1: ICSOFT-EA, (ICSOFT 2014) ISBN 978-989-758-036-9, pages 529-534. DOI: 10.5220/0005114205290534


in Bibtex Style

@conference{icsoft-ea14,
author={Sergey Afonin and Alexander Kozitsyn and Ivan Astapov},
title={SQLReports - Yet Another Relational Database Reporting System},
booktitle={Proceedings of the 9th International Conference on Software Engineering and Applications - Volume 1: ICSOFT-EA, (ICSOFT 2014)},
year={2014},
pages={529-534},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005114205290534},
isbn={978-989-758-036-9},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 9th International Conference on Software Engineering and Applications - Volume 1: ICSOFT-EA, (ICSOFT 2014)
TI - SQLReports - Yet Another Relational Database Reporting System
SN - 978-989-758-036-9
AU - Afonin S.
AU - Kozitsyn A.
AU - Astapov I.
PY - 2014
SP - 529
EP - 534
DO - 10.5220/0005114205290534