Appendix CDatabases and Views

This appendix explains several database concepts. We begin by explaining the difference between traditional schemas, relational schemas, and star schemas. During the discussion on relational schemas, we give you an introduction to the techniques known as normalization and denormalization. Following this, we will take a look at the use of Discoverer with the Oracle E-Business Suite. We explain why views are used and introduce you to Oracle’s Business Views and Oracle Daily Business Intelligence. We then look in depth at Noetix Corporation’s NoetixViews.

Database Schemas

There are two basic schemas or types of database structures that you will encounter when working with Discoverer. These are as follows:

Relational ...

Get Oracle Discoverer 10g Handbook now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.