O'Reilly logo

Oracle Discoverer 10g Handbook by Darlene Armstrong-Smith, Michael Armstrong-Smith

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required