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 Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Business Intelligence Queries

24 Advanced Business Intelligence QueriesThis chapter illustrates techniques for handling advanced business intelligence queries. We hope to … makes a business intelligence query \"advanced\"? The label is best applied to multistep queries … . This chapter includes: Examples of Business Intelligence Queries

Database Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Business Intelligence Queries

Examples of Business Intelligence QueriesThe queries in this chapter illustrate various business intelligence tasks. The topics of the

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

Transportable TablespacesTransportable tablespaces are the fastest way for moving large volumes of data between two Oracle databases. You can transport tablespaces between different computer architectures and operating systems. Previously, the most scalable data transportation mechanisms relied on moving flat files containing raw data. These mechanisms required that data be unloaded or exported into files from the source

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

External TablesExternal tables let you use external data as a virtual table that can be queried and joined directly and in parallel without requiring the external data to be first loaded in the database. You can then use SQL, PL/SQL, and Java to access the external data. External tables enable the pipelining of the loading phase with the transformation phase. The transformation process can be merged with the loading

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

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

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

Overview of Materialized Views for Data WarehousesOne technique employed in data warehouses to improve performance is the creation of summaries. Summaries are special kinds of aggregate views that improve query execution times by precalculating expensive joins and aggregation operations prior to execution and storing the results in a table in the database. For example, you can create a table to contain the sums of sales by region and by product.

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

How Parallel Execution WorksWhen parallel execution is not used, a single server process performs all necessary processing for the sequential execution of a SQL statement. For example, to perform a full table scan (such as SELECT * FROM emp ), one process performs the entire operation, as illustrated in Figure 16-5. Figure 16-5 Serial Full Table Scan Description of \"Figure 16-5 Serial Full Table Scan \" Figure 16-6 illustrates

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

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

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

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