DD Models for Reports Building

Authors: Ljerka Hrženjak-Šego, Željko Polić, Zdravka Aljinović

Abstract:

In general, reports are a form of representing data in such way that user gets the information he needs. They can be built in various ways, from the simplest (“select from") to the most complex ones (results derived from different sources/tables with complex formulas applied). Furthermore, rules of calculations could be written as a program hard code or built in the database to be used by dynamic code. This paper will introduce two types of reports, defined in the DB structure. The main goal is to manage calculations in optimal way, keeping maintenance of reports as simple and smooth as possible.

Keywords: Data Definition diagram, Server Model Diagram, system modelling, reports.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1335368

References:

[1] Billings, C. &M. Rapid Development with Oracle CASE. Addison- Wesley Publishing Company, England, 1993.
[2] Hrženjak-┼áego, Lj. and ┼áego, B. Two ER Models for Optimal Storing Of Reports. Proceedings of the 5th. International Symposium on Operational Research SOR'99, 1999 Sep 30.- Oct 2., Preddvor, Slovenia, pp. 179-183.
[3] Hrženjak-┼áego, Lj. and Polić, Ž. ER Models For Producing Reports, 25th International Conference Information Technology Interfaces ITI-03, 2003 June 16-19, Cavtat / Dubrovnik, Croatia, Poster Abstracts, pp. 17-18.
[4] Hrženjak-┼áego, Lj., Polić, Ž. and ┼áego, B. ER Models For Optimal Building Of Reports, Proceedings of the 7th. International Symposium on Operational Research (SOR'03), Pod─ìetrtek, Slovenia, September 24- 26, 2003, pp. 223-228.
[5] ***. Help Topics of Oracle Design Editor V6.0.3.10.0 Oracle Corporation.