DD Models for Reports Building

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.

Authors:

• Ljerka Hrženjak-Šego
• Željko Polić
• Zdravka Aljinović

Keywords:

• Data Definition diagram
• Server Model Diagram
• system modelling
• reports.

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.