Discoverer aids business professionals to efficiently "discover" and analyze the exact data they need to make better business decisions. The Discoverer administrator defines the subsets of data that business professionals need to support their decision-making, and presents it to them in a logical and clearly understandable way.
Why Discoverer is Needed ?
Databases are designed by information systems professionals whose primary goal is often transaction efficiency, not ease of use by people who want to examine and analyze the data.
The database designer usually groups data elements into tables to optimize data capture, but rarely is that grouping the best for people who want to view and use the data.
Business analysts need a way to access a relatively small amount of data, and usually just a few specific records essential for their decision-making.
That's where Discoverer comes in.
Discoverer lets the business professional find the data he/she needs, analyze it easily, and get answers to support business decisions. Thus, Discoverer provides an efficient way to retrieve a few select records or small amount of specific data from the database.
Discoverer operates in a client/server and web browser environment and has three main components:
* Discoverer Plus,Discoverer Plus & Discoverer Viewer
* Administration Edition
* End User Layer
Discoverer Plus, Discoverer Plus and Discoverer Viewer
The component for end users comprises the Discoverer Plus (Windows), the Discoverer 4i Plus and Discoverer Viewer; these provide the interface that professionals in a company use on a day-to-day basis to access, view and analyze data.
This component is for the Discoverer administrator; it is the tool you use to design and present the subsets of data called Business Areas
that end users access from the Discoverer Plus.
End User Layer
The metalayer that shields end users from the complexity of the database. Conceptually, the EUL resides between the database dictionary/table definitions and Discoverer. Physically, it comprises a number of database tables and views. The End User Layer (EUL) insulates end users from database complexity and constant change. It provides an intuitive, business-focused view of the database that can be tailored to suit each user or user group. As such, the EUL lets end users focus on business issues instead, not data access issues.
Discoverer Administration Edition builds and maintains the End User Layer. Its design determines how users access and view data. This is where administrators define the business areas used by Discoverer Plus.
Designed for business professionals who do not have a computer programming or database background, Discoverer Plus is an easy-to-use read-only data access tool. It provides logical and intuitive access to information from your organization's relational databases for ad hoc query, analysis, and reporting.
Discoverer Viewer is designed for viewing workbooks created by users of the Windows or Web releases of the Discoverer Plus. Using Oracle Discoverer's easy to use interface via a web browser, you can view database data.
What is End User Layer (EUL) ?
From an operating standpoint, the EUL generates SQL statements on the client and communicates with the database using SQL*Net.
When a user selects objects in the business area, the EUL generates the appropriate SQL statements that define the selections from a table, view, or column.
When a user executes a query, the EUL executes that SQL statement and sends it to the database, which in turn sends the results to the Discoverer Plus interface.
Thus, the end user does not have to understand any SQL to access and retrieve data. It is all handled by the EUL.
What is a Business Area?
A business area is a set of folders containing related information with a common business purpose.
* Meet the specific data needs of the users
* Usually contain data from several different tables or views
* Have tables or views and their associated columns mapped to "folders" and "items" respectively
* Can contain many simple folders and complex folders
* May contain folders from one or more physical databases
* Include conditions, joins, calculations, formatting, hierarchy structures, and other custom features
* May be accessible to one or many user IDs or roles; also, a user ID or role may be granted access to many business areas
* Let users access data, without having to understand the database structure
Business Area Terminology
Summary : Here we have seen a brief explanation about Discoverer , its components and EUL.
Options ABANDON and RESTART adop phase=apply patches=10721639 abandon=yes Used to specify whether to restart the previous run of a...
FS_CLONE Phase It is a stand-alone command used for file system cloning. Standard cloning (using adcfgclone.pl) cannot be used to synch...
Abort Phase If for some reason either the prepare or apply phase failed or gave problems, you can abort the patching cycle. After runnin...
Scenario You have noticed that the on the patch edition there are lot of patches applied. You did the cutover and now customer wants t...
Wish every one a Happy New Year.
Scenario You have been asked to apply a patch and you completed the prepare phase and apply phase. Now customer has given a downtime f...
Cleanup Phase Drops now-redundant columns and other objects which are not required after the cutover phase. It is important that we do n...
Scenario You have been asked to apply a patch and you start with the first phase “PREPARE”. Background Customer has recently...
R12.2 Highlights This release is largely focused on providing new technology stack components, new configuration options, and new syst...
Introduction : The following will guide one to take a backup of ASM Enabled Database using RMAN. The following are the steps involved; ...