You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for Business Intelligence


1 to 20 of 997 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Concepts, 11g Release 1 (11.1)

Business Intelligence

16 Business IntelligenceThis chapter describes some of the basic ideas in business intelligence. This chapter contains the … following topics: Introduction to Data Warehousing and Business Intelligence Overview of Extraction

Database Concepts, 11g Release 1 (11.1)

Introduction to Oracle Database

Overview of Business Intelligence FeaturesThis section describes the following business intelligence features: Data Warehousing Materialized … entire spectrum of business intelligence and advanced analytical applications. Oracle OLAP is fully … Also: Chapter 16, \"Business Intelligence\" for more information about Oracle Data

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

Data Warehouse Architecturesystems designed for a particular line of business. Figure 16-3 illustrates an example where

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

Overview of Bitmap Indexes in Data WarehousingBitmap indexes are widely used in data warehousing environments. The environments typically have large amounts of data and ad hoc queries, but a low level of concurrent DML transactions. For such applications, bitmap indexing provides: Reduced response time for large classes of ad hoc queries Reduced storage requirements compared to other indexing techniques Dramatic performance gains even on hardware

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

SQL for AnalysisOracle has advanced SQL analytical processing capabilities using a family of analytic SQL functions. These analytic functions enable you to calculate: Rankings and percentiles Moving window calculations Lag/lead analysis First/last analysis Linear regression statistics Ranking functions include cumulative distributions, percent rank, and N-tiles. Moving window calculations allow you to find moving

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

Overview of Data Mining, and business planning. As of Oracle Database 11 g, Oracle Data Mining models are implemented as data

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

Ease of Application DevelopmentBy integrating multidimensional objects and analytics into the database, Oracle provides the best of both worlds: the power of multidimensional analysis along with the reliability, availability, security, and scalability of Oracle Database. Oracle OLAP is fully integrated into Oracle Database. At a technical level, this means: The OLAP engine runs within the kernel of Oracle Database Dimensional objects

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

Differences Between Data Warehouse and OLTP Systemscurrent state of each business transaction. Schema Design Data warehouses often use denormalized or

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

SQL for AggregationAggregation is a fundamental part of data warehousing. To improve aggregation performance in your warehouse, Oracle Database provides extensions to the GROUP BY clause to make querying and reporting easier and faster. Some of these extensions enable you to: Aggregate at increasing levels of aggregation, from the most detailed up to a grand total Calculate all possible combinations of aggregations

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

Overview of OLAP CapabilitiesOracle online analytical processing (OLAP) adds power to your SQL applications by providing extensive analytic content and fast query response times. A SQL query interface enables any application to query cubes and dimensions without any knowledge of OLAP.

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

SecurityBecause Oracle OLAP is completely embedded in Oracle Database, there is no administration learning curve as is typically associated with standalone OLAP servers. You can leverage your existing DBA staff, rather than invest in specialized administration skills. One major administrative advantage of Oracle's embedded OLAP technology is automated cube maintenance. With standalone OLAP servers, the burden

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

Reduced CostsBusiness intelligence and analytical applications are dominated by actions such as drilling up and … delivers unmatched performance for typical business intelligence applications. Oracle OLAP queries

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

Characteristics of Data Warehousinganalyze what has occurred. Time Variant In order to discover trends in business, analysts need large

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

Overview of Extraction, Transformation, and Loading (ETL)unified information base for business intelligence. Additionally, the data volume in data warehouse … business analysis. To perform this operation, data from one or more operational systems must be extracted … business situation. The same is true for the time delta between two (logically) identical extractions

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

Change Data Captureefficiently identifies and captures data that has been added to, updated, or removed from Oracle Database relational tables, and makes the change data available for use by applications. Oftentimes, data warehousing involves the extraction and transportation of relational data from one or more source databases into the data warehouse for analysis. Change Data Ca pture quickly identifies and processes

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

Overview of Analytic SQLOracle has introduced many SQL operations for performing analytic operations in the database. These operations include ranking, moving averages, cumulative sums, ratio-to-reports, and period-over-period comparisons. Although some of these calculations were previously possible using SQL, this syntax offers much better performance. This section discusses: SQL for Aggregation SQL for Analysis SQL for

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

Unmatched Performance and ScalabilityWith Oracle OLAP, standard Oracle Database security features are used to secure your multidimensional data. In contrast, with a standalone OLAP server, administrators must manage security twice: once on the relational source system and again on the OLAP server system. Additionally, they must manage the security of data in transit from the relational system to the standalone OLAP system. Unmatched

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

Table CompressionYou can save disk space by compressing heap-organized tables. A typical type of heap-organized table you should consider for table compression is partitioned tables. To reduce disk use and memory use (specifically, the buffer cache), you can store tables and partitioned tables in a compressed format inside the database. This often leads to a better scaleup for read-only operations. Table compression

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

Full Integration of Multidimensional TechnologyApplication Express and Business Intelligence Publisher. See Also: Oracle OLAP User's Guide This section

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

Introduction to Data Warehousing and Business Intelligencebusiness users. This section includes the following topics: Characteristics of Data Warehousing