Skip to Main Content
Oracle Essentials, 5th Edition
book

Oracle Essentials, 5th Edition

by Rick Greenwald, Robert Stackowiak, Jonathan Stern
September 2013
Intermediate to advanced content levelIntermediate to advanced
432 pages
14h 42m
English
O'Reilly Media, Inc.
Content preview from Oracle Essentials, 5th Edition

Chapter 10. Oracle Data Warehousing and Business Intelligence

A database is general purpose software and it serves as the basis of a platform that meets a variety of needs, including:

Recording and storing transactional data

Reliably storing data and protecting each user’s data from the effects of other users’ changes

Retrieving data for ad hoc questions (queries) and historical reporting

Providing a consistent and persistent view of the data

Analyzing data

Summarizing and comparing data, detecting trends and data relationships, and forecasting

The last two capabilities are most often associated with a data warehouse, part of an infrastructure that provides business intelligence used in strategic and tactical business management of the corporation or organization. Such solutions expose valuable business information embedded in an organization’s data stores—essentially creating additional value from existing data resources. Because of this, data warehousing is the focus of a great deal of interest from business constituencies.

Data warehousing and business intelligence solutions are widely deployed and continue to be a focus for further development in many organizations. There is a very simple reason behind this: such projects and solutions are seen as core to making business decisions, providing a return on investment that can be grasped by the business community.

This trend is not new. Oracle began adding data warehousing features to Oracle7 in the early 1990s. Ever since, additional features ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern
Oracle in a Nutshell

Oracle in a Nutshell

Rick Greenwald, David C. Kreines
Oracle PL/SQL Programming, 5th Edition

Oracle PL/SQL Programming, 5th Edition

Steven Feuerstein, Bill Pribyl

Publisher Resources

ISBN: 9781449343156Errata Page