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.
There are two basic schemas or types of database structures that you will encounter when working with Discoverer. These are as follows: